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_IMPORT_LIST_PVT_W SQL Statements

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

Line: 107


          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a1(indx));

Line: 108


          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));

Line: 111


          t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));

Line: 179


          t(ddindx).record_update_flag := a73(indx);

Line: 505


          a1(indx) := t(ddindx).last_update_date;

Line: 506


          a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);

Line: 509


          a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);

Line: 577


          a73(indx) := t(ddindx).record_update_flag;

Line: 715


    p8_a1 := ddx_ams_import_rec.last_update_date;

Line: 716


    p8_a2 := rosetta_g_miss_num_map(ddx_ams_import_rec.last_updated_by);

Line: 719


    p8_a5 := rosetta_g_miss_num_map(ddx_ams_import_rec.last_update_login);

Line: 787


    p8_a73 := ddx_ams_import_rec.record_update_flag;

Line: 893


    ddp_ams_import_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 894


    ddp_ams_import_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 897


    ddp_ams_import_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 965


    ddp_ams_import_rec.record_update_flag := p7_a73;

Line: 992


  procedure update_import_list(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  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a12  NUMBER := 0-1962.0724
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  DATE := fnd_api.g_miss_date
    , p7_a15  NUMBER := 0-1962.0724
    , p7_a16  VARCHAR2 := fnd_api.g_miss_char
    , p7_a17  NUMBER := 0-1962.0724
    , p7_a18  NUMBER := 0-1962.0724
    , p7_a19  NUMBER := 0-1962.0724
    , p7_a20  DATE := fnd_api.g_miss_date
    , p7_a21  NUMBER := 0-1962.0724
    , p7_a22  DATE := fnd_api.g_miss_date
    , p7_a23  NUMBER := 0-1962.0724
    , p7_a24  NUMBER := 0-1962.0724
    , p7_a25  VARCHAR2 := fnd_api.g_miss_char
    , p7_a26  DATE := fnd_api.g_miss_date
    , p7_a27  DATE := fnd_api.g_miss_date
    , p7_a28  VARCHAR2 := fnd_api.g_miss_char
    , p7_a29  VARCHAR2 := fnd_api.g_miss_char
    , p7_a30  NUMBER := 0-1962.0724
    , p7_a31  VARCHAR2 := fnd_api.g_miss_char
    , p7_a32  NUMBER := 0-1962.0724
    , p7_a33  VARCHAR2 := fnd_api.g_miss_char
    , p7_a34  VARCHAR2 := fnd_api.g_miss_char
    , p7_a35  VARCHAR2 := fnd_api.g_miss_char
    , p7_a36  VARCHAR2 := fnd_api.g_miss_char
    , p7_a37  VARCHAR2 := fnd_api.g_miss_char
    , p7_a38  VARCHAR2 := fnd_api.g_miss_char
    , p7_a39  VARCHAR2 := fnd_api.g_miss_char
    , p7_a40  VARCHAR2 := fnd_api.g_miss_char
    , p7_a41  VARCHAR2 := fnd_api.g_miss_char
    , p7_a42  VARCHAR2 := fnd_api.g_miss_char
    , p7_a43  VARCHAR2 := fnd_api.g_miss_char
    , p7_a44  VARCHAR2 := fnd_api.g_miss_char
    , p7_a45  VARCHAR2 := fnd_api.g_miss_char
    , p7_a46  VARCHAR2 := fnd_api.g_miss_char
    , p7_a47  VARCHAR2 := fnd_api.g_miss_char
    , p7_a48  VARCHAR2 := fnd_api.g_miss_char
    , p7_a49  VARCHAR2 := fnd_api.g_miss_char
    , p7_a50  VARCHAR2 := fnd_api.g_miss_char
    , p7_a51  VARCHAR2 := fnd_api.g_miss_char
    , p7_a52  VARCHAR2 := fnd_api.g_miss_char
    , p7_a53  VARCHAR2 := fnd_api.g_miss_char
    , p7_a54  VARCHAR2 := fnd_api.g_miss_char
    , p7_a55  NUMBER := 0-1962.0724
    , p7_a56  NUMBER := 0-1962.0724
    , p7_a57  NUMBER := 0-1962.0724
    , p7_a58  NUMBER := 0-1962.0724
    , p7_a59  VARCHAR2 := fnd_api.g_miss_char
    , p7_a60  VARCHAR2 := fnd_api.g_miss_char
    , p7_a61  VARCHAR2 := fnd_api.g_miss_char
    , p7_a62  VARCHAR2 := fnd_api.g_miss_char
    , p7_a63  NUMBER := 0-1962.0724
    , p7_a64  NUMBER := 0-1962.0724
    , p7_a65  NUMBER := 0-1962.0724
    , p7_a66  VARCHAR2 := fnd_api.g_miss_char
    , p7_a67  VARCHAR2 := fnd_api.g_miss_char
    , p7_a68  VARCHAR2 := fnd_api.g_miss_char
    , p7_a69  VARCHAR2 := fnd_api.g_miss_char
    , p7_a70  VARCHAR2 := fnd_api.g_miss_char
    , p7_a71  VARCHAR2 := fnd_api.g_miss_char
    , p7_a72  NUMBER := 0-1962.0724
    , p7_a73  VARCHAR2 := fnd_api.g_miss_char
    , p7_a74  NUMBER := 0-1962.0724
    , p7_a75  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;

Line: 1092


    ddp_ams_import_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 1093


    ddp_ams_import_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 1096


    ddp_ams_import_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 1164


    ddp_ams_import_rec.record_update_flag := p7_a73;

Line: 1170


    ams_import_list_pvt.update_import_list(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_ams_import_rec,
      x_object_version_number);

Line: 1285


    ddp_ams_import_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a1);

Line: 1286


    ddp_ams_import_rec.last_updated_by := rosetta_g_miss_num_map(p3_a2);

Line: 1289


    ddp_ams_import_rec.last_update_login := rosetta_g_miss_num_map(p3_a5);

Line: 1357


    ddp_ams_import_rec.record_update_flag := p3_a73;

Line: 1469


    ddp_ams_import_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1470


    ddp_ams_import_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1473


    ddp_ams_import_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1541


    ddp_ams_import_rec.record_update_flag := p0_a73;

Line: 1652


    ddp_ams_import_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a1);

Line: 1653


    ddp_ams_import_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);

Line: 1656


    ddp_ams_import_rec.last_update_login := rosetta_g_miss_num_map(p5_a5);

Line: 1724


    ddp_ams_import_rec.record_update_flag := p5_a73;