[Home] [Help]
PACKAGE: APPS.IEX_DUNNINGS_PKG
Source
1 PACKAGE iex_dunnings_pkg AS
2 /* $Header: iextduns.pls 120.3.12000000.2 2007/03/14 14:35:15 gnramasa ship $ */
3
4 PROCEDURE insert_row(
5 px_rowid IN OUT NOCOPY VARCHAR2
6 , px_dunning_id IN OUT NOCOPY NUMBER
7 , p_template_id NUMBER
8 , p_callback_yn VARCHAR2
9 , p_callback_date DATE
10 , p_campaign_sched_id NUMBER
11 , p_status VARCHAR2
12 , p_delinquency_id NUMBER
13 , p_ffm_request_id NUMBER
14 , p_xml_request_id NUMBER
15 , p_xml_template_id NUMBER
16 , p_object_id NUMBER
17 , p_object_type VARCHAR2
18 , p_dunning_object_id NUMBER
19 , p_dunning_level VARCHAR2
20 , p_dunning_method VARCHAR2
21 , p_amount_due_remaining NUMBER
22 , p_currency_code VARCHAR2
23 , p_last_update_date DATE
24 , p_last_updated_by NUMBER
25 , p_creation_date DATE
26 , p_created_by NUMBER
27 , p_last_update_login NUMBER
28 , p_request_id NUMBER
29 , p_financial_charge NUMBER default null
30 , p_letter_name VARCHAR2 default null
31 , p_interest_amt NUMBER default null
32 , p_dunning_plan_id NUMBER default null
33 , p_contact_destination varchar2 default null
34 , p_contact_party_id NUMBER default null
35 , p_delivery_status varchar2
36 , p_parent_dunning_id number
37 );
38
39 PROCEDURE delete_row(
40 p_dunning_id NUMBER
41 );
42
43 PROCEDURE update_row(
44 p_rowid VARCHAR2
45 , p_dunning_id NUMBER
46 , p_template_id NUMBER
47 , p_callback_yn VARCHAR2
48 , p_callback_date DATE
49 , p_campaign_sched_id NUMBER
50 , p_status VARCHAR2
51 , p_delinquency_id NUMBER
52 , p_ffm_request_id NUMBER
53 , p_xml_request_id NUMBER
54 , p_xml_template_id NUMBER
55 , p_object_id NUMBER
56 , p_object_type VARCHAR2
57 , p_dunning_object_id NUMBER
58 , p_dunning_level VARCHAR2
59 , p_dunning_method VARCHAR2
60 , p_amount_due_remaining NUMBER
61 , p_currency_code VARCHAR2
62 , p_last_update_date DATE
63 , p_last_updated_by NUMBER
64 , p_creation_date DATE
65 , p_created_by NUMBER
66 , p_last_update_login NUMBER
67 , p_request_id NUMBER
68 , p_financial_charge NUMBER default null
69 , p_letter_name VARCHAR2 default null
70 , p_interest_amt NUMBER default null
71 , p_dunning_plan_id NUMBER default null
72 , p_contact_destination varchar2 default null
73 , p_contact_party_id NUMBER default null
74 , p_delivery_status varchar2
75 , p_parent_dunning_id number
76 );
77
78
79 PROCEDURE lock_row(
80 p_rowid VARCHAR2
81 , p_dunning_id NUMBER
82 , p_template_id NUMBER
83 , p_callback_yn VARCHAR2
84 , p_callback_date DATE
85 , p_campaign_sched_id NUMBER
86 , p_status VARCHAR2
87 , p_delinquency_id NUMBER
88 , p_ffm_request_id NUMBER
89 , p_xml_request_id NUMBER
90 , p_xml_template_id NUMBER
91 , p_object_id NUMBER
92 , p_object_type VARCHAR2
93 , p_dunning_object_id NUMBER
94 , p_dunning_level VARCHAR2
95 , p_dunning_method VARCHAR2
96 , p_amount_due_remaining NUMBER
97 , p_currency_code VARCHAR2
98 , p_last_update_date DATE
99 , p_last_updated_by NUMBER
100 , p_creation_date DATE
101 , p_created_by NUMBER
102 , p_last_update_login NUMBER
103 , p_financial_charge NUMBER default null
104 , p_letter_name VARCHAR2 default null
105 , p_interest_amt NUMBER default null
106 , p_dunning_plan_id NUMBER default null
107 , p_contact_destination varchar2 default null
108 , p_contact_party_id NUMBER default null
109 );
110
111
112
113 END iex_dunnings_pkg;