[Home] [Help]
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
276: Uom_code JAI_PO_TAXES.UOM%TYPE,
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
280: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
281: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
282: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
283: );
276: Uom_code JAI_PO_TAXES.UOM%TYPE,
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
280: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
281: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
282: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
283: );
284:
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
280: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
281: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
282: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
283: );
284:
285:
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
280: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
281: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
282: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
283: );
284:
285:
286: -- START, Vijay Shankar for Bug# 3190782
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
313: Uom_code JAI_PO_TAXES.UOM%TYPE,
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
315: Curr JAI_PO_TAXES.CURRENCY%TYPE,
316: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
317: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
318: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
319: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
320: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
313: Uom_code JAI_PO_TAXES.UOM%TYPE,
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
315: Curr JAI_PO_TAXES.CURRENCY%TYPE,
316: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
317: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
318: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
319: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
320: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
321: );
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
315: Curr JAI_PO_TAXES.CURRENCY%TYPE,
316: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
317: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
318: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
319: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
320: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
321: );
322:
332: lv_process_message VARCHAR2(2000);
333: --=====================================================
334:
335: Cursor req_adhoc_tax_amt(taxid number) is
336: select A.tax_amount from JAI_PO_REQ_LINE_TAXES A, JAI_CMN_TAXES_ALL B
337: where A.tax_id = taxid
338: AND requisition_line_id in(select requisition_line_id
339: from po_req_distributions_all
340: where distribution_id in (select req_distribution_id
497: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
498: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
499: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
500: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
501: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
502: WHERE Po_Line_Id = p_line_id
503: AND Line_Location_Id = p_line_loc_id
504: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
505: AND A.Tax_Id = B.Tax_Id
545: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
546: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
547: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
548: FROM JAI_PO_REQ_LINE_TAXES A,
549: JAI_CMN_TAXES_ALL B,
550: jai_regime_tax_types_v aa
551: WHERE requisition_line_Id = p_line_id
552: AND A.Tax_Id = B.Tax_Id
553: AND aa.tax_type(+) = b.tax_type
581: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
582: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
583: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
584: FROM jai_rcv_line_taxes A,
585: JAI_CMN_TAXES_ALL B,
586: jai_regime_tax_types_v aa
587: WHERE shipment_line_id = p_line_id /* shipment line id */
588: AND A.Tax_Id = B.Tax_Id
589: AND aa.tax_type(+) = b.tax_type
619: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
620: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
621: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
622: FROM Jai_cmn_document_Taxes A,
623: JAI_CMN_TAXES_ALL B,
624: jai_regime_tax_types_v aa
625: WHERE source_doc_line_id = p_line_id /* source doc line id */
626: AND A.Tax_Id = B.Tax_Id
627: AND aa.tax_type(+) = b.tax_type
1348: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1349: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1350: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1351: , pha.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
1352: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
1353: , po_headers_all pha --Added by Kevin Cheng
1354: WHERE Po_Line_Id = p_line_id
1355: AND Line_Location_Id = p_line_loc_id
1356: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1390: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1391: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1392: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1393: FROM JAI_PO_REQ_LINE_TAXES A,
1394: JAI_CMN_TAXES_ALL B,
1395: jai_regime_tax_types_v aa
1396: WHERE requisition_line_Id = p_line_id
1397: AND A.Tax_Id = B.Tax_Id
1398: AND aa.tax_type(+) = b.tax_type
1418: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1419: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1420: , rsh.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
1421: FROM jai_rcv_line_taxes A,
1422: JAI_CMN_TAXES_ALL B,
1423: jai_regime_tax_types_v aa,
1424: RCV_SHIPMENT_HEADERS rsh --Added by Kevin Cheng
1425: WHERE shipment_line_id = p_line_id /* shipment line id */
1426: AND A.Tax_Id = B.Tax_Id
1449: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1450: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
1451: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1452: FROM Jai_cmn_document_Taxes A,
1453: JAI_CMN_TAXES_ALL B,
1454: jai_regime_tax_types_v aa
1455: WHERE source_doc_line_id = p_line_id \* source doc line id *\
1456: AND A.Tax_Id = B.Tax_Id
1457: AND aa.tax_type(+) = b.tax_type
2887: ---------------------------------------------------
2888: 'TDS', 2, 0
2889: )
2890: ) tax_type_val
2891: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
2892: WHERE requisition_line_id = p_line_id
2893: AND a.Tax_Id = b.Tax_Id
2894: AND aa.tax_type(+) = b.tax_type
2895: order by 1/*2*/;--Modified by Kevin Cheng for inclusive tax Dec 17, 2007
2936: B.End_Date Valid_Date,
2937: B.rounding_factor rnd_factor,
2938: B.adhoc_flag adhoc_flag
2939: ,b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 17, 2007
2940: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
2941: WHERE Po_Line_Id = p_po_line_id
2942: --AND nvl(line_location_id,-999) = p_line_location_id
2943: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2944: AND A.Tax_Id = B.Tax_Id
3013: B.rounding_factor rnd_factor,
3014: B.adhoc_flag adhoc_flag
3015: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3016: FROM Jai_cmn_document_Taxes A,
3017: JAI_CMN_TAXES_ALL B,
3018: jai_regime_tax_types_v aa
3019: WHERE source_doc_line_id = cp_source_doc_line_id
3020: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011
3021: AND A.Tax_Id = B.Tax_Id
3054: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1, --,jai_constants.tax_type_cvd_edu_cess, 1,
3055: 'TDS', 2, 0
3056: )
3057: ) tax_type_val
3058: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3059: WHERE requisition_line_id = p_line_id
3060: AND a.Tax_Id = b.Tax_Id
3061: AND aa.tax_type(+) = b.tax_type
3062: order by 2;
3095: B.End_Date Valid_Date,
3096: B.rounding_factor rnd_factor,
3097: B.adhoc_flag adhoc_flag
3098: , pha.vendor_id hdr_vendor_id, a.vendor_id tax_vendor_id --Added by Kevin Cheng
3099: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3100: , po_headers_all pha --Added by Kevin Cheng
3101: WHERE Po_Line_Id = p_po_line_id
3102: --AND nvl(line_location_id,-999) = p_line_location_id
3103: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3138: B.End_Date Valid_Date,
3139: B.rounding_factor rnd_factor,
3140: B.adhoc_flag adhoc_flag
3141: FROM Jai_cmn_document_Taxes A,
3142: JAI_CMN_TAXES_ALL B,
3143: jai_regime_tax_types_v aa
3144: WHERE source_doc_line_id = cp_source_doc_line_id
3145: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011
3146: AND A.Tax_Id = B.Tax_Id
5538:
5539: --Added by Nagaraj.s for Bug2953445..
5540: CURSOR c_check_adhoc_flag(p_tax_id number) IS
5541: select nvl(adhoc_flag,'N')
5542: from JAI_CMN_TAXES_ALL
5543: where tax_id = p_tax_id;
5544:
5545: --Added by Ravi for vat assessable vlue
5546: CURSOR cur_vendor
5557:
5558: lv_item_id po_lines_all.item_id%type;
5559:
5560: vendor_rec cur_vendor%ROWTYPE;
5561: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --Nagaraj.s for Bug2953445.
5562: v_tax_amount NUMBER;--Nagaraj.s for Bug2953445.
5563:
5564: ------------------------------>
5565:
6723: ORDER BY Tax_Line_No;
6724:
6725: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS
6726: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id,adhoc_flag --kundan kumar for forward porting to R12
6727: FROM JAI_CMN_TAXES_ALL
6728: WHERE Tax_Id = taxid;
6729:
6730: CURSOR Fetch_Sum_Cur( Lfid IN NUMBER ) IS
6731: SELECT SUM( NVL( Tax_Amount, 0 ) )
7457: v_tax_target NUMBER;
7458: --Start Added by kundan kumar for forward porting to R12
7459: CURSOR cur_taxes_adhoc(cp_tax_id number) IS --rchandan for bug#4591242
7460: SELECT adhoc_flag
7461: FROM JAI_CMN_TAXES_ALL
7462: WHERE tax_id = cp_tax_id;
7463:
7464: lv_adhoc_flag varchar2(1); --rchandan for bug#4591242
7465: --End kundan kumar