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_SECURITY dependencies on ZX_SECURITY

Line 1: PACKAGE BODY zx_security AS

1: PACKAGE BODY zx_security AS
2: /* $Header: zxifdtaccsecpvtb.pls 120.33.12010000.2 2008/11/12 12:29:24 spasala ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 11: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_SECURITY.';

7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_SECURITY.';
12:
13:
14:
15: FUNCTION get_effective_date RETURN DATE

Line 269: IF ZX_SECURITY.G_FIRST_PARTY_ORG_ID is not null THEN

265: RETURN VARCHAR2
266: IS
267: D_predicate VARCHAR2 (2000);
268: BEGIN
269: IF ZX_SECURITY.G_FIRST_PARTY_ORG_ID is not null THEN
270: D_predicate := ' content_owner_id = SYS_CONTEXT(''my_ctx'',''FIRSTPTYORGID'')';
271: ELSE
272: D_predicate := null;
273: END IF;

Line 285: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN','ZX_SECURITY: CHECK_WRITE_ACCESS()+');

281: IS
282: l_count NUMBER :=0;
283: BEGIN
284: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN','ZX_SECURITY: CHECK_WRITE_ACCESS()+');
286: END IF;
287:
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: IF fnd_profile.value('ZX_GCO_WRITE_ACCESS') = 'Y' then

Line 308: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.END','ZX_SECURITY: CHECK_WRITE_ACCESS()-');

304: and det.view_options_code = 'VFC';
305: END IF;
306:
307: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.END','ZX_SECURITY: CHECK_WRITE_ACCESS()-');
309: END IF;
310:
311: EXCEPTION
312: WHEN NO_DATA_FOUND THEN

Line 366: IF ZX_SECURITY.G_ICX_SESSION_ID is not null THEN

362: FUNCTION add_icx_session_id (D1 VARCHAR2, D2 VARCHAR2) RETURN VARCHAR2
363: IS
364: D_predicate VARCHAR2 (2000);
365: BEGIN
366: IF ZX_SECURITY.G_ICX_SESSION_ID is not null THEN
367: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
368: D_predicate := 'icx_session_id = SYS_CONTEXT(''my_ctx'',''SESSIONID'') ';
369: ELSE
370: D_predicate := null;

Line 367: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

363: IS
364: D_predicate VARCHAR2 (2000);
365: BEGIN
366: IF ZX_SECURITY.G_ICX_SESSION_ID is not null THEN
367: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
368: D_predicate := 'icx_session_id = SYS_CONTEXT(''my_ctx'',''SESSIONID'') ';
369: ELSE
370: D_predicate := null;
371: END IF;

Line 397: 'ZX_SECURITY: SET_SECURITY_CONTEXT()+' ||

393:
394: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.STRING(G_LEVEL_STATEMENT,
396: G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN',
397: 'ZX_SECURITY: SET_SECURITY_CONTEXT()+' ||
398: ', OU: '||to_char(p_internal_org_id)||' and LE: '||to_char(p_legal_entity_id));
399: END IF;
400:
401: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 443: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-'||

439:
440: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(G_LEVEL_STATEMENT,
442: G_MODULE_NAME||'SET_SECURITY_CONTEXT.END',
443: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-'||
444: ', G_EFFECTIVE_DATE: '||to_char(G_EFFECTIVE_DATE) ||
445: ', G_FIRST_PARTY_ORG_ID: '||to_char(G_FIRST_PARTY_ORG_ID));
446: END IF;
447:

Line 465: 'ZX_SECURITY: SET_SECURITY_CONTEXT()+' ||

461:
462: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
463: FND_LOG.STRING(G_LEVEL_STATEMENT,
464: G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN',
465: 'ZX_SECURITY: SET_SECURITY_CONTEXT()+' ||
466: ', OU: '||to_char(p_internal_org_id)||' and LE: '||to_char(p_legal_entity_id));
467: END IF;
468:
469: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 485: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-' ||

481:
482: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.STRING(G_LEVEL_STATEMENT,
484: G_MODULE_NAME||'SET_SECURITY_CONTEXT.END',
485: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-' ||
486: ', G_EFFECTIVE_DATE: '||nvl(SYS_CONTEXT('my_ctx','EFFECTIVEDATE'),sysdate) ||
487: ', G_FIRST_PARTY_ORG_ID:
488: '||to_char(nvl(SYS_CONTEXT('my_ctx','FIRSTPTYORGID'),-999)) );
489: END IF;

Line 522: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-'||

518:
519: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
520: FND_LOG.STRING(G_LEVEL_STATEMENT,
521: G_MODULE_NAME||'SET_SECURITY_CONTEXT.END',
522: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-'||
523: ', G_EFFECTIVE_DATE: '||to_char(G_EFFECTIVE_DATE) ||
524: ', G_FIRST_PARTY_ORG_ID: '||to_char(G_FIRST_PARTY_ORG_ID));
525: END IF;
526:

Line 542: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN','ZX_SECURITY: SET_SECURITY_CONTEXT()+');

538:
539: BEGIN
540:
541: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN','ZX_SECURITY: SET_SECURITY_CONTEXT()+');
543: END IF;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:

Line 571: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-' ||

567:
568: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
569: FND_LOG.STRING(G_LEVEL_STATEMENT,
570: G_MODULE_NAME||'SET_SECURITY_CONTEXT.END',
571: 'ZX_SECURITY: SET_SECURITY_CONTEXT()-' ||
572: ', G_EFFECTIVE_DATE: '||to_char(G_EFFECTIVE_DATE) ||
573: ', G_FIRST_PARTY_ORG_ID: '||to_char(G_FIRST_PARTY_ORG_ID) );
574: END IF;
575:

Line 586: END zx_security;

582: dbms_session.set_context('my_ctx',name,value);
583:
584: END;
585:
586: END zx_security;