The following lines contain the word 'select', 'insert', 'update' or 'delete':
ddp_evo_rec.last_update_date := p4_a1;
ddp_evo_rec.last_updated_by := p4_a2;
ddp_evo_rec.last_update_login := p4_a5;
procedure update_event_offer(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p4_a0 NUMBER
, p4_a1 DATE
, p4_a2 NUMBER
, p4_a3 DATE
, p4_a4 NUMBER
, p4_a5 NUMBER
, p4_a6 NUMBER
, p4_a7 NUMBER
, p4_a8 NUMBER
, p4_a9 VARCHAR2
, p4_a10 VARCHAR2
, p4_a11 VARCHAR2
, p4_a12 VARCHAR2
, p4_a13 NUMBER
, p4_a14 DATE
, p4_a15 VARCHAR2
, p4_a16 VARCHAR2
, p4_a17 NUMBER
, p4_a18 VARCHAR2
, p4_a19 VARCHAR2
, p4_a20 VARCHAR2
, p4_a21 NUMBER
, p4_a22 VARCHAR2
, p4_a23 VARCHAR2
, p4_a24 VARCHAR2
, p4_a25 VARCHAR2
, p4_a26 VARCHAR2
, p4_a27 VARCHAR2
, p4_a28 VARCHAR2
, p4_a29 VARCHAR2
, p4_a30 VARCHAR2
, p4_a31 VARCHAR2
, p4_a32 VARCHAR2
, p4_a33 VARCHAR2
, p4_a34 VARCHAR2
, p4_a35 NUMBER
, p4_a36 NUMBER
, p4_a37 VARCHAR2
, p4_a38 DATE
, p4_a39 DATE
, p4_a40 DATE
, p4_a41 DATE
, p4_a42 DATE
, p4_a43 DATE
, p4_a44 DATE
, p4_a45 DATE
, p4_a46 NUMBER
, p4_a47 NUMBER
, p4_a48 NUMBER
, p4_a49 NUMBER
, p4_a50 NUMBER
, p4_a51 DATE
, p4_a52 NUMBER
, p4_a53 VARCHAR2
, p4_a54 NUMBER
, p4_a55 NUMBER
, p4_a56 NUMBER
, p4_a57 NUMBER
, p4_a58 VARCHAR2
, p4_a59 VARCHAR2
, p4_a60 NUMBER
, p4_a61 VARCHAR2
, p4_a62 NUMBER
, p4_a63 NUMBER
, p4_a64 NUMBER
, p4_a65 NUMBER
, p4_a66 VARCHAR2
, p4_a67 NUMBER
, p4_a68 VARCHAR2
, p4_a69 NUMBER
, p4_a70 NUMBER
, p4_a71 VARCHAR2
, p4_a72 VARCHAR2
, p4_a73 VARCHAR2
, p4_a74 VARCHAR2
, p4_a75 VARCHAR2
, p4_a76 NUMBER
, p4_a77 NUMBER
, p4_a78 VARCHAR2
, p4_a79 VARCHAR2
, p4_a80 VARCHAR2
, p4_a81 NUMBER
, p4_a82 NUMBER
, p4_a83 VARCHAR2
, p4_a84 NUMBER
, p4_a85 VARCHAR2
, p4_a86 VARCHAR2
, p4_a87 VARCHAR2
, p4_a88 VARCHAR2
, p4_a89 VARCHAR2
, p4_a90 VARCHAR2
, p4_a91 VARCHAR2
, p4_a92 VARCHAR2
, p4_a93 VARCHAR2
, p4_a94 VARCHAR2
, p4_a95 VARCHAR2
, p4_a96 VARCHAR2
, p4_a97 VARCHAR2
, p4_a98 VARCHAR2
, p4_a99 VARCHAR2
, p4_a100 VARCHAR2
, p4_a101 VARCHAR2
, p4_a102 VARCHAR2
, p4_a103 VARCHAR2
, p4_a104 VARCHAR2
, p4_a105 NUMBER
, p4_a106 VARCHAR2
, p4_a107 NUMBER
, p4_a108 VARCHAR2
, p4_a109 VARCHAR2
, p4_a110 VARCHAR2
, p4_a111 VARCHAR2
, p4_a112 NUMBER
, p4_a113 VARCHAR2
, p4_a114 NUMBER
, p4_a115 VARCHAR2
, p4_a116 VARCHAR2
, p4_a117 VARCHAR2
, p4_a118 NUMBER
, p4_a119 VARCHAR2
, p4_a120 VARCHAR2
, p4_a121 VARCHAR2
, p4_a122 VARCHAR2
, p4_a123 VARCHAR2
, p4_a124 VARCHAR2
, p4_a125 DATE
, p4_a126 DATE
, p4_a127 NUMBER
, p4_a128 NUMBER
, p4_a129 VARCHAR2
, p4_a130 VARCHAR2
, p4_a131 VARCHAR2
, p4_a132 VARCHAR2
, p4_a133 VARCHAR2
, p4_a134 VARCHAR2
, p4_a135 VARCHAR2
, p4_a136 NUMBER
, p4_a137 VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
ddp_evo_rec.last_update_date := p4_a1;
ddp_evo_rec.last_updated_by := p4_a2;
ddp_evo_rec.last_update_login := p4_a5;
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);
ddp_evo_rec.last_update_date := p3_a1;
ddp_evo_rec.last_updated_by := p3_a2;
ddp_evo_rec.last_update_login := p3_a5;
ddp_evo_rec.last_update_date := p0_a1;
ddp_evo_rec.last_updated_by := p0_a2;
ddp_evo_rec.last_update_login := p0_a5;
ddp_evo_rec.last_update_date := p0_a1;
ddp_evo_rec.last_updated_by := p0_a2;
ddp_evo_rec.last_update_login := p0_a5;
ddp_complete_rec.last_update_date := p1_a1;
ddp_complete_rec.last_updated_by := p1_a2;
ddp_complete_rec.last_update_login := p1_a5;
p0_a1 := ddx_evo_rec.last_update_date;
p0_a2 := ddx_evo_rec.last_updated_by;
p0_a5 := ddx_evo_rec.last_update_login;
ddp_evo_rec.last_update_date := p0_a1;
ddp_evo_rec.last_updated_by := p0_a2;
ddp_evo_rec.last_update_login := p0_a5;
p1_a1 := ddx_complete_rec.last_update_date;
p1_a2 := ddx_complete_rec.last_updated_by;
p1_a5 := ddx_complete_rec.last_update_login;