APPS.ZX_SECURITY dependencies on DBMS_SESSION

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 411: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));

407: L_FIRST_PARTY_ORG_ID,
408: l_return_status);
409:
410:
411: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));
412: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));
413: IF L_FIRST_PARTY_ORG_ID = G_FIRST_PARTY_ORG_ID THEN
414: NULL;
415: ELSE

Line 412: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));

408: l_return_status);
409:
410:
411: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));
412: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));
413: IF L_FIRST_PARTY_ORG_ID = G_FIRST_PARTY_ORG_ID THEN
414: NULL;
415: ELSE
416: name_value('FIRSTPTYORGID',to_char(L_FIRST_PARTY_ORG_ID));

Line 479: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));

475: L_FIRST_PARTY_ORG_ID,
476: l_return_status);
477:
478:
479: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));
480: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));
481:
482: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 480: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));

476: l_return_status);
477:
478:
479: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));
480: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));
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',

Line 551: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));

547: L_EFFECTIVE_DATE := nvl(p_effective_date,sysdate);
548:
549: L_FIRST_PARTY_ORG_ID := p_first_party_org_id;
550:
551: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));
552: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));
553:
554: IF L_FIRST_PARTY_ORG_ID = G_FIRST_PARTY_ORG_ID THEN
555: NULL;

Line 552: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));

548:
549: L_FIRST_PARTY_ORG_ID := p_first_party_org_id;
550:
551: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));
552: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));
553:
554: IF L_FIRST_PARTY_ORG_ID = G_FIRST_PARTY_ORG_ID THEN
555: NULL;
556: ELSE

Line 582: dbms_session.set_context('my_ctx',name,value);

578: PROCEDURE name_value(name varchar2, value varchar2) as
579:
580: BEGIN
581:
582: dbms_session.set_context('my_ctx',name,value);
583:
584: END;
585:
586: END zx_security;