128: p_cust_party_site_id ,
129: p_cust_account_id ,
130: p_source_org_id ,
131: 1 ,
132: fnd_global.conc_request_id() ,
133: fnd_global.prog_appl_id () ,
134: fnd_global.conc_program_id() ,
135: sysdate ,
136: fnd_global.user_id ,
129: p_cust_account_id ,
130: p_source_org_id ,
131: 1 ,
132: fnd_global.conc_request_id() ,
133: fnd_global.prog_appl_id () ,
134: fnd_global.conc_program_id() ,
135: sysdate ,
136: fnd_global.user_id ,
137: sysdate ,
130: p_source_org_id ,
131: 1 ,
132: fnd_global.conc_request_id() ,
133: fnd_global.prog_appl_id () ,
134: fnd_global.conc_program_id() ,
135: sysdate ,
136: fnd_global.user_id ,
137: sysdate ,
138: fnd_global.user_id ,
132: fnd_global.conc_request_id() ,
133: fnd_global.prog_appl_id () ,
134: fnd_global.conc_program_id() ,
135: sysdate ,
136: fnd_global.user_id ,
137: sysdate ,
138: fnd_global.user_id ,
139: sysdate ,
140: fnd_global.login_id ,
134: fnd_global.conc_program_id() ,
135: sysdate ,
136: fnd_global.user_id ,
137: sysdate ,
138: fnd_global.user_id ,
139: sysdate ,
140: fnd_global.login_id ,
141: p_attribute_category ,
142: p_attribute1 ,
136: fnd_global.user_id ,
137: sysdate ,
138: fnd_global.user_id ,
139: sysdate ,
140: fnd_global.login_id ,
141: p_attribute_category ,
142: p_attribute1 ,
143: p_attribute2 ,
144: p_attribute3 ,
214: SET status_code = p_request_status_code,
215: closed_date = p_closed_date,
216: record_version_number = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number),
217: last_update_date = sysdate,
218: last_updated_by = fnd_global.user_id,
219: last_update_login = fnd_global.login_id
220: WHERE request_id = p_request_id
221: AND NVL(p_record_version_number, record_version_number) = record_version_number;
222:
215: closed_date = p_closed_date,
216: record_version_number = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number),
217: last_update_date = sysdate,
218: last_updated_by = fnd_global.user_id,
219: last_update_login = fnd_global.login_id
220: WHERE request_id = p_request_id
221: AND NVL(p_record_version_number, record_version_number) = record_version_number;
222:
223: EXCEPTION