DBA Data[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on INV_MAINTAIN_RESERVATION_PUB

Line 1: PACKAGE BODY INV_MAINTAIN_RESERVATION_PUB AS

1: PACKAGE BODY INV_MAINTAIN_RESERVATION_PUB AS
2: /* $Header: INVPMRVB.pls 120.43.12020000.6 2013/02/27 04:54:31 tachen ship $*/
3:
4: g_dummy_sn_tbl inv_reservation_global.serial_number_tbl_type;
5:

Line 10: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MAINTAIN_RESERVATION_PUB';

6: -- CodeReview.SU.03 Define a global variable for l_Debug
7: g_debug Number := Nvl(Fnd_Profile.Value('INV_DEBUG_TRACE'),0);
8:
9:
10: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MAINTAIN_RESERVATION_PUB';
11: g_version_printed BOOLEAN := FALSE;
12: -- Global Constants for variables used in FND Log
13: -- CodeReview.SU.01 : Commenting following constants
14: -- G_statement_level constant number := FND_LOG.LEVEL_STATEMENT;

Line 1288: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub';

1284:
1285: -- define constants for api version and api name
1286: c_api_version_number constant number := 1.0;
1287: c_api_name constant varchar2(30) := 'build_res_rec';
1288: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub';
1289: c_debug_enabled constant number := 1 ;
1290: l_fnd_log_message varchar2(2000);
1291:
1292: l_rsv inv_reservation_global.mtl_reservation_rec_type;

Line 1430: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

1426:
1427: -- define constants for api version and api name
1428: c_api_version_number constant number := 1.0;
1429: c_api_name constant varchar2(30) := 'create_res';
1430: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1431: c_debug_enabled constant number := 1 ;
1432:
1433: --l_debug number := nvl(fnd_profile.value('inv_debug_trace'), 0);
1434: l_fnd_log_message varchar2(2000);

Line 1705: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

1701: IS
1702: -- Define Constants for API version and API name
1703: C_api_version_number CONSTANT NUMBER := 1.0;
1704: C_api_name CONSTANT VARCHAR2(30) := 'QUERY_RES';
1705: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1706: C_Debug_Enabled Constant Number := 1 ;
1707:
1708: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1709: l_Fnd_Log_Message VARCHAR2(2000);

Line 1971: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

1967: RETURN BOOLEAN IS
1968: -- Define Constants for API version and API name
1969: C_api_version_number CONSTANT NUMBER := 1.0;
1970: C_api_name CONSTANT VARCHAR2(30) := 'EXISTS_RESERVATION';
1971: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1972: C_Debug_Enabled Constant Number := 1 ;
1973:
1974: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1975: l_Fnd_Log_Message VARCHAR2(2000);

Line 2079: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

2075: IS
2076: -- Define Constants for API version and API name
2077: C_api_version_number CONSTANT NUMBER := 1.0;
2078: C_api_name CONSTANT VARCHAR2(30) := 'GET_REQ_LINE_RES';
2079: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2080: C_Debug_Enabled Constant Number := 1 ;
2081:
2082: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2083: l_Fnd_Log_Message VARCHAR2(2000);

Line 2191: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

2187:
2188: -- Define Constants for API version and API name
2189: C_api_version_number CONSTANT NUMBER := 1.0;
2190: C_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RES';
2191: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2192: C_Debug_Enabled Constant Number := 1 ;
2193:
2194: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2195: l_Fnd_Log_Message VARCHAR2(2000);

Line 2446: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

2442:
2443: -- Define Constants for API version and API name
2444: C_api_version_number CONSTANT NUMBER := 1.0;
2445: C_api_name CONSTANT VARCHAR2(30) := 'TRANSFER_RES';
2446: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2447: C_Debug_Enabled Constant Number := 1 ;
2448:
2449: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2450: l_Fnd_Log_Message VARCHAR2(2000);

Line 2753: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

2749: IS
2750: -- Define Constants for API version and API name
2751: C_api_version_number CONSTANT NUMBER := 1.0;
2752: C_api_name CONSTANT VARCHAR2(30) := 'DELETE_RES';
2753: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2754: C_Debug_Enabled Constant Number := 1 ;
2755:
2756: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2757: l_Fnd_Log_Message VARCHAR2(2000);

Line 2992: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';

2988: IS
2989: -- Define Constants for API version and API name
2990: C_api_version_number CONSTANT NUMBER := 1.0;
2991: C_api_name CONSTANT VARCHAR2(30) := 'UOM_CONVERSION';
2992: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2993: C_Debug_Enabled Constant Number := 1 ;
2994:
2995: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2996: l_fnd_log_message VARCHAR2(2000);

Line 6559: END INV_MAINTAIN_RESERVATION_PUB;

6555:
6556: END MAINTAIN_RESERVATION;
6557:
6558:
6559: END INV_MAINTAIN_RESERVATION_PUB;