The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_person_language_2(p_init_msg_list VARCHAR2
, p_object_version_number in out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p1_a0 NUMBER := null
, p1_a1 VARCHAR2 := null
, p1_a2 NUMBER := null
, p1_a3 VARCHAR2 := null
, p1_a4 VARCHAR2 := null
, p1_a5 VARCHAR2 := null
, p1_a6 VARCHAR2 := null
, p1_a7 VARCHAR2 := null
, p1_a8 VARCHAR2 := null
, p1_a9 VARCHAR2 := null
, p1_a10 VARCHAR2 := null
, p1_a11 NUMBER := null
)
as
ddp_person_language_rec hz_person_info_v2pub.person_language_rec_type;
hz_person_info_v2pub.update_person_language(p_init_msg_list,
ddp_person_language_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
ddp_citizenship_rec.birth_or_selected := p1_a2;
procedure update_citizenship_5(p_init_msg_list VARCHAR2
, p_object_version_number in out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p1_a0 NUMBER := null
, p1_a1 NUMBER := null
, p1_a2 VARCHAR := null
, p1_a3 VARCHAR2 := null
, p1_a4 DATE := null
, p1_a5 DATE := null
, p1_a6 DATE := null
, p1_a7 VARCHAR2 := null
, p1_a8 VARCHAR2 := null
, p1_a9 VARCHAR2 := null
, p1_a10 VARCHAR2 := null
, p1_a11 NUMBER := null
)
as
ddp_citizenship_rec hz_person_info_v2pub.citizenship_rec_type;
ddp_citizenship_rec.birth_or_selected := p1_a2;
hz_person_info_v2pub.update_citizenship(p_init_msg_list,
ddp_citizenship_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
p2_a2 := ddx_citizenship_rec.birth_or_selected;
procedure update_education_8(p_init_msg_list VARCHAR2
, p_object_version_number in out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p1_a0 NUMBER := null
, p1_a1 NUMBER := null
, p1_a2 VARCHAR2 := null
, p1_a3 VARCHAR2 := null
, p1_a4 DATE := null
, p1_a5 DATE := null
, p1_a6 VARCHAR2 := null
, p1_a7 NUMBER := null
, p1_a8 VARCHAR2 := null
, p1_a9 VARCHAR2 := null
, p1_a10 VARCHAR2 := null
, p1_a11 NUMBER := null
)
as
ddp_education_rec hz_person_info_v2pub.education_rec_type;
hz_person_info_v2pub.update_education(p_init_msg_list,
ddp_education_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_employment_history_11(p_init_msg_list VARCHAR2
, p_object_version_number in out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p1_a0 NUMBER := null
, p1_a1 NUMBER := null
, p1_a2 DATE := null
, p1_a3 DATE := null
, p1_a4 VARCHAR2 := null
, p1_a5 VARCHAR2 := null
, p1_a6 VARCHAR2 := null
, p1_a7 VARCHAR2 := null
, p1_a8 NUMBER := null
, p1_a9 VARCHAR2 := null
, p1_a10 VARCHAR2 := null
, p1_a11 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 NUMBER := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 NUMBER := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 NUMBER := null
)
as
ddp_employment_history_rec hz_person_info_v2pub.employment_history_rec_type;
hz_person_info_v2pub.update_employment_history(p_init_msg_list,
ddp_employment_history_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_work_class_14(p_init_msg_list VARCHAR2
, p_object_version_number in out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p1_a0 NUMBER := null
, p1_a1 VARCHAR2 := null
, p1_a2 VARCHAR2 := null
, p1_a3 NUMBER := null
, p1_a4 VARCHAR2 := null
, p1_a5 VARCHAR2 := null
, p1_a6 NUMBER := null
)
as
ddp_work_class_rec hz_person_info_v2pub.work_class_rec_type;
hz_person_info_v2pub.update_work_class(p_init_msg_list,
ddp_work_class_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_person_interest_17(p_init_msg_list VARCHAR2
, p_object_version_number in out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p1_a0 NUMBER := null
, p1_a1 VARCHAR2 := null
, p1_a2 NUMBER := null
, p1_a3 VARCHAR2 := null
, p1_a4 VARCHAR2 := null
, p1_a5 VARCHAR2 := null
, p1_a6 VARCHAR2 := null
, p1_a7 VARCHAR2 := null
, p1_a8 VARCHAR2 := null
, p1_a9 VARCHAR2 := null
, p1_a10 DATE := null
, p1_a11 VARCHAR := null
, p1_a12 VARCHAR2 := null
, p1_a13 NUMBER := null
)
as
ddp_person_interest_rec hz_person_info_v2pub.person_interest_rec_type;
hz_person_info_v2pub.update_person_interest(p_init_msg_list,
ddp_person_interest_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);