CREATE OR REPLACE Package Pkg_cust_risk is
--Author:administrator
--CREATED:2014/4/22 10:00:27
--PURPOSE: Customer risk
Vi_errorcode M_log. Errorcode%type DEFAULT 0; --Numeric Type exception code
Vs_errortext M_log. Errortext%type DEFAULT NULL; --Character Type exception description
Vs_owner M_log. Owner%type DEFAULT NULL; --Character type stored procedure call user
Vs_procedure_name M_log. Procedure_name%type DEFAULT NULL; --character type stored procedure name
Vs_statr_tm DATE; ---log start time
Vs_end_tm DATE; ---log end time
--Table 1 partⅰ-Credit Conditions
PROCEDURE sp_cdk_b1000 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 1 partⅱ-group Customer Credit separation
PROCEDURE sp_cdk_b1001 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 1 partⅲ-loan Details
PROCEDURE sp_cdk_b1002 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 1 part iv-holding corporate bond details
PROCEDURE sp_cdk_b1003 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 1 partⅴ-holding Enterprise equity details
PROCEDURE sp_cdk_b1004 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 1 partⅵ-off-sheet business details
PROCEDURE sp_cdk_b1005 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 1 partⅶ-customer service details
PROCEDURE sp_cdk_b1006 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 2 Partⅰ: The basic situation of the group
PROCEDURE sp_cdk_b2000 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 2 Partⅱ: Senior executives and key associates information
PROCEDURE sp_cdk_b2010 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 2 partⅱ-executives and key affiliates-Passport information
PROCEDURE sp_cdk_b2011 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 2 partⅱ-executives and important affiliates-other documents
PROCEDURE sp_cdk_b2012 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 2 partⅲ-member list
PROCEDURE sp_cdk_b2020 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 2 part iv-Actual Control person
PROCEDURE sp_cdk_b2030 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 2 partⅴ-related group information
PROCEDURE sp_cdk_b2040 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 3 partⅰ-basic situation of single legal person
PROCEDURE sp_cdk_b3000 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 3 partⅱ-legal representative, senior executive and important related person information
PROCEDURE sp_cdk_b3010 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 3 partⅱ-legal representative, senior executive and important related person-passport information
PROCEDURE sp_cdk_b3011 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 3 partⅱ-legal representative, senior executive and important related person information-other documents
PROCEDURE sp_cdk_b3012 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 3 partⅲ-important shareholders and major affiliated enterprises
PROCEDURE sp_cdk_b3020 (is_date in VARCHAR2, oi_retcode out INTEGER);
--table 4, the statistics on the security of public clients
PROCEDURE sp_cdk_b4000 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 5, individual loan default status statistics
PROCEDURE sp_cdk_b5000 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 5, individual loan defaults-common debtor
PROCEDURE sp_cdk_b5001 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 5, personal loan default statistics-other types of documents
PROCEDURE sp_cdk_b5002 (is_date in VARCHAR2, oi_retcode out INTEGER);
--Table 6, individual default loan guarantee situation statistics
PROCEDURE sp_cdk_b6000 (is_date in VARCHAR2, oi_retcode out INTEGER);
END Pkg_cust_risk;
Oracle stored procedure returns result set