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 291: --SQL What: Delete rcv_transactions data

287: END IF;
288:
289: l_progress := '040';
290:
291: --SQL What: Delete rcv_transactions data
292: DELETE
293: FROM rcv_transactions RT
294: WHERE EXISTS (
295: SELECT NULL

Line 293: FROM rcv_transactions RT

289: l_progress := '040';
290:
291: --SQL What: Delete rcv_transactions data
292: DELETE
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 332: FROM rcv_transactions RT

328: OR (RLS.transaction_id > 0
329: AND
330: NOT EXISTS (
331: SELECT NULL
332: FROM rcv_transactions RT
333: WHERE RT.transaction_id = RLS.transaction_id));
334:
335: l_progress := '070';
336:

Line 350: FROM rcv_transactions RT

346: OR (RSS.transaction_id > 0
347: AND
348: NOT EXISTS (
349: SELECT NULL
350: FROM rcv_transactions RT
351: WHERE RT.transaction_id = RSS.transaction_id));
352:
353: l_progress := '080';
354:

Line 369: FROM rcv_transactions RT

365: (RLT.transaction_id > 0
366: AND
367: NOT EXISTS (
368: SELECT NULL
369: FROM rcv_transactions RT
370: WHERE RT.transaction_id = RLT.transaction_id));
371:
372: l_progress := '090';
373:

Line 388: FROM rcv_transactions RT

384: (RST.transaction_id > 0
385: AND
386: NOT EXISTS (
387: SELECT NULL
388: FROM rcv_transactions RT
389: WHERE RT.transaction_id = RST.transaction_id));
390:
391: l_progress := '100';
392:

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

434: -- transactions are purged
435: --Parameters:
436: --IN:
437: --p_rt_ids_tbl
438: -- list of rcv_transactions that have been purged
439: --IN OUT:
440: --OUT:
441: --x_return_status
442: -- status of the procedure

Line 485: p_purge_entity_type => 'RCV_TRANSACTIONS',

481: p_commit => FND_API.G_FALSE,
482: x_return_status => l_return_status,
483: x_msg_count => l_msg_count,
484: x_msg_data => l_msg_data,
485: p_purge_entity_type => 'RCV_TRANSACTIONS',
486: p_purge_in_rec => l_cst_purge_in_rec
487: );
488:
489: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 565: ( x_entity_name => 'RCV_TRANSACTIONS_INTERFACE',

561: FOR i IN 1..p_rti_ids_tbl.COUNT LOOP
562: l_progress := '030';
563:
564: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
565: ( x_entity_name => 'RCV_TRANSACTIONS_INTERFACE',
566: x_pk1_value => p_rti_ids_tbl(i),
567: x_delete_document_flag => 'Y'
568: );
569: