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.AP_ETAX_UTILITY_PKG dependencies on AP_ETAX_PKG

Line 2410: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

2406: AND (aid.accounting_event_id IS NOT NULL OR
2407: NVL(aid.match_status_flag,'N') IN ('A','T') OR
2408: NVL(aid.posted_flag,'N') ='Y' OR
2409: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2410: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2411: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2412: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2413: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2414: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 2411: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

2407: NVL(aid.match_status_flag,'N') IN ('A','T') OR
2408: NVL(aid.posted_flag,'N') ='Y' OR
2409: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2410: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2411: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2412: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2413: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2414: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2415: AND gt.trx_id = aid.invoice_id

Line 2412: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

2408: NVL(aid.posted_flag,'N') ='Y' OR
2409: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2410: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2411: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2412: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2413: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2414: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2415: AND gt.trx_id = aid.invoice_id
2416: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions' -- 9485828

Line 2413: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

2409: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2410: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2411: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2412: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2413: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2414: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2415: AND gt.trx_id = aid.invoice_id
2416: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions' -- 9485828
2417: FROM zx_rec_nrec_dist zd

Line 2414: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

2410: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2411: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2412: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2413: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2414: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2415: AND gt.trx_id = aid.invoice_id
2416: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions' -- 9485828
2417: FROM zx_rec_nrec_dist zd
2418: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id

Line 2439: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

2435: AND (aid.accounting_event_id IS NOT NULL OR
2436: NVL(aid.match_status_flag,'N') IN ('A','T') OR
2437: NVL(aid.posted_flag,'N') ='Y' OR
2438: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2439: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2440: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2441: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2442: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2443: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 2440: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

2436: NVL(aid.match_status_flag,'N') IN ('A','T') OR
2437: NVL(aid.posted_flag,'N') ='Y' OR
2438: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2439: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2440: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2441: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2442: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2443: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2444: AND gt.trx_id = aid.invoice_id

Line 2441: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

2437: NVL(aid.posted_flag,'N') ='Y' OR
2438: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2439: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2440: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2441: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2442: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2443: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2444: AND gt.trx_id = aid.invoice_id
2445: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions' -- 9485828

Line 2442: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

2438: NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
2439: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2440: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2441: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2442: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2443: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2444: AND gt.trx_id = aid.invoice_id
2445: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions' -- 9485828
2446: FROM zx_rec_nrec_dist zd

Line 2443: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

2439: AND gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2440: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2441: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2442: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2443: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2444: AND gt.trx_id = aid.invoice_id
2445: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions' -- 9485828
2446: FROM zx_rec_nrec_dist zd
2447: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id

Line 4103: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

4099: OPEN UPDATE_TAX_DIST;
4100: LOOP
4101: FETCH UPDATE_TAX_DIST
4102: BULK COLLECT INTO L_INV_DIST_UPD
4103: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
4104:
4105: EXIT WHEN UPDATE_TAX_DIST%NOTFOUND
4106: AND L_INV_DIST_UPD.COUNT <= 0;
4107:

Line 4257: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

4253: OPEN UPDATE_TAX_VARIANCES;
4254: LOOP
4255: FETCH UPDATE_TAX_VARIANCES
4256: BULK COLLECT INTO L_INV_DIST_UPD
4257: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
4258:
4259: EXIT WHEN UPDATE_TAX_VARIANCES%NOTFOUND
4260: AND L_INV_DIST_UPD.COUNT <= 0;
4261:

Line 4408: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

4404: OPEN UPDATE_TAX_SELF;
4405: LOOP
4406: FETCH UPDATE_TAX_SELF
4407: BULK COLLECT INTO L_INV_SELF_UPD
4408: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
4409:
4410: EXIT WHEN UPDATE_TAX_SELF%NOTFOUND
4411: AND l_inv_self_upd.COUNT <= 0; --Bug13859326
4412:

Line 4546: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

4542: LOOP
4543:
4544: FETCH INSERT_TAX_DIST
4545: BULK COLLECT INTO L_INV_DIST_INS
4546: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
4547:
4548: EXIT WHEN INSERT_TAX_DIST%NOTFOUND
4549: AND L_INV_DIST_INS.COUNT <= 0;
4550:

Line 4997: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

4993: LOOP
4994:
4995: FETCH INSERT_TAX_VARIANCES
4996: BULK COLLECT INTO L_INV_DIST_INS
4997: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
4998:
4999: EXIT WHEN INSERT_TAX_VARIANCES%NOTFOUND
5000: AND L_INV_DIST_INS.COUNT <= 0;
5001:

Line 5174: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

5170: LOOP
5171:
5172: FETCH INSERT_TAX_SELF
5173: BULK COLLECT INTO L_INV_SELF_INS
5174: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
5175:
5176: EXIT WHEN INSERT_TAX_SELF%NOTFOUND
5177: AND L_INV_SELF_INS.COUNT <= 0;
5178:

Line 5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

5815: (SELECT /*+ leading(gt) cardinality(gt,1) */
5816: dist.invoice_distribution_id
5817: FROM zx_trx_headers_gt gt,
5818: ap_invoice_distributions_all dist
5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5822: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5823: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

5816: dist.invoice_distribution_id
5817: FROM zx_trx_headers_gt gt,
5818: ap_invoice_distributions_all dist
5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5822: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5823: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5824: AND gt.trx_id = dist.invoice_id

Line 5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

5817: FROM zx_trx_headers_gt gt,
5818: ap_invoice_distributions_all dist
5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5822: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5823: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5824: AND gt.trx_id = dist.invoice_id
5825: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')

Line 5822: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

5818: ap_invoice_distributions_all dist
5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5822: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5823: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5824: AND gt.trx_id = dist.invoice_id
5825: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
5826: AND NOT EXISTS

Line 5823: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5822: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5823: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5824: AND gt.trx_id = dist.invoice_id
5825: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
5826: AND NOT EXISTS
5827: (SELECT 'Tax Distributions'

Line 5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

5910: (SELECT /*+ leading(gt) cardinality(gt,1) */
5911: dist.invoice_distribution_id
5912: FROM zx_trx_headers_gt gt,
5913: ap_self_assessed_tax_dist_all dist
5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5917: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5918: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

5911: dist.invoice_distribution_id
5912: FROM zx_trx_headers_gt gt,
5913: ap_self_assessed_tax_dist_all dist
5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5917: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5918: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5919: AND gt.trx_id = dist.invoice_id

Line 5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

5912: FROM zx_trx_headers_gt gt,
5913: ap_self_assessed_tax_dist_all dist
5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5917: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5918: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5919: AND gt.trx_id = dist.invoice_id
5920: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')

Line 5917: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

5913: ap_self_assessed_tax_dist_all dist
5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5917: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5918: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5919: AND gt.trx_id = dist.invoice_id
5920: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')
5921: AND NOT EXISTS

Line 5918: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5917: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5918: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5919: AND gt.trx_id = dist.invoice_id
5920: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')
5921: AND NOT EXISTS
5922: (SELECT 'Tax Distributions'

Line 10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

10399:
10400: SELECT 'Tax Only Line Exist'
10401: INTO l_dummy
10402: FROM zx_lines_summary zls
10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
10407: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

10400: SELECT 'Tax Only Line Exist'
10401: INTO l_dummy
10402: FROM zx_lines_summary zls
10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
10407: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
10408: AND zls.trx_id = p_invoice_id

Line 10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

10401: INTO l_dummy
10402: FROM zx_lines_summary zls
10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
10407: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
10408: AND zls.trx_id = p_invoice_id
10409: AND NVL(zls.reporting_only_flag, 'N') = 'N'

Line 10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

10402: FROM zx_lines_summary zls
10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
10407: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
10408: AND zls.trx_id = p_invoice_id
10409: AND NVL(zls.reporting_only_flag, 'N') = 'N'
10410: AND NVL(zls.tax_only_line_flag, 'N') = 'Y'

Line 10407: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
10407: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
10408: AND zls.trx_id = p_invoice_id
10409: AND NVL(zls.reporting_only_flag, 'N') = 'N'
10410: AND NVL(zls.tax_only_line_flag, 'N') = 'Y'
10411: AND rownum = 1;