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.34.12010000.3 2008/11/21 10:03:19 barathsr ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PVT';

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

1: PACKAGE BODY IEX_DUNNING_PVT AS
2: /* $Header: iexvdunb.pls 120.34.12010000.3 2008/11/21 10:03:19 barathsr ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PVT';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvdunb.pls';
7:
8: PG_DEBUG NUMBER ;
9:

Line 1470: p_fulfillment_bind_tbl in out nocopy IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

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

Line 1477: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

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

Line 3103: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

3099: nIdx NUMBER := 0;
3100: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
3101: INDEX BY BINARY_INTEGER;
3102: Del_Tbl Del_ID_TBL_TYPE;
3103: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
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;

Line 3104: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

3100: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
3101: INDEX BY BINARY_INTEGER;
3102: Del_Tbl Del_ID_TBL_TYPE;
3103: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
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;

Line 3633: IEX_DUNNING_PVT.Update_DUNNING(

3629: else
3630: l_dunning_rec_upd.xml_request_id := l_request_id;
3631: end if;
3632:
3633: IEX_DUNNING_PVT.Update_DUNNING(
3634: p_api_version => 1.0
3635: , p_init_msg_list => FND_API.G_FALSE
3636: , p_commit => FND_API.G_TRUE
3637: , p_dunning_rec => l_dunning_rec_upd

Line 3820: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

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

Line 3821: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

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

Line 4295: IEX_DUNNING_PVT.Update_DUNNING(p_api_version => 1.0

4291: else
4292: l_dunning_rec_upd.xml_request_id := l_request_id;
4293: end if;
4294:
4295: IEX_DUNNING_PVT.Update_DUNNING(p_api_version => 1.0
4296: , p_init_msg_list => FND_API.G_TRUE
4297: , p_commit => FND_API.G_TRUE
4298: , p_dunning_rec => l_dunning_rec_upd
4299: , x_return_status => l_return_status

Line 4460: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

4456: nIdx NUMBER := 0;
4457: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
4458: INDEX BY BINARY_INTEGER;
4459: Del_Tbl Del_ID_TBL_TYPE;
4460: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
4461: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
4462: l_org_id NUMBER ;
4463: l_running_level VARCHAR2(25);
4464: l_object_Code VARCHAR2(25);

Line 4461: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

4457: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
4458: INDEX BY BINARY_INTEGER;
4459: Del_Tbl Del_ID_TBL_TYPE;
4460: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
4461: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;
4462: l_org_id NUMBER ;
4463: l_running_level VARCHAR2(25);
4464: l_object_Code VARCHAR2(25);
4465: l_object_id NUMBER;

Line 5163: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

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

Line 5164: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

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

Line 6433: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

6429: */
6430: Procedure Send_Fulfillment(p_api_version IN NUMBER := 1.0,
6431: p_init_msg_list IN VARCHAR2 ,
6432: p_commit IN VARCHAR2 ,
6433: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
6434: p_template_id IN NUMBER,
6435: p_method IN VARCHAR2,
6436: p_party_id IN NUMBER,
6437: p_user_id IN NUMBER ,

Line 6949: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

6945: p_init_msg_list IN VARCHAR2 ,
6946: p_commit IN VARCHAR2 ,
6947: p_resend IN VARCHAR2 ,
6948: p_request_id IN NUMBER,
6949: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
6950: p_template_id IN NUMBER,
6951: p_method IN VARCHAR2,
6952: p_party_id IN NUMBER,
6953: p_user_id IN NUMBER ,

Line 7015: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;

7011: WHERE j.resource_id = p_resource_id;
7012: l_resource_user_id NUMBER;
7013: --Bug5233002. Fix by LKKUMAR on 31-May-2006. End.
7014:
7015: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
7016: --
7017: l_api_name CONSTANT VARCHAR2(30) := 'Send_XML';
7018: l_api_version NUMBER := 1.0;
7019: l_commit VARCHAR2(5) ;

Line 7484: IEX_DUNNING_PVT.Update_DUNNING(

7480:
7481: if l_dunning_rec.DUNNING_ID is not null then
7482: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateRow');
7483:
7484: IEX_DUNNING_PVT.Update_DUNNING(
7485: p_api_version => 1.0
7486: , p_init_msg_list => FND_API.G_FALSE
7487: , p_commit => FND_API.G_TRUE
7488: , p_dunning_rec => l_dunning_rec

Line 8255: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,

8251: END GetContactPoint;
8252:
8253:
8254: Procedure CHK_QUERY_DATA( p_query_id IN NUMBER,
8255: p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
8256: x_keep_flag OUT NOCOPY NUMBER)
8257: IS
8258: CURSOR C_GET_QUERY (IN_ID NUMBER) IS
8259: SELECT upper(query_string)

Line 10024: END IEX_DUNNING_PVT;

10020:
10021: BEGIN
10022: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10023:
10024: END IEX_DUNNING_PVT;