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_LINE_GT

Line 1361: Delete from zx_ptnr_neg_line_gt

1357: RETURN;
1358: END IF;
1359:
1360: Begin
1361: Delete from zx_ptnr_neg_line_gt
1362: WHERE event_class_mapping_id = pg_doc_type_id_tab(I)
1363: and trx_id = pg_trx_id_tab(I)
1364: and trx_line_id = pg_trx_line_id_tab(I)
1365: and trx_level_type = pg_trx_level_type_tab(I);

Line 1834: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;

1830: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
1831: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm) RETURN BOOLEAN is
1832:
1833: /*Following variables used during line deletion process.*/
1834: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1835: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1836: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1837: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1838: /*Not needed for TAXWARE

Line 1835: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;

1831: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm) RETURN BOOLEAN is
1832:
1833: /*Following variables used during line deletion process.*/
1834: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1835: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1836: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1837: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1838: /*Not needed for TAXWARE
1839: arp_ship_to_grphy_type1 varchar2(240);

Line 1836: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;

1832:
1833: /*Following variables used during line deletion process.*/
1834: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1835: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1836: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1837: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1838: /*Not needed for TAXWARE
1839: arp_ship_to_grphy_type1 varchar2(240);
1840: arp_ship_to_grphy_value1 varchar2(240);

Line 1837: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;

1833: /*Following variables used during line deletion process.*/
1834: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1835: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1836: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1837: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1838: /*Not needed for TAXWARE
1839: arp_ship_to_grphy_type1 varchar2(240);
1840: arp_ship_to_grphy_value1 varchar2(240);
1841: arp_ship_to_grphy_type2 varchar2(240);

Line 2041: 'Selecting data from ZX_PTNR_NEG_LINE_GT');

2037: l_OraLink.oracleid := pg_Trx_id_tab(I);
2038: else /*Line level action is delete*/
2039: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2040: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2041: 'Selecting data from ZX_PTNR_NEG_LINE_GT');
2042: END IF;
2043:
2044: select
2045: line_amt,

Line 2123: from ZX_PTNR_NEG_LINE_GT

2119: sec_county_exempt_pct ,
2120: sec_city_exempt_pct ,
2121: arp_tax_sel_param ,
2122: arp_transaction_date
2123: from ZX_PTNR_NEG_LINE_GT
2124: WHERE trx_line_id= pg_trx_line_id_tab(I);
2125:
2126: l_OraLink.oracleid := arp_Trx_id;
2127: end if;

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

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
4293: -- Start --
4294: BEGIN
4295: SELECT COUNT(*)

Line 4297: FROM ZX_PTNR_NEG_LINE_GT

4293: -- Start --
4294: BEGIN
4295: SELECT COUNT(*)
4296: INTO l_neg_trx_line_count
4297: FROM ZX_PTNR_NEG_LINE_GT
4298: WHERE event_class_mapping_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
4299: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4300: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt);
4301: EXCEPTION

Line 4305: ' Error while accessing ZX_PTNR_NEG_LINE_GT');

4301: EXCEPTION
4302: WHEN OTHERS THEN
4303: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4304: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4305: ' Error while accessing ZX_PTNR_NEG_LINE_GT');
4306: END IF;
4307: END;
4308:
4309: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

4307: END;
4308:
4309: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4310: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
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.

Line 4526: FROM ZX_PTNR_NEG_LINE_GT

4522:
4523: BEGIN
4524: SELECT COUNT(*)
4525: INTO l_neg_trx_line_count
4526: FROM ZX_PTNR_NEG_LINE_GT
4527: WHERE event_class_mapping_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt1)
4528: AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt1)
4529: AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt1);
4530: EXCEPTION

Line 4534: ' Error while accessing ZX_PTNR_NEG_LINE_GT');

4530: EXCEPTION
4531: WHEN OTHERS THEN
4532: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4533: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4534: ' Error while accessing ZX_PTNR_NEG_LINE_GT');
4535: END IF;
4536: END;
4537:
4538: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

4536: END;
4537:
4538: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4539: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
4540: ' No of records in ZX_PTNR_NEG_LINE_GT = ' || l_neg_trx_line_count);
4541: END IF;
4542:
4543: IF (l_neg_tax_line_count = 1 OR l_neg_trx_line_count = 1) THEN -- Line is present. Hence, it is an UPDATE action --
4544: l_event_type := 'TAX_LINE_UPDATE';

Line 4747: FROM ZX_PTNR_NEG_LINE_GT;

4743: 'l_cnt_of_loc_info_gt = '||l_cnt_of_loc_info_gt);
4744: BEGIN
4745: SELECT count(*)
4746: INTO l_cnt_of_neg_line_gt
4747: FROM ZX_PTNR_NEG_LINE_GT;
4748: EXCEPTION WHEN OTHERS THEN
4749: l_cnt_of_neg_line_gt := 0;
4750: END;
4751: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4834: FROM ZX_PTNR_NEG_LINE_GT

4830: pg_adj_doc_trx_id_tab,
4831: pg_adj_doc_line_id_tab,
4832: pg_adj_doc_trx_lev_type_tab,
4833: pg_line_level_action_tab
4834: FROM ZX_PTNR_NEG_LINE_GT
4835: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
4836: AND trx_id = x_transaction_rec.transaction_id;
4837: EXCEPTION
4838: WHEN no_data_found THEN

Line 4870: FROM ZX_PTNR_NEG_LINE_GT

4866: --Call Set Document Type
4867:
4868: SELECT SUM(ABS(line_amt))
4869: INTO l_doc_amount
4870: FROM ZX_PTNR_NEG_LINE_GT
4871: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
4872: AND trx_id = x_transaction_rec.transaction_id;
4873:
4874: I := 1;