eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_CONSTANTS

Line 173: lv_debug := jai_constants.yes;

169: lv_cenvat_costed_flag VARCHAR2(15);
170:
171: BEGIN
172: lv_procedure_name := 'jai_rcv_deliver_rtr_pkg.process_transaction';
173: lv_debug := jai_constants.yes;
174: ln_apportion_factor := 1; -- default value added by Vijay Shankar for Bug#4068823 for RECEIPTS DEPLUG
175: ln_modvat_amount := 0;
176: ln_non_modvat_amount := 0;
177: ln_other_modvat_amount := 0;

Line 260: if nvl(p_process_special_source, 'XX') NOT IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim) then

256:
257: /* following condition added by Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
258: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl.
259: */
260: if nvl(p_process_special_source, 'XX') NOT IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim) then
261:
262: -- following gets executed only for NORMAL DELIVER and RTR transactions and not for UNCLAIM Processing till <>
263: lv_statement_id := '5';
264: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

Line 347: end if; -- end of p_process_special_source not in ( jai_constants.cenvat_noclaim ...

343: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
344: ln_total := nvl(ln_non_modvat_amount,0);
345: end if;
346:
347: end if; -- end of p_process_special_source not in ( jai_constants.cenvat_noclaim ...
348:
349: /* following condition added by Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
350: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
351: IF p_process_special_source IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim) THEN

Line 351: IF p_process_special_source IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim) THEN

347: end if; -- end of p_process_special_source not in ( jai_constants.cenvat_noclaim ...
348:
349: /* following condition added by Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
350: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
351: IF p_process_special_source IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim) THEN
352: ln_total := p_process_special_amount;
353: p_codepath := jai_general_pkg.plot_codepath(18.1, p_codepath);
354: ELSE
355: ln_total := nvl(ln_total,0); --In case the Total is Null.

Line 572: or p_process_special_source IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim)

568:
569: /* following was coded to support UNCLAIM functionality during RECEIPTS DEPLUG. Vijay Shankar for Bug#4068823
570: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
571: IF lv_include_cenvat_in_costing = 'Y'
572: or p_process_special_source IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim)
573: THEN
574: p_codepath := jai_general_pkg.plot_codepath(33, p_codepath);
575: lv_cenvat_costed_flag := jai_constants.yes;
576: ELSE

Line 575: lv_cenvat_costed_flag := jai_constants.yes;

571: IF lv_include_cenvat_in_costing = 'Y'
572: or p_process_special_source IN ( jai_constants.cenvat_noclaim, jai_constants.vat_noclaim)
573: THEN
574: p_codepath := jai_general_pkg.plot_codepath(33, p_codepath);
575: lv_cenvat_costed_flag := jai_constants.yes;
576: ELSE
577: p_codepath := jai_general_pkg.plot_codepath(34, p_codepath);
578: lv_cenvat_costed_flag := jai_constants.no;
579: END IF;

Line 578: lv_cenvat_costed_flag := jai_constants.no;

574: p_codepath := jai_general_pkg.plot_codepath(33, p_codepath);
575: lv_cenvat_costed_flag := jai_constants.yes;
576: ELSE
577: p_codepath := jai_general_pkg.plot_codepath(34, p_codepath);
578: lv_cenvat_costed_flag := jai_constants.no;
579: END IF;
580:
581: IF r_trx.attribute1 IS NULL
582: OR (r_trx.attribute1 = jai_rcv_deliver_rtr_pkg.cenvat_costed_flag

Line 583: AND nvl(r_trx.attribute1,jai_constants.no) <> jai_constants.yes)

579: END IF;
580:
581: IF r_trx.attribute1 IS NULL
582: OR (r_trx.attribute1 = jai_rcv_deliver_rtr_pkg.cenvat_costed_flag
583: AND nvl(r_trx.attribute1,jai_constants.no) <> jai_constants.yes)
584: THEN
585:
586: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath);
587: jai_rcv_transactions_pkg.update_attributes(

Line 698: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

694: WHERE jtc.tax_id = rtl.tax_id
695: AND shipment_line_id = p_shipment_line_id
696: AND upper(rtl.tax_type) NOT IN ( 'EXCISE', 'ADDL. EXCISE',
697: 'OTHER EXCISE', 'CVD','TDS', 'MODVAT RECOVERY',
698: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
699: jai_constants.tax_type_exc_edu_cess,
700: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
701: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
702: -- following condition added by Vijay Shankar for Bug#4068823. Service Tax Enhancement

Line 699: jai_constants.tax_type_exc_edu_cess,

695: AND shipment_line_id = p_shipment_line_id
696: AND upper(rtl.tax_type) NOT IN ( 'EXCISE', 'ADDL. EXCISE',
697: 'OTHER EXCISE', 'CVD','TDS', 'MODVAT RECOVERY',
698: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
699: jai_constants.tax_type_exc_edu_cess,
700: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
701: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
702: -- following condition added by Vijay Shankar for Bug#4068823. Service Tax Enhancement
703: -- this is added to Stop Recovery Service Tax Accounting, as this will be done during RECEIVE trx or

Line 700: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

696: AND upper(rtl.tax_type) NOT IN ( 'EXCISE', 'ADDL. EXCISE',
697: 'OTHER EXCISE', 'CVD','TDS', 'MODVAT RECOVERY',
698: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
699: jai_constants.tax_type_exc_edu_cess,
700: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
701: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
702: -- following condition added by Vijay Shankar for Bug#4068823. Service Tax Enhancement
703: -- this is added to Stop Recovery Service Tax Accounting, as this will be done during RECEIVE trx or
704: -- during Payables Invoice/Payment depending on transaction parameters

Line 701: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740

697: 'OTHER EXCISE', 'CVD','TDS', 'MODVAT RECOVERY',
698: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
699: jai_constants.tax_type_exc_edu_cess,
700: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
701: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
702: -- following condition added by Vijay Shankar for Bug#4068823. Service Tax Enhancement
703: -- this is added to Stop Recovery Service Tax Accounting, as this will be done during RECEIVE trx or
704: -- during Payables Invoice/Payment depending on transaction parameters
705: AND rtl.tax_type NOT IN (select attribute_code from JAI_RGM_REGISTRATIONS aa, JAI_RGM_DEFINITIONS bb

Line 708: and bb.regime_code IN (jai_constants.service_regime, jai_constants.vat_regime)

704: -- during Payables Invoice/Payment depending on transaction parameters
705: AND rtl.tax_type NOT IN (select attribute_code from JAI_RGM_REGISTRATIONS aa, JAI_RGM_DEFINITIONS bb
706: where aa.regime_id = bb.regime_id
707: /* vat_regime is included in the following clause by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
708: and bb.regime_code IN (jai_constants.service_regime, jai_constants.vat_regime)
709: and aa.registration_type = jai_constants.regn_type_tax_types )
710: AND NVL(rtl.modvat_flag, 'N') = 'Y'
711: GROUP BY jtc.tax_account_id
712: )

Line 709: and aa.registration_type = jai_constants.regn_type_tax_types )

705: AND rtl.tax_type NOT IN (select attribute_code from JAI_RGM_REGISTRATIONS aa, JAI_RGM_DEFINITIONS bb
706: where aa.regime_id = bb.regime_id
707: /* vat_regime is included in the following clause by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
708: and bb.regime_code IN (jai_constants.service_regime, jai_constants.vat_regime)
709: and aa.registration_type = jai_constants.regn_type_tax_types )
710: AND NVL(rtl.modvat_flag, 'N') = 'Y'
711: GROUP BY jtc.tax_account_id
712: )
713: LOOP

Line 929: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

925:
926: if tax_rec.modvat_flag = 'Y'
927: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
928: 'TDS', 'MODVAT RECOVERY',
929: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
930: jai_constants.tax_type_exc_edu_cess,
931: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
932: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
933: then

Line 930: jai_constants.tax_type_exc_edu_cess,

926: if tax_rec.modvat_flag = 'Y'
927: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
928: 'TDS', 'MODVAT RECOVERY',
929: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
930: jai_constants.tax_type_exc_edu_cess,
931: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
932: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
933: then
934:

Line 931: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

927: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
928: 'TDS', 'MODVAT RECOVERY',
929: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
930: jai_constants.tax_type_exc_edu_cess,
931: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
932: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
933: then
934:
935: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

Line 932: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740

928: 'TDS', 'MODVAT RECOVERY',
929: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
930: jai_constants.tax_type_exc_edu_cess,
931: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
932: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
933: then
934:
935: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
936: lv_tax_modvat_flag := 'Y';

Line 940: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

936: lv_tax_modvat_flag := 'Y';
937:
938: elsif upper(tax_rec.modvat_flag) = 'Y'
939: and tax_rec.tax_type NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
940: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
941: jai_constants.tax_type_exc_edu_cess,
942: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
943: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
944: then

Line 941: jai_constants.tax_type_exc_edu_cess,

937:
938: elsif upper(tax_rec.modvat_flag) = 'Y'
939: and tax_rec.tax_type NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
940: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
941: jai_constants.tax_type_exc_edu_cess,
942: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
943: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
944: then
945:

Line 942: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

938: elsif upper(tax_rec.modvat_flag) = 'Y'
939: and tax_rec.tax_type NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
940: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
941: jai_constants.tax_type_exc_edu_cess,
942: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
943: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
944: then
945:
946: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */

Line 943: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740

939: and tax_rec.tax_type NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
940: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
941: jai_constants.tax_type_exc_edu_cess,
942: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
943: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
944: then
945:
946: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
947: lv_tax_modvat_flag := 'Y';

Line 955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

951: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
952: and r_ja_in_rcv_transactions.item_excisable = 'Y'
953: and r_ja_in_rcv_transactions.organization_type = 'T'
954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
956: jai_constants.tax_type_exc_edu_cess,
957: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
958: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
959: then

Line 956: jai_constants.tax_type_exc_edu_cess,

952: and r_ja_in_rcv_transactions.item_excisable = 'Y'
953: and r_ja_in_rcv_transactions.organization_type = 'T'
954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
956: jai_constants.tax_type_exc_edu_cess,
957: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
958: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
959: then
960:

Line 957: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

953: and r_ja_in_rcv_transactions.organization_type = 'T'
954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
956: jai_constants.tax_type_exc_edu_cess,
957: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
958: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
959: then
960:
961: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 958: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740

954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
956: jai_constants.tax_type_exc_edu_cess,
957: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
958: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
959: then
960:
961: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
962: lv_tax_modvat_flag := 'Y';

Line 977: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

973: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
974:
975: if lv_tax_modvat_flag = 'Y'
976: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
977: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
978: jai_constants.tax_type_exc_edu_cess,
979: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
980: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
981: then

Line 978: jai_constants.tax_type_exc_edu_cess,

974:
975: if lv_tax_modvat_flag = 'Y'
976: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
977: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
978: jai_constants.tax_type_exc_edu_cess,
979: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
980: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
981: then
982:

Line 979: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

975: if lv_tax_modvat_flag = 'Y'
976: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
977: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
978: jai_constants.tax_type_exc_edu_cess,
979: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
980: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
981: then
982:
983: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */

Line 980: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740

976: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
977: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
978: jai_constants.tax_type_exc_edu_cess,
979: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
980: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
981: then
982:
983: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
984: ln_modvat_amount := ln_modvat_amount + tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor;

Line 1003: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

999: -- Added by Jia Li for India tax inclusive 2007/11/28, End
1000:
1001: elsif lv_tax_modvat_flag = 'Y'
1002: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1003: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1004: jai_constants.tax_type_exc_edu_cess,
1005: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
1006: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
1007: then

Line 1004: jai_constants.tax_type_exc_edu_cess,

1000:
1001: elsif lv_tax_modvat_flag = 'Y'
1002: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1003: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1004: jai_constants.tax_type_exc_edu_cess,
1005: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
1006: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
1007: then
1008:

Line 1005: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

1001: elsif lv_tax_modvat_flag = 'Y'
1002: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1003: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1004: jai_constants.tax_type_exc_edu_cess,
1005: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
1006: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
1007: then
1008:
1009: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

Line 1006: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740

1002: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1003: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1004: jai_constants.tax_type_exc_edu_cess,
1005: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS
1006: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) -- added by csahoo for bug#5989740
1007: then
1008:
1009: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1010: ln_other_modvat_amount := ln_other_modvat_amount + tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor;

Line 1361: IF p_process_special_source = jai_constants.cenvat_noclaim THEN

1357: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.expense_accounting', 'START'); /* 1 */
1358:
1359: /* Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1360: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1361: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1362: lv_account_nature := 'Cenvat Unclaim Expense';
1363: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1364: lv_account_nature := 'VAT Unclaim Expense';
1365: END IF;

Line 1363: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN

1359: /* Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1360: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1361: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1362: lv_account_nature := 'Cenvat Unclaim Expense';
1363: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1364: lv_account_nature := 'VAT Unclaim Expense';
1365: END IF;
1366:
1367: if p_transaction_type='CORRECT' then

Line 1570: IF p_process_special_source = jai_constants.cenvat_noclaim THEN

1566: lv_account_nature := 'Average Costing';
1567:
1568: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.average_costing', 'START'); /* 1 */
1569:
1570: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1571: lv_account_nature := 'Unclaim Average Costing';
1572:
1573: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1574: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN

Line 1574: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN

1570: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1571: lv_account_nature := 'Unclaim Average Costing';
1572:
1573: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1574: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1575: lv_account_nature := 'VAT Unclaim Average Costing';
1576: END IF;
1577:
1578: /* Fetch the Material Account Id */

Line 1780: IF p_process_special_source = jai_constants.cenvat_noclaim THEN

1776:
1777: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1778:
1779: -- Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1780: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1781: lv_account_nature := 'Unclaim Standard Costing';
1782:
1783: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1784: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN

Line 1784: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN

1780: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1781: lv_account_nature := 'Unclaim Standard Costing';
1782:
1783: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1784: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1785: lv_account_nature := 'VAT Unclaim Standard Costing';
1786: END IF;
1787:
1788: ln_ppv_account_id := ppv_account

Line 2241: SELECT nvl(unclaim_cenvat_flag, jai_constants.no) unclaim_cenvat_flag,

2237:
2238: ln_dlry_trx_id NUMBER;
2239:
2240: CURSOR c_receipt_cenvat_dtl(cp_transaction_id IN NUMBER) IS
2241: SELECT nvl(unclaim_cenvat_flag, jai_constants.no) unclaim_cenvat_flag,
2242: nvl(non_bonded_delivery_flag, jai_constants.no) non_bonded_delivery_flag,
2243: nvl(cenvat_claimed_amt, 0) cenvat_claimed_amt
2244: FROM JAI_RCV_CENVAT_CLAIMS
2245: WHERE transaction_id = cp_transaction_id;

Line 2242: nvl(non_bonded_delivery_flag, jai_constants.no) non_bonded_delivery_flag,

2238: ln_dlry_trx_id NUMBER;
2239:
2240: CURSOR c_receipt_cenvat_dtl(cp_transaction_id IN NUMBER) IS
2241: SELECT nvl(unclaim_cenvat_flag, jai_constants.no) unclaim_cenvat_flag,
2242: nvl(non_bonded_delivery_flag, jai_constants.no) non_bonded_delivery_flag,
2243: nvl(cenvat_claimed_amt, 0) cenvat_claimed_amt
2244: FROM JAI_RCV_CENVAT_CLAIMS
2245: WHERE transaction_id = cp_transaction_id;
2246: