APPS.CSL_HZ_LOCATIONS_ACC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

PROCEDURE INSERT_LOCATION( p_location_id IN NUMBER
                         , p_resource_id IN NUMBER )
IS
BEGIN
  g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 22

    , 'Entering Insert_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 30

    , 'Inserting ACC record for resource_id = '||p_resource_id
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 34

  JTM_HOOK_UTIL_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     , P_ACC_TABLE_NAME         => g_acc_table_name
     , P_PK1_NAME               => g_pk1_name
     , P_PK1_NUM_VALUE          => p_location_id
     , P_RESOURCE_ID            => p_resource_id
     );

Line: 46

    , 'Leaving Insert_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 50

END INSERT_LOCATION;

Line: 52

PROCEDURE UPDATE_LOCATION( p_location_id IN NUMBER )
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 62

    , 'Entering Update_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 87

        JTM_HOOK_UTIL_PKG.Update_Acc
          ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
           ,P_ACC_TABLE_NAME         => g_acc_table_name
           ,P_RESOURCE_ID            => l_tab_resource_id(i)
           ,P_ACCESS_ID              => l_tab_access_id(i)
          );

Line: 104

END UPDATE_LOCATION;

Line: 106

PROCEDURE DELETE_LOCATION( p_location_id IN NUMBER
                         , p_resource_id IN NUMBER )
IS
BEGIN
 g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 115

    , 'Entering Delete_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 119

 JTM_HOOK_UTIL_PKG.Delete_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     ,P_ACC_TABLE_NAME         => g_acc_table_name
     ,P_PK1_NAME               => g_pk1_name
     ,P_PK1_NUM_VALUE          => p_location_id
     ,P_RESOURCE_ID            => p_resource_id
    );

Line: 131

    , 'Leaving Delete_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 135

END DELETE_LOCATION;

Line: 159

  /*Party site is changed so delete the old one ( basicly we lower the counter )*/
  JTM_HOOK_UTIL_PKG.Delete_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     ,P_ACC_TABLE_NAME         => g_acc_table_name
     ,P_PK1_NAME               => g_pk1_name
     ,P_PK1_NUM_VALUE          => p_old_location_id
     ,P_RESOURCE_ID            => p_resource_id
    );

Line: 168

  /*Insert the new party site*/
  JTM_HOOK_UTIL_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     , P_ACC_TABLE_NAME         => g_acc_table_name
     , P_PK1_NAME               => g_pk1_name
     , P_PK1_NUM_VALUE          => p_new_location_id
     , P_RESOURCE_ID            => p_resource_id
     );

Line: 187

FUNCTION UPDATE_LOCATION_WFSUB( p_subscription_guid   in     raw
               , p_event               in out NOCOPY wf_event_t)
return varchar2
IS
 l_key                    varchar2(240) := p_event.GetEventKey();

Line: 207

    , 'Entering UPDATE_LOCATION_WFSUB'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 242

  UPDATE_LOCATION(l_location_id);

Line: 249

    , 'Leaving UPDATE_LOCATION_WFSUB'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 257

     WF_CORE.CONTEXT('CSL_HZ_LOCATIONS_ACC_PKG', 'UPDATE_LOCATION_WFSUB', p_event.getEventName(), p_subscription_guid);

Line: 260

END UPDATE_LOCATION_WFSUB;