APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RCV_RTV_DTLS

Line 2810: INSERT INTO JAI_RCV_RTV_DTLS(

2806: last_updated_by = fnd_global.user_id
2807: where current of c_rtv_trxs;
2808:
2809: lv_statement_id := '25';
2810: INSERT INTO JAI_RCV_RTV_DTLS(
2811: transaction_id, parent_transaction_id, shipment_line_id,
2812: excise_invoice_no, excise_invoice_date, rg_register_part_i,
2813: creation_date, created_by, last_update_date, last_updated_by, last_update_login
2814: ) VALUES (

Line 4669: FROM JAI_RCV_RTV_DTLS

4665: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath);
4666: if r_trx.transaction_type = 'CORRECT' THEN
4667: lv_statement_id := '23';
4668: SELECT count(1) INTO ln_rtv_cnt
4669: FROM JAI_RCV_RTV_DTLS
4670: WHERE transaction_id = r_trx.parent_transaction_id;
4671:
4672: lv_statement_id := '24';
4673: if ln_rtv_cnt = 0 THEN