APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_RCV_RTV_DTLS

Line 1419: INSERT INTO JAI_RCV_RTV_DTLS(

1415:
1416: lv_statement_id := '6';
1417: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);
1418: IF lv_excise_invoice_no IS NOT NULL THEN
1419: INSERT INTO JAI_RCV_RTV_DTLS(
1420: transaction_id, parent_transaction_id, shipment_line_id,
1421: excise_invoice_no, excise_invoice_date, rg_register_part_i,
1422: creation_date, created_by, last_update_date, last_updated_by, last_update_login
1423: ) VALUES (

Line 1950: UPDATE JAI_RCV_RTV_DTLS

1946:
1947: IF lv_transaction_type = 'RETURN TO VENDOR' AND ln_part_i_register_id IS NOT NULL THEN
1948: lv_statement_id := '20';
1949: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
1950: UPDATE JAI_RCV_RTV_DTLS
1951: SET rg_register_part_i = ln_part_i_register_id
1952: WHERE transaction_id = p_transaction_id;
1953: END IF;
1954:

Line 5103: FROM JAI_RCV_RTV_DTLS

5099: ) IS
5100:
5101: CURSOR c_rtv_excise_inv_no(cp_transaction_id IN NUMBER) IS
5102: SELECT excise_invoice_no, excise_invoice_date
5103: FROM JAI_RCV_RTV_DTLS
5104: WHERE transaction_id = cp_transaction_id;
5105:
5106: r_trx c_trx%ROWTYPE;
5107: lv_statement_id VARCHAR2(5);