The following lines contain the word 'select', 'insert', 'update' or 'delete':
t(ddindx).last_updated_by := a29(indx);
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a30(indx));
t(ddindx).last_update_login := a31(indx);
a29(indx) := t(ddindx).last_updated_by;
a30(indx) := t(ddindx).last_update_date;
a31(indx) := t(ddindx).last_update_login;
ddp_sr_record.last_update_channel := p0_a141;
ddp_sr_record.last_update_program_code := p0_a175;
p0_a141 := ddp_sr_record.last_update_channel;
p0_a175 := ddp_sr_record.last_update_program_code;
ddp_service_request_rec.last_update_channel := p13_a141;
ddp_service_request_rec.last_update_program_code := p13_a175;
ddp_service_request_rec.last_update_channel := p13_a141;
ddp_service_request_rec.last_update_program_code := p13_a175;
procedure update_servicerequest(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p_request_id NUMBER
, p_request_number VARCHAR2
, p_audit_comments VARCHAR2
, p_object_version_number NUMBER
, p_resp_appl_id NUMBER
, p_resp_id NUMBER
, p_last_updated_by NUMBER
, p_last_update_login NUMBER
, p_last_update_date date
, p15_a0 DATE
, p15_a1 NUMBER
, p15_a2 VARCHAR2
, p15_a3 NUMBER
, p15_a4 VARCHAR2
, p15_a5 NUMBER
, p15_a6 VARCHAR2
, p15_a7 NUMBER
, p15_a8 VARCHAR2
, p15_a9 DATE
, p15_a10 NUMBER
, p15_a11 NUMBER
, p15_a12 VARCHAR2
, p15_a13 VARCHAR2
, p15_a14 VARCHAR2
, p15_a15 NUMBER
, p15_a16 VARCHAR2
, p15_a17 NUMBER
, p15_a18 VARCHAR2
, p15_a19 VARCHAR2
, p15_a20 NUMBER
, p15_a21 NUMBER
, p15_a22 VARCHAR2
, p15_a23 VARCHAR2
, p15_a24 NUMBER
, p15_a25 NUMBER
, p15_a26 NUMBER
, p15_a27 NUMBER
, p15_a28 NUMBER
, p15_a29 NUMBER
, p15_a30 VARCHAR2
, p15_a31 NUMBER
, p15_a32 NUMBER
, p15_a33 VARCHAR2
, p15_a34 VARCHAR2
, p15_a35 VARCHAR2
, p15_a36 VARCHAR2
, p15_a37 VARCHAR2
, p15_a38 VARCHAR2
, p15_a39 VARCHAR2
, p15_a40 VARCHAR2
, p15_a41 VARCHAR2
, p15_a42 VARCHAR2
, p15_a43 VARCHAR2
, p15_a44 VARCHAR2
, p15_a45 VARCHAR2
, p15_a46 VARCHAR2
, p15_a47 VARCHAR2
, p15_a48 VARCHAR2
, p15_a49 VARCHAR2
, p15_a50 VARCHAR2
, p15_a51 VARCHAR2
, p15_a52 VARCHAR2
, p15_a53 VARCHAR2
, p15_a54 VARCHAR2
, p15_a55 NUMBER
, p15_a56 VARCHAR2
, p15_a57 NUMBER
, p15_a58 VARCHAR2
, p15_a59 VARCHAR2
, p15_a60 DATE
, p15_a61 NUMBER
, p15_a62 VARCHAR2
, p15_a63 VARCHAR2
, p15_a64 VARCHAR2
, p15_a65 VARCHAR2
, p15_a66 VARCHAR2
, p15_a67 VARCHAR2
, p15_a68 VARCHAR2
, p15_a69 VARCHAR2
, p15_a70 VARCHAR2
, p15_a71 VARCHAR2
, p15_a72 VARCHAR2
, p15_a73 VARCHAR2
, p15_a74 VARCHAR2
, p15_a75 VARCHAR2
, p15_a76 VARCHAR2
, p15_a77 VARCHAR2
, p15_a78 VARCHAR2
, p15_a79 VARCHAR2
, p15_a80 VARCHAR2
, p15_a81 VARCHAR2
, p15_a82 VARCHAR2
, p15_a83 VARCHAR2
, p15_a84 VARCHAR2
, p15_a85 VARCHAR2
, p15_a86 VARCHAR2
, p15_a87 VARCHAR2
, p15_a88 VARCHAR2
, p15_a89 VARCHAR2
, p15_a90 VARCHAR2
, p15_a91 VARCHAR2
, p15_a92 VARCHAR2
, p15_a93 VARCHAR2
, p15_a94 NUMBER
, p15_a95 NUMBER
, p15_a96 NUMBER
, p15_a97 NUMBER
, p15_a98 VARCHAR2
, p15_a99 DATE
, p15_a100 VARCHAR2
, p15_a101 NUMBER
, p15_a102 NUMBER
, p15_a103 VARCHAR2
, p15_a104 NUMBER
, p15_a105 VARCHAR2
, p15_a106 NUMBER
, p15_a107 NUMBER
, p15_a108 VARCHAR2
, p15_a109 NUMBER
, p15_a110 VARCHAR2
, p15_a111 VARCHAR2
, p15_a112 VARCHAR2
, p15_a113 DATE
, p15_a114 NUMBER
, p15_a115 NUMBER
, p15_a116 NUMBER
, p15_a117 NUMBER
, p15_a118 NUMBER
, p15_a119 VARCHAR2
, p15_a120 NUMBER
, p15_a121 VARCHAR2
, p15_a122 NUMBER
, p15_a123 VARCHAR2
, p15_a124 NUMBER
, p15_a125 VARCHAR2
, p15_a126 VARCHAR2
, p15_a127 VARCHAR2
, p15_a128 VARCHAR2
, p15_a129 VARCHAR2
, p15_a130 VARCHAR2
, p15_a131 NUMBER
, p15_a132 NUMBER
, p15_a133 VARCHAR2
, p15_a134 NUMBER
, p15_a135 NUMBER
, p15_a136 VARCHAR2
, p15_a137 VARCHAR2
, p15_a138 VARCHAR2
, p15_a139 VARCHAR2
, p15_a140 VARCHAR2
, p15_a141 VARCHAR2
, p15_a142 NUMBER
, p15_a143 VARCHAR2
, p15_a144 NUMBER
, p15_a145 VARCHAR2
, p15_a146 DATE
, p15_a147 DATE
, p15_a148 DATE
, p15_a149 VARCHAR2
, p15_a150 NUMBER
, p15_a151 VARCHAR2
, p15_a152 VARCHAR2
, p15_a153 VARCHAR2
, p15_a154 VARCHAR2
, p15_a155 VARCHAR2
, p15_a156 VARCHAR2
, p15_a157 VARCHAR2
, p15_a158 VARCHAR2
, p15_a159 VARCHAR2
, p15_a160 VARCHAR2
, p15_a161 VARCHAR2
, p15_a162 VARCHAR2
, p15_a163 VARCHAR2
, p15_a164 DATE
, p15_a165 VARCHAR
, p15_a166 VARCHAR
, p15_a167 VARCHAR
, p15_a168 VARCHAR
, p15_a169 NUMBER
, p15_a170 NUMBER
, p15_a171 NUMBER
, p15_a172 NUMBER
, p15_a173 NUMBER
, p15_a174 VARCHAR2
, p15_a175 VARCHAR2
, p15_a176 NUMBER
, p15_a177 NUMBER
, p15_a178 NUMBER
, p15_a179 NUMBER
, p15_a180 NUMBER
, p15_a181 NUMBER
, p15_a182 NUMBER
, p15_a183 NUMBER
, p15_a184 VARCHAR2
, p15_a185 VARCHAR2
, p15_a186 VARCHAR2
, p15_a187 VARCHAR2
, p15_a188 VARCHAR2
, p15_a189 VARCHAR2
, p15_a190 VARCHAR2
, p15_a191 VARCHAR2
, p15_a192 VARCHAR2
, p15_a193 VARCHAR2
, p15_a194 VARCHAR2
, p15_a195 VARCHAR2
, p15_a196 VARCHAR2
, p15_a197 VARCHAR2
, p15_a198 VARCHAR2
, p15_a199 VARCHAR2
, p15_a200 VARCHAR2
, p15_a201 VARCHAR2
, p15_a202 VARCHAR2
, p15_a203 VARCHAR2
, p15_a204 VARCHAR2
, p15_a205 NUMBER
, p15_a206 VARCHAR2
, p15_a207 NUMBER
, p15_a208 VARCHAR2
, p15_a209 VARCHAR2
, p15_a210 NUMBER
, p15_a211 DATE
, p15_a212 NUMBER
, p15_a213 NUMBER
, p15_a214 NUMBER
, p15_a215 NUMBER
, p15_a216 NUMBER
, p15_a217 DATE
, p15_a218 DATE
, p15_a219 DATE
, p15_a220 DATE
, p15_a221 DATE
, p15_a222 DATE
, p15_a223 NUMBER
, p15_a224 NUMBER
, p15_a225 NUMBER
, p16_a0 JTF_VARCHAR2_TABLE_2000
, p16_a1 JTF_VARCHAR2_TABLE_32767
, p16_a2 JTF_VARCHAR2_TABLE_300
, p16_a3 JTF_VARCHAR2_TABLE_100
, p16_a4 JTF_NUMBER_TABLE
, p16_a5 JTF_VARCHAR2_TABLE_100
, p16_a6 JTF_NUMBER_TABLE
, p16_a7 JTF_VARCHAR2_TABLE_100
, p16_a8 JTF_NUMBER_TABLE
, p17_a0 JTF_NUMBER_TABLE
, p17_a1 JTF_NUMBER_TABLE
, p17_a2 JTF_NUMBER_TABLE
, p17_a3 JTF_VARCHAR2_TABLE_100
, p17_a4 JTF_VARCHAR2_TABLE_100
, p17_a5 JTF_VARCHAR2_TABLE_100
, p17_a6 JTF_VARCHAR2_TABLE_100
, p17_a7 JTF_DATE_TABLE
, p17_a8 JTF_DATE_TABLE
, p_called_by_workflow VARCHAR2
, p_workflow_process_id NUMBER
, p_auto_assign VARCHAR2
, p_validate_sr_closure VARCHAR2
, p_auto_close_child_entities VARCHAR2
, p_default_contract_sla_ind VARCHAR2
, p_auto_generate_tasks VARCHAR2
, p25_a0 out nocopy NUMBER
, p25_a1 out nocopy NUMBER
, p25_a2 out nocopy NUMBER
, p25_a3 out nocopy NUMBER
, p25_a4 out nocopy VARCHAR2
, p25_a5 out nocopy DATE
, p25_a6 out nocopy DATE
, p25_a7 out nocopy NUMBER
, p25_a8 out nocopy DATE
, p25_a9 out nocopy NUMBER
)
as
ddp_last_update_date date;
ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
ddp_service_request_rec.last_update_channel := p15_a141;
ddp_service_request_rec.last_update_program_code := p15_a175;
cs_servicerequest_pub.update_servicerequest(p_api_version,
p_init_msg_list,
p_commit,
x_return_status,
x_msg_count,
x_msg_data,
p_request_id,
p_request_number,
p_audit_comments,
p_object_version_number,
p_resp_appl_id,
p_resp_id,
p_last_updated_by,
p_last_update_login,
ddp_last_update_date,
ddp_service_request_rec,
ddp_notes,
ddp_contacts,
p_called_by_workflow,
p_workflow_process_id,
p_auto_assign,
p_validate_sr_closure,
p_auto_close_child_entities,
p_default_contract_sla_ind,
p_auto_generate_tasks,
ddx_sr_update_out_rec);
p25_a0 := ddx_sr_update_out_rec.interaction_id;
p25_a1 := ddx_sr_update_out_rec.workflow_process_id;
p25_a2 := ddx_sr_update_out_rec.individual_owner;
p25_a3 := ddx_sr_update_out_rec.group_owner;
p25_a4 := ddx_sr_update_out_rec.individual_type;
p25_a5 := ddx_sr_update_out_rec.resolved_on_date;
p25_a6 := ddx_sr_update_out_rec.responded_on_date;
p25_a7 := ddx_sr_update_out_rec.status_id;
p25_a8 := ddx_sr_update_out_rec.close_date;
p25_a9 := ddx_sr_update_out_rec.incident_location_id;
procedure update_servicerequest(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p_request_id NUMBER
, p_request_number VARCHAR2
, p_audit_comments VARCHAR2
, p_object_version_number NUMBER
, p_resp_appl_id NUMBER
, p_resp_id NUMBER
, p_last_updated_by NUMBER
, p_last_update_login NUMBER
, p_last_update_date date
, p15_a0 DATE
, p15_a1 NUMBER
, p15_a2 VARCHAR2
, p15_a3 NUMBER
, p15_a4 VARCHAR2
, p15_a5 NUMBER
, p15_a6 VARCHAR2
, p15_a7 NUMBER
, p15_a8 VARCHAR2
, p15_a9 DATE
, p15_a10 NUMBER
, p15_a11 NUMBER
, p15_a12 VARCHAR2
, p15_a13 VARCHAR2
, p15_a14 VARCHAR2
, p15_a15 NUMBER
, p15_a16 VARCHAR2
, p15_a17 NUMBER
, p15_a18 VARCHAR2
, p15_a19 VARCHAR2
, p15_a20 NUMBER
, p15_a21 NUMBER
, p15_a22 VARCHAR2
, p15_a23 VARCHAR2
, p15_a24 NUMBER
, p15_a25 NUMBER
, p15_a26 NUMBER
, p15_a27 NUMBER
, p15_a28 NUMBER
, p15_a29 NUMBER
, p15_a30 VARCHAR2
, p15_a31 NUMBER
, p15_a32 NUMBER
, p15_a33 VARCHAR2
, p15_a34 VARCHAR2
, p15_a35 VARCHAR2
, p15_a36 VARCHAR2
, p15_a37 VARCHAR2
, p15_a38 VARCHAR2
, p15_a39 VARCHAR2
, p15_a40 VARCHAR2
, p15_a41 VARCHAR2
, p15_a42 VARCHAR2
, p15_a43 VARCHAR2
, p15_a44 VARCHAR2
, p15_a45 VARCHAR2
, p15_a46 VARCHAR2
, p15_a47 VARCHAR2
, p15_a48 VARCHAR2
, p15_a49 VARCHAR2
, p15_a50 VARCHAR2
, p15_a51 VARCHAR2
, p15_a52 VARCHAR2
, p15_a53 VARCHAR2
, p15_a54 VARCHAR2
, p15_a55 NUMBER
, p15_a56 VARCHAR2
, p15_a57 NUMBER
, p15_a58 VARCHAR2
, p15_a59 VARCHAR2
, p15_a60 DATE
, p15_a61 NUMBER
, p15_a62 VARCHAR2
, p15_a63 VARCHAR2
, p15_a64 VARCHAR2
, p15_a65 VARCHAR2
, p15_a66 VARCHAR2
, p15_a67 VARCHAR2
, p15_a68 VARCHAR2
, p15_a69 VARCHAR2
, p15_a70 VARCHAR2
, p15_a71 VARCHAR2
, p15_a72 VARCHAR2
, p15_a73 VARCHAR2
, p15_a74 VARCHAR2
, p15_a75 VARCHAR2
, p15_a76 VARCHAR2
, p15_a77 VARCHAR2
, p15_a78 VARCHAR2
, p15_a79 VARCHAR2
, p15_a80 VARCHAR2
, p15_a81 VARCHAR2
, p15_a82 VARCHAR2
, p15_a83 VARCHAR2
, p15_a84 VARCHAR2
, p15_a85 VARCHAR2
, p15_a86 VARCHAR2
, p15_a87 VARCHAR2
, p15_a88 VARCHAR2
, p15_a89 VARCHAR2
, p15_a90 VARCHAR2
, p15_a91 VARCHAR2
, p15_a92 VARCHAR2
, p15_a93 VARCHAR2
, p15_a94 NUMBER
, p15_a95 NUMBER
, p15_a96 NUMBER
, p15_a97 NUMBER
, p15_a98 VARCHAR2
, p15_a99 DATE
, p15_a100 VARCHAR2
, p15_a101 NUMBER
, p15_a102 NUMBER
, p15_a103 VARCHAR2
, p15_a104 NUMBER
, p15_a105 VARCHAR2
, p15_a106 NUMBER
, p15_a107 NUMBER
, p15_a108 VARCHAR2
, p15_a109 NUMBER
, p15_a110 VARCHAR2
, p15_a111 VARCHAR2
, p15_a112 VARCHAR2
, p15_a113 DATE
, p15_a114 NUMBER
, p15_a115 NUMBER
, p15_a116 NUMBER
, p15_a117 NUMBER
, p15_a118 NUMBER
, p15_a119 VARCHAR2
, p15_a120 NUMBER
, p15_a121 VARCHAR2
, p15_a122 NUMBER
, p15_a123 VARCHAR2
, p15_a124 NUMBER
, p15_a125 VARCHAR2
, p15_a126 VARCHAR2
, p15_a127 VARCHAR2
, p15_a128 VARCHAR2
, p15_a129 VARCHAR2
, p15_a130 VARCHAR2
, p15_a131 NUMBER
, p15_a132 NUMBER
, p15_a133 VARCHAR2
, p15_a134 NUMBER
, p15_a135 NUMBER
, p15_a136 VARCHAR2
, p15_a137 VARCHAR2
, p15_a138 VARCHAR2
, p15_a139 VARCHAR2
, p15_a140 VARCHAR2
, p15_a141 VARCHAR2
, p15_a142 NUMBER
, p15_a143 VARCHAR2
, p15_a144 NUMBER
, p15_a145 VARCHAR2
, p15_a146 DATE
, p15_a147 DATE
, p15_a148 DATE
, p15_a149 VARCHAR2
, p15_a150 NUMBER
, p15_a151 VARCHAR2
, p15_a152 VARCHAR2
, p15_a153 VARCHAR2
, p15_a154 VARCHAR2
, p15_a155 VARCHAR2
, p15_a156 VARCHAR2
, p15_a157 VARCHAR2
, p15_a158 VARCHAR2
, p15_a159 VARCHAR2
, p15_a160 VARCHAR2
, p15_a161 VARCHAR2
, p15_a162 VARCHAR2
, p15_a163 VARCHAR2
, p15_a164 DATE
, p15_a165 VARCHAR
, p15_a166 VARCHAR
, p15_a167 VARCHAR
, p15_a168 VARCHAR
, p15_a169 NUMBER
, p15_a170 NUMBER
, p15_a171 NUMBER
, p15_a172 NUMBER
, p15_a173 NUMBER
, p15_a174 VARCHAR2
, p15_a175 VARCHAR2
, p15_a176 NUMBER
, p15_a177 NUMBER
, p15_a178 NUMBER
, p15_a179 NUMBER
, p15_a180 NUMBER
, p15_a181 NUMBER
, p15_a182 NUMBER
, p15_a183 NUMBER
, p15_a184 VARCHAR2
, p15_a185 VARCHAR2
, p15_a186 VARCHAR2
, p15_a187 VARCHAR2
, p15_a188 VARCHAR2
, p15_a189 VARCHAR2
, p15_a190 VARCHAR2
, p15_a191 VARCHAR2
, p15_a192 VARCHAR2
, p15_a193 VARCHAR2
, p15_a194 VARCHAR2
, p15_a195 VARCHAR2
, p15_a196 VARCHAR2
, p15_a197 VARCHAR2
, p15_a198 VARCHAR2
, p15_a199 VARCHAR2
, p15_a200 VARCHAR2
, p15_a201 VARCHAR2
, p15_a202 VARCHAR2
, p15_a203 VARCHAR2
, p15_a204 VARCHAR2
, p15_a205 NUMBER
, p15_a206 VARCHAR2
, p15_a207 NUMBER
, p15_a208 VARCHAR2
, p15_a209 VARCHAR2
, p15_a210 NUMBER
, p15_a211 DATE
, p15_a212 NUMBER
, p15_a213 NUMBER
, p15_a214 NUMBER
, p15_a215 NUMBER
, p15_a216 NUMBER
, p15_a217 DATE
, p15_a218 DATE
, p15_a219 DATE
, p15_a220 DATE
, p15_a221 DATE
, p15_a222 DATE
, p15_a223 NUMBER
, p15_a224 NUMBER
, p15_a225 NUMBER
, p16_a0 JTF_VARCHAR2_TABLE_2000
, p16_a1 JTF_VARCHAR2_TABLE_32767
, p16_a2 JTF_VARCHAR2_TABLE_300
, p16_a3 JTF_VARCHAR2_TABLE_100
, p16_a4 JTF_NUMBER_TABLE
, p16_a5 JTF_VARCHAR2_TABLE_100
, p16_a6 JTF_NUMBER_TABLE
, p16_a7 JTF_VARCHAR2_TABLE_100
, p16_a8 JTF_NUMBER_TABLE
, p17_a0 JTF_NUMBER_TABLE
, p17_a1 JTF_NUMBER_TABLE
, p17_a2 JTF_NUMBER_TABLE
, p17_a3 JTF_VARCHAR2_TABLE_100
, p17_a4 JTF_VARCHAR2_TABLE_100
, p17_a5 JTF_VARCHAR2_TABLE_100
, p17_a6 JTF_VARCHAR2_TABLE_100
, p17_a7 JTF_DATE_TABLE
, p17_a8 JTF_DATE_TABLE
, p_called_by_workflow VARCHAR2
, p_workflow_process_id NUMBER
, p_default_contract_sla_ind VARCHAR2
, x_workflow_process_id out nocopy NUMBER
, x_interaction_id out nocopy NUMBER
)
as
ddp_last_update_date date;
ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
ddp_service_request_rec.last_update_channel := p15_a141;
ddp_service_request_rec.last_update_program_code := p15_a175;
cs_servicerequest_pub.update_servicerequest(p_api_version,
p_init_msg_list,
p_commit,
x_return_status,
x_msg_count,
x_msg_data,
p_request_id,
p_request_number,
p_audit_comments,
p_object_version_number,
p_resp_appl_id,
p_resp_id,
p_last_updated_by,
p_last_update_login,
ddp_last_update_date,
ddp_service_request_rec,
ddp_notes,
ddp_contacts,
p_called_by_workflow,
p_workflow_process_id,
p_default_contract_sla_ind,
x_workflow_process_id,
x_interaction_id);
procedure update_status(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p_resp_appl_id NUMBER
, p_resp_id NUMBER
, p_user_id NUMBER
, p_login_id NUMBER
, p_request_id NUMBER
, p_request_number VARCHAR2
, p_object_version_number NUMBER
, p_status_id NUMBER
, p_status VARCHAR2
, p_closed_date date
, p_audit_comments VARCHAR2
, p_called_by_workflow VARCHAR2
, p_workflow_process_id NUMBER
, p_comments VARCHAR2
, p_public_comment_flag VARCHAR2
, p_validate_sr_closure VARCHAR2
, p_auto_close_child_entities VARCHAR2
, p_auto_generate_tasks VARCHAR2
, x_interaction_id out nocopy NUMBER
)
as
ddp_closed_date date;
cs_servicerequest_pub.update_status(p_api_version,
p_init_msg_list,
p_commit,
x_return_status,
x_msg_count,
x_msg_data,
p_resp_appl_id,
p_resp_id,
p_user_id,
p_login_id,
p_request_id,
p_request_number,
p_object_version_number,
p_status_id,
p_status,
ddp_closed_date,
p_audit_comments,
p_called_by_workflow,
p_workflow_process_id,
p_comments,
p_public_comment_flag,
p_validate_sr_closure,
p_auto_close_child_entities,
p_auto_generate_tasks,
x_interaction_id);
ddp_service_request_rec.last_update_channel := p13_a141;
ddp_service_request_rec.last_update_program_code := p13_a175;
ddx_getsr_out_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a38);
p3_a38 := ddx_getsr_out_rec.last_update_date;