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.26.12010000.3 2009/01/14 19:57:03 athammin 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 1313: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub';

1309:
1310: -- define constants for api version and api name
1311: c_api_version_number constant number := 1.0;
1312: c_api_name constant varchar2(30) := 'build_res_rec';
1313: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub';
1314: c_debug_enabled constant number := 1 ;
1315: l_fnd_log_message varchar2(2000);
1316:
1317: l_rsv inv_reservation_global.mtl_reservation_rec_type;

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

1451:
1452: -- define constants for api version and api name
1453: c_api_version_number constant number := 1.0;
1454: c_api_name constant varchar2(30) := 'create_res';
1455: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1456: c_debug_enabled constant number := 1 ;
1457:
1458: --l_debug number := nvl(fnd_profile.value('inv_debug_trace'), 0);
1459: l_fnd_log_message varchar2(2000);

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

1726: IS
1727: -- Define Constants for API version and API name
1728: C_api_version_number CONSTANT NUMBER := 1.0;
1729: C_api_name CONSTANT VARCHAR2(30) := 'QUERY_RES';
1730: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1731: C_Debug_Enabled Constant Number := 1 ;
1732:
1733: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1734: l_Fnd_Log_Message VARCHAR2(2000);

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

1992: RETURN BOOLEAN IS
1993: -- Define Constants for API version and API name
1994: C_api_version_number CONSTANT NUMBER := 1.0;
1995: C_api_name CONSTANT VARCHAR2(30) := 'EXISTS_RESERVATION';
1996: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1997: C_Debug_Enabled Constant Number := 1 ;
1998:
1999: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2000: l_Fnd_Log_Message VARCHAR2(2000);

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

2100: IS
2101: -- Define Constants for API version and API name
2102: C_api_version_number CONSTANT NUMBER := 1.0;
2103: C_api_name CONSTANT VARCHAR2(30) := 'GET_REQ_LINE_RES';
2104: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2105: C_Debug_Enabled Constant Number := 1 ;
2106:
2107: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2108: l_Fnd_Log_Message VARCHAR2(2000);

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

2212:
2213: -- Define Constants for API version and API name
2214: C_api_version_number CONSTANT NUMBER := 1.0;
2215: C_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RES';
2216: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2217: C_Debug_Enabled Constant Number := 1 ;
2218:
2219: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2220: l_Fnd_Log_Message VARCHAR2(2000);

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

2466:
2467: -- Define Constants for API version and API name
2468: C_api_version_number CONSTANT NUMBER := 1.0;
2469: C_api_name CONSTANT VARCHAR2(30) := 'TRANSFER_RES';
2470: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2471: C_Debug_Enabled Constant Number := 1 ;
2472:
2473: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2474: l_Fnd_Log_Message VARCHAR2(2000);

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

2763: IS
2764: -- Define Constants for API version and API name
2765: C_api_version_number CONSTANT NUMBER := 1.0;
2766: C_api_name CONSTANT VARCHAR2(30) := 'DELETE_RES';
2767: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2768: C_Debug_Enabled Constant Number := 1 ;
2769:
2770: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2771: l_Fnd_Log_Message VARCHAR2(2000);

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

3002: IS
3003: -- Define Constants for API version and API name
3004: C_api_version_number CONSTANT NUMBER := 1.0;
3005: C_api_name CONSTANT VARCHAR2(30) := 'UOM_CONVERSION';
3006: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
3007: C_Debug_Enabled Constant Number := 1 ;
3008:
3009: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3010: l_fnd_log_message VARCHAR2(2000);

Line 6311: END INV_MAINTAIN_RESERVATION_PUB;

6307:
6308: END MAINTAIN_RESERVATION;
6309:
6310:
6311: END INV_MAINTAIN_RESERVATION_PUB;