The following lines contain the word 'select', 'insert', 'update' or 'delete':
ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
ddp_x_cost_price_rec.last_updated_by := p5_a41;
ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
ddp_x_cost_price_rec.last_update_login := p5_a43;
p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
p5_a41 := ddp_x_cost_price_rec.last_updated_by;
p5_a42 := ddp_x_cost_price_rec.last_update_date;
p5_a43 := ddp_x_cost_price_rec.last_update_login;
ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
ddp_x_cost_price_rec.last_updated_by := p5_a41;
ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
ddp_x_cost_price_rec.last_update_login := p5_a43;
p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
p5_a41 := ddp_x_cost_price_rec.last_updated_by;
p5_a42 := ddp_x_cost_price_rec.last_update_date;
p5_a43 := ddp_x_cost_price_rec.last_update_login;
ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
ddp_x_cost_price_rec.last_updated_by := p5_a41;
ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
ddp_x_cost_price_rec.last_update_login := p5_a43;
p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
p5_a41 := ddp_x_cost_price_rec.last_updated_by;
p5_a42 := ddp_x_cost_price_rec.last_update_date;
p5_a43 := ddp_x_cost_price_rec.last_update_login;
procedure update_task_cost_details(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_module_type VARCHAR2
, p5_a0 NUMBER
, p5_a1 NUMBER
, p5_a2 NUMBER
, p5_a3 NUMBER
, p5_a4 NUMBER
, p5_a5 NUMBER
, p5_a6 NUMBER
, p5_a7 VARCHAR2
, p5_a8 NUMBER
, p5_a9 NUMBER
, p5_a10 NUMBER
, p5_a11 NUMBER
, p5_a12 VARCHAR2
, p5_a13 VARCHAR2
, p5_a14 VARCHAR2
, p5_a15 VARCHAR2
, p5_a16 NUMBER
, p5_a17 VARCHAR2
, p5_a18 NUMBER
, p5_a19 NUMBER
, p5_a20 NUMBER
, p5_a21 DATE
, p5_a22 DATE
, p5_a23 DATE
, p5_a24 DATE
, p5_a25 DATE
, p5_a26 DATE
, p5_a27 VARCHAR2
, p5_a28 NUMBER
, p5_a29 VARCHAR2
, p5_a30 VARCHAR2
, p5_a31 NUMBER
, p5_a32 VARCHAR2
, p5_a33 VARCHAR2
, p5_a34 VARCHAR2
, p5_a35 NUMBER
, p5_a36 VARCHAR2
, p5_a37 NUMBER
, p5_a38 NUMBER
, p5_a39 NUMBER
, p5_a40 DATE
, p5_a41 NUMBER
, p5_a42 DATE
, p5_a43 NUMBER
, p5_a44 VARCHAR2
, p5_a45 VARCHAR2
, p5_a46 VARCHAR2
, p5_a47 VARCHAR2
, p5_a48 VARCHAR2
, p5_a49 VARCHAR2
, p5_a50 VARCHAR2
, p5_a51 VARCHAR2
, p5_a52 VARCHAR2
, p5_a53 VARCHAR2
, p5_a54 VARCHAR2
, p5_a55 VARCHAR2
, p5_a56 VARCHAR2
, p5_a57 VARCHAR2
, p5_a58 VARCHAR2
, p5_a59 VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
ddp_cost_price_rec.is_cst_struc_updated := p5_a15;
ddp_cost_price_rec.last_updated_by := p5_a41;
ddp_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
ddp_cost_price_rec.last_update_login := p5_a43;
ahl_vwp_task_cst_pr_pvt.update_task_cost_details(p_api_version,
p_init_msg_list,
p_commit,
p_validation_level,
p_module_type,
ddp_cost_price_rec,
x_return_status,
x_msg_count,
x_msg_data);
ddp_x_cost_price_rec.is_cst_struc_updated := p8_a15;
ddp_x_cost_price_rec.last_updated_by := p8_a41;
ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a42);
ddp_x_cost_price_rec.last_update_login := p8_a43;
p8_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
p8_a41 := ddp_x_cost_price_rec.last_updated_by;
p8_a42 := ddp_x_cost_price_rec.last_update_date;
p8_a43 := ddp_x_cost_price_rec.last_update_login;
ddp_cost_price_rec.is_cst_struc_updated := p8_a15;
ddp_cost_price_rec.last_updated_by := p8_a41;
ddp_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a42);
ddp_cost_price_rec.last_update_login := p8_a43;