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: --Bug 10200208
369: --D_predicate := 'icx_session_id = SYS_CONTEXT(''my_ctx'',''SESSIONID'') ';
370: D_predicate := 'NVL(icx_session_id,-999) = NVL(SYS_CONTEXT(''my_ctx'',''SESSIONID''),-999) ';
371: ELSE

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

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

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

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

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

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

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

478: l_return_status);
479:
480:
481: -- dbms_session.set_context('my_ctx','FIRSTPTYORGID',to_char(G_FIRST_PARTY_ORG_ID));
482: -- dbms_session.set_context('my_ctx','EFFECTIVEDATE',to_char(G_EFFECTIVE_DATE));
483:
484: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.STRING(G_LEVEL_STATEMENT,
486: G_MODULE_NAME||'SET_SECURITY_CONTEXT.END',

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

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

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

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

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

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