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_LINE_GT

Line 874: FROM ZX_PTNR_NEG_LINE_GT;

870:
871: BEGIN
872: SELECT count(*)
873: INTO l_cnt_of_ptnr_neg_line_gt
874: FROM ZX_PTNR_NEG_LINE_GT;
875: EXCEPTION WHEN OTHERS THEN
876: l_cnt_of_ptnr_neg_line_gt := 0;
877: END;
878:

Line 1447: DELETE FROM zx_ptnr_neg_line_gt

1443: return;
1444: END IF;
1445:
1446: BEGIN
1447: DELETE FROM zx_ptnr_neg_line_gt
1448: WHERE event_class_mapping_id = pg_doc_type_id_tab(I)
1449: and trx_id = pg_trx_id_tab(I)
1450: and trx_line_id = pg_trx_line_id_tab(I)
1451: and trx_level_type = pg_trx_level_type_tab(I);

Line 1971: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;

1967:
1968: PROCEDURE SET_PARAMETERS(x_return_status OUT NOCOPY VARCHAR2) IS
1969:
1970: /*Following variables used during line deletion process.*/
1971: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1972: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1973: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1974: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1975: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;

Line 1972: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;

1968: PROCEDURE SET_PARAMETERS(x_return_status OUT NOCOPY VARCHAR2) IS
1969:
1970: /*Following variables used during line deletion process.*/
1971: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1972: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1973: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1974: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1975: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1976: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;

Line 1973: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;

1969:
1970: /*Following variables used during line deletion process.*/
1971: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1972: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1973: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1974: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1975: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1976: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1977: arp_ship_to_grphy_type1 VARCHAR2(30);

Line 1974: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;

1970: /*Following variables used during line deletion process.*/
1971: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1972: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1973: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1974: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1975: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1976: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1977: arp_ship_to_grphy_type1 VARCHAR2(30);
1978: arp_ship_to_grphy_value1 VARCHAR2(30);

Line 1975: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;

1971: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1972: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1973: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1974: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1975: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1976: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1977: arp_ship_to_grphy_type1 VARCHAR2(30);
1978: arp_ship_to_grphy_value1 VARCHAR2(30);
1979: arp_ship_to_grphy_type2 VARCHAR2(30);

Line 1976: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;

1972: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1973: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1974: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1975: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1976: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1977: arp_ship_to_grphy_type1 VARCHAR2(30);
1978: arp_ship_to_grphy_value1 VARCHAR2(30);
1979: arp_ship_to_grphy_type2 VARCHAR2(30);
1980: arp_ship_to_grphy_value2 VARCHAR2(30);

Line 2549: FROM ZX_PTNR_NEG_LINE_GT

2545: arp_transaction_date,
2546: arp_adjusted_doc_date,
2547: arp_trx_date,
2548: arp_exemption_control_flag
2549: FROM ZX_PTNR_NEG_LINE_GT
2550: WHERE trx_line_id= pg_trx_line_id_tab(I);
2551:
2552:
2553: IF substrb(nvl(arp_ship_from_add,'XXXXXXXXX'), 2,9)='XXXXXXXXX' THEN

Line 4141: FROM zx_ptnr_neg_line_gt

4137: l_neg_line_gt_exists := 0;
4138: BEGIN
4139: SELECT 1
4140: INTO l_neg_line_gt_exists
4141: FROM zx_ptnr_neg_line_gt
4142: WHERE event_class_mapping_id = p_evnt_cls_mapping_id
4143: AND trx_id = p_transaction_id
4144: AND trx_line_id = p_transaction_line_id
4145: AND trx_level_type = p_trx_level_type;

Line 4151: /* For given transaction line id, record already exists in zx_ptnr_neg_line_gt, then there is no need to recreate it */

4147: WHEN OTHERS THEN
4148: l_neg_line_gt_exists := 0;
4149: END;
4150:
4151: /* For given transaction line id, record already exists in zx_ptnr_neg_line_gt, then there is no need to recreate it */
4152:
4153: IF l_neg_line_gt_exists <> 0 THEN
4154: RETURN;
4155: END IF;

Line 4730: -- Added the code to get the count from ZX_PTNR_NEG_LINE_GT to handle

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
4732: -- Start --
4733: BEGIN
4734: SELECT COUNT(*)

Line 4736: FROM ZX_PTNR_NEG_LINE_GT

4732: -- Start --
4733: BEGIN
4734: SELECT COUNT(*)
4735: INTO l_neg_trx_line_count
4736: FROM ZX_PTNR_NEG_LINE_GT
4737: WHERE event_class_mapping_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4738: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4739: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt);
4740: EXCEPTION

Line 4744: ' Error while accessing ZX_PTNR_NEG_LINE_GT');

4740: EXCEPTION
4741: WHEN OTHERS THEN
4742: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4743: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4744: ' Error while accessing ZX_PTNR_NEG_LINE_GT');
4745: END IF;
4746: END;
4747:
4748: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4750: ' No of records in ZX_PTNR_NEG_LINE_GT = ' || l_neg_trx_line_count);

4746: END;
4747:
4748: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4749: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
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.

Line 5038: FROM ZX_PTNR_NEG_LINE_GT

5034:
5035: BEGIN
5036: SELECT COUNT(*)
5037: INTO l_neg_trx_line_count
5038: FROM ZX_PTNR_NEG_LINE_GT
5039: WHERE event_class_mapping_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt1)
5040: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt1)
5041: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt1);
5042: EXCEPTION

Line 5046: ' Error while accessing ZX_PTNR_NEG_LINE_GT');

5042: EXCEPTION
5043: WHEN OTHERS THEN
5044: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5045: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5046: ' Error while accessing ZX_PTNR_NEG_LINE_GT');
5047: END IF;
5048: END;
5049:
5050: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5052: ' No of records in ZX_PTNR_NEG_LINE_GT = ' || l_neg_trx_line_count);

5048: END;
5049:
5050: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5051: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5052: ' No of records in ZX_PTNR_NEG_LINE_GT = ' || l_neg_trx_line_count);
5053: END IF;
5054:
5055: IF (l_neg_tax_line_count = 1 OR l_neg_trx_line_count = 1) THEN -- Line is present. Hence, it is an UPDATE action --
5056: l_event_type := 'TAX_LINE_UPDATE';

Line 5279: FROM ZX_PTNR_NEG_LINE_GT;

5275: 'l_cnt_of_loc_info_gt = '||l_cnt_of_loc_info_gt);
5276: BEGIN
5277: SELECT count(*)
5278: INTO l_cnt_of_neg_line_gt
5279: FROM ZX_PTNR_NEG_LINE_GT;
5280: EXCEPTION WHEN OTHERS THEN
5281: l_cnt_of_neg_line_gt := 0;
5282: END;
5283: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5389: FROM ZX_PTNR_NEG_LINE_GT

5385: pg_adj_doc_trx_id_tab,
5386: pg_adj_doc_line_id_tab,
5387: pg_adj_doc_trx_lev_type_tab,
5388: pg_adj_doc_doc_type_id_tab
5389: FROM ZX_PTNR_NEG_LINE_GT
5390: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
5391: AND trx_id = x_transaction_rec.transaction_id;
5392: END;
5393:

Line 5415: FROM ZX_PTNR_NEG_LINE_GT

5411: -- Call Set Document Type
5412:
5413: SELECT SUM(ABS(line_amt))
5414: INTO l_doc_amount
5415: FROM ZX_PTNR_NEG_LINE_GT
5416: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
5417: AND trx_id = x_transaction_rec.transaction_id;
5418:
5419: SET_DOCUMENT_TYPE(l_document_type,