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

Line 116: IF ( NVL (pv_modvat_flag, 'N') = jai_constants.no

112: , 'pn_cr_percentage ' || pn_cr_percentage
113: );
114: END IF; --(ln_proc_level >= ln_dbg_level)
115:
116: IF ( NVL (pv_modvat_flag, 'N') = jai_constants.no
117: OR NVL (pn_cr_percentage, -1) <= 0
118: )
119: THEN
120: lv_tax_type := 'NR' ; --NON RECOVERABLE

Line 122: ( NVL (pv_modvat_flag, 'N') = jai_constants.yes

118: )
119: THEN
120: lv_tax_type := 'NR' ; --NON RECOVERABLE
121: ELSIF
122: ( NVL (pv_modvat_flag, 'N') = jai_constants.yes
123: AND NVL (pn_cr_percentage, -1) = 100
124: )
125: THEN
126: lv_tax_type := 'FR' ; --FULLY RECOVERABLE

Line 128: ( NVL (pv_modvat_flag, 'N') = jai_constants.yes

124: )
125: THEN
126: lv_tax_type := 'FR' ; --FULLY RECOVERABLE
127: ELSIF
128: ( NVL (pv_modvat_flag, 'N') = jai_constants.yes
129: AND NVL (pn_cr_percentage, -1) < 100
130: )
131: THEN
132: lv_tax_type := 'PR' ; --PARTIALLY RECOVERABLE

Line 133: END IF;--( (pv_modvat_flag, 'N') = jai_constants.no)

129: AND NVL (pn_cr_percentage, -1) < 100
130: )
131: THEN
132: lv_tax_type := 'PR' ; --PARTIALLY RECOVERABLE
133: END IF;--( (pv_modvat_flag, 'N') = jai_constants.no)
134:
135:
136: IF ( ln_proc_level >= ln_dbg_level)
137: THEN

Line 295: AND source_doc_type = jai_constants.g_ap_standalone_invoice;

291: jai_cmn_document_taxes
292: SET
293: source_doc_id = pn_invoice_id
294: WHERE source_doc_id = pn_invoice_id
295: AND source_doc_type = jai_constants.g_ap_standalone_invoice;
296:
297: SELECT
298: NVL(MAX(source_doc_line_id), 0)
299: INTO

Line 304: AND source_doc_type = jai_constants.g_ap_standalone_invoice;

300: ln_max_line_number
301: FROM
302: jai_cmn_document_taxes
303: WHERE source_doc_id = pn_invoice_id
304: AND source_doc_type = jai_constants.g_ap_standalone_invoice;
305:
306:
307: IF ( ln_proc_level >= ln_dbg_level)
308: THEN

Line 648: p_organization_type => jai_constants.orgn_type_io,/5694855/

644: ln_service_interim_account :=
645: jai_cmn_rgm_recording_pkg.get_account
646: (
647: p_regime_id => p_service_regime_id,
648: p_organization_type => jai_constants.orgn_type_io,/*5694855*/
649: p_organization_id => ln_organization_id,/*5694855*/
650: p_location_id => ln_location_id, /*5694855*/
651: p_tax_type => p_tax_type,
652: p_account_name => jai_constants.recovery_interim

Line 652: p_account_name => jai_constants.recovery_interim

648: p_organization_type => jai_constants.orgn_type_io,/*5694855*/
649: p_organization_id => ln_organization_id,/*5694855*/
650: p_location_id => ln_location_id, /*5694855*/
651: p_tax_type => p_tax_type,
652: p_account_name => jai_constants.recovery_interim
653: );
654:
655: return ln_service_interim_account;
656:

Line 737: AND registration_type =jai_constants.regn_type_tax_types --tax type

733: attribute_code tax_type
734: FROM
735: jai_rgm_registrations
736: WHERE regime_id = pn_regime_id
737: AND registration_type =jai_constants.regn_type_tax_types --tax type
738: AND attribute_code = pv_tax_type_code;
739:
740: CURSOR regime_account_cur
741: ( pn_regime_id NUMBER

Line 751: AND tax_types.registration_type = jai_constants.regn_type_tax_types

747: FROM
748: jai_rgm_registrations tax_types
749: , jai_rgm_registrations accnts
750: WHERE tax_types.regime_id = pn_regime_id
751: AND tax_types.registration_type = jai_constants.regn_type_tax_types
752: AND tax_types.attribute_code = pn_tax_type
753: AND accnts.regime_id = tax_types.regime_id
754: AND accnts.registration_type = jai_constants.regn_type_accounts
755: AND accnts.parent_registration_id = tax_types.registration_id

Line 754: AND accnts.registration_type = jai_constants.regn_type_accounts

750: WHERE tax_types.regime_id = pn_regime_id
751: AND tax_types.registration_type = jai_constants.regn_type_tax_types
752: AND tax_types.attribute_code = pn_tax_type
753: AND accnts.regime_id = tax_types.regime_id
754: AND accnts.registration_type = jai_constants.regn_type_accounts
755: AND accnts.parent_registration_id = tax_types.registration_id
756: AND accnts.attribute_code = pv_ac_type;
757:
758: --start additions for bug#9775984

Line 839: OPEN jai_regimes_cur (jai_constants.service_regime);

835: close get_dflt_ccid;
836: end if;
837: --end additions for bug#9775984
838: ELSE -- recoverable tax
839: OPEN jai_regimes_cur (jai_constants.service_regime);
840: FETCH jai_regimes_cur
841: INTO
842: service_regimes_rec;
843: CLOSE jai_regimes_cur;

Line 856: lv_regime_code := jai_constants.service_regime;

852: CLOSE regime_tax_type_cur;
853:
854: IF lv_regim_tax_type IS NOT NULL
855: THEN
856: lv_regime_code := jai_constants.service_regime;
857: ELSE -- (r_service_regime_tax is null)
858: NULL;
859: END IF; --( end of r_service_regime_tax_type level)
860:

Line 893: , p_organization_type => jai_constants.orgn_type_io

889: THEN
890: ln_dist_acct_ccid :=
891: jai_cmn_rgm_recording_pkg.get_account
892: ( p_regime_id => ln_regime_id
893: , p_organization_type => jai_constants.orgn_type_io
894: , p_organization_id => pn_organization_id
895: , p_location_id => pn_location_id
896: , p_tax_type => pn_tax_type_code
897: , p_account_name => pv_ac_type

Line 2066: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice

2062: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
2063: WHERE jcdt.source_doc_id = pn_invoice_id
2064: AND jcdt.source_doc_parent_line_no = pn_parent_line_number
2065: AND jcdt.tax_id = jcta.tax_id --Added by Eric for Inclusive Tax
2066: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice
2067: AND NVL(jcta.reverse_charge_flag,'N') = 'Y' --Added by Chong for reverse charge service tax ER 2012/07/05
2068: --Added by Chong for reverse charge service tax ER bug#14385555 2012/08/06 Start
2069: ---------------------------------------------------------------------------------
2070: AND NOT EXISTS(

Line 2131: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice

2127: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
2128: WHERE jcdt.source_doc_id = pn_invoice_id
2129: AND jcdt.source_doc_parent_line_no = pn_parent_line_number
2130: AND jcdt.tax_id = jcta.tax_id --Added by Eric for Inclusive Tax
2131: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice
2132: AND NVL(jcta.reverse_charge_flag,'N') = 'Y' --Added by Chong for reverse charge service tax ER 20120705
2133: AND NVL(jcdt.modvat_flag, 'N') = 'Y' --Added by Chong for reverse charge service tax ER 20120705
2134: --Added by Chong for reverse charge service tax ER bug#14385555 2012/08/06 Start
2135: ---------------------------------------------------------------------------------

Line 2194: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice

2190: jai_cmn_document_taxes jcdt
2191: WHERE jcdt.source_doc_id = pn_invoice_id
2192: AND jcdt.source_doc_line_id = pn_line_number
2193: AND jcdt.source_doc_parent_line_no = pn_line_number
2194: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice
2195: ORDER BY jcdt.tax_line_no FOR UPDATE;
2196:
2197: CURSOR get_tax_cur (pn_tax_id NUMBER) IS
2198: SELECT

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

3276: WHERE line_location_id = p_line_location_id -- 3096578
3277: AND NVL(UPPER(jpt.tax_type), 'A')
3278: NOT IN( 'TDS'
3279: , 'CVD'
3280: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3281: , 'CUSTOMS'
3282: , jai_constants.tax_type_cvd_edu_cess
3283: , jai_constants.tax_type_customs_edu_cess
3284: , jai_constants.tax_type_sh_cvd_edu_cess

Line 3282: , jai_constants.tax_type_cvd_edu_cess

3278: NOT IN( 'TDS'
3279: , 'CVD'
3280: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3281: , 'CUSTOMS'
3282: , jai_constants.tax_type_cvd_edu_cess
3283: , jai_constants.tax_type_customs_edu_cess
3284: , jai_constants.tax_type_sh_cvd_edu_cess
3285: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
3286: )

Line 3283: , jai_constants.tax_type_customs_edu_cess

3279: , 'CVD'
3280: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3281: , 'CUSTOMS'
3282: , jai_constants.tax_type_cvd_edu_cess
3283: , jai_constants.tax_type_customs_edu_cess
3284: , jai_constants.tax_type_sh_cvd_edu_cess
3285: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
3286: )
3287: AND jcta.tax_id = jpt.tax_id

Line 3284: , jai_constants.tax_type_sh_cvd_edu_cess

3280: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3281: , 'CUSTOMS'
3282: , jai_constants.tax_type_cvd_edu_cess
3283: , jai_constants.tax_type_customs_edu_cess
3284: , jai_constants.tax_type_sh_cvd_edu_cess
3285: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
3286: )
3287: AND jcta.tax_id = jpt.tax_id
3288: AND NVL(jpt.vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895

Line 3285: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740

3281: , 'CUSTOMS'
3282: , jai_constants.tax_type_cvd_edu_cess
3283: , jai_constants.tax_type_customs_edu_cess
3284: , jai_constants.tax_type_sh_cvd_edu_cess
3285: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
3286: )
3287: AND jcta.tax_id = jpt.tax_id
3288: AND NVL(jpt.vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895
3289: AND p_source <> 'PPA'

Line 3325: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds

3321: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
3322: AND jrl.tax_id = jcta.tax_id
3323: AND NVL(jrlc.vendor_id, -1) = vend_id
3324: AND p_source = 'PPA'
3325: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3326: , jai_constants.tax_type_cvd
3327: , jai_constants.tax_type_add_cvd
3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess

Line 3326: , jai_constants.tax_type_cvd

3322: AND jrl.tax_id = jcta.tax_id
3323: AND NVL(jrlc.vendor_id, -1) = vend_id
3324: AND p_source = 'PPA'
3325: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3326: , jai_constants.tax_type_cvd
3327: , jai_constants.tax_type_add_cvd
3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess
3330: , jai_constants.tax_type_customs_edu_cess

Line 3327: , jai_constants.tax_type_add_cvd

3323: AND NVL(jrlc.vendor_id, -1) = vend_id
3324: AND p_source = 'PPA'
3325: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3326: , jai_constants.tax_type_cvd
3327: , jai_constants.tax_type_add_cvd
3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess
3330: , jai_constants.tax_type_customs_edu_cess
3331: , jai_constants.tax_type_sh_cvd_edu_cess

Line 3328: , jai_constants.tax_type_customs

3324: AND p_source = 'PPA'
3325: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3326: , jai_constants.tax_type_cvd
3327: , jai_constants.tax_type_add_cvd
3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess
3330: , jai_constants.tax_type_customs_edu_cess
3331: , jai_constants.tax_type_sh_cvd_edu_cess
3332: , jai_constants.tax_type_cvd_edu_cess

Line 3329: , jai_constants.tax_type_sh_customs_edu_cess

3325: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3326: , jai_constants.tax_type_cvd
3327: , jai_constants.tax_type_add_cvd
3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess
3330: , jai_constants.tax_type_customs_edu_cess
3331: , jai_constants.tax_type_sh_cvd_edu_cess
3332: , jai_constants.tax_type_cvd_edu_cess
3333: )

Line 3330: , jai_constants.tax_type_customs_edu_cess

3326: , jai_constants.tax_type_cvd
3327: , jai_constants.tax_type_add_cvd
3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess
3330: , jai_constants.tax_type_customs_edu_cess
3331: , jai_constants.tax_type_sh_cvd_edu_cess
3332: , jai_constants.tax_type_cvd_edu_cess
3333: )
3334: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416

Line 3331: , jai_constants.tax_type_sh_cvd_edu_cess

3327: , jai_constants.tax_type_add_cvd
3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess
3330: , jai_constants.tax_type_customs_edu_cess
3331: , jai_constants.tax_type_sh_cvd_edu_cess
3332: , jai_constants.tax_type_cvd_edu_cess
3333: )
3334: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
3335: ---------------------------------------------------------------------

Line 3332: , jai_constants.tax_type_cvd_edu_cess

3328: , jai_constants.tax_type_customs
3329: , jai_constants.tax_type_sh_customs_edu_cess
3330: , jai_constants.tax_type_customs_edu_cess
3331: , jai_constants.tax_type_sh_cvd_edu_cess
3332: , jai_constants.tax_type_cvd_edu_cess
3333: )
3334: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
3335: ---------------------------------------------------------------------
3336: --Added by Chong for reverse charge service tax on 2012/07/05 start

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

3426: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
3427: AND NVL(upper(jrl.tax_type),'TDS')
3428: NOT IN ( 'TDS'
3429: , 'CVD'
3430: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3431: , 'CUSTOMS'
3432: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
3433: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
3434: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS

Line 3432: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS

3428: NOT IN ( 'TDS'
3429: , 'CVD'
3430: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3431: , 'CUSTOMS'
3432: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
3433: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
3434: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
3435: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
3436: )

Line 3433: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */

3429: , 'CVD'
3430: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3431: , 'CUSTOMS'
3432: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
3433: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
3434: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
3435: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
3436: )
3437: --Added by Chong for reverse charge service tax on 2012/07/05 start

Line 3434: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS

3430: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3431: , 'CUSTOMS'
3432: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
3433: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
3434: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
3435: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
3436: )
3437: --Added by Chong for reverse charge service tax on 2012/07/05 start
3438: ---------------------------------------------------------------------

Line 3435: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */

3431: , 'CUSTOMS'
3432: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
3433: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
3434: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
3435: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
3436: )
3437: --Added by Chong for reverse charge service tax on 2012/07/05 start
3438: ---------------------------------------------------------------------
3439: AND NVL(jcta.reverse_charge_flag,'N') = 'Y'

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

3472: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
3473: AND NVL(upper(jrl.tax_type),'TDS') NOT IN
3474: ('TDS',
3475: 'CVD',
3476: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3477: 'CUSTOMS',
3478: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
3479: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
3480: )

Line 3478: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */

3474: ('TDS',
3475: 'CVD',
3476: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3477: 'CUSTOMS',
3478: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
3479: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
3480: )
3481: AND p_source <> 'PPA'
3482: --Added by Chong for reverse charge service tax on 2012/07/05 start

Line 3479: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */

3475: 'CVD',
3476: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3477: 'CUSTOMS',
3478: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
3479: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
3480: )
3481: AND p_source <> 'PPA'
3482: --Added by Chong for reverse charge service tax on 2012/07/05 start
3483: ---------------------------------------------------------------------

Line 3518: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds

3514: AND rt.shipment_line_id = rsl.shipment_line_id
3515: AND rt.transaction_id = tran_id
3516: AND jrlc.vendor_id = ven_id
3517: AND p_source = 'PPA'
3518: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3519: , jai_constants.tax_type_cvd
3520: , jai_constants.tax_type_add_cvd
3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess

Line 3519: , jai_constants.tax_type_cvd

3515: AND rt.transaction_id = tran_id
3516: AND jrlc.vendor_id = ven_id
3517: AND p_source = 'PPA'
3518: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3519: , jai_constants.tax_type_cvd
3520: , jai_constants.tax_type_add_cvd
3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess
3523: , jai_constants.tax_type_customs_edu_cess

Line 3520: , jai_constants.tax_type_add_cvd

3516: AND jrlc.vendor_id = ven_id
3517: AND p_source = 'PPA'
3518: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3519: , jai_constants.tax_type_cvd
3520: , jai_constants.tax_type_add_cvd
3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess
3523: , jai_constants.tax_type_customs_edu_cess
3524: , jai_constants.tax_type_sh_cvd_edu_cess

Line 3521: , jai_constants.tax_type_customs

3517: AND p_source = 'PPA'
3518: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3519: , jai_constants.tax_type_cvd
3520: , jai_constants.tax_type_add_cvd
3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess
3523: , jai_constants.tax_type_customs_edu_cess
3524: , jai_constants.tax_type_sh_cvd_edu_cess
3525: , jai_constants.tax_type_cvd_edu_cess

Line 3522: , jai_constants.tax_type_sh_customs_edu_cess

3518: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
3519: , jai_constants.tax_type_cvd
3520: , jai_constants.tax_type_add_cvd
3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess
3523: , jai_constants.tax_type_customs_edu_cess
3524: , jai_constants.tax_type_sh_cvd_edu_cess
3525: , jai_constants.tax_type_cvd_edu_cess
3526: )

Line 3523: , jai_constants.tax_type_customs_edu_cess

3519: , jai_constants.tax_type_cvd
3520: , jai_constants.tax_type_add_cvd
3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess
3523: , jai_constants.tax_type_customs_edu_cess
3524: , jai_constants.tax_type_sh_cvd_edu_cess
3525: , jai_constants.tax_type_cvd_edu_cess
3526: )
3527: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416

Line 3524: , jai_constants.tax_type_sh_cvd_edu_cess

3520: , jai_constants.tax_type_add_cvd
3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess
3523: , jai_constants.tax_type_customs_edu_cess
3524: , jai_constants.tax_type_sh_cvd_edu_cess
3525: , jai_constants.tax_type_cvd_edu_cess
3526: )
3527: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
3528: --Added by Chong for reverse charge service tax on 2012/07/05 start

Line 3525: , jai_constants.tax_type_cvd_edu_cess

3521: , jai_constants.tax_type_customs
3522: , jai_constants.tax_type_sh_customs_edu_cess
3523: , jai_constants.tax_type_customs_edu_cess
3524: , jai_constants.tax_type_sh_cvd_edu_cess
3525: , jai_constants.tax_type_cvd_edu_cess
3526: )
3527: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
3528: --Added by Chong for reverse charge service tax on 2012/07/05 start
3529: ---------------------------------------------------------------------

Line 3683: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */

3679: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
3680: select attribute_code tax_type
3681: from JAI_RGM_REGISTRATIONS
3682: where regime_id = cp_regime_id
3683: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
3684: and attribute_code = cp_tax_type;
3685:
3686:
3687: r_rcv_transactions c_rcv_transactions%rowtype;

Line 4093: open c_jai_regimes(jai_constants.service_regime);

4089:
4090: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'lv_accrue_on_receipt_flag='||lv_accrue_on_receipt_flag);
4091:
4092: --For reverse charege service tax, only service tax regime will come to here.
4093: open c_jai_regimes(jai_constants.service_regime);
4094: fetch c_jai_regimes into r_jai_regimes;
4095: close c_jai_regimes;
4096: /* service End */
4097:

Line 4181: if i.modvat_flag = jai_constants.YES

4177:
4178: --initial the tax_type
4179: lv_tax_type := NULL;
4180:
4181: if i.modvat_flag = jai_constants.YES
4182: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0 then
4183:
4184: --recoverable tax
4185: lv_tax_type := 'RE';

Line 4221: p_organization_type => jai_constants.orgn_type_io,

4217: --for po matched invoice ,service taxes shall hit the interim recovery account irrespective of exclusive or inclusive type
4218: v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
4219: (
4220: p_regime_id => r_jai_regimes.regime_id,
4221: p_organization_type => jai_constants.orgn_type_io,
4222: p_organization_id => ln_ship_to_organization_id,
4223: p_location_id => ln_ship_to_location_id,
4224: p_tax_type => c_tax_rec.tax_type,
4225: p_account_name => GV_REVERSE_CHARGE

Line 4230: p_organization_type => jai_constants.orgn_type_io,

4226: );
4227: v_dist_ccid_liability := jai_cmn_rgm_recording_pkg.get_account
4228: (
4229: p_regime_id => r_jai_regimes.regime_id,
4230: p_organization_type => jai_constants.orgn_type_io,
4231: p_organization_id => ln_ship_to_organization_id,
4232: p_location_id => ln_ship_to_location_id,
4233: p_tax_type => c_tax_rec.tax_type,
4234: p_account_name => GV_INTERIM_LIABILITY

Line 4282: if i.modvat_flag = jai_constants.YES

4278:
4279: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name
4280: , 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
4281:
4282: if i.modvat_flag = jai_constants.YES
4283: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4284: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
4285: then
4286: --

Line 4325: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

4321:
4322: v_tax_amount := ln_nrec_tax_amt;
4323: lv_tax_line_amount := v_tax_amount ;
4324:
4325: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4326: v_assets_tracking_flag := jai_constants.YES;
4327: END IF;
4328:
4329: lv_modvat_flag := jai_constants.NO ;

Line 4326: v_assets_tracking_flag := jai_constants.YES;

4322: v_tax_amount := ln_nrec_tax_amt;
4323: lv_tax_line_amount := v_tax_amount ;
4324:
4325: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4326: v_assets_tracking_flag := jai_constants.YES;
4327: END IF;
4328:
4329: lv_modvat_flag := jai_constants.NO ;
4330:

Line 4329: lv_modvat_flag := jai_constants.NO ;

4325: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4326: v_assets_tracking_flag := jai_constants.YES;
4327: END IF;
4328:
4329: lv_modvat_flag := jai_constants.NO ;
4330:
4331: --
4332: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
4333: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 4419: IF i.modvat_flag = jai_constants.no

4415: v_tax_variance_inv_cur := v_tax_amt_dist * (r_ap_dist.invoice_price_variance / r_ap_dist.amount);
4416: v_tax_variance_fun_cur := v_tax_variance_inv_cur * nvl(for_org_id_rec.exchange_rate, 1);
4417: END IF;
4418:
4419: IF i.modvat_flag = jai_constants.no
4420: THEN
4421: v_assets_tracking_flag := r_ap_dist.assets_tracking_flag;
4422: lv_project_accounting_context := r_ap_dist.project_accounting_context;
4423: lv_pa_addition_flag := r_ap_dist.pa_addition_flag;

Line 4735: if r_tax_lines_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

4731: FETCH c_tax_curr_prec INTO ln_tax_precision ;
4732: CLOSE c_tax_curr_prec ;
4733:
4734: ln_base_amount := null ;
4735: if r_tax_lines_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
4736: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
4737: (
4738: p_invoice_id => inv_id ,
4739: p_line_location_id => null ,

Line 4752: if r_tax_lines_rec.modvat_flag = jai_constants.YES

4748: lv_tax_type := NULL;
4749:
4750: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'c_tax_rec.mod_cr_percentage = '||c_tax_rec.mod_cr_percentage);
4751:
4752: if r_tax_lines_rec.modvat_flag = jai_constants.YES
4753: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4754: then
4755: /* recoverable tax */
4756: lv_tax_type := 'RE';

Line 4791: p_organization_type => jai_constants.orgn_type_io,

4787: /* Service type of tax */
4788: v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
4789: (
4790: p_regime_id => r_jai_regimes.regime_id,
4791: p_organization_type => jai_constants.orgn_type_io,
4792: p_organization_id => ln_ship_to_organization_id,
4793: p_location_id => ln_ship_to_location_id,
4794: p_tax_type => c_tax_rec.tax_type,
4795: p_account_name => GV_REVERSE_CHARGE

Line 4800: p_organization_type => jai_constants.orgn_type_io,

4796: );
4797: v_dist_ccid_liability := jai_cmn_rgm_recording_pkg.get_account
4798: (
4799: p_regime_id => r_jai_regimes.regime_id,
4800: p_organization_type => jai_constants.orgn_type_io,
4801: p_organization_id => ln_ship_to_organization_id,
4802: p_location_id => ln_ship_to_location_id,
4803: p_tax_type => c_tax_rec.tax_type,
4804: p_account_name => GV_INTERIM_LIABILITY

Line 4905: if r_tax_lines_rec.modvat_flag = jai_constants.YES

4901:
4902: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
4903: 'r_tax_lines_rec.modvat_flag ='||r_tax_lines_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
4904:
4905: if r_tax_lines_rec.modvat_flag = jai_constants.YES
4906: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4907: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
4908: then
4909: --

Line 4957: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

4953:
4954: v_tax_amount := ln_nrec_tax_amt;
4955: lv_tax_line_amount := v_tax_amount ;
4956:
4957: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4958: v_assets_tracking_flag := jai_constants.YES;
4959: END IF;
4960:
4961: lv_modvat_flag := jai_constants.NO ;

Line 4958: v_assets_tracking_flag := jai_constants.YES;

4954: v_tax_amount := ln_nrec_tax_amt;
4955: lv_tax_line_amount := v_tax_amount ;
4956:
4957: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4958: v_assets_tracking_flag := jai_constants.YES;
4959: END IF;
4960:
4961: lv_modvat_flag := jai_constants.NO ;
4962:

Line 4961: lv_modvat_flag := jai_constants.NO ;

4957: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4958: v_assets_tracking_flag := jai_constants.YES;
4959: END IF;
4960:
4961: lv_modvat_flag := jai_constants.NO ;
4962:
4963: --
4964: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
4965: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 5547: jai_constants.tax_type_add_cvd ,

5543: AND jrl.vendor_id = ven_id
5544: AND jcta.tax_id = jrl.tax_id
5545: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ('TDS',
5546: 'CVD',
5547: jai_constants.tax_type_add_cvd ,
5548: 'CUSTOMS',
5549: jai_constants.tax_type_customs_edu_cess,
5550: jai_constants.tax_type_cvd_edu_cess)
5551: AND NVL(jcta.reverse_charge_flag,'N') = 'Y'

Line 5549: jai_constants.tax_type_customs_edu_cess,

5545: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ('TDS',
5546: 'CVD',
5547: jai_constants.tax_type_add_cvd ,
5548: 'CUSTOMS',
5549: jai_constants.tax_type_customs_edu_cess,
5550: jai_constants.tax_type_cvd_edu_cess)
5551: AND NVL(jcta.reverse_charge_flag,'N') = 'Y'
5552: order by tax_line_no
5553: ;

Line 5550: jai_constants.tax_type_cvd_edu_cess)

5546: 'CVD',
5547: jai_constants.tax_type_add_cvd ,
5548: 'CUSTOMS',
5549: jai_constants.tax_type_customs_edu_cess,
5550: jai_constants.tax_type_cvd_edu_cess)
5551: AND NVL(jcta.reverse_charge_flag,'N') = 'Y'
5552: order by tax_line_no
5553: ;
5554:

Line 5582: jai_constants.tax_type_add_cvd ,

5578: WHERE jpt.line_location_id = p_line_location_id
5579: AND jcta.tax_id = jpt.tax_id
5580: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
5581: 'CVD',
5582: jai_constants.tax_type_add_cvd ,
5583: 'CUSTOMS',
5584: jai_constants.tax_type_customs_edu_cess,
5585: jai_constants.tax_type_cvd_edu_cess
5586: )

Line 5584: jai_constants.tax_type_customs_edu_cess,

5580: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
5581: 'CVD',
5582: jai_constants.tax_type_add_cvd ,
5583: 'CUSTOMS',
5584: jai_constants.tax_type_customs_edu_cess,
5585: jai_constants.tax_type_cvd_edu_cess
5586: )
5587: AND NVL(jpt.vendor_id, 0) = vend_id
5588: AND cp_source <> 'ASBN'

Line 5585: jai_constants.tax_type_cvd_edu_cess

5581: 'CVD',
5582: jai_constants.tax_type_add_cvd ,
5583: 'CUSTOMS',
5584: jai_constants.tax_type_customs_edu_cess,
5585: jai_constants.tax_type_cvd_edu_cess
5586: )
5587: AND NVL(jpt.vendor_id, 0) = vend_id
5588: AND cp_source <> 'ASBN'
5589: AND NVL(jcta.reverse_charge_flag,'N') = 'Y'

Line 5745: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */

5741: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
5742: select attribute_code tax_type
5743: from JAI_RGM_REGISTRATIONS
5744: where regime_id = cp_regime_id
5745: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
5746: and attribute_code = cp_tax_type;
5747:
5748: /*Added by kunkumar for bug#5593895*/
5749: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is

Line 5978: open c_jai_regimes(jai_constants.service_regime);

5974:
5975: lv_accrue_on_receipt_flag :=
5976: jai_rcv_trx_processing_pkg.get_accrue_on_receipt(p_po_distribution_id => po_dist_id);
5977:
5978: open c_jai_regimes(jai_constants.service_regime);
5979: fetch c_jai_regimes into r_jai_regimes;
5980: close c_jai_regimes;
5981:
5982: /* service End */

Line 6050: p_organization_type => jai_constants.orgn_type_io,

6046: /* Service type of tax */
6047: v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
6048: (
6049: p_regime_id => r_jai_regimes.regime_id,
6050: p_organization_type => jai_constants.orgn_type_io,
6051: p_organization_id => ln_ship_to_organization_id,
6052: p_location_id => ln_ship_to_location_id,
6053: p_tax_type => c_tax_rec.tax_type,
6054: p_account_name => GV_REVERSE_CHARGE

Line 6059: p_organization_type => jai_constants.orgn_type_io,

6055: );
6056: v_dist_ccid_liability := jai_cmn_rgm_recording_pkg.get_account
6057: (
6058: p_regime_id => r_jai_regimes.regime_id,
6059: p_organization_type => jai_constants.orgn_type_io,
6060: p_organization_id => ln_ship_to_organization_id,
6061: p_location_id => ln_ship_to_location_id,
6062: p_tax_type => c_tax_rec.tax_type,
6063: p_account_name => GV_INTERIM_LIABILITY

Line 6109: if tax_lines1_rec.modvat_flag = jai_constants.YES

6105:
6106: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
6107: 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
6108:
6109: if tax_lines1_rec.modvat_flag = jai_constants.YES
6110: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
6111: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
6112: then
6113: --

Line 6152: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

6148:
6149: v_tax_amount := ln_nrec_tax_amt;
6150: lv_tax_line_amount := v_tax_amount ;
6151:
6152: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6153: v_assets_tracking_flag := jai_constants.YES;
6154: END IF;
6155:
6156: lv_modvat_flag := jai_constants.NO ;

Line 6153: v_assets_tracking_flag := jai_constants.YES;

6149: v_tax_amount := ln_nrec_tax_amt;
6150: lv_tax_line_amount := v_tax_amount ;
6151:
6152: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6153: v_assets_tracking_flag := jai_constants.YES;
6154: END IF;
6155:
6156: lv_modvat_flag := jai_constants.NO ;
6157:

Line 6156: lv_modvat_flag := jai_constants.NO ;

6152: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6153: v_assets_tracking_flag := jai_constants.YES;
6154: END IF;
6155:
6156: lv_modvat_flag := jai_constants.NO ;
6157:
6158: --
6159: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
6160: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 6594: p_organization_type => jai_constants.orgn_type_io,

6590: /* Service type of tax */
6591: v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
6592: (
6593: p_regime_id => r_jai_regimes.regime_id,
6594: p_organization_type => jai_constants.orgn_type_io,
6595: p_organization_id => ln_ship_to_organization_id,
6596: p_location_id => ln_ship_to_location_id,
6597: p_tax_type => c_tax_rec.tax_type,
6598: p_account_name => GV_REVERSE_CHARGE

Line 6603: p_organization_type => jai_constants.orgn_type_io,

6599: );
6600: v_dist_ccid_liability := jai_cmn_rgm_recording_pkg.get_account
6601: (
6602: p_regime_id => r_jai_regimes.regime_id,
6603: p_organization_type => jai_constants.orgn_type_io,
6604: p_organization_id => ln_ship_to_organization_id,
6605: p_location_id => ln_ship_to_location_id,
6606: p_tax_type => c_tax_rec.tax_type,
6607: p_account_name => GV_INTERIM_LIABILITY

Line 6642: if i.modvat_flag = jai_constants.YES

6638:
6639: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
6640: 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
6641:
6642: if i.modvat_flag = jai_constants.YES
6643: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
6644: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
6645: then
6646: --

Line 6683: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

6679:
6680: v_tax_amount := ln_nrec_tax_amt;
6681: lv_tax_line_amount := v_tax_amount ;
6682:
6683: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6684: v_assets_tracking_flag := jai_constants.YES;
6685: END IF;
6686:
6687: lv_modvat_flag := jai_constants.NO ;

Line 6684: v_assets_tracking_flag := jai_constants.YES;

6680: v_tax_amount := ln_nrec_tax_amt;
6681: lv_tax_line_amount := v_tax_amount ;
6682:
6683: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6684: v_assets_tracking_flag := jai_constants.YES;
6685: END IF;
6686:
6687: lv_modvat_flag := jai_constants.NO ;
6688:

Line 6687: lv_modvat_flag := jai_constants.NO ;

6683: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6684: v_assets_tracking_flag := jai_constants.YES;
6685: END IF;
6686:
6687: lv_modvat_flag := jai_constants.NO ;
6688:
6689: --
6690: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
6691: -- projects related columns so that PROJECTS can consider this line for Project Costing