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_TAX_PKG dependencies on JAI_CONSTANTS

Line 222: SELECT nvl(process_status_flag, jai_constants.no) process_status_flag,

218: AND a.organization_id = cp_organization_id
219: AND (cp_location_id is null or a.location_id=cp_location_id);
220:
221: CURSOR c_rcv_rgm_dtl(cp_regime_code VARCHAR2, cp_shipment_line_id NUMBER) IS
222: SELECT nvl(process_status_flag, jai_constants.no) process_status_flag,
223: regime_item_class,
224: invoice_no
225: FROM jai_rcv_rgm_lines
226: WHERE shipment_line_id = cp_shipment_line_id

Line 1224: "IF lv_vat_recoverable_for_item = jai_constants.yes

1220:
1221: Fix
1222: ---
1223: 1) Commented the Condition -
1224: "IF lv_vat_recoverable_for_item = jai_constants.yes
1225: AND NVL(ln_chk_vat, 0) <> 0
1226: AND r_rcv_rgm_dtl.process_status_flag <> 'U' --Not Unclaimed
1227: AND r_rcv_rgm_dtl.invoice_no IS NULL"
1228:

Line 1350: v_duplicate_ship := jai_constants.no;

1346:
1347: --File.Sql.35 Cbabu
1348: -- v_form_id := 'JAINPORE';
1349: v_tax_total := 0;
1350: v_duplicate_ship := jai_constants.no;
1351: v_chk_receipt_lines :=0;
1352: v_chk_receipt_tax_lines :=0;
1353: v_precedence_0 :=0;
1354: v_precedence_non_0 :=0;

Line 1356: v_debug_flag := jai_constants.no;

1352: v_chk_receipt_tax_lines :=0;
1353: v_precedence_0 :=0;
1354: v_precedence_non_0 :=0;
1355: v_tax_base :=0;
1356: v_debug_flag := jai_constants.no;
1357: v_price_override :=0;
1358: v_po_quantity :=0;
1359: v_assessable_value :=0;
1360: ln_vat_assess_value :=0;

Line 1712: p_regime_code => jai_constants.vat_regime,

1708: --Pick Item Modvat Flag---------------------------------------------------------------------
1709:
1710: /* Start, following call added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1711: jai_inv_items_pkg.jai_get_attrib(
1712: p_regime_code => jai_constants.vat_regime,
1713: p_organization_id => p_organization_id,
1714: p_inventory_item_id => v_item_id,
1715: p_attribute_code => jai_constants.rgm_attr_item_recoverable,
1716: p_attribute_value => lv_vat_recoverable_for_item,

Line 1715: p_attribute_code => jai_constants.rgm_attr_item_recoverable,

1711: jai_inv_items_pkg.jai_get_attrib(
1712: p_regime_code => jai_constants.vat_regime,
1713: p_organization_id => p_organization_id,
1714: p_inventory_item_id => v_item_id,
1715: p_attribute_code => jai_constants.rgm_attr_item_recoverable,
1716: p_attribute_value => lv_vat_recoverable_for_item,
1717: p_process_flag => lv_process_flag,
1718: p_process_msg => lv_process_msg
1719: );

Line 1721: IF lv_process_flag = jai_constants.unexpected_error THEN

1717: p_process_flag => lv_process_flag,
1718: p_process_msg => lv_process_msg
1719: );
1720:
1721: IF lv_process_flag = jai_constants.unexpected_error THEN
1722: errormsg:='Error from jai_inv_items_pkg.jai_get_attrib: Error:'||lv_process_msg;
1723: RAISE_APPLICATION_ERROR( -20099, 'Error from jai_inv_items_pkg.jai_get_attrib: Error:'||lv_process_msg);
1724: END IF;
1725:

Line 1727: lv_vat_recoverable_for_item := nvl(lv_vat_recoverable_for_item, jai_constants.yes); -- CHK

1723: RAISE_APPLICATION_ERROR( -20099, 'Error from jai_inv_items_pkg.jai_get_attrib: Error:'||lv_process_msg);
1724: END IF;
1725:
1726: -- Default value for following variable is set as YES
1727: lv_vat_recoverable_for_item := nvl(lv_vat_recoverable_for_item, jai_constants.yes); -- CHK
1728: /* End, Vijay Shankar for Bug#4250236(4245089) */
1729:
1730: IF v_rcv_uom_code <> v_po_uom_code THEN
1731:

Line 1869: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,

1865:
1866: IF v_item_modvat_flag = 'N' AND
1867: v_item_trading_flag = 'N' AND
1868: upper(lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1869: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
1870: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/*Bug 5989740 bduvarag*/
1871: THEN
1872: v_tax_modvat_flag := 'N';
1873:

Line 1870: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/Bug 5989740 bduvarag/

1866: IF v_item_modvat_flag = 'N' AND
1867: v_item_trading_flag = 'N' AND
1868: upper(lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1869: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
1870: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/*Bug 5989740 bduvarag*/
1871: THEN
1872: v_tax_modvat_flag := 'N';
1873:
1874: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */

Line 1875: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes

1871: THEN
1872: v_tax_modvat_flag := 'N';
1873:
1874: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1875: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
1876: AND lines_rec.regime_code = jai_constants.vat_regime
1877: THEN
1878: v_tax_modvat_flag := jai_constants.no;
1879:

Line 1876: AND lines_rec.regime_code = jai_constants.vat_regime

1872: v_tax_modvat_flag := 'N';
1873:
1874: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1875: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
1876: AND lines_rec.regime_code = jai_constants.vat_regime
1877: THEN
1878: v_tax_modvat_flag := jai_constants.no;
1879:
1880: ELSIF lines_rec.modcp > 0 THEN

Line 1878: v_tax_modvat_flag := jai_constants.no;

1874: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1875: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
1876: AND lines_rec.regime_code = jai_constants.vat_regime
1877: THEN
1878: v_tax_modvat_flag := jai_constants.no;
1879:
1880: ELSIF lines_rec.modcp > 0 THEN
1881: v_tax_modvat_flag := 'Y';
1882: END IF;

Line 1906: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_Exc_edu_cess,

1902: /* Added by LGOPALSA. Bug 4210102
1903: * Added CVD, Excise and Customs edcuation cess */
1904:
1905: IF upper(lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
1906: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_Exc_edu_cess,
1907: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_Edu_cess,
1908: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/*Bug5989740 bduvarag*/
1909: THEN
1910: v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(lines_rec.duty, 0) / 100;

Line 1907: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_Edu_cess,

1903: * Added CVD, Excise and Customs edcuation cess */
1904:
1905: IF upper(lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
1906: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_Exc_edu_cess,
1907: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_Edu_cess,
1908: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/*Bug5989740 bduvarag*/
1909: THEN
1910: v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(lines_rec.duty, 0) / 100;
1911: ELSE

Line 1908: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/Bug5989740 bduvarag/

1904:
1905: IF upper(lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
1906: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_Exc_edu_cess,
1907: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_Edu_cess,
1908: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/*Bug5989740 bduvarag*/
1909: THEN
1910: v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(lines_rec.duty, 0) / 100;
1911: ELSE
1912: v_claimable_amount := 0;

Line 2284: and po_lines_rec.regime_code <> jai_constants.vat_regime

2280: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value,v_price_override);
2281: end if;
2282:
2283: If p_source_document_code = 'INVENTORY'/*rchandan - 6030615..start*/
2284: and po_lines_rec.regime_code <> jai_constants.vat_regime
2285: and upper(po_lines_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE')
2286: THEN
2287: v_price_override := r_jai_mtl_Trxs.selling_price;
2288: END IF;

Line 2290: IF p_source_document_code = 'INVENTORY' AND po_lines_rec.regime_code = jai_constants.vat_regime THEN

2286: THEN
2287: v_price_override := r_jai_mtl_Trxs.selling_price;
2288: END IF;
2289: -- bug 6488829 uncommented the if condition */
2290: IF p_source_document_code = 'INVENTORY' AND po_lines_rec.regime_code = jai_constants.vat_regime THEN
2291: v_precedence_0 := v_price_override;
2292: ELSE
2293: ln_vat_assess_value:=ln_vat_assess_value*v_po_quantity;
2294: v_assessable_value:=v_assessable_value*v_po_quantity;

Line 2365: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,

2361: end_date_tab(row_count) := 0;
2362: END IF;
2363:
2364: IF upper(po_lines_rec.tax_type) IN('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
2365: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2366: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)
2367: THEN
2368: tax_type_tab(row_count) := 1;
2369: ELSIF po_lines_rec.regime_code=jai_constants.vat_regime

Line 2366: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)

2362: END IF;
2363:
2364: IF upper(po_lines_rec.tax_type) IN('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
2365: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2366: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)
2367: THEN
2368: tax_type_tab(row_count) := 1;
2369: ELSIF po_lines_rec.regime_code=jai_constants.vat_regime
2370: THEN

Line 2369: ELSIF po_lines_rec.regime_code=jai_constants.vat_regime

2365: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2366: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)
2367: THEN
2368: tax_type_tab(row_count) := 1;
2369: ELSIF po_lines_rec.regime_code=jai_constants.vat_regime
2370: THEN
2371: tax_type_tab(row_count) := 4;
2372: ELSE
2373: tax_type_tab(row_count) := 0;

Line 2380: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,

2376:
2377: IF v_item_modvat_flag = 'N' AND
2378: v_item_trading_flag = 'N' AND
2379: upper(po_lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
2380: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2381: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/*bug5989740 bduvarag*/
2382: THEN
2383: v_tax_modvat_flag := 'N';
2384: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */

Line 2381: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/bug5989740 bduvarag/

2377: IF v_item_modvat_flag = 'N' AND
2378: v_item_trading_flag = 'N' AND
2379: upper(po_lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
2380: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2381: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/*bug5989740 bduvarag*/
2382: THEN
2383: v_tax_modvat_flag := 'N';
2384: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2385: /*Commented for Bug 4644524 bduvarag*/

Line 2386: -- ELSIF lv_vat_recoverable_for_item <> jai_constants.yes

2382: THEN
2383: v_tax_modvat_flag := 'N';
2384: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2385: /*Commented for Bug 4644524 bduvarag*/
2386: -- ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
2387: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)
2388: AND po_lines_rec.regime_code = jai_constants.vat_regime
2389: THEN
2390: v_tax_modvat_flag := jai_constants.no;

Line 2387: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)

2383: v_tax_modvat_flag := 'N';
2384: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2385: /*Commented for Bug 4644524 bduvarag*/
2386: -- ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
2387: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)
2388: AND po_lines_rec.regime_code = jai_constants.vat_regime
2389: THEN
2390: v_tax_modvat_flag := jai_constants.no;
2391:

Line 2388: AND po_lines_rec.regime_code = jai_constants.vat_regime

2384: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2385: /*Commented for Bug 4644524 bduvarag*/
2386: -- ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
2387: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)
2388: AND po_lines_rec.regime_code = jai_constants.vat_regime
2389: THEN
2390: v_tax_modvat_flag := jai_constants.no;
2391:
2392: ELSE

Line 2390: v_tax_modvat_flag := jai_constants.no;

2386: -- ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
2387: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)
2388: AND po_lines_rec.regime_code = jai_constants.vat_regime
2389: THEN
2390: v_tax_modvat_flag := jai_constants.no;
2391:
2392: ELSE
2393: v_tax_modvat_flag := po_lines_rec.modvat_flag;
2394: END IF;

Line 2877: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,

2873: v_cor_amount := nvl(tax_amt_tab(i), 0);
2874: /* Added by LGOPLASA. Bug 4210102.
2875: * Added CVD, Excise and customs education cess */
2876: IF upper(po_lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
2877: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2878: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,
2879: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/*Bug5904736 bduvarag*/ THEN
2880: -- v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(lines_rec.duty, 0) / 100;
2881: -- above line commented by Aparajita for bug#2929171

Line 2878: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,

2874: /* Added by LGOPLASA. Bug 4210102.
2875: * Added CVD, Excise and customs education cess */
2876: IF upper(po_lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
2877: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2878: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,
2879: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/*Bug5904736 bduvarag*/ THEN
2880: -- v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(lines_rec.duty, 0) / 100;
2881: -- above line commented by Aparajita for bug#2929171
2882: v_claimable_amount := NVL(v_cor_amount, 0) * NVL(po_lines_rec.duty, 0) / 100;

Line 2879: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/Bug5904736 bduvarag/ THEN

2875: * Added CVD, Excise and customs education cess */
2876: IF upper(po_lines_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
2877: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
2878: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,
2879: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess)/*Bug5904736 bduvarag*/ THEN
2880: -- v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(lines_rec.duty, 0) / 100;
2881: -- above line commented by Aparajita for bug#2929171
2882: v_claimable_amount := NVL(v_cor_amount, 0) * NVL(po_lines_rec.duty, 0) / 100;
2883: ELSE

Line 3169: 'CVD', JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/Bug5989740 bduvarag/

3165:
3166: -- Start of addition by Srihari on 30-NOV-99
3167:
3168: IF v_item_modvat_flag = 'N' AND upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE',
3169: 'CVD', JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/*Bug5989740 bduvarag*/
3170: THEN
3171: v_tax_modvat_flag := 'N';
3172: -- End of addition by Srihari on 30-NOV-99
3173:

Line 3175: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes

3171: v_tax_modvat_flag := 'N';
3172: -- End of addition by Srihari on 30-NOV-99
3173:
3174: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
3175: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
3176: AND tax_rec.regime_code = jai_constants.vat_regime
3177: THEN
3178: v_tax_modvat_flag := jai_constants.no;
3179:

Line 3176: AND tax_rec.regime_code = jai_constants.vat_regime

3172: -- End of addition by Srihari on 30-NOV-99
3173:
3174: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
3175: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
3176: AND tax_rec.regime_code = jai_constants.vat_regime
3177: THEN
3178: v_tax_modvat_flag := jai_constants.no;
3179:
3180: ELSIF tax_rec.mod_cr_percentage > 0 THEN

Line 3178: v_tax_modvat_flag := jai_constants.no;

3174: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
3175: ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
3176: AND tax_rec.regime_code = jai_constants.vat_regime
3177: THEN
3178: v_tax_modvat_flag := jai_constants.no;
3179:
3180: ELSIF tax_rec.mod_cr_percentage > 0 THEN
3181: v_tax_modvat_flag := 'Y';
3182: ELSE

Line 3196: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,

3192: /* Added by LGOPALSa. Bug 4210102.
3193: * ADded Excise, Customs and CVD education cess */
3194:
3195: IF upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
3196: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
3197: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,
3198: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess/*Bug5989740 bduvarag*/
3199: )
3200: THEN

Line 3197: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,

3193: * ADded Excise, Customs and CVD education cess */
3194:
3195: IF upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
3196: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
3197: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,
3198: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess/*Bug5989740 bduvarag*/
3199: )
3200: THEN
3201: v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(tax_rec.duty, 0) / 100;

Line 3198: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess/Bug5989740 bduvarag/

3194:
3195: IF upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CUSTOMS', 'CVD',
3196: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess,
3197: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess,
3198: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess/*Bug5989740 bduvarag*/
3199: )
3200: THEN
3201: v_claimable_amount := NVL(v_cor_amount * v_conv_factor, 0) * NVL(tax_rec.duty, 0) / 100;
3202: ELSE

Line 3355: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/Bug5989740 bduvarag/

3351: AND jrtl.tax_id = jtc.tax_id)
3352: LOOP
3353:
3354: if upper(exc_rec.tax_type) IN ('EXCISE', 'CVD', 'ADDL. EXCISE', 'OTHER EXCISE',
3355: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,jai_constants.tax_type_exc_edu_cess, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess)/*Bug5989740 bduvarag*/
3356: then
3357: v_chk_excise := NVL(v_chk_excise, 0) + (exc_rec.tax_amount * exc_rec.mod_cr_percentage / 100);
3358:
3359: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */

Line 3360: elsif exc_rec.regime_code = jai_constants.vat_regime then

3356: then
3357: v_chk_excise := NVL(v_chk_excise, 0) + (exc_rec.tax_amount * exc_rec.mod_cr_percentage / 100);
3358:
3359: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
3360: elsif exc_rec.regime_code = jai_constants.vat_regime then
3361: ln_chk_vat := nvl(ln_chk_vat, 0) + (exc_rec.tax_amount * exc_rec.mod_cr_percentage / 100);
3362: end if;
3363:
3364: END LOOP;

Line 3373: open c_rgm_setup_for_orgn_loc(jai_constants.vat_regime, jai_constants.orgn_type_io,

3369: IF v_rg_location_id = 0 THEN
3370: v_rg_location_id := null;
3371: END IF;
3372:
3373: open c_rgm_setup_for_orgn_loc(jai_constants.vat_regime, jai_constants.orgn_type_io,
3374: p_organization_id, v_rg_location_id);
3375: fetch c_rgm_setup_for_orgn_loc into ln_vat_setup_chk;
3376: close c_rgm_setup_for_orgn_loc;
3377:

Line 3414: open c_rcv_rgm_dtl(jai_constants.vat_regime, p_shipment_line_id);

3410: v_manufacturing := i.manufacturing;
3411: EXIT WHEN v_manufacturing IS NOT NULL;
3412: END LOOP;
3413:
3414: open c_rcv_rgm_dtl(jai_constants.vat_regime, p_shipment_line_id);
3415: fetch c_rcv_rgm_dtl into r_rcv_rgm_dtl;
3416: close c_rcv_rgm_dtl;
3417:
3418: /* Bug 4516678. Added by Lakshmi Gopalsami */

Line 3472: /* IF lv_vat_recoverable_for_item = jai_constants.yes

3468: );
3469:
3470: -- following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl.
3471: -- Before VAT is fully Claimed if RTV is being done, then we should error out the transaction
3472: /* IF lv_vat_recoverable_for_item = jai_constants.yes
3473: AND NVL(ln_chk_vat, 0) <> 0
3474: AND r_rcv_rgm_dtl.process_status_flag <> 'U' -- Not Unclaimed
3475: AND r_rcv_rgm_dtl.invoice_no IS NULL -- if this is given it means then VAT is eligible for claim
3476: THEN