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_VERTEX_TAX_SERVICE_PKG dependencies on ZX_PTNR_NEG_TAX_LINE_GT

Line 4407: FROM ZX_PTNR_NEG_TAX_LINE_GT

4403: /* Identify Tax event type -Start*/
4404: BEGIN
4405: SELECT count(*)
4406: INTO l_count
4407: FROM ZX_PTNR_NEG_TAX_LINE_GT
4408: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4409: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4410: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
4411: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)

Line 4418: ' Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');

4414: EXCEPTION
4415: WHEN OTHERS THEN
4416: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4417: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4418: ' Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');
4419: END IF;
4420: END;
4421:
4422: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

4420: END;
4421:
4422: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4423: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4424: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_count);
4425: END IF;
4426:
4427: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
4428: Deleted line is passed thru zx_sync_tax_lines_input_v and there is

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

4423: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4424: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_count);
4425: END IF;
4426:
4427: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
4428: Deleted line is passed thru zx_sync_tax_lines_input_v and there is
4429: no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */
4430:
4431: IF (l_count=1) THEN /*Line is present. Hence, it is an UPDATE action */

Line 4429: no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */

4425: END IF;
4426:
4427: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
4428: Deleted line is passed thru zx_sync_tax_lines_input_v and there is
4429: no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */
4430:
4431: IF (l_count=1) THEN /*Line is present. Hence, it is an UPDATE action */
4432: l_event_type :='TAX_LINE_UPDATE';
4433: ELSIF (l_count=0) THEN

Line 4484: FROM ZX_PTNR_NEG_TAX_LINE_GT

4480: IF (l_event_type='TAX_LINE_UPDATE') THEN
4481: BEGIN
4482: SELECT tax_amount
4483: INTO l_amount
4484: FROM ZX_PTNR_NEG_TAX_LINE_GT
4485: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4486: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4487: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
4488: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)

Line 4508: from ZX_PTNR_NEG_TAX_LINE_GT

4504: ELSIF(l_event_type='TAX_LINE_DELETE')then
4505: /*
4506: select tax_amount
4507: into l_amount
4508: from ZX_PTNR_NEG_TAX_LINE_GT
4509: where trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt) and
4510: trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt);
4511: */
4512: