APPS.IGI_SLS_CONTEXT_PKG dependencies on DBMS_SESSION

Line 60: DBMS_SESSION.SET_CONTEXT('IGI','SLS_ENABLED','N');

56: default security group
57: Bidisha S, 28 Mar 2002
58: */
59:
60: DBMS_SESSION.SET_CONTEXT('IGI','SLS_ENABLED','N');
61: DBMS_SESSION.SET_CONTEXT('IGI','SLS_GROUP_STATUS','N');
62: DBMS_SESSION.SET_CONTEXT('IGI','SLS_RESPONSIBILITY','N');
63:
64: FND_PROFILE.GET(l_sls_responsibility, l_resp);

Line 61: DBMS_SESSION.SET_CONTEXT('IGI','SLS_GROUP_STATUS','N');

57: Bidisha S, 28 Mar 2002
58: */
59:
60: DBMS_SESSION.SET_CONTEXT('IGI','SLS_ENABLED','N');
61: DBMS_SESSION.SET_CONTEXT('IGI','SLS_GROUP_STATUS','N');
62: DBMS_SESSION.SET_CONTEXT('IGI','SLS_RESPONSIBILITY','N');
63:
64: FND_PROFILE.GET(l_sls_responsibility, l_resp);
65:

Line 62: DBMS_SESSION.SET_CONTEXT('IGI','SLS_RESPONSIBILITY','N');

58: */
59:
60: DBMS_SESSION.SET_CONTEXT('IGI','SLS_ENABLED','N');
61: DBMS_SESSION.SET_CONTEXT('IGI','SLS_GROUP_STATUS','N');
62: DBMS_SESSION.SET_CONTEXT('IGI','SLS_RESPONSIBILITY','N');
63:
64: FND_PROFILE.GET(l_sls_responsibility, l_resp);
65:
66: IF l_resp = 'Y' THEN

Line 74: DBMS_SESSION.SET_CONTEXT('IGI','SLS_RESPONSIBILITY','Y');

70: FROM all_context
71: WHERE namespace = 'IGI';
72: */ -- Removed the above code as it is no longer required - ak bug3975504.
73:
74: DBMS_SESSION.SET_CONTEXT('IGI','SLS_RESPONSIBILITY','Y');
75:
76: /* R12 SLS uptake::
77: Removing the check if SLS is enabled for this org-id.
78: IF IGI_GEN.IS_REQ_INSTALLED('SLS')

Line 81: DBMS_SESSION.SET_CONTEXT('IGI','SLS_ENABLED','Y');

77: Removing the check if SLS is enabled for this org-id.
78: IF IGI_GEN.IS_REQ_INSTALLED('SLS')
79: THEN
80: */
81: DBMS_SESSION.SET_CONTEXT('IGI','SLS_ENABLED','Y');
82:
83: DBMS_SESSION.SET_CONTEXT('IGI','SLS_DEFAULT_SECURITY_GROUP',
84: FND_PROFILE.VALUE(l_default_security_name));
85:

Line 83: DBMS_SESSION.SET_CONTEXT('IGI','SLS_DEFAULT_SECURITY_GROUP',

79: THEN
80: */
81: DBMS_SESSION.SET_CONTEXT('IGI','SLS_ENABLED','Y');
82:
83: DBMS_SESSION.SET_CONTEXT('IGI','SLS_DEFAULT_SECURITY_GROUP',
84: FND_PROFILE.VALUE(l_default_security_name));
85:
86: -- Set to Security Group or default security Group
87: l_sec_grp := Nvl(FND_PROFILE.VALUE(l_security_name),

Line 90: DBMS_SESSION.SET_CONTEXT('IGI','SLS_SECURITY_GROUP',l_sec_grp);

86: -- Set to Security Group or default security Group
87: l_sec_grp := Nvl(FND_PROFILE.VALUE(l_security_name),
88: FND_PROFILE.VALUE(l_default_security_name));
89:
90: DBMS_SESSION.SET_CONTEXT('IGI','SLS_SECURITY_GROUP',l_sec_grp);
91:
92: Open C1 (l_sec_grp);
93: fetch c1 into l_status;
94: IF c1%NOTFOUND THEN

Line 99: DBMS_SESSION.SET_CONTEXT('IGI','SLS_GROUP_STATUS',l_status);

95: l_Status := 'N';
96: END IF;
97: CLOSE C1;
98:
99: DBMS_SESSION.SET_CONTEXT('IGI','SLS_GROUP_STATUS',l_status);
100:
101: /*
102: R12 SLS uptake::
103: Removing the check if SLS is enabled for this org-id.