APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on FND_GLOBAL

Line 233: WHERE user_id = FND_GLOBAL.user_id();

229: -- Get the resource ids of the current user.
230: CURSOR user_csr IS
231: SELECT resource_id
232: FROM jtf_rs_resource_extns
233: WHERE user_id = FND_GLOBAL.user_id();
234:
235:
236: -- Get all the groups for a resource id.
237: CURSOR group_csr(l_resource_id NUMBER) IS

Line 259: l_user_id := FND_GLOBAL.user_id();

255: -- 1. Add the string 'no_acl' to the ACL keys.
256: x_keys := 'no_acl' || ' ';
257:
258: -- 2. Add the current user o to the ACL keys.
259: l_user_id := FND_GLOBAL.user_id();
260: x_keys := x_keys || 'o' || to_char(l_user_id) || ' ';
261:
262: -- 3. If (the current user has admin responsibility), then add
263: -- 'admin_acl' and return the list of ACL keys.

Line 372: l_user_id := FND_GLOBAL.user_id;

368: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
369: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
370: END IF;
371:
372: l_user_id := FND_GLOBAL.user_id;
373: l_resp_id := FND_GLOBAL.RESP_ID;
374: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
375: l_resp_appl_id := 510;
376:

Line 373: l_resp_id := FND_GLOBAL.RESP_ID;

369: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
370: END IF;
371:
372: l_user_id := FND_GLOBAL.user_id;
373: l_resp_id := FND_GLOBAL.RESP_ID;
374: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
375: l_resp_appl_id := 510;
376:
377: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);

Line 374: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;

370: END IF;
371:
372: l_user_id := FND_GLOBAL.user_id;
373: l_resp_id := FND_GLOBAL.RESP_ID;
374: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
375: l_resp_appl_id := 510;
376:
377: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);
378: MO_GLOBAL.init('OKC');

Line 377: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);

373: l_resp_id := FND_GLOBAL.RESP_ID;
374: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
375: l_resp_appl_id := 510;
376:
377: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);
378: MO_GLOBAL.init('OKC');
379:
380:
381:

Line 563: WHERE user_id = FND_GLOBAL.user_id;

559: -- 1. Get the resource_id associated with the current user.
560: SELECT resource_id
561: INTO l_resource_id
562: FROM jtf_rs_resource_extns
563: WHERE user_id = FND_GLOBAL.user_id;
564:
565: -- 2. If the resource_id is null, return 'NONE'.
566: IF (l_resource_id = NULL)
567: THEN