eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_QUERY_PVT_W SQL Statements

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

Line: 148


    ddp_list_query_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 149


    ddp_list_query_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 152


    ddp_list_query_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 237


    ddp_list_query_rec_tbl.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 238


    ddp_list_query_rec_tbl.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 241


    ddp_list_query_rec_tbl.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 284


  procedure update_list_query(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status OUT NOCOPY  VARCHAR2
    , x_msg_count OUT NOCOPY  NUMBER
    , x_msg_data OUT NOCOPY  VARCHAR2
    , x_object_version_number OUT NOCOPY  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  DATE := fnd_api.g_miss_date
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  DATE := fnd_api.g_miss_date
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  NUMBER := 0-1962.0724
    , p7_a7  VARCHAR2 := fnd_api.g_miss_char
    , p7_a8  VARCHAR2 := fnd_api.g_miss_char
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p7_a10  VARCHAR2 := fnd_api.g_miss_char
    , p7_a11  VARCHAR2 := fnd_api.g_miss_char
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  NUMBER := 0-1962.0724
    , p7_a15  VARCHAR2 := fnd_api.g_miss_char
    , p7_a16  NUMBER := 0-1962.0724
    , p7_a17  VARCHAR2 := fnd_api.g_miss_char
    , p7_a18  VARCHAR2 := fnd_api.g_miss_char
    , p7_a19  NUMBER := 0-1962.0724
    , p7_a20  NUMBER := 0-1962.0724
  )
  as
    ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

Line: 328


    ddp_list_query_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 329


    ddp_list_query_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 332


    ddp_list_query_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 351


    ams_list_query_pvt.update_list_query(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_list_query_rec,
      x_object_version_number);

Line: 372


  procedure update_list_query(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status OUT NOCOPY  VARCHAR2
    , x_msg_count OUT NOCOPY  NUMBER
    , x_msg_data OUT NOCOPY  VARCHAR2
    , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
    , x_object_version_number OUT NOCOPY  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  DATE := fnd_api.g_miss_date
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  DATE := fnd_api.g_miss_date
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  NUMBER := 0-1962.0724
    , p7_a7  VARCHAR2 := fnd_api.g_miss_char
    , p7_a8  VARCHAR2 := fnd_api.g_miss_char
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p7_a10  VARCHAR2 := fnd_api.g_miss_char
    , p7_a11  VARCHAR2 := fnd_api.g_miss_char
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  NUMBER := 0-1962.0724
    , p7_a15  VARCHAR2 := fnd_api.g_miss_char
    , p7_a16  NUMBER := 0-1962.0724
    , p7_a17  VARCHAR2 := fnd_api.g_miss_char
    , p7_a18  NUMBER := 0-1962.0724
    , p7_a19  NUMBER := 0-1962.0724
  )
  as
    ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;

Line: 417


    ddp_list_query_rec_tbl.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 418


    ddp_list_query_rec_tbl.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 421


    ddp_list_query_rec_tbl.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 441


    ams_list_query_pvt.update_list_query(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_list_query_rec_tbl,
      ddp_sql_string_tbl,
      x_object_version_number);

Line: 502


    ddp_list_query_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a1);

Line: 503


    ddp_list_query_rec.last_updated_by := rosetta_g_miss_num_map(p3_a2);

Line: 506


    ddp_list_query_rec.last_update_login := rosetta_g_miss_num_map(p3_a5);

Line: 575


    ddp_list_query_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 576


    ddp_list_query_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 579


    ddp_list_query_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 647


    ddp_list_query_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a1);

Line: 648


    ddp_list_query_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);

Line: 651


    ddp_list_query_rec.last_update_login := rosetta_g_miss_num_map(p5_a5);