The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_cust_acct_site_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 NUMBER := 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 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 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 VARCHAR2 := null
, p1_a41 VARCHAR2 := null
, p1_a42 VARCHAR2 := null
, p1_a43 VARCHAR2 := null
, p1_a44 VARCHAR2 := null
, p1_a45 VARCHAR2 := null
, p1_a46 VARCHAR2 := null
, p1_a47 VARCHAR2 := null
, p1_a48 VARCHAR2 := null
, p1_a49 VARCHAR2 := null
, p1_a50 VARCHAR2 := null
, p1_a51 NUMBER := null
, p1_a52 VARCHAR2 := null
, p1_a53 NUMBER := null
, p1_a54 NUMBER := null
, p1_a55 NUMBER := null
, p1_a56 VARCHAR2 := null
, p1_a57 VARCHAR2 := null
, p1_a58 VARCHAR2 := null
, p1_a59 NUMBER := null
, p1_a60 NUMBER := null
)
as
ddp_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
hz_cust_account_site_v2pub.update_cust_acct_site(p_init_msg_list,
ddp_cust_acct_site_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_cust_site_use_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 VARCHAR2 := null
, p1_a3 VARCHAR2 := null
, p1_a4 VARCHAR2 := null
, p1_a5 VARCHAR2 := null
, p1_a6 NUMBER := null
, p1_a7 NUMBER := 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 NUMBER := null
, p1_a17 NUMBER := null
, p1_a18 VARCHAR2 := null
, p1_a19 NUMBER := null
, p1_a20 NUMBER := 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
, p1_a35 VARCHAR2 := null
, p1_a36 VARCHAR2 := null
, p1_a37 VARCHAR2 := null
, p1_a38 VARCHAR2 := null
, p1_a39 VARCHAR2 := null
, p1_a40 VARCHAR2 := null
, p1_a41 VARCHAR2 := null
, p1_a42 VARCHAR2 := null
, p1_a43 VARCHAR2 := null
, p1_a44 VARCHAR2 := null
, p1_a45 VARCHAR2 := null
, p1_a46 VARCHAR2 := null
, p1_a47 VARCHAR2 := null
, p1_a48 VARCHAR2 := null
, p1_a49 VARCHAR2 := null
, p1_a50 VARCHAR2 := null
, p1_a51 VARCHAR2 := null
, p1_a52 VARCHAR2 := 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 NUMBER := null
, p1_a75 NUMBER := null
, p1_a76 NUMBER := null
, p1_a77 NUMBER := null
, p1_a78 VARCHAR2 := null
, p1_a79 NUMBER := null
, p1_a80 NUMBER := null
, p1_a81 VARCHAR2 := null
, p1_a82 NUMBER := null
, p1_a83 NUMBER := null
, p1_a84 VARCHAR2 := null
, p1_a85 VARCHAR2 := null
, p1_a86 VARCHAR2 := null
, p1_a87 VARCHAR2 := null
, p1_a88 VARCHAR2 := null
, p1_a89 NUMBER := null
, p1_a90 NUMBER := null
, p1_a91 NUMBER := null
, p1_a92 NUMBER := null
, p1_a93 NUMBER := null
, p1_a94 NUMBER := null
, p1_a95 NUMBER := null
, p1_a96 NUMBER := null
, p1_a97 NUMBER := null
, p1_a98 NUMBER := null
, p1_a99 VARCHAR2 := null
, p1_a100 VARCHAR2 := null
, p1_a101 NUMBER := null
, p1_a102 NUMBER := null
)
as
ddp_cust_site_use_rec hz_cust_account_site_v2pub.cust_site_use_rec_type;
hz_cust_account_site_v2pub.update_cust_site_use(p_init_msg_list,
ddp_cust_site_use_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);