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

Line 20: -- Bug 5417887: Tables to hold zx_lines_det_factor_attributes to avoid any further fetch on it.

16:
17: NUMBER_DUMMY CONSTANT NUMBER(15):= -999999999999999;
18:
19:
20: -- Bug 5417887: Tables to hold zx_lines_det_factor_attributes to avoid any further fetch on it.
21: TYPE varchar_30_idx_bi_tbl_type is table of VARCHAR2(30) index by BINARY_INTEGER;
22: record_type_code_tbl varchar_30_idx_bi_tbl_type;
23: line_level_action_tbl varchar_30_idx_bi_tbl_type;
24:

Line 54: l_mig_trx_date zx_lines.trx_date%type;

50: x_return_status OUT NOCOPY VARCHAR2
51: ) IS
52: l_api_name CONSTANT VARCHAR2(30) := 'GET_MIGRATED_DOC_INFO';
53: l_context_info_rec ZX_API_PUB.context_info_rec_type;
54: l_mig_trx_date zx_lines.trx_date%type;
55: l_mig_first_pty_id number;
56: l_mig_exists number;
57: l_mig_glb_att_cat zx_lines.global_attribute_category%type;
58: BEGIN

Line 57: l_mig_glb_att_cat zx_lines.global_attribute_category%type;

53: l_context_info_rec ZX_API_PUB.context_info_rec_type;
54: l_mig_trx_date zx_lines.trx_date%type;
55: l_mig_first_pty_id number;
56: l_mig_exists number;
57: l_mig_glb_att_cat zx_lines.global_attribute_category%type;
58: BEGIN
59: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
60: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
61: END IF;

Line 75: FROM ZX_LINES

71: SELECT tax_provider_id,
72: tax_regime_code
73: INTO x_migrated_tax_provider_id,
74: x_migrated_tax_regime_code
75: FROM ZX_LINES
76: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
77: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
78: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
79: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)

Line 101: FROM ZX_LINES

97: x_migrated_tax_regime_code,
98: l_mig_trx_date,
99: l_mig_first_pty_id,
100: l_mig_glb_att_cat
101: FROM ZX_LINES
102: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
103: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
104: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
105: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_index)

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 405: FROM zx_lines

401: IF NVL(l_historical_flag,'N') = 'Y' THEN
402: BEGIN
403: SELECT tax_line_id
404: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind)
405: FROM zx_lines
406: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
407: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
408: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
409: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 417: FROM zx_lines

413: WHEN TOO_MANY_ROWS THEN
414: BEGIN
415: SELECT tax_line_id
416: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind)
417: FROM zx_lines
418: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
419: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
420: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
421: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 440: FROM zx_lines

436: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind) IS NULL THEN
437: BEGIN
438: SELECT tax_line_id
439: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind)
440: FROM zx_lines
441: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
442: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
443: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
444: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 455: FROM zx_lines

451: WHEN TOO_MANY_ROWS THEN
452: BEGIN
453: SELECT tax_line_id
454: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind)
455: FROM zx_lines
456: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
457: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
458: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
459: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 471: FROM zx_lines

467: WHEN TOO_MANY_ROWS THEN
468: BEGIN
469: SELECT tax_line_id
470: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind)
471: FROM zx_lines
472: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
473: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
474: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
475: 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 989: --APPLIED_FROM_DOCUMENT - migrated: get information of regimes from ZX_LINES

985: l_ptnr_migrated_flag := 'N';
986: END;
987:
988: IF l_ptnr_migrated_flag = 'Y' THEN
989: --APPLIED_FROM_DOCUMENT - migrated: get information of regimes from ZX_LINES
990: get_migrated_doc_info (p_trx_line_index,
991: l_migrated_tax_provider_id,
992: l_migrated_tax_regime_code,
993: l_migrated_tax_regime_id,

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 1089: --ADJUSTED DOC - migrated: get information of regimes from ZX_LINES

1085: WHEN no_data_found THEN
1086: l_ptnr_migrated_flag := 'N';
1087: END;
1088: IF l_ptnr_migrated_flag = 'Y' THEN
1089: --ADJUSTED DOC - migrated: get information of regimes from ZX_LINES
1090: get_migrated_doc_info (p_trx_line_index,
1091: l_migrated_tax_provider_id,
1092: l_migrated_tax_regime_code,
1093: l_migrated_tax_regime_id,

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 2343: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)

2339: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2340: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2341: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2342: c_tax_class ZX_RATES_B.TAX_CLASS%TYPE,
2343: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
2344: IS
2345: SELECT rate.tax_rate_code,
2346: rate.rate_type_code,
2347: rate.tax_rate_id

Line 2755: FROM ZX_LINES tax

2751: tax.line_amt
2752: INTO l_prepay_tax_rate,
2753: l_prepay_tax_amt,
2754: l_prepay_line_amt
2755: FROM ZX_LINES tax
2756: WHERE tax.application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_application_id(ptnr_tax_line_index)
2757: AND tax.entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_entity_code(ptnr_tax_line_index)
2758: AND tax.event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_event_class_code(ptnr_tax_line_index)
2759: AND tax.trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_trx_id(ptnr_tax_line_index)

Line 2946: select ZX_LINES_S.nextval,

2942: last_update_login,
2943: establishment_id
2944: )
2945: -- VALUES (--ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_line_id(i),
2946: select ZX_LINES_S.nextval,
2947: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.internal_organization_id(i),
2948: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.application_id(i),
2949: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.entity_code(i),
2950: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.event_class_code(i),

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

Line 3145: l_last_manual_entry zx_lines.last_manual_entry%type;

3141: ) IS
3142:
3143: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROC_SYNC_TAX';
3144: l_context_info_rec ZX_API_PUB.context_info_rec_type;
3145: l_last_manual_entry zx_lines.last_manual_entry%type;
3146: l_tax_line_id zx_lines.tax_line_id%type; -- Bug 4908196
3147: l_return_status VARCHAR2(1);
3148:
3149: BEGIN

Line 3146: l_tax_line_id zx_lines.tax_line_id%type; -- Bug 4908196

3142:
3143: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROC_SYNC_TAX';
3144: l_context_info_rec ZX_API_PUB.context_info_rec_type;
3145: l_last_manual_entry zx_lines.last_manual_entry%type;
3146: l_tax_line_id zx_lines.tax_line_id%type; -- Bug 4908196
3147: l_return_status VARCHAR2(1);
3148:
3149: BEGIN
3150: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3167: FROM ZX_LINES tax

3163: SELECT tax.last_manual_entry
3164: , tax.tax_line_id
3165: INTO l_last_manual_entry
3166: , l_tax_line_id
3167: FROM ZX_LINES tax
3168: WHERE tax.application_id = p_event_class_rec.application_id
3169: AND tax.entity_code = p_event_class_rec.entity_code
3170: AND tax.event_class_code = p_event_class_rec.event_class_code
3171: AND tax.trx_id = p_event_class_rec.trx_id

Line 3181: UPDATE ZX_LINES

3177:
3178: IF l_last_manual_entry = 'TAX_AMOUNT' THEN
3179: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage is not null OR
3180: ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount is not null THEN
3181: UPDATE ZX_LINES
3182: SET tax_rate = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage,
3183: taxable_amt = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount
3184: WHERE tax_line_id = l_tax_line_id;
3185: END IF;

Line 3193: UPDATE ZX_LINES

3189: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'The tax partner cannot modify an overridden tax rate');
3191: END IF;
3192: ELSIF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount is not null THEN
3193: UPDATE ZX_LINES
3194: SET taxable_amt = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount
3195: WHERE tax_line_id = l_tax_line_id;
3196: END IF;
3197: END IF; --last_manual_entry

Line 3199: UPDATE ZX_LINES

3195: WHERE tax_line_id = l_tax_line_id;
3196: END IF;
3197: END IF; --last_manual_entry
3198: ELSE
3199: UPDATE ZX_LINES
3200: SET tax_rate = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage,
3201: taxable_amt = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount
3202: WHERE application_id = p_event_class_rec.application_id
3203: AND entity_code = p_event_class_rec.entity_code

Line 3244: SELECT /+ INDEX (TAX ZX_LINES_U1) /

3240: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3241: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3242: END IF;
3243:
3244: SELECT /*+ INDEX (TAX ZX_LINES_U1) */
3245: sum(nvl(tax.tax_amt,0))
3246: INTO l_tax_amount
3247: FROM ZX_LINES tax
3248: WHERE tax.application_id = p_application_id

Line 3247: FROM ZX_LINES tax

3243:
3244: SELECT /*+ INDEX (TAX ZX_LINES_U1) */
3245: sum(nvl(tax.tax_amt,0))
3246: INTO l_tax_amount
3247: FROM ZX_LINES tax
3248: WHERE tax.application_id = p_application_id
3249: AND tax.entity_code = p_entity_code
3250: AND tax.event_class_code = p_event_class_code
3251: AND tax.trx_id = p_trx_id