APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_PTNR_NEG_TAX_LINE_GT

Line 4710: FROM ZX_PTNR_NEG_TAX_LINE_GT

4706: -- Start : Identify Tax event type --
4707: BEGIN
4708: SELECT COUNT(*)
4709: INTO l_neg_tax_line_count
4710: FROM ZX_PTNR_NEG_TAX_LINE_GT
4711: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4712: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4713: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
4714: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)

Line 4721: 'Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');

4717: EXCEPTION
4718: WHEN OTHERS THEN
4719: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4721: 'Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');
4722: END IF;
4723: END;
4724:
4725: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

4723: END;
4724:
4725: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4726: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4727: 'No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_neg_tax_line_count);
4728: END IF;
4729:
4730: -- Added the code to get the count from ZX_PTNR_NEG_LINE_GT to handle
4731: -- UPDATE event. Code changed for Bug#12544630

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

4750: ' No of records in ZX_PTNR_NEG_LINE_GT = ' || l_neg_trx_line_count);
4751: END IF;
4752: -- End --
4753:
4754: -- Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
4755: -- Deleted line is passed thru zx_sync_tax_lines_input_v and there is
4756: -- no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT
4757:
4758: -- Changed logic to set the event type

Line 4756: -- no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT

4752: -- End --
4753:
4754: -- Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
4755: -- Deleted line is passed thru zx_sync_tax_lines_input_v and there is
4756: -- no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT
4757:
4758: -- Changed logic to set the event type
4759: -- Code changed for Bug#12544630
4760: -- Start --

Line 4821: FROM ZX_PTNR_NEG_TAX_LINE_GT

4817: IF l_neg_tax_line_count = 1 THEN
4818: BEGIN
4819: SELECT tax_amount
4820: INTO l_amount
4821: FROM ZX_PTNR_NEG_TAX_LINE_GT
4822: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4823: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4824: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
4825: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)

Line 5015: FROM ZX_PTNR_NEG_TAX_LINE_GT

5011:
5012: BEGIN
5013: SELECT COUNT(*)
5014: INTO l_neg_tax_line_count
5015: FROM ZX_PTNR_NEG_TAX_LINE_GT
5016: WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt1)
5017: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt1)
5018: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt1)
5019: AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt1)

Line 5026: 'Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');

5022: EXCEPTION
5023: WHEN OTHERS THEN
5024: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5025: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5026: 'Error while accessing ZX_PTNR_NEG_TAX_LINE_GT');
5027: END IF;
5028: END;
5029:
5030: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

5028: END;
5029:
5030: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5031: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5032: 'No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_neg_tax_line_count);
5033: END IF;
5034:
5035: BEGIN
5036: SELECT COUNT(*)