APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RTP_POPULATE_T

Line 1736: FROM jai_rtp_populate_t)

1732: SELECT rowid
1733: FROM jai_rcv_transactions
1734: WHERE transaction_id IN
1735: ( SELECT transaction_id
1736: FROM jai_rtp_populate_t)
1737: FOR UPDATE OF transaction_id ;
1738:
1739: lock_rcv_rec_dtls c_lock_rcv_dtls%ROWTYPE ;
1740:

Line 1745: INTO JAI_RTP_POPULATE_T

1741: BEGIN
1742: IF p_shipment_header_id is null THEN
1743:
1744: INSERT
1745: INTO JAI_RTP_POPULATE_T
1746: (TRANSACTION_ID,
1747: SHIPMENT_LINE_ID,
1748: PROCESS_FLAG,
1749: CENVAT_RG_FLAG,

Line 1779: INTO JAI_RTP_POPULATE_T

1775: );
1776:
1777: ELSE
1778: INSERT
1779: INTO JAI_RTP_POPULATE_T
1780: (TRANSACTION_ID,
1781: SHIPMENT_LINE_ID,
1782: PROCESS_FLAG,
1783: CENVAT_RG_FLAG,

Line 2217: FOR trx IN (SELECT * FROM JAI_RTP_POPULATE_T ORDER BY receipt_num, transaction_id) LOOP

2213: ja_in_populate_details ; -- added by Sanjikum for bug#4929410
2214:
2215: --FOR trx IN c_trxns_to_populate_dtls LOOP
2216: --commented the above and added the below by Sanjikum for Bug#4929410
2217: FOR trx IN (SELECT * FROM JAI_RTP_POPULATE_T ORDER BY receipt_num, transaction_id) LOOP
2218: BEGIN -- Added by nprashar for bug # 13880102
2219: SAVEPOINT start_trx_population; /*Uncommented by nprashar for bug # 13880102 */
2220: lv_codepath := '';
2221:

Line 2270: DELETE FROM JAI_RTP_POPULATE_T

2266: ELSE
2267: retcode := jai_constants.request_error;
2268: END IF;
2269:
2270: DELETE FROM JAI_RTP_POPULATE_T
2271: WHERE transaction_id = trx.transaction_id;
2272:
2273: COMMIT;
2274: