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

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

Line: 180


    ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a1);

Line: 181


    ddp_evo_rec.last_updated_by := rosetta_g_miss_num_map(p4_a2);

Line: 184


    ddp_evo_rec.last_update_login := rosetta_g_miss_num_map(p4_a5);

Line: 344


  procedure update_event_offer(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
    , p4_a0  NUMBER := 0-1962.0724
    , p4_a1  DATE := fnd_api.g_miss_date
    , p4_a2  NUMBER := 0-1962.0724
    , p4_a3  DATE := fnd_api.g_miss_date
    , p4_a4  NUMBER := 0-1962.0724
    , p4_a5  NUMBER := 0-1962.0724
    , p4_a6  NUMBER := 0-1962.0724
    , p4_a7  NUMBER := 0-1962.0724
    , p4_a8  NUMBER := 0-1962.0724
    , p4_a9  VARCHAR2 := fnd_api.g_miss_char
    , p4_a10  VARCHAR2 := fnd_api.g_miss_char
    , p4_a11  VARCHAR2 := fnd_api.g_miss_char
    , p4_a12  VARCHAR2 := fnd_api.g_miss_char
    , p4_a13  NUMBER := 0-1962.0724
    , p4_a14  DATE := fnd_api.g_miss_date
    , p4_a15  VARCHAR2 := fnd_api.g_miss_char
    , p4_a16  VARCHAR2 := fnd_api.g_miss_char
    , p4_a17  NUMBER := 0-1962.0724
    , p4_a18  VARCHAR2 := fnd_api.g_miss_char
    , p4_a19  VARCHAR2 := fnd_api.g_miss_char
    , p4_a20  VARCHAR2 := fnd_api.g_miss_char
    , p4_a21  NUMBER := 0-1962.0724
    , p4_a22  VARCHAR2 := fnd_api.g_miss_char
    , p4_a23  VARCHAR2 := fnd_api.g_miss_char
    , p4_a24  VARCHAR2 := fnd_api.g_miss_char
    , p4_a25  VARCHAR2 := fnd_api.g_miss_char
    , p4_a26  VARCHAR2 := fnd_api.g_miss_char
    , p4_a27  VARCHAR2 := fnd_api.g_miss_char
    , p4_a28  VARCHAR2 := fnd_api.g_miss_char
    , p4_a29  VARCHAR2 := fnd_api.g_miss_char
    , p4_a30  VARCHAR2 := fnd_api.g_miss_char
    , p4_a31  VARCHAR2 := fnd_api.g_miss_char
    , p4_a32  VARCHAR2 := fnd_api.g_miss_char
    , p4_a33  VARCHAR2 := fnd_api.g_miss_char
    , p4_a34  VARCHAR2 := fnd_api.g_miss_char
    , p4_a35  NUMBER := 0-1962.0724
    , p4_a36  NUMBER := 0-1962.0724
    , p4_a37  VARCHAR2 := fnd_api.g_miss_char
    , p4_a38  DATE := fnd_api.g_miss_date
    , p4_a39  DATE := fnd_api.g_miss_date
    , p4_a40  DATE := fnd_api.g_miss_date
    , p4_a41  DATE := fnd_api.g_miss_date
    , p4_a42  DATE := fnd_api.g_miss_date
    , p4_a43  DATE := fnd_api.g_miss_date
    , p4_a44  DATE := fnd_api.g_miss_date
    , p4_a45  DATE := fnd_api.g_miss_date
    , p4_a46  NUMBER := 0-1962.0724
    , p4_a47  NUMBER := 0-1962.0724
    , p4_a48  NUMBER := 0-1962.0724
    , p4_a49  NUMBER := 0-1962.0724
    , p4_a50  NUMBER := 0-1962.0724
    , p4_a51  DATE := fnd_api.g_miss_date
    , p4_a52  NUMBER := 0-1962.0724
    , p4_a53  VARCHAR2 := fnd_api.g_miss_char
    , p4_a54  NUMBER := 0-1962.0724
    , p4_a55  NUMBER := 0-1962.0724
    , p4_a56  NUMBER := 0-1962.0724
    , p4_a57  NUMBER := 0-1962.0724
    , p4_a58  VARCHAR2 := fnd_api.g_miss_char
    , p4_a59  VARCHAR2 := fnd_api.g_miss_char
    , p4_a60  NUMBER := 0-1962.0724
    , p4_a61  VARCHAR2 := fnd_api.g_miss_char
    , p4_a62  NUMBER := 0-1962.0724
    , p4_a63  NUMBER := 0-1962.0724
    , p4_a64  NUMBER := 0-1962.0724
    , p4_a65  NUMBER := 0-1962.0724
    , p4_a66  VARCHAR2 := fnd_api.g_miss_char
    , p4_a67  NUMBER := 0-1962.0724
    , p4_a68  VARCHAR2 := fnd_api.g_miss_char
    , p4_a69  NUMBER := 0-1962.0724
    , p4_a70  NUMBER := 0-1962.0724
    , p4_a71  VARCHAR2 := fnd_api.g_miss_char
    , p4_a72  VARCHAR2 := fnd_api.g_miss_char
    , p4_a73  VARCHAR2 := fnd_api.g_miss_char
    , p4_a74  VARCHAR2 := fnd_api.g_miss_char
    , p4_a75  VARCHAR2 := fnd_api.g_miss_char
    , p4_a76  NUMBER := 0-1962.0724
    , p4_a77  NUMBER := 0-1962.0724
    , p4_a78  VARCHAR2 := fnd_api.g_miss_char
    , p4_a79  VARCHAR2 := fnd_api.g_miss_char
    , p4_a80  VARCHAR2 := fnd_api.g_miss_char
    , p4_a81  NUMBER := 0-1962.0724
    , p4_a82  NUMBER := 0-1962.0724
    , p4_a83  VARCHAR2 := fnd_api.g_miss_char
    , p4_a84  NUMBER := 0-1962.0724
    , p4_a85  VARCHAR2 := fnd_api.g_miss_char
    , p4_a86  VARCHAR2 := fnd_api.g_miss_char
    , p4_a87  VARCHAR2 := fnd_api.g_miss_char
    , p4_a88  VARCHAR2 := fnd_api.g_miss_char
    , p4_a89  VARCHAR2 := fnd_api.g_miss_char
    , p4_a90  VARCHAR2 := fnd_api.g_miss_char
    , p4_a91  VARCHAR2 := fnd_api.g_miss_char
    , p4_a92  VARCHAR2 := fnd_api.g_miss_char
    , p4_a93  VARCHAR2 := fnd_api.g_miss_char
    , p4_a94  VARCHAR2 := fnd_api.g_miss_char
    , p4_a95  VARCHAR2 := fnd_api.g_miss_char
    , p4_a96  VARCHAR2 := fnd_api.g_miss_char
    , p4_a97  VARCHAR2 := fnd_api.g_miss_char
    , p4_a98  VARCHAR2 := fnd_api.g_miss_char
    , p4_a99  VARCHAR2 := fnd_api.g_miss_char
    , p4_a100  VARCHAR2 := fnd_api.g_miss_char
    , p4_a101  VARCHAR2 := fnd_api.g_miss_char
    , p4_a102  VARCHAR2 := fnd_api.g_miss_char
    , p4_a103  VARCHAR2 := fnd_api.g_miss_char
    , p4_a104  VARCHAR2 := fnd_api.g_miss_char
    , p4_a105  NUMBER := 0-1962.0724
    , p4_a106  VARCHAR2 := fnd_api.g_miss_char
    , p4_a107  NUMBER := 0-1962.0724
    , p4_a108  VARCHAR2 := fnd_api.g_miss_char
    , p4_a109  VARCHAR2 := fnd_api.g_miss_char
    , p4_a110  VARCHAR2 := fnd_api.g_miss_char
    , p4_a111  VARCHAR2 := fnd_api.g_miss_char
    , p4_a112  NUMBER := 0-1962.0724
    , p4_a113  VARCHAR2 := fnd_api.g_miss_char
    , p4_a114  NUMBER := 0-1962.0724
    , p4_a115  VARCHAR2 := fnd_api.g_miss_char
    , p4_a116  VARCHAR2 := fnd_api.g_miss_char
    , p4_a117  VARCHAR2 := fnd_api.g_miss_char
    , p4_a118  NUMBER := 0-1962.0724
    , p4_a119  VARCHAR2 := fnd_api.g_miss_char
    , p4_a120  VARCHAR2 := fnd_api.g_miss_char
    , p4_a121  VARCHAR2 := fnd_api.g_miss_char
    , p4_a122  VARCHAR2 := fnd_api.g_miss_char
    , p4_a123  VARCHAR2 := fnd_api.g_miss_char
    , p4_a124  VARCHAR2 := fnd_api.g_miss_char
    , p4_a125  DATE := fnd_api.g_miss_date
    , p4_a126  DATE := fnd_api.g_miss_date
    , p4_a127  NUMBER := 0-1962.0724
    , p4_a128  NUMBER := 0-1962.0724
    , p4_a129  VARCHAR2 := fnd_api.g_miss_char
    , p4_a130  VARCHAR2 := fnd_api.g_miss_char
    , p4_a131  VARCHAR2 := fnd_api.g_miss_char
    , p4_a132  VARCHAR2 := fnd_api.g_miss_char
    , p4_a133  VARCHAR2 := fnd_api.g_miss_char
    , p4_a134  VARCHAR2 := fnd_api.g_miss_char
    , p4_a135  VARCHAR2 := fnd_api.g_miss_char
    , p4_a136  NUMBER := 0-1962.0724
    , p4_a137  VARCHAR2 := fnd_api.g_miss_char
  )
  as
    ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;

Line: 501


    ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a1);

Line: 502


    ddp_evo_rec.last_updated_by := rosetta_g_miss_num_map(p4_a2);

Line: 505


    ddp_evo_rec.last_update_login := rosetta_g_miss_num_map(p4_a5);

Line: 643


    ams_eventoffer_pvt.update_event_offer(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      ddp_evo_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 817


    ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a1);

Line: 818


    ddp_evo_rec.last_updated_by := rosetta_g_miss_num_map(p3_a2);

Line: 821


    ddp_evo_rec.last_update_login := rosetta_g_miss_num_map(p3_a5);

Line: 1124


    ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1125


    ddp_evo_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1128


    ddp_evo_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1560


    ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1561


    ddp_evo_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1564


    ddp_evo_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1699


    ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);

Line: 1700


    ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);

Line: 1703


    ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);

Line: 1999


    p0_a1 := ddx_evo_rec.last_update_date;

Line: 2000


    p0_a2 := rosetta_g_miss_num_map(ddx_evo_rec.last_updated_by);

Line: 2003


    p0_a5 := rosetta_g_miss_num_map(ddx_evo_rec.last_update_login);

Line: 2423


    ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 2424


    ddp_evo_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 2427


    ddp_evo_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 2569


    p1_a1 := ddx_complete_rec.last_update_date;

Line: 2570


    p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);

Line: 2573


    p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);