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.8.12010000.3 2008/11/21 10:34:09 barathsr 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 578: PROCEDURE VALIDATE_INSERT_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE)

574: x_broken_on_date := l_broken_on_date;
575: end;
576:
577:
578: PROCEDURE VALIDATE_INSERT_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE)
579: IS
580: Type refCur is Ref Cursor;
581:
582: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_INSERT_INPUT';

Line 1051: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE,

1047: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1048: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1049: X_MSG_COUNT OUT NOCOPY NUMBER,
1050: X_MSG_DATA OUT NOCOPY VARCHAR2,
1051: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE,
1052: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1053: IS
1054: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_PROMISE';
1055: l_api_version CONSTANT NUMBER := 1.0;

Line 1052: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)

1048: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1049: X_MSG_COUNT OUT NOCOPY NUMBER,
1050: X_MSG_DATA OUT NOCOPY VARCHAR2,
1051: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE,
1052: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1053: IS
1054: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_PROMISE';
1055: l_api_version CONSTANT NUMBER := 1.0;
1056: l_return_status VARCHAR2(1);

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

1381: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1382:
1383: END;
1384:
1385: PROCEDURE VALIDATE_UPDATE_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE)
1386: IS
1387: Type refCur is Ref Cursor;
1388:
1389: l_validation_item varchar2(100);

Line 1677: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE,

1673: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1674: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1675: X_MSG_COUNT OUT NOCOPY NUMBER,
1676: X_MSG_DATA OUT NOCOPY VARCHAR2,
1677: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE,
1678: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1679: IS
1680: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROMISE';
1681: l_api_version CONSTANT NUMBER := 1.0;

Line 1678: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)

1674: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1675: X_MSG_COUNT OUT NOCOPY NUMBER,
1676: X_MSG_DATA OUT NOCOPY VARCHAR2,
1677: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE,
1678: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1679: IS
1680: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROMISE';
1681: l_api_version CONSTANT NUMBER := 1.0;
1682: l_return_status VARCHAR2(1);

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

1931:
1932: END;
1933:
1934:
1935: PROCEDURE VALIDATE_CANCEL_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE)
1936: IS
1937: l_validation_item varchar2(100);
1938: l_procedure varchar2(50); -- := 'VALIDATE_CANCEL_INPUT';
1939:

Line 1986: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE,

1982: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1983: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1984: X_MSG_COUNT OUT NOCOPY NUMBER,
1985: X_MSG_DATA OUT NOCOPY VARCHAR2,
1986: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE,
1987: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1988: IS
1989: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PROMISE';
1990: l_api_version CONSTANT NUMBER := 1.0;

Line 1987: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)

1983: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1984: X_MSG_COUNT OUT NOCOPY NUMBER,
1985: X_MSG_DATA OUT NOCOPY VARCHAR2,
1986: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE,
1987: X_PRORESP_REC OUT NOCOPY IEX_PROMISES_PUB.PRO_RESP_REC_TYPE)
1988: IS
1989: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PROMISE';
1990: l_api_version CONSTANT NUMBER := 1.0;
1991: l_return_status VARCHAR2(1);

Line 2208: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE)

2204:
2205:
2206: PROCEDURE VALIDATE_MASS_INPUT(
2207: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2208: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE)
2209: IS
2210: Type refCur is Ref Cursor;
2211:
2212: l_cursor refCur;

Line 2356: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,

2352: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2353: X_MSG_COUNT OUT NOCOPY NUMBER,
2354: X_MSG_DATA OUT NOCOPY VARCHAR2,
2355: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2356: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,
2357: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)
2358: IS
2359: l_api_name CONSTANT VARCHAR2(30) := 'MASS_PROMISE';
2360: l_api_version CONSTANT NUMBER := 1.0;

Line 2357: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)

2353: X_MSG_COUNT OUT NOCOPY NUMBER,
2354: X_MSG_DATA OUT NOCOPY VARCHAR2,
2355: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2356: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,
2357: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)
2358: IS
2359: l_api_name CONSTANT VARCHAR2(30) := 'MASS_PROMISE';
2360: l_api_version CONSTANT NUMBER := 1.0;
2361: l_return_status VARCHAR2(1);