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 3606: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

3602: OPEN UPDATE_TAX_DIST;
3603: LOOP
3604: FETCH UPDATE_TAX_DIST
3605: BULK COLLECT INTO L_INV_DIST_UPD
3606: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
3607:
3608: EXIT WHEN UPDATE_TAX_DIST%NOTFOUND
3609: AND L_INV_DIST_UPD.COUNT <= 0;
3610:

Line 3724: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

3720: OPEN UPDATE_TAX_VARIANCES;
3721: LOOP
3722: FETCH UPDATE_TAX_VARIANCES
3723: BULK COLLECT INTO L_INV_DIST_UPD
3724: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
3725:
3726: EXIT WHEN UPDATE_TAX_VARIANCES%NOTFOUND
3727: AND L_INV_DIST_UPD.COUNT <= 0;
3728:

Line 3840: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

3836: OPEN UPDATE_TAX_SELF;
3837: LOOP
3838: FETCH UPDATE_TAX_SELF
3839: BULK COLLECT INTO L_INV_SELF_UPD
3840: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
3841:
3842: EXIT WHEN UPDATE_TAX_SELF%NOTFOUND
3843: AND L_INV_DIST_UPD.COUNT <= 0;
3844:

Line 3953: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

3949: OPEN INSERT_TAX_DIST;
3950: LOOP
3951: FETCH INSERT_TAX_DIST
3952: BULK COLLECT INTO L_INV_DIST_INS
3953: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
3954:
3955: EXIT WHEN INSERT_TAX_DIST%NOTFOUND
3956: AND L_INV_DIST_INS.COUNT <= 0;
3957:

Line 4146: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

4142: OPEN INSERT_TAX_VARIANCES;
4143: LOOP
4144: FETCH INSERT_TAX_VARIANCES
4145: BULK COLLECT INTO L_INV_DIST_INS
4146: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
4147:
4148: EXIT WHEN INSERT_TAX_VARIANCES%NOTFOUND
4149: AND L_INV_DIST_INS.COUNT <= 0;
4150:

Line 4212: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

4208: OPEN INSERT_TAX_SELF;
4209: LOOP
4210: FETCH INSERT_TAX_SELF
4211: BULK COLLECT INTO L_INV_SELF_INS
4212: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
4213:
4214: EXIT WHEN INSERT_TAX_SELF%NOTFOUND
4215: AND L_INV_SELF_INS.COUNT <= 0;
4216:

Line 4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

4735: (SELECT /*+ leading(gt) cardinality(gt,1) */
4736: dist.invoice_distribution_id
4737: FROM zx_trx_headers_gt gt,
4738: ap_invoice_distributions_all dist
4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4741: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4742: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4743: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

4736: dist.invoice_distribution_id
4737: FROM zx_trx_headers_gt gt,
4738: ap_invoice_distributions_all dist
4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4741: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4742: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4743: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4744: AND gt.trx_id = dist.invoice_id

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

4737: FROM zx_trx_headers_gt gt,
4738: ap_invoice_distributions_all dist
4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4741: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4742: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4743: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4744: AND gt.trx_id = dist.invoice_id
4745: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')

Line 4742: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

4738: ap_invoice_distributions_all dist
4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4741: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4742: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4743: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4744: AND gt.trx_id = dist.invoice_id
4745: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
4746: AND NOT EXISTS

Line 4743: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4741: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4742: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4743: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4744: AND gt.trx_id = dist.invoice_id
4745: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
4746: AND NOT EXISTS
4747: (SELECT 'Tax Distributions'

Line 4767: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

4763: (SELECT /*+ leading(gt) cardinality(gt,1) */
4764: dist.invoice_distribution_id
4765: FROM zx_trx_headers_gt gt,
4766: ap_self_assessed_tax_dist_all dist
4767: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4768: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4769: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4770: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4771: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 4768: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

4764: dist.invoice_distribution_id
4765: FROM zx_trx_headers_gt gt,
4766: ap_self_assessed_tax_dist_all dist
4767: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4768: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4769: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4770: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4771: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4772: AND gt.trx_id = dist.invoice_id

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

4765: FROM zx_trx_headers_gt gt,
4766: ap_self_assessed_tax_dist_all dist
4767: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4768: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4769: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4770: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4771: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4772: AND gt.trx_id = dist.invoice_id
4773: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')

Line 4770: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

4766: ap_self_assessed_tax_dist_all dist
4767: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4768: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4769: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4770: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4771: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4772: AND gt.trx_id = dist.invoice_id
4773: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')
4774: AND NOT EXISTS

Line 4771: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

4767: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4768: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4769: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4770: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
4771: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
4772: AND gt.trx_id = dist.invoice_id
4773: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')
4774: AND NOT EXISTS
4775: (SELECT 'Tax Distributions'