The following lines contain the word 'select', 'insert', 'update' or 'delete':
t(ddindx).last_updated_by := a25(indx);
t(ddindx).last_update_login := a26(indx);
t(ddindx).last_update_date := a27(indx);
t(ddindx).program_update_date := a147(indx);
a25(indx) := t(ddindx).last_updated_by;
a26(indx) := t(ddindx).last_update_login;
a27(indx) := t(ddindx).last_update_date;
a147(indx) := t(ddindx).program_update_date;
ddp_srch_attr_rec.last_updated_by := p12_a25;
ddp_srch_attr_rec.last_update_login := p12_a26;
ddp_srch_attr_rec.last_update_date := p12_a27;
ddp_srch_attr_rec.program_update_date := p12_a147;
procedure insert_api_record(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_validation_level VARCHAR2
, p_action VARCHAR2
, p4_a0 NUMBER
, p4_a1 VARCHAR2
, p4_a2 VARCHAR2
, p4_a3 NUMBER
, p4_a4 NUMBER
, p4_a5 VARCHAR2
, p4_a6 DATE
, p4_a7 DATE
, p4_a8 NUMBER
, p4_a9 NUMBER
, p4_a10 NUMBER
, p4_a11 NUMBER
, p4_a12 NUMBER
, p4_a13 VARCHAR2
, p4_a14 NUMBER
, p4_a15 VARCHAR2
, p4_a16 VARCHAR2
, p4_a17 VARCHAR2
, p4_a18 VARCHAR2
, p4_a19 VARCHAR2
, p4_a20 VARCHAR2
, p4_a21 VARCHAR2
, p4_a22 NUMBER
, p4_a23 NUMBER
, p4_a24 DATE
, p4_a25 NUMBER
, p4_a26 NUMBER
, p4_a27 DATE
, p4_a28 VARCHAR2
, p4_a29 VARCHAR2
, p4_a30 VARCHAR2
, p4_a31 VARCHAR2
, p4_a32 VARCHAR2
, p4_a33 VARCHAR2
, p4_a34 VARCHAR2
, p4_a35 VARCHAR2
, p4_a36 VARCHAR2
, p4_a37 VARCHAR2
, p4_a38 VARCHAR2
, p4_a39 VARCHAR2
, p4_a40 VARCHAR2
, p4_a41 VARCHAR2
, p4_a42 VARCHAR2
, p4_a43 VARCHAR2
, p4_a44 VARCHAR2
, p4_a45 VARCHAR2
, p4_a46 VARCHAR2
, p4_a47 VARCHAR2
, p4_a48 VARCHAR2
, p4_a49 VARCHAR2
, p4_a50 VARCHAR2
, p4_a51 VARCHAR2
, p4_a52 VARCHAR2
, p4_a53 VARCHAR2
, p4_a54 VARCHAR2
, p4_a55 VARCHAR2
, p4_a56 VARCHAR2
, p4_a57 VARCHAR2
, p4_a58 VARCHAR2
, p4_a59 VARCHAR2
, p4_a60 VARCHAR2
, p4_a61 VARCHAR2
, p4_a62 VARCHAR2
, p4_a63 VARCHAR2
, p4_a64 VARCHAR2
, p4_a65 VARCHAR2
, p4_a66 VARCHAR2
, p4_a67 VARCHAR2
, p4_a68 VARCHAR2
, p4_a69 VARCHAR2
, p4_a70 VARCHAR2
, p4_a71 VARCHAR2
, p4_a72 VARCHAR2
, p4_a73 VARCHAR2
, p4_a74 VARCHAR2
, p4_a75 VARCHAR2
, p4_a76 VARCHAR2
, p4_a77 VARCHAR2
, p4_a78 VARCHAR2
, p4_a79 VARCHAR2
, p4_a80 VARCHAR2
, p4_a81 VARCHAR2
, p4_a82 VARCHAR2
, p4_a83 VARCHAR2
, p4_a84 VARCHAR2
, p4_a85 VARCHAR2
, p4_a86 VARCHAR2
, p4_a87 VARCHAR2
, p4_a88 VARCHAR2
, p4_a89 VARCHAR2
, p4_a90 VARCHAR2
, p4_a91 VARCHAR2
, p4_a92 VARCHAR2
, p4_a93 VARCHAR2
, p4_a94 VARCHAR2
, p4_a95 VARCHAR2
, p4_a96 VARCHAR2
, p4_a97 VARCHAR2
, p4_a98 VARCHAR2
, p4_a99 VARCHAR2
, p4_a100 VARCHAR2
, p4_a101 VARCHAR2
, p4_a102 VARCHAR2
, p4_a103 VARCHAR2
, p4_a104 VARCHAR2
, p4_a105 VARCHAR2
, p4_a106 VARCHAR2
, p4_a107 VARCHAR2
, p4_a108 VARCHAR2
, p4_a109 VARCHAR2
, p4_a110 VARCHAR2
, p4_a111 VARCHAR2
, p4_a112 VARCHAR2
, p4_a113 VARCHAR2
, p4_a114 VARCHAR2
, p4_a115 VARCHAR2
, p4_a116 VARCHAR2
, p4_a117 VARCHAR2
, p4_a118 VARCHAR2
, p4_a119 VARCHAR2
, p4_a120 VARCHAR2
, p4_a121 VARCHAR2
, p4_a122 VARCHAR2
, p4_a123 VARCHAR2
, p4_a124 VARCHAR2
, p4_a125 VARCHAR2
, p4_a126 VARCHAR2
, p4_a127 VARCHAR2
, p4_a128 VARCHAR2
, p4_a129 NUMBER
, p4_a130 VARCHAR2
, p4_a131 NUMBER
, p4_a132 VARCHAR2
, p4_a133 VARCHAR2
, p4_a134 VARCHAR2
, p4_a135 NUMBER
, p4_a136 NUMBER
, p4_a137 NUMBER
, p4_a138 NUMBER
, p4_a139 VARCHAR2
, p4_a140 NUMBER
, p4_a141 NUMBER
, p4_a142 VARCHAR2
, p4_a143 NUMBER
, p4_a144 NUMBER
, p4_a145 NUMBER
, p4_a146 NUMBER
, p4_a147 DATE
, p4_a148 NUMBER
, p4_a149 VARCHAR2
, p4_a150 DATE
, p4_a151 NUMBER
, p4_a152 DATE
, p4_a153 NUMBER
, p4_a154 NUMBER
, p4_a155 NUMBER
, p4_a156 NUMBER
, p4_a157 NUMBER
, p4_a158 NUMBER
, p4_a159 VARCHAR2
, p4_a160 VARCHAR2
, p4_a161 VARCHAR2
, p4_a162 VARCHAR2
, p4_a163 DATE
, p4_a164 VARCHAR2
, p4_a165 VARCHAR2
, p4_a166 VARCHAR2
, p4_a167 VARCHAR2
, p4_a168 VARCHAR2
, p4_a169 VARCHAR2
, p4_a170 NUMBER
, p4_a171 NUMBER
, p4_a172 NUMBER
, p4_a173 VARCHAR2
, p4_a174 NUMBER
, p4_a175 NUMBER
, p4_a176 VARCHAR2
, p4_a177 NUMBER
, p4_a178 VARCHAR2
, p4_a179 VARCHAR2
, p4_a180 VARCHAR2
, p4_a181 VARCHAR2
, p4_a182 VARCHAR2
, p4_a183 NUMBER
, p4_a184 NUMBER
, p4_a185 NUMBER
, p4_a186 NUMBER
, p4_a187 NUMBER
, p4_a188 NUMBER
, p4_a189 VARCHAR2
, p4_a190 VARCHAR2
, x_api_id out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_loading_status out nocopy VARCHAR2
)
as
ddp_newtx_rec cn_get_tx_data_pub.adj_rec_type;
ddp_newtx_rec.last_updated_by := p4_a25;
ddp_newtx_rec.last_update_login := p4_a26;
ddp_newtx_rec.last_update_date := p4_a27;
ddp_newtx_rec.program_update_date := p4_a147;
cn_get_tx_data_pub.insert_api_record(p_api_version,
p_init_msg_list,
p_validation_level,
p_action,
ddp_newtx_rec,
x_api_id,
x_return_status,
x_msg_count,
x_msg_data,
x_loading_status);
procedure call_mass_update(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_validation_level VARCHAR2
, p_org_id NUMBER
, p_salesrep_id NUMBER
, p_pr_date_to DATE
, p_pr_date_from DATE
, p_calc_status VARCHAR2
, p_adj_status VARCHAR2
, p_load_status VARCHAR2
, p_invoice_num VARCHAR2
, p_order_num NUMBER
, p12_a0 NUMBER
, p12_a1 VARCHAR2
, p12_a2 VARCHAR2
, p12_a3 NUMBER
, p12_a4 NUMBER
, p12_a5 VARCHAR2
, p12_a6 DATE
, p12_a7 DATE
, p12_a8 NUMBER
, p12_a9 NUMBER
, p12_a10 NUMBER
, p12_a11 NUMBER
, p12_a12 NUMBER
, p12_a13 VARCHAR2
, p12_a14 NUMBER
, p12_a15 VARCHAR2
, p12_a16 VARCHAR2
, p12_a17 VARCHAR2
, p12_a18 VARCHAR2
, p12_a19 VARCHAR2
, p12_a20 VARCHAR2
, p12_a21 VARCHAR2
, p12_a22 NUMBER
, p12_a23 NUMBER
, p12_a24 DATE
, p12_a25 NUMBER
, p12_a26 NUMBER
, p12_a27 DATE
, p12_a28 VARCHAR2
, p12_a29 VARCHAR2
, p12_a30 VARCHAR2
, p12_a31 VARCHAR2
, p12_a32 VARCHAR2
, p12_a33 VARCHAR2
, p12_a34 VARCHAR2
, p12_a35 VARCHAR2
, p12_a36 VARCHAR2
, p12_a37 VARCHAR2
, p12_a38 VARCHAR2
, p12_a39 VARCHAR2
, p12_a40 VARCHAR2
, p12_a41 VARCHAR2
, p12_a42 VARCHAR2
, p12_a43 VARCHAR2
, p12_a44 VARCHAR2
, p12_a45 VARCHAR2
, p12_a46 VARCHAR2
, p12_a47 VARCHAR2
, p12_a48 VARCHAR2
, p12_a49 VARCHAR2
, p12_a50 VARCHAR2
, p12_a51 VARCHAR2
, p12_a52 VARCHAR2
, p12_a53 VARCHAR2
, p12_a54 VARCHAR2
, p12_a55 VARCHAR2
, p12_a56 VARCHAR2
, p12_a57 VARCHAR2
, p12_a58 VARCHAR2
, p12_a59 VARCHAR2
, p12_a60 VARCHAR2
, p12_a61 VARCHAR2
, p12_a62 VARCHAR2
, p12_a63 VARCHAR2
, p12_a64 VARCHAR2
, p12_a65 VARCHAR2
, p12_a66 VARCHAR2
, p12_a67 VARCHAR2
, p12_a68 VARCHAR2
, p12_a69 VARCHAR2
, p12_a70 VARCHAR2
, p12_a71 VARCHAR2
, p12_a72 VARCHAR2
, p12_a73 VARCHAR2
, p12_a74 VARCHAR2
, p12_a75 VARCHAR2
, p12_a76 VARCHAR2
, p12_a77 VARCHAR2
, p12_a78 VARCHAR2
, p12_a79 VARCHAR2
, p12_a80 VARCHAR2
, p12_a81 VARCHAR2
, p12_a82 VARCHAR2
, p12_a83 VARCHAR2
, p12_a84 VARCHAR2
, p12_a85 VARCHAR2
, p12_a86 VARCHAR2
, p12_a87 VARCHAR2
, p12_a88 VARCHAR2
, p12_a89 VARCHAR2
, p12_a90 VARCHAR2
, p12_a91 VARCHAR2
, p12_a92 VARCHAR2
, p12_a93 VARCHAR2
, p12_a94 VARCHAR2
, p12_a95 VARCHAR2
, p12_a96 VARCHAR2
, p12_a97 VARCHAR2
, p12_a98 VARCHAR2
, p12_a99 VARCHAR2
, p12_a100 VARCHAR2
, p12_a101 VARCHAR2
, p12_a102 VARCHAR2
, p12_a103 VARCHAR2
, p12_a104 VARCHAR2
, p12_a105 VARCHAR2
, p12_a106 VARCHAR2
, p12_a107 VARCHAR2
, p12_a108 VARCHAR2
, p12_a109 VARCHAR2
, p12_a110 VARCHAR2
, p12_a111 VARCHAR2
, p12_a112 VARCHAR2
, p12_a113 VARCHAR2
, p12_a114 VARCHAR2
, p12_a115 VARCHAR2
, p12_a116 VARCHAR2
, p12_a117 VARCHAR2
, p12_a118 VARCHAR2
, p12_a119 VARCHAR2
, p12_a120 VARCHAR2
, p12_a121 VARCHAR2
, p12_a122 VARCHAR2
, p12_a123 VARCHAR2
, p12_a124 VARCHAR2
, p12_a125 VARCHAR2
, p12_a126 VARCHAR2
, p12_a127 VARCHAR2
, p12_a128 VARCHAR2
, p12_a129 NUMBER
, p12_a130 VARCHAR2
, p12_a131 NUMBER
, p12_a132 VARCHAR2
, p12_a133 VARCHAR2
, p12_a134 VARCHAR2
, p12_a135 NUMBER
, p12_a136 NUMBER
, p12_a137 NUMBER
, p12_a138 NUMBER
, p12_a139 VARCHAR2
, p12_a140 NUMBER
, p12_a141 NUMBER
, p12_a142 VARCHAR2
, p12_a143 NUMBER
, p12_a144 NUMBER
, p12_a145 NUMBER
, p12_a146 NUMBER
, p12_a147 DATE
, p12_a148 NUMBER
, p12_a149 VARCHAR2
, p12_a150 DATE
, p12_a151 NUMBER
, p12_a152 DATE
, p12_a153 NUMBER
, p12_a154 NUMBER
, p12_a155 NUMBER
, p12_a156 NUMBER
, p12_a157 NUMBER
, p12_a158 NUMBER
, p12_a159 VARCHAR2
, p12_a160 VARCHAR2
, p12_a161 VARCHAR2
, p12_a162 VARCHAR2
, p12_a163 DATE
, p12_a164 VARCHAR2
, p12_a165 VARCHAR2
, p12_a166 VARCHAR2
, p12_a167 VARCHAR2
, p12_a168 VARCHAR2
, p12_a169 VARCHAR2
, p12_a170 NUMBER
, p12_a171 NUMBER
, p12_a172 NUMBER
, p12_a173 VARCHAR2
, p12_a174 NUMBER
, p12_a175 NUMBER
, p12_a176 VARCHAR2
, p12_a177 NUMBER
, p12_a178 VARCHAR2
, p12_a179 VARCHAR2
, p12_a180 VARCHAR2
, p12_a181 VARCHAR2
, p12_a182 VARCHAR2
, p12_a183 NUMBER
, p12_a184 NUMBER
, p12_a185 NUMBER
, p12_a186 NUMBER
, p12_a187 NUMBER
, p12_a188 NUMBER
, p12_a189 VARCHAR2
, p12_a190 VARCHAR2
, p_mass_adj_type VARCHAR2
, p14_a0 NUMBER
, p14_a1 VARCHAR2
, p14_a2 VARCHAR2
, p14_a3 NUMBER
, p14_a4 NUMBER
, p14_a5 VARCHAR2
, p14_a6 DATE
, p14_a7 DATE
, p14_a8 NUMBER
, p14_a9 NUMBER
, p14_a10 NUMBER
, p14_a11 NUMBER
, p14_a12 NUMBER
, p14_a13 VARCHAR2
, p14_a14 NUMBER
, p14_a15 VARCHAR2
, p14_a16 VARCHAR2
, p14_a17 VARCHAR2
, p14_a18 VARCHAR2
, p14_a19 VARCHAR2
, p14_a20 VARCHAR2
, p14_a21 VARCHAR2
, p14_a22 NUMBER
, p14_a23 NUMBER
, p14_a24 DATE
, p14_a25 NUMBER
, p14_a26 NUMBER
, p14_a27 DATE
, p14_a28 VARCHAR2
, p14_a29 VARCHAR2
, p14_a30 VARCHAR2
, p14_a31 VARCHAR2
, p14_a32 VARCHAR2
, p14_a33 VARCHAR2
, p14_a34 VARCHAR2
, p14_a35 VARCHAR2
, p14_a36 VARCHAR2
, p14_a37 VARCHAR2
, p14_a38 VARCHAR2
, p14_a39 VARCHAR2
, p14_a40 VARCHAR2
, p14_a41 VARCHAR2
, p14_a42 VARCHAR2
, p14_a43 VARCHAR2
, p14_a44 VARCHAR2
, p14_a45 VARCHAR2
, p14_a46 VARCHAR2
, p14_a47 VARCHAR2
, p14_a48 VARCHAR2
, p14_a49 VARCHAR2
, p14_a50 VARCHAR2
, p14_a51 VARCHAR2
, p14_a52 VARCHAR2
, p14_a53 VARCHAR2
, p14_a54 VARCHAR2
, p14_a55 VARCHAR2
, p14_a56 VARCHAR2
, p14_a57 VARCHAR2
, p14_a58 VARCHAR2
, p14_a59 VARCHAR2
, p14_a60 VARCHAR2
, p14_a61 VARCHAR2
, p14_a62 VARCHAR2
, p14_a63 VARCHAR2
, p14_a64 VARCHAR2
, p14_a65 VARCHAR2
, p14_a66 VARCHAR2
, p14_a67 VARCHAR2
, p14_a68 VARCHAR2
, p14_a69 VARCHAR2
, p14_a70 VARCHAR2
, p14_a71 VARCHAR2
, p14_a72 VARCHAR2
, p14_a73 VARCHAR2
, p14_a74 VARCHAR2
, p14_a75 VARCHAR2
, p14_a76 VARCHAR2
, p14_a77 VARCHAR2
, p14_a78 VARCHAR2
, p14_a79 VARCHAR2
, p14_a80 VARCHAR2
, p14_a81 VARCHAR2
, p14_a82 VARCHAR2
, p14_a83 VARCHAR2
, p14_a84 VARCHAR2
, p14_a85 VARCHAR2
, p14_a86 VARCHAR2
, p14_a87 VARCHAR2
, p14_a88 VARCHAR2
, p14_a89 VARCHAR2
, p14_a90 VARCHAR2
, p14_a91 VARCHAR2
, p14_a92 VARCHAR2
, p14_a93 VARCHAR2
, p14_a94 VARCHAR2
, p14_a95 VARCHAR2
, p14_a96 VARCHAR2
, p14_a97 VARCHAR2
, p14_a98 VARCHAR2
, p14_a99 VARCHAR2
, p14_a100 VARCHAR2
, p14_a101 VARCHAR2
, p14_a102 VARCHAR2
, p14_a103 VARCHAR2
, p14_a104 VARCHAR2
, p14_a105 VARCHAR2
, p14_a106 VARCHAR2
, p14_a107 VARCHAR2
, p14_a108 VARCHAR2
, p14_a109 VARCHAR2
, p14_a110 VARCHAR2
, p14_a111 VARCHAR2
, p14_a112 VARCHAR2
, p14_a113 VARCHAR2
, p14_a114 VARCHAR2
, p14_a115 VARCHAR2
, p14_a116 VARCHAR2
, p14_a117 VARCHAR2
, p14_a118 VARCHAR2
, p14_a119 VARCHAR2
, p14_a120 VARCHAR2
, p14_a121 VARCHAR2
, p14_a122 VARCHAR2
, p14_a123 VARCHAR2
, p14_a124 VARCHAR2
, p14_a125 VARCHAR2
, p14_a126 VARCHAR2
, p14_a127 VARCHAR2
, p14_a128 VARCHAR2
, p14_a129 NUMBER
, p14_a130 VARCHAR2
, p14_a131 NUMBER
, p14_a132 VARCHAR2
, p14_a133 VARCHAR2
, p14_a134 VARCHAR2
, p14_a135 NUMBER
, p14_a136 NUMBER
, p14_a137 NUMBER
, p14_a138 NUMBER
, p14_a139 VARCHAR2
, p14_a140 NUMBER
, p14_a141 NUMBER
, p14_a142 VARCHAR2
, p14_a143 NUMBER
, p14_a144 NUMBER
, p14_a145 NUMBER
, p14_a146 NUMBER
, p14_a147 DATE
, p14_a148 NUMBER
, p14_a149 VARCHAR2
, p14_a150 DATE
, p14_a151 NUMBER
, p14_a152 DATE
, p14_a153 NUMBER
, p14_a154 NUMBER
, p14_a155 NUMBER
, p14_a156 NUMBER
, p14_a157 NUMBER
, p14_a158 NUMBER
, p14_a159 VARCHAR2
, p14_a160 VARCHAR2
, p14_a161 VARCHAR2
, p14_a162 VARCHAR2
, p14_a163 DATE
, p14_a164 VARCHAR2
, p14_a165 VARCHAR2
, p14_a166 VARCHAR2
, p14_a167 VARCHAR2
, p14_a168 VARCHAR2
, p14_a169 VARCHAR2
, p14_a170 NUMBER
, p14_a171 NUMBER
, p14_a172 NUMBER
, p14_a173 VARCHAR2
, p14_a174 NUMBER
, p14_a175 NUMBER
, p14_a176 VARCHAR2
, p14_a177 NUMBER
, p14_a178 VARCHAR2
, p14_a179 VARCHAR2
, p14_a180 VARCHAR2
, p14_a181 VARCHAR2
, p14_a182 VARCHAR2
, p14_a183 NUMBER
, p14_a184 NUMBER
, p14_a185 NUMBER
, p14_a186 NUMBER
, p14_a187 NUMBER
, p14_a188 NUMBER
, p14_a189 VARCHAR2
, p14_a190 VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_loading_status out nocopy VARCHAR2
)
as
ddp_srch_attr_rec cn_get_tx_data_pub.adj_rec_type;
ddp_srch_attr_rec.last_updated_by := p12_a25;
ddp_srch_attr_rec.last_update_login := p12_a26;
ddp_srch_attr_rec.last_update_date := p12_a27;
ddp_srch_attr_rec.program_update_date := p12_a147;
ddp_adj_rec.last_updated_by := p14_a25;
ddp_adj_rec.last_update_login := p14_a26;
ddp_adj_rec.last_update_date := p14_a27;
ddp_adj_rec.program_update_date := p14_a147;
cn_get_tx_data_pub.call_mass_update(p_api_version,
p_init_msg_list,
p_validation_level,
p_org_id,
p_salesrep_id,
p_pr_date_to,
p_pr_date_from,
p_calc_status,
p_adj_status,
p_load_status,
p_invoice_num,
p_order_num,
ddp_srch_attr_rec,
p_mass_adj_type,
ddp_adj_rec,
x_return_status,
x_msg_count,
x_msg_data,
x_loading_status);
procedure update_api_record(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_validation_level VARCHAR2
, p3_a0 NUMBER
, p3_a1 VARCHAR2
, p3_a2 VARCHAR2
, p3_a3 NUMBER
, p3_a4 NUMBER
, p3_a5 VARCHAR2
, p3_a6 DATE
, p3_a7 DATE
, p3_a8 NUMBER
, p3_a9 NUMBER
, p3_a10 NUMBER
, p3_a11 NUMBER
, p3_a12 NUMBER
, p3_a13 VARCHAR2
, p3_a14 NUMBER
, p3_a15 VARCHAR2
, p3_a16 VARCHAR2
, p3_a17 VARCHAR2
, p3_a18 VARCHAR2
, p3_a19 VARCHAR2
, p3_a20 VARCHAR2
, p3_a21 VARCHAR2
, p3_a22 NUMBER
, p3_a23 NUMBER
, p3_a24 DATE
, p3_a25 NUMBER
, p3_a26 NUMBER
, p3_a27 DATE
, p3_a28 VARCHAR2
, p3_a29 VARCHAR2
, p3_a30 VARCHAR2
, p3_a31 VARCHAR2
, p3_a32 VARCHAR2
, p3_a33 VARCHAR2
, p3_a34 VARCHAR2
, p3_a35 VARCHAR2
, p3_a36 VARCHAR2
, p3_a37 VARCHAR2
, p3_a38 VARCHAR2
, p3_a39 VARCHAR2
, p3_a40 VARCHAR2
, p3_a41 VARCHAR2
, p3_a42 VARCHAR2
, p3_a43 VARCHAR2
, p3_a44 VARCHAR2
, p3_a45 VARCHAR2
, p3_a46 VARCHAR2
, p3_a47 VARCHAR2
, p3_a48 VARCHAR2
, p3_a49 VARCHAR2
, p3_a50 VARCHAR2
, p3_a51 VARCHAR2
, p3_a52 VARCHAR2
, p3_a53 VARCHAR2
, p3_a54 VARCHAR2
, p3_a55 VARCHAR2
, p3_a56 VARCHAR2
, p3_a57 VARCHAR2
, p3_a58 VARCHAR2
, p3_a59 VARCHAR2
, p3_a60 VARCHAR2
, p3_a61 VARCHAR2
, p3_a62 VARCHAR2
, p3_a63 VARCHAR2
, p3_a64 VARCHAR2
, p3_a65 VARCHAR2
, p3_a66 VARCHAR2
, p3_a67 VARCHAR2
, p3_a68 VARCHAR2
, p3_a69 VARCHAR2
, p3_a70 VARCHAR2
, p3_a71 VARCHAR2
, p3_a72 VARCHAR2
, p3_a73 VARCHAR2
, p3_a74 VARCHAR2
, p3_a75 VARCHAR2
, p3_a76 VARCHAR2
, p3_a77 VARCHAR2
, p3_a78 VARCHAR2
, p3_a79 VARCHAR2
, p3_a80 VARCHAR2
, p3_a81 VARCHAR2
, p3_a82 VARCHAR2
, p3_a83 VARCHAR2
, p3_a84 VARCHAR2
, p3_a85 VARCHAR2
, p3_a86 VARCHAR2
, p3_a87 VARCHAR2
, p3_a88 VARCHAR2
, p3_a89 VARCHAR2
, p3_a90 VARCHAR2
, p3_a91 VARCHAR2
, p3_a92 VARCHAR2
, p3_a93 VARCHAR2
, p3_a94 VARCHAR2
, p3_a95 VARCHAR2
, p3_a96 VARCHAR2
, p3_a97 VARCHAR2
, p3_a98 VARCHAR2
, p3_a99 VARCHAR2
, p3_a100 VARCHAR2
, p3_a101 VARCHAR2
, p3_a102 VARCHAR2
, p3_a103 VARCHAR2
, p3_a104 VARCHAR2
, p3_a105 VARCHAR2
, p3_a106 VARCHAR2
, p3_a107 VARCHAR2
, p3_a108 VARCHAR2
, p3_a109 VARCHAR2
, p3_a110 VARCHAR2
, p3_a111 VARCHAR2
, p3_a112 VARCHAR2
, p3_a113 VARCHAR2
, p3_a114 VARCHAR2
, p3_a115 VARCHAR2
, p3_a116 VARCHAR2
, p3_a117 VARCHAR2
, p3_a118 VARCHAR2
, p3_a119 VARCHAR2
, p3_a120 VARCHAR2
, p3_a121 VARCHAR2
, p3_a122 VARCHAR2
, p3_a123 VARCHAR2
, p3_a124 VARCHAR2
, p3_a125 VARCHAR2
, p3_a126 VARCHAR2
, p3_a127 VARCHAR2
, p3_a128 VARCHAR2
, p3_a129 NUMBER
, p3_a130 VARCHAR2
, p3_a131 NUMBER
, p3_a132 VARCHAR2
, p3_a133 VARCHAR2
, p3_a134 VARCHAR2
, p3_a135 NUMBER
, p3_a136 NUMBER
, p3_a137 NUMBER
, p3_a138 NUMBER
, p3_a139 VARCHAR2
, p3_a140 NUMBER
, p3_a141 NUMBER
, p3_a142 VARCHAR2
, p3_a143 NUMBER
, p3_a144 NUMBER
, p3_a145 NUMBER
, p3_a146 NUMBER
, p3_a147 DATE
, p3_a148 NUMBER
, p3_a149 VARCHAR2
, p3_a150 DATE
, p3_a151 NUMBER
, p3_a152 DATE
, p3_a153 NUMBER
, p3_a154 NUMBER
, p3_a155 NUMBER
, p3_a156 NUMBER
, p3_a157 NUMBER
, p3_a158 NUMBER
, p3_a159 VARCHAR2
, p3_a160 VARCHAR2
, p3_a161 VARCHAR2
, p3_a162 VARCHAR2
, p3_a163 DATE
, p3_a164 VARCHAR2
, p3_a165 VARCHAR2
, p3_a166 VARCHAR2
, p3_a167 VARCHAR2
, p3_a168 VARCHAR2
, p3_a169 VARCHAR2
, p3_a170 NUMBER
, p3_a171 NUMBER
, p3_a172 NUMBER
, p3_a173 VARCHAR2
, p3_a174 NUMBER
, p3_a175 NUMBER
, p3_a176 VARCHAR2
, p3_a177 NUMBER
, p3_a178 VARCHAR2
, p3_a179 VARCHAR2
, p3_a180 VARCHAR2
, p3_a181 VARCHAR2
, p3_a182 VARCHAR2
, p3_a183 NUMBER
, p3_a184 NUMBER
, p3_a185 NUMBER
, p3_a186 NUMBER
, p3_a187 NUMBER
, p3_a188 NUMBER
, p3_a189 VARCHAR2
, p3_a190 VARCHAR2
, x_api_id out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_loading_status out nocopy VARCHAR2
)
as
ddp_newtx_rec cn_get_tx_data_pub.adj_rec_type;
ddp_newtx_rec.last_updated_by := p3_a25;
ddp_newtx_rec.last_update_login := p3_a26;
ddp_newtx_rec.last_update_date := p3_a27;
ddp_newtx_rec.program_update_date := p3_a147;
cn_get_tx_data_pub.update_api_record(p_api_version,
p_init_msg_list,
p_validation_level,
ddp_newtx_rec,
x_api_id,
x_return_status,
x_msg_count,
x_msg_data,
x_loading_status);