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 219: prev_application_id zx_lines_det_factors.application_id%type;

215:
216: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;

Line 220: prev_entity_code zx_lines_det_factors.entity_code%type;

216: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;

Line 221: prev_event_class_code zx_lines_det_factors.event_class_code%type;

217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;

Line 222: prev_trx_id zx_lines_det_factors.trx_id%type;

218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);

Line 223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;

219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);
227: l_ptnr_exemption_indx BINARY_INTEGER;

Line 224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;

220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);
227: l_ptnr_exemption_indx BINARY_INTEGER;
228: l_tax_account_source_tax ZX_TAXES_B.TAX_ACCOUNT_SOURCE_TAX%TYPE;

Line 225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;

221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);
227: l_ptnr_exemption_indx BINARY_INTEGER;
228: l_tax_account_source_tax ZX_TAXES_B.TAX_ACCOUNT_SOURCE_TAX%TYPE;
229:

Line 276: FROM zx_lines_det_factors

272: ELSE
273: BEGIN
274: SELECT *
275: INTO l_lines_det_fact_rec
276: FROM zx_lines_det_factors
277: WHERE application_id = p_event_class_rec.application_id
278: AND entity_code = p_event_class_rec.entity_code
279: AND event_class_code = p_event_class_rec.event_class_code
280: AND trx_id = p_event_class_rec.trx_id

Line 338: FROM ZX_LINES_DET_FACTORS

334: ' trx_level_type = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_level_type(p_ptnr_tax_line_ind));
335: END IF;
336: BEGIN
337: SELECT historical_flag INTO l_historical_flag
338: FROM ZX_LINES_DET_FACTORS
339: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
340: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
341: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
342: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 856: FROM ZX_LINES_DET_FACTORS

852: --APPLIED_FROM_DOCUMENT - check if original document is migrated
853: BEGIN
854: SELECT nvl(partner_migrated_flag, 'N') -- Bug 5007293
855: INTO l_ptnr_migrated_flag
856: FROM ZX_LINES_DET_FACTORS
857: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
858: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
859: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
860: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)

Line 958: FROM ZX_LINES_DET_FACTORS

954: --ADJUSTED_DOC - check if original document is migrated
955: BEGIN
956: SELECT nvl(partner_migrated_flag, 'N') -- Bug 5007293
957: INTO l_ptnr_migrated_flag
958: FROM ZX_LINES_DET_FACTORS
959: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
960: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
961: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
962: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_index)

Line 1530: FROM ZX_LINES_DET_FACTORS lines

1526: sysdate,
1527: fnd_global.user_id,
1528: sysdate,
1529: fnd_global.user_id
1530: FROM ZX_LINES_DET_FACTORS lines
1531: WHERE application_id = p_event_class_rec.application_id
1532: AND entity_code = p_event_class_rec.entity_code
1533: AND event_class_code = p_event_class_rec.event_class_code
1534: AND trx_id = p_event_class_rec.trx_id

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

1594: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731
1595: l_application_short_name FND_APPLICATION.application_short_name%type;
1596: -- Bug# 4769082
1597: l_cnt_of_options_gt NUMBER;
1598: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593
1599: l_party_id ZX_PARTY_TAX_PROFILE.party_id%type; -- Bug 5090593
1600: l_tax_provider_id NUMBER; -- Bug 5090593
1601:
1602: BEGIN

Line 1696: FROM zx_lines_det_factors

1692: SELECT line_level_action,
1693: hq_estb_party_tax_prof_id
1694: INTO l_line_level_action,
1695: l_hq_estb_ptp_id
1696: FROM zx_lines_det_factors
1697: WHERE application_id = p_event_class_rec.application_id
1698: AND entity_code = p_event_class_rec.entity_code
1699: AND event_class_code = p_event_class_rec.event_class_code
1700: AND trx_id = p_event_class_rec.trx_id

Line 1905: FROM ZX_LINES_DET_FACTORS

1901:
1902: --Currencies can be passed at either the header level/line level
1903: CURSOR document_currency_csr IS
1904: SELECT nvl(trx_line_currency_code,trx_currency_code) trx_currency_code
1905: FROM ZX_LINES_DET_FACTORS
1906: WHERE application_id = p_event_class_rec.application_id
1907: AND entity_code = p_event_class_rec.entity_code
1908: AND event_class_code = p_event_class_rec.event_class_code
1909: AND trx_id = p_event_class_rec.trx_id;

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

2772: ' Exception while Populate zx_detail_tax_lines_gt: ' || sqlerrm);
2773: END IF;
2774: END;
2775:
2776: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.
2777: IF l_threshold_indicator_flag = 'Y' OR l_partner_migrated_flag = 'N' THEN
2778: UPDATE zx_lines_det_factors
2779: SET threshold_indicator_flag = nvl(l_threshold_indicator_flag, threshold_indicator_flag),
2780: partner_migrated_flag = nvl(l_partner_migrated_flag, partner_migrated_flag),

Line 2778: UPDATE zx_lines_det_factors

2774: END;
2775:
2776: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.
2777: IF l_threshold_indicator_flag = 'Y' OR l_partner_migrated_flag = 'N' THEN
2778: UPDATE zx_lines_det_factors
2779: SET threshold_indicator_flag = nvl(l_threshold_indicator_flag, threshold_indicator_flag),
2780: partner_migrated_flag = nvl(l_partner_migrated_flag, partner_migrated_flag),
2781: line_amt_includes_tax_flag = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.line_amt_includes_tax_flag(1)
2782: WHERE application_id = p_event_class_rec.application_id