APPS.ZX_TAXWARE_TAX_SERVICE_PKG dependencies on ZX_LINES

Line 237: l_document_type zx_lines_det_factors.event_class_code%type;

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

Line 1929: arp_product_code ZX_LINES_DET_FACTORS.PRODUCT_CODE%TYPE;

1925: arp_bill_from_grphy_value9 varchar2(240);
1926: arp_bill_from_grphy_type10 varchar2(240);
1927: arp_bill_from_grphy_value10 varchar2(240); Not Required for TAXWARE*/
1928: arp_tax_type varchar2(150);
1929: arp_product_code ZX_LINES_DET_FACTORS.PRODUCT_CODE%TYPE;
1930: use_step varchar2(30);
1931: arp_state_exempt_reason varchar2(240);
1932: arp_county_exempt_reason varchar2(240);
1933: arp_city_exempt_reason varchar2(240);

Line 2889: From zx_lines_det_factors

2885: IF l_situs = 'SHIP_TO' THEN
2886: /* Bug 5090593: Making use of the location ids passed thru view.
2887: select nvl(ship_to_location_id, bill_to_location_id)
2888: INTO p_location_id
2889: From zx_lines_det_factors
2890: WHERE
2891: event_class_mapping_id = pg_doc_type_id_tab(I) and
2892: trx_id = pg_trx_id_tab(I) and
2893: trx_line_id = pg_trx_line_id_tab(I) and

Line 2902: From zx_lines_det_factors

2898: ELSIF l_situs = 'SHIP_FROM' THEN
2899: /* Bug 5090593: Making use of the location ids passed thru view.
2900: select nvl(ship_from_location_id, bill_from_location_id)
2901: INTO p_location_id
2902: From zx_lines_det_factors
2903: WHERE
2904: event_class_mapping_id = pg_doc_type_id_tab(I) and
2905: trx_id = pg_trx_id_tab(I) and
2906: trx_line_id = pg_trx_line_id_tab(I) and

Line 3530: p_transaction_id IN ZX_LINES.trx_id%type,

3526:
3527: END CREATE_TAX_LINE;
3528:
3529: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3530: p_transaction_id IN ZX_LINES.trx_id%type,
3531: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3532: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3533: p_regime_code IN ZX_LINES.tax_regime_code%type,
3534: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

Line 3531: p_transaction_line_id IN ZX_LINES.trx_line_id%type,

3527: END CREATE_TAX_LINE;
3528:
3529: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3530: p_transaction_id IN ZX_LINES.trx_id%type,
3531: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3532: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3533: p_regime_code IN ZX_LINES.tax_regime_code%type,
3534: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3535: x_return_status OUT NOCOPY VARCHAR2 ) is

Line 3532: p_trx_level_type IN ZX_LINES.trx_level_type%type,

3528:
3529: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3530: p_transaction_id IN ZX_LINES.trx_id%type,
3531: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3532: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3533: p_regime_code IN ZX_LINES.tax_regime_code%type,
3534: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3535: x_return_status OUT NOCOPY VARCHAR2 ) is
3536:

Line 3533: p_regime_code IN ZX_LINES.tax_regime_code%type,

3529: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3530: p_transaction_id IN ZX_LINES.trx_id%type,
3531: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3532: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3533: p_regime_code IN ZX_LINES.tax_regime_code%type,
3534: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3535: x_return_status OUT NOCOPY VARCHAR2 ) is
3536:
3537: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;

Line 3534: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

3530: p_transaction_id IN ZX_LINES.trx_id%type,
3531: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3532: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3533: p_regime_code IN ZX_LINES.tax_regime_code%type,
3534: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3535: x_return_status OUT NOCOPY VARCHAR2 ) is
3536:
3537: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;
3538: event_class_rec ZX_API_PUB.event_class_rec_type;

Line 3577: From zx_lines_det_factors

3573: l_EVENT_CLASS_CODE,
3574: l_TRX_ID ,
3575: l_TRX_LINE_ID,
3576: l_TRX_LEVEL_TYPE
3577: From zx_lines_det_factors
3578: where
3579: event_class_mapping_id = p_evnt_cls_mapping_id
3580: AND trx_id = p_transaction_id
3581: AND trx_line_id = p_transaction_line_id

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

3586: IF (g_level_exception >= g_current_runtime_level ) THEN
3587: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3588: End if;
3589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3590: g_string :='No data found in zx_lines_det_factors ';
3591: error_exception_handle(g_string);
3592: return;
3593: End;
3594:

Line 3682: , p_tax IN zx_lines.tax%type

3678: END IF;
3679: End Check_in_cache;
3680:
3681: PROCEDURE POPULATE_SYNC_TAX_AMTS(p_sync_tax_cnt IN NUMBER
3682: , p_tax IN zx_lines.tax%type
3683: , x_output_sync_tax_lines OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type
3684: , x_return_status OUT NOCOPY VARCHAR2) IS
3685:
3686: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';

Line 4115: FROM ZX_LINES_DET_FACTORS

4111: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4112: BEGIN
4113: SELECT count(*)
4114: INTO l_cnt_of_det_factors
4115: FROM ZX_LINES_DET_FACTORS
4116: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
4117: AND trx_id = x_transaction_rec.transaction_id;
4118: EXCEPTION WHEN OTHERS THEN
4119: l_cnt_of_det_factors := 0;