APPS.PN_MO_CACHE_UTILS dependencies on PN_MO_CACHE_UTILS

Line 1: PACKAGE BODY pn_mo_cache_utils AS

1: PACKAGE BODY pn_mo_cache_utils AS
2: /* $Header: PNMOCSHB.pls 120.7 2007/09/11 16:10:29 rthumma ship $ */
3:
4: /** Added these two functions to remove dependency on MO packages
5: * until shared services changes is effective

Line 32: IF pn_mo_cache_utils.is_MOAC_enabled THEN

28: SELECT multi_org_flag
29: FROM fnd_product_groups;
30:
31: BEGIN
32: IF pn_mo_cache_utils.is_MOAC_enabled THEN
33: l_result := mo_global.is_multi_org_enabled;
34: ELSE
35: FOR cur IN flag LOOP
36: l_result := cur.multi_org_flag;

Line 61: IF pn_mo_cache_utils.is_MOAC_enabled THEN

57: FUNCTION check_access(p_org_id NUMBER) RETURN VARCHAR2
58: IS
59: l_result VARCHAR2(1) := 'N';
60: BEGIN
61: IF pn_mo_cache_utils.is_MOAC_enabled THEN
62: l_result := mo_global.check_access(p_org_id);
63: ELSE
64: IF TO_NUMBER(fnd_profile.value('ORG_ID')) = p_org_id THEN
65: l_result := 'Y';

Line 90: IF pn_mo_cache_utils.is_MOAC_enabled THEN

86: FUNCTION check_valid_org(p_org_id NUMBER) RETURN VARCHAR2 IS
87: l_result VARCHAR2(1);
88: BEGIN
89: l_result := 'N';
90: IF pn_mo_cache_utils.is_MOAC_enabled THEN
91: l_result := mo_global.check_valid_org(p_org_id);
92: ELSE
93: IF TO_NUMBER(fnd_profile.value('ORG_ID')) = p_org_id THEN
94: l_result := 'Y';

Line 176: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN

172: -------------------------------------------------------------------------------
173: PROCEDURE retrieve_globals(p_globals OUT NOCOPY GlobalsTable )
174: IS
175: BEGIN
176: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN
177: SELECT pn.org_id,
178: gl.name,
179: gl.chart_of_accounts_id,
180: hr.name,

Line 255: WHERE pn_mo_cache_utils.check_access(pn.org_id) = 'Y'

251: p_globals.incl_terms_by_default_flag_t
252: FROM hr_legal_entities hr,
253: gl_sets_of_books gl,
254: pn_system_setup_options pn
255: WHERE pn_mo_cache_utils.check_access(pn.org_id) = 'Y'
256: AND gl.set_of_books_id = pn.set_of_books_id
257: AND hr.organization_id (+) = pn.org_id;
258:
259: ELSE -- non multi org case

Line 343: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN

339:
340: END IF;
341: EXCEPTION
342: WHEN OTHERS THEN
343: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN
344: raise_application_error(-20001,'Error: no data found in multi org table' || to_char(sqlcode));
345: app_exception.raise_exception;
346: ELSE -- non multi org
347: raise_application_error(-20001,'Error: no data found in profile_setup table'|| to_char(sqlcode));

Line 440: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN

436: AND nvl(pn.org_id,l_dummy_org_id) = p_id;
437:
438: BEGIN
439:
440: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN
441: IF p_org_id IS NULL THEN
442: mo_utils.get_default_ou(l_dummy_org_id, l_name, l_count);
443: ELSE
444: l_dummy_org_id := p_org_id;

Line 580: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN

576: WHERE org_id = nvl(p_org_id, fnd_profile.value('ORG_ID'));
577:
578: BEGIN
579:
580: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN
581:
582: /* assume single-org */
583:
584: FOR answer_cur IN get_profile LOOP

Line 730: END pn_mo_cache_utils;

726: WHEN others THEN
727: RAISE;
728: END get_current_org_id;
729:
730: END pn_mo_cache_utils;