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
67: /* -- check for the existance of the IGI context
68: SELECT 'X'
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),
88: FND_PROFILE.VALUE(l_default_security_name));
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),
88: FND_PROFILE.VALUE(l_default_security_name));
89:
90: DBMS_SESSION.SET_CONTEXT('IGI','SLS_SECURITY_GROUP',l_sec_grp);
91:
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),
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);