APPS.CSL_HZ_PARTY_SITES_ACC_PKG SQL Statements

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

Line: 12

PROCEDURE INSERT_PARTY_SITE( p_party_site_id IN NUMBER
                           , p_resource_id IN NUMBER )
IS
 CURSOR c_party_site( b_party_site_id NUMBER ) IS
   SELECT *
   FROM HZ_PARTY_SITES
   WHERE party_site_id = b_party_site_id;

Line: 29

    , 'Entering Insert_Party_Site'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 37

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

Line: 41

  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_party_site_id
     , P_RESOURCE_ID            => p_resource_id
     );

Line: 49

  /*Insert the matching location*/
  OPEN c_party_site( b_party_site_id => p_party_site_id );

Line: 53

    CSL_HZ_LOCATIONS_ACC_PKG.INSERT_LOCATION( p_location_id => r_party_site.location_id
                                            , p_resource_id => p_resource_id );

Line: 62

    , 'Leaving Insert_Party_Site'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 66

END INSERT_PARTY_SITE;

Line: 68

PROCEDURE UPDATE_PARTY_SITE( p_party_site_id IN NUMBER )
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 78

    , 'Entering Update_Party_Site'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 103

        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: 120

END UPDATE_PARTY_SITE;

Line: 122

PROCEDURE DELETE_PARTY_SITE( p_party_site_id IN NUMBER
                           , p_resource_id IN NUMBER )
IS
 CURSOR c_party_site( b_party_site_id NUMBER ) IS
   SELECT *
   FROM HZ_PARTY_SITES
   WHERE party_site_id = b_party_site_id;

Line: 138

    , 'Entering Delete_Party_Site'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 142

 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_party_site_id
     ,P_RESOURCE_ID            => p_resource_id
    );

Line: 150

  /*Delete the matching location*/
  OPEN c_party_site( b_party_site_id => p_party_site_id );

Line: 154

    CSL_HZ_LOCATIONS_ACC_PKG.DELETE_LOCATION( p_location_id => r_party_site.location_id
                                            , p_resource_id => p_resource_id );

Line: 163

    , 'Leaving Delete_Party_Site'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 167

END DELETE_PARTY_SITE;

Line: 174

   SELECT *
   FROM HZ_PARTY_SITES
   WHERE party_site_id = b_party_site_id;

Line: 198

  /*Party site is changed so delete the old one ( basicly we lower the counter )*/
  IF p_old_party_site_id IS NOT NULL THEN
    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_party_site_id
       ,P_RESOURCE_ID            => p_resource_id
      );

Line: 208

    /*Delete the matching location*/
    OPEN c_party_site( b_party_site_id => p_old_party_site_id );

Line: 212

      CSL_HZ_LOCATIONS_ACC_PKG.DELETE_LOCATION( p_location_id => r_party_site.location_id
                                              , p_resource_id => p_resource_id );

Line: 219

  /*Insert the new party site*/
  IF p_new_party_site_id IS NOT NULL THEN
    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_party_site_id
       , P_RESOURCE_ID            => p_resource_id
       );

Line: 229

    /*Insert the matching location*/
    OPEN c_party_site( b_party_site_id => p_new_party_site_id );

Line: 233

      CSL_HZ_LOCATIONS_ACC_PKG.INSERT_LOCATION( p_location_id => r_party_site.location_id
                                              , p_resource_id => p_resource_id );