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

Line 227: (JAI_CONSTANTS.TAX_TYPE_EXCISE,

223: WHERE JAMIT.INVOICE_DISTRIBUTION_ID =
224: AIDA.INVOICE_DISTRIBUTION_ID
225: AND JCT.TAX_ID = JAMIT.TAX_ID
226: AND UPPER(JCT.TAX_TYPE) IN
227: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
228: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

Line 228: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,

224: AIDA.INVOICE_DISTRIBUTION_ID
225: AND JCT.TAX_ID = JAMIT.TAX_ID
226: AND UPPER(JCT.TAX_TYPE) IN
227: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
228: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

Line 229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,

225: AND JCT.TAX_ID = JAMIT.TAX_ID
226: AND UPPER(JCT.TAX_TYPE) IN
227: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
228: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,

Line 230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,

226: AND UPPER(JCT.TAX_TYPE) IN
227: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
228: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
234: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))

Line 231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

227: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
228: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
234: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
235: AND NOT EXISTS (SELECT '1'

Line 232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

228: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
234: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
235: AND NOT EXISTS (SELECT '1'
236: FROM AP_INVOICES_ALL

Line 233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,

229: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
234: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
235: AND NOT EXISTS (SELECT '1'
236: FROM AP_INVOICES_ALL
237: WHERE INVOICE_ID = p_inv_id

Line 234: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))

230: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
231: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
234: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
235: AND NOT EXISTS (SELECT '1'
236: FROM AP_INVOICES_ALL
237: WHERE INVOICE_ID = p_inv_id
238: AND SOURCE = 'INDIA TDS')

Line 405: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)

401: AND JCTA.TAX_TYPE IN (SELECT ATTRIBUTE_CODE
402: FROM JAI_RGM_REGISTRATIONS
403: WHERE REGIME_ID = (SELECT REGIME_ID
404: FROM JAI_RGM_DEFINITIONS
405: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)
406: AND REGISTRATION_TYPE = 'TAX_TYPES');
407:
408: -- cursor to Check if Service Tax exists for PO matched Invoice
409: cursor c_po_matched_st_line (cp_inv_dist_id number)

Line 421: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)

417: AND JCTA.TAX_TYPE IN (SELECT ATTRIBUTE_CODE
418: FROM JAI_RGM_REGISTRATIONS
419: WHERE REGIME_ID = (SELECT REGIME_ID
420: FROM JAI_RGM_DEFINITIONS
421: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)
422: AND REGISTRATION_TYPE = 'TAX_TYPES');
423:
424: -- cursor to get parent distribution id for po matched
425: cursor c_get_po_matched_dist_id (cp_inv_dist_id number)

Line 2242: (JAI_CONSTANTS.TAX_TYPE_EXCISE,

2238: WHERE JAMIT.INVOICE_DISTRIBUTION_ID =
2239: AIDA.INVOICE_DISTRIBUTION_ID
2240: AND JCT.TAX_ID = JAMIT.TAX_ID
2241: AND JCT.TAX_TYPE IN
2242: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2243: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

Line 2243: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,

2239: AIDA.INVOICE_DISTRIBUTION_ID
2240: AND JCT.TAX_ID = JAMIT.TAX_ID
2241: AND JCT.TAX_TYPE IN
2242: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2243: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

Line 2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,

2240: AND JCT.TAX_ID = JAMIT.TAX_ID
2241: AND JCT.TAX_TYPE IN
2242: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2243: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2248: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,

Line 2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,

2241: AND JCT.TAX_TYPE IN
2242: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2243: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2248: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2249: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))

Line 2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

2242: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2243: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2248: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2249: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2250: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin

Line 2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

2243: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2248: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2249: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2250: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2251: AND AMOUNT > 0

Line 2248: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,

2244: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2248: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2249: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2250: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2251: AND AMOUNT > 0
2252: AND NVL(REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null

Line 2249: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))

2245: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2246: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2247: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2248: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2249: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2250: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2251: AND AMOUNT > 0
2252: AND NVL(REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null
2253: AND NOT EXISTS (SELECT 1

Line 2371: (JAI_CONSTANTS.TAX_TYPE_EXCISE,

2367: WHERE JAMIT.INVOICE_DISTRIBUTION_ID =
2368: AIDA.INVOICE_DISTRIBUTION_ID
2369: AND JCT.TAX_ID = JAMIT.TAX_ID
2370: AND JCT.TAX_TYPE IN
2371: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2372: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

Line 2372: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,

2368: AIDA.INVOICE_DISTRIBUTION_ID
2369: AND JCT.TAX_ID = JAMIT.TAX_ID
2370: AND JCT.TAX_TYPE IN
2371: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2372: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

Line 2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,

2369: AND JCT.TAX_ID = JAMIT.TAX_ID
2370: AND JCT.TAX_TYPE IN
2371: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2372: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2377: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,

Line 2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,

2370: AND JCT.TAX_TYPE IN
2371: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2372: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2377: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2378: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))

Line 2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

2371: (JAI_CONSTANTS.TAX_TYPE_EXCISE,
2372: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2377: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2378: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2379: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin

Line 2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

2372: JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL,
2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2377: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2378: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2379: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2380: AND AIDA.AMOUNT > 0

Line 2377: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,

2373: JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2377: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2378: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2379: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2380: AND AIDA.AMOUNT > 0
2381: AND NVL(AIDA.REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null

Line 2378: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))

2374: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS,
2375: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2376: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
2377: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2378: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
2379: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2380: AND AIDA.AMOUNT > 0
2381: AND NVL(AIDA.REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null
2382: AND NOT EXISTS (SELECT 1