APPS.PN_MO_CACHE_UTILS dependencies on FND_PROFILE

Line 64: IF TO_NUMBER(fnd_profile.value('ORG_ID')) = p_org_id THEN

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';
66: ELSE
67: l_result := 'N';
68: END IF;

Line 93: IF TO_NUMBER(fnd_profile.value('ORG_ID')) = p_org_id THEN

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';
95: ELSE
96: l_result := 'N';
97: END IF;

Line 505: -- PURPOSE : wrapper function for fnd_profile.value() due to MO

501: END retrieve_org_id_specific;
502:
503: -------------------------------------------------------------------------------
504: -- FUNCTION : get_profile_value
505: -- PURPOSE : wrapper function for fnd_profile.value() due to MO
506: -- NOTE : temporarily assume either 1 or 0 entry for
507: -- pn_system_setup_options table (until MO is activated)
508: -- INVOKED FROM : get_profile_value in PNCOMMON.pld and *.pls files.
509: -- ARGUMENTS : IN p_profile_name, p_org_id

Line 576: WHERE org_id = nvl(p_org_id, fnd_profile.value('ORG_ID'));

572: recalc_ir_on_acc_chg_flag,
573: smallest_term_amount,
574: incl_terms_by_default_flag
575: FROM pn_system_setup_options
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

Line 651: l_answer := fnd_profile.value(p_profile_name);

647: l_answer := answer_cur.smallest_term_amount; --#@#Bug4291907
648: ELSIF UPPER(p_profile_name) = 'INCL_TERMS_BY_DEFAULT_FLAG' THEN
649: l_answer := answer_cur.incl_terms_by_default_flag;
650: ELSE
651: l_answer := fnd_profile.value(p_profile_name);
652: /* handle for non OU level profiles */
653: END IF;
654:
655: END LOOP;

Line 660: RETURN fnd_profile.value(p_profile_name);

656:
657: RETURN l_answer;
658:
659: ELSE
660: RETURN fnd_profile.value(p_profile_name);
661: END IF;
662:
663: END get_profile_value;
664: