APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on MO_GLOBAL

Line 342: l_ou_tab MO_GLOBAL.OrgIdTab;

338: PROCEDURE get_current_user_moac_keys
339: ( x_keys OUT NOCOPY VARCHAR2)
340: IS
341: l_api_name VARCHAR2(30);
342: l_ou_tab MO_GLOBAL.OrgIdTab;
343:
344: l_user_id NUMBER;
345: l_resp_id NUMBER;
346: l_resp_appl_id NUMBER;

Line 352: WHERE mo_global.check_access(ou.organization_id) = 'Y';

348:
349: CURSOR get_moac_org_id IS
350: SELECT ou.organization_id org_id
351: FROM hr_operating_units ou
352: WHERE mo_global.check_access(ou.organization_id) = 'Y';
353:
354:
355: BEGIN
356:

Line 372: MO_GLOBAL.init('OKC');

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:
376: -- 1. Call MO_GLOBAL.get_ou_tab to get the current user's accessible

Line 376: -- 1. Call MO_GLOBAL.get_ou_tab to get the current user's accessible

372: MO_GLOBAL.init('OKC');
373:
374:
375:
376: -- 1. Call MO_GLOBAL.get_ou_tab to get the current user's accessible
377: -- operating units in a temporary table.
378: --
379: -- (Uncomment the following for testing purposes)
380: -- MO_GLOBAL.init('OKC');

Line 380: -- MO_GLOBAL.init('OKC');

376: -- 1. Call MO_GLOBAL.get_ou_tab to get the current user's accessible
377: -- operating units in a temporary table.
378: --
379: -- (Uncomment the following for testing purposes)
380: -- MO_GLOBAL.init('OKC');
381: -- MO_GLOBAL.set_policy_context('M',204);
382: --l_ou_tab := MO_GLOBAL.get_ou_tab;//Commented this.Using the cursor instead
383:
384: OPEN get_moac_org_id;

Line 381: -- MO_GLOBAL.set_policy_context('M',204);

377: -- operating units in a temporary table.
378: --
379: -- (Uncomment the following for testing purposes)
380: -- MO_GLOBAL.init('OKC');
381: -- MO_GLOBAL.set_policy_context('M',204);
382: --l_ou_tab := MO_GLOBAL.get_ou_tab;//Commented this.Using the cursor instead
383:
384: OPEN get_moac_org_id;
385: FETCH get_moac_org_id BULK COLLECT INTO l_ou_tab;

Line 382: --l_ou_tab := MO_GLOBAL.get_ou_tab;//Commented this.Using the cursor instead

378: --
379: -- (Uncomment the following for testing purposes)
380: -- MO_GLOBAL.init('OKC');
381: -- MO_GLOBAL.set_policy_context('M',204);
382: --l_ou_tab := MO_GLOBAL.get_ou_tab;//Commented this.Using the cursor instead
383:
384: OPEN get_moac_org_id;
385: FETCH get_moac_org_id BULK COLLECT INTO l_ou_tab;
386: CLOSE get_moac_org_id;