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_DUNNING_PUB

Line 2048: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,

2044: Procedure Create_AG_DN_XREF
2045: (p_api_version IN NUMBER := 1.0,
2046: p_init_msg_list IN VARCHAR2 ,
2047: p_commit IN VARCHAR2 ,
2048: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,
2049: x_return_status OUT NOCOPY VARCHAR2,
2050: x_msg_count OUT NOCOPY NUMBER,
2051: x_msg_data OUT NOCOPY VARCHAR2,
2052: x_AG_DN_XREF_ID OUT NOCOPY NUMBER)

Line 2060: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;

2056: l_return_status VARCHAR2(1);
2057: l_msg_count NUMBER;
2058: l_msg_data VARCHAR2(32767);
2059: l_rowid Varchar2(50);
2060: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
2061: errmsg VARCHAR2(32767);
2062:
2063: BEGIN
2064: -- Standard Start of API savepoint

Line 2171: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,

2167: Procedure Update_AG_DN_XREF
2168: (p_api_version IN NUMBER := 1.0,
2169: p_init_msg_list IN VARCHAR2 ,
2170: p_commit IN VARCHAR2 ,
2171: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,
2172: p_AG_DN_XREF_ID IN NUMBER,
2173: x_return_status OUT NOCOPY VARCHAR2,
2174: x_msg_count OUT NOCOPY NUMBER,
2175: x_msg_data OUT NOCOPY VARCHAR2)

Line 2207: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;

2203: l_return_status VARCHAR2(1);
2204: l_msg_count NUMBER;
2205: l_msg_data VARCHAR2(32767);
2206: l_rowid Varchar2(50);
2207: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
2208: l_AG_DN_XREF_id NUMBER ;
2209: l_AG_DN_XREF_REF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;
2210: errmsg VARCHAR2(32767);
2211:

Line 2209: l_AG_DN_XREF_REF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;

2205: l_msg_data VARCHAR2(32767);
2206: l_rowid Varchar2(50);
2207: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
2208: l_AG_DN_XREF_id NUMBER ;
2209: l_AG_DN_XREF_REF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;
2210: errmsg VARCHAR2(32767);
2211:
2212: BEGIN
2213:

Line 2524: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,

2520: Procedure Create_Dunning
2521: (p_api_version IN NUMBER := 1.0,
2522: p_init_msg_list IN VARCHAR2 ,
2523: p_commit IN VARCHAR2 ,
2524: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,
2525: x_return_status OUT NOCOPY VARCHAR2,
2526: x_msg_count OUT NOCOPY NUMBER,
2527: x_msg_data OUT NOCOPY VARCHAR2,
2528: x_Dunning_ID OUT NOCOPY NUMBER)

Line 2536: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;

2532: l_return_status VARCHAR2(1);
2533: l_msg_count NUMBER;
2534: l_msg_data VARCHAR2(32767);
2535: l_rowid Varchar2(50);
2536: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;
2537: errmsg VARCHAR2(32767);
2538:
2539: BEGIN
2540: -- Standard Start of API savepoint

Line 2685: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;

2681: l_return_status VARCHAR2(1);
2682: l_msg_count NUMBER;
2683: l_msg_data VARCHAR2(32767);
2684: l_rowid Varchar2(50);
2685: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;
2686: errmsg VARCHAR2(32767);
2687:
2688: cursor c_dunning_plan_lines(p_ag_dn_xref_id number) is
2689: select ag_dn_xref_id,

Line 3581: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,

3577: Procedure Update_Dunning
3578: (p_api_version IN NUMBER := 1.0,
3579: p_init_msg_list IN VARCHAR2 ,
3580: p_commit IN VARCHAR2 ,
3581: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,
3582: x_return_status OUT NOCOPY VARCHAR2,
3583: x_msg_count OUT NOCOPY NUMBER,
3584: x_msg_data OUT NOCOPY VARCHAR2)
3585:

Line 3638: l_DUNNING_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE ;

3634: l_return_status VARCHAR2(1);
3635: l_msg_count NUMBER;
3636: l_msg_data VARCHAR2(32767);
3637: l_rowid Varchar2(50);
3638: l_DUNNING_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE ;
3639: l_dunning_id NUMBER ;
3640: l_DUNNING_REF_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3641: errmsg VARCHAR2(32767);
3642:

Line 3640: l_DUNNING_REF_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE;

3636: l_msg_data VARCHAR2(32767);
3637: l_rowid Varchar2(50);
3638: l_DUNNING_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE ;
3639: l_dunning_id NUMBER ;
3640: l_DUNNING_REF_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3641: errmsg VARCHAR2(32767);
3642:
3643: BEGIN
3644:

Line 4136: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

4132: l_party_cust_id NUMBER;
4133: l_account_id NUMBER;
4134: l_customer_site_use_id NUMBER;
4135: l_noskip NUMBER := 0;
4136: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4137: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
4138: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4139: l_score NUMBER;
4140: l_bucket_line_id NUMBER;

Line 4137: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;

4133: l_account_id NUMBER;
4134: l_customer_site_use_id NUMBER;
4135: l_noskip NUMBER := 0;
4136: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4137: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
4138: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4139: l_score NUMBER;
4140: l_bucket_line_id NUMBER;
4141: l_campaign_sched_id NUMBER;

Line 4138: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

4134: l_customer_site_use_id NUMBER;
4135: l_noskip NUMBER := 0;
4136: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4137: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
4138: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4139: l_score NUMBER;
4140: l_bucket_line_id NUMBER;
4141: l_campaign_sched_id NUMBER;
4142: l_template_id NUMBER;

Line 4166: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

4162: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
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;

Line 5360: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

5356: l_party_cust_id NUMBER;
5357: l_account_id NUMBER;
5358: l_customer_site_use_id NUMBER;
5359: l_noskip NUMBER := 0;
5360: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
5361: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
5362: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
5363: l_score NUMBER;
5364: l_bucket_line_id NUMBER;

Line 5361: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;

5357: l_account_id NUMBER;
5358: l_customer_site_use_id NUMBER;
5359: l_noskip NUMBER := 0;
5360: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
5361: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
5362: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
5363: l_score NUMBER;
5364: l_bucket_line_id NUMBER;
5365: l_campaign_sched_id NUMBER;

Line 5362: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

5358: l_customer_site_use_id NUMBER;
5359: l_noskip NUMBER := 0;
5360: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
5361: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
5362: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
5363: l_score NUMBER;
5364: l_bucket_line_id NUMBER;
5365: l_campaign_sched_id NUMBER;
5366: l_template_id NUMBER;

Line 5390: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

5386: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
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;

Line 7012: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

7008: l_party_cust_id NUMBER;
7009: l_account_id NUMBER;
7010: l_customer_site_use_id NUMBER;
7011: l_location_id number;
7012: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
7013: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
7014: l_score NUMBER;
7015: l_bucket_line_id NUMBER;
7016: l_campaign_sched_id NUMBER;

Line 7013: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

7009: l_account_id NUMBER;
7010: l_customer_site_use_id NUMBER;
7011: l_location_id number;
7012: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
7013: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
7014: l_score NUMBER;
7015: l_bucket_line_id NUMBER;
7016: l_campaign_sched_id NUMBER;
7017: l_template_id NUMBER;

Line 7039: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

7035: Del_Tbl Del_ID_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);

Line 8036: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

8032: l_party_cust_id NUMBER;
8033: l_account_id NUMBER;
8034: l_customer_site_use_id NUMBER;
8035: l_location_id number;
8036: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
8037: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
8038: l_score NUMBER;
8039: l_bucket_line_id NUMBER;
8040: l_campaign_sched_id NUMBER;

Line 8037: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

8033: l_account_id NUMBER;
8034: l_customer_site_use_id NUMBER;
8035: l_location_id number;
8036: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
8037: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
8038: l_score NUMBER;
8039: l_bucket_line_id NUMBER;
8040: l_campaign_sched_id NUMBER;
8041: l_template_id NUMBER;

Line 8063: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

8059: Del_Tbl Del_ID_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);

Line 9233: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

9229: l_party_cust_id NUMBER;
9230: l_account_id NUMBER;
9231: l_customer_site_use_id NUMBER;
9232: l_noskip NUMBER := 0;
9233: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
9234: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
9235: l_score NUMBER;
9236: l_bucket_line_id NUMBER;
9237: l_campaign_sched_id NUMBER;

Line 9234: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;

9230: l_account_id NUMBER;
9231: l_customer_site_use_id NUMBER;
9232: l_noskip NUMBER := 0;
9233: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
9234: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
9235: l_score NUMBER;
9236: l_bucket_line_id NUMBER;
9237: l_campaign_sched_id NUMBER;
9238: l_template_id NUMBER;

Line 9263: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

9259: l_org_id NUMBER ;
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;

Line 10280: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

10276: l_party_cust_id NUMBER;
10277: l_account_id NUMBER;
10278: l_customer_site_use_id NUMBER;
10279: l_noskip NUMBER := 0;
10280: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
10281: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
10282: l_score NUMBER;
10283: l_bucket_line_id NUMBER;
10284: l_campaign_sched_id NUMBER;

Line 10281: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;

10277: l_account_id NUMBER;
10278: l_customer_site_use_id NUMBER;
10279: l_noskip NUMBER := 0;
10280: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
10281: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
10282: l_score NUMBER;
10283: l_bucket_line_id NUMBER;
10284: l_campaign_sched_id NUMBER;
10285: l_template_id NUMBER;

Line 10310: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

10306: l_org_id NUMBER ;
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;

Line 11247: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

11243: l_delinquency_id NUMBER;
11244: l_party_cust_id NUMBER;
11245: l_account_id NUMBER;
11246: l_customer_site_use_id NUMBER;
11247: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
11248: l_score NUMBER;
11249: l_bucket_line_id NUMBER;
11250: l_campaign_sched_id NUMBER;
11251: l_template_id NUMBER;

Line 11273: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

11269: Del_Tbl Del_ID_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);

Line 12035: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

12031: l_delinquency_id NUMBER;
12032: l_party_cust_id NUMBER;
12033: l_account_id NUMBER;
12034: l_customer_site_use_id NUMBER;
12035: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
12036: l_score NUMBER;
12037: l_bucket_line_id NUMBER;
12038: l_campaign_sched_id NUMBER;
12039: l_template_id NUMBER;

Line 12061: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

12057: Del_Tbl Del_ID_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);

Line 13581: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

13577:
13578: nOrgFound NUMBER := 0;
13579: l_org_id NUMBER ;
13580:
13581: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
13582: l_dunning_id NUMBER;
13583:
13584: l_contact_party_id number; --#bug 3955222
13585:

Line 14111: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

14107: nOrgIdx NUMBER := 0;
14108: errmsg VARCHAR2(30000);
14109: nOrgFound NUMBER := 0;
14110: l_org_id NUMBER ;
14111: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
14112: l_DUNNING_upd_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
14113: l_dunning_id NUMBER;
14114:
14115: l_level VARCHAR2(20);

Line 14112: l_DUNNING_upd_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

14108: errmsg VARCHAR2(30000);
14109: nOrgFound NUMBER := 0;
14110: l_org_id NUMBER ;
14111: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
14112: l_DUNNING_upd_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
14113: l_dunning_id NUMBER;
14114:
14115: l_level VARCHAR2(20);
14116: l_temp_level VARCHAR2(20);

Line 15925: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

15921: l_DUNNING_id NUMBER;
15922: l_delinquency_id NUMBER;
15923: l_dunning_object_id NUMBER;
15924: l_dunning_level VARCHAR2(30);
15925: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
15926: l_api_name CONSTANT VARCHAR2(30) := 'Close_Dunning';
15927: l_api_version_number CONSTANT NUMBER := 1.0;
15928: l_return_status VARCHAR2(1);
15929: l_msg_count NUMBER;

Line 16104: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

16100: l_DUNNING_id NUMBER;
16101: l_delinquency_id NUMBER;
16102: l_dunning_object_id NUMBER;
16103: l_dunning_level VARCHAR2(30);
16104: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
16105: l_api_name CONSTANT VARCHAR2(30) := 'Close_Staged_Dunning';
16106: l_api_version_number CONSTANT NUMBER := 1.0;
16107: l_return_status VARCHAR2(1);
16108: l_msg_count NUMBER;

Line 16304: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

16300: --
16301: l_DUNNING_id NUMBER;
16302: l_delinquency_id NUMBER;
16303: l_callback_date varchar2(10);
16304: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
16305: l_curr_date varchar2(10);
16306: l_task_id NUMBER;
16307: l_api_name CONSTANT VARCHAR2(30) := 'Daily_Dunning';
16308: l_api_version_number CONSTANT NUMBER := 1.0;

Line 18401: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;

18397: l_return_status VARCHAR2(1);
18398: l_msg_count NUMBER;
18399: l_msg_data VARCHAR2(32767);
18400: l_rowid Varchar2(50);
18401: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;
18402: errmsg VARCHAR2(32767);
18403:
18404: --l_dunning_plan_lines c_dunning_plan_lines%rowtype;
18405: Type refCur is Ref Cursor;