APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on MO_GLOBAL

Line 348: l_ou_tab MO_GLOBAL.OrgIdTab;

344: PROCEDURE get_current_user_moac_keys
345: ( x_keys OUT NOCOPY VARCHAR2)
346: IS
347: l_api_name VARCHAR2(30);
348: l_ou_tab MO_GLOBAL.OrgIdTab;
349:
350: l_user_id NUMBER;
351: l_resp_id NUMBER;
352: l_resp_appl_id NUMBER;

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

354:
355: CURSOR get_moac_org_id IS
356: SELECT ou.organization_id org_id
357: FROM hr_operating_units ou
358: WHERE mo_global.check_access(ou.organization_id) = 'Y';
359:
360:
361: BEGIN
362:

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

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

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

378: MO_GLOBAL.init('OKC');
379:
380:
381:
382: -- 1. Call MO_GLOBAL.get_ou_tab to get the current user's accessible
383: -- operating units in a temporary table.
384: --
385: -- (Uncomment the following for testing purposes)
386: -- MO_GLOBAL.init('OKC');

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

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

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

383: -- operating units in a temporary table.
384: --
385: -- (Uncomment the following for testing purposes)
386: -- MO_GLOBAL.init('OKC');
387: -- MO_GLOBAL.set_policy_context('M',204);
388: --l_ou_tab := MO_GLOBAL.get_ou_tab;//Commented this.Using the cursor instead
389:
390: OPEN get_moac_org_id;
391: FETCH get_moac_org_id BULK COLLECT INTO l_ou_tab;

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

384: --
385: -- (Uncomment the following for testing purposes)
386: -- MO_GLOBAL.init('OKC');
387: -- MO_GLOBAL.set_policy_context('M',204);
388: --l_ou_tab := MO_GLOBAL.get_ou_tab;//Commented this.Using the cursor instead
389:
390: OPEN get_moac_org_id;
391: FETCH get_moac_org_id BULK COLLECT INTO l_ou_tab;
392: CLOSE get_moac_org_id;