DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on IEX_PROMISES_PUB

Line 1: PACKAGE BODY IEX_PROMISES_PUB as

1: PACKAGE BODY IEX_PROMISES_PUB as
2: /* $Header: iexpyprb.pls 120.15.12020000.4 2012/07/23 09:25:36 sunagesh ship $ */
3:
4: PG_DEBUG NUMBER; -- := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_PROMISES_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_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpyprb.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 593: PROCEDURE VALIDATE_INSERT_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE)

589: x_broken_on_date := l_broken_on_date;
590: end;
591:
592:
593: PROCEDURE VALIDATE_INSERT_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE)
594: IS
595: Type refCur is Ref Cursor;
596:
597: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_INSERT_INPUT';

Line 1066: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE,

1062: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1063: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1064: X_MSG_COUNT OUT NOCOPY NUMBER,
1065: X_MSG_DATA OUT NOCOPY VARCHAR2,
1066: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE,
1067: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1068: IS
1069: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_PROMISE';
1070: l_api_version CONSTANT NUMBER := 1.0;

Line 1067: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)

1063: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1064: X_MSG_COUNT OUT NOCOPY NUMBER,
1065: X_MSG_DATA OUT NOCOPY VARCHAR2,
1066: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE,
1067: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1068: IS
1069: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_PROMISE';
1070: l_api_version CONSTANT NUMBER := 1.0;
1071: l_return_status VARCHAR2(1);

Line 1424: PROCEDURE VALIDATE_UPDATE_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE)

1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422: END;
1423:
1424: PROCEDURE VALIDATE_UPDATE_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE)
1425: IS
1426: Type refCur is Ref Cursor;
1427:
1428: l_validation_item varchar2(100);

Line 1716: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE,

1712: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1713: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1714: X_MSG_COUNT OUT NOCOPY NUMBER,
1715: X_MSG_DATA OUT NOCOPY VARCHAR2,
1716: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE,
1717: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1718: IS
1719: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROMISE';
1720: l_api_version CONSTANT NUMBER := 1.0;

Line 1717: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)

1713: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1714: X_MSG_COUNT OUT NOCOPY NUMBER,
1715: X_MSG_DATA OUT NOCOPY VARCHAR2,
1716: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE,
1717: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1718: IS
1719: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROMISE';
1720: l_api_version CONSTANT NUMBER := 1.0;
1721: l_return_status VARCHAR2(1);

Line 1997: PROCEDURE VALIDATE_CANCEL_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE)

1993:
1994: END;
1995:
1996:
1997: PROCEDURE VALIDATE_CANCEL_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE)
1998: IS
1999: l_validation_item varchar2(100);
2000: l_procedure varchar2(50); -- := 'VALIDATE_CANCEL_INPUT';
2001:

Line 2048: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE,

2044: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2045: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2046: X_MSG_COUNT OUT NOCOPY NUMBER,
2047: X_MSG_DATA OUT NOCOPY VARCHAR2,
2048: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE,
2049: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
2050: IS
2051: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PROMISE';
2052: l_api_version CONSTANT NUMBER := 1.0;

Line 2049: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)

2045: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2046: X_MSG_COUNT OUT NOCOPY NUMBER,
2047: X_MSG_DATA OUT NOCOPY VARCHAR2,
2048: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE,
2049: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
2050: IS
2051: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PROMISE';
2052: l_api_version CONSTANT NUMBER := 1.0;
2053: l_return_status VARCHAR2(1);

Line 2309: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE)

2305:
2306:
2307: PROCEDURE VALIDATE_MASS_INPUT(
2308: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2309: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE)
2310: IS
2311: Type refCur is Ref Cursor;
2312:
2313: l_cursor refCur;

Line 2457: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,

2453: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2454: X_MSG_COUNT OUT NOCOPY NUMBER,
2455: X_MSG_DATA OUT NOCOPY VARCHAR2,
2456: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2457: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,
2458: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)
2459: IS
2460: l_api_name CONSTANT VARCHAR2(30) := 'MASS_PROMISE';
2461: l_api_version CONSTANT NUMBER := 1.0;

Line 2458: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)

2454: X_MSG_COUNT OUT NOCOPY NUMBER,
2455: X_MSG_DATA OUT NOCOPY VARCHAR2,
2456: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2457: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,
2458: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)
2459: IS
2460: l_api_name CONSTANT VARCHAR2(30) := 'MASS_PROMISE';
2461: l_api_version CONSTANT NUMBER := 1.0;
2462: l_return_status VARCHAR2(1);