1 PACKAGE AR_CMGT_CREDIT_REQUEST_API AUTHID CURRENT_USER AS
2 /* $Header: ARCMCRAS.pls 120.18.12010000.2 2009/11/18 23:51:45 rravikir ship $ */
3 /*#
4 * Creates a credit request for initiating a credit review for a party,
5 * account, or account site. After the credit request is created with
6 * minimal validations, an asynchronous workflow is initiated that
7 * starts processing the credit request.
8 * @rep:scope public
9 * @rep:doccd 120ocmug.pdf Credit Management API User Notes, Oracle Credit Management User Guide
10 * @rep:product OCM
11 * @rep:lifecycle active
12 * @rep:displayname Create Credit Request
13 * @rep:category BUSINESS_ENTITY AR_CREDIT_REQUEST
14 */
15
16 /*#
17 * Use this procedure to create a credit request for initiating a credit review
18 * for a party, account, or account site.
19 * @rep:scope public
20 * @rep:lifecycle active
21 * @rep:displayname Create Credit Request
22 */
23 /* bug4414414 : Added paramters p_parent_credit_request_id and p_credit_request_type
24 */
25
26 TYPE hold_reason_rec_type IS TABLE OF
27 fnd_new_messages.message_name%TYPE;
28
29 PROCEDURE create_credit_request
30 ( p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
32 p_commit IN VARCHAR2,
33 p_validation_level IN VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_application_number IN VARCHAR2,
38 p_application_date IN DATE,
39 p_requestor_type IN VARCHAR2,
40 p_requestor_id IN NUMBER, --this happens to be the HR person_id of
41 --the requestor
42 p_review_type IN VARCHAR2,
43 p_credit_classification IN VARCHAR2,
44 p_requested_amount IN NUMBER,
45 p_requested_currency IN VARCHAR2,
46 p_trx_amount IN NUMBER,
47 p_trx_currency IN VARCHAR2,
48 p_credit_type IN VARCHAR2,
49 p_term_length IN NUMBER, --the unit is no of months
50 p_credit_check_rule_id IN NUMBER, --this is the credit check rule from the OM
51 p_credit_request_status IN VARCHAR2, --SAVE or FINISH
52 p_party_id IN NUMBER,
53 p_cust_account_id IN NUMBER,
54 p_cust_acct_site_id IN NUMBER,
55 p_site_use_id IN NUMBER,
56 p_contact_party_id IN NUMBER, --this is the party_id of the pseudo party
57 --created becoz of the contact relationship.
58 p_notes IN VARCHAR2,
59 p_source_org_id IN NUMBER,
60 p_source_user_id IN NUMBER,
61 p_source_resp_id IN NUMBER,
62 p_source_appln_id IN NUMBER,
63 p_source_security_group_id IN NUMBER,
64 p_source_name IN VARCHAR2,
65 p_source_column1 IN VARCHAR2,
66 p_source_column2 IN VARCHAR2,
67 p_source_column3 IN VARCHAR2,
68 p_credit_request_id OUT NOCOPY NUMBER,
69 p_review_cycle IN VARCHAR2 DEFAULT NULL,
70 p_case_folder_number IN VARCHAR2 DEFAULT NULL,
71 p_score_model_id IN NUMBER DEFAULT NULL,
72 p_parent_credit_request_id IN NUMBER DEFAULT NULL,
73 p_credit_request_type IN VARCHAR2 DEFAULT NULL,
74 p_reco IN VARCHAR2 DEFAULT NULL
75 );
76
77 /* Overloaded for hold_reason_rec parameter */
78 PROCEDURE create_credit_request
79 ( p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
81 p_commit IN VARCHAR2,
82 p_validation_level IN VARCHAR2,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_application_number IN VARCHAR2,
87 p_application_date IN DATE,
88 p_requestor_type IN VARCHAR2,
89 p_requestor_id IN NUMBER, --this happens to be the HR person_id of
90 --the requestor
91 p_review_type IN VARCHAR2,
92 p_credit_classification IN VARCHAR2,
93 p_requested_amount IN NUMBER,
94 p_requested_currency IN VARCHAR2,
95 p_trx_amount IN NUMBER,
96 p_trx_currency IN VARCHAR2,
97 p_credit_type IN VARCHAR2,
98 p_term_length IN NUMBER, --the unit is no of months
99 p_credit_check_rule_id IN NUMBER, --this is the credit check rule from the OM
100 p_credit_request_status IN VARCHAR2, --SAVE or FINISH
101 p_party_id IN NUMBER,
102 p_cust_account_id IN NUMBER,
103 p_cust_acct_site_id IN NUMBER,
104 p_site_use_id IN NUMBER,
105 p_contact_party_id IN NUMBER, --this is the party_id of the pseudo party
106 --created becoz of the contact relationship.
107 p_notes IN VARCHAR2,
108 p_source_org_id IN NUMBER,
109 p_source_user_id IN NUMBER,
110 p_source_resp_id IN NUMBER,
111 p_source_appln_id IN NUMBER,
112 p_source_security_group_id IN NUMBER,
113 p_source_name IN VARCHAR2,
114 p_source_column1 IN VARCHAR2,
115 p_source_column2 IN VARCHAR2,
116 p_source_column3 IN VARCHAR2,
117 p_credit_request_id OUT NOCOPY NUMBER,
118 p_review_cycle IN VARCHAR2 DEFAULT NULL,
119 p_case_folder_number IN VARCHAR2 DEFAULT NULL,
120 p_score_model_id IN NUMBER DEFAULT NULL,
121 p_parent_credit_request_id IN NUMBER DEFAULT NULL,
122 p_credit_request_type IN VARCHAR2 DEFAULT NULL,
123 p_reco IN VARCHAR2 DEFAULT NULL,
124 p_hold_reason_rec IN hold_reason_rec_type
125 );
126
127 FUNCTION is_Credit_Management_Installed RETURN BOOLEAN;
128
129 /*#
130 * Returns application number for a given credit request ID.
131 * @param p_credit_request_id Credit Request Id
132 * @return Application Number
133 * @rep:scope public
134 * @rep:lifecycle active
135 * @rep:displayname Get Application Number
136 */
137
138 FUNCTION get_application_number
139 ( p_credit_request_id IN NUMBER)
140 RETURN VARCHAR2;
141
142 END AR_CMGT_CREDIT_REQUEST_API; -- Package spec