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.ZX_TAXWARE_TAX_SERVICE_PKG dependencies on ZX_PTNR_NEG_TAX_LINE_GT

Line 3929: FROM ZX_PTNR_NEG_TAX_LINE_GT

3925: /* Identify Tax event type -Start*/
3926: BEGIN
3927: SELECT count(*)
3928: INTO l_count
3929: FROM ZX_PTNR_NEG_TAX_LINE_GT
3930: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
3931: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
3932: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
3933: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)

Line 3940: ' Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');

3936: EXCEPTION
3937: WHEN OTHERS THEN
3938: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3939: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3940: ' Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');
3941: END IF;
3942: END;
3943:
3944: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3946: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_count);

3942: END;
3943:
3944: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3945: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3946: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_count);
3947: END IF;
3948:
3949: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
3950: Deleted line is passed thru zx_sync_tax_lines_input_v and there is

Line 3949: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.

3945: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3946: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_count);
3947: END IF;
3948:
3949: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
3950: Deleted line is passed thru zx_sync_tax_lines_input_v and there is
3951: no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */
3952:
3953: IF (l_count=1) THEN /*Line is present. Hence, it is an UPDATE action */

Line 3951: no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */

3947: END IF;
3948:
3949: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
3950: Deleted line is passed thru zx_sync_tax_lines_input_v and there is
3951: no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */
3952:
3953: IF (l_count=1) THEN /*Line is present. Hence, it is an UPDATE action */
3954: l_event_type :='TAX_LINE_UPDATE';
3955: ELSIF (l_count=0) THEN

Line 3999: from ZX_PTNR_NEG_TAX_LINE_GT

3995:
3996: ELSIF(l_event_type='TAX_LINE_DELETE')then
3997: select tax_amount
3998: into l_amount
3999: from ZX_PTNR_NEG_TAX_LINE_GT
4000: where trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt) and
4001: trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt);
4002:
4003: create_tax_line(SYNC_TAX_LINES.tax(sync_tax_cnt),-1*l_amount,l_return_status);