The following lines contain the word 'select', 'insert', 'update' or 'delete':
ddp_user_preference_rec.last_updated_by := rosetta_g_miss_num_map(p0_a4);
ddp_user_preference_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a5);
ddp_user_preference_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
procedure update_preference(x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p0_a0 NUMBER := 0-1962.0724
, p0_a1 NUMBER := 0-1962.0724
, p0_a2 NUMBER := 0-1962.0724
, p0_a3 DATE := fnd_api.g_miss_date
, p0_a4 NUMBER := 0-1962.0724
, p0_a5 DATE := fnd_api.g_miss_date
, p0_a6 NUMBER := 0-1962.0724
, p0_a7 VARCHAR2 := fnd_api.g_miss_char
, p0_a8 NUMBER := 0-1962.0724
, p0_a9 VARCHAR2 := fnd_api.g_miss_char
, p0_a10 VARCHAR2 := fnd_api.g_miss_char
, p0_a11 VARCHAR2 := fnd_api.g_miss_char
, p0_a12 VARCHAR2 := fnd_api.g_miss_char
, p0_a13 VARCHAR2 := fnd_api.g_miss_char
, p0_a14 VARCHAR2 := fnd_api.g_miss_char
, p0_a15 VARCHAR2 := fnd_api.g_miss_char
, p0_a16 VARCHAR2 := fnd_api.g_miss_char
, p0_a17 VARCHAR2 := fnd_api.g_miss_char
, p0_a18 VARCHAR2 := fnd_api.g_miss_char
, p0_a19 VARCHAR2 := fnd_api.g_miss_char
, p0_a20 VARCHAR2 := fnd_api.g_miss_char
, p0_a21 VARCHAR2 := fnd_api.g_miss_char
, p0_a22 VARCHAR2 := fnd_api.g_miss_char
, p0_a23 VARCHAR2 := fnd_api.g_miss_char
, p0_a24 VARCHAR2 := fnd_api.g_miss_char
, p0_a25 VARCHAR2 := fnd_api.g_miss_char
, p0_a26 VARCHAR2 := fnd_api.g_miss_char
, p0_a27 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;
ddp_user_preference_rec.last_updated_by := rosetta_g_miss_num_map(p0_a4);
ddp_user_preference_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a5);
ddp_user_preference_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
asf_user_preference_pub.update_preference(ddp_user_preference_rec,
x_return_status,
x_msg_count,
x_msg_data);
procedure delete_preference(x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p0_a0 NUMBER := 0-1962.0724
, p0_a1 NUMBER := 0-1962.0724
, p0_a2 NUMBER := 0-1962.0724
, p0_a3 DATE := fnd_api.g_miss_date
, p0_a4 NUMBER := 0-1962.0724
, p0_a5 DATE := fnd_api.g_miss_date
, p0_a6 NUMBER := 0-1962.0724
, p0_a7 VARCHAR2 := fnd_api.g_miss_char
, p0_a8 NUMBER := 0-1962.0724
, p0_a9 VARCHAR2 := fnd_api.g_miss_char
, p0_a10 VARCHAR2 := fnd_api.g_miss_char
, p0_a11 VARCHAR2 := fnd_api.g_miss_char
, p0_a12 VARCHAR2 := fnd_api.g_miss_char
, p0_a13 VARCHAR2 := fnd_api.g_miss_char
, p0_a14 VARCHAR2 := fnd_api.g_miss_char
, p0_a15 VARCHAR2 := fnd_api.g_miss_char
, p0_a16 VARCHAR2 := fnd_api.g_miss_char
, p0_a17 VARCHAR2 := fnd_api.g_miss_char
, p0_a18 VARCHAR2 := fnd_api.g_miss_char
, p0_a19 VARCHAR2 := fnd_api.g_miss_char
, p0_a20 VARCHAR2 := fnd_api.g_miss_char
, p0_a21 VARCHAR2 := fnd_api.g_miss_char
, p0_a22 VARCHAR2 := fnd_api.g_miss_char
, p0_a23 VARCHAR2 := fnd_api.g_miss_char
, p0_a24 VARCHAR2 := fnd_api.g_miss_char
, p0_a25 VARCHAR2 := fnd_api.g_miss_char
, p0_a26 VARCHAR2 := fnd_api.g_miss_char
, p0_a27 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;
ddp_user_preference_rec.last_updated_by := rosetta_g_miss_num_map(p0_a4);
ddp_user_preference_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a5);
ddp_user_preference_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
asf_user_preference_pub.delete_preference(ddp_user_preference_rec,
x_return_status,
x_msg_count,
x_msg_data);