202: , P_RESOURCE_ID => l_resource_id
203: );
204:
205: -- HZ_PARTY_SITES ( ALSO HZ_LOCATIONS IS FILLED BY THIS HOOK )
206: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( r_location_ids.HPS_ID, l_resource_id );
207: END IF;
208: CLOSE c_location_ids;
209:
210: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
332: ,l_resource_id
333: ,l_pla_acc_id
334: );
335: -- HZ_PARTY_SITES
336: CSL_HZ_PARTY_SITES_ACC_PKG.UPDATE_PARTY_SITE( r_location_ids.HPS_ID );
337:
338: -- HZ_LOCATIONS
339: CSL_HZ_LOCATIONS_ACC_PKG.UPDATE_LOCATION( r_location_ids.HZL_ID );
340: END IF;
469: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
470: jtm_message_log_pkg.Log_Msg
471: ( p_resource_id
472: , g_table_name
473: , 'Calling CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site'
474: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
475: END IF;
476:
477: CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site( r_location_ids.HPS_ID, p_resource_id );
473: , 'Calling CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site'
474: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
475: END IF;
476:
477: CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site( r_location_ids.HPS_ID, p_resource_id );
478: END IF;
479: CLOSE c_location_ids;
480:
481: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN