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.

APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on HR_CAL_EVENT_MAPPING_PKG

Line 1: PACKAGE BODY hr_cal_event_mapping_pkg AS

1: PACKAGE BODY hr_cal_event_mapping_pkg AS
2: -- $Header: pecalmap.pkb 120.8 2009/11/04 14:02:31 tkghosh ship $
3:
4: --
5: -----------------------------------------------------------------------------

Line 125: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.get_org_hier_elements';

121: FROM per_org_structure_elements
122: WHERE org_structure_version_id = cp_osv_id
123: AND organization_id_parent = cp_par_org_id;
124: BEGIN
125: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.get_org_hier_elements';
126: hr_utility.set_location('Entering '||l_proc,10);
127:
128: -- Populate hierarchy Level 1 to stack
129: l_level := 1;

Line 191: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.write_org_cache';

187: l_ovr_id per_cal_entry_values.cal_entry_value_id%TYPE;
188: l_proc VARCHAR2(100);
189:
190: BEGIN
191: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.write_org_cache';
192: hr_utility.set_location('Entering '||l_proc,10);
193:
194: IF p_coverage_list.COUNT > 0 THEN
195: hr_utility.set_location(l_proc,12);

Line 250: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.is_org_in_list';

246: ) RETURN BOOLEAN IS
247: l_return BOOLEAN;
248: l_proc VARCHAR2(100);
249: BEGIN
250: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.is_org_in_list';
251: hr_utility.set_location('Entering '||l_proc,10);
252: l_return := FALSE;
253:
254: IF p_org_list.COUNT > 0 THEN

Line 291: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.get_child_org_nodes';

287: l_hier_top_case BOOLEAN;
288: l_proc VARCHAR2(100);
289:
290: BEGIN
291: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.get_child_org_nodes';
292: hr_utility.set_location('Entering '||l_proc,5);
293: l_result_count := 0;
294: l_parent_found := FALSE;
295: l_exclude_flag := FALSE;

Line 393: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.process_org_coverage';

389: l_coverage_list t_org_id_table;
390: l_exclusion_list t_org_id_table;
391: l_proc VARCHAR2(100);
392: BEGIN
393: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.process_org_coverage';
394: hr_utility.set_location('Entering '||l_proc,10);
395: l_exc_count := 0;
396: IF p_cal_event_table.COUNT > 0 THEN
397: hr_utility.set_location(l_proc,20);

Line 441: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.populate_org_list';

437: hr_utility.set_location('Leaving '||l_proc,30);
438: END process_org_coverage;
439:
440: BEGIN -- populate_org_list
441: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.populate_org_list';
442: hr_utility.set_location('Entering '||l_proc,10);
443:
444: -- Get identifiers for all the hierarchies that need to be processed
445: FOR l_osv_rec IN c_osv_ids LOOP

Line 646: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.write_geo_cache';

642: l_ovr_id per_cal_entry_values.cal_entry_value_id%TYPE;
643: l_proc VARCHAR2(100);
644:
645: BEGIN
646: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.write_geo_cache';
647: hr_utility.set_location('Entering '||l_proc,10);
648:
649: IF p_coverage_list.COUNT > 0 THEN
650: hr_utility.set_location(l_proc,12);

Line 707: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.is_node_in_list';

703: ) RETURN BOOLEAN IS
704: l_return BOOLEAN;
705: l_proc VARCHAR2(100);
706: BEGIN
707: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.is_node_in_list';
708: hr_utility.set_location('Entering '||l_proc,10);
709: hr_utility.set_location('p_node_id:'||p_node_id,11);
710: l_return := FALSE;
711:

Line 749: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.get_child_nodes';

745: l_exclude_flag BOOLEAN;
746: l_proc VARCHAR2(100);
747:
748: BEGIN
749: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.get_child_nodes';
750: hr_utility.set_location('Entering '||l_proc,10);
751:
752: l_result_count := 0;
753: l_parent_found := FALSE;

Line 858: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.process_geo_coverage';

854: l_proc VARCHAR2(100);
855: l_cov_count NUMBER;
856:
857: BEGIN
858: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.process_geo_coverage';
859: hr_utility.set_location('Entering '||l_proc,10);
860: l_exc_count := 0;
861: l_cov_count := 0;
862: IF p_cal_event_table.COUNT > 0 THEN

Line 915: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.populate_geo_list';

911: hr_utility.set_location('Leaving '||l_proc,90);
912: END process_geo_coverage;
913:
914: BEGIN -- populate_geo_list
915: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.populate_geo_list';
916: hr_utility.set_location('Entering '||l_proc,10);
917:
918: -- Get the identifiers for all the hierarchies that need to be processed.
919: FOR l_ghv_rec IN c_ghv_ids LOOP

Line 1018: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.build_event_cache';

1014: l_dummy BOOLEAN;
1015: l_proc VARCHAR2(100);
1016:
1017: BEGIN
1018: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.build_event_cache';
1019: hr_utility.set_location('Entering '||l_proc,10);
1020:
1021: -- Delete previous event org list records as this execution will
1022: -- refresh the list

Line 1220: l_proc := 'hr_cal_event_mapping_pkg.get_per_asg_cal_events';

1216: e_param_valdn_fail EXCEPTION;
1217: e_bg_leg_not_found EXCEPTION;
1218:
1219: BEGIN
1220: l_proc := 'hr_cal_event_mapping_pkg.get_per_asg_cal_events';
1221: hr_utility.set_location('Entering: '|| l_proc, 10);
1222:
1223: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1224: x_cal_event_varray := per_cal_event_varray(); -- initialize empty

Line 1571: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (PerVer)';

1567: l_cal_event_varray per_cal_event_varray;
1568:
1569: BEGIN
1570:
1571: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (PerVer)';
1572: hr_utility.set_location('Entering: '|| l_proc, 10);
1573:
1574: -- Invoke private procedure to get calendar events
1575: get_per_asg_cal_events (p_person_id => p_person_id

Line 1623: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (AsgVer)';

1619: WHERE assignment_id = cp_assignment_id;
1620:
1621: BEGIN
1622:
1623: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (AsgVer)';
1624: hr_utility.set_location('Entering: '|| l_proc, 10);
1625:
1626: -- Get the person id for an assignment id. Though multiple records could
1627: -- exist, the person id will be the same. So sufficient to fetch first.

Line 1685: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (HZVer)';

1681: AND orig_system_reference = 'PER:'||person_identifier;
1682:
1683: BEGIN
1684:
1685: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (HZVer)';
1686: hr_utility.set_location('Entering: '|| l_proc, 10);
1687:
1688: -- Get the person id for a party id. Though multiple records could
1689: -- exist, the person id will be the same. So sufficient to fetch first.

Line 1769: l_proc := 'hr_cal_event_mapping_pkg.get_all_cal_events';

1765: );
1766:
1767: BEGIN
1768:
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');

Line 1903: l_proc := 'hr_cal_event_mapping_pkg.build_cal_map_cache';

1899: l_cal_event_obj per_cal_event_obj;
1900:
1901: BEGIN
1902:
1903: l_proc := 'hr_cal_event_mapping_pkg.build_cal_map_cache';
1904: hr_utility.set_location('Entering: '|| l_proc, 10);
1905: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1906: l_cal_event_varray := per_cal_event_varray(); -- initialize empty
1907:

Line 1966: END hr_cal_event_mapping_pkg;

1962: hr_utility.set_location(SQLERRM, 65);
1963:
1964: END build_cal_map_cache;
1965:
1966: END hr_cal_event_mapping_pkg;