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 1442: lv_segment_name1 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT1');

1438: ltt_segment(29).value := segment_rec.segment29;
1439: ltt_segment(30).value := segment_rec.segment30;
1440: END LOOP;
1441:
1442: lv_segment_name1 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT1');
1443: lv_segment_name2 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT2');
1444:
1445: IF lv_segment_name1 IS NULL
1446: THEN

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

1439: ltt_segment(30).value := segment_rec.segment30;
1440: END LOOP;
1441:
1442: lv_segment_name1 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT1');
1443: lv_segment_name2 := fnd_profile.value('HR_JOB_KEYFLEX_SEGMENT2');
1444:
1445: IF lv_segment_name1 IS NULL
1446: THEN
1447: RETURN ltt_segment(0).value;--job_name

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

1446: THEN
1447: RETURN ltt_segment(0).value;--job_name
1448: END IF;
1449:
1450: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1451:
1452: OPEN lc_get_job_flex_id(p_business_group_id => ln_business_group_id);
1453: FETCH lc_get_job_flex_id INTO ln_flex_num;
1454: IF lc_get_job_flex_id%NOTFOUND

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

1588: ltt_segment(29).value := segment_rec.segment29;
1589: ltt_segment(30).value := segment_rec.segment30;
1590: END LOOP;
1591:
1592: lv_segment_name1 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT1');
1593: lv_segment_name2 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT2');
1594:
1595: IF lv_segment_name1 IS NULL
1596: THEN

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

1589: ltt_segment(30).value := segment_rec.segment30;
1590: END LOOP;
1591:
1592: lv_segment_name1 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT1');
1593: lv_segment_name2 := fnd_profile.value('HR_GRADE_KEYFLEX_SEGMENT2');
1594:
1595: IF lv_segment_name1 IS NULL
1596: THEN
1597: RETURN ltt_segment(0).value;--grade_name

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

1596: THEN
1597: RETURN ltt_segment(0).value;--grade_name
1598: END IF;
1599:
1600: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1601:
1602: OPEN lc_get_grade_flex_id(p_business_group_id => ln_business_group_id);
1603: FETCH lc_get_grade_flex_id INTO ln_flex_num;
1604: IF lc_get_grade_flex_id%NOTFOUND

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

1744: ltt_segment(29).value := segment_rec.segment29;
1745: ltt_segment(30).value := segment_rec.segment30;
1746: END LOOP;
1747:
1748: lv_segment_name1 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT1');
1749: lv_segment_name2 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT2');
1750:
1751: IF lv_segment_name1 IS NULL
1752: THEN

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

1745: ltt_segment(30).value := segment_rec.segment30;
1746: END LOOP;
1747:
1748: lv_segment_name1 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT1');
1749: lv_segment_name2 := fnd_profile.value('HR_POS_KEYFLEX_SEGMENT2');
1750:
1751: IF lv_segment_name1 IS NULL
1752: THEN
1753: RETURN ltt_segment(0).value;--position_name

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

1752: THEN
1753: RETURN ltt_segment(0).value;--position_name
1754: END IF;
1755:
1756: ln_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1757:
1758: OPEN lc_get_position_flex_id(p_business_group_id => ln_business_group_id);
1759: FETCH lc_get_position_flex_id INTO ln_flex_num;
1760: IF lc_get_position_flex_id%NOTFOUND