DBA Data[Home] [Help]

APPS.IEX_DUNNING_PUB dependencies on IEX_DUNNING_PUB

Line 1: PACKAGE BODY IEX_DUNNING_PUB AS

1: PACKAGE BODY IEX_DUNNING_PUB AS
2: /* $Header: iexpdunb.pls 120.11.12010000.3 2008/09/01 09:54:40 gnramasa ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PUB';

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

1: PACKAGE BODY IEX_DUNNING_PUB AS
2: /* $Header: iexpdunb.pls 120.11.12010000.3 2008/09/01 09:54:40 gnramasa ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PUB';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpdunb.pls';
7:
8: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
9: PG_DEBUG NUMBER ;

Line 27: P_AG_DN_XREF_TBL IN IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE ,

23: Procedure Create_AG_DN_XREF
24: (p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 ,
26: p_commit IN VARCHAR2 ,
27: P_AG_DN_XREF_TBL IN IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE ,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: x_AG_DN_XREF_ID_TBL OUT NOCOPY IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE)

Line 31: x_AG_DN_XREF_ID_TBL OUT NOCOPY IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE)

27: P_AG_DN_XREF_TBL IN IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE ,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: x_AG_DN_XREF_ID_TBL OUT NOCOPY IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE)
32:
33: IS
34: l_api_name CONSTANT VARCHAR2(30) := 'Create_AG_DN_XREF';
35: l_api_version_number CONSTANT NUMBER := 1.0;

Line 40: l_AG_DN_XREF_rec IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;

36: l_return_status VARCHAR2(1);
37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(32767);
39: errmsg VARCHAR2(32767);
40: l_AG_DN_XREF_rec IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;
41: x_ag_dn_xref_id NUMBER;
42: l_AG_DN_XREF_ID_TBL IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE;
43:
44:

Line 42: l_AG_DN_XREF_ID_TBL IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE;

38: l_msg_data VARCHAR2(32767);
39: errmsg VARCHAR2(32767);
40: l_AG_DN_XREF_rec IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;
41: x_ag_dn_xref_id NUMBER;
42: l_AG_DN_XREF_ID_TBL IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE;
43:
44:
45: BEGIN
46: -- Standard Start of API savepoint

Line 162: P_AG_DN_XREF_TBL IN IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE ,

158: Procedure Update_AG_DN_XREF
159: (p_api_version IN NUMBER := 1.0,
160: p_init_msg_list IN VARCHAR2 ,
161: p_commit IN VARCHAR2 ,
162: P_AG_DN_XREF_TBL IN IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE ,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2)
166: IS

Line 173: l_AG_DN_XREF_rec IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;

169: l_return_status VARCHAR2(1);
170: l_msg_count NUMBER;
171: l_msg_data VARCHAR2(32767);
172: errmsg VARCHAR2(32767);
173: l_AG_DN_XREF_rec IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
174:
175: BEGIN
176:
177: -- Standard Start of API savepoint

Line 719: P_Procedure_name => 'IEX_DUNNING_PUB.SEND_DUNNING',

715: */
716: /*
717: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
718: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
719: P_Procedure_name => 'IEX_DUNNING_PUB.SEND_DUNNING',
720: P_MESSAGE => 'NO Delinquencies');
721: */
722: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
723: /*

Line 1266: --p_dunning_tbl IN IEX_DUNNING_PUB.DUNNING_TBL_TYPE,

1262: Procedure Daily_Dunning
1263: (p_api_version IN NUMBER := 1.0,
1264: p_init_msg_list IN VARCHAR2 ,
1265: p_commit IN VARCHAR2 ,
1266: --p_dunning_tbl IN IEX_DUNNING_PUB.DUNNING_TBL_TYPE,
1267: p_running_level IN VARCHAR2 ,
1268: x_return_status OUT NOCOPY VARCHAR2,
1269: x_msg_count OUT NOCOPY NUMBER,
1270: x_msg_data OUT NOCOPY VARCHAR2)

Line 1474: IEX_DUNNING_PUB.Daily_Dunning(

1470: --
1471: else
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Dunning Callbacks');
1473: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - starting Daily_Dunning');
1474: IEX_DUNNING_PUB.Daily_Dunning(
1475: p_api_version => l_api_version
1476: , p_init_msg_list => FND_API.G_TRUE
1477: , p_commit => FND_API.G_TRUE
1478: , p_running_level => l_running_level

Line 1656: IEX_DUNNING_PUB.SEND_DUNNING(

1652: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - runninglevel='||l_running_level);
1653: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - bucket='||l_bucket);
1654: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - starting Send_Dunning');
1655: END IF;
1656: IEX_DUNNING_PUB.SEND_DUNNING(
1657: p_api_version => l_api_version
1658: , p_init_msg_list => FND_API.G_TRUE
1659: , p_commit => FND_API.G_TRUE
1660: , p_running_level => l_running_level

Line 1711: END IEX_DUNNING_PUB;

1707:
1708: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1709:
1710:
1711: END IEX_DUNNING_PUB;