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_PROMISES_BATCH_PUB dependencies on IEX_PROMISES_BATCH_PUB

Line 1: PACKAGE BODY IEX_PROMISES_BATCH_PUB as

1: PACKAGE BODY IEX_PROMISES_BATCH_PUB as
2: /* $Header: iexpyrbb.pls 120.22.12020000.4 2012/10/19 17:30:20 sunagesh ship $ */
3:
4: PG_DEBUG NUMBER; -- := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PROMISES_BATCH_PUB';

3:
4: PG_DEBUG NUMBER; -- := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: G_APP_ID CONSTANT NUMBER := 695;
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PROMISES_BATCH_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpyrbb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;

Line 110: P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.GET_CALLBACK_DATE',

106: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
107: /*
108: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
109: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
110: P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.GET_CALLBACK_DATE',
111: P_MESSAGE => 'Cannot Get Callback_Date. Assing sysdate.' );
112: */
113: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
114:

Line 519: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES',

515: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
516: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
517: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
518: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
519: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES',
520: -- P_MESSAGE => 'Failed to close promises.' );
521: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 532: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES',

528: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
529: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
530: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
531: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
532: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES',
533: -- P_MESSAGE => 'Failed to close promises.' );
534: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
535: WHEN OTHERS THEN
536: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 548: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES',

544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
545: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
546: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
547: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
548: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES',
549: -- P_MESSAGE => 'Failed to close promises.' );
550: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
551: */
552: END;

Line 1147: l_appl_tbl IEX_PROMISES_BATCH_PUB.REVERSE_APPLS_TBL;

1143: l_msg_data VARCHAR2(32767);
1144: vSQL varchar2(10000);
1145: Type refCur is Ref Cursor;
1146: promises_cur refCur;
1147: l_appl_tbl IEX_PROMISES_BATCH_PUB.REVERSE_APPLS_TBL;
1148: i NUMBER;
1149: nCount NUMBER;
1150: l_promise_detail_id NUMBER;
1151: l_promise_date DATE;

Line 1541: l_pro_tbl IEX_PROMISES_BATCH_PUB.PROMISES_TBL;

1537: Type refCur is Ref Cursor;
1538: promise_cur refCur;
1539: y NUMBER;
1540: nCount NUMBER;
1541: l_pro_tbl IEX_PROMISES_BATCH_PUB.PROMISES_TBL;
1542:
1543: l_PROMISE_DETAIL_ID NUMBER;
1544: l_CREATION_DATE DATE;
1545: l_PROMISE_DATE DATE;

Line 1936: P_PROMISES_TBL IN OUT NOCOPY IEX_PROMISES_BATCH_PUB.PROMISES_TBL,

1932: P_VALIDATION_LEVEL IN NUMBER,
1933: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1934: X_MSG_COUNT OUT NOCOPY NUMBER,
1935: X_MSG_DATA OUT NOCOPY VARCHAR2,
1936: P_PROMISES_TBL IN OUT NOCOPY IEX_PROMISES_BATCH_PUB.PROMISES_TBL,
1937: P_TYPE IN VARCHAR2)
1938: IS
1939: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_PROMISES_FIFO';
1940: l_api_version CONSTANT NUMBER := 1.0;

Line 1956: l_appl_tbl IEX_PROMISES_BATCH_PUB.APPLS_TBL;

1952: l_adj_remaining_amount NUMBER;
1953: -- End bug 3635087 gnramasa 10/07/07
1954: Type refCur is Ref Cursor;
1955: appl_cur refCur;
1956: l_appl_tbl IEX_PROMISES_BATCH_PUB.APPLS_TBL;
1957: i NUMBER;
1958: y NUMBER;
1959: x NUMBER;
1960: nCount NUMBER;

Line 3337: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',

3333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3334: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3335: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3336: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3337: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',
3338: -- P_MESSAGE => 'Failed to reopen promises.' );
3339: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3341: ROLLBACK TO REOPEN_PROMISES_PVT;

Line 3347: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',

3343: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3344: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3345: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3346: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3347: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',
3348: -- P_MESSAGE => 'Failed to reopen promises.' );
3349: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3350: WHEN OTHERS THEN
3351: ROLLBACK TO REOPEN_PROMISES_PVT;

Line 3360: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',

3356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3357: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3358: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3359: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3360: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',
3361: -- P_MESSAGE => 'Failed to reopen promises.' );
3362: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3363: */
3364: END;