1 PACKAGE IEX_PROFILE AUTHID CURRENT_USER AS
2 /* $Header: iexrcnts.pls 120.3 2005/01/24 20:44:57 jypark ship $ */
3
4 TYPE Profile_Rec is RECORD(
5 Total_Promises Number ,
6 Broken_Promises Number ,
7 Open_Promises Number,
8 Installments_Due Number ,
9 Unpaid_Installments Number ,
10 OnTime_Installments Number ,
11 Late_Installments Number ,
12 Credit_Limit_AMT NUMBER,
13 Credit_Limit_AMT_CURR VARCHAR2(15),
14 Credit_Status VARCHAR2(80),
15 Credit_Rating VARCHAR2(80),
16 Collector_Name VARCHAR2(360),
17 Include_Dunning VARCHAR2(80),
18 Last_Outcome JTF_IH_OUTCOMES_VL.Short_Description%TYPE,
19 last_contact_date Date ,
20 last_Contacted_By JTF_RS_RESOURCE_EXTNS_VL.Resource_Name%TYPE,
21 Last_Result JTF_IH_RESULTS_VL.Short_Description%TYPE
22 ) ;
23
24 -- Ref cursors to select the History and Activity Data
25 TYPE PROFILE_CUR IS REF CURSOR ;
26
27 -- Ref cursors to select the Payment info
28 TYPE LAST_PAYMENT_CUR IS REF CURSOR ;
29
30
31 PROCEDURE GET_PROFILE_INFO
32 (p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2,
34 p_commit IN VARCHAR2,
35 p_validation_level IN NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_calling_app IN VARCHAR2,
40 p_filter_mode IN VARCHAR2 ,
41 p_Party_id IN Number,
42 p_cust_account_id IN Number,
43 p_delinquency_id IN NUMBER, -- added by jypark
44 p_customer_site_use_id IN NUMBER, -- added by jypark for Bill-to
45 p_using_paying_rel IN VARCHAR2, -- added by jypark for Paying Relationship
46 x_profile_rec OUT NOCOPY Profile_Rec) ;
47
48 End IEX_PROFILE ;