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.OKC_CONTEXT dependencies on DBMS_SESSION

Line 52: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',NVL(FND_PROFILE.VALUE('ORG_ID'),-99));

48: -- Sets the org_id to a context namespace attribute.
49: IF p_org_id IS NULL OR p_org_id = -99 THEN
50: --mmadhavi changes for MOAC project
51: /*
52: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',NVL(FND_PROFILE.VALUE('ORG_ID'),-99));
53: ELSE
54: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',p_org_id);
55: END IF;
56: */

Line 54: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',p_org_id);

50: --mmadhavi changes for MOAC project
51: /*
52: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',NVL(FND_PROFILE.VALUE('ORG_ID'),-99));
53: ELSE
54: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',p_org_id);
55: END IF;
56: */
57:
58: mo_utils.get_default_ou(l_default_org_id, l_default_ou_name, l_ou_count);

Line 80: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',

76:
77: IF p_organization_id IS NULL THEN
78: -- Added By Jvorugan for Bug:4729941
79: IF l_org_id IS NOT NULL THEN
80: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',
81: NVL(OE_PROFILE.VALUE('OE_ORGANIZATION_ID',l_org_id),-99)); --Mmadhavi replaced get_okc_org_id with l_org_id
82: ELSE
83: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',-99);
84: END IF;

Line 83: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',-99);

79: IF l_org_id IS NOT NULL THEN
80: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',
81: NVL(OE_PROFILE.VALUE('OE_ORGANIZATION_ID',l_org_id),-99)); --Mmadhavi replaced get_okc_org_id with l_org_id
82: ELSE
83: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',-99);
84: END IF;
85: -- End of changes for Bug:4729941
86: ELSE
87: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',p_organization_id);

Line 87: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',p_organization_id);

83: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',-99);
84: END IF;
85: -- End of changes for Bug:4729941
86: ELSE
87: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',p_organization_id);
88: END IF;
89:
90: -- Sets the Inventory business_group_id to a context namespace attribute.
91:

Line 99: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','BUSINESS_GROUP_ID',l_business_group_id);

95: CLOSE c_bus_grp;
96:
97: l_business_group_id := NVL(l_business_group_id,-99);
98:
99: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','BUSINESS_GROUP_ID',l_business_group_id);
100:
101: END set_okc_org_context;
102:
103: -- Procedure set_okc_org_context(p_chr_id IN NUMBER)

Line 134: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','CHR_ID',p_chr_id); -- bug#2155926

130: l_business_group_id NUMBER;
131: l_org_id hr_operating_units.organization_id%TYPE;
132:
133: BEGIN
134: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','CHR_ID',p_chr_id); -- bug#2155926
135:
136: FOR l_c_chr IN c_chr
137: LOOP
138: --DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',l_c_chr.authoring_org_id);

Line 138: --DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',l_c_chr.authoring_org_id);

134: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','CHR_ID',p_chr_id); -- bug#2155926
135:
136: FOR l_c_chr IN c_chr
137: LOOP
138: --DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',l_c_chr.authoring_org_id);
139: --mmadhavi for MOAC project
140: mo_global.set_policy_context('S', l_c_chr.authoring_org_id);
141: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',l_c_chr.inv_organization_id);
142: l_org_id := l_c_chr.authoring_org_id ;

Line 141: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',l_c_chr.inv_organization_id);

137: LOOP
138: --DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORG_ID',l_c_chr.authoring_org_id);
139: --mmadhavi for MOAC project
140: mo_global.set_policy_context('S', l_c_chr.authoring_org_id);
141: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',l_c_chr.inv_organization_id);
142: l_org_id := l_c_chr.authoring_org_id ;
143: END LOOP;
144:
145: -- Sets the Inventory business_group_id to a context namespace attribute.

Line 153: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','BUSINESS_GROUP_ID',l_business_group_id);

149: CLOSE c_bus_grp;
150:
151: l_business_group_id := NVL(l_business_group_id,-99);
152:
153: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','BUSINESS_GROUP_ID',l_business_group_id);
154: END set_okc_org_context;
155:
156: -- Function get_okc_organization_id RETURN NUMBER
157: -- Returns the Inventory organization id.

Line 199: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_organization_id);

195: /*PROCEDURE restore_contexts
196: IS
197: BEGIN
198: MO_GLOBAL.set_policy_context(g_moac_access_mode, g_moac_current_org_id);
199: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_organization_id);
200: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_business_group_id);
201: END restore_contexts;*/
202:
203: ---modified for bug8936332

Line 200: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_business_group_id);

196: IS
197: BEGIN
198: MO_GLOBAL.set_policy_context(g_moac_access_mode, g_moac_current_org_id);
199: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_organization_id);
200: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_business_group_id);
201: END restore_contexts;*/
202:
203: ---modified for bug8936332
204:

Line 208: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_organization_id);

204:
205: PROCEDURE restore_contexts IS
206: BEGIN
207: MO_GLOBAL.set_policy_context(g_moac_access_mode, g_moac_current_org_id);
208: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_organization_id);
209: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','BUSINESS_GROUP_ID',g_okc_business_group_id);
210: END restore_contexts;
211:
212: ---modified for bug8936332

Line 209: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','BUSINESS_GROUP_ID',g_okc_business_group_id);

205: PROCEDURE restore_contexts IS
206: BEGIN
207: MO_GLOBAL.set_policy_context(g_moac_access_mode, g_moac_current_org_id);
208: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID',g_okc_organization_id);
209: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','BUSINESS_GROUP_ID',g_okc_business_group_id);
210: END restore_contexts;
211:
212: ---modified for bug8936332
213: