DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on FND_PROFILE

Line 383: if(fnd_profile.value('ICX_PREFERRED_CURRENCY') is not null and fnd_profile.value('ICX_PREFERRED_CURRENCY') <> 'ANY') then

379:
380: FUNCTION getLoginPrsnCurrencyCode RETURN VARCHAR2
381: IS
382: BEGIN
383: if(fnd_profile.value('ICX_PREFERRED_CURRENCY') is not null and fnd_profile.value('ICX_PREFERRED_CURRENCY') <> 'ANY') then
384: return fnd_profile.value('ICX_PREFERRED_CURRENCY');
385: else
386: return hr_util_misc_ss.g_loginPrsnCurrencyCode;
387: end if;

Line 384: return fnd_profile.value('ICX_PREFERRED_CURRENCY');

380: FUNCTION getLoginPrsnCurrencyCode RETURN VARCHAR2
381: IS
382: BEGIN
383: if(fnd_profile.value('ICX_PREFERRED_CURRENCY') is not null and fnd_profile.value('ICX_PREFERRED_CURRENCY') <> 'ANY') then
384: return fnd_profile.value('ICX_PREFERRED_CURRENCY');
385: else
386: return hr_util_misc_ss.g_loginPrsnCurrencyCode;
387: end if;
388: END;

Line 422: l_fte_profile_value VARCHAR2(30) := fnd_profile.VALUE('PER_ANNUAL_SALARY_ON_FTE');

418: ,p_grade_annual_factor in number
419: ,p_grade_basis in varchar2
420: ,p_grade_mid_value in number
421: ) return number is
422: l_fte_profile_value VARCHAR2(30) := fnd_profile.VALUE('PER_ANNUAL_SALARY_ON_FTE');
423: l_pay_factor number;
424: l_fte_factor NUMBER;
425: ln_annual_salary NUMBER;
426: ln_grade_mid_point number;

Line 1485: lv_segment_name1 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT1');

1481: ltt_segment(29).value := segment_rec.segment29;
1482: ltt_segment(30).value := segment_rec.segment30;
1483: END LOOP;
1484:
1485: lv_segment_name1 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT1');
1486: lv_segment_name2 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT2');
1487:
1488: IF lv_segment_name1 IS NULL
1489: THEN

Line 1486: lv_segment_name2 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT2');

1482: ltt_segment(30).value := segment_rec.segment30;
1483: END LOOP;
1484:
1485: lv_segment_name1 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT1');
1486: lv_segment_name2 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT2');
1487:
1488: IF lv_segment_name1 IS NULL
1489: THEN
1490: RETURN ltt_segment(0).value;--job_name

Line 1493: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

1489: THEN
1490: RETURN ltt_segment(0).value;--job_name
1491: END IF;
1492:
1493: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1494:
1495: OPEN lc_get_job_flex_id(p_business_group_id => ln_business_group_id);
1496: FETCH lc_get_job_flex_id INTO ln_flex_num;
1497: IF lc_get_job_flex_id%NOTFOUND

Line 1635: lv_segment_name1 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT1');

1631: ltt_segment(29).value := segment_rec.segment29;
1632: ltt_segment(30).value := segment_rec.segment30;
1633: END LOOP;
1634:
1635: lv_segment_name1 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT1');
1636: lv_segment_name2 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT2');
1637:
1638: IF lv_segment_name1 IS NULL
1639: THEN

Line 1636: lv_segment_name2 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT2');

1632: ltt_segment(30).value := segment_rec.segment30;
1633: END LOOP;
1634:
1635: lv_segment_name1 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT1');
1636: lv_segment_name2 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT2');
1637:
1638: IF lv_segment_name1 IS NULL
1639: THEN
1640: RETURN ltt_segment(0).value;--grade_name

Line 1643: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

1639: THEN
1640: RETURN ltt_segment(0).value;--grade_name
1641: END IF;
1642:
1643: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1644:
1645: OPEN lc_get_grade_flex_id(p_business_group_id => ln_business_group_id);
1646: FETCH lc_get_grade_flex_id INTO ln_flex_num;
1647: IF lc_get_grade_flex_id%NOTFOUND

Line 1791: lv_segment_name1 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT1');

1787: ltt_segment(29).value := segment_rec.segment29;
1788: ltt_segment(30).value := segment_rec.segment30;
1789: END LOOP;
1790:
1791: lv_segment_name1 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT1');
1792: lv_segment_name2 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT2');
1793:
1794: IF lv_segment_name1 IS NULL
1795: THEN

Line 1792: lv_segment_name2 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT2');

1788: ltt_segment(30).value := segment_rec.segment30;
1789: END LOOP;
1790:
1791: lv_segment_name1 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT1');
1792: lv_segment_name2 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT2');
1793:
1794: IF lv_segment_name1 IS NULL
1795: THEN
1796: RETURN ltt_segment(0).value;--position_name

Line 1799: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

1795: THEN
1796: RETURN ltt_segment(0).value;--position_name
1797: END IF;
1798:
1799: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1800:
1801: OPEN lc_get_position_flex_id(p_business_group_id => ln_business_group_id);
1802: FETCH lc_get_position_flex_id INTO ln_flex_num;
1803: IF lc_get_position_flex_id%NOTFOUND