DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on IEX_DELINQUENCY_PUB

Line 66: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

62: Procedure Create_Staged_Dunning
63: (p_api_version IN NUMBER := 1.0,
64: p_init_msg_list IN VARCHAR2 ,
65: p_commit IN VARCHAR2 ,
66: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
67: p_dunning_id IN NUMBER,
68: p_correspondence_date IN DATE,
69: p_ag_dn_xref_id IN NUMBER,
70: p_running_level IN VARCHAR2,

Line 101: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

97: p_commit IN VARCHAR2 ,
98: p_running_level IN VARCHAR2,
99: p_dunning_plan_id in number,
100: p_resend_flag IN VARCHAR2 DEFAULT NULL,
101: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
102: p_parent_request_id IN NUMBER,
103: p_dunning_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
104: p_confirmation_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
105: p_correspondence_date IN DATE,

Line 118: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

114: p_running_level IN VARCHAR2,
115: p_dunning_plan_id in number,
116: p_correspondence_date IN DATE,
117: p_resend_flag IN VARCHAR2 DEFAULT NULL,
118: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
119: p_parent_request_id IN NUMBER,
120: p_dunning_mode IN VARCHAR2 DEFAULT NULL,
121: p_single_staged_letter IN VARCHAR2 DEFAULT 'N',
122: p_confirmation_mode IN VARCHAR2 DEFAULT NULL,

Line 133: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

129: p_init_msg_list IN VARCHAR2 ,
130: p_commit IN VARCHAR2 ,
131: p_dunning_plan_id in number,
132: p_resend_flag IN VARCHAR2 DEFAULT NULL,
133: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
134: p_parent_request_id IN NUMBER,
135: p_dunning_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
136: p_confirmation_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
137: p_correspondence_date IN DATE,

Line 149: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

145: p_commit IN VARCHAR2 ,
146: p_dunning_plan_id in number,
147: p_correspondence_date IN DATE,
148: p_resend_flag IN VARCHAR2 DEFAULT NULL,
149: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
150: p_parent_request_id IN NUMBER,
151: p_dunning_mode IN VARCHAR2 DEFAULT NULL,
152: p_single_staged_letter IN VARCHAR2 DEFAULT 'N',
153: p_confirmation_mode IN VARCHAR2 DEFAULT NULL,

Line 190: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

186: p_init_msg_list IN VARCHAR2 ,
187: p_commit IN VARCHAR2 ,
188: p_dunning_plan_id in number,
189: p_running_level IN VARCHAR2,
190: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
191: p_org_id in number default null,
192: p_dunning_id in number default null,
193: x_request_id OUT NOCOPY NUMBER,
194: x_return_status OUT NOCOPY VARCHAR2,

Line 205: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

201: p_commit IN VARCHAR2 ,
202: p_dunning_plan_id in number,
203: p_dunning_id in number,
204: p_running_level IN VARCHAR2,
205: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
206: p_org_id in number default null,
207: x_request_id OUT NOCOPY NUMBER,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,

Line 217: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

213: (p_api_version IN NUMBER := 1.0,
214: p_init_msg_list IN VARCHAR2 ,
215: p_commit IN VARCHAR2 ,
216: p_dunning_plan_id in number,
217: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
218: p_org_id in number default null,
219: p_dunning_id in number default null,
220: x_request_id OUT NOCOPY NUMBER,
221: x_return_status OUT NOCOPY VARCHAR2,

Line 231: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

227: p_init_msg_list IN VARCHAR2 ,
228: p_commit IN VARCHAR2 ,
229: p_dunning_plan_id in number,
230: p_dunning_id in number,
231: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
232: p_org_id in number default null,
233: x_request_id OUT NOCOPY NUMBER,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,

Line 286: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

282: PROCEDURE Close_Dunning
283: (p_api_version IN NUMBER := 1.0,
284: p_init_msg_list IN VARCHAR2 ,
285: p_commit IN VARCHAR2 ,
286: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
287: --p_delinquencies_tbl IN IEX_DUNNING_PUB.DelId_NumList,
288: p_running_level IN VARCHAR2,
289: --p_dunning_id IN NUMBER default NULL, -- added by gnramasa for bug 8489610 14-May-09
290: --p_status IN VARCHAR2 DEFAULT 'OPEN', -- added by gnramasa for bug 8489610 14-May-09

Line 299: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

295: PROCEDURE Close_Staged_Dunning
296: (p_api_version IN NUMBER := 1.0,
297: p_init_msg_list IN VARCHAR2 ,
298: p_commit IN VARCHAR2 ,
299: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
300: p_ag_dn_xref_id IN NUMBER,
301: p_running_level IN VARCHAR2,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,

Line 530: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

526: Procedure INSERT_DUNNING_TRANSACTION
527: (p_api_version IN NUMBER := 1.0,
528: p_init_msg_list IN VARCHAR2 ,
529: p_commit IN VARCHAR2 ,
530: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
531: p_dunning_id IN NUMBER,
532: p_correspondence_date IN DATE default sysdate,
533: p_ag_dn_xref_id IN NUMBER,
534: p_running_level IN VARCHAR2,