eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on FND_PROFILE

Line 1104: AND information_type = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP')

1100: CURSOR c_asg_geo_node (cp_assignment_id NUMBER) IS
1101: SELECT aei_information1
1102: FROM per_assignment_extra_info
1103: WHERE assignment_id = cp_assignment_id
1104: AND information_type = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP')
1105: AND aei_information_category = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP');
1106:
1107: -- Cursor to fetch GEO node at location EIT level
1108: CURSOR c_loc_geo_node (cp_location_id NUMBER) IS

Line 1105: AND aei_information_category = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP');

1101: SELECT aei_information1
1102: FROM per_assignment_extra_info
1103: WHERE assignment_id = cp_assignment_id
1104: AND information_type = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP')
1105: AND aei_information_category = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP');
1106:
1107: -- Cursor to fetch GEO node at location EIT level
1108: CURSOR c_loc_geo_node (cp_location_id NUMBER) IS
1109: SELECT lei_information1

Line 1112: AND information_type = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP')

1108: CURSOR c_loc_geo_node (cp_location_id NUMBER) IS
1109: SELECT lei_information1
1110: FROM hr_location_extra_info
1111: WHERE location_id = cp_location_id
1112: AND information_type = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP')
1113: AND lei_information_category = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP');
1114:
1115: -- Cursor to fetch GEO node at business group legislation level
1116: CURSOR c_bg_geo_node (cp_business_group_id NUMBER) IS

Line 1113: AND lei_information_category = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP');

1109: SELECT lei_information1
1110: FROM hr_location_extra_info
1111: WHERE location_id = cp_location_id
1112: AND information_type = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP')
1113: AND lei_information_category = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP');
1114:
1115: -- Cursor to fetch GEO node at business group legislation level
1116: CURSOR c_bg_geo_node (cp_business_group_id NUMBER) IS
1117: SELECT org_information9

Line 1773: l_bg_id := FND_PROFILE.Value('PER_BUSINESS_GROUP_ID');

1769: l_proc := 'hr_cal_event_mapping_pkg.get_all_cal_events';
1770: hr_utility.set_location('Entering: '|| l_proc, 10);
1771: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1772: l_cal_event_varray := per_cal_event_varray(); -- initialize empty
1773: l_bg_id := FND_PROFILE.Value('PER_BUSINESS_GROUP_ID');
1774: l_start_date := TRUNC(p_start_date);
1775: l_end_date := TRUNC(p_end_date);
1776:
1777: OPEN c_cal_events (p_event_type