APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 2691: jai_cmn_rg_i_trxs_pkg.create_rg1_entry(

2687: );
2688: ELSIF Nvl(p_rg_i_entry,0)=1
2689: THEN
2690: --p_codepath := jai_general_pkg.plot_codepath(6.3, p_codepath);
2691: jai_cmn_rg_i_trxs_pkg.create_rg1_entry(
2692: p_register_id => ln_register_id,
2693: p_register_id_part_ii => null,
2694: p_fin_year => jai_general_pkg.get_fin_year(p_organization_id => r_trx.organization_id),
2695: p_slno => lv_slno,

Line 2764: FROM jai_cmn_rg_i_trxs

2760: AND NOT EXISTS (SELECT 1 FROM jai_cmn_rg_23ac_i_trxs WHERE receipt_ref = pn_transaction_id AND receipt_ref IS NOT NULL);
2761:
2762: CURSOR c_rg_i_entry (cp_transaction_id NUMBER, cp_item_id NUMBER, cp_orgn_id NUMBER, cp_location_id NUMBER) IS
2763: SELECT 1
2764: FROM jai_cmn_rg_i_trxs
2765: WHERE ref_doc_no = To_Char(cp_transaction_id)
2766: AND inventory_item_id = cp_item_id
2767: AND organization_id = cp_orgn_id
2768: AND location_id = cp_location_id

Line 2770: FROM jai_cmn_rg_i_trxs

2766: AND inventory_item_id = cp_item_id
2767: AND organization_id = cp_orgn_id
2768: AND location_id = cp_location_id
2769: AND NOT EXISTS (SELECT 1
2770: FROM jai_cmn_rg_i_trxs
2771: WHERE ref_doc_no = To_Char(pn_transaction_id)
2772: AND organization_id = cp_orgn_id
2773: AND location_id = cp_location_id
2774: AND inventory_item_id = cp_item_id);