[Home] [Help]
PACKAGE: APPS.IEX_DUNNINGS_PKG
Source
1 PACKAGE iex_dunnings_pkg AUTHID CURRENT_USER AS
2 /* $Header: iextduns.pls 120.9 2011/06/14 06:32:42 snuthala 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 , p_dunning_mode varchar2 -- added by gnramasa for bug 8489610 14-May-09
38 , p_confirmation_mode varchar2 -- added by gnramasa for bug 8489610 14-May-09
39 , p_org_id number
40 , p_ag_dn_xref_id number default null
41 , p_correspondence_date date default trunc(sysdate)
42 , p_addt_xml_template_id number default null --added for bug 9970624 gnramasa 4th Aug 10
43 , p_addt_delivery_status varchar2 default null --added for bug 9970624 gnramasa 4th Aug 10
44 ,p_as_of_date date default trunc(sysdate)
45 );
46
47 PROCEDURE delete_row(
48 p_dunning_id NUMBER
49 );
50
51 PROCEDURE update_row(
52 p_rowid VARCHAR2
53 , p_dunning_id NUMBER
54 , p_template_id NUMBER
55 , p_callback_yn VARCHAR2
56 , p_callback_date DATE
57 , p_campaign_sched_id NUMBER
58 , p_status VARCHAR2
59 , p_delinquency_id NUMBER
60 , p_ffm_request_id NUMBER
61 , p_xml_request_id NUMBER
62 , p_xml_template_id NUMBER
63 , p_object_id NUMBER
64 , p_object_type VARCHAR2
65 , p_dunning_object_id NUMBER
66 , p_dunning_level VARCHAR2
67 , p_dunning_method VARCHAR2
68 , p_amount_due_remaining NUMBER
69 , p_currency_code VARCHAR2
70 , p_last_update_date DATE
71 , p_last_updated_by NUMBER
72 , p_creation_date DATE
73 , p_created_by NUMBER
74 , p_last_update_login NUMBER
75 , p_request_id NUMBER
76 , p_financial_charge NUMBER default null
77 , p_letter_name VARCHAR2 default null
78 , p_interest_amt NUMBER default null
79 , p_dunning_plan_id NUMBER default null
80 , p_contact_destination varchar2 default null
81 , p_contact_party_id NUMBER default null
82 , p_delivery_status varchar2
83 , p_parent_dunning_id number
84 , p_dunning_mode varchar2 -- added by gnramasa for bug 8489610 14-May-09
85 , p_confirmation_mode varchar2 -- added by gnramasa for bug 8489610 14-May-09
86 , p_ag_dn_xref_id number default null
87 , p_correspondence_date date default trunc(sysdate)
88 , p_addt_xml_template_id number default null --added for bug 9970624 gnramasa 4th Aug 10
89 , p_addt_delivery_status varchar2 default null --added for bug 9970624 gnramasa 4th Aug 10
90 );
91
92
93 PROCEDURE lock_row(
94 p_rowid VARCHAR2
95 , p_dunning_id NUMBER
96 , p_template_id NUMBER
97 , p_callback_yn VARCHAR2
98 , p_callback_date DATE
99 , p_campaign_sched_id NUMBER
100 , p_status VARCHAR2
101 , p_delinquency_id NUMBER
102 , p_ffm_request_id NUMBER
103 , p_xml_request_id NUMBER
104 , p_xml_template_id NUMBER
105 , p_object_id NUMBER
106 , p_object_type VARCHAR2
107 , p_dunning_object_id NUMBER
108 , p_dunning_level VARCHAR2
109 , p_dunning_method VARCHAR2
110 , p_amount_due_remaining NUMBER
111 , p_currency_code VARCHAR2
112 , p_last_update_date DATE
113 , p_last_updated_by NUMBER
114 , p_creation_date DATE
115 , p_created_by NUMBER
116 , p_last_update_login NUMBER
117 , p_financial_charge NUMBER default null
118 , p_letter_name VARCHAR2 default null
119 , p_interest_amt NUMBER default null
120 , p_dunning_plan_id NUMBER default null
121 , p_contact_destination varchar2 default null
122 , p_contact_party_id NUMBER default null
123 );
124
125 PROCEDURE insert_Staged_Dunning_row(
126 px_rowid IN OUT NOCOPY VARCHAR2
127 , px_dunning_trx_id IN OUT NOCOPY NUMBER
128 , p_dunning_id NUMBER
129 , p_cust_trx_id NUMBER default null
130 , p_payment_schedule_id NUMBER
131 , p_ag_dn_xref_id NUMBER default null --added for bug 9970624 gnramasa 4th Aug 10
132 , p_stage_number NUMBER default null
133 , p_created_by NUMBER
134 , p_creation_date DATE
135 , p_last_updated_by NUMBER
136 , p_last_update_date DATE
137 , p_last_update_login NUMBER
138 , p_object_version_number NUMBER
139 );
140
141 /*
142 PROCEDURE update_Staged_Dunning_row(
143 p_rowid VARCHAR2
144 , p_dunning_id NUMBER
145 , p_template_id NUMBER
146 , p_callback_yn VARCHAR2
147 , p_callback_date DATE
148 , p_campaign_sched_id NUMBER
149 , p_status VARCHAR2
150 , p_delinquency_id NUMBER
151 , p_ffm_request_id NUMBER
152 , p_xml_request_id NUMBER
153 , p_xml_template_id NUMBER
154 , p_object_id NUMBER
155 , p_object_type VARCHAR2
156 , p_dunning_object_id NUMBER
157 , p_dunning_level VARCHAR2
158 , p_dunning_method VARCHAR2
159 , p_amount_due_remaining NUMBER
160 , p_currency_code VARCHAR2
161 , p_last_update_date DATE
162 , p_last_updated_by NUMBER
163 , p_creation_date DATE
164 , p_created_by NUMBER
165 , p_last_update_login NUMBER
166 , p_request_id NUMBER
167 , p_financial_charge NUMBER default null
168 , p_letter_name VARCHAR2 default null
169 , p_interest_amt NUMBER default null
170 , p_dunning_plan_id NUMBER default null
171 , p_contact_destination varchar2 default null
172 , p_contact_party_id NUMBER default null
173 , p_delivery_status varchar2
174 , p_parent_dunning_id number
175 , p_dunning_mode varchar2 -- added by gnramasa for bug 8489610 14-May-09
176 , p_confirmation_mode varchar2 -- added by gnramasa for bug 8489610 14-May-09
177 , p_dunning_plan_line_id number
178 );
179
180 */
181
182 END iex_dunnings_pkg;