[Home] [Help]
225: -- update the quantity for 2nd claim only during the first claim of transaction line and that too only for CG Items only
226: IF p_cenvat_claimed_ptg = 50 AND r_trx.item_class IN ('CGIN','CGEX') THEN
227:
228: IF lv_transaction_type IN ('DELIVER','RETURN TO RECEIVING','RETURN TO VENDOR') THEN
229: ln_trx_equivalent_of_receive := jai_rcv_trx_processing_pkg.get_equivalent_qty_of_receive(r_trx.transaction_id);
230: ELSE
231: ln_trx_equivalent_of_receive := r_trx.quantity;
232: END IF;
233:
1318: lv_statement_id := '8';
1319: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1320: IF lv_transaction_type IN ('RECEIVE', 'RETURN TO RECEIVING', 'DELIVER', 'RETURN TO VENDOR') THEN
1321:
1322: IF r_trx.organization_type = jai_rcv_trx_processing_pkg.MFG_ORGN THEN
1323:
1324: lv_statement_id := '9';
1325: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1326:
1323:
1324: lv_statement_id := '9';
1325: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1326:
1327: IF (r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma -- 'India RMA Receipt'
1328: AND r_trx.item_class IN ('FGIN', 'FGEX', 'CCIN', 'CCEX'))
1329: /*Added by nprashar for bug 6710747 The following condition is added to support register update for Inter Org Transfer*/
1330: OR ( r_base_trx.source_document_Code = 'INVENTORY' AND lv_transaction_type <>'DELIVER' AND r_trx.item_class IN ('FGIN', 'FGEX', 'CCIN', 'CCEX'))
1331: THEN
1663: GOTO finish;
1664: END IF;
1665: /* END - ACCOUNTING LOGIC */
1666:
1667: ELSIF r_trx.organization_type = jai_rcv_trx_processing_pkg.TRADING_ORGN THEN
1668:
1669: -- In a Trading Organization all the ITEM CLASSes are supported
1670:
1671: lv_statement_id := '14';
1697: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
1698: -- there is no part II entry for TRADING transactions
1699: IF lv_transaction_type IN ('RECEIVE', 'RETURN TO VENDOR') AND r_trx.excise_in_trading = 'Y' THEN
1700:
1701: lb_process_iso := jai_rcv_trx_processing_pkg.process_iso_transaction(
1702: p_transaction_id => r_trx.transaction_id,
1703: p_shipment_line_id => r_trx.shipment_line_id
1704: );
1705:
1709: -- Vijay Shankar for Bug#3927371, This needs modification after discussing with Yadu
1710: -- IF r_trx.organization_type = 'M' OR (r_trx.organization_type = 'T' AND lb_process_iso)
1711: IF ( r_base_trx.source_document_code <> 'REQ'
1712: OR (r_base_trx.source_document_code='REQ' AND lb_process_iso) )
1713: AND r_base_trx.source_document_code <> jai_rcv_trx_processing_pkg.source_rma /*srjayara for bug#5155138 - change done for base bug 5110511 + DFF Elimination*/
1714:
1715: THEN
1716:
1717: p_codepath := jai_general_pkg.plot_codepath(21.2, p_codepath);
1928: END IF;
1929:
1930: IF r_base_trx.source_document_code = 'RMA' THEN
1931: IF ln_customer_site_id IS NULL THEN
1932: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id(
1933: p_transaction_id => r_trx.transaction_id,
1934: p_shipment_line_id => r_trx.shipment_line_id,
1935: p_required_trx_type => 'RECEIVE'
1936: )
1957:
1958: lv_statement_id := '7';
1959: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1960: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
1961: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then -- 'India RMA Receipt' THEN
1962: lv_transaction_type := 'CR';
1963: ELSE
1964: lv_transaction_type := 'R';
1965: END IF;
2154:
2155: IF r_base_trx.source_document_code = 'RMA' THEN
2156:
2157: IF ln_customer_site_id IS NULL THEN
2158: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id(
2159: p_transaction_id => r_trx.transaction_id,
2160: p_shipment_line_id => r_trx.shipment_line_id,
2161: p_required_trx_type => 'RECEIVE'
2162: )
2399: FETCH c_rma_tax_rate INTO ln_excise_duty_rate;
2400: CLOSE c_rma_tax_rate;
2401:
2402: IF ln_customer_site_id IS NULL THEN
2403: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id
2404: (p_transaction_id => r_trx.transaction_id,
2405: p_shipment_line_id => r_trx.shipment_line_id,
2406: p_required_trx_type => 'RECEIVE')
2407: );*/
2625: IF lv_transaction_type = 'RECEIVE' THEN
2626: ln_quantity_received := -ln_quantity_received;
2627: END IF;
2628:
2629: ln_ancestor_trxn_id := jai_rcv_trx_processing_pkg.get_ancestor_id(
2630: p_transaction_id => r_trx.transaction_id,
2631: p_shipment_line_id => r_trx.shipment_line_id,
2632: p_required_trx_type => 'RECEIVE'
2633: );
2762: END IF;
2763:
2764: IF r_base_trx.source_document_code = 'RMA' THEN
2765: IF ln_customer_site_id IS NULL THEN
2766: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id
2767: (p_transaction_id => r_trx.transaction_id,
2768: p_shipment_line_id => r_trx.shipment_line_id,
2769: p_required_trx_type => 'RECEIVE')
2770: );*/
3357: lv_statement_id := '6';
3358: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
3359: lv_accnt_nature := 'CENVAT';
3360: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3361: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3362: ln_receiving_accnt_id := r_orgn_info.excise_rcvble_account; /* In front end this is shown as excise Paid Payable Accnt */
3363:
3364: /* Vijay Shankar for Bug#4211045 */
3365: ln_cess_paid_payable_accnt_id := r_orgn_info.cess_paid_payable_account_id;
3446: fnd_file.put_line(FND_FILE.LOG, '
3448: IF ln_receiving_accnt_id IS NULL THEN
3449: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3450: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3451: lv_message := 'Excise Receivable Account was not defined in Organization Setup';
3452: ELSE
3453: lv_message := 'Receivable Account was not defined in RCV Parameters';
3454: END IF;
3459: /* following Added for EDUCATION CESS by Vijay Shankar*/
3460: IF ln_total_excise_edu_cess_amt <> 0 THEN
3461: /* Vijay Shankar for Bug#4211045 */
3462: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt'
3463: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
3464: AND ln_cess_paid_payable_accnt_id IS NULL
3465: THEN
3466: lv_message := 'Cess Paid/Payable Account was not defined in Organization Setup'; /* Cess meaning Excise Education Cess */
3467: END IF;
3485: END IF;
3486: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
3487: --start
3488: IF ln_sh_total_exc_edu_cess_amt <> 0 THEN
3489: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
3490: AND ln_sh_cess_paid_payable_accnt IS NULL
3491: THEN
3492: lv_message := 'Secondary/Higher Cess Paid/Payable Account was not defined in Organization Setup';
3493: END IF;
3620:
3621: /* ln_balancing_credit := ln_balancing_credit + ln_total_excise_edu_cess_amt; */
3622: /* If condition added by Vijay Shankar for Bug#4211045. Else is existing previously itself as above statement */
3623: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3624: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3625: ln_edu_cess_balancing_credit := ln_total_excise_edu_cess_amt;
3626: ELSE
3627: ln_balancing_credit := ln_balancing_credit + ln_total_excise_edu_cess_amt;
3628: END IF;
3631:
3632: /* ln_balancing_debit := ln_balancing_debit + ln_total_excise_edu_cess_amt; */
3633: /* If condition added by Vijay Shankar for Bug#4211045. Else is existing previously itself as above statement */
3634: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3635: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3636: ln_edu_cess_balancing_debit := ln_total_excise_edu_cess_amt;
3637: ELSE
3638: ln_balancing_debit := ln_balancing_debit + ln_total_excise_edu_cess_amt;
3639: END IF;
3648: IF p_cenvat_accounting_type = CENVAT_DEBIT THEN
3649:
3650:
3651:
3652: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3653: ln_sh_edu_cess_balancin_credit := ln_sh_total_exc_edu_cess_amt;
3654: ELSE
3655: ln_balancing_credit := ln_balancing_credit + ln_sh_total_exc_edu_cess_amt;
3656: END IF;
3657:
3658: ELSE
3659:
3660:
3661: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3662: ln_sh_edu_cess_balancin_debit := ln_sh_total_exc_edu_cess_amt;
3663: ELSE
3664: ln_balancing_debit := ln_balancing_debit + ln_sh_total_exc_edu_cess_amt;
3665: END IF;
3693: P_CATEGORY_NAME => gv_category_name,
3694: P_CODE_COMBINATION_ID => ln_cenvat_accnt_id,
3695: P_ENTERED_DR => ln_debit,
3696: P_ENTERED_CR => ln_credit,
3697: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3698: P_ACCOUNTING_DATE => lv_accounting_date,
3699: P_REFERENCE_10 => lv_reference10,
3700: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3701: P_REFERENCE_24 => 'rcv_transactions',
3734: P_CATEGORY_NAME => gv_category_name,
3735: P_CODE_COMBINATION_ID => ln_exc_edu_cess_accnt,
3736: P_ENTERED_DR => ln_edu_cess_debit,
3737: P_ENTERED_CR => ln_edu_cess_credit,
3738: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3739: P_ACCOUNTING_DATE => lv_accounting_date,
3740: P_REFERENCE_10 => lv_reference10,
3741: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3742: P_REFERENCE_24 => 'rcv_transactions',
3775: P_CATEGORY_NAME => gv_category_name,
3776: P_CODE_COMBINATION_ID => ln_sh_exc_edu_cess_accnt,
3777: P_ENTERED_DR => ln_sh_edu_cess_debit,
3778: P_ENTERED_CR => ln_sh_edu_cess_credit,
3779: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3780: P_ACCOUNTING_DATE => lv_accounting_date,
3781: P_REFERENCE_10 => lv_reference10,
3782: P_REFERENCE_23 => 'ja_in_receipt_cenvat_rg_pkg.accounting_entries',
3783: P_REFERENCE_24 => 'rcv_transactions',
3819: P_CATEGORY_NAME => gv_category_name,
3820: P_CODE_COMBINATION_ID => ln_receiving_accnt_id,
3821: P_ENTERED_DR => ln_balancing_debit,
3822: P_ENTERED_CR => ln_balancing_credit,
3823: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3824: P_ACCOUNTING_DATE => lv_accounting_date,
3825: P_REFERENCE_10 => lv_reference10,
3826: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3827: P_REFERENCE_24 => 'rcv_transactions',
3845:
3846: /* following entry (CESS BALANCING ENTRY for RMA Production Input and GOODS RETURN cases)
3847: added by Vijay Shankar for Bug#4211045 */
3848: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt'
3849: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
3850: AND nvl(ln_edu_cess_balancing_debit, ln_edu_cess_balancing_credit) <> 0
3851: THEN
3852:
3853: lv_statement_id := '10b';
3862: P_CATEGORY_NAME => gv_category_name,
3863: P_CODE_COMBINATION_ID => ln_cess_paid_payable_accnt_id,
3864: P_ENTERED_DR => ln_edu_cess_balancing_debit,
3865: P_ENTERED_CR => ln_edu_cess_balancing_credit,
3866: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3867: P_ACCOUNTING_DATE => lv_accounting_date,
3868: P_REFERENCE_10 => lv_reference10,
3869: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3870: P_REFERENCE_24 => 'rcv_transactions',
3891: ||' SH_Debit:'||ln_sh_edu_cess_balancin_debit||', SH_Credit:'||ln_sh_edu_cess_balancin_credit
3892: ||', ln_sh_cess_paid_payable_accnt:'||ln_sh_cess_paid_payable_accnt);
3893: end if;
3894:
3895: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
3896: AND nvl(ln_sh_edu_cess_balancin_debit, ln_sh_edu_cess_balancin_credit) <> 0
3897: THEN
3898:
3899: lv_statement_id := '10d';
3907: P_CATEGORY_NAME => gv_category_name,
3908: P_CODE_COMBINATION_ID => ln_sh_cess_paid_payable_accnt,--replaced ln_cess_paid_payable_accnt_id with ln_sh_cess_paid_payable_accnt for bug #5989740
3909: P_ENTERED_DR => ln_sh_edu_cess_balancin_debit,
3910: P_ENTERED_CR => ln_sh_edu_cess_balancin_credit,
3911: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3912: P_ACCOUNTING_DATE => lv_accounting_date,
3913: P_REFERENCE_10 => lv_reference10,
3914: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3915: P_REFERENCE_24 => 'rcv_transactions',
4157: P_CATEGORY_NAME => gv_category_name,
4158: P_CODE_COMBINATION_ID => ln_cenvat_accnt_id,
4159: P_ENTERED_DR => ln_debit,
4160: P_ENTERED_CR => ln_credit,
4161: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4162: P_ACCOUNTING_DATE => lv_accounting_date,
4163: P_REFERENCE_10 => lv_reference10,
4164: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4165: P_REFERENCE_24 => 'rcv_transactions',
4200: P_CATEGORY_NAME => gv_category_name,
4201: P_CODE_COMBINATION_ID => ln_exc_edu_cess_accnt,
4202: P_ENTERED_DR => ln_edu_cess_debit,
4203: P_ENTERED_CR => ln_edu_cess_credit,
4204: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4205: P_ACCOUNTING_DATE => lv_accounting_date,
4206: P_REFERENCE_10 => lv_reference10,
4207: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4208: P_REFERENCE_24 => 'rcv_transactions',
4242: P_CATEGORY_NAME => gv_category_name,
4243: P_CODE_COMBINATION_ID => ln_sh_exc_edu_cess_accnt,
4244: P_ENTERED_DR => ln_sh_edu_cess_debit,
4245: P_ENTERED_CR => ln_sh_edu_cess_credit,
4246: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4247: P_ACCOUNTING_DATE => lv_accounting_date,
4248: P_REFERENCE_10 => lv_reference10,
4249: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4250: P_REFERENCE_24 => 'rcv_transactions',
4288: P_CATEGORY_NAME => gv_category_name,
4289: P_CODE_COMBINATION_ID => ln_cenvat_rcvble_accnt_id,
4290: P_ENTERED_DR => ln_balancing_debit,
4291: P_ENTERED_CR => ln_balancing_credit,
4292: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4293: P_ACCOUNTING_DATE => lv_accounting_date,
4294: P_REFERENCE_10 => lv_reference10,
4295: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4296: P_REFERENCE_24 => 'rcv_transactions',
4331: P_CATEGORY_NAME => gv_category_name,
4332: P_CODE_COMBINATION_ID => ln_exc_edu_cess_rcvble_accnt,
4333: P_ENTERED_DR => ln_bal_edu_cess_debit,
4334: P_ENTERED_CR => ln_bal_edu_cess_credit,
4335: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4336: P_ACCOUNTING_DATE => lv_accounting_date,
4337: P_REFERENCE_10 => lv_reference10,
4338: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4339: P_REFERENCE_24 => 'rcv_transactions',
4374: P_CATEGORY_NAME => gv_category_name,
4375: P_CODE_COMBINATION_ID => ln_sh_exc_edu_cess_rcvb_accnt,
4376: P_ENTERED_DR => ln_sh_bal_edu_cess_debit,
4377: P_ENTERED_CR => ln_sh_bal_edu_cess_credit,
4378: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4379: P_ACCOUNTING_DATE => lv_accounting_date,
4380: P_REFERENCE_10 => lv_reference10,
4381: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4382: P_REFERENCE_24 => 'rcv_transactions',
4575: /*
4576: ||Start of bug 5378630
4577: ||Modified the below if statement condition such that the RMA_type 'GOODS RETURN' was changed into GOODS RETURN
4578: */
4579: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
4580: AND upper(r_jai_receipt_line.rma_type) NOT IN ('PRODUCTION INPUT', 'GOODS RETURN')
4581: THEN
4582: /* End of bug 5378630 */
4583: lv_validation_message := 'RMA Type Not supported';
4587: IF r_trx.organization_type = 'M' AND r_trx.item_class IN ('FGIN', 'FGEX')
4588: and r_base_trx.source_document_code <> 'INVENTORY' THEN /* 6030615 - interorg */
4589: lv_validation_message := 'Item Class not supported for Manufacturing Transactions';
4590:
4591: --ELSIF r_trx.organization_type = 'T' AND r_trx.item_class = jai_rcv_trx_processing_pkg.NO_SETUP THEN
4592: --
4593: ELSE
4594: lv_statement_id := '5.1';
4595: END IF;
4783: transactions follow this
4784: This is the function that should be changed if all Receipt Queries should be based on TRANSACTION_ID instead of SHIPMENT_LINE_ID
4785: */
4786: --ln_ancestor_receive_trxn_id :=
4787: -- jai_rcv_trx_processing_pkg.get_ancestor_id(p_transaction_id, p_shipment_line_id, 'RECEIVE');
4788:
4789: -- commented as pert of review and modified p_shipment_line_id -> p_transaction_id
4790: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.get_receive_claimed_ptg', 'START'); /* 1 */
4791: OPEN c_cenvat_claimed_ptg(p_shipment_line_id);
4832:
4833: ln_mod_problem_amt := 0;
4834: ln_nonmod_problem_amt := 0;
4835:
4836: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
4837:
4838: FOR tax_rec IN (SELECT rtl.tax_type ,
4839: nvl(rtl.tax_amount, 0) tax_amount ,
4840: nvl(rtl.modvat_flag, 'N') modvat_flag ,
4837:
4838: FOR tax_rec IN (SELECT rtl.tax_type ,
4839: nvl(rtl.tax_amount, 0) tax_amount ,
4840: nvl(rtl.modvat_flag, 'N') modvat_flag ,
4841: nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr) currency ,
4842: nvl(decode(p_breakup_type, 'RG23D', 100, jtc.mod_cr_percentage), 0) mod_cr_percentage,
4843: nvl(jtc.rounding_factor, 0) rnd
4844: FROM JAI_RCV_LINE_TAXES rtl, JAI_CMN_TAXES_ALL jtc
4845: WHERE rtl.shipment_line_id = p_shipment_line_id
4848:
4849: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
4850:
4851:
4852: IF tax_rec.currency <> jai_rcv_trx_processing_pkg.gv_func_curr THEN
4853: ln_curr_conv := NVL(p_curr_conv_rate, 1);
4854: ELSE
4855: ln_curr_conv := 1;
4856: END IF;
5935: p_code_combination_id => ln_ccid,
5936: p_entered_dr => ln_debit_amt,
5937: p_entered_cr => ln_credit_amt,
5938:
5939: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
5940: p_accounting_date => lv_accounting_date,
5941: p_reference_10 => lv_reference10,
5942: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
5943: p_reference_24 => lv_reference24, --'rcv_transactions',
5969: p_code_combination_id => ln_balancing_ccid,
5970: p_entered_dr => ln_balancing_debit_amt,
5971: p_entered_cr => ln_balancing_credit_amt,
5972:
5973: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
5974: p_accounting_date => lv_accounting_date,
5975: p_reference_10 => lv_reference10,
5976: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
5977: p_reference_24 => lv_reference24, --'rcv_transactions',
6022: p_code_combination_id => ln_ccid,
6023: p_entered_dr => ln_debit_amt,
6024: p_entered_cr => ln_credit_amt,
6025:
6026: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6027: p_accounting_date => lv_accounting_date,
6028: p_reference_10 => lv_reference10,
6029: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6030: p_reference_24 => lv_reference24, --'rcv_transactions',
6056: p_code_combination_id => ln_balancing_ccid,
6057: p_entered_dr => ln_balancing_debit_amt,
6058: p_entered_cr => ln_balancing_credit_amt,
6059:
6060: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6061: p_accounting_date => lv_accounting_date,
6062: p_reference_10 => lv_reference10,
6063: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6064: p_reference_24 => lv_reference24, --'rcv_transactions',
6112: p_code_combination_id => ln_ccid,
6113: p_entered_dr => ln_debit_amt,
6114: p_entered_cr => ln_credit_amt,
6115:
6116: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6117: p_accounting_date => lv_accounting_date,
6118: p_reference_10 => lv_reference10,
6119: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6120: p_reference_24 => lv_reference24, --'rcv_transactions',
6146: p_code_combination_id => ln_balancing_ccid,
6147: p_entered_dr => ln_balancing_debit_amt,
6148: p_entered_cr => ln_balancing_credit_amt,
6149:
6150: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6151: p_accounting_date => lv_accounting_date,
6152: p_reference_10 => lv_reference10,
6153: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6154: p_reference_24 => lv_reference24, --'rcv_transactions',