APPS.AMS_LIST_PURGE_PVT_W SQL Statements

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

Line: 106

  procedure delete_entries_soft(p0_a0 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_list_header_id_tbl ams_list_purge_pvt.list_header_id_tbl;

Line: 125

    ams_list_purge_pvt.delete_entries_soft(ddp_list_header_id_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 136

  procedure delete_entries_online(p0_a0 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_list_header_id_tbl ams_list_purge_pvt.list_header_id_tbl;

Line: 155

    ams_list_purge_pvt.delete_entries_online(ddp_list_header_id_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);