APPS.RCV_AP_PURGE_PVT dependencies on RCV_TRANSACTIONS

Line 279: FROM rcv_transactions_interface RTI

275: WHERE RSL.shipment_header_id =
276: RSH.shipment_header_id)
277: AND NOT EXISTS (
278: SELECT NULL
279: FROM rcv_transactions_interface RTI
280: WHERE RTI.shipment_header_id = RSH.shipment_header_id
281: AND RTI.processing_status_code <> 'COMPLETED')
282: RETURNING RSH.shipment_header_id
283: BULK COLLECT INTO l_rsh_ids_tbl;

Line 293: FROM rcv_transactions RT

289: l_progress := '040';
290:
291: SELECT RT.transaction_id, RT.interface_transaction_id
292: BULK COLLECT INTO l_rt_ids_tbl, l_rti_ids_tbl
293: FROM rcv_transactions RT
294: WHERE EXISTS (
295: SELECT NULL
296: FROM po_purge_po_list PPL
297: WHERE PPL.po_header_id = RT.po_header_id

Line 311: --SQL What: Delete rcv_transactions data

307: ( x_return_status => l_return_status,
308: p_rt_ids_tbl => l_rt_ids_tbl
309: );
310:
311: --SQL What: Delete rcv_transactions data
312: FORALL i IN l_rt_ids_tbl.FIRST..l_rt_ids_tbl.LAST
313: DELETE
314: FROM rcv_transactions RT
315: WHERE transaction_id = l_rt_ids_tbl(i);

Line 314: FROM rcv_transactions RT

310:
311: --SQL What: Delete rcv_transactions data
312: FORALL i IN l_rt_ids_tbl.FIRST..l_rt_ids_tbl.LAST
313: DELETE
314: FROM rcv_transactions RT
315: WHERE transaction_id = l_rt_ids_tbl(i);
316:
317: IF (g_fnd_debug = 'Y') THEN
318: asn_debug.put_line('Deleted ' || l_rt_ids_tbl.COUNT || ' rt records');

Line 336: FROM rcv_transactions RT

332: OR (RLS.transaction_id > 0
333: AND
334: NOT EXISTS (
335: SELECT NULL
336: FROM rcv_transactions RT
337: WHERE RT.transaction_id = RLS.transaction_id));
338:
339: l_progress := '070';
340:

Line 354: FROM rcv_transactions RT

350: OR (RSS.transaction_id > 0
351: AND
352: NOT EXISTS (
353: SELECT NULL
354: FROM rcv_transactions RT
355: WHERE RT.transaction_id = RSS.transaction_id));
356:
357: l_progress := '080';
358:

Line 373: FROM rcv_transactions RT

369: (RLT.transaction_id > 0
370: AND
371: NOT EXISTS (
372: SELECT NULL
373: FROM rcv_transactions RT
374: WHERE RT.transaction_id = RLT.transaction_id));
375:
376: l_progress := '090';
377:

Line 392: FROM rcv_transactions RT

388: (RST.transaction_id > 0
389: AND
390: NOT EXISTS (
391: SELECT NULL
392: FROM rcv_transactions RT
393: WHERE RT.transaction_id = RST.transaction_id));
394:
395: l_progress := '100';
396:

Line 442: -- list of rcv_transactions that have been purged

438: -- transactions are purged
439: --Parameters:
440: --IN:
441: --p_rt_ids_tbl
442: -- list of rcv_transactions that have been purged
443: --IN OUT:
444: --OUT:
445: --x_return_status
446: -- status of the procedure

Line 489: p_purge_entity_type => 'RCV_TRANSACTIONS',

485: p_commit => FND_API.G_FALSE,
486: x_return_status => l_return_status,
487: x_msg_count => l_msg_count,
488: x_msg_data => l_msg_data,
489: p_purge_entity_type => 'RCV_TRANSACTIONS',
490: p_purge_in_rec => l_cst_purge_in_rec
491: );
492:
493: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 569: ( x_entity_name => 'RCV_TRANSACTIONS_INTERFACE',

565: FOR i IN 1..p_rti_ids_tbl.COUNT LOOP
566: l_progress := '030';
567:
568: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
569: ( x_entity_name => 'RCV_TRANSACTIONS_INTERFACE',
570: x_pk1_value => p_rti_ids_tbl(i),
571: x_delete_document_flag => 'Y'
572: );
573: