eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_DUNNING_PVT dependencies on IEX_DELINQUENCY_PUB

Line 2666: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

2662: Procedure Create_Staged_Dunning
2663: (p_api_version IN NUMBER := 1.0,
2664: p_init_msg_list IN VARCHAR2 ,
2665: p_commit IN VARCHAR2 ,
2666: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
2667: p_dunning_id IN NUMBER,
2668: p_correspondence_date IN DATE,
2669: p_ag_dn_xref_id IN NUMBER,
2670: p_running_level IN VARCHAR2,

Line 3985: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

3981: p_commit IN VARCHAR2 ,
3982: p_running_level IN VARCHAR2,
3983: p_dunning_plan_id in number,
3984: p_resend_flag IN VARCHAR2,
3985: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
3986: p_parent_request_id IN NUMBER,
3987: p_dunning_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 14-May-09
3988: p_confirmation_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 14-May-09
3989: p_correspondence_date IN DATE,

Line 4167: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

4163: l_org_id NUMBER ;
4164: l_object_Code VARCHAR2(25);
4165: l_object_id NUMBER;
4166: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
4167: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
4168: l_curr_code VARCHAR2(15);
4169: l_amount NUMBER;
4170: l_write NUMBER;
4171: l_ffm_cnt NUMBER := 0;

Line 5252: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

5248: p_running_level IN VARCHAR2,
5249: p_dunning_plan_id in number,
5250: p_correspondence_date IN DATE,
5251: p_resend_flag IN VARCHAR2,
5252: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
5253: p_parent_request_id IN NUMBER,
5254: p_dunning_mode IN VARCHAR2,
5255: p_single_staged_letter IN VARCHAR2 DEFAULT 'N', -- added by gnramasa for bug stageddunning 28-Dec-09
5256: p_confirmation_mode IN VARCHAR2,

Line 5391: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

5387: l_org_id NUMBER ;
5388: l_object_Code VARCHAR2(25);
5389: l_object_id NUMBER;
5390: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
5391: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
5392: l_curr_code VARCHAR2(15);
5393: l_amount NUMBER;
5394: l_write NUMBER;
5395: l_ffm_cnt NUMBER := 0;

Line 6888: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

6884: p_init_msg_list IN VARCHAR2 ,
6885: p_commit IN VARCHAR2 ,
6886: p_dunning_plan_id in number,
6887: p_resend_flag IN VARCHAR2,
6888: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
6889: p_parent_request_id IN NUMBER,
6890: p_dunning_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 14-May-09
6891: p_confirmation_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 14-May-09
6892: p_correspondence_date IN DATE,

Line 7040: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

7036: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
7037: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
7038: l_org_id NUMBER ;
7039: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
7040: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
7041: l_ffm_cnt NUMBER := 0;
7042: l_dunn_cnt NUMBER := 0;
7043: l_bucket VARCHAR2(100);
7044:

Line 7934: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

7930: p_commit IN VARCHAR2 ,
7931: p_dunning_plan_id in number,
7932: p_correspondence_date IN DATE,
7933: p_resend_flag IN VARCHAR2,
7934: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
7935: p_parent_request_id IN NUMBER,
7936: p_dunning_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 14-May-09
7937: p_single_staged_letter IN VARCHAR2 DEFAULT 'N', -- added by gnramasa for bug stageddunning 30-Dec-09
7938: p_confirmation_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 14-May-09

Line 8064: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

8060: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
8061: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
8062: l_org_id NUMBER ;
8063: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
8064: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
8065: l_ffm_cnt NUMBER := 0;
8066: l_dunn_cnt NUMBER := 0;
8067: l_bucket VARCHAR2(100);
8068:

Line 9129: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

9125: p_init_msg_list IN VARCHAR2 ,
9126: p_commit IN VARCHAR2 ,
9127: p_dunning_plan_id in number,
9128: p_running_level IN VARCHAR2,
9129: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
9130: p_org_id in number,
9131: p_dunning_id in Number,
9132: x_request_id OUT NOCOPY NUMBER,
9133: x_return_status OUT NOCOPY VARCHAR2,

Line 9264: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

9260: l_running_level VARCHAR2(25);
9261: l_object_Code VARCHAR2(25);
9262: l_object_id NUMBER;
9263: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
9264: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
9265: l_curr_code VARCHAR2(15);
9266: l_amount NUMBER;
9267: l_write NUMBER;
9268: l_ffm_cnt NUMBER := 0;

Line 10210: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

10206: p_commit IN VARCHAR2 ,
10207: p_dunning_plan_id in number,
10208: p_dunning_id in number,
10209: p_running_level IN VARCHAR2,
10210: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
10211: p_org_id in number default null,
10212: x_request_id OUT NOCOPY NUMBER,
10213: x_return_status OUT NOCOPY VARCHAR2,
10214: x_msg_count OUT NOCOPY NUMBER,

Line 10311: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

10307: l_running_level VARCHAR2(25);
10308: l_object_Code VARCHAR2(25);
10309: l_object_id NUMBER;
10310: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
10311: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
10312: l_curr_code VARCHAR2(15);
10313: l_amount NUMBER;
10314: l_write NUMBER;
10315: l_ffm_cnt NUMBER := 0;

Line 11162: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

11158: (p_api_version IN NUMBER := 1.0,
11159: p_init_msg_list IN VARCHAR2 ,
11160: p_commit IN VARCHAR2 ,
11161: p_dunning_plan_id in number,
11162: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
11163: p_org_id in number,
11164: p_dunning_id in Number,
11165: x_request_id OUT NOCOPY NUMBER,
11166: x_return_status OUT NOCOPY VARCHAR2,

Line 11274: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

11270: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
11271: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
11272: l_org_id NUMBER ;
11273: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
11274: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
11275: l_ffm_cnt NUMBER := 0;
11276: l_dunn_cnt NUMBER := 0;
11277: l_bucket VARCHAR2(100);
11278: i NUMBER := 0;

Line 11953: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

11949: p_init_msg_list IN VARCHAR2 ,
11950: p_commit IN VARCHAR2 ,
11951: p_dunning_plan_id in number,
11952: p_dunning_id in number,
11953: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
11954: p_org_id in number,
11955: x_request_id OUT NOCOPY NUMBER,
11956: x_return_status OUT NOCOPY VARCHAR2,
11957: x_msg_count OUT NOCOPY NUMBER,

Line 12062: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

12058: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
12059: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
12060: l_org_id NUMBER ;
12061: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
12062: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
12063: l_ffm_cnt NUMBER := 0;
12064: l_dunn_cnt NUMBER := 0;
12065: l_bucket VARCHAR2(100);
12066: i NUMBER := 0;

Line 15900: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

15896: PROCEDURE Close_Dunning
15897: (p_api_version IN NUMBER,
15898: p_init_msg_list IN VARCHAR2 ,
15899: p_commit IN VARCHAR2 ,
15900: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
15901: p_running_level IN VARCHAR2,
15902: --p_dunning_id IN NUMBER default NULL, -- added by gnramasa for bug 8489610 14-May-09
15903: --p_status IN VARCHAR2 , -- added by gnramasa for bug 8489610 14-May-09
15904: x_return_status OUT NOCOPY VARCHAR2,

Line 16078: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

16074: PROCEDURE Close_Staged_Dunning
16075: (p_api_version IN NUMBER,
16076: p_init_msg_list IN VARCHAR2 ,
16077: p_commit IN VARCHAR2 ,
16078: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
16079: p_ag_dn_xref_id IN NUMBER,
16080: p_running_level IN VARCHAR2,
16081: --p_dunning_id IN NUMBER default NULL, -- added by gnramasa for bug 8489610 14-May-09
16082: --p_status IN VARCHAR2 , -- added by gnramasa for bug 8489610 14-May-09

Line 18383: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,

18379: Procedure INSERT_DUNNING_TRANSACTION
18380: (p_api_version IN NUMBER := 1.0,
18381: p_init_msg_list IN VARCHAR2 ,
18382: p_commit IN VARCHAR2 ,
18383: p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
18384: p_dunning_id IN NUMBER,
18385: p_correspondence_date IN DATE,
18386: p_ag_dn_xref_id IN NUMBER ,
18387: p_running_level IN VARCHAR2,