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 262: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_determine_date(p_ptnr_tax_line_ind) := ZX_SECURITY.G_EFFECTIVE_DATE;

258: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.mrc_tax_line_flag(p_ptnr_tax_line_ind) := 'N'; -- Bug 5162537
259: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_apportionment_flag(p_ptnr_tax_line_ind) := 'N';
260: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_line_number(p_ptnr_tax_line_ind) := NUMBER_DUMMY;
261: 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);
262: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_determine_date(p_ptnr_tax_line_ind) := ZX_SECURITY.G_EFFECTIVE_DATE;
263:
264: IF prev_trx_line_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.transaction_line_id(p_ptnr_tax_line_ind)
265: AND prev_trx_level_type = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_level_type(p_ptnr_tax_line_ind)
266: AND prev_application_id = p_event_class_rec.application_id

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

1187: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1188: ' Application Id = ' || to_char(p_application_id) ||
1189: ' Entity code = ' || p_entity_code ||
1190: ' Event Class code = ' || p_event_class_code ||
1191: ' ZX_SECURITY.G_FIRST_PARTY_ORG_ID = ' || ZX_SECURITY.G_FIRST_PARTY_ORG_ID ||
1192: ' Tax Regime code = ' || p_tax_regime_code ||
1193: ' ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW =' || ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW);
1194: END IF;
1195:

Line 1196: 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);

1192: ' Tax Regime code = ' || p_tax_regime_code ||
1193: ' ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW =' || ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW);
1194: END IF;
1195:
1196: 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);
1197:
1198: IF tax_regime_tmp_tbl.exists(l_tbl_index) THEN
1199: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1200: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1216: AND ZX_SECURITY.G_EFFECTIVE_DATE between

1212: WHERE reg.tax_regime_code = p_tax_regime_code
1213: AND srvc.regime_usage_id = reg.regime_usage_id
1214: AND srvc.enabled_flag = 'Y'
1215: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW
1216: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1217: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1218: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1219: AND NOT EXISTS (SELECT 1
1220: FROM ZX_SRVC_SBSCRPTN_EXCLS excl

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

1213: AND srvc.regime_usage_id = reg.regime_usage_id
1214: AND srvc.enabled_flag = 'Y'
1215: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW
1216: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1217: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1218: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1219: AND NOT EXISTS (SELECT 1
1220: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
1221: WHERE excl.application_id = p_application_id

Line 1218: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID

1214: AND srvc.enabled_flag = 'Y'
1215: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW
1216: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1217: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1218: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1219: AND NOT EXISTS (SELECT 1
1220: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
1221: WHERE excl.application_id = p_application_id
1222: AND excl.entity_code = p_entity_code

Line 1313: AND ZX_SECURITY.G_EFFECTIVE_DATE between

1309: AND srvc.regime_usage_id = reg.regime_usage_id
1310: AND srvc.enabled_flag = 'Y'
1311: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR
1312: srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW)
1313: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1314: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1315: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID;
1316:
1317: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1310: AND srvc.enabled_flag = 'Y'
1311: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR
1312: srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW)
1313: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1314: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1315: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID;
1316:
1317: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1318: SELECT party_name

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

1311: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR
1312: srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW)
1313: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1314: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1315: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID;
1316:
1317: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1318: SELECT party_name
1319: INTO l_provider_name

Line 1956: p_conversion_date => ZX_SECURITY.G_EFFECTIVE_DATE,

1952: ZX_PTNR_SRVC_INTGRTN_PKG.G_TAX_CURRENCIES_TBL(l_counter).trx_line_currency_code := doc_curr.trx_currency_code;
1953:
1954: ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency (p_from_currency => currencies.tax_currency_code,
1955: p_to_currency => doc_curr.trx_currency_code,
1956: p_conversion_date => ZX_SECURITY.G_EFFECTIVE_DATE,
1957: p_tax_conversion_type => currencies.exchange_rate_type,
1958: p_trx_conversion_type => p_event_class_rec.currency_conversion_type,
1959: p_to_curr_conv_rate => ZX_PTNR_SRVC_INTGRTN_PKG.G_TAX_CURRENCIES_TBL(l_counter).exchange_rate,
1960: p_from_amt => 1,

Line 1964: p_trx_conversion_date => ZX_SECURITY.G_EFFECTIVE_DATE); --Bug7183884

1960: p_from_amt => 1,
1961: p_to_amt => l_to_amt,
1962: p_return_status => l_return_status,
1963: p_error_buffer => l_error_buffer,
1964: p_trx_conversion_date => ZX_SECURITY.G_EFFECTIVE_DATE); --Bug7183884
1965:
1966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1967: x_return_status := l_return_status;
1968: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2232: ZX_SECURITY.G_EFFECTIVE_DATE,

2228:
2229: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2230: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index),
2231: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2232: ZX_SECURITY.G_EFFECTIVE_DATE,
2233: l_tax_rec,
2234: l_return_status,
2235: l_error_buffer);
2236:

Line 2347: ZX_SECURITY.G_EFFECTIVE_DATE,

2343: /* bug#5395227 don't need to call again here
2344: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2345: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index),
2346: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2347: ZX_SECURITY.G_EFFECTIVE_DATE,
2348: l_tax_rec,
2349: l_return_status,
2350: l_error_buffer);
2351:

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

2391: FROM ZX_SCO_STATUS_B_V status
2392: WHERE status.tax_regime_code = p_tax_regime_code
2393: AND status.default_status_flag = 'Y'
2394: AND status.tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2395: AND (ZX_SECURITY.G_EFFECTIVE_DATE between status.default_flg_effective_from AND nvl(status.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))
2396: AND rownum = 1
2397: ORDER BY subscription_level_code; -- Bug#5395227
2398: EXCEPTION WHEN OTHERS THEN
2399: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2424: AND rate.tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2425: AND rate.tax_status_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index)
2426: AND rate.tax_jurisdiction_code is null
2427: AND (rate.tax_class = l_tax_class or rate.tax_class IS NULL)
2428: AND (ZX_SECURITY.G_EFFECTIVE_DATE between rate.default_flg_effective_from AND nvl(rate.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))
2429: AND rownum = 1
2430: ORDER BY rate.tax_class NULLS LAST, rate.subscription_level_code; -- Bug#5395227
2431: EXCEPTION WHEN OTHERS THEN
2432: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2448: ZX_SECURITY.G_EFFECTIVE_DATE);

2444: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index),
2445: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2446: p_tax_regime_code,
2447: l_tax_class,
2448: ZX_SECURITY.G_EFFECTIVE_DATE);
2449:
2450: FETCH get_def_tax_rate_csr INTO
2451: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_rate_code(ptnr_tax_line_index),
2452: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.rate_type_code(ptnr_tax_line_index),

Line 2525: p_tax_determine_date => ZX_SECURITY.G_EFFECTIVE_DATE,

2521: --Call TCM routine to get first party tax registration number
2522: ZX_TCM_CONTROL_PKG.get_tax_registration (p_parent_ptp_id => ZX_GLOBAL_STRUCTURES_PKG.hq_estb_ptp_id(1),
2523: p_site_ptp_id => null,
2524: p_account_type_code => null,
2525: p_tax_determine_date => ZX_SECURITY.G_EFFECTIVE_DATE,
2526: p_tax => ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),
2527: p_tax_regime_code => p_tax_regime_code,
2528: p_jurisdiction_code => null,
2529: p_account_id => null,