DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 363: FROM JAI_CMN_RG_23D_TRXS

359: WHERE header_id = p_order_header_id;
360:
361: CURSOR qty_to_adjust_cur (p_receipt_id NUMBER) IS
362: SELECT qty_to_adjust,excise_duty_rate,rate_per_unit
363: FROM JAI_CMN_RG_23D_TRXS
364: WHERE register_id = p_receipt_id;
365: -- Till Here
366: /*
367: || Changed by aiyer for the bug 3139718

Line 2244: jai_cmn_rg_23d_trxs_pkg.upd_receipt_qty_matched(match_rec.receipt_id, match_rec.quantity_applied, v_qty_to_adjust);

2240: ||', v_source_line_id -> ' || v_source_line_id||', v_source_header_id -> ' || v_source_header_id
2241: );
2242: lv_statement_no := '60';
2243:
2244: jai_cmn_rg_23d_trxs_pkg.upd_receipt_qty_matched(match_rec.receipt_id, match_rec.quantity_applied, v_qty_to_adjust);
2245: -- END IF; --2002/02/20 Vijay
2246: END LOOP;
2247:
2248: -- Start, cbabu for Bug# 2736191

Line 2266: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;

2262: END IF;
2263:
2264: --END 7043292
2265: lv_statement_no := '54';
2266: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;
2267:
2268: lv_statement_no := '59';
2269:
2270: jai_om_rg_pkg.Ja_In_Rg23d_Entry(