APPS.AMS_ITEM_SECTION_PVT SQL Statements

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

Line: 200

PROCEDURE Delete_item_sec_assoc
(
  p_api_version         IN  NUMBER,
  p_init_msg_list       IN  VARCHAR2 := FND_API.g_false,
  p_commit              IN  VARCHAR2 := FND_API.g_false,
  p_validation_level    IN  NUMBER   := FND_API.g_valid_level_full,

  x_return_status       OUT VARCHAR2,
  x_msg_count           OUT NUMBER,
  x_msg_data            OUT VARCHAR2,

  p_section_rec         IN  section_rec_type

  )

  IS
    l_api_name                CONSTANT VARCHAR2(50) := 'Delete_item_sec_assoc';

Line: 231

      SAVEPOINT Delete_item_sec_assoc;

Line: 316

     ROLLBACK TO Delete_item_sec_assoc;

Line: 325

      ROLLBACK TO Delete_item_sec_assoc;

Line: 334

      ROLLBACK TO Delete_item_sec_assoc;

Line: 346

 END Delete_item_sec_assoc;