PACKAGE: APPS.OCM_ADD_DATA_POINTS

Source

1 Package OCM_ADD_DATA_POINTS AS
2 /*  $Header: OCMGTDPS.pls 120.4 2005/12/30 20:55:18 bsarkar noship $ */
3 /*=======================================================================+
4  |  Declare PUBLIC Data Types and Variables
5  +=======================================================================*/
6 
7 TYPE OCM_ADD_DP_PARAM_REC_TYPE IS RECORD
8      (
9         p_credit_request_id               NUMBER,
10         p_case_folder_id                  NUMBER,
11         p_application_number              VARCHAR2(30),
12         p_TRX_CURRENCY                    VARCHAR2(30),
13         p_LIMIT_CURRENCY                  VARCHAR2(30),
14         p_party_id                        NUMBER,
15         p_cust_account_id                 NUMBER,
16         p_site_use_id                     NUMBER,
17         p_requestor_id                    NUMBER,
18         p_credit_analyst_id               NUMBER,
19         p_review_type                     VARCHAR2(30),
20         p_credit_classification           VARCHAR2(30),
21         p_check_list_id                   NUMBER,
22         p_score_model_id                  NUMBER,
23         p_credit_type                     VARCHAR2(30),
24         p_source_name                     VARCHAR2(30),
25         p_source_user_id                  NUMBER,
26         p_source_resp_id                  NUMBER,
27         p_source_resp_appln_id            NUMBER,
28         p_source_security_group_id        NUMBER,
29         p_source_org_id                   NUMBER,
30         p_source_column1                  VARCHAR2(150),
31         p_source_column2                  VARCHAR2(150),
32         p_source_column3                  VARCHAR2(150),
33         p_data_point_application_id       NUMBER,
34         p_data_point_id                   NUMBER ,
35         p_parent_data_point_id            NUMBER,
36         p_data_point_value                VARCHAR2(240),
37         p_exchange_rate_type			  VARCHAR2(30),
38         p_data_point_value_id			  NUMBER,
39         p_return_data_type                VARCHAR2(30),
40         p_return_date_format              VARCHAR2(60)
41     );
42 
43 
44 pg_ocm_add_dp_param_rec OCM_ADD_DP_PARAM_REC_TYPE;
45 
46 TYPE ocm_dp_values_rec_type IS RECORD
47      (
48         p_data_point_id                   NUMBER,
49         p_parent_data_point_id            NUMBER,
50         p_sequence_number                 NUMBER,
51         p_data_point_value                VARCHAR2(240),
52         p_data_point_value_id			  NUMBER
53      );
54 
55 TYPE ocm_dp_values_tbl_type IS TABLE OF ocm_dp_values_rec_type
56                         INDEX BY BINARY_INTEGER;
57 
58 pg_ocm_dp_values_tbl OCM_DP_VALUES_TBL_TYPE;
59 
60 PROCEDURE GetAdditionalDataPoints (
61 	p_credit_request_id		IN		NUMBER,
62 	p_case_folder_id		IN		NUMBER,
63 	p_mode					IN		VARCHAR2 DEFAULT 'CREATE',
64 	p_error_msg				OUT NOCOPY VARCHAR2,
65 	p_resultout				OUT	NOCOPY VARCHAR2 );
66 
67 END OCM_ADD_DATA_POINTS;