The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_org_contact_2(p_init_msg_list VARCHAR2
, p_cont_object_version_number in out nocopy NUMBER
, p_rel_object_version_number in out nocopy NUMBER
, p_party_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 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
, 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 VARCHAR2 := null
, p1_a34 VARCHAR2 := null
, p1_a35 VARCHAR2 := null
, p1_a36 VARCHAR2 := null
, p1_a37 VARCHAR2 := null
, p1_a38 VARCHAR2 := null
, p1_a39 VARCHAR2 := null
, p1_a40 NUMBER := null
, p1_a41 NUMBER := null
, p1_a42 NUMBER := null
, p1_a43 VARCHAR2 := null
, p1_a44 VARCHAR2 := null
, p1_a45 NUMBER := null
, p1_a46 VARCHAR2 := null
, p1_a47 VARCHAR2 := null
, p1_a48 VARCHAR2 := null
, p1_a49 VARCHAR2 := null
, p1_a50 VARCHAR2 := null
, p1_a51 DATE := null
, p1_a52 DATE := null
, p1_a53 VARCHAR2 := null
, p1_a54 VARCHAR2 := null
, p1_a55 VARCHAR2 := null
, p1_a56 VARCHAR2 := null
, p1_a57 VARCHAR2 := null
, p1_a58 VARCHAR2 := null
, p1_a59 VARCHAR2 := null
, p1_a60 VARCHAR2 := null
, p1_a61 VARCHAR2 := null
, p1_a62 VARCHAR2 := null
, p1_a63 VARCHAR2 := null
, p1_a64 VARCHAR2 := null
, p1_a65 VARCHAR2 := null
, p1_a66 VARCHAR2 := null
, p1_a67 VARCHAR2 := null
, p1_a68 VARCHAR2 := null
, p1_a69 VARCHAR2 := null
, p1_a70 VARCHAR2 := null
, p1_a71 VARCHAR2 := null
, p1_a72 VARCHAR2 := null
, p1_a73 VARCHAR2 := null
, p1_a74 VARCHAR2 := null
, p1_a75 VARCHAR2 := null
, p1_a76 VARCHAR2 := null
, p1_a77 NUMBER := null
, p1_a78 NUMBER := null
, p1_a79 VARCHAR2 := null
, p1_a80 VARCHAR2 := null
, p1_a81 VARCHAR2 := null
, p1_a82 VARCHAR2 := null
, p1_a83 VARCHAR2 := null
, p1_a84 VARCHAR2 := null
, p1_a85 VARCHAR2 := null
, p1_a86 VARCHAR2 := null
, p1_a87 VARCHAR2 := null
, p1_a88 VARCHAR2 := null
, p1_a89 VARCHAR2 := null
, p1_a90 VARCHAR2 := null
, p1_a91 VARCHAR2 := null
, p1_a92 VARCHAR2 := null
, p1_a93 VARCHAR2 := null
, p1_a94 VARCHAR2 := null
, p1_a95 VARCHAR2 := null
, p1_a96 VARCHAR2 := null
, p1_a97 VARCHAR2 := null
, p1_a98 VARCHAR2 := null
, p1_a99 VARCHAR2 := null
, p1_a100 VARCHAR2 := null
, p1_a101 VARCHAR2 := null
, p1_a102 VARCHAR2 := null
, p1_a103 VARCHAR2 := null
, p1_a104 VARCHAR2 := null
, p1_a105 VARCHAR2 := null
, p1_a106 VARCHAR2 := null
, p1_a107 VARCHAR2 := null
, p1_a108 VARCHAR2 := null
, p1_a109 VARCHAR2 := null
, p1_a110 VARCHAR2 := null
, p1_a111 VARCHAR2 := null
, p1_a112 VARCHAR2 := null
, p1_a113 VARCHAR2 := null
, p1_a114 VARCHAR2 := null
, p1_a115 VARCHAR2 := null
, p1_a116 VARCHAR2 := null
, p1_a117 VARCHAR2 := null
, p1_a118 VARCHAR2 := null
, p1_a119 VARCHAR2 := null
, p1_a120 VARCHAR2 := null
, p1_a121 VARCHAR2 := null
, p1_a122 VARCHAR2 := null
, p1_a123 VARCHAR2 := null
, p1_a124 VARCHAR2 := null
, p1_a125 VARCHAR2 := null
, p1_a126 VARCHAR2 := null
, p1_a127 VARCHAR2 := null
, p1_a128 VARCHAR2 := null
, p1_a129 VARCHAR2 := null
, p1_a130 VARCHAR2 := null
, p1_a131 VARCHAR2 := null
, p1_a132 VARCHAR2 := null
, p1_a133 VARCHAR2 := null
, p1_a134 VARCHAR2 := null
, p1_a135 VARCHAR2 := null
, p1_a136 VARCHAR2 := null
, p1_a137 VARCHAR2 := null
, p1_a138 VARCHAR2 := null
, p1_a139 VARCHAR2 := null
, p1_a140 VARCHAR2 := null
, p1_a141 NUMBER := null
, p1_a142 VARCHAR2 := null
)
as
ddp_org_contact_rec hz_party_contact_v2pub.org_contact_rec_type;
hz_party_contact_v2pub.update_org_contact(p_init_msg_list,
ddp_org_contact_rec,
p_cont_object_version_number,
p_rel_object_version_number,
p_party_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_org_contact_role_4(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 VARCHAR2 := null
, p1_a7 VARCHAR2 := null
, p1_a8 VARCHAR2 := null
, p1_a9 VARCHAR2 := null
, p1_a10 NUMBER := null
)
as
ddp_org_contact_role_rec hz_party_contact_v2pub.org_contact_role_rec_type;
hz_party_contact_v2pub.update_org_contact_role(p_init_msg_list,
ddp_org_contact_role_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);