The following lines contain the word 'select', 'insert', 'update' or 'delete':
t(ddindx).last_updated_by := a12(indx);
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a13(indx));
t(ddindx).last_update_login := a14(indx);
a12(indx) := t(ddindx).last_updated_by;
a13(indx) := t(ddindx).last_update_date;
a14(indx) := t(ddindx).last_update_login;
ddp_memb_rec.last_updated_by := p7_a12;
ddp_memb_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a13);
ddp_memb_rec.last_update_login := p7_a14;
procedure update_pg_memberships(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
, p7_a0 NUMBER
, p7_a1 NUMBER
, p7_a2 NUMBER
, p7_a3 NUMBER
, p7_a4 DATE
, p7_a5 DATE
, p7_a6 DATE
, p7_a7 VARCHAR2
, p7_a8 VARCHAR2
, p7_a9 NUMBER
, p7_a10 NUMBER
, p7_a11 DATE
, p7_a12 NUMBER
, p7_a13 DATE
, p7_a14 NUMBER
, p7_a15 VARCHAR2
, p7_a16 VARCHAR2
, p7_a17 VARCHAR2
, p7_a18 VARCHAR2
, p7_a19 VARCHAR2
, p7_a20 VARCHAR2
, p7_a21 VARCHAR2
, p7_a22 VARCHAR2
, p7_a23 VARCHAR2
, p7_a24 VARCHAR2
, p7_a25 VARCHAR2
, p7_a26 VARCHAR2
, p7_a27 VARCHAR2
, p7_a28 VARCHAR2
, p7_a29 VARCHAR2
)
as
ddp_memb_rec pv_pg_memberships_pvt.memb_rec_type;
ddp_memb_rec.last_updated_by := p7_a12;
ddp_memb_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a13);
ddp_memb_rec.last_update_login := p7_a14;
pv_pg_memberships_pvt.update_pg_memberships(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
x_return_status,
x_msg_count,
x_msg_data,
ddp_memb_rec);
ddp_memb_rec.last_updated_by := p3_a12;
ddp_memb_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a13);
ddp_memb_rec.last_update_login := p3_a14;
ddp_memb_rec.last_updated_by := p0_a12;
ddp_memb_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a13);
ddp_memb_rec.last_update_login := p0_a14;
ddp_memb_rec.last_updated_by := p5_a12;
ddp_memb_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a13);
ddp_memb_rec.last_update_login := p5_a14;
procedure update_membership_end_date(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_membership_id NUMBER
, p_new_date date
, p_comments VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_new_date date;
pv_pg_memberships_pvt.update_membership_end_date(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
p_membership_id,
ddp_new_date,
p_comments,
x_return_status,
x_msg_count,
x_msg_data);