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 1339: Delete from zx_ptnr_neg_line_gt

1335: x_messages_tbl:=g_messages_tbl;
1336: RETURN;
1337: END IF;
1338: Begin
1339: Delete from zx_ptnr_neg_line_gt
1340: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
1341: trx_id = pg_trx_id_tab(I) and
1342: trx_line_id = pg_trx_line_id_tab(I) and
1343: trx_level_type = pg_trx_level_type_tab(I);

Line 1804: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;

1800: l_JurLink IN OUT NOCOPY zx_tax_taxware_GEN.JurParm,
1801: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm) RETURN BOOLEAN is
1802:
1803: /*Following variables used during line deletion process.*/
1804: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1805: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1806: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1807: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1808: /*Not needed for TAXWARE

Line 1805: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;

1801: l_OraLink IN OUT NOCOPY zx_tax_taxware_GEN.t_OraParm) RETURN BOOLEAN is
1802:
1803: /*Following variables used during line deletion process.*/
1804: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1805: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1806: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1807: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1808: /*Not needed for TAXWARE
1809: arp_ship_to_grphy_type1 varchar2(240);

Line 1806: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;

1802:
1803: /*Following variables used during line deletion process.*/
1804: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1805: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1806: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1807: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1808: /*Not needed for TAXWARE
1809: arp_ship_to_grphy_type1 varchar2(240);
1810: arp_ship_to_grphy_value1 varchar2(240);

Line 1807: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;

1803: /*Following variables used during line deletion process.*/
1804: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1805: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1806: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1807: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1808: /*Not needed for TAXWARE
1809: arp_ship_to_grphy_type1 varchar2(240);
1810: arp_ship_to_grphy_value1 varchar2(240);
1811: arp_ship_to_grphy_type2 varchar2(240);

Line 2011: 'Selecting data from ZX_PTNR_NEG_LINE_GT');

2007: l_OraLink.oracleid := pg_Trx_id_tab(I);
2008: else /*Line level action is delete*/
2009: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2010: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2011: 'Selecting data from ZX_PTNR_NEG_LINE_GT');
2012: END IF;
2013:
2014: select
2015: line_amt,

Line 2093: from ZX_PTNR_NEG_LINE_GT

2089: sec_county_exempt_pct ,
2090: sec_city_exempt_pct ,
2091: arp_tax_sel_param ,
2092: arp_transaction_date
2093: from ZX_PTNR_NEG_LINE_GT
2094: WHERE trx_line_id= pg_trx_line_id_tab(I);
2095:
2096: l_OraLink.oracleid := arp_Trx_id;
2097: end if;

Line 4162: FROM ZX_PTNR_NEG_LINE_GT;

4158: 'l_cnt_of_loc_info_gt = '||l_cnt_of_loc_info_gt);
4159: BEGIN
4160: SELECT count(*)
4161: INTO l_cnt_of_neg_line_gt
4162: FROM ZX_PTNR_NEG_LINE_GT;
4163: EXCEPTION WHEN OTHERS THEN
4164: l_cnt_of_neg_line_gt := 0;
4165: END;
4166: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4175: FROM ZX_PTNR_NEG_LINE_GT

4171:
4172: BEGIN
4173: SELECT trx_line_id
4174: BULK COLLECT INTO pg_trx_line_id_tab
4175: FROM ZX_PTNR_NEG_LINE_GT
4176: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
4177: AND trx_id = x_transaction_rec.transaction_id;
4178: EXCEPTION
4179: WHEN no_data_found THEN