APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 381: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b

377: AND TAX_TYPE in ('Addl. Excise','Excise','Other Excise');
378:
379: cursor c_rcpts_match (cp_temp_id IN NUMBER) IS
380: select sum(a.quantity_applied) quantity_applied , sum(b.excise_duty_rate) excise_duty_rate
381: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b
382: where a.receipt_id = b.register_id
383: and a.ref_line_id = cp_temp_id
384: and a.order_invoice = 'X';
385:

Line 576: stmt_name := 'Calling jai_cmn_rg_23d_trxs_pkg.insert_row';

572: l_process_message := NULL;
573: processed_flag := 'N';
574: END IF;
575: ELSIF l_trading = 'Y' AND main_rec.trading = 'Y' AND main_rec.item_trading_flag = 'Y' THEN
576: stmt_name := 'Calling jai_cmn_rg_23d_trxs_pkg.insert_row';
577:
578: if main_Rec.quantity <> 0 then
579: v_tax_rate := round((l_duty_amt / main_Rec.quantity),2);
580: end if;

Line 588: jai_cmn_rg_23d_trxs_pkg.insert_row(

584: if r_rcpts_match.quantity_applied <> 0 THEN
585: ln_total_tax_rate := round (( ( r_rcpts_match.excise_duty_rate *r_rcpts_match.quantity_applied ) / r_rcpts_match.quantity_applied),2);
586: end if;
587:
588: jai_cmn_rg_23d_trxs_pkg.insert_row(
589: P_REGISTER_ID => l_register_id,
590: P_ORGANIZATION_ID => main_rec.to_organization,
591: P_LOCATION_ID => main_rec.location_id,
592: P_TRANSACTION_TYPE => 'R',