APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_RCV_RTV_DTLS

Line 1260: INSERT INTO JAI_RCV_RTV_DTLS(

1256:
1257: lv_statement_id := '6';
1258: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);
1259: IF lv_excise_invoice_no IS NOT NULL THEN
1260: INSERT INTO JAI_RCV_RTV_DTLS(
1261: transaction_id, parent_transaction_id, shipment_line_id,
1262: excise_invoice_no, excise_invoice_date, rg_register_part_i,
1263: creation_date, created_by, last_update_date, last_updated_by, last_update_login
1264: ) VALUES (

Line 1772: UPDATE JAI_RCV_RTV_DTLS

1768:
1769: IF lv_transaction_type = 'RETURN TO VENDOR' AND ln_part_i_register_id IS NOT NULL THEN
1770: lv_statement_id := '20';
1771: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
1772: UPDATE JAI_RCV_RTV_DTLS
1773: SET rg_register_part_i = ln_part_i_register_id
1774: WHERE transaction_id = p_transaction_id;
1775: END IF;
1776:

Line 4710: FROM JAI_RCV_RTV_DTLS

4706: ) IS
4707:
4708: CURSOR c_rtv_excise_inv_no(cp_transaction_id IN NUMBER) IS
4709: SELECT excise_invoice_no, excise_invoice_date
4710: FROM JAI_RCV_RTV_DTLS
4711: WHERE transaction_id = cp_transaction_id;
4712:
4713: r_trx c_trx%ROWTYPE;
4714: lv_statement_id VARCHAR2(5);