[Home] [Help]
PACKAGE: APPS.OCM_CREDIT_REQUEST_UPDATE_PUB
Source
1 PACKAGE OCM_CREDIT_REQUEST_UPDATE_PUB AS
2 /*$Header: OCMUPCRS.pls 120.6 2006/06/30 22:10:21 bsarkar noship $ */
3 /*#
4 * This API updates a credit request based on the credit request ID. When
5 * a credit request is updated, its corresponding case folder is refreshed
6 * to reflect current data.
7 * @rep:scope public
8 * @rep:doccd 120ocmug.pdf Credit Management API User Notes, Oracle Credit Management User Guide
9 * @rep:product OCM
10 * @rep:lifecycle active
11 * @rep:displayname Update Credit Request
12 * @rep:category BUSINESS_ENTITY AR_CREDIT_REQUEST
13 */
14
15 /*#
16 * Use this procedure to update a credit request.
17 * @rep:scope public
18 * @rep:lifecycle active
19 * @rep:displayname Update Credit Request
20 */
21
22 TYPE credit_request_rec IS RECORD (
23 application_number VARCHAR2(30) DEFAULT NULL,
24 application_date DATE DEFAULT NULL,
25 requestor_type VARCHAR2(30) DEFAULT NULL,
26 requestor_id NUMBER DEFAULT NULL,
27 review_type VARCHAR2(30) DEFAULT NULL,
28 credit_classification VARCHAR2(30) DEFAULT NULL,
29 requested_amount NUMBER DEFAULT NULL,
30 requested_currency VARCHAR2(30) DEFAULT NULL,
31 trx_amount NUMBER DEFAULT NULL,
32 trx_currency VARCHAR2(30) DEFAULT NULL,
33 credit_type VARCHAR2(30) DEFAULT NULL,
34 check_list_id NUMBER DEFAULT NULL,
35 credit_analyst_id NUMBER DEFAULT NULL,
36 term_length NUMBER DEFAULT NULL,
37 credit_check_rule_id NUMBER DEFAULT NULL,
38 credit_request_status VARCHAR2(30) DEFAULT NULL,
39 party_id NUMBER DEFAULT NULL,
40 cust_account_id NUMBER DEFAULT NULL,
41 cust_acct_site_id NUMBER DEFAULT NULL,
42 site_use_id NUMBER DEFAULT NULL,
43 contact_party_id NUMBER DEFAULT NULL,
44 notes VARCHAR2(2000) DEFAULT NULL,
45 source_org_id NUMBER DEFAULT NULL,
46 source_user_id NUMBER DEFAULT NULL,
47 source_resp_id NUMBER DEFAULT NULL,
48 source_resp_appln_id NUMBER DEFAULT NULL,
49 source_security_group_id NUMBER DEFAULT NULL,
50 source_name VARCHAR2(30) DEFAULT NULL,
51 source_column1 VARCHAR2(150) DEFAULT NULL,
52 source_column2 VARCHAR2(150) DEFAULT NULL,
53 source_column3 VARCHAR2(150) DEFAULT NULL,
54 credit_request_id NUMBER DEFAULT NULL,
55 review_cycle VARCHAR2(30) DEFAULT NULL,
56 case_folder_number VARCHAR2(30) DEFAULT NULL,
57 score_model_id NUMBER DEFAULT NULL,
58 case_folder_id NUMBER DEFAULT NULL,
59 stock_exchange VARCHAR2(50) DEFAULT NULL,
60 current_stock_price NUMBER DEFAULT NULL,
61 stock_currency VARCHAR2(30) DEFAULT NULL,
62 market_capitalization NUMBER DEFAULT NULL,
63 market_cap_monetary_unit VARCHAR2(15) DEFAULT NULL,
64 pending_litigations NUMBER DEFAULT NULL,
65 bond_rating VARCHAR2(30) DEFAULT NULL,
66 legal_entity_name VARCHAR2(240) DEFAULT NULL,
67 entity_type VARCHAR2(30) DEFAULT NULL,
68 recommendation_name VARCHAR2(30) DEFAULT NULL
69 );
70
71 PROCEDURE UPDATE_CREDIT_REQUEST (
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
74 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_validation_level IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_credit_request_rec IN credit_request_rec );
80
81 PROCEDURE GET_CREDIT_REQUEST_REC (
82 p_credit_request_id IN NUMBER,
83 p_return_status OUT NOCOPY VARCHAR2,
84 p_error_msg OUT NOCOPY VARCHAR2,
85 p_credit_request_rec OUT NOCOPY credit_request_rec );
86 /*#
87 * Use this procedure to update a credit request status.
88 * @rep:scope public
89 * @rep:lifecycle active
90 * @rep:displayname Update Credit Request Status
91 */
92
93 PROCEDURE update_credit_request_status (
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
96 p_commit IN VARCHAR2,
97 p_validation_level IN VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_credit_request_id IN NUMBER,
102 p_credit_request_status IN VARCHAR2 DEFAULT 'SUBMIT');
103
104
105
106 END OCM_CREDIT_REQUEST_UPDATE_PUB;