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 2033: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,

2029: Procedure Create_AG_DN_XREF
2030: (p_api_version IN NUMBER := 1.0,
2031: p_init_msg_list IN VARCHAR2 ,
2032: p_commit IN VARCHAR2 ,
2033: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,
2034: x_return_status OUT NOCOPY VARCHAR2,
2035: x_msg_count OUT NOCOPY NUMBER,
2036: x_msg_data OUT NOCOPY VARCHAR2,
2037: x_AG_DN_XREF_ID OUT NOCOPY NUMBER)

Line 2045: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;

2041: l_return_status VARCHAR2(1);
2042: l_msg_count NUMBER;
2043: l_msg_data VARCHAR2(32767);
2044: l_rowid Varchar2(50);
2045: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
2046: errmsg VARCHAR2(32767);
2047:
2048:
2049: BEGIN

Line 2161: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,

2157: Procedure Update_AG_DN_XREF
2158: (p_api_version IN NUMBER := 1.0,
2159: p_init_msg_list IN VARCHAR2 ,
2160: p_commit IN VARCHAR2 ,
2161: P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,
2162: p_AG_DN_XREF_ID IN NUMBER,
2163: x_return_status OUT NOCOPY VARCHAR2,
2164: x_msg_count OUT NOCOPY NUMBER,
2165: x_msg_data OUT NOCOPY VARCHAR2)

Line 2197: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;

2193: l_return_status VARCHAR2(1);
2194: l_msg_count NUMBER;
2195: l_msg_data VARCHAR2(32767);
2196: l_rowid Varchar2(50);
2197: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
2198: l_AG_DN_XREF_id NUMBER ;
2199: l_AG_DN_XREF_REF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;
2200: errmsg VARCHAR2(32767);
2201:

Line 2199: l_AG_DN_XREF_REF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;

2195: l_msg_data VARCHAR2(32767);
2196: l_rowid Varchar2(50);
2197: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
2198: l_AG_DN_XREF_id NUMBER ;
2199: l_AG_DN_XREF_REF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;
2200: errmsg VARCHAR2(32767);
2201:
2202:
2203: BEGIN

Line 2519: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,

2515: Procedure Create_Dunning
2516: (p_api_version IN NUMBER := 1.0,
2517: p_init_msg_list IN VARCHAR2 ,
2518: p_commit IN VARCHAR2 ,
2519: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,
2520: x_return_status OUT NOCOPY VARCHAR2,
2521: x_msg_count OUT NOCOPY NUMBER,
2522: x_msg_data OUT NOCOPY VARCHAR2,
2523: x_Dunning_ID OUT NOCOPY NUMBER)

Line 2531: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;

2527: l_return_status VARCHAR2(1);
2528: l_msg_count NUMBER;
2529: l_msg_data VARCHAR2(32767);
2530: l_rowid Varchar2(50);
2531: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;
2532: errmsg VARCHAR2(32767);
2533:
2534:
2535: BEGIN

Line 2652: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,

2648: Procedure Update_Dunning
2649: (p_api_version IN NUMBER := 1.0,
2650: p_init_msg_list IN VARCHAR2 ,
2651: p_commit IN VARCHAR2 ,
2652: P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,
2653: x_return_status OUT NOCOPY VARCHAR2,
2654: x_msg_count OUT NOCOPY NUMBER,
2655: x_msg_data OUT NOCOPY VARCHAR2)
2656:

Line 2700: l_DUNNING_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE ;

2696: l_return_status VARCHAR2(1);
2697: l_msg_count NUMBER;
2698: l_msg_data VARCHAR2(32767);
2699: l_rowid Varchar2(50);
2700: l_DUNNING_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE ;
2701: l_dunning_id NUMBER ;
2702: l_DUNNING_REF_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE;
2703: errmsg VARCHAR2(32767);
2704:

Line 2702: l_DUNNING_REF_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE;

2698: l_msg_data VARCHAR2(32767);
2699: l_rowid Varchar2(50);
2700: l_DUNNING_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE ;
2701: l_dunning_id NUMBER ;
2702: l_DUNNING_REF_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE;
2703: errmsg VARCHAR2(32767);
2704:
2705:
2706: BEGIN

Line 3078: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

3074: l_party_cust_id NUMBER;
3075: l_account_id NUMBER;
3076: l_customer_site_use_id NUMBER;
3077: l_noskip NUMBER := 0;
3078: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3079: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
3080: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3081: l_score NUMBER;
3082: l_bucket_line_id NUMBER;

Line 3079: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;

3075: l_account_id NUMBER;
3076: l_customer_site_use_id NUMBER;
3077: l_noskip NUMBER := 0;
3078: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3079: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
3080: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3081: l_score NUMBER;
3082: l_bucket_line_id NUMBER;
3083: l_campaign_sched_id NUMBER;

Line 3080: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

3076: l_customer_site_use_id NUMBER;
3077: l_noskip NUMBER := 0;
3078: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3079: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
3080: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3081: l_score NUMBER;
3082: l_bucket_line_id NUMBER;
3083: l_campaign_sched_id NUMBER;
3084: l_template_id NUMBER;

Line 3108: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

3104: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
3105: l_org_id NUMBER ;
3106: l_object_Code VARCHAR2(25);
3107: l_object_id NUMBER;
3108: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
3109: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
3110: l_curr_code VARCHAR2(15);
3111: l_amount NUMBER;
3112: l_write NUMBER;

Line 3796: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

3792: l_party_cust_id NUMBER;
3793: l_account_id NUMBER;
3794: l_customer_site_use_id NUMBER;
3795: l_location_id number;
3796: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3797: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3798: l_score NUMBER;
3799: l_bucket_line_id NUMBER;
3800: l_campaign_sched_id NUMBER;

Line 3797: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;

3793: l_account_id NUMBER;
3794: l_customer_site_use_id NUMBER;
3795: l_location_id number;
3796: l_dunning_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3797: l_dunning_rec_upd IEX_DUNNING_PUB.DUNNING_REC_TYPE;
3798: l_score NUMBER;
3799: l_bucket_line_id NUMBER;
3800: l_campaign_sched_id NUMBER;
3801: l_template_id NUMBER;

Line 3823: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

3819: Del_Tbl Del_ID_TBL_TYPE;
3820: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
3821: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
3822: l_org_id NUMBER ;
3823: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
3824: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
3825: l_ffm_cnt NUMBER := 0;
3826: l_dunn_cnt NUMBER := 0;
3827: l_bucket VARCHAR2(100);

Line 4436: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

4432: l_party_cust_id NUMBER;
4433: l_account_id NUMBER;
4434: l_customer_site_use_id NUMBER;
4435: l_noskip NUMBER := 0;
4436: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4437: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
4438: l_score NUMBER;
4439: l_bucket_line_id NUMBER;
4440: l_campaign_sched_id NUMBER;

Line 4437: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;

4433: l_account_id NUMBER;
4434: l_customer_site_use_id NUMBER;
4435: l_noskip NUMBER := 0;
4436: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
4437: l_DUNNING_tbl IEX_DUNNING_PUB.DUNNING_TBL_TYPE;
4438: l_score NUMBER;
4439: l_bucket_line_id NUMBER;
4440: l_campaign_sched_id NUMBER;
4441: l_template_id NUMBER;

Line 4466: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

4462: l_org_id NUMBER ;
4463: l_running_level VARCHAR2(25);
4464: l_object_Code VARCHAR2(25);
4465: l_object_id NUMBER;
4466: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
4467: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
4468: l_curr_code VARCHAR2(15);
4469: l_amount NUMBER;
4470: l_write NUMBER;

Line 5140: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

5136: l_delinquency_id NUMBER;
5137: l_party_cust_id NUMBER;
5138: l_account_id NUMBER;
5139: l_customer_site_use_id NUMBER;
5140: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
5141: l_score NUMBER;
5142: l_bucket_line_id NUMBER;
5143: l_campaign_sched_id NUMBER;
5144: l_template_id NUMBER;

Line 5166: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;

5162: Del_Tbl Del_ID_TBL_TYPE;
5163: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
5164: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
5165: l_org_id NUMBER ;
5166: --l_delid_tbl IEX_DUNNING_PUB.DelId_NumList;
5167: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
5168: l_ffm_cnt NUMBER := 0;
5169: l_dunn_cnt NUMBER := 0;
5170: l_bucket VARCHAR2(100);

Line 6525: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

6521: nOrgFound NUMBER := 0;
6522: l_org_id NUMBER ;
6523:
6524:
6525: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
6526: l_dunning_id NUMBER;
6527:
6528: l_contact_party_id number; --#bug 3955222
6529:

Line 7048: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

7044: nOrgIdx NUMBER := 0;
7045: errmsg VARCHAR2(30000);
7046: nOrgFound NUMBER := 0;
7047: l_org_id NUMBER ;
7048: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
7049: l_dunning_id NUMBER;
7050:
7051: l_level VARCHAR2(20);
7052: l_temp_level VARCHAR2(20);

Line 8416: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

8412: l_DUNNING_id NUMBER;
8413: l_delinquency_id NUMBER;
8414: l_dunning_object_id NUMBER;
8415: l_dunning_level VARCHAR2(30);
8416: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
8417: l_api_name CONSTANT VARCHAR2(30) := 'Close_Dunning';
8418: l_api_version_number CONSTANT NUMBER := 1.0;
8419: l_return_status VARCHAR2(1);
8420: l_msg_count NUMBER;

Line 8613: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;

8609: --
8610: l_DUNNING_id NUMBER;
8611: l_delinquency_id NUMBER;
8612: l_callback_date varchar2(10);
8613: l_DUNNING_rec IEX_DUNNING_PUB.DUNNING_REC_TYPE;
8614: l_curr_date varchar2(10);
8615: l_task_id NUMBER;
8616: l_api_name CONSTANT VARCHAR2(30) := 'Daily_Dunning';
8617: l_api_version_number CONSTANT NUMBER := 1.0;