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

Line 543: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/

539: a.precedence_5 p_5, a.precedence_6 p_6, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
540: a.precedence_7 p_7, a.precedence_8 p_8,
541: a.precedence_9 p_9, a.precedence_10 p_10,
542: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
543: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
544: /*jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
545: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10*/
546: jai_constants.customs_regime, 8, --Added by Bo Li for Bug#11684111 BOE Ehancement
547: DECODE(UPPER(b.tax_type),

Line 544: /*jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10

540: a.precedence_7 p_7, a.precedence_8 p_8,
541: a.precedence_9 p_9, a.precedence_10 p_10,
542: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
543: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
544: /*jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
545: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10*/
546: jai_constants.customs_regime, 8, --Added by Bo Li for Bug#11684111 BOE Ehancement
547: DECODE(UPPER(b.tax_type),
548: 'EXCISE', 1,

Line 545: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10*/

541: a.precedence_9 p_9, a.precedence_10 p_10,
542: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
543: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
544: /*jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
545: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10*/
546: jai_constants.customs_regime, 8, --Added by Bo Li for Bug#11684111 BOE Ehancement
547: DECODE(UPPER(b.tax_type),
548: 'EXCISE', 1,
549: 'ADDL. EXCISE', 1,

Line 546: jai_constants.customs_regime, 8, --Added by Bo Li for Bug#11684111 BOE Ehancement

542: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
543: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
544: /*jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
545: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10*/
546: jai_constants.customs_regime, 8, --Added by Bo Li for Bug#11684111 BOE Ehancement
547: DECODE(UPPER(b.tax_type),
548: 'EXCISE', 1,
549: 'ADDL. EXCISE', 1,
550: 'OTHER EXCISE', 1,

Line 893: if nvl(p_action, jai_constants.default_taxes) = jai_constants.default_taxes then

889: /** Both driving parameter tax_category_id and threshol_tax_category_id are invalid hence no need to do anything */
890: return;
891: end if;
892:
893: if nvl(p_action, jai_constants.default_taxes) = jai_constants.default_taxes then
894: /** Assign tax defaultation cursor object to refc_tax_cur reference by using. Call to get_tax_cat_taxes_cur will return
895: a reference cursor */
896:
897: if p_threshold_tax_cat_id is not null and p_threshold_tax_cat_id > 0 then

Line 948: elsif p_action = jai_constants.recalculate_taxes then

944: );
945:
946: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Cursor is opened');*/ --commented by bgowrava for bug#5631784
947:
948: elsif p_action = jai_constants.recalculate_taxes then
949: /**
950: Following is a dynamic sql string which can be modifed as per requirement
951:
952: The sql has four place holders defined as below

Line 992: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/

988: , a.tax_amount
989: , b.tax_amount qty_rate /*Added b.tax_amount qty_rate by murtuza for bug 14675629*/
990: , b.uom_code
991: , b.end_date valid_date
992: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
993: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
994: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
995: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
996: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1

Line 993: /'''||jai_constants.cgst_regime||''', 7, //* Added by Jia for GST Bug#10043656 on 2010/09/10 */

989: , b.tax_amount qty_rate /*Added b.tax_amount qty_rate by murtuza for bug 14675629*/
990: , b.uom_code
991: , b.end_date valid_date
992: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
993: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
994: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
995: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
996: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
997: , ''ADDL. EXCISE'', 1

Line 994: /'''||jai_constants.sgst_regime||''', 7, //* Added by Jia for GST Bug#10043656 on 2010/09/10 */

990: , b.uom_code
991: , b.end_date valid_date
992: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
993: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
994: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
995: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
996: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
997: , ''ADDL. EXCISE'', 1
998: , ''OTHER EXCISE'', 1

Line 995: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */

991: , b.end_date valid_date
992: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
993: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
994: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
995: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
996: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
997: , ''ADDL. EXCISE'', 1
998: , ''OTHER EXCISE'', 1
999: , ''TDS'' , 2

Line 1001: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /bduvarag for the bug#5989740/ --modified by walton for inclusive tax

997: , ''ADDL. EXCISE'', 1
998: , ''OTHER EXCISE'', 1
999: , ''TDS'' , 2
1000: , ''EXCISE_EDUCATION_CESS'',6 --modified by walton for inclusive tax
1001: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
1002: , ''CVD_EDUCATION_CESS'' ,6 --modified by walton for inclusive tax
1003: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
1004: , 0
1005: )

Line 1003: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /bduvarag for the bug#5989740/ --modified by walton for inclusive tax

999: , ''TDS'' , 2
1000: , ''EXCISE_EDUCATION_CESS'',6 --modified by walton for inclusive tax
1001: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
1002: , ''CVD_EDUCATION_CESS'' ,6 --modified by walton for inclusive tax
1003: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
1004: , 0
1005: )
1006: ) tax_type_val
1007: , b.mod_cr_percentage

Line 1047: if upper(p_source_trx_type) = jai_constants.source_ttype_delivery then

1043: , '$$ADDITIONAL_ORDER_BY$$'
1044: , ''
1045: );
1046:
1047: if upper(p_source_trx_type) = jai_constants.source_ttype_delivery then
1048:
1049: /** replace the correct tax source table */
1050: lv_recalculation_sql :=
1051: replace ( lv_recalculation_sql

Line 1061: elsif upper(p_source_trx_type) = jai_constants.bill_only_invoice then

1057: replace ( lv_recalculation_sql
1058: , '$$SOURCE_TABLE_FILTER$$'
1059: , 'a.delivery_detail_id = ' || p_line_id
1060: );
1061: elsif upper(p_source_trx_type) = jai_constants.bill_only_invoice then
1062:
1063: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
1064: lv_recalculation_sql :=
1065: replace ( lv_recalculation_sql

Line 1084: elsif upper(p_source_trx_type) = jai_constants.PA_DRAFT_INVOICE then

1080:
1081: -- Date 24-Apr-2007 Added by SACSETHI for bug 6012570 (5876390)
1082: -- in This , Recalculation will be happen in Draft invoice
1083: ---------------------------------------------------------
1084: elsif upper(p_source_trx_type) = jai_constants.PA_DRAFT_INVOICE then
1085:
1086: lv_recalculation_sql :=
1087: replace ( lv_recalculation_sql
1088: , 'a.tax_amount'

Line 1101: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id || ' and SOURCE_DOC_TYPE ='''|| jai_constants.PA_DRAFT_INVOICE || ''''

1097: /** replace join condition */
1098: lv_recalculation_sql :=
1099: replace ( lv_recalculation_sql
1100: , '$$SOURCE_TABLE_FILTER$$'
1101: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id || ' and SOURCE_DOC_TYPE ='''|| jai_constants.PA_DRAFT_INVOICE || ''''
1102: );
1103:
1104: -- Added by Jason Liu for standalone invoice on 2007/08/23
1105: ----------------------------------------------------------------------

Line 1107: jai_constants.G_AP_STANDALONE_INVOICE

1103:
1104: -- Added by Jason Liu for standalone invoice on 2007/08/23
1105: ----------------------------------------------------------------------
1106: ELSIF upper(p_source_trx_type) =
1107: jai_constants.G_AP_STANDALONE_INVOICE
1108: THEN
1109:
1110: lv_recalculation_sql :=
1111: REPLACE( lv_recalculation_sql

Line 1127: jai_constants.G_AP_STANDALONE_INVOICE || ''''

1123: REPLACE( lv_recalculation_sql
1124: , '$$SOURCE_TABLE_FILTER$$'
1125: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id ||
1126: ' and SOURCE_DOC_TYPE ='''||
1127: jai_constants.G_AP_STANDALONE_INVOICE || ''''
1128: );
1129:
1130: -- Added by Zhiwei Hou for Bug#13359892 DTC enhancement on 2011/11/28 begin
1131: ----------------------------------------------------------------------

Line 1277: IF p_action = jai_constants.recalculate_taxes AND --recalculate_taxes

1273: qty_rate_tab(row_count) := rec.qty_rate; /*Added by mmurtuza for bug 14675629*/
1274: /*End of bug 4691616 */
1275: -- tax_amt_tab(row_count) := 0;
1276: /*added for bug#6498072, start*/
1277: IF p_action = jai_constants.recalculate_taxes AND --recalculate_taxes
1278: NVL(rec.adhoc_flag,'N') = 'Y' --adhoc_flag='Y'
1279: THEN
1280: tax_amt_tab(row_count) := nvl(rec.tax_amount,0) ;
1281: ELSE

Line 1318: and p_source_trx_type = jai_constants.ar_cash

1314: IF NVL(v_conversion_rate, 0) <= 0 THEN
1315:
1316: /* for cash receipt there will be no lines. sacsethi for 6012570 (5876390) */
1317: if (p_uom_code is null and p_inventory_item_id is null )
1318: and p_source_trx_type = jai_constants.ar_cash
1319: then --
1320: v_conversion_rate := 1;
1321:
1322: /*

Line 1327: and p_source_trx_type in (jai_constants.pa_draft_invoice

1323: Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
1324: in This , Recalculation will be happen in Draft invoice
1325: */
1326: elsif (p_uom_code is null and p_inventory_item_id is null )
1327: and p_source_trx_type in (jai_constants.pa_draft_invoice
1328: ,jai_constants.G_AP_STANDALONE_INVOICE)
1329: then
1330: v_conversion_rate := 0;
1331:

Line 1328: ,jai_constants.G_AP_STANDALONE_INVOICE)

1324: in This , Recalculation will be happen in Draft invoice
1325: */
1326: elsif (p_uom_code is null and p_inventory_item_id is null )
1327: and p_source_trx_type in (jai_constants.pa_draft_invoice
1328: ,jai_constants.G_AP_STANDALONE_INVOICE)
1329: then
1330: v_conversion_rate := 0;
1331:
1332: else

Line 1340: IF p_action = jai_constants.recalculate_taxes THEN

1336: END IF;
1337: END IF;
1338: --tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity; -- cbabu for EnhancementBug# 2427465, compact code
1339: /*added for bug#6498072, start*/
1340: IF p_action = jai_constants.recalculate_taxes THEN
1341: /*tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) ;*/ --commented out by walton for inclusive tax
1342: lt_tax_amt_non_rate_tab(rec.lno):=NVL(rec.tax_amount * v_conversion_rate, 0); --added by walton for inclusive tax
1343: ELSE
1344: /*tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity ;*/ --commented out by walton for inclusive tax

Line 1366: IF p_action = jai_constants.default_taxes

1362: END IF;
1363: row_count := row_count + 1;
1364:
1365: --added for bug#9214366, start
1366: IF p_action = jai_constants.default_taxes
1367: and p_thhold_cat_base_tax_typ = jai_constants.tax_type_tcs
1368: THEN
1369: tax_amt_tab(rec.lno) := 0;
1370: END IF;

Line 1367: and p_thhold_cat_base_tax_typ = jai_constants.tax_type_tcs

1363: row_count := row_count + 1;
1364:
1365: --added for bug#9214366, start
1366: IF p_action = jai_constants.default_taxes
1367: and p_thhold_cat_base_tax_typ = jai_constants.tax_type_tcs
1368: THEN
1369: tax_amt_tab(rec.lno) := 0;
1370: END IF;
1371: --bug#9214366, end

Line 2639: if nvl(p_action, jai_constants.default_taxes) = jai_constants.default_taxes then

2635: /** Both driving parameter tax_category_id and threshol_tax_category_id are invalid hence no need to do anything */
2636: return;
2637: end if;
2638:
2639: if nvl(p_action, jai_constants.default_taxes) = jai_constants.default_taxes then
2640: /** Assign tax defaultation cursor object to refc_tax_cur reference by using. Call to get_tax_cat_taxes_cur will return
2641: a reference cursor */
2642:
2643: if p_threshold_tax_cat_id is not null and p_threshold_tax_cat_id > 0 then

Line 2689: elsif p_action = jai_constants.recalculate_taxes then

2685: );
2686:
2687: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Cursor is opened');*/ --commented by bgowrava for bug#5631784
2688:
2689: elsif p_action = jai_constants.recalculate_taxes then
2690: /**
2691: Following is a dynamic sql string which can be modifed as per requirement
2692:
2693: The sql has four place holders defined as below

Line 2732: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/

2728: , a.tax_rate
2729: , a.tax_amount
2730: , b.uom_code
2731: , b.end_date valid_date
2732: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
2733: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2734: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2735: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
2736: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1

Line 2733: /'''||jai_constants.cgst_regime||''', 7, //* Added by Jia for GST Bug#10043656 on 2010/09/10 */

2729: , a.tax_amount
2730: , b.uom_code
2731: , b.end_date valid_date
2732: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
2733: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2734: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2735: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
2736: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
2737: , ''ADDL. EXCISE'', 1

Line 2734: /'''||jai_constants.sgst_regime||''', 7, //* Added by Jia for GST Bug#10043656 on 2010/09/10 */

2730: , b.uom_code
2731: , b.end_date valid_date
2732: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
2733: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2734: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2735: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
2736: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
2737: , ''ADDL. EXCISE'', 1
2738: , ''OTHER EXCISE'', 1

Line 2735: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */

2731: , b.end_date valid_date
2732: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
2733: /*'''||jai_constants.cgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2734: /*'''||jai_constants.sgst_regime||''', 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
2735: '''||jai_constants.customs_regime||''', 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
2736: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
2737: , ''ADDL. EXCISE'', 1
2738: , ''OTHER EXCISE'', 1
2739: , ''TDS'' , 2

Line 2741: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 1 /bduvarag for the bug#5989740/

2737: , ''ADDL. EXCISE'', 1
2738: , ''OTHER EXCISE'', 1
2739: , ''TDS'' , 2
2740: , ''EXCISE_EDUCATION_CESS'',1
2741: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
2742: , ''CVD_EDUCATION_CESS'' ,1
2743: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
2744: , 0
2745: )

Line 2743: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 1 /bduvarag for the bug#5989740/

2739: , ''TDS'' , 2
2740: , ''EXCISE_EDUCATION_CESS'',1
2741: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
2742: , ''CVD_EDUCATION_CESS'' ,1
2743: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
2744: , 0
2745: )
2746: ) tax_type_val
2747: , b.mod_cr_percentage

Line 2786: if upper(p_source_trx_type) = jai_constants.source_ttype_delivery then

2782: , '$$ADDITIONAL_ORDER_BY$$'
2783: , ''
2784: );
2785:
2786: if upper(p_source_trx_type) = jai_constants.source_ttype_delivery then
2787:
2788: /** replace the correct tax source table */
2789: lv_recalculation_sql :=
2790: replace ( lv_recalculation_sql

Line 2800: elsif upper(p_source_trx_type) = jai_constants.bill_only_invoice then

2796: replace ( lv_recalculation_sql
2797: , '$$SOURCE_TABLE_FILTER$$'
2798: , 'a.delivery_detail_id = ' || p_line_id
2799: );
2800: elsif upper(p_source_trx_type) = jai_constants.bill_only_invoice then
2801:
2802: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
2803: lv_recalculation_sql :=
2804: replace ( lv_recalculation_sql

Line 2823: elsif upper(p_source_trx_type) = jai_constants.PA_DRAFT_INVOICE then

2819:
2820: -- Date 24-Apr-2007 Added by SACSETHI for bug 6012570 (5876390)
2821: -- in This , Recalculation will be happen in Draft invoice
2822: ---------------------------------------------------------
2823: elsif upper(p_source_trx_type) = jai_constants.PA_DRAFT_INVOICE then
2824:
2825: lv_recalculation_sql :=
2826: replace ( lv_recalculation_sql
2827: , 'a.tax_amount'

Line 2840: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id || ' and SOURCE_DOC_TYPE ='''|| jai_constants.PA_DRAFT_INVOICE || ''''

2836: /** replace join condition */
2837: lv_recalculation_sql :=
2838: replace ( lv_recalculation_sql
2839: , '$$SOURCE_TABLE_FILTER$$'
2840: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id || ' and SOURCE_DOC_TYPE ='''|| jai_constants.PA_DRAFT_INVOICE || ''''
2841: );
2842:
2843: -- Added by Jason Liu for standalone invoice on 2007/08/23
2844: ----------------------------------------------------------------------

Line 2846: jai_constants.G_AP_STANDALONE_INVOICE

2842:
2843: -- Added by Jason Liu for standalone invoice on 2007/08/23
2844: ----------------------------------------------------------------------
2845: ELSIF upper(p_source_trx_type) =
2846: jai_constants.G_AP_STANDALONE_INVOICE
2847: THEN
2848:
2849: lv_recalculation_sql :=
2850: REPLACE( lv_recalculation_sql

Line 2866: jai_constants.G_AP_STANDALONE_INVOICE || ''''

2862: REPLACE( lv_recalculation_sql
2863: , '$$SOURCE_TABLE_FILTER$$'
2864: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id ||
2865: ' and SOURCE_DOC_TYPE ='''||
2866: jai_constants.G_AP_STANDALONE_INVOICE || ''''
2867: );
2868: ----------------------------------------------------------------------
2869: end if; /*pv_tax_source_table*/
2870:

Line 2948: /*IF p_action = jai_constants.recalculate_taxes AND --recalculate_taxes

2944: /*End of bug 4691616 */
2945: -- tax_amt_tab(row_count) := 0;
2946: /*added for bug#6498072, start*/
2947: --Comment out by Kevin Cheng
2948: /*IF p_action = jai_constants.recalculate_taxes AND --recalculate_taxes
2949: NVL(rec.adhoc_flag,'N') = 'Y' --adhoc_flag='Y'
2950: THEN
2951: tax_amt_tab(row_count) := nvl(rec.tax_amount,0) ;
2952: ELSE

Line 3096: and p_source_trx_type = jai_constants.ar_cash

3092: IF NVL(v_conversion_rate, 0) <= 0 THEN
3093:
3094: \* for cash receipt there will be no lines. sacsethi for 6012570 (5876390) *\
3095: if (p_uom_code is null and p_inventory_item_id is null )
3096: and p_source_trx_type = jai_constants.ar_cash
3097: then --
3098: v_conversion_rate := 1;
3099:
3100: \*

Line 3105: and p_source_trx_type= jai_constants.pa_draft_invoice

3101: Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
3102: in This , Recalculation will be happen in Draft invoice
3103: *\
3104: elsif (p_uom_code is null and p_inventory_item_id is null )
3105: and p_source_trx_type= jai_constants.pa_draft_invoice
3106: then
3107: v_conversion_rate := 0;
3108:
3109: else

Line 3117: IF p_action = jai_constants.recalculate_taxes THEN

3113: END IF;
3114: END IF;
3115: --tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity; -- cbabu for EnhancementBug# 2427465, compact code
3116: \*added for bug#6498072, start*\
3117: IF p_action = jai_constants.recalculate_taxes THEN
3118: tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) ;
3119: ELSE
3120: tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity ;
3121: END IF ;

Line 3539: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,

3535: ELSIF rec.mod_cr_percentage IS NULL THEN
3536: v_modvat_flag := 'N';
3537: END IF;
3538: -- bug 6436825
3539: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
3540: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
3541: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
3542: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
3543: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,

Line 3540: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,

3536: v_modvat_flag := 'N';
3537: END IF;
3538: -- bug 6436825
3539: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
3540: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
3541: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
3542: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
3543: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
3544: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN

Line 3541: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,

3537: END IF;
3538: -- bug 6436825
3539: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
3540: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
3541: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
3542: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
3543: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
3544: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
3545:

Line 3542: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,

3538: -- bug 6436825
3539: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
3540: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
3541: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
3542: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
3543: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
3544: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
3545:
3546: INSERT INTO jai_cmn_document_taxes(

Line 3543: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,

3539: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
3540: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
3541: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
3542: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
3543: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
3544: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
3545:
3546: INSERT INTO jai_cmn_document_taxes(
3547: DOC_TAX_ID,

Line 3674: IF lv_tax_type IN (jai_constants.tax_type_add_cvd,

3670: END;
3671: ------------------------------
3672: --Add by Qiong Liu for bug#11684111 BOE Ehancement End
3673: -- Add by Wenqiong for bug#12611347 begin
3674: IF lv_tax_type IN (jai_constants.tax_type_add_cvd,
3675: jai_constants.tax_type_customs_edu_cess,
3676: jai_constants.tax_type_sh_customs_edu_cess,
3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,

Line 3675: jai_constants.tax_type_customs_edu_cess,

3671: ------------------------------
3672: --Add by Qiong Liu for bug#11684111 BOE Ehancement End
3673: -- Add by Wenqiong for bug#12611347 begin
3674: IF lv_tax_type IN (jai_constants.tax_type_add_cvd,
3675: jai_constants.tax_type_customs_edu_cess,
3676: jai_constants.tax_type_sh_customs_edu_cess,
3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,

Line 3676: jai_constants.tax_type_sh_customs_edu_cess,

3672: --Add by Qiong Liu for bug#11684111 BOE Ehancement End
3673: -- Add by Wenqiong for bug#12611347 begin
3674: IF lv_tax_type IN (jai_constants.tax_type_add_cvd,
3675: jai_constants.tax_type_customs_edu_cess,
3676: jai_constants.tax_type_sh_customs_edu_cess,
3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,

Line 3677: jai_constants.tax_type_cvd,

3673: -- Add by Wenqiong for bug#12611347 begin
3674: IF lv_tax_type IN (jai_constants.tax_type_add_cvd,
3675: jai_constants.tax_type_customs_edu_cess,
3676: jai_constants.tax_type_sh_customs_edu_cess,
3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,

Line 3678: jai_constants.tax_type_cvd_edu_cess,

3674: IF lv_tax_type IN (jai_constants.tax_type_add_cvd,
3675: jai_constants.tax_type_customs_edu_cess,
3676: jai_constants.tax_type_sh_customs_edu_cess,
3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,

Line 3679: jai_constants.tax_type_sh_cvd_edu_cess,

3675: jai_constants.tax_type_customs_edu_cess,
3676: jai_constants.tax_type_sh_customs_edu_cess,
3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,

Line 3680: jai_constants.tax_type_customs,

3676: jai_constants.tax_type_sh_customs_edu_cess,
3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,

Line 3681: jai_constants.tax_type_boe_surcharge_duty,

3677: jai_constants.tax_type_cvd,
3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,
3685: jai_constants.tax_type_boe_other4,

Line 3682: jai_constants.tax_type_boe_other1,

3678: jai_constants.tax_type_cvd_edu_cess,
3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,
3685: jai_constants.tax_type_boe_other4,
3686: jai_constants.tax_type_boe_other5,

Line 3683: jai_constants.tax_type_boe_other2,

3679: jai_constants.tax_type_sh_cvd_edu_cess,
3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,
3685: jai_constants.tax_type_boe_other4,
3686: jai_constants.tax_type_boe_other5,
3687: jai_constants.tax_type_boe_add_customs) THEN

Line 3684: jai_constants.tax_type_boe_other3,

3680: jai_constants.tax_type_customs,
3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,
3685: jai_constants.tax_type_boe_other4,
3686: jai_constants.tax_type_boe_other5,
3687: jai_constants.tax_type_boe_add_customs) THEN
3688: lv_boe_flag := 'Y';

Line 3685: jai_constants.tax_type_boe_other4,

3681: jai_constants.tax_type_boe_surcharge_duty,
3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,
3685: jai_constants.tax_type_boe_other4,
3686: jai_constants.tax_type_boe_other5,
3687: jai_constants.tax_type_boe_add_customs) THEN
3688: lv_boe_flag := 'Y';
3689: ELSE

Line 3686: jai_constants.tax_type_boe_other5,

3682: jai_constants.tax_type_boe_other1,
3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,
3685: jai_constants.tax_type_boe_other4,
3686: jai_constants.tax_type_boe_other5,
3687: jai_constants.tax_type_boe_add_customs) THEN
3688: lv_boe_flag := 'Y';
3689: ELSE
3690: lv_boe_flag := 'N';

Line 3687: jai_constants.tax_type_boe_add_customs) THEN

3683: jai_constants.tax_type_boe_other2,
3684: jai_constants.tax_type_boe_other3,
3685: jai_constants.tax_type_boe_other4,
3686: jai_constants.tax_type_boe_other5,
3687: jai_constants.tax_type_boe_add_customs) THEN
3688: lv_boe_flag := 'Y';
3689: ELSE
3690: lv_boe_flag := 'N';
3691: END IF;

Line 3995: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

3991: END IF;
3992:
3993: IF v_transaction_name IN ( 'OTHERS', 'QUOTATION', 'BLANKET' ) THEN
3994: IF upper(rec.tax_type) IN ( 'CVD',
3995: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3996: 'CUSTOMS' ,
3997: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
3998: jai_constants.tax_type_cvd_edu_cess ,
3999: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/

Line 3997: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/bduvarag for the bug#5989740/

3993: IF v_transaction_name IN ( 'OTHERS', 'QUOTATION', 'BLANKET' ) THEN
3994: IF upper(rec.tax_type) IN ( 'CVD',
3995: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3996: 'CUSTOMS' ,
3997: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
3998: jai_constants.tax_type_cvd_edu_cess ,
3999: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4000: jai_constants.tax_type_customs_edu_cess
4001: ) THEN

Line 3998: jai_constants.tax_type_cvd_edu_cess ,

3994: IF upper(rec.tax_type) IN ( 'CVD',
3995: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3996: 'CUSTOMS' ,
3997: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
3998: jai_constants.tax_type_cvd_edu_cess ,
3999: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4000: jai_constants.tax_type_customs_edu_cess
4001: ) THEN
4002: v_vendor_id := NULL;

Line 3999: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/bduvarag for the bug#5989740/

3995: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3996: 'CUSTOMS' ,
3997: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
3998: jai_constants.tax_type_cvd_edu_cess ,
3999: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4000: jai_constants.tax_type_customs_edu_cess
4001: ) THEN
4002: v_vendor_id := NULL;
4003: ELSIF UPPER( rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN

Line 4000: jai_constants.tax_type_customs_edu_cess

3996: 'CUSTOMS' ,
3997: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
3998: jai_constants.tax_type_cvd_edu_cess ,
3999: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4000: jai_constants.tax_type_customs_edu_cess
4001: ) THEN
4002: v_vendor_id := NULL;
4003: ELSIF UPPER( rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN
4004: v_vendor_id := p_vendor_id;

Line 4140: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

4136: END IF;
4137: IF rec.tax_type = 'TDS' THEN
4138: v_vendor_id := rec.vendor_id;
4139: ELSIF UPPER(rec.tax_type) IN ('CVD',
4140: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4141: 'CUSTOMS',
4142: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4143: jai_constants.tax_type_cvd_edu_cess ,
4144: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/

Line 4142: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/bduvarag for the bug#5989740/

4138: v_vendor_id := rec.vendor_id;
4139: ELSIF UPPER(rec.tax_type) IN ('CVD',
4140: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4141: 'CUSTOMS',
4142: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4143: jai_constants.tax_type_cvd_edu_cess ,
4144: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4145: jai_constants.tax_type_customs_edu_cess
4146: ) THEN

Line 4143: jai_constants.tax_type_cvd_edu_cess ,

4139: ELSIF UPPER(rec.tax_type) IN ('CVD',
4140: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4141: 'CUSTOMS',
4142: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4143: jai_constants.tax_type_cvd_edu_cess ,
4144: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4145: jai_constants.tax_type_customs_edu_cess
4146: ) THEN
4147: v_vendor_id := NULL;

Line 4144: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/bduvarag for the bug#5989740/

4140: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4141: 'CUSTOMS',
4142: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4143: jai_constants.tax_type_cvd_edu_cess ,
4144: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4145: jai_constants.tax_type_customs_edu_cess
4146: ) THEN
4147: v_vendor_id := NULL;
4148: ELSIF UPPER( rec.tax_type ) LIKE '%EXCISE%' THEN

Line 4145: jai_constants.tax_type_customs_edu_cess

4141: 'CUSTOMS',
4142: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4143: jai_constants.tax_type_cvd_edu_cess ,
4144: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4145: jai_constants.tax_type_customs_edu_cess
4146: ) THEN
4147: v_vendor_id := NULL;
4148: ELSIF UPPER( rec.tax_type ) LIKE '%EXCISE%' THEN
4149: v_vendor_id := p_vendor_id;

Line 4159: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI

4155: v_currency := p_currency;
4156: END IF;
4157: IF NVL( p_operation_flag, 0 ) < 0 AND ( UPPER( rec.tax_type ) LIKE '%EXCISE%' OR UPPER(rec.tax_type)
4158: NOT IN ( 'CVD',
4159: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4160: 'CUSTOMS',
4161: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4162: jai_constants.tax_type_cvd_edu_cess ,
4163: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/

Line 4161: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/bduvarag for the bug#5989740/

4157: IF NVL( p_operation_flag, 0 ) < 0 AND ( UPPER( rec.tax_type ) LIKE '%EXCISE%' OR UPPER(rec.tax_type)
4158: NOT IN ( 'CVD',
4159: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4160: 'CUSTOMS',
4161: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4162: jai_constants.tax_type_cvd_edu_cess ,
4163: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4164: jai_constants.tax_type_customs_edu_cess
4165: ) )

Line 4162: jai_constants.tax_type_cvd_edu_cess ,

4158: NOT IN ( 'CVD',
4159: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4160: 'CUSTOMS',
4161: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4162: jai_constants.tax_type_cvd_edu_cess ,
4163: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4164: jai_constants.tax_type_customs_edu_cess
4165: ) )
4166: THEN /* Indiactes an Internal Requisition */

Line 4163: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/bduvarag for the bug#5989740/

4159: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4160: 'CUSTOMS',
4161: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4162: jai_constants.tax_type_cvd_edu_cess ,
4163: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4164: jai_constants.tax_type_customs_edu_cess
4165: ) )
4166: THEN /* Indiactes an Internal Requisition */
4167: v_vendor_id := p_operation_flag;

Line 4164: jai_constants.tax_type_customs_edu_cess

4160: 'CUSTOMS',
4161: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
4162: jai_constants.tax_type_cvd_edu_cess ,
4163: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
4164: jai_constants.tax_type_customs_edu_cess
4165: ) )
4166: THEN /* Indiactes an Internal Requisition */
4167: v_vendor_id := p_operation_flag;
4168: END IF;

Line 4201: jai_constants.pa_draft_invoice /* 6012570 (5876390) */

4197:
4198: /* bgowrava for forward porting bug#5631784 */
4199: /* Added OR condition as we are passing p_action as null in case of 'CASH' Receipt. by JMEENA */
4200: elsif (p_source_trx_type in (
4201: jai_constants.pa_draft_invoice /* 6012570 (5876390) */
4202: , jai_constants.G_AP_STANDALONE_INVOICE
4203: -- Added by Jason Liu on 2007/08/23
4204: )
4205: and p_action = jai_constants.default_taxes )

Line 4202: , jai_constants.G_AP_STANDALONE_INVOICE

4198: /* bgowrava for forward porting bug#5631784 */
4199: /* Added OR condition as we are passing p_action as null in case of 'CASH' Receipt. by JMEENA */
4200: elsif (p_source_trx_type in (
4201: jai_constants.pa_draft_invoice /* 6012570 (5876390) */
4202: , jai_constants.G_AP_STANDALONE_INVOICE
4203: -- Added by Jason Liu on 2007/08/23
4204: )
4205: and p_action = jai_constants.default_taxes )
4206: OR (p_source_trx_type = jai_constants.ar_cash)

Line 4205: and p_action = jai_constants.default_taxes )

4201: jai_constants.pa_draft_invoice /* 6012570 (5876390) */
4202: , jai_constants.G_AP_STANDALONE_INVOICE
4203: -- Added by Jason Liu on 2007/08/23
4204: )
4205: and p_action = jai_constants.default_taxes )
4206: OR (p_source_trx_type = jai_constants.ar_cash)
4207: then
4208: -- Added by Jason Liu for standalone invoice on 2007/08/23
4209: ----------------------------------------------------------------------

Line 4206: OR (p_source_trx_type = jai_constants.ar_cash)

4202: , jai_constants.G_AP_STANDALONE_INVOICE
4203: -- Added by Jason Liu on 2007/08/23
4204: )
4205: and p_action = jai_constants.default_taxes )
4206: OR (p_source_trx_type = jai_constants.ar_cash)
4207: then
4208: -- Added by Jason Liu for standalone invoice on 2007/08/23
4209: ----------------------------------------------------------------------
4210: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE

Line 4210: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE

4206: OR (p_source_trx_type = jai_constants.ar_cash)
4207: then
4208: -- Added by Jason Liu for standalone invoice on 2007/08/23
4209: ----------------------------------------------------------------------
4210: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
4211: AND rec.tax_type IN ( jai_constants.tax_type_value_added
4212: , jai_constants.tax_type_sales
4213: , jai_constants.tax_type_cst
4214: , jai_constants.tax_type_other)

Line 4211: AND rec.tax_type IN ( jai_constants.tax_type_value_added

4207: then
4208: -- Added by Jason Liu for standalone invoice on 2007/08/23
4209: ----------------------------------------------------------------------
4210: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
4211: AND rec.tax_type IN ( jai_constants.tax_type_value_added
4212: , jai_constants.tax_type_sales
4213: , jai_constants.tax_type_cst
4214: , jai_constants.tax_type_other)
4215: THEN

Line 4212: , jai_constants.tax_type_sales

4208: -- Added by Jason Liu for standalone invoice on 2007/08/23
4209: ----------------------------------------------------------------------
4210: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
4211: AND rec.tax_type IN ( jai_constants.tax_type_value_added
4212: , jai_constants.tax_type_sales
4213: , jai_constants.tax_type_cst
4214: , jai_constants.tax_type_other)
4215: THEN
4216: v_modvat_flag := 'N';

Line 4213: , jai_constants.tax_type_cst

4209: ----------------------------------------------------------------------
4210: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
4211: AND rec.tax_type IN ( jai_constants.tax_type_value_added
4212: , jai_constants.tax_type_sales
4213: , jai_constants.tax_type_cst
4214: , jai_constants.tax_type_other)
4215: THEN
4216: v_modvat_flag := 'N';
4217: END IF; --p_source_trx_type = jai_constants.AP_STANDALONE_INVOICE

Line 4214: , jai_constants.tax_type_other)

4210: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
4211: AND rec.tax_type IN ( jai_constants.tax_type_value_added
4212: , jai_constants.tax_type_sales
4213: , jai_constants.tax_type_cst
4214: , jai_constants.tax_type_other)
4215: THEN
4216: v_modvat_flag := 'N';
4217: END IF; --p_source_trx_type = jai_constants.AP_STANDALONE_INVOICE
4218: ----------------------------------------------------------------------

Line 4217: END IF; --p_source_trx_type = jai_constants.AP_STANDALONE_INVOICE

4213: , jai_constants.tax_type_cst
4214: , jai_constants.tax_type_other)
4215: THEN
4216: v_modvat_flag := 'N';
4217: END IF; --p_source_trx_type = jai_constants.AP_STANDALONE_INVOICE
4218: ----------------------------------------------------------------------
4219:
4220: /*
4221: || When currency conversion rate is null it means the transaction is in the INR only

Line 4246: || ',tax_modified_by -> '||jai_constants.tax_modified_by_system ||CHR(10)

4242: || ',source_doc_type -> '||p_source_trx_type ||CHR(10)
4243: || ',source_doc_id -> '||p_header_id ||CHR(10)
4244: || ',source_doc_line_id -> '||p_line_id ||CHR(10)
4245: || ',source_table_name -> '||p_source_table_name ||CHR(10)
4246: || ',tax_modified_by -> '||jai_constants.tax_modified_by_system ||CHR(10)
4247: || ',precedence_1 -> '||rec.p_1 ||CHR(10)
4248: || ',precedence_2 -> '||rec.p_2 ||CHR(10)
4249: || ',precedence_3 -> '||rec.p_3 ||CHR(10)
4250: || ',precedence_4 -> '||rec.p_4 ||CHR(10)

Line 4265: IF (p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )

4261: || ',last_update_login -> '||p_last_update_login ||CHR(10)
4262: ); */ --commented by bgowrava for bug#5631784
4263: -- Added by Eric Ma for standalone invoice on 2007/09/27
4264: ----------------------------------------------------------------------
4265: IF (p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )
4266: THEN
4267: INSERT INTO jai_cmn_document_taxes
4268: ( doc_tax_id
4269: , tax_line_no

Line 4325: , jai_constants.tax_modified_by_system

4321: , p_header_id -- source_doc_id
4322: , p_line_id -- source_doc_line_id
4323: , p_line_id -- source_doc_parent_line_no,added by Eric Ma
4324: , p_source_table_name -- source_table_name
4325: , jai_constants.tax_modified_by_system
4326: --tax_modified_by(SYSTEM=system defaulted, MANUAL=User Modified)
4327: , rec.p_1 -- precedence_1
4328: , rec.p_2 -- precedence_2
4329: , rec.p_3 -- precedence_3

Line 4343: ELSE --(p_source_trx_type <>jai_constants.G_AP_STANDALONE_INVOICE );

4339: , p_last_update_date -- last_update_date
4340: , p_last_updated_by -- last_updated_by
4341: , p_last_update_login -- last_update_login
4342: );
4343: ELSE --(p_source_trx_type <>jai_constants.G_AP_STANDALONE_INVOICE );
4344: ------------------------------------------------------------------
4345: insert into jai_cmn_document_taxes
4346: ( doc_tax_id
4347: , tax_line_no

Line 4406: , jai_constants.tax_modified_by_system -- tax_modified_by (SYSTEM=system defaulted, MANUAL=User Modified)

4402: , p_source_trx_type -- source_doc_type
4403: , p_header_id -- source_doc_id
4404: , p_line_id -- source_doc_line_id
4405: , p_source_table_name -- source_table_name
4406: , jai_constants.tax_modified_by_system -- tax_modified_by (SYSTEM=system defaulted, MANUAL=User Modified)
4407: , rec.p_1 -- precedence_1
4408: , rec.p_2 -- precedence_2
4409: , rec.p_3 -- precedence_3
4410: , rec.p_4 -- precedence_4

Line 4423: END IF; --(p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )

4419: , p_last_update_date -- last_update_date
4420: , p_last_updated_by -- last_updated_by
4421: , p_last_update_login -- last_update_login
4422: );
4423: END IF; --(p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )
4424: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Record inserted into jai_cmn_document_taxes');*/ --commented by bgowrava for bug#5631784
4425:
4426: /* Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
4427: in This , Recalculation will be happen in Draft invoice */

Line 4429: p_source_trx_type = jai_constants.pa_draft_invoice

4425:
4426: /* Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
4427: in This , Recalculation will be happen in Draft invoice */
4428: elsif
4429: p_source_trx_type = jai_constants.pa_draft_invoice
4430: and p_action = jai_constants.recalculate_taxes
4431: then
4432:
4433: update jai_cmn_document_taxes

Line 4430: and p_action = jai_constants.recalculate_taxes

4426: /* Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
4427: in This , Recalculation will be happen in Draft invoice */
4428: elsif
4429: p_source_trx_type = jai_constants.pa_draft_invoice
4430: and p_action = jai_constants.recalculate_taxes
4431: then
4432:
4433: update jai_cmn_document_taxes
4434: set tax_amt = tax_amt_tab(row_count)

Line 4441: and source_doc_type = jai_constants.pa_draft_invoice;

4437: ,last_updated_by = p_last_updated_by
4438: ,last_update_login = p_last_update_login
4439: where source_doc_line_id = p_line_id
4440: and tax_id = rec.tax_id
4441: and source_doc_type = jai_constants.pa_draft_invoice;
4442:
4443: elsif p_source_trx_type = jai_constants.source_ttype_delivery
4444: then
4445:

Line 4443: elsif p_source_trx_type = jai_constants.source_ttype_delivery

4439: where source_doc_line_id = p_line_id
4440: and tax_id = rec.tax_id
4441: and source_doc_type = jai_constants.pa_draft_invoice;
4442:
4443: elsif p_source_trx_type = jai_constants.source_ttype_delivery
4444: then
4445:
4446: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
4447: ,'Value of variables used for updating ja_in_so_picking_tax_lines'||chr(10)

Line 4454: if p_action = jai_constants.recalculate_taxes then

4450: ||'base_tax_amount = '||round( nvl(tax_amt_tab(row_count),0), rec.rounding_factor) ||chr(10)
4451: ||'tax_id = '||rec.tax_id
4452: ); */ --commented by bgowrava for bug#5631784
4453:
4454: if p_action = jai_constants.recalculate_taxes then
4455: --Used base_tax_amt_tab instead of tax_amt_tab to update column base_tax_amount for bug#8905076 by JMEENA
4456: update JAI_OM_WSH_LINE_TAXES
4457: set tax_amount = tax_amt_tab(row_count)
4458: ,func_tax_amount = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)

Line 4471: p_source_trx_type = 'TDS INVOICE'--jai_constants.pa_draft_invoice

4467:
4468: --Added by Zhiwei Hou for Bug#13359892 DTC enhancement on 20111128 begin
4469: --------------------------------------------------------------------------------
4470: elsif
4471: p_source_trx_type = 'TDS INVOICE'--jai_constants.pa_draft_invoice
4472: and p_action = jai_constants.recalculate_taxes
4473: then
4474:
4475: if v_currency_conv_factor is null then

Line 4472: and p_action = jai_constants.recalculate_taxes

4468: --Added by Zhiwei Hou for Bug#13359892 DTC enhancement on 20111128 begin
4469: --------------------------------------------------------------------------------
4470: elsif
4471: p_source_trx_type = 'TDS INVOICE'--jai_constants.pa_draft_invoice
4472: and p_action = jai_constants.recalculate_taxes
4473: then
4474:
4475: if v_currency_conv_factor is null then
4476: v_currency_conv_factor := 1;

Line 4497: elsif p_source_trx_type = jai_constants.bill_only_invoice then

4493:
4494: --------------------------------------------------------------------------------
4495: --Added by Zhiwei Hou for Bug#13359892 DTC enhancement on 20111128 end
4496:
4497: elsif p_source_trx_type = jai_constants.bill_only_invoice then
4498:
4499: /*
4500: || When currency conversion rate is null it means the transaction is in the INR only
4501: */

Line 4514: if p_action = jai_constants.recalculate_taxes then

4510: ||'base_tax_amount = '||round( nvl(tax_amt_tab(row_count),0), rec.rounding_factor) ||chr(10)
4511: ||'tax_id = '||rec.tax_id
4512: ); */ --commented by bgowrava for bug#5631784
4513:
4514: if p_action = jai_constants.recalculate_taxes then
4515:
4516: update JAI_AR_TRX_TAX_LINES
4517: set tax_amount = tax_amt_tab(row_count)
4518: ,func_tax_amount = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)

Line 4664: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/

4660: , b.tax_amount
4661: , b.tax_amount qty_rate /*Added b.tax_amount qty_rate by murtuza for bug 14675629*/
4662: , b.uom_code
4663: , b.end_date valid_date
4664: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4665: /*jai_constants.cgst_regime, 7,*/ /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4666: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4667: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4668: DECODE(UPPER(b.tax_type),

Line 4665: /jai_constants.cgst_regime, 7,/ /* Added by Jia for GST Bug#10043656 on 2010/09/10 */

4661: , b.tax_amount qty_rate /*Added b.tax_amount qty_rate by murtuza for bug 14675629*/
4662: , b.uom_code
4663: , b.end_date valid_date
4664: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4665: /*jai_constants.cgst_regime, 7,*/ /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4666: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4667: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4668: DECODE(UPPER(b.tax_type),
4669: 'EXCISE', 1,

Line 4666: /jai_constants.sgst_regime, 7, //* Added by Jia for GST Bug#10043656 on 2010/09/10 */

4662: , b.uom_code
4663: , b.end_date valid_date
4664: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4665: /*jai_constants.cgst_regime, 7,*/ /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4666: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4667: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4668: DECODE(UPPER(b.tax_type),
4669: 'EXCISE', 1,
4670: 'ADDL. EXCISE', 1,

Line 4667: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */

4663: , b.end_date valid_date
4664: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4665: /*jai_constants.cgst_regime, 7,*/ /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4666: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4667: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4668: DECODE(UPPER(b.tax_type),
4669: 'EXCISE', 1,
4670: 'ADDL. EXCISE', 1,
4671: 'OTHER EXCISE', 1,

Line 4674: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 6 , /bduvarag for the bug#5989740/ --modified by walton for inclusive tax

4670: 'ADDL. EXCISE', 1,
4671: 'OTHER EXCISE', 1,
4672: 'TDS', 2,
4673: 'EXCISE_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
4674: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 6 , /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
4675: 'CVD_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
4676: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 6 , /*bduvarag for the bug#5989740*/--modified by walton for inclusive tax
4677: 0
4678: )

Line 4676: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 6 , /bduvarag for the bug#5989740/--modified by walton for inclusive tax

4672: 'TDS', 2,
4673: 'EXCISE_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
4674: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 6 , /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
4675: 'CVD_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
4676: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 6 , /*bduvarag for the bug#5989740*/--modified by walton for inclusive tax
4677: 0
4678: )
4679: ) tax_type_val
4680: , b.mod_cr_percentage

Line 4740: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/

4736: , b.tax_rate
4737: , b.tax_amount
4738: , b.uom_code
4739: , b.end_date valid_date
4740: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4741: /*jai_constants.cgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4742: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4743: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4744: DECODE(UPPER(b.tax_type),

Line 4741: /jai_constants.cgst_regime, 7, //* Added by Jia for GST Bug#10043656 on 2010/09/10 */

4737: , b.tax_amount
4738: , b.uom_code
4739: , b.end_date valid_date
4740: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4741: /*jai_constants.cgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4742: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4743: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4744: DECODE(UPPER(b.tax_type),
4745: 'EXCISE', 1,

Line 4742: /jai_constants.sgst_regime, 7, //* Added by Jia for GST Bug#10043656 on 2010/09/10 */

4738: , b.uom_code
4739: , b.end_date valid_date
4740: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4741: /*jai_constants.cgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4742: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4743: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4744: DECODE(UPPER(b.tax_type),
4745: 'EXCISE', 1,
4746: 'ADDL. EXCISE', 1,

Line 4743: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */

4739: , b.end_date valid_date
4740: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
4741: /*jai_constants.cgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4742: /*jai_constants.sgst_regime, 7, *//* Added by Jia for GST Bug#10043656 on 2010/09/10 */
4743: jai_constants.customs_regime, 8, /* Added by Bo Li for Bug#11684111 BOE Ehancement */
4744: DECODE(UPPER(b.tax_type),
4745: 'EXCISE', 1,
4746: 'ADDL. EXCISE', 1,
4747: 'OTHER EXCISE', 1,

Line 4750: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 1 , /bduvarag for the bug#5989740/

4746: 'ADDL. EXCISE', 1,
4747: 'OTHER EXCISE', 1,
4748: 'TDS', 2,
4749: 'EXCISE_EDUCATION_CESS' ,1,
4750: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 1 , /*bduvarag for the bug#5989740*/
4751: 'CVD_EDUCATION_CESS' ,1,
4752: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 1 , /*bduvarag for the bug#5989740*/
4753: 0
4754: )

Line 4752: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 1 , /bduvarag for the bug#5989740/

4748: 'TDS', 2,
4749: 'EXCISE_EDUCATION_CESS' ,1,
4750: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 1 , /*bduvarag for the bug#5989740*/
4751: 'CVD_EDUCATION_CESS' ,1,
4752: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 1 , /*bduvarag for the bug#5989740*/
4753: 0
4754: )
4755: ) tax_type_val
4756: , b.mod_cr_percentage