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_PVT

Line 1: PACKAGE BODY IEX_DUNNING_PVT AS

1: PACKAGE BODY IEX_DUNNING_PVT AS
2: /* $Header: iexvdunb.pls 120.110.12020000.25 2013/02/21 12:55:35 sunagesh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvdunb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PVT';

1: PACKAGE BODY IEX_DUNNING_PVT AS
2: /* $Header: iexvdunb.pls 120.110.12020000.25 2013/02/21 12:55:35 sunagesh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvdunb.pls';
6:
7: PG_DEBUG NUMBER ;
8:

Line 1468: p_fulfillment_bind_tbl in out nocopy IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

1464: p_send_method in varchar2,
1465: p_resend IN VARCHAR2 ,
1466: p_object_code IN VARCHAR2 ,
1467: p_object_id IN NUMBER,
1468: p_fulfillment_bind_tbl in out nocopy IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
1469: x_return_status OUT NOCOPY VARCHAR2,
1470: x_msg_count OUT NOCOPY NUMBER,
1471: x_msg_data OUT NOCOPY VARCHAR2)
1472:

Line 1475: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

1471: x_msg_data OUT NOCOPY VARCHAR2)
1472:
1473: is
1474:
1475: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
1476: l_bind_count number;
1477: l_del_index number;
1478: l_location_index number;
1479: l_contact_index number;

Line 4161: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

4157: nIdx NUMBER := 0;
4158: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
4159: INDEX BY BINARY_INTEGER;
4160: Del_Tbl Del_ID_TBL_TYPE;
4161: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
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;

Line 4162: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

4158: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
4159: INDEX BY BINARY_INTEGER;
4160: Del_Tbl Del_ID_TBL_TYPE;
4161: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
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;

Line 5144: IEX_DUNNING_PVT.Update_DUNNING(

5140: else
5141: l_dunning_rec_upd.xml_request_id := l_request_id;
5142: end if;
5143:
5144: IEX_DUNNING_PVT.Update_DUNNING(
5145: p_api_version => 1.0
5146: , p_init_msg_list => FND_API.G_FALSE
5147: , p_commit => FND_API.G_TRUE
5148: , p_dunning_rec => l_dunning_rec_upd

Line 5385: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

5381: nIdx NUMBER := 0;
5382: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
5383: INDEX BY BINARY_INTEGER;
5384: Del_Tbl Del_ID_TBL_TYPE;
5385: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
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;

Line 5386: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

5382: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
5383: INDEX BY BINARY_INTEGER;
5384: Del_Tbl Del_ID_TBL_TYPE;
5385: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
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;

Line 6583: IEX_DUNNING_PVT.Update_DUNNING(

6579: l_dunning_rec_upd.currency_code := l_curr_code;
6580: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec_upd.amount_due_remaining = ' ||l_dunning_rec_upd.amount_due_remaining);
6581: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec_upd.currency_code = ' ||l_dunning_rec_upd.currency_code);
6582:
6583: IEX_DUNNING_PVT.Update_DUNNING(
6584: p_api_version => 1.0
6585: , p_init_msg_list => FND_API.G_FALSE
6586: , p_commit => FND_API.G_TRUE
6587: , p_dunning_rec => l_dunning_rec_upd

Line 6726: IEX_DUNNING_PVT.Update_DUNNING(

6722: l_dunning_rec_upd.currency_code := l_curr_code;
6723: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec_upd.amount_due_remaining == ' ||l_dunning_rec_upd.amount_due_remaining);
6724: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec_upd.currency_code == ' ||l_dunning_rec_upd.currency_code);
6725:
6726: IEX_DUNNING_PVT.Update_DUNNING(
6727: p_api_version => 1.0
6728: , p_init_msg_list => FND_API.G_FALSE
6729: , p_commit => FND_API.G_TRUE
6730: , p_dunning_rec => l_dunning_rec_upd

Line 7036: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

7032: nIdx NUMBER := 0;
7033: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
7034: INDEX BY BINARY_INTEGER;
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;

Line 7037: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

7033: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
7034: INDEX BY BINARY_INTEGER;
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;

Line 7849: IEX_DUNNING_PVT.Update_DUNNING(p_api_version => 1.0

7845: else
7846: l_dunning_rec_upd.xml_request_id := l_request_id;
7847: end if;
7848:
7849: IEX_DUNNING_PVT.Update_DUNNING(p_api_version => 1.0
7850: , p_init_msg_list => FND_API.G_TRUE
7851: , p_commit => FND_API.G_TRUE
7852: , p_dunning_rec => l_dunning_rec_upd
7853: , x_return_status => l_return_status

Line 8060: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

8056: nIdx NUMBER := 0;
8057: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
8058: INDEX BY BINARY_INTEGER;
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;

Line 8061: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

8057: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
8058: INDEX BY BINARY_INTEGER;
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;

Line 9007: IEX_DUNNING_PVT.Update_DUNNING(p_api_version => 1.0

9003: else
9004: l_dunning_rec_upd.xml_request_id := l_request_id;
9005: end if;
9006:
9007: IEX_DUNNING_PVT.Update_DUNNING(p_api_version => 1.0
9008: , p_init_msg_list => FND_API.G_TRUE
9009: , p_commit => FND_API.G_TRUE
9010: , p_dunning_rec => l_dunning_rec_upd
9011: , x_return_status => l_return_status

Line 9257: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

9253: nIdx NUMBER := 0;
9254: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
9255: INDEX BY BINARY_INTEGER;
9256: Del_Tbl Del_ID_TBL_TYPE;
9257: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
9258: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
9259: l_org_id NUMBER ;
9260: l_running_level VARCHAR2(25);
9261: l_object_Code VARCHAR2(25);

Line 9258: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

9254: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
9255: INDEX BY BINARY_INTEGER;
9256: Del_Tbl Del_ID_TBL_TYPE;
9257: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
9258: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
9259: l_org_id NUMBER ;
9260: l_running_level VARCHAR2(25);
9261: l_object_Code VARCHAR2(25);
9262: l_object_id NUMBER;

Line 10304: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

10300: nIdx NUMBER := 0;
10301: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
10302: INDEX BY BINARY_INTEGER;
10303: Del_Tbl Del_ID_TBL_TYPE;
10304: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
10305: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
10306: l_org_id NUMBER ;
10307: l_running_level VARCHAR2(25);
10308: l_object_Code VARCHAR2(25);

Line 10305: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

10301: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
10302: INDEX BY BINARY_INTEGER;
10303: Del_Tbl Del_ID_TBL_TYPE;
10304: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
10305: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
10306: l_org_id NUMBER ;
10307: l_running_level VARCHAR2(25);
10308: l_object_Code VARCHAR2(25);
10309: l_object_id NUMBER;

Line 11270: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

11266: nIdx NUMBER := 0;
11267: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
11268: INDEX BY BINARY_INTEGER;
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;

Line 11271: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

11267: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
11268: INDEX BY BINARY_INTEGER;
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;

Line 12058: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

12054: nIdx NUMBER := 0;
12055: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
12056: INDEX BY BINARY_INTEGER;
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;

Line 12059: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

12055: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
12056: INDEX BY BINARY_INTEGER;
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;

Line 13490: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

13486: */
13487: Procedure Send_Fulfillment(p_api_version IN NUMBER := 1.0,
13488: p_init_msg_list IN VARCHAR2 ,
13489: p_commit IN VARCHAR2 ,
13490: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
13491: p_template_id IN NUMBER,
13492: p_method IN VARCHAR2,
13493: p_party_id IN NUMBER,
13494: p_user_id IN NUMBER ,

Line 14002: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

13998: p_init_msg_list IN VARCHAR2 ,
13999: p_commit IN VARCHAR2 ,
14000: p_resend IN VARCHAR2 ,
14001: p_request_id IN NUMBER,
14002: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
14003: p_template_id IN NUMBER,
14004: p_method IN VARCHAR2,
14005: p_party_id IN NUMBER,
14006: p_user_id IN NUMBER ,

Line 14078: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

14074: CURSOR c_get_resend_query_data(p_query_temp_id number) is
14075: select query_id from IEX_QUERY_TEMP_XREF
14076: where query_temp_id = p_query_temp_id;
14077:
14078: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
14079: --
14080: l_api_name CONSTANT VARCHAR2(30) := 'Send_XML';
14081: l_api_version NUMBER := 1.0;
14082: l_commit VARCHAR2(5) ;

Line 14518: IEX_DUNNING_PVT.Update_DUNNING(

14514:
14515: if l_dunning_upd_rec.xml_request_id is not null then
14516: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Update dunning Row with xml request id');
14517:
14518: IEX_DUNNING_PVT.Update_DUNNING(
14519: p_api_version => 1.0
14520: , p_init_msg_list => FND_API.G_FALSE
14521: , p_commit => FND_API.G_TRUE
14522: , p_dunning_rec => l_dunning_upd_rec

Line 14878: IEX_DUNNING_PVT.Update_DUNNING(

14874:
14875: if l_dunning_upd_rec.xml_request_id is not null then
14876: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Update dunning Row with xml request id');
14877:
14878: IEX_DUNNING_PVT.Update_DUNNING(
14879: p_api_version => 1.0
14880: , p_init_msg_list => FND_API.G_FALSE
14881: , p_commit => FND_API.G_TRUE
14882: , p_dunning_rec => l_dunning_upd_rec

Line 14947: IEX_DUNNING_PVT.Update_DUNNING(

14943:
14944: if l_dunning_rec.DUNNING_ID is not null then
14945: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateRow');
14946:
14947: IEX_DUNNING_PVT.Update_DUNNING(
14948: p_api_version => 1.0
14949: , p_init_msg_list => FND_API.G_FALSE
14950: , p_commit => FND_API.G_TRUE
14951: , p_dunning_rec => l_dunning_rec

Line 15760: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

15756: );
15757: END GetContactPoint;
15758:
15759: Procedure CHK_QUERY_DATA( p_query_id IN NUMBER,
15760: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
15761: x_keep_flag OUT NOCOPY NUMBER)
15762: IS
15763: CURSOR C_GET_QUERY (IN_ID NUMBER) IS
15764: SELECT upper(query_string)

Line 18147: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

18143: IS
18144: l_object_type varchar2(20);
18145: l_object_id number;
18146: l_send_method varchar2(10);
18147: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
18148: l_request_id number := 0;
18149: l_source_id number;
18150: l_template_id number;
18151: l_cust_trx_id number;

Line 18303: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' calling iex_dunning_pvt.send_xml');

18299: when others then
18300: WriteLog(G_PKG_NAME || ' ' || l_api_name || sqlerrm);
18301: end;
18302:
18303: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' calling iex_dunning_pvt.send_xml');
18304:
18305: send_xml(
18306: p_api_version => 1.0,
18307: p_init_msg_list => 'T',

Line 19067: END IEX_DUNNING_PVT;

19063:
19064: BEGIN
19065: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
19066:
19067: END IEX_DUNNING_PVT;