APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 368: FROM JAI_CMN_RG_23D_TRXS

364: WHERE header_id = p_order_header_id;
365:
366: CURSOR qty_to_adjust_cur (p_receipt_id NUMBER) IS
367: SELECT qty_to_adjust,excise_duty_rate,rate_per_unit,quantity_received --added quantity_received for bug#5735284
368: FROM JAI_CMN_RG_23D_TRXS
369: WHERE register_id = p_receipt_id;
370:
371: /*added the following cursor for bug#5735284*/
372: CURSOR get_duty_amt_cur (p_receipt_id NUMBER) IS

Line 374: FROM JAI_CMN_RG_23D_TRXS

370:
371: /*added the following cursor for bug#5735284*/
372: CURSOR get_duty_amt_cur (p_receipt_id NUMBER) IS
373: SELECT duty_amount,basic_ed, additional_ed,other_ed, cvd,additional_cvd
374: FROM JAI_CMN_RG_23D_TRXS
375: WHERE register_id = p_receipt_id;
376: rec_get_duty_amt get_duty_amt_cur%rowtype;
377:
378: -- Till Here

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

2351: ||', v_source_line_id -> ' || v_source_line_id||', v_source_header_id -> ' || v_source_header_id
2352: );
2353: lv_statement_no := '60';
2354:
2355: jai_cmn_rg_23d_trxs_pkg.upd_receipt_qty_matched(match_rec.receipt_id, match_rec.quantity_applied, v_qty_to_adjust);
2356: -- END IF; --2002/02/20 Vijay
2357: --added for bug#5735284 ,start
2358: OPEN get_duty_amt_cur(match_rec.receipt_id);
2359: FETCH get_duty_amt_cur INTO rec_get_duty_amt;

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

2385: END IF;
2386:
2387: --END 7043292
2388: lv_statement_no := '54';
2389: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;
2390:
2391: lv_statement_no := '59';
2392:
2393: jai_om_rg_pkg.Ja_In_Rg23d_Entry(