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 4271: FROM ZX_PTNR_NEG_TAX_LINE_GT

4267: -- Start : Identify Tax event type --
4268: BEGIN
4269: SELECT count(*)
4270: INTO l_neg_tax_line_count
4271: FROM ZX_PTNR_NEG_TAX_LINE_GT
4272: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4273: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4274: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
4275: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)

Line 4282: ' Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');

4278: EXCEPTION
4279: WHEN OTHERS THEN
4280: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4282: ' Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');
4283: END IF;
4284: END;
4285:
4286: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4288: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_neg_tax_line_count);

4284: END;
4285:
4286: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4287: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4288: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_neg_tax_line_count);
4289: END IF;
4290:
4291: -- Added the code to get the count from ZX_PTNR_NEG_LINE_GT to handle
4292: -- UPDATE event. Code changed for Bug#12544630

Line 4315: -- Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.

4311: ' No of records in ZX_PTNR_NEG_LINE_GT = ' || l_neg_trx_line_count);
4312: END IF;
4313: -- End --
4314:
4315: -- Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
4316: -- Deleted line is passed thru zx_sync_tax_lines_input_v and there is
4317: -- no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT
4318:
4319: -- Changed logic to set the event type

Line 4317: -- no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT

4313: -- End --
4314:
4315: -- Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
4316: -- Deleted line is passed thru zx_sync_tax_lines_input_v and there is
4317: -- no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT
4318:
4319: -- Changed logic to set the event type
4320: -- Code changed for Bug#12544630
4321: -- Start --

Line 4380: FROM ZX_PTNR_NEG_TAX_LINE_GT

4376: IF l_neg_tax_line_count = 1 THEN
4377: BEGIN
4378: SELECT tax_amount
4379: INTO l_amount
4380: FROM ZX_PTNR_NEG_TAX_LINE_GT
4381: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4382: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4383: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
4384: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)

Line 4405: from ZX_PTNR_NEG_TAX_LINE_GT

4401: l_write_record:=TRUE;
4402: ELSIF(l_event_type='TAX_LINE_DELETE')then
4403: select tax_amount
4404: into l_amount
4405: from ZX_PTNR_NEG_TAX_LINE_GT
4406: where trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt) and
4407: trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt);
4408:
4409: create_tax_line(SYNC_TAX_LINES.tax(sync_tax_cnt),-1*l_amount,l_return_status);

Line 4503: FROM ZX_PTNR_NEG_TAX_LINE_GT

4499:
4500: BEGIN
4501: SELECT COUNT(*)
4502: INTO l_neg_tax_line_count
4503: FROM ZX_PTNR_NEG_TAX_LINE_GT
4504: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt1)
4505: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt1)
4506: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt1)
4507: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt1)

Line 4514: 'Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');

4510: EXCEPTION
4511: WHEN OTHERS THEN
4512: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4514: 'Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');
4515: END IF;
4516: END;
4517:
4518: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4520: 'No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_neg_tax_line_count);

4516: END;
4517:
4518: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4519: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4520: 'No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_neg_tax_line_count);
4521: END IF;
4522:
4523: BEGIN
4524: SELECT COUNT(*)