APPS.CSL_MTL_SEC_INV_ACC_PKG SQL Statements

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

Line: 13

PROCEDURE Insert_MTL_Sec_Inventory(
                                    p_resource_id   NUMBER
                                  , p_subinventory_code VARCHAR2
                                  , p_organization_id NUMBER
		    )
IS
BEGIN
  /*** get debug level ***/
  g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 27

    , v_message     => 'Entering Insert_MTL_Sec_Inventory'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 35

      , v_message     => 'Inserting ACC record :' || p_organization_id || ' for resource id '
                         || p_resource_id
      , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 40

  /*** Call common package to insert record into ACC table ***/
  JTM_HOOK_UTIL_PKG.Insert_Acc
  ( p_publication_item_names => g_publication_item_name
   ,p_acc_table_name         => g_acc_table_name
   ,p_resource_id            => p_resource_id
   ,p_pk1_name               => g_pk1_name
   ,p_pk1_char_value         => p_subinventory_code
   ,p_pk2_name               => g_pk2_name
   ,p_pk2_num_value          => p_organization_id
  );

Line: 55

    , v_message     => 'Leaving Insert_MTL_Sec_Inventory'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 59

END Insert_MTL_Sec_Inventory;

Line: 62

PROCEDURE Update_MTL_Sec_Inventory(
                                    p_resource_id   NUMBER
                                  , p_subinventory_code VARCHAR2
                                  , p_organization_id NUMBER
		    )
IS
  l_acc_id   NUMBER;

Line: 78

    , v_message     => 'Entering Update_MTL_Sec_Inventory'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 86

      , v_message     => 'Update ACC record :' ||
                         p_organization_id || ' for resource id ' || p_resource_id
      , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 91

  /*** Call common package to insert record into ACC table ***/
  l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
             ( P_ACC_TABLE_NAME => g_acc_table_name
              ,p_pk1_name       => g_pk1_name
              ,p_pk1_char_value => p_subinventory_code
              ,p_pk2_name       => g_pk2_name
              ,p_pk2_num_value  => p_organization_id
              ,P_RESOURCE_ID    => p_resource_id);

Line: 102

  /*** Record is not yet in ACC tables. Insert has to be done ***/
    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_char_value          => p_subinventory_code
                     ,p_pk2_name                => g_pk2_name
                     ,p_pk2_num_value           => p_organization_id
                     ,p_resource_id             => p_resource_id
                     );

Line: 113

  /*** Record is already in ACC. Only an update is required for re-sending ***/
    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            => p_resource_id
                     ,p_access_id               => l_acc_id
                     );

Line: 126

    , v_message     => 'Leaving Update_MTL_Sec_Inventory'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 129

END Update_MTL_Sec_Inventory;

Line: 132

PROCEDURE Delete_MTL_Sec_Inventory(
                                    p_resource_id   NUMBER
                                  , p_subinventory_code VARCHAR2
                                  , p_organization_id NUMBER
		    )
IS
BEGIN
  /*** get debug level ***/
  g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 146

    , v_message     => 'Entering Delete_MTL_Sec_Inventory'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 154

      , v_message     => 'Inserting ACC record :' || p_organization_id || ' for resource id '
                         || p_resource_id
      , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 159

  /*** Call common package to insert record into ACC table ***/
  JTM_HOOK_UTIL_PKG.Delete_Acc
  ( p_publication_item_names => g_publication_item_name
   ,p_acc_table_name         => g_acc_table_name
   ,p_resource_id            => p_resource_id
   ,p_pk1_name               => g_pk1_name
   ,p_pk1_char_value         => p_subinventory_code
   ,p_pk2_name               => g_pk2_name
   ,p_pk2_num_value          => p_organization_id
  );

Line: 174

    , v_message     => 'Leaving Delete_MTL_Sec_Inventory'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 177

END Delete_MTL_Sec_Inventory;