3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_perf_mgmt_plan_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-------------------------< create_perf_mgmt_plan >------------------------|
11: -- ----------------------------------------------------------------------------
99: begin
100:
101: IF g_debug THEN
102:
103: hr_utility.set_location('Entering:'|| l_proc, 10);
104:
105: hr_utility.trace(' ');
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
101: IF g_debug THEN
102:
103: hr_utility.set_location('Entering:'|| l_proc, 10);
104:
105: hr_utility.trace(' ');
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT PARAMETER '||
109: ' VALUE');
102:
103: hr_utility.set_location('Entering:'|| l_proc, 10);
104:
105: hr_utility.trace(' ');
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
104:
105: hr_utility.trace(' ');
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_plan_name '||
108: hr_utility.trace(' IN / IN OUT PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_plan_name '||
115: p_plan_name);
116: hr_utility.trace(' p_administrator_person_id '||
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_plan_name '||
115: p_plan_name);
116: hr_utility.trace(' p_administrator_person_id '||
117: to_char(p_administrator_person_id));
118: hr_utility.trace(' p_previous_plan_id '||
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_plan_name '||
115: p_plan_name);
116: hr_utility.trace(' p_administrator_person_id '||
117: to_char(p_administrator_person_id));
118: hr_utility.trace(' p_previous_plan_id '||
119: to_char(p_previous_plan_id));
120: hr_utility.trace(' p_start_date '||
114: hr_utility.trace(' p_plan_name '||
115: p_plan_name);
116: hr_utility.trace(' p_administrator_person_id '||
117: to_char(p_administrator_person_id));
118: hr_utility.trace(' p_previous_plan_id '||
119: to_char(p_previous_plan_id));
120: hr_utility.trace(' p_start_date '||
121: to_char(p_start_date));
122: hr_utility.trace(' p_end_date '||
116: hr_utility.trace(' p_administrator_person_id '||
117: to_char(p_administrator_person_id));
118: hr_utility.trace(' p_previous_plan_id '||
119: to_char(p_previous_plan_id));
120: hr_utility.trace(' p_start_date '||
121: to_char(p_start_date));
122: hr_utility.trace(' p_end_date '||
123: to_char(p_end_date));
124: hr_utility.trace(' p_hierarchy_type_code '||
118: hr_utility.trace(' p_previous_plan_id '||
119: to_char(p_previous_plan_id));
120: hr_utility.trace(' p_start_date '||
121: to_char(p_start_date));
122: hr_utility.trace(' p_end_date '||
123: to_char(p_end_date));
124: hr_utility.trace(' p_hierarchy_type_code '||
125: p_hierarchy_type_code);
126: hr_utility.trace(' p_supervisor_id '||
120: hr_utility.trace(' p_start_date '||
121: to_char(p_start_date));
122: hr_utility.trace(' p_end_date '||
123: to_char(p_end_date));
124: hr_utility.trace(' p_hierarchy_type_code '||
125: p_hierarchy_type_code);
126: hr_utility.trace(' p_supervisor_id '||
127: to_char(p_supervisor_id));
128: hr_utility.trace(' p_supervisor_assignment_id '||
122: hr_utility.trace(' p_end_date '||
123: to_char(p_end_date));
124: hr_utility.trace(' p_hierarchy_type_code '||
125: p_hierarchy_type_code);
126: hr_utility.trace(' p_supervisor_id '||
127: to_char(p_supervisor_id));
128: hr_utility.trace(' p_supervisor_assignment_id '||
129: to_char(p_supervisor_assignment_id));
130: hr_utility.trace(' p_organization_structure_id '||
124: hr_utility.trace(' p_hierarchy_type_code '||
125: p_hierarchy_type_code);
126: hr_utility.trace(' p_supervisor_id '||
127: to_char(p_supervisor_id));
128: hr_utility.trace(' p_supervisor_assignment_id '||
129: to_char(p_supervisor_assignment_id));
130: hr_utility.trace(' p_organization_structure_id '||
131: to_char(p_organization_structure_id));
132: hr_utility.trace(' p_org_structure_version_id '||
126: hr_utility.trace(' p_supervisor_id '||
127: to_char(p_supervisor_id));
128: hr_utility.trace(' p_supervisor_assignment_id '||
129: to_char(p_supervisor_assignment_id));
130: hr_utility.trace(' p_organization_structure_id '||
131: to_char(p_organization_structure_id));
132: hr_utility.trace(' p_org_structure_version_id '||
133: to_char(p_org_structure_version_id));
134: hr_utility.trace(' p_top_organization_id '||
128: hr_utility.trace(' p_supervisor_assignment_id '||
129: to_char(p_supervisor_assignment_id));
130: hr_utility.trace(' p_organization_structure_id '||
131: to_char(p_organization_structure_id));
132: hr_utility.trace(' p_org_structure_version_id '||
133: to_char(p_org_structure_version_id));
134: hr_utility.trace(' p_top_organization_id '||
135: to_char(p_top_organization_id));
136: hr_utility.trace(' p_position_structure_id '||
130: hr_utility.trace(' p_organization_structure_id '||
131: to_char(p_organization_structure_id));
132: hr_utility.trace(' p_org_structure_version_id '||
133: to_char(p_org_structure_version_id));
134: hr_utility.trace(' p_top_organization_id '||
135: to_char(p_top_organization_id));
136: hr_utility.trace(' p_position_structure_id '||
137: to_char(p_position_structure_id));
138: hr_utility.trace(' p_pos_structure_version_id '||
132: hr_utility.trace(' p_org_structure_version_id '||
133: to_char(p_org_structure_version_id));
134: hr_utility.trace(' p_top_organization_id '||
135: to_char(p_top_organization_id));
136: hr_utility.trace(' p_position_structure_id '||
137: to_char(p_position_structure_id));
138: hr_utility.trace(' p_pos_structure_version_id '||
139: to_char(p_pos_structure_version_id));
140: hr_utility.trace(' p_top_position_id '||
134: hr_utility.trace(' p_top_organization_id '||
135: to_char(p_top_organization_id));
136: hr_utility.trace(' p_position_structure_id '||
137: to_char(p_position_structure_id));
138: hr_utility.trace(' p_pos_structure_version_id '||
139: to_char(p_pos_structure_version_id));
140: hr_utility.trace(' p_top_position_id '||
141: to_char(p_top_position_id));
142: hr_utility.trace(' p_hierarchy_levels '||
136: hr_utility.trace(' p_position_structure_id '||
137: to_char(p_position_structure_id));
138: hr_utility.trace(' p_pos_structure_version_id '||
139: to_char(p_pos_structure_version_id));
140: hr_utility.trace(' p_top_position_id '||
141: to_char(p_top_position_id));
142: hr_utility.trace(' p_hierarchy_levels '||
143: to_char(p_hierarchy_levels));
144: hr_utility.trace(' p_automatic_enrollment_flag '||
138: hr_utility.trace(' p_pos_structure_version_id '||
139: to_char(p_pos_structure_version_id));
140: hr_utility.trace(' p_top_position_id '||
141: to_char(p_top_position_id));
142: hr_utility.trace(' p_hierarchy_levels '||
143: to_char(p_hierarchy_levels));
144: hr_utility.trace(' p_automatic_enrollment_flag '||
145: p_automatic_enrollment_flag);
146: hr_utility.trace(' p_assignment_types_code '||
140: hr_utility.trace(' p_top_position_id '||
141: to_char(p_top_position_id));
142: hr_utility.trace(' p_hierarchy_levels '||
143: to_char(p_hierarchy_levels));
144: hr_utility.trace(' p_automatic_enrollment_flag '||
145: p_automatic_enrollment_flag);
146: hr_utility.trace(' p_assignment_types_code '||
147: p_assignment_types_code);
148: hr_utility.trace(' p_primary_asg_only_flag '||
142: hr_utility.trace(' p_hierarchy_levels '||
143: to_char(p_hierarchy_levels));
144: hr_utility.trace(' p_automatic_enrollment_flag '||
145: p_automatic_enrollment_flag);
146: hr_utility.trace(' p_assignment_types_code '||
147: p_assignment_types_code);
148: hr_utility.trace(' p_primary_asg_only_flag '||
149: p_primary_asg_only_flag);
150: hr_utility.trace(' p_include_obj_setting_flag '||
144: hr_utility.trace(' p_automatic_enrollment_flag '||
145: p_automatic_enrollment_flag);
146: hr_utility.trace(' p_assignment_types_code '||
147: p_assignment_types_code);
148: hr_utility.trace(' p_primary_asg_only_flag '||
149: p_primary_asg_only_flag);
150: hr_utility.trace(' p_include_obj_setting_flag '||
151: p_include_obj_setting_flag);
152: hr_utility.trace(' p_obj_setting_start_date '||
146: hr_utility.trace(' p_assignment_types_code '||
147: p_assignment_types_code);
148: hr_utility.trace(' p_primary_asg_only_flag '||
149: p_primary_asg_only_flag);
150: hr_utility.trace(' p_include_obj_setting_flag '||
151: p_include_obj_setting_flag);
152: hr_utility.trace(' p_obj_setting_start_date '||
153: to_char(p_obj_setting_start_date));
154: hr_utility.trace(' p_obj_setting_deadline '||
148: hr_utility.trace(' p_primary_asg_only_flag '||
149: p_primary_asg_only_flag);
150: hr_utility.trace(' p_include_obj_setting_flag '||
151: p_include_obj_setting_flag);
152: hr_utility.trace(' p_obj_setting_start_date '||
153: to_char(p_obj_setting_start_date));
154: hr_utility.trace(' p_obj_setting_deadline '||
155: to_char(p_obj_setting_deadline));
156: hr_utility.trace(' p_obj_set_outside_period_flag '||
150: hr_utility.trace(' p_include_obj_setting_flag '||
151: p_include_obj_setting_flag);
152: hr_utility.trace(' p_obj_setting_start_date '||
153: to_char(p_obj_setting_start_date));
154: hr_utility.trace(' p_obj_setting_deadline '||
155: to_char(p_obj_setting_deadline));
156: hr_utility.trace(' p_obj_set_outside_period_flag '||
157: p_obj_set_outside_period_flag);
158: hr_utility.trace(' p_method_code '||
152: hr_utility.trace(' p_obj_setting_start_date '||
153: to_char(p_obj_setting_start_date));
154: hr_utility.trace(' p_obj_setting_deadline '||
155: to_char(p_obj_setting_deadline));
156: hr_utility.trace(' p_obj_set_outside_period_flag '||
157: p_obj_set_outside_period_flag);
158: hr_utility.trace(' p_method_code '||
159: p_method_code);
160: hr_utility.trace(' p_notify_population_flag '||
154: hr_utility.trace(' p_obj_setting_deadline '||
155: to_char(p_obj_setting_deadline));
156: hr_utility.trace(' p_obj_set_outside_period_flag '||
157: p_obj_set_outside_period_flag);
158: hr_utility.trace(' p_method_code '||
159: p_method_code);
160: hr_utility.trace(' p_notify_population_flag '||
161: p_notify_population_flag);
162: hr_utility.trace(' p_automatic_allocation_flag '||
156: hr_utility.trace(' p_obj_set_outside_period_flag '||
157: p_obj_set_outside_period_flag);
158: hr_utility.trace(' p_method_code '||
159: p_method_code);
160: hr_utility.trace(' p_notify_population_flag '||
161: p_notify_population_flag);
162: hr_utility.trace(' p_automatic_allocation_flag '||
163: p_automatic_allocation_flag);
164: hr_utility.trace(' p_copy_past_objectives_flag '||
158: hr_utility.trace(' p_method_code '||
159: p_method_code);
160: hr_utility.trace(' p_notify_population_flag '||
161: p_notify_population_flag);
162: hr_utility.trace(' p_automatic_allocation_flag '||
163: p_automatic_allocation_flag);
164: hr_utility.trace(' p_copy_past_objectives_flag '||
165: p_copy_past_objectives_flag);
166: hr_utility.trace(' p_sharing_alignment_task_flag '||
160: hr_utility.trace(' p_notify_population_flag '||
161: p_notify_population_flag);
162: hr_utility.trace(' p_automatic_allocation_flag '||
163: p_automatic_allocation_flag);
164: hr_utility.trace(' p_copy_past_objectives_flag '||
165: p_copy_past_objectives_flag);
166: hr_utility.trace(' p_sharing_alignment_task_flag '||
167: p_sharing_alignment_task_flag);
168: hr_utility.trace(' p_include_appraisals_flag '||
162: hr_utility.trace(' p_automatic_allocation_flag '||
163: p_automatic_allocation_flag);
164: hr_utility.trace(' p_copy_past_objectives_flag '||
165: p_copy_past_objectives_flag);
166: hr_utility.trace(' p_sharing_alignment_task_flag '||
167: p_sharing_alignment_task_flag);
168: hr_utility.trace(' p_include_appraisals_flag '||
169: p_include_appraisals_flag);
170: hr_utility.trace(' p_change_sc_status_flag '||
164: hr_utility.trace(' p_copy_past_objectives_flag '||
165: p_copy_past_objectives_flag);
166: hr_utility.trace(' p_sharing_alignment_task_flag '||
167: p_sharing_alignment_task_flag);
168: hr_utility.trace(' p_include_appraisals_flag '||
169: p_include_appraisals_flag);
170: hr_utility.trace(' p_change_sc_status_flag '||
171: p_change_sc_status_flag);
172: hr_utility.trace(' --------------------------------'||
166: hr_utility.trace(' p_sharing_alignment_task_flag '||
167: p_sharing_alignment_task_flag);
168: hr_utility.trace(' p_include_appraisals_flag '||
169: p_include_appraisals_flag);
170: hr_utility.trace(' p_change_sc_status_flag '||
171: p_change_sc_status_flag);
172: hr_utility.trace(' --------------------------------'||
173: '---------------------------------');
174: hr_utility.trace(' ');
168: hr_utility.trace(' p_include_appraisals_flag '||
169: p_include_appraisals_flag);
170: hr_utility.trace(' p_change_sc_status_flag '||
171: p_change_sc_status_flag);
172: hr_utility.trace(' --------------------------------'||
173: '---------------------------------');
174: hr_utility.trace(' ');
175:
176: END IF;
170: hr_utility.trace(' p_change_sc_status_flag '||
171: p_change_sc_status_flag);
172: hr_utility.trace(' --------------------------------'||
173: '---------------------------------');
174: hr_utility.trace(' ');
175:
176: END IF;
177:
178: --
268: end;
269: --
270: -- End of Before Process User Hook call
271: --
272: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
273:
274: --
275: -- Call the row handler insert
276: --
344: ,p_update_library_objectives => p_update_library_objectives -- 8740021 bug fix
345: ,p_automatic_approval_flag => p_automatic_approval_flag
346: );
347:
348: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
349:
350: --
351: -- Call After Process User Hook
352: --
432: );
433:
434: end;
435:
436: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
437:
438: --
439: -- End of After Process User Hook call
440: --
455:
456:
457: IF g_debug THEN
458:
459: hr_utility.trace(' ');
460: hr_utility.trace('+--------------------------------'||
461: '---------------------------------');
462: hr_utility.trace(' IN OUT / OUT PARAMETER '||
463: ' VALUE');
456:
457: IF g_debug THEN
458:
459: hr_utility.trace(' ');
460: hr_utility.trace('+--------------------------------'||
461: '---------------------------------');
462: hr_utility.trace(' IN OUT / OUT PARAMETER '||
463: ' VALUE');
464: hr_utility.trace(' --------------------------------'||
458:
459: hr_utility.trace(' ');
460: hr_utility.trace('+--------------------------------'||
461: '---------------------------------');
462: hr_utility.trace(' IN OUT / OUT PARAMETER '||
463: ' VALUE');
464: hr_utility.trace(' --------------------------------'||
465: '---------------------------------');
466: hr_utility.trace(' p_plan_id '||
460: hr_utility.trace('+--------------------------------'||
461: '---------------------------------');
462: hr_utility.trace(' IN OUT / OUT PARAMETER '||
463: ' VALUE');
464: hr_utility.trace(' --------------------------------'||
465: '---------------------------------');
466: hr_utility.trace(' p_plan_id '||
467: to_char(p_plan_id));
468: hr_utility.trace(' p_object_version_number '||
462: hr_utility.trace(' IN OUT / OUT PARAMETER '||
463: ' VALUE');
464: hr_utility.trace(' --------------------------------'||
465: '---------------------------------');
466: hr_utility.trace(' p_plan_id '||
467: to_char(p_plan_id));
468: hr_utility.trace(' p_object_version_number '||
469: to_char(p_object_version_number));
470: hr_utility.trace(' p_status_code '||
464: hr_utility.trace(' --------------------------------'||
465: '---------------------------------');
466: hr_utility.trace(' p_plan_id '||
467: to_char(p_plan_id));
468: hr_utility.trace(' p_object_version_number '||
469: to_char(p_object_version_number));
470: hr_utility.trace(' p_status_code '||
471: p_status_code);
472: IF p_duplicate_name_warning THEN
466: hr_utility.trace(' p_plan_id '||
467: to_char(p_plan_id));
468: hr_utility.trace(' p_object_version_number '||
469: to_char(p_object_version_number));
470: hr_utility.trace(' p_status_code '||
471: p_status_code);
472: IF p_duplicate_name_warning THEN
473: hr_utility.trace(' p_duplicate_name_warning '||
474: 'TRUE');
469: to_char(p_object_version_number));
470: hr_utility.trace(' p_status_code '||
471: p_status_code);
472: IF p_duplicate_name_warning THEN
473: hr_utility.trace(' p_duplicate_name_warning '||
474: 'TRUE');
475: ELSE
476: hr_utility.trace(' p_duplicate_name_warning '||
477: 'FALSE');
472: IF p_duplicate_name_warning THEN
473: hr_utility.trace(' p_duplicate_name_warning '||
474: 'TRUE');
475: ELSE
476: hr_utility.trace(' p_duplicate_name_warning '||
477: 'FALSE');
478: END IF;
479: IF p_no_life_events_warning THEN
480: hr_utility.trace(' p_no_life_events_warning '||
476: hr_utility.trace(' p_duplicate_name_warning '||
477: 'FALSE');
478: END IF;
479: IF p_no_life_events_warning THEN
480: hr_utility.trace(' p_no_life_events_warning '||
481: 'TRUE');
482: ELSE
483: hr_utility.trace(' p_no_life_events_warning '||
484: 'FALSE');
479: IF p_no_life_events_warning THEN
480: hr_utility.trace(' p_no_life_events_warning '||
481: 'TRUE');
482: ELSE
483: hr_utility.trace(' p_no_life_events_warning '||
484: 'FALSE');
485: END IF;
486: hr_utility.trace(' --------------------------------'||
487: '---------------------------------');
482: ELSE
483: hr_utility.trace(' p_no_life_events_warning '||
484: 'FALSE');
485: END IF;
486: hr_utility.trace(' --------------------------------'||
487: '---------------------------------');
488: hr_utility.trace(' ');
489: hr_utility.set_location(' Leaving:'||l_proc, 970);
490:
484: 'FALSE');
485: END IF;
486: hr_utility.trace(' --------------------------------'||
487: '---------------------------------');
488: hr_utility.trace(' ');
489: hr_utility.set_location(' Leaving:'||l_proc, 970);
490:
491: END IF;
492:
485: END IF;
486: hr_utility.trace(' --------------------------------'||
487: '---------------------------------');
488: hr_utility.trace(' ');
489: hr_utility.set_location(' Leaving:'||l_proc, 970);
490:
491: END IF;
492:
493: exception
507: p_duplicate_name_warning := l_duplicate_name_warning;
508: p_no_life_events_warning := l_no_life_events_warning;
509:
510: --
511: hr_utility.set_location(' Leaving:'||l_proc, 980);
512: --
513: when others then
514: --
515: -- A validation or unexpected error has occured
523: p_object_version_number := null;
524: p_duplicate_name_warning := null;
525: p_no_life_events_warning := null;
526:
527: hr_utility.set_location(' Leaving:'||l_proc, 990);
528: raise;
529:
530: end create_perf_mgmt_plan;
531: --
624: begin
625:
626: IF g_debug THEN
627:
628: hr_utility.set_location('Entering:'|| l_proc, 10);
629:
630: hr_utility.trace(' ');
631: hr_utility.trace(' --------------------------------'||
632: '---------------------------------');
626: IF g_debug THEN
627:
628: hr_utility.set_location('Entering:'|| l_proc, 10);
629:
630: hr_utility.trace(' ');
631: hr_utility.trace(' --------------------------------'||
632: '---------------------------------');
633: hr_utility.trace(' IN / IN OUT PARAMETER '||
634: ' VALUE');
627:
628: hr_utility.set_location('Entering:'|| l_proc, 10);
629:
630: hr_utility.trace(' ');
631: hr_utility.trace(' --------------------------------'||
632: '---------------------------------');
633: hr_utility.trace(' IN / IN OUT PARAMETER '||
634: ' VALUE');
635: hr_utility.trace(' --------------------------------'||
629:
630: hr_utility.trace(' ');
631: hr_utility.trace(' --------------------------------'||
632: '---------------------------------');
633: hr_utility.trace(' IN / IN OUT PARAMETER '||
634: ' VALUE');
635: hr_utility.trace(' --------------------------------'||
636: '+--------------------------------');
637: hr_utility.trace(' p_effective_date '||
631: hr_utility.trace(' --------------------------------'||
632: '---------------------------------');
633: hr_utility.trace(' IN / IN OUT PARAMETER '||
634: ' VALUE');
635: hr_utility.trace(' --------------------------------'||
636: '+--------------------------------');
637: hr_utility.trace(' p_effective_date '||
638: to_char(p_effective_date));
639: hr_utility.trace(' p_plan_id '||
633: hr_utility.trace(' IN / IN OUT PARAMETER '||
634: ' VALUE');
635: hr_utility.trace(' --------------------------------'||
636: '+--------------------------------');
637: hr_utility.trace(' p_effective_date '||
638: to_char(p_effective_date));
639: hr_utility.trace(' p_plan_id '||
640: to_char(p_plan_id));
641: hr_utility.trace(' p_object_version_number '||
635: hr_utility.trace(' --------------------------------'||
636: '+--------------------------------');
637: hr_utility.trace(' p_effective_date '||
638: to_char(p_effective_date));
639: hr_utility.trace(' p_plan_id '||
640: to_char(p_plan_id));
641: hr_utility.trace(' p_object_version_number '||
642: to_char(p_object_version_number));
643: hr_utility.trace(' p_plan_name '||
637: hr_utility.trace(' p_effective_date '||
638: to_char(p_effective_date));
639: hr_utility.trace(' p_plan_id '||
640: to_char(p_plan_id));
641: hr_utility.trace(' p_object_version_number '||
642: to_char(p_object_version_number));
643: hr_utility.trace(' p_plan_name '||
644: p_plan_name);
645: hr_utility.trace(' p_administrator_person_id '||
639: hr_utility.trace(' p_plan_id '||
640: to_char(p_plan_id));
641: hr_utility.trace(' p_object_version_number '||
642: to_char(p_object_version_number));
643: hr_utility.trace(' p_plan_name '||
644: p_plan_name);
645: hr_utility.trace(' p_administrator_person_id '||
646: to_char(p_administrator_person_id));
647: hr_utility.trace(' p_previous_plan_id '||
641: hr_utility.trace(' p_object_version_number '||
642: to_char(p_object_version_number));
643: hr_utility.trace(' p_plan_name '||
644: p_plan_name);
645: hr_utility.trace(' p_administrator_person_id '||
646: to_char(p_administrator_person_id));
647: hr_utility.trace(' p_previous_plan_id '||
648: to_char(p_previous_plan_id));
649: hr_utility.trace(' p_start_date '||
643: hr_utility.trace(' p_plan_name '||
644: p_plan_name);
645: hr_utility.trace(' p_administrator_person_id '||
646: to_char(p_administrator_person_id));
647: hr_utility.trace(' p_previous_plan_id '||
648: to_char(p_previous_plan_id));
649: hr_utility.trace(' p_start_date '||
650: to_char(p_start_date));
651: hr_utility.trace(' p_end_date '||
645: hr_utility.trace(' p_administrator_person_id '||
646: to_char(p_administrator_person_id));
647: hr_utility.trace(' p_previous_plan_id '||
648: to_char(p_previous_plan_id));
649: hr_utility.trace(' p_start_date '||
650: to_char(p_start_date));
651: hr_utility.trace(' p_end_date '||
652: to_char(p_end_date));
653: hr_utility.trace(' p_hierarchy_type_code '||
647: hr_utility.trace(' p_previous_plan_id '||
648: to_char(p_previous_plan_id));
649: hr_utility.trace(' p_start_date '||
650: to_char(p_start_date));
651: hr_utility.trace(' p_end_date '||
652: to_char(p_end_date));
653: hr_utility.trace(' p_hierarchy_type_code '||
654: p_hierarchy_type_code);
655: hr_utility.trace(' p_supervisor_id '||
649: hr_utility.trace(' p_start_date '||
650: to_char(p_start_date));
651: hr_utility.trace(' p_end_date '||
652: to_char(p_end_date));
653: hr_utility.trace(' p_hierarchy_type_code '||
654: p_hierarchy_type_code);
655: hr_utility.trace(' p_supervisor_id '||
656: to_char(p_supervisor_id));
657: hr_utility.trace(' p_supervisor_assignment_id '||
651: hr_utility.trace(' p_end_date '||
652: to_char(p_end_date));
653: hr_utility.trace(' p_hierarchy_type_code '||
654: p_hierarchy_type_code);
655: hr_utility.trace(' p_supervisor_id '||
656: to_char(p_supervisor_id));
657: hr_utility.trace(' p_supervisor_assignment_id '||
658: to_char(p_supervisor_assignment_id));
659: hr_utility.trace(' p_organization_structure_id '||
653: hr_utility.trace(' p_hierarchy_type_code '||
654: p_hierarchy_type_code);
655: hr_utility.trace(' p_supervisor_id '||
656: to_char(p_supervisor_id));
657: hr_utility.trace(' p_supervisor_assignment_id '||
658: to_char(p_supervisor_assignment_id));
659: hr_utility.trace(' p_organization_structure_id '||
660: to_char(p_organization_structure_id));
661: hr_utility.trace(' p_org_structure_version_id '||
655: hr_utility.trace(' p_supervisor_id '||
656: to_char(p_supervisor_id));
657: hr_utility.trace(' p_supervisor_assignment_id '||
658: to_char(p_supervisor_assignment_id));
659: hr_utility.trace(' p_organization_structure_id '||
660: to_char(p_organization_structure_id));
661: hr_utility.trace(' p_org_structure_version_id '||
662: to_char(p_org_structure_version_id));
663: hr_utility.trace(' p_top_organization_id '||
657: hr_utility.trace(' p_supervisor_assignment_id '||
658: to_char(p_supervisor_assignment_id));
659: hr_utility.trace(' p_organization_structure_id '||
660: to_char(p_organization_structure_id));
661: hr_utility.trace(' p_org_structure_version_id '||
662: to_char(p_org_structure_version_id));
663: hr_utility.trace(' p_top_organization_id '||
664: to_char(p_top_organization_id));
665: hr_utility.trace(' p_position_structure_id '||
659: hr_utility.trace(' p_organization_structure_id '||
660: to_char(p_organization_structure_id));
661: hr_utility.trace(' p_org_structure_version_id '||
662: to_char(p_org_structure_version_id));
663: hr_utility.trace(' p_top_organization_id '||
664: to_char(p_top_organization_id));
665: hr_utility.trace(' p_position_structure_id '||
666: to_char(p_position_structure_id));
667: hr_utility.trace(' p_pos_structure_version_id '||
661: hr_utility.trace(' p_org_structure_version_id '||
662: to_char(p_org_structure_version_id));
663: hr_utility.trace(' p_top_organization_id '||
664: to_char(p_top_organization_id));
665: hr_utility.trace(' p_position_structure_id '||
666: to_char(p_position_structure_id));
667: hr_utility.trace(' p_pos_structure_version_id '||
668: to_char(p_pos_structure_version_id));
669: hr_utility.trace(' p_top_position_id '||
663: hr_utility.trace(' p_top_organization_id '||
664: to_char(p_top_organization_id));
665: hr_utility.trace(' p_position_structure_id '||
666: to_char(p_position_structure_id));
667: hr_utility.trace(' p_pos_structure_version_id '||
668: to_char(p_pos_structure_version_id));
669: hr_utility.trace(' p_top_position_id '||
670: to_char(p_top_position_id));
671: hr_utility.trace(' p_hierarchy_levels '||
665: hr_utility.trace(' p_position_structure_id '||
666: to_char(p_position_structure_id));
667: hr_utility.trace(' p_pos_structure_version_id '||
668: to_char(p_pos_structure_version_id));
669: hr_utility.trace(' p_top_position_id '||
670: to_char(p_top_position_id));
671: hr_utility.trace(' p_hierarchy_levels '||
672: to_char(p_hierarchy_levels));
673: hr_utility.trace(' p_automatic_enrollment_flag '||
667: hr_utility.trace(' p_pos_structure_version_id '||
668: to_char(p_pos_structure_version_id));
669: hr_utility.trace(' p_top_position_id '||
670: to_char(p_top_position_id));
671: hr_utility.trace(' p_hierarchy_levels '||
672: to_char(p_hierarchy_levels));
673: hr_utility.trace(' p_automatic_enrollment_flag '||
674: p_automatic_enrollment_flag);
675: hr_utility.trace(' p_assignment_types_code '||
669: hr_utility.trace(' p_top_position_id '||
670: to_char(p_top_position_id));
671: hr_utility.trace(' p_hierarchy_levels '||
672: to_char(p_hierarchy_levels));
673: hr_utility.trace(' p_automatic_enrollment_flag '||
674: p_automatic_enrollment_flag);
675: hr_utility.trace(' p_assignment_types_code '||
676: p_assignment_types_code);
677: hr_utility.trace(' p_primary_asg_only_flag '||
671: hr_utility.trace(' p_hierarchy_levels '||
672: to_char(p_hierarchy_levels));
673: hr_utility.trace(' p_automatic_enrollment_flag '||
674: p_automatic_enrollment_flag);
675: hr_utility.trace(' p_assignment_types_code '||
676: p_assignment_types_code);
677: hr_utility.trace(' p_primary_asg_only_flag '||
678: p_primary_asg_only_flag);
679: hr_utility.trace(' p_include_obj_setting_flag '||
673: hr_utility.trace(' p_automatic_enrollment_flag '||
674: p_automatic_enrollment_flag);
675: hr_utility.trace(' p_assignment_types_code '||
676: p_assignment_types_code);
677: hr_utility.trace(' p_primary_asg_only_flag '||
678: p_primary_asg_only_flag);
679: hr_utility.trace(' p_include_obj_setting_flag '||
680: p_include_obj_setting_flag);
681: hr_utility.trace(' p_obj_setting_start_date '||
675: hr_utility.trace(' p_assignment_types_code '||
676: p_assignment_types_code);
677: hr_utility.trace(' p_primary_asg_only_flag '||
678: p_primary_asg_only_flag);
679: hr_utility.trace(' p_include_obj_setting_flag '||
680: p_include_obj_setting_flag);
681: hr_utility.trace(' p_obj_setting_start_date '||
682: to_char(p_obj_setting_start_date));
683: hr_utility.trace(' p_obj_setting_deadline '||
677: hr_utility.trace(' p_primary_asg_only_flag '||
678: p_primary_asg_only_flag);
679: hr_utility.trace(' p_include_obj_setting_flag '||
680: p_include_obj_setting_flag);
681: hr_utility.trace(' p_obj_setting_start_date '||
682: to_char(p_obj_setting_start_date));
683: hr_utility.trace(' p_obj_setting_deadline '||
684: to_char(p_obj_setting_deadline));
685: hr_utility.trace(' p_obj_set_outside_period_flag '||
679: hr_utility.trace(' p_include_obj_setting_flag '||
680: p_include_obj_setting_flag);
681: hr_utility.trace(' p_obj_setting_start_date '||
682: to_char(p_obj_setting_start_date));
683: hr_utility.trace(' p_obj_setting_deadline '||
684: to_char(p_obj_setting_deadline));
685: hr_utility.trace(' p_obj_set_outside_period_flag '||
686: p_obj_set_outside_period_flag);
687: hr_utility.trace(' p_method_code '||
681: hr_utility.trace(' p_obj_setting_start_date '||
682: to_char(p_obj_setting_start_date));
683: hr_utility.trace(' p_obj_setting_deadline '||
684: to_char(p_obj_setting_deadline));
685: hr_utility.trace(' p_obj_set_outside_period_flag '||
686: p_obj_set_outside_period_flag);
687: hr_utility.trace(' p_method_code '||
688: p_method_code);
689: hr_utility.trace(' p_notify_population_flag '||
683: hr_utility.trace(' p_obj_setting_deadline '||
684: to_char(p_obj_setting_deadline));
685: hr_utility.trace(' p_obj_set_outside_period_flag '||
686: p_obj_set_outside_period_flag);
687: hr_utility.trace(' p_method_code '||
688: p_method_code);
689: hr_utility.trace(' p_notify_population_flag '||
690: p_notify_population_flag);
691: hr_utility.trace(' p_automatic_allocation_flag '||
685: hr_utility.trace(' p_obj_set_outside_period_flag '||
686: p_obj_set_outside_period_flag);
687: hr_utility.trace(' p_method_code '||
688: p_method_code);
689: hr_utility.trace(' p_notify_population_flag '||
690: p_notify_population_flag);
691: hr_utility.trace(' p_automatic_allocation_flag '||
692: p_automatic_allocation_flag);
693: hr_utility.trace(' p_copy_past_objectives_flag '||
687: hr_utility.trace(' p_method_code '||
688: p_method_code);
689: hr_utility.trace(' p_notify_population_flag '||
690: p_notify_population_flag);
691: hr_utility.trace(' p_automatic_allocation_flag '||
692: p_automatic_allocation_flag);
693: hr_utility.trace(' p_copy_past_objectives_flag '||
694: p_copy_past_objectives_flag);
695: hr_utility.trace(' p_sharing_alignment_task_flag '||
689: hr_utility.trace(' p_notify_population_flag '||
690: p_notify_population_flag);
691: hr_utility.trace(' p_automatic_allocation_flag '||
692: p_automatic_allocation_flag);
693: hr_utility.trace(' p_copy_past_objectives_flag '||
694: p_copy_past_objectives_flag);
695: hr_utility.trace(' p_sharing_alignment_task_flag '||
696: p_sharing_alignment_task_flag);
697: hr_utility.trace(' p_include_appraisals_flag '||
691: hr_utility.trace(' p_automatic_allocation_flag '||
692: p_automatic_allocation_flag);
693: hr_utility.trace(' p_copy_past_objectives_flag '||
694: p_copy_past_objectives_flag);
695: hr_utility.trace(' p_sharing_alignment_task_flag '||
696: p_sharing_alignment_task_flag);
697: hr_utility.trace(' p_include_appraisals_flag '||
698: p_include_appraisals_flag);
699: hr_utility.trace(' p_change_sc_status_flag '||
693: hr_utility.trace(' p_copy_past_objectives_flag '||
694: p_copy_past_objectives_flag);
695: hr_utility.trace(' p_sharing_alignment_task_flag '||
696: p_sharing_alignment_task_flag);
697: hr_utility.trace(' p_include_appraisals_flag '||
698: p_include_appraisals_flag);
699: hr_utility.trace(' p_change_sc_status_flag '||
700: p_change_sc_status_flag);
701: hr_utility.trace(' --------------------------------'||
695: hr_utility.trace(' p_sharing_alignment_task_flag '||
696: p_sharing_alignment_task_flag);
697: hr_utility.trace(' p_include_appraisals_flag '||
698: p_include_appraisals_flag);
699: hr_utility.trace(' p_change_sc_status_flag '||
700: p_change_sc_status_flag);
701: hr_utility.trace(' --------------------------------'||
702: '---------------------------------');
703: hr_utility.trace(' ');
697: hr_utility.trace(' p_include_appraisals_flag '||
698: p_include_appraisals_flag);
699: hr_utility.trace(' p_change_sc_status_flag '||
700: p_change_sc_status_flag);
701: hr_utility.trace(' --------------------------------'||
702: '---------------------------------');
703: hr_utility.trace(' ');
704:
705: END IF;
699: hr_utility.trace(' p_change_sc_status_flag '||
700: p_change_sc_status_flag);
701: hr_utility.trace(' --------------------------------'||
702: '---------------------------------');
703: hr_utility.trace(' ');
704:
705: END IF;
706:
707: --
806:
807: --
808: -- Process Logic
809: --
810: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
811:
812: --
813: -- Change the plan's status to updated if it's currently
814: -- published.
891: ,p_update_library_objectives => p_update_library_objectives -- 8740021 bug fix
892: ,p_automatic_approval_flag => p_automatic_approval_flag
893: );
894:
895: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
896: --
897: -- Call After Process User Hook
898: --
899: begin
974: p_hook_type => 'AP'
975: );
976: end;
977:
978: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
979:
980: --
981: -- End of After Process User Hook call
982: --
995: p_no_life_events_warning := l_no_life_events_warning;
996:
997: IF g_debug THEN
998:
999: hr_utility.trace(' ');
1000: hr_utility.trace(' --------------------------------'||
1001: '---------------------------------');
1002: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1003: ' VALUE');
996:
997: IF g_debug THEN
998:
999: hr_utility.trace(' ');
1000: hr_utility.trace(' --------------------------------'||
1001: '---------------------------------');
1002: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1003: ' VALUE');
1004: hr_utility.trace(' --------------------------------'||
998:
999: hr_utility.trace(' ');
1000: hr_utility.trace(' --------------------------------'||
1001: '---------------------------------');
1002: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1003: ' VALUE');
1004: hr_utility.trace(' --------------------------------'||
1005: '+--------------------------------');
1006: hr_utility.trace(' p_object_version_number '||
1000: hr_utility.trace(' --------------------------------'||
1001: '---------------------------------');
1002: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1003: ' VALUE');
1004: hr_utility.trace(' --------------------------------'||
1005: '+--------------------------------');
1006: hr_utility.trace(' p_object_version_number '||
1007: to_char(p_object_version_number));
1008: hr_utility.trace(' p_status_code '||
1002: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1003: ' VALUE');
1004: hr_utility.trace(' --------------------------------'||
1005: '+--------------------------------');
1006: hr_utility.trace(' p_object_version_number '||
1007: to_char(p_object_version_number));
1008: hr_utility.trace(' p_status_code '||
1009: p_status_code);
1010: IF p_duplicate_name_warning THEN
1004: hr_utility.trace(' --------------------------------'||
1005: '+--------------------------------');
1006: hr_utility.trace(' p_object_version_number '||
1007: to_char(p_object_version_number));
1008: hr_utility.trace(' p_status_code '||
1009: p_status_code);
1010: IF p_duplicate_name_warning THEN
1011: hr_utility.trace(' p_duplicate_name_warning '||
1012: 'TRUE');
1007: to_char(p_object_version_number));
1008: hr_utility.trace(' p_status_code '||
1009: p_status_code);
1010: IF p_duplicate_name_warning THEN
1011: hr_utility.trace(' p_duplicate_name_warning '||
1012: 'TRUE');
1013: ELSE
1014: hr_utility.trace(' p_duplicate_name_warning '||
1015: 'FALSE');
1010: IF p_duplicate_name_warning THEN
1011: hr_utility.trace(' p_duplicate_name_warning '||
1012: 'TRUE');
1013: ELSE
1014: hr_utility.trace(' p_duplicate_name_warning '||
1015: 'FALSE');
1016: END IF;
1017: IF p_no_life_events_warning THEN
1018: hr_utility.trace(' p_no_life_events_warning '||
1014: hr_utility.trace(' p_duplicate_name_warning '||
1015: 'FALSE');
1016: END IF;
1017: IF p_no_life_events_warning THEN
1018: hr_utility.trace(' p_no_life_events_warning '||
1019: 'TRUE');
1020: ELSE
1021: hr_utility.trace(' p_no_life_events_warning '||
1022: 'FALSE');
1017: IF p_no_life_events_warning THEN
1018: hr_utility.trace(' p_no_life_events_warning '||
1019: 'TRUE');
1020: ELSE
1021: hr_utility.trace(' p_no_life_events_warning '||
1022: 'FALSE');
1023: END IF;
1024: hr_utility.trace(' --------------------------------'||
1025: '---------------------------------');
1020: ELSE
1021: hr_utility.trace(' p_no_life_events_warning '||
1022: 'FALSE');
1023: END IF;
1024: hr_utility.trace(' --------------------------------'||
1025: '---------------------------------');
1026: hr_utility.trace(' ');
1027: hr_utility.set_location(' Leaving:'||l_proc, 970);
1028:
1022: 'FALSE');
1023: END IF;
1024: hr_utility.trace(' --------------------------------'||
1025: '---------------------------------');
1026: hr_utility.trace(' ');
1027: hr_utility.set_location(' Leaving:'||l_proc, 970);
1028:
1029: END IF;
1030:
1023: END IF;
1024: hr_utility.trace(' --------------------------------'||
1025: '---------------------------------');
1026: hr_utility.trace(' ');
1027: hr_utility.set_location(' Leaving:'||l_proc, 970);
1028:
1029: END IF;
1030:
1031: exception
1044: p_status_code := l_status_code;
1045: p_duplicate_name_warning := l_duplicate_name_warning;
1046: p_no_life_events_warning := l_no_life_events_warning;
1047: --
1048: hr_utility.set_location(' Leaving:'||l_proc, 980);
1049: --
1050: when others then
1051: --
1052: -- A validation or unexpected error has occured
1060: p_status_code := null;
1061: p_duplicate_name_warning := null;
1062: p_no_life_events_warning := null;
1063:
1064: hr_utility.set_location(' Leaving:'||l_proc, 990);
1065: raise;
1066:
1067: end update_perf_mgmt_plan;
1068: --
1085: begin
1086:
1087: IF g_debug THEN
1088:
1089: hr_utility.set_location('Entering:'|| l_proc, 10);
1090:
1091: hr_utility.trace(' ');
1092: hr_utility.trace(' --------------------------------'||
1093: '---------------------------------');
1087: IF g_debug THEN
1088:
1089: hr_utility.set_location('Entering:'|| l_proc, 10);
1090:
1091: hr_utility.trace(' ');
1092: hr_utility.trace(' --------------------------------'||
1093: '---------------------------------');
1094: hr_utility.trace(' IN / IN OUT PARAMETER '||
1095: ' VALUE');
1088:
1089: hr_utility.set_location('Entering:'|| l_proc, 10);
1090:
1091: hr_utility.trace(' ');
1092: hr_utility.trace(' --------------------------------'||
1093: '---------------------------------');
1094: hr_utility.trace(' IN / IN OUT PARAMETER '||
1095: ' VALUE');
1096: hr_utility.trace(' --------------------------------'||
1090:
1091: hr_utility.trace(' ');
1092: hr_utility.trace(' --------------------------------'||
1093: '---------------------------------');
1094: hr_utility.trace(' IN / IN OUT PARAMETER '||
1095: ' VALUE');
1096: hr_utility.trace(' --------------------------------'||
1097: '+--------------------------------');
1098: hr_utility.trace(' p_plan_id '||
1092: hr_utility.trace(' --------------------------------'||
1093: '---------------------------------');
1094: hr_utility.trace(' IN / IN OUT PARAMETER '||
1095: ' VALUE');
1096: hr_utility.trace(' --------------------------------'||
1097: '+--------------------------------');
1098: hr_utility.trace(' p_plan_id '||
1099: to_char(p_plan_id));
1100: hr_utility.trace(' p_object_version_number '||
1094: hr_utility.trace(' IN / IN OUT PARAMETER '||
1095: ' VALUE');
1096: hr_utility.trace(' --------------------------------'||
1097: '+--------------------------------');
1098: hr_utility.trace(' p_plan_id '||
1099: to_char(p_plan_id));
1100: hr_utility.trace(' p_object_version_number '||
1101: to_char(p_object_version_number));
1102: hr_utility.trace(' --------------------------------'||
1096: hr_utility.trace(' --------------------------------'||
1097: '+--------------------------------');
1098: hr_utility.trace(' p_plan_id '||
1099: to_char(p_plan_id));
1100: hr_utility.trace(' p_object_version_number '||
1101: to_char(p_object_version_number));
1102: hr_utility.trace(' --------------------------------'||
1103: '---------------------------------');
1104: hr_utility.trace(' ');
1098: hr_utility.trace(' p_plan_id '||
1099: to_char(p_plan_id));
1100: hr_utility.trace(' p_object_version_number '||
1101: to_char(p_object_version_number));
1102: hr_utility.trace(' --------------------------------'||
1103: '---------------------------------');
1104: hr_utility.trace(' ');
1105:
1106: END IF;
1100: hr_utility.trace(' p_object_version_number '||
1101: to_char(p_object_version_number));
1102: hr_utility.trace(' --------------------------------'||
1103: '---------------------------------');
1104: hr_utility.trace(' ');
1105:
1106: END IF;
1107:
1108: --
1128:
1129: --
1130: -- End of Before Process User Hook call
1131: --
1132: hr_utility.set_location(l_proc, 7);
1133: --
1134: -- Process Logic - Delete Plan
1135: --
1136:
1138: (p_plan_id => p_plan_id
1139: ,p_object_version_number => p_object_version_number
1140: );
1141:
1142: hr_utility.set_location(l_proc, 8);
1143: --
1144: -- Call After Process User Hook
1145: --
1146: begin
1155: p_hook_type => 'AP'
1156: );
1157: end;
1158:
1159: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1160: --
1161: -- When in validation only mode raise the Validate_Enabled exception
1162: --
1163: if p_validate then
1166:
1167: --
1168: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1169: --
1170: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1171:
1172: exception
1173: when hr_api.validate_enabled then
1174: --
1180: -- Reset IN OUT parameters and set OUT parameters
1181: -- (Any key or derived arguments must be set to null
1182: -- when validation only mode is being used.)
1183: --
1184: hr_utility.set_location(' Leaving:'||l_proc, 980);
1185:
1186: when others then
1187: --
1188: -- A validation or unexpected error has occured
1191: --
1192: -- Reset IN OUT parameters and set all
1193: -- OUT parameters, including warnings, to null
1194: --
1195: hr_utility.set_location(' Leaving:'||l_proc, 990);
1196: raise;
1197:
1198: end delete_perf_mgmt_plan;
1199: --
1221: begin
1222:
1223: IF g_debug THEN
1224:
1225: hr_utility.set_location('Entering:'|| l_proc, 10);
1226:
1227: hr_utility.trace(' ');
1228: hr_utility.trace(' --------------------------------'||
1229: '---------------------------------');
1223: IF g_debug THEN
1224:
1225: hr_utility.set_location('Entering:'|| l_proc, 10);
1226:
1227: hr_utility.trace(' ');
1228: hr_utility.trace(' --------------------------------'||
1229: '---------------------------------');
1230: hr_utility.trace(' IN / IN OUT PARAMETER '||
1231: ' VALUE');
1224:
1225: hr_utility.set_location('Entering:'|| l_proc, 10);
1226:
1227: hr_utility.trace(' ');
1228: hr_utility.trace(' --------------------------------'||
1229: '---------------------------------');
1230: hr_utility.trace(' IN / IN OUT PARAMETER '||
1231: ' VALUE');
1232: hr_utility.trace(' --------------------------------'||
1226:
1227: hr_utility.trace(' ');
1228: hr_utility.trace(' --------------------------------'||
1229: '---------------------------------');
1230: hr_utility.trace(' IN / IN OUT PARAMETER '||
1231: ' VALUE');
1232: hr_utility.trace(' --------------------------------'||
1233: '+--------------------------------');
1234: hr_utility.trace(' p_plan_id '||
1228: hr_utility.trace(' --------------------------------'||
1229: '---------------------------------');
1230: hr_utility.trace(' IN / IN OUT PARAMETER '||
1231: ' VALUE');
1232: hr_utility.trace(' --------------------------------'||
1233: '+--------------------------------');
1234: hr_utility.trace(' p_plan_id '||
1235: to_char(p_plan_id));
1236: hr_utility.trace(' p_object_version_number '||
1230: hr_utility.trace(' IN / IN OUT PARAMETER '||
1231: ' VALUE');
1232: hr_utility.trace(' --------------------------------'||
1233: '+--------------------------------');
1234: hr_utility.trace(' p_plan_id '||
1235: to_char(p_plan_id));
1236: hr_utility.trace(' p_object_version_number '||
1237: to_char(p_object_version_number));
1238: hr_utility.trace(' --------------------------------'||
1232: hr_utility.trace(' --------------------------------'||
1233: '+--------------------------------');
1234: hr_utility.trace(' p_plan_id '||
1235: to_char(p_plan_id));
1236: hr_utility.trace(' p_object_version_number '||
1237: to_char(p_object_version_number));
1238: hr_utility.trace(' --------------------------------'||
1239: '---------------------------------');
1240: hr_utility.trace(' ');
1234: hr_utility.trace(' p_plan_id '||
1235: to_char(p_plan_id));
1236: hr_utility.trace(' p_object_version_number '||
1237: to_char(p_object_version_number));
1238: hr_utility.trace(' --------------------------------'||
1239: '---------------------------------');
1240: hr_utility.trace(' ');
1241:
1242: END IF;
1236: hr_utility.trace(' p_object_version_number '||
1237: to_char(p_object_version_number));
1238: hr_utility.trace(' --------------------------------'||
1239: '---------------------------------');
1240: hr_utility.trace(' ');
1241:
1242: END IF;
1243:
1244: --
1271:
1272: --
1273: -- End of Before Process User Hook call
1274: --
1275: hr_utility.set_location(l_proc, 7);
1276: --
1277: -- What if mode
1278: --
1279: if (p_validate) then
1291: ,p_reverse_mode => 'N'
1292: ,p_what_if => l_what_if
1293: );
1294:
1295: hr_utility.set_location(l_proc, 8);
1296: --
1297: -- Call After Process User Hook
1298: --
1299: begin
1309: p_hook_type => 'AP'
1310: );
1311: end;
1312:
1313: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1314: --
1315: -- When in validation only mode raise the Validate_Enabled exception
1316: --
1317: if p_validate then
1325:
1326: --
1327: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1328: --
1329: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1330:
1331: exception
1332: when hr_api.validate_enabled then
1333: --
1339: -- Reset IN OUT parameters and set OUT parameters
1340: -- (Any key or derived arguments must be set to null
1341: -- when validation only mode is being used.)
1342: --
1343: hr_utility.set_location(' Leaving:'||l_proc, 980);
1344:
1345: when others then
1346: --
1347: -- A validation or unexpected error has occured
1350: --
1351: -- Reset IN OUT parameters and set all
1352: -- OUT parameters, including warnings, to null
1353: --
1354: hr_utility.set_location(' Leaving:'||l_proc, 990);
1355: raise;
1356:
1357: end publish_plan;
1358:
1379: begin
1380:
1381: IF g_debug THEN
1382:
1383: hr_utility.set_location('Entering:'|| l_proc, 10);
1384:
1385: hr_utility.trace(' ');
1386: hr_utility.trace(' --------------------------------'||
1387: '---------------------------------');
1381: IF g_debug THEN
1382:
1383: hr_utility.set_location('Entering:'|| l_proc, 10);
1384:
1385: hr_utility.trace(' ');
1386: hr_utility.trace(' --------------------------------'||
1387: '---------------------------------');
1388: hr_utility.trace(' IN / IN OUT PARAMETER '||
1389: ' VALUE');
1382:
1383: hr_utility.set_location('Entering:'|| l_proc, 10);
1384:
1385: hr_utility.trace(' ');
1386: hr_utility.trace(' --------------------------------'||
1387: '---------------------------------');
1388: hr_utility.trace(' IN / IN OUT PARAMETER '||
1389: ' VALUE');
1390: hr_utility.trace(' --------------------------------'||
1384:
1385: hr_utility.trace(' ');
1386: hr_utility.trace(' --------------------------------'||
1387: '---------------------------------');
1388: hr_utility.trace(' IN / IN OUT PARAMETER '||
1389: ' VALUE');
1390: hr_utility.trace(' --------------------------------'||
1391: '+--------------------------------');
1392: hr_utility.trace(' p_plan_id '||
1386: hr_utility.trace(' --------------------------------'||
1387: '---------------------------------');
1388: hr_utility.trace(' IN / IN OUT PARAMETER '||
1389: ' VALUE');
1390: hr_utility.trace(' --------------------------------'||
1391: '+--------------------------------');
1392: hr_utility.trace(' p_plan_id '||
1393: to_char(p_plan_id));
1394: hr_utility.trace(' p_object_version_number '||
1388: hr_utility.trace(' IN / IN OUT PARAMETER '||
1389: ' VALUE');
1390: hr_utility.trace(' --------------------------------'||
1391: '+--------------------------------');
1392: hr_utility.trace(' p_plan_id '||
1393: to_char(p_plan_id));
1394: hr_utility.trace(' p_object_version_number '||
1395: to_char(p_object_version_number));
1396: hr_utility.trace(' --------------------------------'||
1390: hr_utility.trace(' --------------------------------'||
1391: '+--------------------------------');
1392: hr_utility.trace(' p_plan_id '||
1393: to_char(p_plan_id));
1394: hr_utility.trace(' p_object_version_number '||
1395: to_char(p_object_version_number));
1396: hr_utility.trace(' --------------------------------'||
1397: '---------------------------------');
1398: hr_utility.trace(' ');
1392: hr_utility.trace(' p_plan_id '||
1393: to_char(p_plan_id));
1394: hr_utility.trace(' p_object_version_number '||
1395: to_char(p_object_version_number));
1396: hr_utility.trace(' --------------------------------'||
1397: '---------------------------------');
1398: hr_utility.trace(' ');
1399:
1400: END IF;
1394: hr_utility.trace(' p_object_version_number '||
1395: to_char(p_object_version_number));
1396: hr_utility.trace(' --------------------------------'||
1397: '---------------------------------');
1398: hr_utility.trace(' ');
1399:
1400: END IF;
1401:
1402: --
1427:
1428: --
1429: -- End of Before Process User Hook call
1430: --
1431: hr_utility.set_location(l_proc, 7);
1432: --
1433: -- What if mode
1434: --
1435: if (p_validate) then
1448: ,p_what_if => l_what_if);
1449:
1450:
1451:
1452: hr_utility.set_location(l_proc, 8);
1453: --
1454: -- Call After Process User Hook
1455: --
1456: begin
1465: p_hook_type => 'AP'
1466: );
1467: end;
1468:
1469: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1470: --
1471: -- When in validation only mode raise the Validate_Enabled exception
1472: --
1473: if p_validate then
1481:
1482: --
1483: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1484: --
1485: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1486:
1487: exception
1488: when hr_api.validate_enabled then
1489: --
1495: -- Reset IN OUT parameters and set OUT parameters
1496: -- (Any key or derived arguments must be set to null
1497: -- when validation only mode is being used.)
1498: --
1499: hr_utility.set_location(' Leaving:'||l_proc, 980);
1500:
1501: when others then
1502: --
1503: -- A validation or unexpected error has occured
1506: --
1507: -- Reset IN OUT parameters and set all
1508: -- OUT parameters, including warnings, to null
1509: --
1510: hr_utility.set_location(' Leaving:'||l_proc, 990);
1511: raise;
1512:
1513: end reverse_publish_plan;
1514: