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_SECURITY

Line 306: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_determine_date(p_ptnr_tax_line_ind) := ZX_SECURITY.G_EFFECTIVE_DATE;

302: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.mrc_tax_line_flag(p_ptnr_tax_line_ind) := 'N'; -- Bug 5162537
303: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_apportionment_flag(p_ptnr_tax_line_ind) := 'N';
304: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_line_number(p_ptnr_tax_line_ind) := NUMBER_DUMMY;
305: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.taxable_amt_tax_curr(p_ptnr_tax_line_ind) := ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.taxable_amount(p_ptnr_tax_line_ind);
306: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_determine_date(p_ptnr_tax_line_ind) := ZX_SECURITY.G_EFFECTIVE_DATE;
307:
308: IF prev_trx_line_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.transaction_line_id(p_ptnr_tax_line_ind)
309: AND prev_trx_level_type = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_level_type(p_ptnr_tax_line_ind)
310: AND prev_application_id = p_event_class_rec.application_id

Line 1310: ' ZX_SECURITY.G_FIRST_PARTY_ORG_ID = ' || ZX_SECURITY.G_FIRST_PARTY_ORG_ID ||

1306: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1307: ' Application Id = ' || to_char(p_application_id) ||
1308: ' Entity code = ' || p_entity_code ||
1309: ' Event Class code = ' || p_event_class_code ||
1310: ' ZX_SECURITY.G_FIRST_PARTY_ORG_ID = ' || ZX_SECURITY.G_FIRST_PARTY_ORG_ID ||
1311: ' Tax Regime code = ' || p_tax_regime_code ||
1312: ' ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW =' || ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW);
1313: END IF;
1314:

Line 1315: l_tbl_index := dbms_utility.get_hash_value(to_char(p_application_id)||'$$'||p_entity_code||'$$'||p_event_class_code||'$$'||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||'$$'||p_tax_regime_code, 1, 8192);

1311: ' Tax Regime code = ' || p_tax_regime_code ||
1312: ' ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW =' || ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW);
1313: END IF;
1314:
1315: l_tbl_index := dbms_utility.get_hash_value(to_char(p_application_id)||'$$'||p_entity_code||'$$'||p_event_class_code||'$$'||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||'$$'||p_tax_regime_code, 1, 8192);
1316:
1317: IF tax_regime_tmp_tbl.exists(l_tbl_index)
1318: AND tax_regime_tmp_tbl(l_tbl_index).application_id = p_application_id
1319: AND tax_regime_tmp_tbl(l_tbl_index).entity_code = p_entity_code

Line 1321: AND tax_regime_tmp_tbl(l_tbl_index).first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID

1317: IF tax_regime_tmp_tbl.exists(l_tbl_index)
1318: AND tax_regime_tmp_tbl(l_tbl_index).application_id = p_application_id
1319: AND tax_regime_tmp_tbl(l_tbl_index).entity_code = p_entity_code
1320: AND tax_regime_tmp_tbl(l_tbl_index).event_class_code = p_event_class_code
1321: AND tax_regime_tmp_tbl(l_tbl_index).first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1322: AND tax_regime_tmp_tbl(l_tbl_index).tax_regime_code = p_tax_regime_code THEN
1323: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1325: ' Using tax_regime_tmp_tbl cache');

Line 1340: AND ZX_SECURITY.G_EFFECTIVE_DATE between

1336: WHERE reg.tax_regime_code = p_tax_regime_code
1337: AND srvc.regime_usage_id = reg.regime_usage_id
1338: AND srvc.enabled_flag = 'Y'
1339: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW
1340: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1341: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1342: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1343: AND NOT EXISTS (SELECT 1
1344: FROM ZX_SRVC_SBSCRPTN_EXCLS excl

Line 1341: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)

1337: AND srvc.regime_usage_id = reg.regime_usage_id
1338: AND srvc.enabled_flag = 'Y'
1339: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW
1340: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1341: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1342: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1343: AND NOT EXISTS (SELECT 1
1344: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
1345: WHERE excl.application_id = p_application_id

Line 1342: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID

1338: AND srvc.enabled_flag = 'Y'
1339: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW
1340: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1341: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1342: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1343: AND NOT EXISTS (SELECT 1
1344: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
1345: WHERE excl.application_id = p_application_id
1346: AND excl.entity_code = p_entity_code

Line 1362: tax_regime_tmp_tbl(l_tbl_index).first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID;

1358: tax_regime_tmp_tbl(l_tbl_index).srvc_provider_id := x_provider_id;
1359: tax_regime_tmp_tbl(l_tbl_index).application_id := p_application_id;
1360: tax_regime_tmp_tbl(l_tbl_index).entity_code := p_entity_code;
1361: tax_regime_tmp_tbl(l_tbl_index).event_class_code := p_event_class_code;
1362: tax_regime_tmp_tbl(l_tbl_index).first_pty_org_id := ZX_SECURITY.G_FIRST_PARTY_ORG_ID;
1363: tax_regime_tmp_tbl(l_tbl_index).tax_regime_code := p_tax_regime_code;
1364:
1365: END IF;
1366:

Line 1442: AND ZX_SECURITY.G_EFFECTIVE_DATE between

1438: AND srvc.regime_usage_id = reg.regime_usage_id
1439: AND srvc.enabled_flag = 'Y'
1440: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR
1441: srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW)
1442: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1443: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1444: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID;
1445:
1446: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1443: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)

1439: AND srvc.enabled_flag = 'Y'
1440: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR
1441: srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW)
1442: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1443: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1444: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID;
1445:
1446: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1447: SELECT party_name

Line 1444: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID;

1440: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR
1441: srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW)
1442: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1443: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1444: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID;
1445:
1446: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1447: SELECT party_name
1448: INTO l_provider_name

Line 2129: p_conversion_date => ZX_SECURITY.G_EFFECTIVE_DATE,

2125: ELSE
2126: l_exchange_rate := TO_NUMBER(NULL);
2127: ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency (p_from_currency => doc_curr.trx_currency_code,
2128: p_to_currency => currencies.tax_currency_code,
2129: p_conversion_date => ZX_SECURITY.G_EFFECTIVE_DATE,
2130: p_tax_conversion_type => currencies.exchange_rate_type,
2131: p_trx_conversion_type => p_event_class_rec.currency_conversion_type,
2132: p_to_curr_conv_rate => l_exchange_rate,
2133: p_from_amt => 1,

Line 2501: ZX_SECURITY.G_EFFECTIVE_DATE,

2497:
2498: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2499: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index),
2500: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2501: ZX_SECURITY.G_EFFECTIVE_DATE,
2502: l_tax_rec,
2503: l_return_status,
2504: l_error_buffer);
2505:

Line 2602: AND (ZX_SECURITY.G_EFFECTIVE_DATE between status.default_flg_effective_from AND nvl(status.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))

2598: FROM ZX_SCO_STATUS_B_V status
2599: WHERE status.tax_regime_code = p_tax_regime_code
2600: AND status.default_status_flag = 'Y'
2601: AND status.tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2602: AND (ZX_SECURITY.G_EFFECTIVE_DATE between status.default_flg_effective_from AND nvl(status.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))
2603: AND rownum = 1
2604: ORDER BY subscription_level_code; -- Bug#5395227
2605: EXCEPTION WHEN OTHERS THEN
2606: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2634: AND (ZX_SECURITY.G_EFFECTIVE_DATE between rate.default_flg_effective_from AND nvl(rate.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))

2630: AND rate.tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2631: AND rate.tax_status_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index)
2632: AND rate.tax_jurisdiction_code is null
2633: AND (rate.tax_class = l_tax_class or rate.tax_class IS NULL)
2634: AND (ZX_SECURITY.G_EFFECTIVE_DATE between rate.default_flg_effective_from AND nvl(rate.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))
2635: AND rownum = 1
2636: ORDER BY rate.tax_class NULLS LAST, rate.subscription_level_code; -- Bug#5395227
2637: EXCEPTION WHEN OTHERS THEN
2638: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2652: ZX_SECURITY.G_EFFECTIVE_DATE);

2648: OPEN get_def_tax_rate_csr(ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index),
2649: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2650: p_tax_regime_code,
2651: l_tax_class,
2652: ZX_SECURITY.G_EFFECTIVE_DATE);
2653:
2654: FETCH get_def_tax_rate_csr INTO
2655: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_rate_code(ptnr_tax_line_index),
2656: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.rate_type_code(ptnr_tax_line_index),

Line 2717: ZX_SECURITY.G_EFFECTIVE_DATE,

2713: /* bug#5395227 don't need to call again here
2714: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2715: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index),
2716: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2717: ZX_SECURITY.G_EFFECTIVE_DATE,
2718: l_tax_rec,
2719: l_return_status,
2720: l_error_buffer);
2721:

Line 2804: p_tax_determine_date => ZX_SECURITY.G_EFFECTIVE_DATE,

2800: --Call TCM routine to get first party tax registration number
2801: ZX_TCM_CONTROL_PKG.get_tax_registration (p_parent_ptp_id => ZX_GLOBAL_STRUCTURES_PKG.hq_estb_ptp_id(1),
2802: p_site_ptp_id => null,
2803: p_account_type_code => null,
2804: p_tax_determine_date => ZX_SECURITY.G_EFFECTIVE_DATE,
2805: p_tax => ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2806: p_tax_regime_code => p_tax_regime_code,
2807: p_jurisdiction_code => null,
2808: p_account_id => null,