APPS.ZX_TAXWARE_TAX_SERVICE_PKG dependencies on ZX_LINES_DET_FACTORS

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 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 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 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;