APPS.CSM_HZ_LOCATIONS_EVENT_PKG SQL Statements

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

Line: 15

PROCEDURE INSERT_LOCATION( p_location_id IN NUMBER, p_user_id IN NUMBER)
IS
--variable declarations
l_sqlerrno 		VARCHAR2(20);

Line: 28

    , 'Entering Insert_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 36

    , 'Inserting ACC record for user_id = '||p_user_id || 'for location id' ||p_location_id
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 40

  CSM_ACC_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name,
      P_ACC_TABLE_NAME         => g_acc_table_name,
      P_SEQ_NAME               => g_seq_name,
      P_USER_ID                => p_user_id,
      P_PK1_NAME               => g_pk1_name,
      P_PK1_NUM_VALUE          => p_location_id);

Line: 52

    , 'Leaving Insert_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 61

     CSM_UTIL_PKG.LOG('Exception in CSM_HZ_LOCATIONS_EVENT_PKG.INSERT_LOCATION: ' || l_sqlerrno || ':' || l_sqlerrmsg,
                         'CSM_HZ_LOCATIONS_EVENT_PKG.INSERT_LOCATION',FND_LOG.LEVEL_EXCEPTION);

Line: 64

END INSERT_LOCATION;

Line: 67

PROCEDURE DELETE_LOCATION( p_location_id IN NUMBER, p_user_id IN NUMBER)
IS
--variable declarations
l_sqlerrno 		VARCHAR2(20);

Line: 83

 CSM_ACC_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_USER_ID                => p_user_id
    );

Line: 96

    , 'Leaving Delete_Location'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 105

     CSM_UTIL_PKG.LOG('Exception in CSM_HZ_LOCATIONS_EVENT_PKG.DELETE_LOCATION: ' || l_sqlerrno || ':' || l_sqlerrmsg,
                         'CSM_HZ_LOCATIONS_EVENT_PKG.DELETE_LOCATION',FND_LOG.LEVEL_EXCEPTION);

Line: 108

END DELETE_LOCATION;