APPS.CSL_HZ_LOCATIONS_ACC_PKG dependencies on DBMS_SQL

Line 54: l_tab_resource_id dbms_sql.Number_Table;

50: END INSERT_LOCATION;
51:
52: PROCEDURE UPDATE_LOCATION( p_location_id IN NUMBER )
53: IS
54: l_tab_resource_id dbms_sql.Number_Table;
55: l_tab_access_id dbms_sql.Number_Table;
56: BEGIN
57: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
58: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 55: l_tab_access_id dbms_sql.Number_Table;

51:
52: PROCEDURE UPDATE_LOCATION( p_location_id IN NUMBER )
53: IS
54: l_tab_resource_id dbms_sql.Number_Table;
55: l_tab_access_id dbms_sql.Number_Table;
56: BEGIN
57: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
58: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
59: jtm_message_log_pkg.Log_Msg