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

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

Line: 133


    ddp_evh_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 134


    ddp_evh_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 137


    ddp_evh_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 244


  procedure update_event_header(p_api_version  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
    , 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  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  DATE := fnd_api.g_miss_date
    , p7_a15  VARCHAR2 := fnd_api.g_miss_char
    , p7_a16  VARCHAR2 := fnd_api.g_miss_char
    , p7_a17  VARCHAR2 := fnd_api.g_miss_char
    , p7_a18  VARCHAR2 := fnd_api.g_miss_char
    , p7_a19  DATE := fnd_api.g_miss_date
    , p7_a20  DATE := fnd_api.g_miss_date
    , p7_a21  VARCHAR2 := fnd_api.g_miss_char
    , p7_a22  VARCHAR2 := fnd_api.g_miss_char
    , p7_a23  VARCHAR2 := fnd_api.g_miss_char
    , p7_a24  VARCHAR2 := fnd_api.g_miss_char
    , p7_a25  VARCHAR2 := fnd_api.g_miss_char
    , p7_a26  NUMBER := 0-1962.0724
    , p7_a27  NUMBER := 0-1962.0724
    , p7_a28  VARCHAR2 := fnd_api.g_miss_char
    , p7_a29  DATE := fnd_api.g_miss_date
    , p7_a30  DATE := fnd_api.g_miss_date
    , p7_a31  NUMBER := 0-1962.0724
    , p7_a32  NUMBER := 0-1962.0724
    , p7_a33  VARCHAR2 := fnd_api.g_miss_char
    , p7_a34  VARCHAR2 := fnd_api.g_miss_char
    , p7_a35  NUMBER := 0-1962.0724
    , p7_a36  NUMBER := 0-1962.0724
    , p7_a37  NUMBER := 0-1962.0724
    , p7_a38  NUMBER := 0-1962.0724
    , p7_a39  NUMBER := 0-1962.0724
    , p7_a40  NUMBER := 0-1962.0724
    , p7_a41  NUMBER := 0-1962.0724
    , p7_a42  NUMBER := 0-1962.0724
    , p7_a43  NUMBER := 0-1962.0724
    , p7_a44  VARCHAR2 := fnd_api.g_miss_char
    , p7_a45  NUMBER := 0-1962.0724
    , p7_a46  NUMBER := 0-1962.0724
    , p7_a47  NUMBER := 0-1962.0724
    , p7_a48  VARCHAR2 := fnd_api.g_miss_char
    , p7_a49  VARCHAR2 := fnd_api.g_miss_char
    , p7_a50  NUMBER := 0-1962.0724
    , 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  VARCHAR2 := fnd_api.g_miss_char
    , p7_a56  VARCHAR2 := fnd_api.g_miss_char
    , p7_a57  VARCHAR2 := fnd_api.g_miss_char
    , p7_a58  VARCHAR2 := fnd_api.g_miss_char
    , 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  VARCHAR2 := fnd_api.g_miss_char
    , p7_a64  VARCHAR2 := fnd_api.g_miss_char
    , p7_a65  VARCHAR2 := fnd_api.g_miss_char
    , 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  VARCHAR2 := fnd_api.g_miss_char
    , p7_a73  VARCHAR2 := fnd_api.g_miss_char
    , p7_a74  VARCHAR2 := fnd_api.g_miss_char
    , p7_a75  VARCHAR2 := fnd_api.g_miss_char
    , p7_a76  NUMBER := 0-1962.0724
    , p7_a77  VARCHAR2 := fnd_api.g_miss_char
    , p7_a78  NUMBER := 0-1962.0724
    , p7_a79  VARCHAR2 := fnd_api.g_miss_char
    , p7_a80  VARCHAR2 := fnd_api.g_miss_char
    , p7_a81  VARCHAR2 := fnd_api.g_miss_char
    , p7_a82  VARCHAR2 := fnd_api.g_miss_char
    , p7_a83  NUMBER := 0-1962.0724
    , p7_a84  NUMBER := 0-1962.0724
    , p7_a85  VARCHAR2 := fnd_api.g_miss_char
    , p7_a86  VARCHAR2 := fnd_api.g_miss_char
    , p7_a87  VARCHAR2 := fnd_api.g_miss_char
  )
  as
    ddp_evh_rec ams_eventheader_pvt.evh_rec_type;

Line: 354


    ddp_evh_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 355


    ddp_evh_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 358


    ddp_evh_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 443


    ams_eventheader_pvt.update_event_header(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_evh_rec);

Line: 570


    ddp_evh_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);

Line: 571


    ddp_evh_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);

Line: 574


    ddp_evh_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);

Line: 774


    ddp_evh_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 775


    ddp_evh_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 778


    ddp_evh_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1060


    ddp_evh_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1061


    ddp_evh_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1064


    ddp_evh_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1149


    ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);

Line: 1150


    ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);

Line: 1153


    ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);

Line: 1349


    p0_a1 := ddx_evh_rec.last_update_date;

Line: 1350


    p0_a2 := rosetta_g_miss_num_map(ddx_evh_rec.last_updated_by);

Line: 1353


    p0_a5 := rosetta_g_miss_num_map(ddx_evh_rec.last_update_login);

Line: 1623


    ddp_evh_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1624


    ddp_evh_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1627


    ddp_evh_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1719


    p1_a1 := ddx_complete_rec.last_update_date;

Line: 1720


    p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);

Line: 1723


    p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);

Line: 1995


    ddp_evh_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1996


    ddp_evh_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1999


    ddp_evh_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 2084


    ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);

Line: 2085


    ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);

Line: 2088


    ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);