The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_contact_point_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 VARCHAR2 := null
, p1_a2 VARCHAR2 := null
, p1_a3 VARCHAR2 := null
, p1_a4 NUMBER := 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 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 VARCHAR2 := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 VARCHAR2 := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 VARCHAR2 := null
, p1_a25 VARCHAR2 := null
, p1_a26 VARCHAR2 := null
, p1_a27 VARCHAR2 := null
, p1_a28 VARCHAR2 := null
, p1_a29 VARCHAR2 := null
, p1_a30 VARCHAR2 := null
, p1_a31 VARCHAR2 := null
, p1_a32 VARCHAR2 := null
, p1_a33 NUMBER := null
, p1_a34 VARCHAR2 := null
, p2_a0 VARCHAR2 := null
, p2_a1 VARCHAR2 := null
, p2_a2 VARCHAR2 := null
, p2_a3 VARCHAR2 := null
, p2_a4 VARCHAR2 := null
, p2_a5 VARCHAR2 := null
, p2_a6 NUMBER := null
, p2_a7 VARCHAR2 := null
, p3_a0 VARCHAR2 := null
, p3_a1 VARCHAR2 := null
, p4_a0 VARCHAR2 := null
, p4_a1 DATE := null
, p4_a2 NUMBER := null
, p4_a3 VARCHAR2 := null
, p4_a4 VARCHAR2 := null
, p4_a5 VARCHAR2 := null
, p4_a6 VARCHAR2 := null
, p4_a7 VARCHAR2 := null
, p4_a8 VARCHAR2 := null
, p5_a0 VARCHAR2 := null
, p6_a0 VARCHAR2 := null
, p6_a1 VARCHAR2 := null
)
as
ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
hz_contact_point_v2pub.update_contact_point(p_init_msg_list,
ddp_contact_point_rec,
ddp_edi_rec,
ddp_email_rec,
ddp_phone_rec,
ddp_telex_rec,
ddp_web_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_edi_contact_point_9(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 VARCHAR2 := null
, p1_a4 NUMBER := 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 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 VARCHAR2 := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 VARCHAR2 := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 VARCHAR2 := null
, p1_a25 VARCHAR2 := null
, p1_a26 VARCHAR2 := null
, p1_a27 VARCHAR2 := null
, p1_a28 VARCHAR2 := null
, p1_a29 VARCHAR2 := null
, p1_a30 VARCHAR2 := null
, p1_a31 VARCHAR2 := null
, p1_a32 VARCHAR2 := null
, p1_a33 NUMBER := null
, p1_a34 VARCHAR2 := null
, p2_a0 VARCHAR2 := null
, p2_a1 VARCHAR2 := null
, p2_a2 VARCHAR2 := null
, p2_a3 VARCHAR2 := null
, p2_a4 VARCHAR2 := null
, p2_a5 VARCHAR2 := null
, p2_a6 NUMBER := null
, p2_a7 VARCHAR2 := null
)
as
ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
hz_contact_point_v2pub.update_edi_contact_point(p_init_msg_list,
ddp_contact_point_rec,
ddp_edi_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_web_contact_point_10(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 VARCHAR2 := null
, p1_a4 NUMBER := 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 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 VARCHAR2 := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 VARCHAR2 := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 VARCHAR2 := null
, p1_a25 VARCHAR2 := null
, p1_a26 VARCHAR2 := null
, p1_a27 VARCHAR2 := null
, p1_a28 VARCHAR2 := null
, p1_a29 VARCHAR2 := null
, p1_a30 VARCHAR2 := null
, p1_a31 VARCHAR2 := null
, p1_a32 VARCHAR2 := null
, p1_a33 NUMBER := null
, p1_a34 VARCHAR2 := null
, p2_a0 VARCHAR2 := null
, p2_a1 VARCHAR2 := null
)
as
ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
hz_contact_point_v2pub.update_web_contact_point(p_init_msg_list,
ddp_contact_point_rec,
ddp_web_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_eft_contact_point_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 VARCHAR2 := null
, p1_a2 VARCHAR2 := null
, p1_a3 VARCHAR2 := null
, p1_a4 NUMBER := 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 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 VARCHAR2 := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 VARCHAR2 := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 VARCHAR2 := null
, p1_a25 VARCHAR2 := null
, p1_a26 VARCHAR2 := null
, p1_a27 VARCHAR2 := null
, p1_a28 VARCHAR2 := null
, p1_a29 VARCHAR2 := null
, p1_a30 VARCHAR2 := null
, p1_a31 VARCHAR2 := null
, p1_a32 VARCHAR2 := null
, p1_a33 NUMBER := null
, p1_a34 VARCHAR2 := null
, p2_a0 NUMBER := null
, p2_a1 NUMBER := null
, p2_a2 VARCHAR2 := null
, p2_a3 VARCHAR2 := null
)
as
ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
hz_contact_point_v2pub.update_eft_contact_point(p_init_msg_list,
ddp_contact_point_rec,
ddp_eft_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_phone_contact_point_12(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 VARCHAR2 := null
, p1_a4 NUMBER := 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 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 VARCHAR2 := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 VARCHAR2 := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 VARCHAR2 := null
, p1_a25 VARCHAR2 := null
, p1_a26 VARCHAR2 := null
, p1_a27 VARCHAR2 := null
, p1_a28 VARCHAR2 := null
, p1_a29 VARCHAR2 := null
, p1_a30 VARCHAR2 := null
, p1_a31 VARCHAR2 := null
, p1_a32 VARCHAR2 := null
, p1_a33 NUMBER := null
, p1_a34 VARCHAR2 := null
, p2_a0 VARCHAR2 := null
, p2_a1 DATE := null
, p2_a2 NUMBER := null
, p2_a3 VARCHAR2 := null
, p2_a4 VARCHAR2 := null
, p2_a5 VARCHAR2 := null
, p2_a6 VARCHAR2 := null
, p2_a7 VARCHAR2 := null
, p2_a8 VARCHAR2 := null
)
as
ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
hz_contact_point_v2pub.update_phone_contact_point(p_init_msg_list,
ddp_contact_point_rec,
ddp_phone_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_telex_contact_point_13(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 VARCHAR2 := null
, p1_a4 NUMBER := 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 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 VARCHAR2 := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 VARCHAR2 := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 VARCHAR2 := null
, p1_a25 VARCHAR2 := null
, p1_a26 VARCHAR2 := null
, p1_a27 VARCHAR2 := null
, p1_a28 VARCHAR2 := null
, p1_a29 VARCHAR2 := null
, p1_a30 VARCHAR2 := null
, p1_a31 VARCHAR2 := null
, p1_a32 VARCHAR2 := null
, p1_a33 NUMBER := null
, p1_a34 VARCHAR2 := null
, p2_a0 VARCHAR2 := null
)
as
ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
hz_contact_point_v2pub.update_telex_contact_point(p_init_msg_list,
ddp_contact_point_rec,
ddp_telex_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_email_contact_point_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 VARCHAR2 := null
, p1_a4 NUMBER := 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 VARCHAR2 := null
, p1_a12 VARCHAR2 := null
, p1_a13 VARCHAR2 := null
, p1_a14 VARCHAR2 := null
, p1_a15 VARCHAR2 := null
, p1_a16 VARCHAR2 := null
, p1_a17 VARCHAR2 := null
, p1_a18 VARCHAR2 := null
, p1_a19 VARCHAR2 := null
, p1_a20 VARCHAR2 := null
, p1_a21 VARCHAR2 := null
, p1_a22 VARCHAR2 := null
, p1_a23 VARCHAR2 := null
, p1_a24 VARCHAR2 := null
, p1_a25 VARCHAR2 := null
, p1_a26 VARCHAR2 := null
, p1_a27 VARCHAR2 := null
, p1_a28 VARCHAR2 := null
, p1_a29 VARCHAR2 := null
, p1_a30 VARCHAR2 := null
, p1_a31 VARCHAR2 := null
, p1_a32 VARCHAR2 := null
, p1_a33 NUMBER := null
, p1_a34 VARCHAR2 := null
, p2_a0 VARCHAR2 := null
, p2_a1 VARCHAR2 := null
)
as
ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
hz_contact_point_v2pub.update_email_contact_point(p_init_msg_list,
ddp_contact_point_rec,
ddp_email_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);