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_TPI_SERVICES_PKG dependencies on ZX_LINES_DET_FACTORS

Line 261: prev_application_id zx_lines_det_factors.application_id%type;

257:
258: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
259: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
260:
261: prev_application_id zx_lines_det_factors.application_id%type;
262: prev_entity_code zx_lines_det_factors.entity_code%type;
263: prev_event_class_code zx_lines_det_factors.event_class_code%type;
264: prev_trx_id zx_lines_det_factors.trx_id%type;
265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;

Line 262: prev_entity_code zx_lines_det_factors.entity_code%type;

258: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
259: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
260:
261: prev_application_id zx_lines_det_factors.application_id%type;
262: prev_entity_code zx_lines_det_factors.entity_code%type;
263: prev_event_class_code zx_lines_det_factors.event_class_code%type;
264: prev_trx_id zx_lines_det_factors.trx_id%type;
265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
266: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;

Line 263: prev_event_class_code zx_lines_det_factors.event_class_code%type;

259: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
260:
261: prev_application_id zx_lines_det_factors.application_id%type;
262: prev_entity_code zx_lines_det_factors.entity_code%type;
263: prev_event_class_code zx_lines_det_factors.event_class_code%type;
264: prev_trx_id zx_lines_det_factors.trx_id%type;
265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
266: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
267: l_lines_det_fact_rec zx_lines_det_factors%rowtype;

Line 264: prev_trx_id zx_lines_det_factors.trx_id%type;

260:
261: prev_application_id zx_lines_det_factors.application_id%type;
262: prev_entity_code zx_lines_det_factors.entity_code%type;
263: prev_event_class_code zx_lines_det_factors.event_class_code%type;
264: prev_trx_id zx_lines_det_factors.trx_id%type;
265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
266: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
267: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
268: l_historical_flag VARCHAR2(1);

Line 265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;

261: prev_application_id zx_lines_det_factors.application_id%type;
262: prev_entity_code zx_lines_det_factors.entity_code%type;
263: prev_event_class_code zx_lines_det_factors.event_class_code%type;
264: prev_trx_id zx_lines_det_factors.trx_id%type;
265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
266: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
267: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
268: l_historical_flag VARCHAR2(1);
269: l_ptnr_exemption_indx VARCHAR2(4000);

Line 266: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;

262: prev_entity_code zx_lines_det_factors.entity_code%type;
263: prev_event_class_code zx_lines_det_factors.event_class_code%type;
264: prev_trx_id zx_lines_det_factors.trx_id%type;
265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
266: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
267: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
268: l_historical_flag VARCHAR2(1);
269: l_ptnr_exemption_indx VARCHAR2(4000);
270: l_tax_account_source_tax ZX_TAXES_B.TAX_ACCOUNT_SOURCE_TAX%TYPE;

Line 267: l_lines_det_fact_rec zx_lines_det_factors%rowtype;

263: prev_event_class_code zx_lines_det_factors.event_class_code%type;
264: prev_trx_id zx_lines_det_factors.trx_id%type;
265: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
266: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
267: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
268: l_historical_flag VARCHAR2(1);
269: l_ptnr_exemption_indx VARCHAR2(4000);
270: l_tax_account_source_tax ZX_TAXES_B.TAX_ACCOUNT_SOURCE_TAX%TYPE;
271:

Line 320: FROM zx_lines_det_factors

316: ELSE
317: BEGIN
318: SELECT *
319: INTO l_lines_det_fact_rec
320: FROM zx_lines_det_factors
321: WHERE application_id = p_event_class_rec.application_id
322: AND entity_code = p_event_class_rec.entity_code
323: AND event_class_code = p_event_class_rec.event_class_code
324: AND trx_id = p_event_class_rec.trx_id

Line 384: FROM ZX_LINES_DET_FACTORS

380: END IF;
381:
382: BEGIN
383: SELECT historical_flag INTO l_historical_flag
384: FROM ZX_LINES_DET_FACTORS
385: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
386: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
387: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
388: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 975: FROM ZX_LINES_DET_FACTORS

971: --APPLIED_FROM_DOCUMENT - check if original document is migrated
972: BEGIN
973: SELECT nvl(partner_migrated_flag, 'N') -- Bug 5007293
974: INTO l_ptnr_migrated_flag
975: FROM ZX_LINES_DET_FACTORS
976: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
977: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
978: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
979: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)

Line 1077: FROM ZX_LINES_DET_FACTORS

1073: --ADJUSTED_DOC - check if original document is migrated
1074: BEGIN
1075: SELECT nvl(partner_migrated_flag, 'N') -- Bug 5007293
1076: INTO l_ptnr_migrated_flag
1077: FROM ZX_LINES_DET_FACTORS
1078: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
1079: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
1080: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
1081: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_index)

Line 1680: FROM ZX_LINES_DET_FACTORS lines

1676: sysdate,
1677: fnd_global.user_id,
1678: sysdate,
1679: fnd_global.user_id
1680: FROM ZX_LINES_DET_FACTORS lines
1681: WHERE application_id = p_event_class_rec.application_id
1682: AND entity_code = p_event_class_rec.entity_code
1683: AND event_class_code = p_event_class_rec.event_class_code
1684: AND trx_id = p_event_class_rec.trx_id

Line 1748: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593

1744: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731
1745: l_application_short_name FND_APPLICATION.application_short_name%type;
1746: -- Bug# 4769082
1747: l_cnt_of_options_gt NUMBER;
1748: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593
1749: l_party_id ZX_PARTY_TAX_PROFILE.party_id%type; -- Bug 5090593
1750: l_tax_provider_id NUMBER; -- Bug 5090593
1751:
1752: BEGIN

Line 1845: FROM zx_lines_det_factors

1841: ELSE
1842: BEGIN
1843: SELECT line_level_action, hq_estb_party_tax_prof_id
1844: INTO l_line_level_action, l_hq_estb_ptp_id
1845: FROM zx_lines_det_factors
1846: WHERE application_id = p_event_class_rec.application_id
1847: AND entity_code = p_event_class_rec.entity_code
1848: AND event_class_code = p_event_class_rec.event_class_code
1849: AND trx_id = p_event_class_rec.trx_id

Line 1856: FROM zx_lines_det_factors

1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: SELECT line_level_action, hq_estb_party_tax_prof_id
1855: INTO l_line_level_action, l_hq_estb_ptp_id
1856: FROM zx_lines_det_factors
1857: WHERE application_id = p_event_class_rec.application_id
1858: AND entity_code = p_event_class_rec.entity_code
1859: AND event_class_code = p_event_class_rec.event_class_code
1860: AND trx_id = p_event_class_rec.trx_id

Line 2075: FROM ZX_LINES_DET_FACTORS

2071: CURSOR document_currency_csr IS
2072: SELECT DISTINCT -- Bug#16460613
2073: NVL(trx_line_currency_code,trx_currency_code) trx_currency_code,
2074: trx_date
2075: FROM ZX_LINES_DET_FACTORS
2076: WHERE application_id = p_event_class_rec.application_id
2077: AND entity_code = p_event_class_rec.entity_code
2078: AND event_class_code = p_event_class_rec.event_class_code
2079: AND trx_id = p_event_class_rec.trx_id;

Line 3070: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.

3066: ' Exception while Populate zx_detail_tax_lines_gt: ' || sqlerrm);
3067: END IF;
3068: END;
3069:
3070: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.
3071: IF l_threshold_indicator_flag = 'Y' OR l_partner_migrated_flag = 'N' THEN
3072: UPDATE zx_lines_det_factors
3073: SET threshold_indicator_flag = nvl(l_threshold_indicator_flag, threshold_indicator_flag),
3074: partner_migrated_flag = nvl(l_partner_migrated_flag, partner_migrated_flag),

Line 3072: UPDATE zx_lines_det_factors

3068: END;
3069:
3070: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.
3071: IF l_threshold_indicator_flag = 'Y' OR l_partner_migrated_flag = 'N' THEN
3072: UPDATE zx_lines_det_factors
3073: SET threshold_indicator_flag = nvl(l_threshold_indicator_flag, threshold_indicator_flag),
3074: partner_migrated_flag = nvl(l_partner_migrated_flag, partner_migrated_flag),
3075: line_amt_includes_tax_flag = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.line_amt_includes_tax_flag(1)
3076: WHERE application_id = p_event_class_rec.application_id