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_LINES

Line 238: l_document_type zx_lines_det_factors.event_class_code%type;

234: ------------------------------------------------*/
235: C_LINES_PER_COMMIT CONSTANT NUMBER := 1000;
236: I Number; --Index Variable.
237: g_line_level_action varchar2(20);
238: l_document_type zx_lines_det_factors.event_class_code%type;
239: -- PG_DEBUG varchar2(1);
240: -- x_return_status varchar2(20);
241:
242: /* ======================================================================*

Line 1959: arp_product_code ZX_LINES_DET_FACTORS.PRODUCT_CODE%TYPE;

1955: arp_bill_from_grphy_value9 varchar2(240);
1956: arp_bill_from_grphy_type10 varchar2(240);
1957: arp_bill_from_grphy_value10 varchar2(240); Not Required for TAXWARE*/
1958: arp_tax_type varchar2(150);
1959: arp_product_code ZX_LINES_DET_FACTORS.PRODUCT_CODE%TYPE;
1960: use_step varchar2(30);
1961: arp_state_exempt_reason varchar2(240);
1962: arp_county_exempt_reason varchar2(240);
1963: arp_city_exempt_reason varchar2(240);

Line 2393: FROM ZX_LINES_DET_FACTORS zd

2389:
2390: BEGIN
2391: SELECT nvl(zd.partner_migrated_flag, 'N') -- Bug 5007293
2392: INTO pg_ugraded_inv_flag_tab(I)
2393: FROM ZX_LINES_DET_FACTORS zd
2394: WHERE zd.event_class_mapping_id = pg_adj_doc_doc_type_id_tab(i)
2395: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)
2396: AND zd.trx_line_id = pg_adj_doc_line_id_tab(i)
2397: AND zd.trx_level_type = pg_adj_doc_trx_lev_type_tab(i)

Line 2399: FROM ZX_LINES zl

2395: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)
2396: AND zd.trx_line_id = pg_adj_doc_line_id_tab(i)
2397: AND zd.trx_level_type = pg_adj_doc_trx_lev_type_tab(i)
2398: AND EXISTS (SELECT 'Y'
2399: FROM ZX_LINES zl
2400: WHERE zl.application_id = zd.application_id
2401: AND zl.entity_code = zd.entity_code
2402: AND zl.event_class_code = zd.event_class_code
2403: AND zl.trx_id = pg_adj_doc_trx_id_tab(i)

Line 3022: From zx_lines_det_factors

3018: IF l_situs = 'SHIP_TO' THEN
3019: /* Bug 5090593: Making use of the location ids passed thru view.
3020: select nvl(ship_to_location_id, bill_to_location_id)
3021: INTO p_location_id
3022: From zx_lines_det_factors
3023: WHERE
3024: event_class_mapping_id = pg_doc_type_id_tab(I) and
3025: trx_id = pg_trx_id_tab(I) and
3026: trx_line_id = pg_trx_line_id_tab(I) and

Line 3034: From zx_lines_det_factors

3030: ELSIF l_situs = 'SHIP_FROM' THEN
3031: /* Bug 5090593: Making use of the location ids passed thru view.
3032: select nvl(ship_from_location_id, bill_from_location_id)
3033: INTO p_location_id
3034: From zx_lines_det_factors
3035: WHERE
3036: event_class_mapping_id = pg_doc_type_id_tab(I) and
3037: trx_id = pg_trx_id_tab(I) and
3038: trx_line_id = pg_trx_line_id_tab(I) and

Line 3707: FROM zx_lines

3703: SELECT global_attribute2, global_attribute4, global_attribute6, tax_amt,
3704: precision, minimum_accountable_unit, rounding_rule_code
3705: INTO g_StTaxAmt, g_CoTaxAmt, g_CiTaxAmt, g_TotalTaxAmt,
3706: l_precision, l_mau, l_rounding_rule
3707: FROM zx_lines
3708: WHERE application_id = NVL2(pg_adj_doc_doc_type_id_tab(I),222, NULL)
3709: AND entity_code = NVL2(pg_adj_doc_doc_type_id_tab(I),'TRANSACTIONS',NULL)
3710: AND event_class_code = decode(pg_adj_doc_doc_type_id_tab(I), 4, 'INVOICE',
3711: 5, 'DEBIT_MEMO',

Line 3853: p_transaction_id IN ZX_LINES.trx_id%type,

3849: RAISE;
3850: END CREATE_TAX_LINE;
3851:
3852: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3853: p_transaction_id IN ZX_LINES.trx_id%type,
3854: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3855: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3856: p_regime_code IN ZX_LINES.tax_regime_code%type,
3857: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

Line 3854: p_transaction_line_id IN ZX_LINES.trx_line_id%type,

3850: END CREATE_TAX_LINE;
3851:
3852: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3853: p_transaction_id IN ZX_LINES.trx_id%type,
3854: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3855: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3856: p_regime_code IN ZX_LINES.tax_regime_code%type,
3857: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3858: x_return_status OUT NOCOPY VARCHAR2 ) is

Line 3855: p_trx_level_type IN ZX_LINES.trx_level_type%type,

3851:
3852: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3853: p_transaction_id IN ZX_LINES.trx_id%type,
3854: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3855: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3856: p_regime_code IN ZX_LINES.tax_regime_code%type,
3857: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3858: x_return_status OUT NOCOPY VARCHAR2 ) is
3859:

Line 3856: p_regime_code IN ZX_LINES.tax_regime_code%type,

3852: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3853: p_transaction_id IN ZX_LINES.trx_id%type,
3854: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3855: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3856: p_regime_code IN ZX_LINES.tax_regime_code%type,
3857: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3858: x_return_status OUT NOCOPY VARCHAR2 ) is
3859:
3860: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;

Line 3857: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

3853: p_transaction_id IN ZX_LINES.trx_id%type,
3854: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3855: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3856: p_regime_code IN ZX_LINES.tax_regime_code%type,
3857: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3858: x_return_status OUT NOCOPY VARCHAR2 ) is
3859:
3860: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;
3861: event_class_rec ZX_API_PUB.event_class_rec_type;

Line 3900: From zx_lines_det_factors

3896: l_EVENT_CLASS_CODE,
3897: l_TRX_ID ,
3898: l_TRX_LINE_ID,
3899: l_TRX_LEVEL_TYPE
3900: From zx_lines_det_factors
3901: where
3902: event_class_mapping_id = p_evnt_cls_mapping_id
3903: AND trx_id = p_transaction_id
3904: AND trx_line_id = p_transaction_line_id

Line 3913: g_string :='No data found in zx_lines_det_factors ';

3909: IF (g_level_exception >= g_current_runtime_level ) THEN
3910: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3911: End if;
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3913: g_string :='No data found in zx_lines_det_factors ';
3914: error_exception_handle(g_string);
3915: return;
3916: End;
3917:

Line 4005: , p_tax IN zx_lines.tax%type

4001: END IF;
4002: End Check_in_cache;
4003:
4004: PROCEDURE POPULATE_SYNC_TAX_AMTS(p_sync_tax_cnt IN NUMBER
4005: , p_tax IN zx_lines.tax%type
4006: , x_output_sync_tax_lines OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type
4007: , x_return_status OUT NOCOPY VARCHAR2) IS
4008:
4009: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';

Line 4700: FROM ZX_LINES_DET_FACTORS

4696: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4697: BEGIN
4698: SELECT count(*)
4699: INTO l_cnt_of_det_factors
4700: FROM ZX_LINES_DET_FACTORS
4701: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
4702: AND trx_id = x_transaction_rec.transaction_id;
4703: EXCEPTION WHEN OTHERS THEN
4704: l_cnt_of_det_factors := 0;