APPS.PA_PAY_VALIDATE dependencies on PA_PAY_EXT_INTERFACE_DETAILS

Line 27: from pa_pay_ext_interface_details

23: cursor Interface_details(l_header_id in number) IS
24: select pay_element_type_code ,
25: person_id,
26: assignment_id
27: from pa_pay_ext_interface_details
28: where interface_header_id =l_header_id
29: and nvl(transfer_status_flag,'K') in ('P','R','K')
30: and person_id = nvl(x_person_id,person_id)
31: for update of rejection_code,

Line 146: update pa_pay_ext_interface_details

142: IF SQL%ROWCOUNT > 0 THEN
143: --{
144:
145:
146: update pa_pay_ext_interface_details
147: set rejection_code = 'RC 150',
148: transfer_status_flag = 'R',
149: request_id = l_request_id
150: where interface_header_id = Hdr_rec.interface_header_id;

Line 189: update pa_pay_ext_interface_details

185: IF SQL%ROWCOUNT > 0 THEN
186: --{
187:
188:
189: update pa_pay_ext_interface_details
190: set rejection_code = 'RC 155',
191: transfer_status_flag = 'R',
192: request_id = l_request_id
193: where interface_header_id = Hdr_rec.interface_header_id;

Line 221: update pa_pay_ext_interface_details

217: update pa_pay_ext_interface_header
218: set rejection_code = 'RC 160'
219: where current of Int_header_details;
220:
221: update pa_pay_ext_interface_details
222: set rejection_code = 'RC 160',
223: transfer_status_flag = 'R',
224: request_id = l_request_id
225: where interface_header_id = Hdr_rec.interface_header_id;

Line 256: update pa_pay_ext_interface_details

252: update pa_pay_ext_interface_header
253: set rejection_code = 'RC 165'
254: where current of Int_header_details;
255:
256: update pa_pay_ext_interface_details
257: set rejection_code = 'RC 165',
258: transfer_status_flag = 'R',
259: request_id = l_request_id
260: where interface_header_id = Hdr_rec.interface_header_id;

Line 307: update pa_pay_ext_interface_details

303:
304: IF l_value_exists = 0 THEN
305: --{
306:
307: update pa_pay_ext_interface_details
308: set rejection_code = 'RC 170',
309: transfer_status_flag ='R',
310: request_id = l_request_id
311: where current of Interface_details;

Line 331: update pa_pay_ext_interface_details

327:
328: IF l_value_exists = 0 THEN
329: --{
330:
331: update pa_pay_ext_interface_details
332: set rejection_code = 'RC 175',
333: transfer_status_flag = 'R' ,
334: request_id = l_request_id
335: where current of Interface_details ;

Line 365: update pa_pay_ext_interface_details

361:
362: IF l_value_exists = 0 THEN
363: --{
364:
365: update pa_pay_ext_interface_details
366: set rejection_code = 'RC 180',
367: transfer_status_flag = 'R',
368: request_id = l_request_id
369: where current of Interface_details ;

Line 404: update pa_pay_ext_interface_details

400:
401: --}
402: END IF;
403:
404: update pa_pay_ext_interface_details
405: set transfer_status_flag = 'P',
406: request_id = l_request_id
407: where current of Interface_details;
408:

Line 428: update pa_pay_ext_interface_details eid1

424: END LOOP;
425:
426: /* Rejecting the other lines if any item gets rejected */
427:
428: update pa_pay_ext_interface_details eid1
429: set transfer_status_flag = 'R',
430: rejection_code = nvl(rejection_code,'RC 185'),
431: request_id = l_request_id
432: where interface_header_id = Hdr_rec.interface_header_id

Line 433: and exists (select null from pa_pay_ext_interface_details eid2

429: set transfer_status_flag = 'R',
430: rejection_code = nvl(rejection_code,'RC 185'),
431: request_id = l_request_id
432: where interface_header_id = Hdr_rec.interface_header_id
433: and exists (select null from pa_pay_ext_interface_details eid2
434: where eid1.interface_header_id = eid2.interface_header_id
435: and interface_header_id = Hdr_rec.interface_header_id
436: and transfer_status_flag = 'R');
437: