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 366: l_user_id := FND_GLOBAL.user_id;

362: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
363: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
364: END IF;
365:
366: l_user_id := FND_GLOBAL.user_id;
367: l_resp_id := FND_GLOBAL.RESP_ID;
368: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
369: l_resp_appl_id := 510;
370:

Line 367: l_resp_id := FND_GLOBAL.RESP_ID;

363: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
364: END IF;
365:
366: l_user_id := FND_GLOBAL.user_id;
367: l_resp_id := FND_GLOBAL.RESP_ID;
368: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
369: l_resp_appl_id := 510;
370:
371: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);

Line 368: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;

364: END IF;
365:
366: l_user_id := FND_GLOBAL.user_id;
367: l_resp_id := FND_GLOBAL.RESP_ID;
368: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
369: l_resp_appl_id := 510;
370:
371: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);
372: MO_GLOBAL.init('OKC');

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

367: l_resp_id := FND_GLOBAL.RESP_ID;
368: l_security_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
369: l_resp_appl_id := 510;
370:
371: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);
372: MO_GLOBAL.init('OKC');
373:
374:
375:

Line 557: WHERE user_id = FND_GLOBAL.user_id;

553: -- 1. Get the resource_id associated with the current user.
554: SELECT resource_id
555: INTO l_resource_id
556: FROM jtf_rs_resource_extns
557: WHERE user_id = FND_GLOBAL.user_id;
558:
559: -- 2. If the resource_id is null, return 'NONE'.
560: IF (l_resource_id = NULL)
561: THEN