[Home] [Help]
1: PACKAGE BODY jai_rcv_excise_processing_pkg AS
2: /* $Header: jai_rcv_exc_prc.plb 120.38.12020000.4 2012/12/21 15:14:47 vkavulur ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
167: ) RETURN TAX_BREAKUP IS
168:
169: r_tax TAX_BREAKUP;
170: ln_factor NUMBER;
171: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_apportioned_tax';
172:
173: BEGIN
174:
175: if p_factor IS NULL THEN /*Commented the condition or p_factor = 0 the changes for bug # 8644480 */
221: FROM JAI_RCV_CENVAT_CLAIMS
222: WHERE transaction_id = cp_transaction_id;
223:
224: r_receipt_cenvat_dtl c_receipt_cenvat_dtl%ROWTYPE;
225: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_changed_vendor_dtls';
226:
227: BEGIN
228:
229: OPEN c_receipt_cenvat_dtl(p_receive_trx_id);
280:
281:
282: ln_trx_qty_for_2nd_claim NUMBER;
283: ln_trx_equivalent_of_receive NUMBER;
284: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.post_cenvat_processor';
285:
286:
287:
288:
423: END post_cenvat_processor;
424:
425: /* Start of bug 5365346. Created by Lakshmi Gopalsami */
426: PROCEDURE update_RTV_Diff_value
427: (pr_base_trx IN jai_rcv_excise_processing_pkg.c_base_trx%ROWTYPE,
428: pr_tax IN jai_rcv_excise_processing_pkg.c_trx%ROWTYPE,
429: pr_diff_tax IN TAX_BREAKUP,
430: p_source_reg IN VARCHAR2 ,
431: p_register_entry_type IN VARCHAR2 ,
424:
425: /* Start of bug 5365346. Created by Lakshmi Gopalsami */
426: PROCEDURE update_RTV_Diff_value
427: (pr_base_trx IN jai_rcv_excise_processing_pkg.c_base_trx%ROWTYPE,
428: pr_tax IN jai_rcv_excise_processing_pkg.c_trx%ROWTYPE,
429: pr_diff_tax IN TAX_BREAKUP,
430: p_source_reg IN VARCHAR2 ,
431: p_register_entry_type IN VARCHAR2 ,
432: p_register_id IN OUT NOCOPY NUMBER,
467:
468: BEGIN
469:
470: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath,
471: 'jai_rcv_excise_processing_pkg.update_RTV_Diff_value', 'START');
472:
473:
474: lv_statement_id := '1';
475: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath);
923: ln_total_cenvat NUMBER;
924: ln_total_cenvat_rounded NUMBER;
925: ln_rounded_amt NUMBER;
926:
927: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.do_cenvat_rounding';
928: BEGIN
929:
930: FND_FILE.put_line(FND_FILE.log, '^CENVAT_RG_PKG.do_cenvat_rounding. Basic->'||pr_tax.basic_excise
931: ||', Additional->'||pr_tax.addl_excise
1113:
1114: BEGIN
1115:
1116: /*----------------------------------------------------------------------------------------------------------------------------
1117: CHANGE HISTORY for FILENAME: jai_rcv_excise_processing_pkg.sql
1118: S.No dd/mm/yyyy Author and Details
1119: ------------------------------------------------------------------------------------------------------------------------------
1120: 1 26/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
1121: This Package is coded for Corrections Enhancement to invoke CENVAT and RG related insert APIs for PO Functionality.
1250: lv_procedure_name := 'CENVAT_RG_PKG.process_transaction';
1251: ln_amount_factor := 1;
1252:
1253: -- this is to identify the path in SQL TRACE file if any problem occured
1254: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1255:
1256: if lb_rg_debug then
1257: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1258: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1253: -- this is to identify the path in SQL TRACE file if any problem occured
1254: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1255:
1256: if lb_rg_debug then
1257: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1258: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1259: end if;
1260:
1261: /* Added for bug #13362352 */
1254: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1255:
1256: if lb_rg_debug then
1257: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1258: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1259: end if;
1260:
1261: /* Added for bug #13362352 */
1262: OPEN cur_destination_type_code;
1264: CLOSE cur_destination_type_code;
1265:
1266: lv_statement_id := '0';
1267: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.process_trx', 'START'); /* 1 */
1268: FND_FILE.put_line( FND_FILE.log, '***** Start of jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );
1269:
1270: lv_statement_id := '1';
1271: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1272: OPEN c_trx(p_transaction_id);
1325: );
1326:
1327: -- Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG
1328: -- following should be executed only incase of RECEIVE (or) MATCH transactions and that too for 2nd claim
1329: IF p_process_special_reason = jai_rcv_excise_processing_pkg.second_50ptg_claim THEN
1330: /* Bug 6800251. Added by Lakshmi Gopalsami
1331: * Get the total RTV qty and proportion it against the receipt qty.
1332: * The tax breakup should happen for the remaining quantity so that
1333: * half of the amount can be used for 2nd claim.
1347: -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1348: END IF;
1349:
1350: if lb_rg_debug then
1351: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1352: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1353: end if;
1354:
1355: -- Following is to calculate Tax Breakup Amount As Per Apportion Factor. This is calculated based on
1348: END IF;
1349:
1350: if lb_rg_debug then
1351: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1352: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1353: end if;
1354:
1355: -- Following is to calculate Tax Breakup Amount As Per Apportion Factor. This is calculated based on
1356: -- Transaction UOMs, Quantities of Parent RECEIVE and present trxn an
1998: p_process_message := 'CENVAT_RG_PKG.process_trxn:'||lv_message||', StatementId:'||lv_statement_id;
1999: END IF;
2000:
2001: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath, null, 'END'); /* 26 */
2002: FND_FILE.put_line( FND_FILE.log, '----- END, jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );
2003:
2004: EXCEPTION
2005: WHEN OTHERS THEN
2006: p_process_status := 'E';
2768: ln_other_tax_debit := pr_tax.excise_edu_cess;
2769: ELSE
2770: ln_other_tax_credit := pr_tax.excise_edu_cess;
2771: END IF;
2772: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2773: p_source_register => jai_constants.reg_rg23d,
2774: p_source_register_id => p_register_id,
2775: p_tax_type => jai_constants.tax_type_exc_edu_cess,
2776: p_credit => ln_other_tax_credit,
2788: ln_other_tax_debit := pr_tax.cvd_edu_cess;
2789: ELSE
2790: ln_other_tax_credit := pr_tax.cvd_edu_cess;
2791: END IF;
2792: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2793: p_source_register => jai_constants.reg_rg23d,
2794: p_source_register_id => p_register_id,
2795: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
2796: p_credit => ln_other_tax_credit,
2810: ELSE
2811: ln_other_tax_credit := pr_tax.sh_exc_edu_cess;
2812: END IF;
2813:
2814: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2815: p_source_register => jai_constants.reg_rg23d,
2816: p_source_register_id => p_register_id,
2817: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
2818: p_credit => ln_other_tax_credit,
2830: ln_other_tax_debit := pr_tax.sh_cvd_edu_cess;
2831: ELSE
2832: ln_other_tax_credit := pr_tax.sh_cvd_edu_cess;
2833: END IF;
2834: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2835: p_source_register => jai_constants.reg_rg23d,
2836: p_source_register_id => p_register_id,
2837: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
2838: p_credit => ln_other_tax_credit,
3165: ln_other_tax_debit := pr_tax.excise_edu_cess;
3166: ELSE
3167: ln_other_tax_credit := pr_tax.excise_edu_cess;
3168: END IF;
3169: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3170: p_source_register => lv_source_register,
3171: p_source_register_id => p_register_id,
3172: p_tax_type => jai_constants.tax_type_exc_edu_cess,
3173: p_credit => ln_other_tax_credit,
3190: --added for bug#9854329, end
3191: ELSE
3192: ln_other_tax_credit := pr_tax.cvd_edu_cess;
3193: END IF;
3194: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3195: p_source_register => lv_source_register,
3196: p_source_register_id => p_register_id,
3197: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
3198: p_credit => ln_other_tax_credit,
3209: ln_other_tax_debit := pr_tax.sh_exc_edu_cess;
3210: ELSE
3211: ln_other_tax_credit := pr_tax.sh_exc_edu_cess;
3212: END IF;
3213: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3214: p_source_register => lv_source_register,
3215: p_source_register_id => p_register_id,
3216: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
3217: p_credit => ln_other_tax_credit,
3234: --added for bug#9854329, end
3235: ELSE
3236: ln_other_tax_credit := pr_tax.sh_cvd_edu_cess;
3237: END IF;
3238: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3239: p_source_register => lv_source_register,
3240: p_source_register_id => p_register_id,
3241: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
3242: p_credit => ln_other_tax_credit,
3438: ln_other_tax_debit := pr_tax.excise_edu_cess;
3439: ELSE
3440: ln_other_tax_credit := pr_tax.excise_edu_cess;
3441: END IF;
3442: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3443: p_source_register => jai_constants.reg_pla,
3444: p_source_register_id => p_register_id,
3445: p_tax_type => jai_constants.tax_type_exc_edu_cess,
3446: p_credit => ln_other_tax_credit,
3463: -- added by vkaranam for bug#9854329, end
3464: ELSE
3465: ln_other_tax_credit := pr_tax.cvd_edu_cess;
3466: END IF;
3467: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3468: p_source_register => jai_constants.reg_pla,
3469: p_source_register_id => p_register_id,
3470: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
3471: p_credit => ln_other_tax_credit,
3484: ELSE
3485: ln_other_tax_credit := nvl(pr_tax.sh_exc_edu_cess,0);
3486: END IF;
3487:
3488: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3489: p_source_register => jai_constants.reg_pla,
3490: p_source_register_id => p_register_id,
3491: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
3492: p_credit => ln_other_tax_credit,
3509: -- added by vkaranam for bug#9854329, end
3510: ELSE
3511: ln_other_tax_credit := nvl(pr_tax.sh_cvd_edu_cess,0);
3512: END IF;
3513: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3514: p_source_register => jai_constants.reg_pla,
3515: p_source_register_id => p_register_id,
3516: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
3517: p_credit => ln_other_tax_credit,
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',
4070: P_REFERENCE_25 => 'transaction_id',
4071: P_REFERENCE_26 => to_char(p_transaction_id),
4072: P_DESTINATION => 'G',
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',
4111: P_REFERENCE_25 => 'transaction_id',
4112: P_REFERENCE_26 => to_char(p_transaction_id),
4113: P_DESTINATION => 'G',
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',
4196: P_REFERENCE_25 => 'transaction_id',
4197: P_REFERENCE_26 => to_char(p_transaction_id),
4198: P_DESTINATION => 'G',
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',
4239: P_REFERENCE_25 => 'transaction_id',
4240: P_REFERENCE_26 => to_char(p_transaction_id),
4241: P_DESTINATION => 'G',
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',
4284: P_REFERENCE_25 => 'transaction_id',
4285: P_REFERENCE_26 => to_char(p_transaction_id),
4286: P_DESTINATION => 'G',
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',
4534: P_REFERENCE_25 => 'transaction_id',
4535: P_REFERENCE_26 => to_char(p_transaction_id),
4536: P_DESTINATION => 'G',
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',
4577: P_REFERENCE_25 => 'transaction_id',
4578: P_REFERENCE_26 => to_char(p_transaction_id),
4579: P_DESTINATION => 'G',
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',
4619: P_REFERENCE_25 => 'transaction_id',
4620: P_REFERENCE_26 => to_char(p_transaction_id),
4621: P_DESTINATION => 'G',
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',
4665: P_REFERENCE_25 => 'transaction_id',
4666: P_REFERENCE_26 => to_char(p_transaction_id),
4667: P_DESTINATION => 'G',
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',
4708: P_REFERENCE_25 => 'transaction_id',
4709: P_REFERENCE_26 => to_char(p_transaction_id),
4710: P_DESTINATION => 'G',
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',
4751: P_REFERENCE_25 => 'transaction_id',
4752: P_REFERENCE_26 => to_char(p_transaction_id),
4753: P_DESTINATION => 'G',
5164: FROM JAI_RCV_CENVAT_CLAIMS
5165: WHERE shipment_line_id = cp_shipment_line_id;
5166:
5167: ln_cenvat_claimed_ptg NUMBER;
5168: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_receive_claimed_ptg';
5169:
5170: --ln_ancestor_receive_trxn_id JAI_RCV_TRANSACTIONS.transaction_id%TYPE;
5171:
5172: BEGIN
5209: ln_curr_conv NUMBER;
5210: ln_mod_problem_amt NUMBER;
5211: ln_nonmod_problem_amt NUMBER;
5212: ln_apportion_factor NUMBER;
5213: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_tax_amount_breakup';
5214:
5215: BEGIN
5216: /* This procedure returns excise amounts as per transaction quantity
5217: If p_breakup_type is RG23D, then total tax amount should be added to excise amount instead of taking
5563: p_process_status OUT NOCOPY VARCHAR2,
5564: p_process_message OUT NOCOPY VARCHAR2
5565: ) IS
5566: ln_source_type NUMBER(2);
5567: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.other_cenvat_rg_recording';
5568: BEGIN
5569:
5570: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN
5571: ln_source_type := jai_constants.reg_rg23_2_code;
5607:
5608: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
5609: ln_receive_claimed_ptg NUMBER;
5610: lv_message VARCHAR2(200);
5611: lv_object_name varchar2(200) := 'jai_rcv_excise_processing_pkg.dervice_cgin_scenario';
5612:
5613: BEGIN
5614:
5615: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.cgin_scenario' , 'START'); /* 1 */
6233: lv_accounting_date DATE;
6234: lv_acct_nature JAI_RCV_JOURNAL_ENTRIES.acct_nature%TYPE;
6235: lv_acct_type JAI_RCV_JOURNAL_ENTRIES.acct_type%TYPE;
6236:
6237: r_diff_tax jai_rcv_excise_processing_pkg.TAX_BREAKUP;
6238: r_rtv_dtls c_rtv_dtls%ROWTYPE;
6239:
6240: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
6241: ln_excise_cess_rate NUMBER;
6266: r_base_trx c_base_trx%ROWTYPE;
6267: begin
6268:
6269: lv_statement_id := '1';
6270: pv_codepath := jai_general_pkg.plot_codepath(1, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'START');
6271: lv_simulate_flag := jai_constants.no;
6272: lv_register_entry_type := jai_rcv_excise_processing_pkg.cenvat_debit;
6273:
6274: open c_trx(pn_transaction_id);
6268:
6269: lv_statement_id := '1';
6270: pv_codepath := jai_general_pkg.plot_codepath(1, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'START');
6271: lv_simulate_flag := jai_constants.no;
6272: lv_register_entry_type := jai_rcv_excise_processing_pkg.cenvat_debit;
6273:
6274: open c_trx(pn_transaction_id);
6275: fetch c_trx into r_trx;
6276: close c_trx;
6325: --added by csahoo for bug#6078460, end
6326:
6327: lv_statement_id := '3';
6328: /* Start Register Entry */
6329: jai_rcv_excise_processing_pkg.derive_duty_registers(
6330: p_organization_id => r_trx.organization_id,
6331: p_location_id => r_trx.location_id,
6332: p_item_class => r_trx.item_class,
6333: pr_tax => r_diff_tax,
6349: pv_codepath := jai_general_pkg.plot_codepath(17, pv_codepath);
6350:
6351: lv_reference_num := 'CENVAT-SSI';
6352: /*
6353: jai_rcv_excise_processing_pkg.rg23_part_ii_entry(
6354: p_transaction_id => r_trx.transaction_id,
6355: pr_tax => r_diff_tax,
6356: p_part_i_register_id => null,
6357: p_register_entry_type => lv_register_entry_type,
6390: lv_statement_id := '7';
6391: pv_codepath := jai_general_pkg.plot_codepath(17.1, pv_codepath);
6392: /* Bug 5365346. Added by Lakshmi Gopalsami
6393: Commented the call to pla entry and added
6394: jai_rcv_excise_processing_pkg.pla_entry(
6395: p_transaction_id => r_trx.transaction_id,
6396: pr_tax => r_diff_tax,
6397: p_register_entry_type => lv_register_entry_type,
6398: p_register_id => ln_part_ii_register_id,
6497: if r_trx.transaction_type = 'CORRECT' THEN
6498: lv_reference10 := lv_reference10 || ' of '||r_trx.parent_transaction_type;
6499: end if;
6500:
6501: if lv_register_entry_type = jai_rcv_excise_processing_pkg.CENVAT_DEBIT then
6502: ln_debit_amt := null;
6503: ln_credit_amt := r_diff_tax.basic_excise;
6504: ln_balancing_debit_amt := r_diff_tax.basic_excise;
6505: ln_balancing_credit_amt := null;
6515: jai_rcv_accounting_pkg.process_transaction(
6516: p_transaction_id => r_trx.transaction_id,
6517: p_acct_type => lv_acct_type,
6518: p_acct_nature => lv_acct_nature,
6519: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6520: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6521:
6522: p_code_combination_id => ln_ccid,
6523: p_entered_dr => ln_debit_amt,
6516: p_transaction_id => r_trx.transaction_id,
6517: p_acct_type => lv_acct_type,
6518: p_acct_nature => lv_acct_nature,
6519: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6520: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6521:
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',
6531: p_reference_25 => lv_reference25, --'transaction_id',
6532: p_reference_26 => lv_reference26, --
6533: p_destination => 'G',
6549: jai_rcv_accounting_pkg.process_transaction(
6550: p_transaction_id => r_trx.transaction_id,
6551: p_acct_type => lv_acct_type,
6552: p_acct_nature => lv_acct_nature,
6553: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6554: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6555:
6556: p_code_combination_id => ln_balancing_ccid,
6557: p_entered_dr => ln_balancing_debit_amt,
6550: p_transaction_id => r_trx.transaction_id,
6551: p_acct_type => lv_acct_type,
6552: p_acct_nature => lv_acct_nature,
6553: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6554: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6555:
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',
6565: p_reference_25 => lv_reference25, --'transaction_id',
6566: p_reference_26 => lv_reference26, --
6567: p_destination => 'G',
6584: lv_statement_id := '24';
6585: lv_acct_nature := 'CENVAT-EDUCESS-SSI';
6586: ln_ccid := ln_excise_cess_accnt_id;
6587:
6588: if lv_register_entry_type = jai_rcv_excise_processing_pkg.CENVAT_DEBIT then
6589: ln_debit_amt := null;
6590: ln_credit_amt := r_diff_tax.excise_edu_cess;
6591: ln_balancing_debit_amt := r_diff_tax.excise_edu_cess;
6592: ln_balancing_credit_amt := null;
6602: jai_rcv_accounting_pkg.process_transaction(
6603: p_transaction_id => r_trx.transaction_id,
6604: p_acct_type => lv_acct_type,
6605: p_acct_nature => lv_acct_nature,
6606: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6607: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6608:
6609: p_code_combination_id => ln_ccid,
6610: p_entered_dr => ln_debit_amt,
6603: p_transaction_id => r_trx.transaction_id,
6604: p_acct_type => lv_acct_type,
6605: p_acct_nature => lv_acct_nature,
6606: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6607: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6608:
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',
6618: p_reference_25 => lv_reference25, --'transaction_id',
6619: p_reference_26 => lv_reference26, --
6620: p_destination => 'G',
6636: jai_rcv_accounting_pkg.process_transaction(
6637: p_transaction_id => r_trx.transaction_id,
6638: p_acct_type => lv_acct_type,
6639: p_acct_nature => lv_acct_nature,
6640: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6641: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6642:
6643: p_code_combination_id => ln_balancing_ccid,
6644: p_entered_dr => ln_balancing_debit_amt,
6637: p_transaction_id => r_trx.transaction_id,
6638: p_acct_type => lv_acct_type,
6639: p_acct_nature => lv_acct_nature,
6640: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6641: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6642:
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',
6652: p_reference_25 => lv_reference25, --'transaction_id',
6653: p_reference_26 => lv_reference26, --
6654: p_destination => 'G',
6674: lv_statement_id := '29';
6675: lv_acct_nature := 'CENVAT-SH-EDUCESS-SSI';
6676: ln_ccid := ln_excise_sh_cess_accnt_id;
6677:
6678: if lv_register_entry_type = jai_rcv_excise_processing_pkg.CENVAT_DEBIT then
6679: ln_debit_amt := null;
6680: ln_credit_amt := r_diff_tax.sh_exc_edu_cess;
6681: ln_balancing_debit_amt := r_diff_tax.sh_exc_edu_cess;
6682: ln_balancing_credit_amt := null;
6692: jai_rcv_accounting_pkg.process_transaction(
6693: p_transaction_id => r_trx.transaction_id,
6694: p_acct_type => lv_acct_type,
6695: p_acct_nature => lv_acct_nature,
6696: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6697: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6698:
6699: p_code_combination_id => ln_ccid,
6700: p_entered_dr => ln_debit_amt,
6693: p_transaction_id => r_trx.transaction_id,
6694: p_acct_type => lv_acct_type,
6695: p_acct_nature => lv_acct_nature,
6696: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6697: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6698:
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',
6708: p_reference_25 => lv_reference25, --'transaction_id',
6709: p_reference_26 => lv_reference26, --
6710: p_destination => 'G',
6726: jai_rcv_accounting_pkg.process_transaction(
6727: p_transaction_id => r_trx.transaction_id,
6728: p_acct_type => lv_acct_type,
6729: p_acct_nature => lv_acct_nature,
6730: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6731: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6732:
6733: p_code_combination_id => ln_balancing_ccid,
6734: p_entered_dr => ln_balancing_debit_amt,
6727: p_transaction_id => r_trx.transaction_id,
6728: p_acct_type => lv_acct_type,
6729: p_acct_nature => lv_acct_nature,
6730: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6731: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6732:
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',
6742: p_reference_25 => lv_reference25, --'transaction_id',
6743: p_reference_26 => lv_reference26, --
6744: p_destination => 'G',
6762:
6763: lv_statement_id := '29';
6764: pv_process_status := jai_constants.yes;
6765: <
6766: pv_codepath := jai_general_pkg.plot_codepath(75, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6767:
6768: exception
6769: when others then
6770: pv_process_status := 'E';
6767:
6768: exception
6769: when others then
6770: pv_process_status := 'E';
6771: pv_process_message := 'Unexpected error in jai_rcv_excise_processing_pkg.rtv_processing_for_ssi(StmtId:'
6772: ||lv_statement_id||'). ErrMsg:'||SQLERRM;
6773: pv_codepath := jai_general_pkg.plot_codepath(999, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6774:
6775: end rtv_processing_for_ssi;
6769: when others then
6770: pv_process_status := 'E';
6771: pv_process_message := 'Unexpected error in jai_rcv_excise_processing_pkg.rtv_processing_for_ssi(StmtId:'
6772: ||lv_statement_id||'). ErrMsg:'||SQLERRM;
6773: pv_codepath := jai_general_pkg.plot_codepath(999, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6774:
6775: end rtv_processing_for_ssi;
6776: --start additions for bug#4750798
6777: PROCEDURE get_excise_tax_rounding_factor(
6809:
6810: --end additions for bug#4750798
6811:
6812:
6813: END jai_rcv_excise_processing_pkg;