1 PACKAGE AR_CMGT_CREDIT_REQUEST_API AS
2 /* $Header: ARCMCRAS.pls 120.18 2006/08/31 21:23:24 bsarkar noship $ */
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
27 PROCEDURE create_credit_request
28 ( p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
30 p_commit IN VARCHAR2,
31 p_validation_level IN VARCHAR2,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_application_number IN VARCHAR2,
36 p_application_date IN DATE,
37 p_requestor_type IN VARCHAR2,
38 p_requestor_id IN NUMBER, --this happens to be the HR person_id of
39 --the requestor
40 p_review_type IN VARCHAR2,
41 p_credit_classification IN VARCHAR2,
42 p_requested_amount IN NUMBER,
43 p_requested_currency IN VARCHAR2,
44 p_trx_amount IN NUMBER,
45 p_trx_currency IN VARCHAR2,
46 p_credit_type IN VARCHAR2,
47 p_term_length IN NUMBER, --the unit is no of months
48 p_credit_check_rule_id IN NUMBER, --this is the credit check rule from the OM
49 p_credit_request_status IN VARCHAR2, --SAVE or FINISH
50 p_party_id IN NUMBER,
51 p_cust_account_id IN NUMBER,
52 p_cust_acct_site_id IN NUMBER,
53 p_site_use_id IN NUMBER,
54 p_contact_party_id IN NUMBER, --this is the party_id of the pseudo party
55 --created becoz of the contact relationship.
56 p_notes IN VARCHAR2,
57 p_source_org_id IN NUMBER,
58 p_source_user_id IN NUMBER,
59 p_source_resp_id IN NUMBER,
60 p_source_appln_id IN NUMBER,
61 p_source_security_group_id IN NUMBER,
62 p_source_name IN VARCHAR2,
63 p_source_column1 IN VARCHAR2,
64 p_source_column2 IN VARCHAR2,
65 p_source_column3 IN VARCHAR2,
66 p_credit_request_id OUT NOCOPY NUMBER,
67 p_review_cycle IN VARCHAR2 DEFAULT NULL,
68 p_case_folder_number IN VARCHAR2 DEFAULT NULL,
69 p_score_model_id IN NUMBER DEFAULT NULL,
70 p_parent_credit_request_id IN NUMBER DEFAULT NULL,
71 p_credit_request_type IN VARCHAR2 DEFAULT NULL,
72 p_reco IN VARCHAR2 DEFAULT NULL
73 );
74
75 FUNCTION is_Credit_Management_Installed RETURN BOOLEAN;
76
77 /*#
78 * Returns application number for a given credit request ID.
79 * @param p_credit_request_id Credit Request Id
80 * @return Application Number
81 * @rep:scope public
82 * @rep:lifecycle active
83 * @rep:displayname Get Application Number
84 */
85
86 FUNCTION get_application_number
87 ( p_credit_request_id IN NUMBER)
88 RETURN VARCHAR2;
89
90 END AR_CMGT_CREDIT_REQUEST_API; -- Package spec