APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 504: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b

500: AND TAX_TYPE in ('Addl. Excise','Excise','Other Excise');
501:
502: cursor c_rcpts_match (cp_temp_id IN NUMBER) IS
503: select sum(a.quantity_applied) quantity_applied , sum(b.excise_duty_rate) excise_duty_rate
504: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b
505: where a.receipt_id = b.register_id
506: and a.ref_line_id = cp_temp_id
507: and a.order_invoice = 'X';
508:

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

695: l_process_message := NULL;
696: processed_flag := 'N';
697: END IF;
698: ELSIF l_trading = 'Y' AND main_rec.trading = 'Y' AND main_rec.item_trading_flag = 'Y' THEN
699: stmt_name := 'Calling jai_cmn_rg_23d_trxs_pkg.insert_row';
700:
701: if main_Rec.quantity <> 0 then
702: v_tax_rate := round((l_duty_amt / main_Rec.quantity),2);
703: end if;

Line 711: jai_cmn_rg_23d_trxs_pkg.insert_row(

707: if r_rcpts_match.quantity_applied <> 0 THEN
708: ln_total_tax_rate := round (( ( r_rcpts_match.excise_duty_rate *r_rcpts_match.quantity_applied ) / r_rcpts_match.quantity_applied),2);
709: end if;
710:
711: jai_cmn_rg_23d_trxs_pkg.insert_row(
712: P_REGISTER_ID => l_register_id,
713: P_ORGANIZATION_ID => main_rec.to_organization,
714: P_LOCATION_ID => main_rec.location_id,
715: P_TRANSACTION_TYPE => 'R',