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_VERTEX_TAX_SERVICE_PKG dependencies on ZX_LINES

Line 65: l_document_type zx_lines_det_factors.event_class_code%type;

61: ------------------------------------------------*/
62: C_LINES_PER_COMMIT CONSTANT NUMBER := 1000;
63: I Number;
64: l_line_level_action varchar2(20);
65: l_document_type zx_lines_det_factors.event_class_code%type;
66: l_trx_line_context_changed BOOLEAN;
67: l_state_tax_cnt NUMBER;
68: l_county_tax_cnt NUMBER;
69: l_city_tax_cnt NUMBER;

Line 728: l_line_action zx_lines_det_factors.line_level_action%type;

724: l_cnt_of_loc_info_gt NUMBER;
725: l_cnt_of_ptnr_neg_line_gt NUMBER;
726: l_partner_processing_flag VARCHAR2(80);
727: l_record_for_partners_flag VARCHAR2(80);
728: l_line_action zx_lines_det_factors.line_level_action%type;
729: -- l_inclusive_tax_override_flag VARCHAR2(80);
730: l_application_id NUMBER;
731: l_entity_code VARCHAR2(80);
732: l_event_class_code VARCHAR2(100);

Line 826: , ZX_LINES_DET_FACTORS zldf

822: BEGIN
823: SELECT count(*)
824: INTO l_cnt_of_options_gt
825: FROM ZX_TRX_PRE_PROC_OPTIONS_GT ztppo
826: , ZX_LINES_DET_FACTORS zldf
827: WHERE ztppo.application_id = zldf.application_id
828: AND ztppo.entity_code = zldf.entity_code
829: AND ztppo.event_class_code = zldf.event_class_code
830: AND ztppo.trx_id = zldf.trx_id;

Line 899: FROM zx_lines_det_factors

895:
896: SELECT output_tax_classification_code,receivables_trx_type_id,internal_organization_id, ship_to_location_id,
897: bill_to_location_id
898: INTO l_tax_code, l_trx_type_id, l_org_id, l_ship_to_location_id, l_bill_to_location_id
899: FROM zx_lines_det_factors
900: WHERE application_id = l_application_id
901: and entity_code = l_entity_code
902: and event_class_code = l_event_class_code
903: and trx_id = l_trx_id

Line 982: -- ,ZX_LINES_DET_FACTORS zldf

978: --BEGIN
979: -- select zldf.line_level_action,zldf.inclusive_tax_override_flag
980: -- into l_line_level_action, l_inclusive_tax_override_flag
981: -- FROM ZX_TRX_PRE_PROC_OPTIONS_GT ztppo
982: -- ,ZX_LINES_DET_FACTORS zldf
983: -- WHERE ztppo.application_id = zldf.application_id
984: -- AND ztppo.entity_code = zldf.entity_code
985: -- AND ztppo.event_class_code = zldf.event_class_code
986: -- AND ztppo.trx_id = zldf.trx_id;

Line 1406: from zx_lines_det_factors

1402: ELSE
1403: IF l_document_type = 'APPLIED_CREDIT_MEMO' and pg_line_amount_tab(I) = 0 THEN
1404: BEGIN
1405: select line_level_action into l_line_action
1406: from zx_lines_det_factors
1407: where application_id = l_application_id
1408: and entity_code = l_entity_code
1409: and event_class_code = l_event_class_code
1410: and trx_id = pg_trx_id_tab(I)

Line 1830: FROM ZX_LINES

1826: IF l_application_id IS NOT NULL THEN
1827: BEGIN
1828: SELECT Count(*)
1829: INTO l_ver_count
1830: FROM ZX_LINES
1831: WHERE APPLICATION_ID = l_application_id
1832: AND TRX_ID = pg_trx_id_tab(I)
1833: AND TRX_LINE_ID = pg_trx_line_id_tab(I)
1834: AND TAX_PROVIDER_ID IS NOT NULL;

Line 2740: FROM ZX_LINES_DET_FACTORS zd

2736: --bug#6831713
2737: BEGIN
2738: SELECT nvl(zd.partner_migrated_flag, 'N') -- Bug 5007293
2739: INTO pg_ugraded_inv_flag_tab(I)
2740: FROM ZX_LINES_DET_FACTORS zd
2741: WHERE zd.event_class_mapping_id = pg_adj_doc_doc_type_id_tab(i)
2742: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)
2743: AND zd.trx_line_id = pg_adj_doc_line_id_tab(i)
2744: AND zd.trx_level_type = pg_adj_doc_trx_lev_type_tab(i)

Line 2746: FROM ZX_LINES zl

2742: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)
2743: AND zd.trx_line_id = pg_adj_doc_line_id_tab(i)
2744: AND zd.trx_level_type = pg_adj_doc_trx_lev_type_tab(i)
2745: AND EXISTS (SELECT 'Y'
2746: FROM ZX_LINES zl
2747: WHERE zl.application_id = zd.application_id
2748: AND zl.entity_code = zd.entity_code
2749: AND zl.event_class_code = zd.event_class_code
2750: AND zl.trx_id = pg_adj_doc_trx_id_tab(i)

Line 3388: From zx_lines_det_factors

3384: IF l_situs = 'SHIP_TO' THEN
3385: /* Bug 5090593: Making use of the location ids passed thru view.
3386: select nvl(ship_to_location_id, bill_to_location_id)
3387: INTO p_location_id
3388: From zx_lines_det_factors
3389: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
3390: trx_id = pg_trx_id_tab(I) and
3391: trx_line_id = pg_trx_line_id_tab(I) and
3392: trx_level_type = pg_trx_level_type_tab(I);

Line 3400: From zx_lines_det_factors

3396: ELSIF l_situs = 'SHIP_FROM' THEN
3397: /* Bug 5090593: Making use of the location ids passed thru view.
3398: select nvl(ship_from_location_id, bill_from_location_id)
3399: INTO p_location_id
3400: From zx_lines_det_factors
3401: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
3402: trx_id = pg_trx_id_tab(I) and
3403: trx_line_id = pg_trx_line_id_tab(I) and
3404: trx_level_type = pg_trx_level_type_tab(I);

Line 3929: FROM zx_lines

3925: SELECT global_attribute2, global_attribute4, global_attribute6, tax_amt,
3926: precision, minimum_accountable_unit, rounding_rule_code
3927: INTO g_StTaxAmt, g_CoTaxAmt, g_CiTaxAmt, g_TotalTaxAmt,
3928: l_precision, l_mau, l_rounding_rule
3929: FROM zx_lines
3930: WHERE application_id = NVL2(pg_adj_doc_doc_type_id_tab(I),222, NULL)
3931: AND entity_code = NVL2(pg_adj_doc_doc_type_id_tab(I),'TRANSACTIONS',NULL)
3932: AND event_class_code = decode(pg_adj_doc_doc_type_id_tab(I), 4, 'INVOICE',
3933: 5, 'DEBIT_MEMO',

Line 4104: p_transaction_id IN ZX_LINES.trx_id%type,

4100:
4101: END CREATE_TAX_LINE;
4102:
4103: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
4104: p_transaction_id IN ZX_LINES.trx_id%type,
4105: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
4106: p_trx_level_type IN ZX_LINES.trx_level_type%type,
4107: p_regime_code IN ZX_LINES.tax_regime_code%type,
4108: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

Line 4105: p_transaction_line_id IN ZX_LINES.trx_line_id%type,

4101: END CREATE_TAX_LINE;
4102:
4103: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
4104: p_transaction_id IN ZX_LINES.trx_id%type,
4105: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
4106: p_trx_level_type IN ZX_LINES.trx_level_type%type,
4107: p_regime_code IN ZX_LINES.tax_regime_code%type,
4108: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
4109: x_return_status OUT NOCOPY VARCHAR2 ) is

Line 4106: p_trx_level_type IN ZX_LINES.trx_level_type%type,

4102:
4103: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
4104: p_transaction_id IN ZX_LINES.trx_id%type,
4105: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
4106: p_trx_level_type IN ZX_LINES.trx_level_type%type,
4107: p_regime_code IN ZX_LINES.tax_regime_code%type,
4108: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
4109: x_return_status OUT NOCOPY VARCHAR2 ) is
4110:

Line 4107: p_regime_code IN ZX_LINES.tax_regime_code%type,

4103: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
4104: p_transaction_id IN ZX_LINES.trx_id%type,
4105: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
4106: p_trx_level_type IN ZX_LINES.trx_level_type%type,
4107: p_regime_code IN ZX_LINES.tax_regime_code%type,
4108: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
4109: x_return_status OUT NOCOPY VARCHAR2 ) is
4110:
4111: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;

Line 4108: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

4104: p_transaction_id IN ZX_LINES.trx_id%type,
4105: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
4106: p_trx_level_type IN ZX_LINES.trx_level_type%type,
4107: p_regime_code IN ZX_LINES.tax_regime_code%type,
4108: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
4109: x_return_status OUT NOCOPY VARCHAR2 ) is
4110:
4111: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;
4112: event_class_rec ZX_API_PUB.event_class_rec_type;

Line 4170: FROM zx_lines_det_factors

4166: l_EVENT_CLASS_CODE,
4167: l_TRX_ID ,
4168: l_TRX_LINE_ID,
4169: l_TRX_LEVEL_TYPE
4170: FROM zx_lines_det_factors
4171: WHERE event_class_mapping_id = p_evnt_cls_mapping_id
4172: AND trx_id = p_transaction_id
4173: AND trx_line_id = p_transaction_line_id
4174: AND trx_level_type = p_trx_level_type;

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

4177: IF (g_level_exception >= g_current_runtime_level ) THEN
4178: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4179: END IF;
4180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4181: g_string :='No data found in zx_lines_det_factors ';
4182: error_exception_handle(g_string);
4183: RETURN;
4184: END;
4185:

Line 4277: , p_tax IN zx_lines.tax%type

4273:
4274: End Check_in_cache;
4275:
4276: PROCEDURE POPULATE_SYNC_TAX_AMTS(p_sync_tax_cnt IN NUMBER
4277: , p_tax IN zx_lines.tax%type
4278: , x_output_sync_tax_lines IN OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type
4279: , x_return_status OUT NOCOPY VARCHAR2) IS
4280:
4281: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';

Line 4468: l_line_action zx_lines_det_factors.line_level_action%type;

4464: l_neg_tax_line_count NUMBER; -- Added for Bug#12544630
4465: l_neg_trx_line_count NUMBER; -- Added for Bug#12544630
4466: l_update_mode BOOLEAN; -- Added for Bug#12544630
4467:
4468: l_line_action zx_lines_det_factors.line_level_action%type;
4469: l_adj_trx_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4470: BEGIN
4471: x_return_status := FND_API.G_RET_STS_SUCCESS;
4472: err_count := 0;

Line 4559: -- FROM zx_lines_det_factors

4555:
4556: -- SELECT output_tax_classification_code , receivables_trx_type_id,
4557: -- internal_organization_id
4558: -- INTO l_tax_code, l_trx_type_id, l_org_id
4559: -- FROM zx_lines_det_factors
4560: -- WHERE application_id = l_application_id
4561: -- AND entity_code = l_entity_code
4562: -- AND event_class_code = l_event_class_code
4563: -- AND trx_id = SYNC_TAX_LINES.transaction_id(1)

Line 5232: FROM ZX_LINES_DET_FACTORS

5228: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5229: BEGIN
5230: SELECT count(*)
5231: INTO l_cnt_of_det_factors
5232: FROM ZX_LINES_DET_FACTORS
5233: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
5234: AND trx_id = x_transaction_rec.transaction_id;
5235: EXCEPTION WHEN OTHERS THEN
5236: l_cnt_of_det_factors := 0;

Line 5324: FROM zx_lines_det_factors where

5320:
5321: SELECT output_tax_classification_code,receivables_trx_type_id,
5322: internal_organization_id into
5323: l_tax_code,l_trx_type_id, l_org_id
5324: FROM zx_lines_det_factors where
5325: application_id = l_application_id
5326: and entity_code = l_entity_code
5327: and event_class_code = l_event_class_code
5328: and trx_id = l_trx_id