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.5 2005/09/12 11:06:18 lsilveir noship $
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 645: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.write_geo_cache';

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

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

700: ) RETURN BOOLEAN IS
701: l_return BOOLEAN;
702: l_proc VARCHAR2(100);
703: BEGIN
704: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.is_node_in_list';
705: hr_utility.set_location('Entering '||l_proc,10);
706: l_return := FALSE;
707:
708: IF p_node_list.COUNT > 0 THEN

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

740: l_exclude_flag BOOLEAN;
741: l_proc VARCHAR2(100);
742:
743: BEGIN
744: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.get_child_nodes';
745: hr_utility.set_location('Entering '||l_proc,10);
746:
747: l_result_count := 0;
748: l_parent_found := FALSE;

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

831: l_coverage_list t_node_id_table;
832: l_exclusion_list t_node_id_table;
833: l_proc VARCHAR2(100);
834: BEGIN
835: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.process_geo_coverage';
836: hr_utility.set_location('Entering '||l_proc,10);
837: l_exc_count := 0;
838: IF p_cal_event_table.COUNT > 0 THEN
839: hr_utility.set_location(l_proc,20);

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

878: hr_utility.set_location('Leaving '||l_proc,90);
879: END process_geo_coverage;
880:
881: BEGIN -- populate_geo_list
882: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.populate_geo_list';
883: hr_utility.set_location('Entering '||l_proc,10);
884:
885: -- Get the identifiers for all the hierarchies that need to be processed.
886: FOR l_ghv_rec IN c_ghv_ids LOOP

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

976: l_dummy BOOLEAN;
977: l_proc VARCHAR2(100);
978:
979: BEGIN
980: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.build_event_cache';
981: hr_utility.set_location('Entering '||l_proc,10);
982:
983: -- Delete previous event org list records as this execution will
984: -- refresh the list

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

1178: e_param_valdn_fail EXCEPTION;
1179: e_bg_leg_not_found EXCEPTION;
1180:
1181: BEGIN
1182: l_proc := 'hr_cal_event_mapping_pkg.get_per_asg_cal_events';
1183: hr_utility.set_location('Entering: '|| l_proc, 10);
1184:
1185: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1186: x_cal_event_varray := per_cal_event_varray(); -- initialize empty

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

1529: l_cal_event_varray per_cal_event_varray;
1530:
1531: BEGIN
1532:
1533: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (PerVer)';
1534: hr_utility.set_location('Entering: '|| l_proc, 10);
1535:
1536: -- Invoke private procedure to get calendar events
1537: get_per_asg_cal_events (p_person_id => p_person_id

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

1581: WHERE assignment_id = cp_assignment_id;
1582:
1583: BEGIN
1584:
1585: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (AsgVer)';
1586: hr_utility.set_location('Entering: '|| l_proc, 10);
1587:
1588: -- Get the person id for an assignment id. Though multiple records could
1589: -- exist, the person id will be the same. So sufficient to fetch first.

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

1643: AND orig_system_reference = 'PER:'||person_identifier;
1644:
1645: BEGIN
1646:
1647: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (HZVer)';
1648: hr_utility.set_location('Entering: '|| l_proc, 10);
1649:
1650: -- Get the person id for a party id. Though multiple records could
1651: -- exist, the person id will be the same. So sufficient to fetch first.

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

1727: );
1728:
1729: BEGIN
1730:
1731: l_proc := 'hr_cal_event_mapping_pkg.get_all_cal_events';
1732: hr_utility.set_location('Entering: '|| l_proc, 10);
1733: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1734: l_cal_event_varray := per_cal_event_varray(); -- initialize empty
1735: l_bg_id := FND_PROFILE.Value('PER_BUSINESS_GROUP_ID');

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

1861: l_cal_event_obj per_cal_event_obj;
1862:
1863: BEGIN
1864:
1865: l_proc := 'hr_cal_event_mapping_pkg.build_cal_map_cache';
1866: hr_utility.set_location('Entering: '|| l_proc, 10);
1867: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1868: l_cal_event_varray := per_cal_event_varray(); -- initialize empty
1869:

Line 1928: END hr_cal_event_mapping_pkg;

1924: hr_utility.set_location(SQLERRM, 65);
1925:
1926: END build_cal_map_cache;
1927:
1928: END hr_cal_event_mapping_pkg;