[Home] [Help]
301: -- update the quantity for 2nd claim only during the first claim of transaction line and that too only for CG Items only
302: IF p_cenvat_claimed_ptg = 50 AND r_trx.item_class IN ('CGIN','CGEX') THEN
303:
304: IF lv_transaction_type IN ('DELIVER','RETURN TO RECEIVING','RETURN TO VENDOR') THEN
305: ln_trx_equivalent_of_receive := jai_rcv_trx_processing_pkg.get_equivalent_qty_of_receive(r_trx.transaction_id);
306: ELSE
307: ln_trx_equivalent_of_receive := r_trx.quantity;
308: END IF;
309:
392: last_update_login = fnd_global.login_id
393: WHERE transaction_id = r_trx.tax_transaction_id;
394: ELSE
395:
396: ln_trx_equivalent_of_receive := jai_rcv_trx_processing_pkg .get_equivalent_qty_of_receive(r_trx.tax_transaction_id);
397:
398: open c_fetch_base_correct_qty(r_trx.tax_transaction_id);
399: fetch c_fetch_base_correct_qty into v_base_correct_quantity;
400: close c_fetch_base_correct_qty;
1477: lv_statement_id := '8';
1478: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1479: IF lv_transaction_type IN ('RECEIVE', 'RETURN TO RECEIVING', 'DELIVER', 'RETURN TO VENDOR') THEN
1480:
1481: IF r_trx.organization_type = jai_rcv_trx_processing_pkg.MFG_ORGN THEN
1482:
1483: lv_statement_id := '9';
1484: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1485:
1482:
1483: lv_statement_id := '9';
1484: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1485:
1486: IF (r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma -- 'India RMA Receipt'
1487: AND r_trx.item_class IN ('FGIN', 'FGEX', 'CCIN', 'CCEX'))
1488: /*Added by nprashar for bug 6710747 The following condition is added to support register update for Inter Org Transfer*/
1489: OR ( r_base_trx.source_document_Code IN ('REQ','INVENTORY') AND lv_transaction_type <>'DELIVER' AND r_trx.item_class IN ('FGIN', 'FGEX', 'CCIN', 'CCEX')) --added 'REQ' for bug #13514510
1490: THEN
1841: END IF ;
1842:
1843: /* END - ACCOUNTING LOGIC */
1844:
1845: ELSIF r_trx.organization_type = jai_rcv_trx_processing_pkg.TRADING_ORGN THEN
1846:
1847: -- In a Trading Organization all the ITEM CLASSes are supported
1848:
1849: lv_statement_id := '14';
1875: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
1876: -- there is no part II entry for TRADING transactions
1877: IF lv_transaction_type IN ('RECEIVE', 'RETURN TO VENDOR') AND r_trx.excise_in_trading = 'Y' THEN
1878:
1879: lb_process_iso := jai_rcv_trx_processing_pkg.process_iso_transaction(
1880: p_transaction_id => r_trx.transaction_id,
1881: p_shipment_line_id => r_trx.shipment_line_id
1882: );
1883:
1887: -- Vijay Shankar for Bug#3927371, This needs modification after discussing with Yadu
1888: -- IF r_trx.organization_type = 'M' OR (r_trx.organization_type = 'T' AND lb_process_iso)
1889: IF ( r_base_trx.source_document_code <> 'REQ'
1890: OR (r_base_trx.source_document_code='REQ' AND lb_process_iso) )
1891: 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*/
1892:
1893: THEN
1894:
1895: p_codepath := jai_general_pkg.plot_codepath(21.2, p_codepath);
2122: END IF;
2123:
2124: IF r_base_trx.source_document_code = 'RMA' THEN
2125: IF ln_customer_site_id IS NULL THEN
2126: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id(
2127: p_transaction_id => r_trx.transaction_id,
2128: p_shipment_line_id => r_trx.shipment_line_id,
2129: p_required_trx_type => 'RECEIVE'
2130: )
2151:
2152: lv_statement_id := '7';
2153: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2154: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
2155: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then -- 'India RMA Receipt' THEN
2156: lv_transaction_type := 'CR';
2157: ELSE
2158: lv_transaction_type := 'R';
2159: END IF;
2378:
2379: IF r_base_trx.source_document_code = 'RMA' THEN
2380:
2381: IF ln_customer_site_id IS NULL THEN
2382: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id(
2383: p_transaction_id => r_trx.transaction_id,
2384: p_shipment_line_id => r_trx.shipment_line_id,
2385: p_required_trx_type => 'RECEIVE'
2386: )
2633: FETCH c_rma_tax_rate INTO ln_excise_duty_rate;
2634: CLOSE c_rma_tax_rate;
2635:
2636: IF ln_customer_site_id IS NULL THEN
2637: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id
2638: (p_transaction_id => r_trx.transaction_id,
2639: p_shipment_line_id => r_trx.shipment_line_id,
2640: p_required_trx_type => 'RECEIVE')
2641: );*/
2859: IF lv_transaction_type = 'RECEIVE' THEN
2860: ln_quantity_received := -ln_quantity_received;
2861: END IF;
2862:
2863: ln_ancestor_trxn_id := jai_rcv_trx_processing_pkg.get_ancestor_id(
2864: p_transaction_id => r_trx.transaction_id,
2865: p_shipment_line_id => r_trx.shipment_line_id,
2866: p_required_trx_type => 'RECEIVE'
2867: );
3016: END IF;
3017:
3018: IF r_base_trx.source_document_code = 'RMA' THEN
3019: IF ln_customer_site_id IS NULL THEN
3020: /*OPEN c_base_trx( jai_rcv_trx_processing_pkg.get_ancestor_id
3021: (p_transaction_id => r_trx.transaction_id,
3022: p_shipment_line_id => r_trx.shipment_line_id,
3023: p_required_trx_type => 'RECEIVE')
3024: );*/
3715: lv_statement_id := '6';
3716: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
3717: lv_accnt_nature := 'CENVAT';
3718: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3719: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3720: ln_receiving_accnt_id := r_orgn_info.excise_rcvble_account; /* In front end this is shown as excise Paid Payable Accnt */
3721:
3722: /* Vijay Shankar for Bug#4211045 */
3723: ln_cess_paid_payable_accnt_id := r_orgn_info.cess_paid_payable_account_id;
3814: fnd_file.put_line(FND_FILE.LOG, '
3816: IF ln_receiving_accnt_id IS NULL THEN
3817: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3818: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3819: lv_message := 'Excise Receivable Account was not defined in Organization Setup';
3820: ELSE
3821: lv_message := 'Receivable Account was not defined in RCV Parameters';
3822: END IF;
3827: /* following Added for EDUCATION CESS by Vijay Shankar*/
3828: IF ln_total_excise_edu_cess_amt <> 0 THEN
3829: /* Vijay Shankar for Bug#4211045 */
3830: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt'
3831: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
3832: AND ln_cess_paid_payable_accnt_id IS NULL
3833: THEN
3834: lv_message := 'Cess Paid/Payable Account was not defined in Organization Setup'; /* Cess meaning Excise Education Cess */
3835: END IF;
3853: END IF;
3854: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
3855: --start
3856: IF ln_sh_total_exc_edu_cess_amt <> 0 THEN
3857: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
3858: AND ln_sh_cess_paid_payable_accnt IS NULL
3859: THEN
3860: lv_message := 'Secondary/Higher Cess Paid/Payable Account was not defined in Organization Setup';
3861: END IF;
3988:
3989: /* ln_balancing_credit := ln_balancing_credit + ln_total_excise_edu_cess_amt; */
3990: /* If condition added by Vijay Shankar for Bug#4211045. Else is existing previously itself as above statement */
3991: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3992: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
3993: ln_edu_cess_balancing_credit := ln_total_excise_edu_cess_amt;
3994: ELSE
3995: ln_balancing_credit := ln_balancing_credit + ln_total_excise_edu_cess_amt;
3996: END IF;
3999:
4000: /* ln_balancing_debit := ln_balancing_debit + ln_total_excise_edu_cess_amt; */
4001: /* If condition added by Vijay Shankar for Bug#4211045. Else is existing previously itself as above statement */
4002: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
4003: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
4004: ln_edu_cess_balancing_debit := ln_total_excise_edu_cess_amt;
4005: ELSE
4006: ln_balancing_debit := ln_balancing_debit + ln_total_excise_edu_cess_amt;
4007: END IF;
4016: IF p_cenvat_accounting_type = CENVAT_DEBIT THEN
4017:
4018:
4019:
4020: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
4021: ln_sh_edu_cess_balancin_credit := ln_sh_total_exc_edu_cess_amt;
4022: ELSE
4023: ln_balancing_credit := ln_balancing_credit + ln_sh_total_exc_edu_cess_amt;
4024: END IF;
4025:
4026: ELSE
4027:
4028:
4029: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then
4030: ln_sh_edu_cess_balancin_debit := ln_sh_total_exc_edu_cess_amt;
4031: ELSE
4032: ln_balancing_debit := ln_balancing_debit + ln_sh_total_exc_edu_cess_amt;
4033: END IF;
4061: P_CATEGORY_NAME => gv_category_name,
4062: P_CODE_COMBINATION_ID => ln_cenvat_accnt_id,
4063: P_ENTERED_DR => ln_debit,
4064: P_ENTERED_CR => ln_credit,
4065: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4066: P_ACCOUNTING_DATE => lv_accounting_date,
4067: P_REFERENCE_10 => lv_reference10,
4068: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4069: P_REFERENCE_24 => 'rcv_transactions',
4102: P_CATEGORY_NAME => gv_category_name,
4103: P_CODE_COMBINATION_ID => ln_exc_edu_cess_accnt,
4104: P_ENTERED_DR => ln_edu_cess_debit,
4105: P_ENTERED_CR => ln_edu_cess_credit,
4106: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4107: P_ACCOUNTING_DATE => lv_accounting_date,
4108: P_REFERENCE_10 => lv_reference10,
4109: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4110: P_REFERENCE_24 => 'rcv_transactions',
4143: P_CATEGORY_NAME => gv_category_name,
4144: P_CODE_COMBINATION_ID => ln_sh_exc_edu_cess_accnt,
4145: P_ENTERED_DR => ln_sh_edu_cess_debit,
4146: P_ENTERED_CR => ln_sh_edu_cess_credit,
4147: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4148: P_ACCOUNTING_DATE => lv_accounting_date,
4149: P_REFERENCE_10 => lv_reference10,
4150: P_REFERENCE_23 => 'ja_in_receipt_cenvat_rg_pkg.accounting_entries',
4151: P_REFERENCE_24 => 'rcv_transactions',
4187: P_CATEGORY_NAME => gv_category_name,
4188: P_CODE_COMBINATION_ID => ln_receiving_accnt_id,
4189: P_ENTERED_DR => ln_balancing_debit,
4190: P_ENTERED_CR => ln_balancing_credit,
4191: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4192: P_ACCOUNTING_DATE => lv_accounting_date,
4193: P_REFERENCE_10 => lv_reference10,
4194: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4195: P_REFERENCE_24 => 'rcv_transactions',
4213:
4214: /* following entry (CESS BALANCING ENTRY for RMA Production Input and GOODS RETURN cases)
4215: added by Vijay Shankar for Bug#4211045 */
4216: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt'
4217: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
4218: AND nvl(ln_edu_cess_balancing_debit, ln_edu_cess_balancing_credit) <> 0
4219: THEN
4220:
4221: lv_statement_id := '10b';
4230: P_CATEGORY_NAME => gv_category_name,
4231: P_CODE_COMBINATION_ID => ln_cess_paid_payable_accnt_id,
4232: P_ENTERED_DR => ln_edu_cess_balancing_debit,
4233: P_ENTERED_CR => ln_edu_cess_balancing_credit,
4234: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4235: P_ACCOUNTING_DATE => lv_accounting_date,
4236: P_REFERENCE_10 => lv_reference10,
4237: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4238: P_REFERENCE_24 => 'rcv_transactions',
4259: ||' SH_Debit:'||ln_sh_edu_cess_balancin_debit||', SH_Credit:'||ln_sh_edu_cess_balancin_credit
4260: ||', ln_sh_cess_paid_payable_accnt:'||ln_sh_cess_paid_payable_accnt);
4261: end if;
4262:
4263: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
4264: AND nvl(ln_sh_edu_cess_balancin_debit, ln_sh_edu_cess_balancin_credit) <> 0
4265: THEN
4266:
4267: lv_statement_id := '10d';
4275: P_CATEGORY_NAME => gv_category_name,
4276: 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
4277: P_ENTERED_DR => ln_sh_edu_cess_balancin_debit,
4278: P_ENTERED_CR => ln_sh_edu_cess_balancin_credit,
4279: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4280: P_ACCOUNTING_DATE => lv_accounting_date,
4281: P_REFERENCE_10 => lv_reference10,
4282: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4283: P_REFERENCE_24 => 'rcv_transactions',
4525: P_CATEGORY_NAME => gv_category_name,
4526: P_CODE_COMBINATION_ID => ln_cenvat_accnt_id,
4527: P_ENTERED_DR => ln_debit,
4528: P_ENTERED_CR => ln_credit,
4529: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4530: P_ACCOUNTING_DATE => lv_accounting_date,
4531: P_REFERENCE_10 => lv_reference10,
4532: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4533: P_REFERENCE_24 => 'rcv_transactions',
4568: P_CATEGORY_NAME => gv_category_name,
4569: P_CODE_COMBINATION_ID => ln_exc_edu_cess_accnt,
4570: P_ENTERED_DR => ln_edu_cess_debit,
4571: P_ENTERED_CR => ln_edu_cess_credit,
4572: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4573: P_ACCOUNTING_DATE => lv_accounting_date,
4574: P_REFERENCE_10 => lv_reference10,
4575: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4576: P_REFERENCE_24 => 'rcv_transactions',
4610: P_CATEGORY_NAME => gv_category_name,
4611: P_CODE_COMBINATION_ID => ln_sh_exc_edu_cess_accnt,
4612: P_ENTERED_DR => ln_sh_edu_cess_debit,
4613: P_ENTERED_CR => ln_sh_edu_cess_credit,
4614: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4615: P_ACCOUNTING_DATE => lv_accounting_date,
4616: P_REFERENCE_10 => lv_reference10,
4617: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4618: P_REFERENCE_24 => 'rcv_transactions',
4656: P_CATEGORY_NAME => gv_category_name,
4657: P_CODE_COMBINATION_ID => ln_cenvat_rcvble_accnt_id,
4658: P_ENTERED_DR => ln_balancing_debit,
4659: P_ENTERED_CR => ln_balancing_credit,
4660: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4661: P_ACCOUNTING_DATE => lv_accounting_date,
4662: P_REFERENCE_10 => lv_reference10,
4663: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4664: P_REFERENCE_24 => 'rcv_transactions',
4699: P_CATEGORY_NAME => gv_category_name,
4700: P_CODE_COMBINATION_ID => ln_exc_edu_cess_rcvble_accnt,
4701: P_ENTERED_DR => ln_bal_edu_cess_debit,
4702: P_ENTERED_CR => ln_bal_edu_cess_credit,
4703: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4704: P_ACCOUNTING_DATE => lv_accounting_date,
4705: P_REFERENCE_10 => lv_reference10,
4706: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4707: P_REFERENCE_24 => 'rcv_transactions',
4742: P_CATEGORY_NAME => gv_category_name,
4743: P_CODE_COMBINATION_ID => ln_sh_exc_edu_cess_rcvb_accnt,
4744: P_ENTERED_DR => ln_sh_bal_edu_cess_debit,
4745: P_ENTERED_CR => ln_sh_bal_edu_cess_credit,
4746: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4747: P_ACCOUNTING_DATE => lv_accounting_date,
4748: P_REFERENCE_10 => lv_reference10,
4749: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4750: P_REFERENCE_24 => 'rcv_transactions',
4967: /*
4968: ||Start of bug 5378630
4969: ||Modified the below if statement condition such that the RMA_type 'GOODS RETURN' was changed into GOODS RETURN
4970: */
4971: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma
4972: AND upper(r_jai_receipt_line.rma_type) NOT IN ('PRODUCTION INPUT', 'GOODS RETURN')
4973: THEN
4974: /* End of bug 5378630 */
4975: lv_validation_message := 'RMA Type Not supported';
4979: IF r_trx.organization_type = 'M' AND r_trx.item_class IN ('FGIN', 'FGEX')
4980: and r_base_trx.source_document_code NOT IN ('REQ','INVENTORY') THEN /* 6030615 - interorg */ --added 'REQ' for bug #13514510
4981: lv_validation_message := 'Item Class not supported for Manufacturing Transactions';
4982:
4983: --ELSIF r_trx.organization_type = 'T' AND r_trx.item_class = jai_rcv_trx_processing_pkg.NO_SETUP THEN
4984: --
4985: ELSE
4986: lv_statement_id := '5.1';
4987: END IF;
5176: transactions follow this
5177: This is the function that should be changed if all Receipt Queries should be based on TRANSACTION_ID instead of SHIPMENT_LINE_ID
5178: */
5179: --ln_ancestor_receive_trxn_id :=
5180: -- jai_rcv_trx_processing_pkg.get_ancestor_id(p_transaction_id, p_shipment_line_id, 'RECEIVE');
5181:
5182: -- commented as pert of review and modified p_shipment_line_id -> p_transaction_id
5183: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.get_receive_claimed_ptg', 'START'); /* 1 */
5184: OPEN c_cenvat_claimed_ptg(p_shipment_line_id);
5225:
5226: ln_mod_problem_amt := 0;
5227: ln_nonmod_problem_amt := 0;
5228:
5229: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
5230:
5231: FOR tax_rec IN (SELECT rtl.tax_type ,
5232: nvl(rtl.tax_amount, 0) tax_amount ,
5233: nvl(rtl.modvat_flag, 'N') modvat_flag ,
5230:
5231: FOR tax_rec IN (SELECT rtl.tax_type ,
5232: nvl(rtl.tax_amount, 0) tax_amount ,
5233: nvl(rtl.modvat_flag, 'N') modvat_flag ,
5234: nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr) currency ,
5235: nvl(decode(p_breakup_type, 'RG23D', 100, jtc.mod_cr_percentage), 0) mod_cr_percentage,
5236: nvl(jtc.rounding_factor, 0) rnd,
5237: nvl(jtc.inclusive_tax_flag,'N') INCLUSIVE_TAX_FLAG --12817175
5238: FROM JAI_RCV_LINE_TAXES rtl, JAI_CMN_TAXES_ALL jtc
5242:
5243: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
5244:
5245:
5246: IF tax_rec.currency <> jai_rcv_trx_processing_pkg.gv_func_curr THEN
5247: ln_curr_conv := NVL(p_curr_conv_rate, 1);
5248: ELSE
5249: ln_curr_conv := 1;
5250: END IF;
6522: p_code_combination_id => ln_ccid,
6523: p_entered_dr => ln_debit_amt,
6524: p_entered_cr => ln_credit_amt,
6525:
6526: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6527: p_accounting_date => lv_accounting_date,
6528: p_reference_10 => lv_reference10,
6529: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6530: p_reference_24 => lv_reference24, --'rcv_transactions',
6556: p_code_combination_id => ln_balancing_ccid,
6557: p_entered_dr => ln_balancing_debit_amt,
6558: p_entered_cr => ln_balancing_credit_amt,
6559:
6560: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6561: p_accounting_date => lv_accounting_date,
6562: p_reference_10 => lv_reference10,
6563: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6564: p_reference_24 => lv_reference24, --'rcv_transactions',
6609: p_code_combination_id => ln_ccid,
6610: p_entered_dr => ln_debit_amt,
6611: p_entered_cr => ln_credit_amt,
6612:
6613: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6614: p_accounting_date => lv_accounting_date,
6615: p_reference_10 => lv_reference10,
6616: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6617: p_reference_24 => lv_reference24, --'rcv_transactions',
6643: p_code_combination_id => ln_balancing_ccid,
6644: p_entered_dr => ln_balancing_debit_amt,
6645: p_entered_cr => ln_balancing_credit_amt,
6646:
6647: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6648: p_accounting_date => lv_accounting_date,
6649: p_reference_10 => lv_reference10,
6650: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6651: p_reference_24 => lv_reference24, --'rcv_transactions',
6699: p_code_combination_id => ln_ccid,
6700: p_entered_dr => ln_debit_amt,
6701: p_entered_cr => ln_credit_amt,
6702:
6703: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6704: p_accounting_date => lv_accounting_date,
6705: p_reference_10 => lv_reference10,
6706: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6707: p_reference_24 => lv_reference24, --'rcv_transactions',
6733: p_code_combination_id => ln_balancing_ccid,
6734: p_entered_dr => ln_balancing_debit_amt,
6735: p_entered_cr => ln_balancing_credit_amt,
6736:
6737: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6738: p_accounting_date => lv_accounting_date,
6739: p_reference_10 => lv_reference10,
6740: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6741: p_reference_24 => lv_reference24, --'rcv_transactions',