APPS.CSL_HZ_PARTIES_ACC_PKG dependencies on DBMS_SQL

Line 236: l_tab_resource_id dbms_sql.Number_Table;

232: *
233: */
234: PROCEDURE UPDATE_PARTY( p_party_id IN NUMBER )
235: IS
236: l_tab_resource_id dbms_sql.Number_Table;
237: l_tab_access_id dbms_sql.Number_Table;
238: BEGIN
239: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
240: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 237: l_tab_access_id dbms_sql.Number_Table;

233: */
234: PROCEDURE UPDATE_PARTY( p_party_id IN NUMBER )
235: IS
236: l_tab_resource_id dbms_sql.Number_Table;
237: l_tab_access_id dbms_sql.Number_Table;
238: BEGIN
239: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
240: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
241: jtm_message_log_pkg.Log_Msg

Line 420: l_tab_resource_id dbms_sql.Number_Table;

416: */
417: PROCEDURE POST_UPDATE_PARTY ( x_return_status OUT NOCOPY varchar2)
418: IS
419: l_party_id NUMBER;
420: l_tab_resource_id dbms_sql.Number_Table;
421: l_tab_access_id dbms_sql.Number_Table;
422: BEGIN
423: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
424:

Line 421: l_tab_access_id dbms_sql.Number_Table;

417: PROCEDURE POST_UPDATE_PARTY ( x_return_status OUT NOCOPY varchar2)
418: IS
419: l_party_id NUMBER;
420: l_tab_resource_id dbms_sql.Number_Table;
421: l_tab_access_id dbms_sql.Number_Table;
422: BEGIN
423: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
424:
425: /*TODO get the party id from the hook api*/