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: -- ----------------------------------------------------------------------------
97: begin
98:
99: IF g_debug THEN
100:
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102:
103: hr_utility.trace(' ');
104: hr_utility.trace(' --------------------------------'||
105: '---------------------------------');
99: IF g_debug THEN
100:
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102:
103: hr_utility.trace(' ');
104: hr_utility.trace(' --------------------------------'||
105: '---------------------------------');
106: hr_utility.trace(' IN / IN OUT PARAMETER '||
107: ' VALUE');
100:
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102:
103: hr_utility.trace(' ');
104: hr_utility.trace(' --------------------------------'||
105: '---------------------------------');
106: hr_utility.trace(' IN / IN OUT PARAMETER '||
107: ' VALUE');
108: hr_utility.trace(' --------------------------------'||
102:
103: hr_utility.trace(' ');
104: hr_utility.trace(' --------------------------------'||
105: '---------------------------------');
106: hr_utility.trace(' IN / IN OUT PARAMETER '||
107: ' VALUE');
108: hr_utility.trace(' --------------------------------'||
109: '+--------------------------------');
110: hr_utility.trace(' p_effective_date '||
104: hr_utility.trace(' --------------------------------'||
105: '---------------------------------');
106: hr_utility.trace(' IN / IN OUT PARAMETER '||
107: ' VALUE');
108: hr_utility.trace(' --------------------------------'||
109: '+--------------------------------');
110: hr_utility.trace(' p_effective_date '||
111: to_char(p_effective_date));
112: hr_utility.trace(' p_plan_name '||
106: hr_utility.trace(' IN / IN OUT PARAMETER '||
107: ' VALUE');
108: hr_utility.trace(' --------------------------------'||
109: '+--------------------------------');
110: hr_utility.trace(' p_effective_date '||
111: to_char(p_effective_date));
112: hr_utility.trace(' p_plan_name '||
113: p_plan_name);
114: hr_utility.trace(' p_administrator_person_id '||
108: hr_utility.trace(' --------------------------------'||
109: '+--------------------------------');
110: hr_utility.trace(' p_effective_date '||
111: to_char(p_effective_date));
112: hr_utility.trace(' p_plan_name '||
113: p_plan_name);
114: hr_utility.trace(' p_administrator_person_id '||
115: to_char(p_administrator_person_id));
116: hr_utility.trace(' p_previous_plan_id '||
110: hr_utility.trace(' p_effective_date '||
111: to_char(p_effective_date));
112: hr_utility.trace(' p_plan_name '||
113: p_plan_name);
114: hr_utility.trace(' p_administrator_person_id '||
115: to_char(p_administrator_person_id));
116: hr_utility.trace(' p_previous_plan_id '||
117: to_char(p_previous_plan_id));
118: hr_utility.trace(' p_start_date '||
112: hr_utility.trace(' p_plan_name '||
113: p_plan_name);
114: hr_utility.trace(' p_administrator_person_id '||
115: to_char(p_administrator_person_id));
116: hr_utility.trace(' p_previous_plan_id '||
117: to_char(p_previous_plan_id));
118: hr_utility.trace(' p_start_date '||
119: to_char(p_start_date));
120: hr_utility.trace(' p_end_date '||
114: hr_utility.trace(' p_administrator_person_id '||
115: to_char(p_administrator_person_id));
116: hr_utility.trace(' p_previous_plan_id '||
117: to_char(p_previous_plan_id));
118: hr_utility.trace(' p_start_date '||
119: to_char(p_start_date));
120: hr_utility.trace(' p_end_date '||
121: to_char(p_end_date));
122: hr_utility.trace(' p_hierarchy_type_code '||
116: hr_utility.trace(' p_previous_plan_id '||
117: to_char(p_previous_plan_id));
118: hr_utility.trace(' p_start_date '||
119: to_char(p_start_date));
120: hr_utility.trace(' p_end_date '||
121: to_char(p_end_date));
122: hr_utility.trace(' p_hierarchy_type_code '||
123: p_hierarchy_type_code);
124: hr_utility.trace(' p_supervisor_id '||
118: hr_utility.trace(' p_start_date '||
119: to_char(p_start_date));
120: hr_utility.trace(' p_end_date '||
121: to_char(p_end_date));
122: hr_utility.trace(' p_hierarchy_type_code '||
123: p_hierarchy_type_code);
124: hr_utility.trace(' p_supervisor_id '||
125: to_char(p_supervisor_id));
126: hr_utility.trace(' p_supervisor_assignment_id '||
120: hr_utility.trace(' p_end_date '||
121: to_char(p_end_date));
122: hr_utility.trace(' p_hierarchy_type_code '||
123: p_hierarchy_type_code);
124: hr_utility.trace(' p_supervisor_id '||
125: to_char(p_supervisor_id));
126: hr_utility.trace(' p_supervisor_assignment_id '||
127: to_char(p_supervisor_assignment_id));
128: hr_utility.trace(' p_organization_structure_id '||
122: hr_utility.trace(' p_hierarchy_type_code '||
123: p_hierarchy_type_code);
124: hr_utility.trace(' p_supervisor_id '||
125: to_char(p_supervisor_id));
126: hr_utility.trace(' p_supervisor_assignment_id '||
127: to_char(p_supervisor_assignment_id));
128: hr_utility.trace(' p_organization_structure_id '||
129: to_char(p_organization_structure_id));
130: hr_utility.trace(' p_org_structure_version_id '||
124: hr_utility.trace(' p_supervisor_id '||
125: to_char(p_supervisor_id));
126: hr_utility.trace(' p_supervisor_assignment_id '||
127: to_char(p_supervisor_assignment_id));
128: hr_utility.trace(' p_organization_structure_id '||
129: to_char(p_organization_structure_id));
130: hr_utility.trace(' p_org_structure_version_id '||
131: to_char(p_org_structure_version_id));
132: hr_utility.trace(' p_top_organization_id '||
126: hr_utility.trace(' p_supervisor_assignment_id '||
127: to_char(p_supervisor_assignment_id));
128: hr_utility.trace(' p_organization_structure_id '||
129: to_char(p_organization_structure_id));
130: hr_utility.trace(' p_org_structure_version_id '||
131: to_char(p_org_structure_version_id));
132: hr_utility.trace(' p_top_organization_id '||
133: to_char(p_top_organization_id));
134: hr_utility.trace(' p_position_structure_id '||
128: hr_utility.trace(' p_organization_structure_id '||
129: to_char(p_organization_structure_id));
130: hr_utility.trace(' p_org_structure_version_id '||
131: to_char(p_org_structure_version_id));
132: hr_utility.trace(' p_top_organization_id '||
133: to_char(p_top_organization_id));
134: hr_utility.trace(' p_position_structure_id '||
135: to_char(p_position_structure_id));
136: hr_utility.trace(' p_pos_structure_version_id '||
130: hr_utility.trace(' p_org_structure_version_id '||
131: to_char(p_org_structure_version_id));
132: hr_utility.trace(' p_top_organization_id '||
133: to_char(p_top_organization_id));
134: hr_utility.trace(' p_position_structure_id '||
135: to_char(p_position_structure_id));
136: hr_utility.trace(' p_pos_structure_version_id '||
137: to_char(p_pos_structure_version_id));
138: hr_utility.trace(' p_top_position_id '||
132: hr_utility.trace(' p_top_organization_id '||
133: to_char(p_top_organization_id));
134: hr_utility.trace(' p_position_structure_id '||
135: to_char(p_position_structure_id));
136: hr_utility.trace(' p_pos_structure_version_id '||
137: to_char(p_pos_structure_version_id));
138: hr_utility.trace(' p_top_position_id '||
139: to_char(p_top_position_id));
140: hr_utility.trace(' p_hierarchy_levels '||
134: hr_utility.trace(' p_position_structure_id '||
135: to_char(p_position_structure_id));
136: hr_utility.trace(' p_pos_structure_version_id '||
137: to_char(p_pos_structure_version_id));
138: hr_utility.trace(' p_top_position_id '||
139: to_char(p_top_position_id));
140: hr_utility.trace(' p_hierarchy_levels '||
141: to_char(p_hierarchy_levels));
142: hr_utility.trace(' p_automatic_enrollment_flag '||
136: hr_utility.trace(' p_pos_structure_version_id '||
137: to_char(p_pos_structure_version_id));
138: hr_utility.trace(' p_top_position_id '||
139: to_char(p_top_position_id));
140: hr_utility.trace(' p_hierarchy_levels '||
141: to_char(p_hierarchy_levels));
142: hr_utility.trace(' p_automatic_enrollment_flag '||
143: p_automatic_enrollment_flag);
144: hr_utility.trace(' p_assignment_types_code '||
138: hr_utility.trace(' p_top_position_id '||
139: to_char(p_top_position_id));
140: hr_utility.trace(' p_hierarchy_levels '||
141: to_char(p_hierarchy_levels));
142: hr_utility.trace(' p_automatic_enrollment_flag '||
143: p_automatic_enrollment_flag);
144: hr_utility.trace(' p_assignment_types_code '||
145: p_assignment_types_code);
146: hr_utility.trace(' p_primary_asg_only_flag '||
140: hr_utility.trace(' p_hierarchy_levels '||
141: to_char(p_hierarchy_levels));
142: hr_utility.trace(' p_automatic_enrollment_flag '||
143: p_automatic_enrollment_flag);
144: hr_utility.trace(' p_assignment_types_code '||
145: p_assignment_types_code);
146: hr_utility.trace(' p_primary_asg_only_flag '||
147: p_primary_asg_only_flag);
148: hr_utility.trace(' p_include_obj_setting_flag '||
142: hr_utility.trace(' p_automatic_enrollment_flag '||
143: p_automatic_enrollment_flag);
144: hr_utility.trace(' p_assignment_types_code '||
145: p_assignment_types_code);
146: hr_utility.trace(' p_primary_asg_only_flag '||
147: p_primary_asg_only_flag);
148: hr_utility.trace(' p_include_obj_setting_flag '||
149: p_include_obj_setting_flag);
150: hr_utility.trace(' p_obj_setting_start_date '||
144: hr_utility.trace(' p_assignment_types_code '||
145: p_assignment_types_code);
146: hr_utility.trace(' p_primary_asg_only_flag '||
147: p_primary_asg_only_flag);
148: hr_utility.trace(' p_include_obj_setting_flag '||
149: p_include_obj_setting_flag);
150: hr_utility.trace(' p_obj_setting_start_date '||
151: to_char(p_obj_setting_start_date));
152: hr_utility.trace(' p_obj_setting_deadline '||
146: hr_utility.trace(' p_primary_asg_only_flag '||
147: p_primary_asg_only_flag);
148: hr_utility.trace(' p_include_obj_setting_flag '||
149: p_include_obj_setting_flag);
150: hr_utility.trace(' p_obj_setting_start_date '||
151: to_char(p_obj_setting_start_date));
152: hr_utility.trace(' p_obj_setting_deadline '||
153: to_char(p_obj_setting_deadline));
154: hr_utility.trace(' p_obj_set_outside_period_flag '||
148: hr_utility.trace(' p_include_obj_setting_flag '||
149: p_include_obj_setting_flag);
150: hr_utility.trace(' p_obj_setting_start_date '||
151: to_char(p_obj_setting_start_date));
152: hr_utility.trace(' p_obj_setting_deadline '||
153: to_char(p_obj_setting_deadline));
154: hr_utility.trace(' p_obj_set_outside_period_flag '||
155: p_obj_set_outside_period_flag);
156: hr_utility.trace(' p_method_code '||
150: hr_utility.trace(' p_obj_setting_start_date '||
151: to_char(p_obj_setting_start_date));
152: hr_utility.trace(' p_obj_setting_deadline '||
153: to_char(p_obj_setting_deadline));
154: hr_utility.trace(' p_obj_set_outside_period_flag '||
155: p_obj_set_outside_period_flag);
156: hr_utility.trace(' p_method_code '||
157: p_method_code);
158: hr_utility.trace(' p_notify_population_flag '||
152: hr_utility.trace(' p_obj_setting_deadline '||
153: to_char(p_obj_setting_deadline));
154: hr_utility.trace(' p_obj_set_outside_period_flag '||
155: p_obj_set_outside_period_flag);
156: hr_utility.trace(' p_method_code '||
157: p_method_code);
158: hr_utility.trace(' p_notify_population_flag '||
159: p_notify_population_flag);
160: hr_utility.trace(' p_automatic_allocation_flag '||
154: hr_utility.trace(' p_obj_set_outside_period_flag '||
155: p_obj_set_outside_period_flag);
156: hr_utility.trace(' p_method_code '||
157: p_method_code);
158: hr_utility.trace(' p_notify_population_flag '||
159: p_notify_population_flag);
160: hr_utility.trace(' p_automatic_allocation_flag '||
161: p_automatic_allocation_flag);
162: hr_utility.trace(' p_copy_past_objectives_flag '||
156: hr_utility.trace(' p_method_code '||
157: p_method_code);
158: hr_utility.trace(' p_notify_population_flag '||
159: p_notify_population_flag);
160: hr_utility.trace(' p_automatic_allocation_flag '||
161: p_automatic_allocation_flag);
162: hr_utility.trace(' p_copy_past_objectives_flag '||
163: p_copy_past_objectives_flag);
164: hr_utility.trace(' p_sharing_alignment_task_flag '||
158: hr_utility.trace(' p_notify_population_flag '||
159: p_notify_population_flag);
160: hr_utility.trace(' p_automatic_allocation_flag '||
161: p_automatic_allocation_flag);
162: hr_utility.trace(' p_copy_past_objectives_flag '||
163: p_copy_past_objectives_flag);
164: hr_utility.trace(' p_sharing_alignment_task_flag '||
165: p_sharing_alignment_task_flag);
166: hr_utility.trace(' p_include_appraisals_flag '||
160: hr_utility.trace(' p_automatic_allocation_flag '||
161: p_automatic_allocation_flag);
162: hr_utility.trace(' p_copy_past_objectives_flag '||
163: p_copy_past_objectives_flag);
164: hr_utility.trace(' p_sharing_alignment_task_flag '||
165: p_sharing_alignment_task_flag);
166: hr_utility.trace(' p_include_appraisals_flag '||
167: p_include_appraisals_flag);
168: hr_utility.trace(' p_change_sc_status_flag '||
162: hr_utility.trace(' p_copy_past_objectives_flag '||
163: p_copy_past_objectives_flag);
164: hr_utility.trace(' p_sharing_alignment_task_flag '||
165: p_sharing_alignment_task_flag);
166: hr_utility.trace(' p_include_appraisals_flag '||
167: p_include_appraisals_flag);
168: hr_utility.trace(' p_change_sc_status_flag '||
169: p_change_sc_status_flag);
170: hr_utility.trace(' --------------------------------'||
164: hr_utility.trace(' p_sharing_alignment_task_flag '||
165: p_sharing_alignment_task_flag);
166: hr_utility.trace(' p_include_appraisals_flag '||
167: p_include_appraisals_flag);
168: hr_utility.trace(' p_change_sc_status_flag '||
169: p_change_sc_status_flag);
170: hr_utility.trace(' --------------------------------'||
171: '---------------------------------');
172: hr_utility.trace(' ');
166: hr_utility.trace(' p_include_appraisals_flag '||
167: p_include_appraisals_flag);
168: hr_utility.trace(' p_change_sc_status_flag '||
169: p_change_sc_status_flag);
170: hr_utility.trace(' --------------------------------'||
171: '---------------------------------');
172: hr_utility.trace(' ');
173:
174: END IF;
168: hr_utility.trace(' p_change_sc_status_flag '||
169: p_change_sc_status_flag);
170: hr_utility.trace(' --------------------------------'||
171: '---------------------------------');
172: hr_utility.trace(' ');
173:
174: END IF;
175:
176: --
264: end;
265: --
266: -- End of Before Process User Hook call
267: --
268: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
269:
270: --
271: -- Call the row handler insert
272: --
338: ,p_duplicate_name_warning => l_duplicate_name_warning
339: ,p_no_life_events_warning => p_no_life_events_warning
340: );
341:
342: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
343:
344: --
345: -- Call After Process User Hook
346: --
424: );
425:
426: end;
427:
428: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
429:
430: --
431: -- End of After Process User Hook call
432: --
447:
448:
449: IF g_debug THEN
450:
451: hr_utility.trace(' ');
452: hr_utility.trace('+--------------------------------'||
453: '---------------------------------');
454: hr_utility.trace(' IN OUT / OUT PARAMETER '||
455: ' VALUE');
448:
449: IF g_debug THEN
450:
451: hr_utility.trace(' ');
452: hr_utility.trace('+--------------------------------'||
453: '---------------------------------');
454: hr_utility.trace(' IN OUT / OUT PARAMETER '||
455: ' VALUE');
456: hr_utility.trace(' --------------------------------'||
450:
451: hr_utility.trace(' ');
452: hr_utility.trace('+--------------------------------'||
453: '---------------------------------');
454: hr_utility.trace(' IN OUT / OUT PARAMETER '||
455: ' VALUE');
456: hr_utility.trace(' --------------------------------'||
457: '---------------------------------');
458: hr_utility.trace(' p_plan_id '||
452: hr_utility.trace('+--------------------------------'||
453: '---------------------------------');
454: hr_utility.trace(' IN OUT / OUT PARAMETER '||
455: ' VALUE');
456: hr_utility.trace(' --------------------------------'||
457: '---------------------------------');
458: hr_utility.trace(' p_plan_id '||
459: to_char(p_plan_id));
460: hr_utility.trace(' p_object_version_number '||
454: hr_utility.trace(' IN OUT / OUT PARAMETER '||
455: ' VALUE');
456: hr_utility.trace(' --------------------------------'||
457: '---------------------------------');
458: hr_utility.trace(' p_plan_id '||
459: to_char(p_plan_id));
460: hr_utility.trace(' p_object_version_number '||
461: to_char(p_object_version_number));
462: hr_utility.trace(' p_status_code '||
456: hr_utility.trace(' --------------------------------'||
457: '---------------------------------');
458: hr_utility.trace(' p_plan_id '||
459: to_char(p_plan_id));
460: hr_utility.trace(' p_object_version_number '||
461: to_char(p_object_version_number));
462: hr_utility.trace(' p_status_code '||
463: p_status_code);
464: IF p_duplicate_name_warning THEN
458: hr_utility.trace(' p_plan_id '||
459: to_char(p_plan_id));
460: hr_utility.trace(' p_object_version_number '||
461: to_char(p_object_version_number));
462: hr_utility.trace(' p_status_code '||
463: p_status_code);
464: IF p_duplicate_name_warning THEN
465: hr_utility.trace(' p_duplicate_name_warning '||
466: 'TRUE');
461: to_char(p_object_version_number));
462: hr_utility.trace(' p_status_code '||
463: p_status_code);
464: IF p_duplicate_name_warning THEN
465: hr_utility.trace(' p_duplicate_name_warning '||
466: 'TRUE');
467: ELSE
468: hr_utility.trace(' p_duplicate_name_warning '||
469: 'FALSE');
464: IF p_duplicate_name_warning THEN
465: hr_utility.trace(' p_duplicate_name_warning '||
466: 'TRUE');
467: ELSE
468: hr_utility.trace(' p_duplicate_name_warning '||
469: 'FALSE');
470: END IF;
471: IF p_no_life_events_warning THEN
472: hr_utility.trace(' p_no_life_events_warning '||
468: hr_utility.trace(' p_duplicate_name_warning '||
469: 'FALSE');
470: END IF;
471: IF p_no_life_events_warning THEN
472: hr_utility.trace(' p_no_life_events_warning '||
473: 'TRUE');
474: ELSE
475: hr_utility.trace(' p_no_life_events_warning '||
476: 'FALSE');
471: IF p_no_life_events_warning THEN
472: hr_utility.trace(' p_no_life_events_warning '||
473: 'TRUE');
474: ELSE
475: hr_utility.trace(' p_no_life_events_warning '||
476: 'FALSE');
477: END IF;
478: hr_utility.trace(' --------------------------------'||
479: '---------------------------------');
474: ELSE
475: hr_utility.trace(' p_no_life_events_warning '||
476: 'FALSE');
477: END IF;
478: hr_utility.trace(' --------------------------------'||
479: '---------------------------------');
480: hr_utility.trace(' ');
481: hr_utility.set_location(' Leaving:'||l_proc, 970);
482:
476: 'FALSE');
477: END IF;
478: hr_utility.trace(' --------------------------------'||
479: '---------------------------------');
480: hr_utility.trace(' ');
481: hr_utility.set_location(' Leaving:'||l_proc, 970);
482:
483: END IF;
484:
477: END IF;
478: hr_utility.trace(' --------------------------------'||
479: '---------------------------------');
480: hr_utility.trace(' ');
481: hr_utility.set_location(' Leaving:'||l_proc, 970);
482:
483: END IF;
484:
485: exception
499: p_duplicate_name_warning := l_duplicate_name_warning;
500: p_no_life_events_warning := l_no_life_events_warning;
501:
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 980);
504: --
505: when others then
506: --
507: -- A validation or unexpected error has occured
515: p_object_version_number := null;
516: p_duplicate_name_warning := null;
517: p_no_life_events_warning := null;
518:
519: hr_utility.set_location(' Leaving:'||l_proc, 990);
520: raise;
521:
522: end create_perf_mgmt_plan;
523: --
614: begin
615:
616: IF g_debug THEN
617:
618: hr_utility.set_location('Entering:'|| l_proc, 10);
619:
620: hr_utility.trace(' ');
621: hr_utility.trace(' --------------------------------'||
622: '---------------------------------');
616: IF g_debug THEN
617:
618: hr_utility.set_location('Entering:'|| l_proc, 10);
619:
620: hr_utility.trace(' ');
621: hr_utility.trace(' --------------------------------'||
622: '---------------------------------');
623: hr_utility.trace(' IN / IN OUT PARAMETER '||
624: ' VALUE');
617:
618: hr_utility.set_location('Entering:'|| l_proc, 10);
619:
620: hr_utility.trace(' ');
621: hr_utility.trace(' --------------------------------'||
622: '---------------------------------');
623: hr_utility.trace(' IN / IN OUT PARAMETER '||
624: ' VALUE');
625: hr_utility.trace(' --------------------------------'||
619:
620: hr_utility.trace(' ');
621: hr_utility.trace(' --------------------------------'||
622: '---------------------------------');
623: hr_utility.trace(' IN / IN OUT PARAMETER '||
624: ' VALUE');
625: hr_utility.trace(' --------------------------------'||
626: '+--------------------------------');
627: hr_utility.trace(' p_effective_date '||
621: hr_utility.trace(' --------------------------------'||
622: '---------------------------------');
623: hr_utility.trace(' IN / IN OUT PARAMETER '||
624: ' VALUE');
625: hr_utility.trace(' --------------------------------'||
626: '+--------------------------------');
627: hr_utility.trace(' p_effective_date '||
628: to_char(p_effective_date));
629: hr_utility.trace(' p_plan_id '||
623: hr_utility.trace(' IN / IN OUT PARAMETER '||
624: ' VALUE');
625: hr_utility.trace(' --------------------------------'||
626: '+--------------------------------');
627: hr_utility.trace(' p_effective_date '||
628: to_char(p_effective_date));
629: hr_utility.trace(' p_plan_id '||
630: to_char(p_plan_id));
631: hr_utility.trace(' p_object_version_number '||
625: hr_utility.trace(' --------------------------------'||
626: '+--------------------------------');
627: hr_utility.trace(' p_effective_date '||
628: to_char(p_effective_date));
629: hr_utility.trace(' p_plan_id '||
630: to_char(p_plan_id));
631: hr_utility.trace(' p_object_version_number '||
632: to_char(p_object_version_number));
633: hr_utility.trace(' p_plan_name '||
627: hr_utility.trace(' p_effective_date '||
628: to_char(p_effective_date));
629: hr_utility.trace(' p_plan_id '||
630: to_char(p_plan_id));
631: hr_utility.trace(' p_object_version_number '||
632: to_char(p_object_version_number));
633: hr_utility.trace(' p_plan_name '||
634: p_plan_name);
635: hr_utility.trace(' p_administrator_person_id '||
629: hr_utility.trace(' p_plan_id '||
630: to_char(p_plan_id));
631: hr_utility.trace(' p_object_version_number '||
632: to_char(p_object_version_number));
633: hr_utility.trace(' p_plan_name '||
634: p_plan_name);
635: hr_utility.trace(' p_administrator_person_id '||
636: to_char(p_administrator_person_id));
637: hr_utility.trace(' p_previous_plan_id '||
631: hr_utility.trace(' p_object_version_number '||
632: to_char(p_object_version_number));
633: hr_utility.trace(' p_plan_name '||
634: p_plan_name);
635: hr_utility.trace(' p_administrator_person_id '||
636: to_char(p_administrator_person_id));
637: hr_utility.trace(' p_previous_plan_id '||
638: to_char(p_previous_plan_id));
639: hr_utility.trace(' p_start_date '||
633: hr_utility.trace(' p_plan_name '||
634: p_plan_name);
635: hr_utility.trace(' p_administrator_person_id '||
636: to_char(p_administrator_person_id));
637: hr_utility.trace(' p_previous_plan_id '||
638: to_char(p_previous_plan_id));
639: hr_utility.trace(' p_start_date '||
640: to_char(p_start_date));
641: hr_utility.trace(' p_end_date '||
635: hr_utility.trace(' p_administrator_person_id '||
636: to_char(p_administrator_person_id));
637: hr_utility.trace(' p_previous_plan_id '||
638: to_char(p_previous_plan_id));
639: hr_utility.trace(' p_start_date '||
640: to_char(p_start_date));
641: hr_utility.trace(' p_end_date '||
642: to_char(p_end_date));
643: hr_utility.trace(' p_hierarchy_type_code '||
637: hr_utility.trace(' p_previous_plan_id '||
638: to_char(p_previous_plan_id));
639: hr_utility.trace(' p_start_date '||
640: to_char(p_start_date));
641: hr_utility.trace(' p_end_date '||
642: to_char(p_end_date));
643: hr_utility.trace(' p_hierarchy_type_code '||
644: p_hierarchy_type_code);
645: hr_utility.trace(' p_supervisor_id '||
639: hr_utility.trace(' p_start_date '||
640: to_char(p_start_date));
641: hr_utility.trace(' p_end_date '||
642: to_char(p_end_date));
643: hr_utility.trace(' p_hierarchy_type_code '||
644: p_hierarchy_type_code);
645: hr_utility.trace(' p_supervisor_id '||
646: to_char(p_supervisor_id));
647: hr_utility.trace(' p_supervisor_assignment_id '||
641: hr_utility.trace(' p_end_date '||
642: to_char(p_end_date));
643: hr_utility.trace(' p_hierarchy_type_code '||
644: p_hierarchy_type_code);
645: hr_utility.trace(' p_supervisor_id '||
646: to_char(p_supervisor_id));
647: hr_utility.trace(' p_supervisor_assignment_id '||
648: to_char(p_supervisor_assignment_id));
649: hr_utility.trace(' p_organization_structure_id '||
643: hr_utility.trace(' p_hierarchy_type_code '||
644: p_hierarchy_type_code);
645: hr_utility.trace(' p_supervisor_id '||
646: to_char(p_supervisor_id));
647: hr_utility.trace(' p_supervisor_assignment_id '||
648: to_char(p_supervisor_assignment_id));
649: hr_utility.trace(' p_organization_structure_id '||
650: to_char(p_organization_structure_id));
651: hr_utility.trace(' p_org_structure_version_id '||
645: hr_utility.trace(' p_supervisor_id '||
646: to_char(p_supervisor_id));
647: hr_utility.trace(' p_supervisor_assignment_id '||
648: to_char(p_supervisor_assignment_id));
649: hr_utility.trace(' p_organization_structure_id '||
650: to_char(p_organization_structure_id));
651: hr_utility.trace(' p_org_structure_version_id '||
652: to_char(p_org_structure_version_id));
653: hr_utility.trace(' p_top_organization_id '||
647: hr_utility.trace(' p_supervisor_assignment_id '||
648: to_char(p_supervisor_assignment_id));
649: hr_utility.trace(' p_organization_structure_id '||
650: to_char(p_organization_structure_id));
651: hr_utility.trace(' p_org_structure_version_id '||
652: to_char(p_org_structure_version_id));
653: hr_utility.trace(' p_top_organization_id '||
654: to_char(p_top_organization_id));
655: hr_utility.trace(' p_position_structure_id '||
649: hr_utility.trace(' p_organization_structure_id '||
650: to_char(p_organization_structure_id));
651: hr_utility.trace(' p_org_structure_version_id '||
652: to_char(p_org_structure_version_id));
653: hr_utility.trace(' p_top_organization_id '||
654: to_char(p_top_organization_id));
655: hr_utility.trace(' p_position_structure_id '||
656: to_char(p_position_structure_id));
657: hr_utility.trace(' p_pos_structure_version_id '||
651: hr_utility.trace(' p_org_structure_version_id '||
652: to_char(p_org_structure_version_id));
653: hr_utility.trace(' p_top_organization_id '||
654: to_char(p_top_organization_id));
655: hr_utility.trace(' p_position_structure_id '||
656: to_char(p_position_structure_id));
657: hr_utility.trace(' p_pos_structure_version_id '||
658: to_char(p_pos_structure_version_id));
659: hr_utility.trace(' p_top_position_id '||
653: hr_utility.trace(' p_top_organization_id '||
654: to_char(p_top_organization_id));
655: hr_utility.trace(' p_position_structure_id '||
656: to_char(p_position_structure_id));
657: hr_utility.trace(' p_pos_structure_version_id '||
658: to_char(p_pos_structure_version_id));
659: hr_utility.trace(' p_top_position_id '||
660: to_char(p_top_position_id));
661: hr_utility.trace(' p_hierarchy_levels '||
655: hr_utility.trace(' p_position_structure_id '||
656: to_char(p_position_structure_id));
657: hr_utility.trace(' p_pos_structure_version_id '||
658: to_char(p_pos_structure_version_id));
659: hr_utility.trace(' p_top_position_id '||
660: to_char(p_top_position_id));
661: hr_utility.trace(' p_hierarchy_levels '||
662: to_char(p_hierarchy_levels));
663: hr_utility.trace(' p_automatic_enrollment_flag '||
657: hr_utility.trace(' p_pos_structure_version_id '||
658: to_char(p_pos_structure_version_id));
659: hr_utility.trace(' p_top_position_id '||
660: to_char(p_top_position_id));
661: hr_utility.trace(' p_hierarchy_levels '||
662: to_char(p_hierarchy_levels));
663: hr_utility.trace(' p_automatic_enrollment_flag '||
664: p_automatic_enrollment_flag);
665: hr_utility.trace(' p_assignment_types_code '||
659: hr_utility.trace(' p_top_position_id '||
660: to_char(p_top_position_id));
661: hr_utility.trace(' p_hierarchy_levels '||
662: to_char(p_hierarchy_levels));
663: hr_utility.trace(' p_automatic_enrollment_flag '||
664: p_automatic_enrollment_flag);
665: hr_utility.trace(' p_assignment_types_code '||
666: p_assignment_types_code);
667: hr_utility.trace(' p_primary_asg_only_flag '||
661: hr_utility.trace(' p_hierarchy_levels '||
662: to_char(p_hierarchy_levels));
663: hr_utility.trace(' p_automatic_enrollment_flag '||
664: p_automatic_enrollment_flag);
665: hr_utility.trace(' p_assignment_types_code '||
666: p_assignment_types_code);
667: hr_utility.trace(' p_primary_asg_only_flag '||
668: p_primary_asg_only_flag);
669: hr_utility.trace(' p_include_obj_setting_flag '||
663: hr_utility.trace(' p_automatic_enrollment_flag '||
664: p_automatic_enrollment_flag);
665: hr_utility.trace(' p_assignment_types_code '||
666: p_assignment_types_code);
667: hr_utility.trace(' p_primary_asg_only_flag '||
668: p_primary_asg_only_flag);
669: hr_utility.trace(' p_include_obj_setting_flag '||
670: p_include_obj_setting_flag);
671: hr_utility.trace(' p_obj_setting_start_date '||
665: hr_utility.trace(' p_assignment_types_code '||
666: p_assignment_types_code);
667: hr_utility.trace(' p_primary_asg_only_flag '||
668: p_primary_asg_only_flag);
669: hr_utility.trace(' p_include_obj_setting_flag '||
670: p_include_obj_setting_flag);
671: hr_utility.trace(' p_obj_setting_start_date '||
672: to_char(p_obj_setting_start_date));
673: hr_utility.trace(' p_obj_setting_deadline '||
667: hr_utility.trace(' p_primary_asg_only_flag '||
668: p_primary_asg_only_flag);
669: hr_utility.trace(' p_include_obj_setting_flag '||
670: p_include_obj_setting_flag);
671: hr_utility.trace(' p_obj_setting_start_date '||
672: to_char(p_obj_setting_start_date));
673: hr_utility.trace(' p_obj_setting_deadline '||
674: to_char(p_obj_setting_deadline));
675: hr_utility.trace(' p_obj_set_outside_period_flag '||
669: hr_utility.trace(' p_include_obj_setting_flag '||
670: p_include_obj_setting_flag);
671: hr_utility.trace(' p_obj_setting_start_date '||
672: to_char(p_obj_setting_start_date));
673: hr_utility.trace(' p_obj_setting_deadline '||
674: to_char(p_obj_setting_deadline));
675: hr_utility.trace(' p_obj_set_outside_period_flag '||
676: p_obj_set_outside_period_flag);
677: hr_utility.trace(' p_method_code '||
671: hr_utility.trace(' p_obj_setting_start_date '||
672: to_char(p_obj_setting_start_date));
673: hr_utility.trace(' p_obj_setting_deadline '||
674: to_char(p_obj_setting_deadline));
675: hr_utility.trace(' p_obj_set_outside_period_flag '||
676: p_obj_set_outside_period_flag);
677: hr_utility.trace(' p_method_code '||
678: p_method_code);
679: hr_utility.trace(' p_notify_population_flag '||
673: hr_utility.trace(' p_obj_setting_deadline '||
674: to_char(p_obj_setting_deadline));
675: hr_utility.trace(' p_obj_set_outside_period_flag '||
676: p_obj_set_outside_period_flag);
677: hr_utility.trace(' p_method_code '||
678: p_method_code);
679: hr_utility.trace(' p_notify_population_flag '||
680: p_notify_population_flag);
681: hr_utility.trace(' p_automatic_allocation_flag '||
675: hr_utility.trace(' p_obj_set_outside_period_flag '||
676: p_obj_set_outside_period_flag);
677: hr_utility.trace(' p_method_code '||
678: p_method_code);
679: hr_utility.trace(' p_notify_population_flag '||
680: p_notify_population_flag);
681: hr_utility.trace(' p_automatic_allocation_flag '||
682: p_automatic_allocation_flag);
683: hr_utility.trace(' p_copy_past_objectives_flag '||
677: hr_utility.trace(' p_method_code '||
678: p_method_code);
679: hr_utility.trace(' p_notify_population_flag '||
680: p_notify_population_flag);
681: hr_utility.trace(' p_automatic_allocation_flag '||
682: p_automatic_allocation_flag);
683: hr_utility.trace(' p_copy_past_objectives_flag '||
684: p_copy_past_objectives_flag);
685: hr_utility.trace(' p_sharing_alignment_task_flag '||
679: hr_utility.trace(' p_notify_population_flag '||
680: p_notify_population_flag);
681: hr_utility.trace(' p_automatic_allocation_flag '||
682: p_automatic_allocation_flag);
683: hr_utility.trace(' p_copy_past_objectives_flag '||
684: p_copy_past_objectives_flag);
685: hr_utility.trace(' p_sharing_alignment_task_flag '||
686: p_sharing_alignment_task_flag);
687: hr_utility.trace(' p_include_appraisals_flag '||
681: hr_utility.trace(' p_automatic_allocation_flag '||
682: p_automatic_allocation_flag);
683: hr_utility.trace(' p_copy_past_objectives_flag '||
684: p_copy_past_objectives_flag);
685: hr_utility.trace(' p_sharing_alignment_task_flag '||
686: p_sharing_alignment_task_flag);
687: hr_utility.trace(' p_include_appraisals_flag '||
688: p_include_appraisals_flag);
689: hr_utility.trace(' p_change_sc_status_flag '||
683: hr_utility.trace(' p_copy_past_objectives_flag '||
684: p_copy_past_objectives_flag);
685: hr_utility.trace(' p_sharing_alignment_task_flag '||
686: p_sharing_alignment_task_flag);
687: hr_utility.trace(' p_include_appraisals_flag '||
688: p_include_appraisals_flag);
689: hr_utility.trace(' p_change_sc_status_flag '||
690: p_change_sc_status_flag);
691: hr_utility.trace(' --------------------------------'||
685: hr_utility.trace(' p_sharing_alignment_task_flag '||
686: p_sharing_alignment_task_flag);
687: hr_utility.trace(' p_include_appraisals_flag '||
688: p_include_appraisals_flag);
689: hr_utility.trace(' p_change_sc_status_flag '||
690: p_change_sc_status_flag);
691: hr_utility.trace(' --------------------------------'||
692: '---------------------------------');
693: hr_utility.trace(' ');
687: hr_utility.trace(' p_include_appraisals_flag '||
688: p_include_appraisals_flag);
689: hr_utility.trace(' p_change_sc_status_flag '||
690: p_change_sc_status_flag);
691: hr_utility.trace(' --------------------------------'||
692: '---------------------------------');
693: hr_utility.trace(' ');
694:
695: END IF;
689: hr_utility.trace(' p_change_sc_status_flag '||
690: p_change_sc_status_flag);
691: hr_utility.trace(' --------------------------------'||
692: '---------------------------------');
693: hr_utility.trace(' ');
694:
695: END IF;
696:
697: --
794:
795: --
796: -- Process Logic
797: --
798: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
799:
800: --
801: -- Change the plan's status to updated if it's currently
802: -- published.
877: ,p_duplicate_name_warning => l_duplicate_name_warning
878: ,p_no_life_events_warning => l_no_life_events_warning
879: );
880:
881: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
882: --
883: -- Call After Process User Hook
884: --
885: begin
958: p_hook_type => 'AP'
959: );
960: end;
961:
962: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
963:
964: --
965: -- End of After Process User Hook call
966: --
979: p_no_life_events_warning := l_no_life_events_warning;
980:
981: IF g_debug THEN
982:
983: hr_utility.trace(' ');
984: hr_utility.trace(' --------------------------------'||
985: '---------------------------------');
986: hr_utility.trace(' IN OUT / OUT PARAMETER '||
987: ' VALUE');
980:
981: IF g_debug THEN
982:
983: hr_utility.trace(' ');
984: hr_utility.trace(' --------------------------------'||
985: '---------------------------------');
986: hr_utility.trace(' IN OUT / OUT PARAMETER '||
987: ' VALUE');
988: hr_utility.trace(' --------------------------------'||
982:
983: hr_utility.trace(' ');
984: hr_utility.trace(' --------------------------------'||
985: '---------------------------------');
986: hr_utility.trace(' IN OUT / OUT PARAMETER '||
987: ' VALUE');
988: hr_utility.trace(' --------------------------------'||
989: '+--------------------------------');
990: hr_utility.trace(' p_object_version_number '||
984: hr_utility.trace(' --------------------------------'||
985: '---------------------------------');
986: hr_utility.trace(' IN OUT / OUT PARAMETER '||
987: ' VALUE');
988: hr_utility.trace(' --------------------------------'||
989: '+--------------------------------');
990: hr_utility.trace(' p_object_version_number '||
991: to_char(p_object_version_number));
992: hr_utility.trace(' p_status_code '||
986: hr_utility.trace(' IN OUT / OUT PARAMETER '||
987: ' VALUE');
988: hr_utility.trace(' --------------------------------'||
989: '+--------------------------------');
990: hr_utility.trace(' p_object_version_number '||
991: to_char(p_object_version_number));
992: hr_utility.trace(' p_status_code '||
993: p_status_code);
994: IF p_duplicate_name_warning THEN
988: hr_utility.trace(' --------------------------------'||
989: '+--------------------------------');
990: hr_utility.trace(' p_object_version_number '||
991: to_char(p_object_version_number));
992: hr_utility.trace(' p_status_code '||
993: p_status_code);
994: IF p_duplicate_name_warning THEN
995: hr_utility.trace(' p_duplicate_name_warning '||
996: 'TRUE');
991: to_char(p_object_version_number));
992: hr_utility.trace(' p_status_code '||
993: p_status_code);
994: IF p_duplicate_name_warning THEN
995: hr_utility.trace(' p_duplicate_name_warning '||
996: 'TRUE');
997: ELSE
998: hr_utility.trace(' p_duplicate_name_warning '||
999: 'FALSE');
994: IF p_duplicate_name_warning THEN
995: hr_utility.trace(' p_duplicate_name_warning '||
996: 'TRUE');
997: ELSE
998: hr_utility.trace(' p_duplicate_name_warning '||
999: 'FALSE');
1000: END IF;
1001: IF p_no_life_events_warning THEN
1002: hr_utility.trace(' p_no_life_events_warning '||
998: hr_utility.trace(' p_duplicate_name_warning '||
999: 'FALSE');
1000: END IF;
1001: IF p_no_life_events_warning THEN
1002: hr_utility.trace(' p_no_life_events_warning '||
1003: 'TRUE');
1004: ELSE
1005: hr_utility.trace(' p_no_life_events_warning '||
1006: 'FALSE');
1001: IF p_no_life_events_warning THEN
1002: hr_utility.trace(' p_no_life_events_warning '||
1003: 'TRUE');
1004: ELSE
1005: hr_utility.trace(' p_no_life_events_warning '||
1006: 'FALSE');
1007: END IF;
1008: hr_utility.trace(' --------------------------------'||
1009: '---------------------------------');
1004: ELSE
1005: hr_utility.trace(' p_no_life_events_warning '||
1006: 'FALSE');
1007: END IF;
1008: hr_utility.trace(' --------------------------------'||
1009: '---------------------------------');
1010: hr_utility.trace(' ');
1011: hr_utility.set_location(' Leaving:'||l_proc, 970);
1012:
1006: 'FALSE');
1007: END IF;
1008: hr_utility.trace(' --------------------------------'||
1009: '---------------------------------');
1010: hr_utility.trace(' ');
1011: hr_utility.set_location(' Leaving:'||l_proc, 970);
1012:
1013: END IF;
1014:
1007: END IF;
1008: hr_utility.trace(' --------------------------------'||
1009: '---------------------------------');
1010: hr_utility.trace(' ');
1011: hr_utility.set_location(' Leaving:'||l_proc, 970);
1012:
1013: END IF;
1014:
1015: exception
1028: p_status_code := l_status_code;
1029: p_duplicate_name_warning := l_duplicate_name_warning;
1030: p_no_life_events_warning := l_no_life_events_warning;
1031: --
1032: hr_utility.set_location(' Leaving:'||l_proc, 980);
1033: --
1034: when others then
1035: --
1036: -- A validation or unexpected error has occured
1044: p_status_code := null;
1045: p_duplicate_name_warning := null;
1046: p_no_life_events_warning := null;
1047:
1048: hr_utility.set_location(' Leaving:'||l_proc, 990);
1049: raise;
1050:
1051: end update_perf_mgmt_plan;
1052: --
1069: begin
1070:
1071: IF g_debug THEN
1072:
1073: hr_utility.set_location('Entering:'|| l_proc, 10);
1074:
1075: hr_utility.trace(' ');
1076: hr_utility.trace(' --------------------------------'||
1077: '---------------------------------');
1071: IF g_debug THEN
1072:
1073: hr_utility.set_location('Entering:'|| l_proc, 10);
1074:
1075: hr_utility.trace(' ');
1076: hr_utility.trace(' --------------------------------'||
1077: '---------------------------------');
1078: hr_utility.trace(' IN / IN OUT PARAMETER '||
1079: ' VALUE');
1072:
1073: hr_utility.set_location('Entering:'|| l_proc, 10);
1074:
1075: hr_utility.trace(' ');
1076: hr_utility.trace(' --------------------------------'||
1077: '---------------------------------');
1078: hr_utility.trace(' IN / IN OUT PARAMETER '||
1079: ' VALUE');
1080: hr_utility.trace(' --------------------------------'||
1074:
1075: hr_utility.trace(' ');
1076: hr_utility.trace(' --------------------------------'||
1077: '---------------------------------');
1078: hr_utility.trace(' IN / IN OUT PARAMETER '||
1079: ' VALUE');
1080: hr_utility.trace(' --------------------------------'||
1081: '+--------------------------------');
1082: hr_utility.trace(' p_plan_id '||
1076: hr_utility.trace(' --------------------------------'||
1077: '---------------------------------');
1078: hr_utility.trace(' IN / IN OUT PARAMETER '||
1079: ' VALUE');
1080: hr_utility.trace(' --------------------------------'||
1081: '+--------------------------------');
1082: hr_utility.trace(' p_plan_id '||
1083: to_char(p_plan_id));
1084: hr_utility.trace(' p_object_version_number '||
1078: hr_utility.trace(' IN / IN OUT PARAMETER '||
1079: ' VALUE');
1080: hr_utility.trace(' --------------------------------'||
1081: '+--------------------------------');
1082: hr_utility.trace(' p_plan_id '||
1083: to_char(p_plan_id));
1084: hr_utility.trace(' p_object_version_number '||
1085: to_char(p_object_version_number));
1086: hr_utility.trace(' --------------------------------'||
1080: hr_utility.trace(' --------------------------------'||
1081: '+--------------------------------');
1082: hr_utility.trace(' p_plan_id '||
1083: to_char(p_plan_id));
1084: hr_utility.trace(' p_object_version_number '||
1085: to_char(p_object_version_number));
1086: hr_utility.trace(' --------------------------------'||
1087: '---------------------------------');
1088: hr_utility.trace(' ');
1082: hr_utility.trace(' p_plan_id '||
1083: to_char(p_plan_id));
1084: hr_utility.trace(' p_object_version_number '||
1085: to_char(p_object_version_number));
1086: hr_utility.trace(' --------------------------------'||
1087: '---------------------------------');
1088: hr_utility.trace(' ');
1089:
1090: END IF;
1084: hr_utility.trace(' p_object_version_number '||
1085: to_char(p_object_version_number));
1086: hr_utility.trace(' --------------------------------'||
1087: '---------------------------------');
1088: hr_utility.trace(' ');
1089:
1090: END IF;
1091:
1092: --
1112:
1113: --
1114: -- End of Before Process User Hook call
1115: --
1116: hr_utility.set_location(l_proc, 7);
1117: --
1118: -- Process Logic - Delete Plan
1119: --
1120:
1122: (p_plan_id => p_plan_id
1123: ,p_object_version_number => p_object_version_number
1124: );
1125:
1126: hr_utility.set_location(l_proc, 8);
1127: --
1128: -- Call After Process User Hook
1129: --
1130: begin
1139: p_hook_type => 'AP'
1140: );
1141: end;
1142:
1143: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1144: --
1145: -- When in validation only mode raise the Validate_Enabled exception
1146: --
1147: if p_validate then
1150:
1151: --
1152: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1153: --
1154: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1155:
1156: exception
1157: when hr_api.validate_enabled then
1158: --
1164: -- Reset IN OUT parameters and set OUT parameters
1165: -- (Any key or derived arguments must be set to null
1166: -- when validation only mode is being used.)
1167: --
1168: hr_utility.set_location(' Leaving:'||l_proc, 980);
1169:
1170: when others then
1171: --
1172: -- A validation or unexpected error has occured
1175: --
1176: -- Reset IN OUT parameters and set all
1177: -- OUT parameters, including warnings, to null
1178: --
1179: hr_utility.set_location(' Leaving:'||l_proc, 990);
1180: raise;
1181:
1182: end delete_perf_mgmt_plan;
1183: --
1205: begin
1206:
1207: IF g_debug THEN
1208:
1209: hr_utility.set_location('Entering:'|| l_proc, 10);
1210:
1211: hr_utility.trace(' ');
1212: hr_utility.trace(' --------------------------------'||
1213: '---------------------------------');
1207: IF g_debug THEN
1208:
1209: hr_utility.set_location('Entering:'|| l_proc, 10);
1210:
1211: hr_utility.trace(' ');
1212: hr_utility.trace(' --------------------------------'||
1213: '---------------------------------');
1214: hr_utility.trace(' IN / IN OUT PARAMETER '||
1215: ' VALUE');
1208:
1209: hr_utility.set_location('Entering:'|| l_proc, 10);
1210:
1211: hr_utility.trace(' ');
1212: hr_utility.trace(' --------------------------------'||
1213: '---------------------------------');
1214: hr_utility.trace(' IN / IN OUT PARAMETER '||
1215: ' VALUE');
1216: hr_utility.trace(' --------------------------------'||
1210:
1211: hr_utility.trace(' ');
1212: hr_utility.trace(' --------------------------------'||
1213: '---------------------------------');
1214: hr_utility.trace(' IN / IN OUT PARAMETER '||
1215: ' VALUE');
1216: hr_utility.trace(' --------------------------------'||
1217: '+--------------------------------');
1218: hr_utility.trace(' p_plan_id '||
1212: hr_utility.trace(' --------------------------------'||
1213: '---------------------------------');
1214: hr_utility.trace(' IN / IN OUT PARAMETER '||
1215: ' VALUE');
1216: hr_utility.trace(' --------------------------------'||
1217: '+--------------------------------');
1218: hr_utility.trace(' p_plan_id '||
1219: to_char(p_plan_id));
1220: hr_utility.trace(' p_object_version_number '||
1214: hr_utility.trace(' IN / IN OUT PARAMETER '||
1215: ' VALUE');
1216: hr_utility.trace(' --------------------------------'||
1217: '+--------------------------------');
1218: hr_utility.trace(' p_plan_id '||
1219: to_char(p_plan_id));
1220: hr_utility.trace(' p_object_version_number '||
1221: to_char(p_object_version_number));
1222: hr_utility.trace(' --------------------------------'||
1216: hr_utility.trace(' --------------------------------'||
1217: '+--------------------------------');
1218: hr_utility.trace(' p_plan_id '||
1219: to_char(p_plan_id));
1220: hr_utility.trace(' p_object_version_number '||
1221: to_char(p_object_version_number));
1222: hr_utility.trace(' --------------------------------'||
1223: '---------------------------------');
1224: hr_utility.trace(' ');
1218: hr_utility.trace(' p_plan_id '||
1219: to_char(p_plan_id));
1220: hr_utility.trace(' p_object_version_number '||
1221: to_char(p_object_version_number));
1222: hr_utility.trace(' --------------------------------'||
1223: '---------------------------------');
1224: hr_utility.trace(' ');
1225:
1226: END IF;
1220: hr_utility.trace(' p_object_version_number '||
1221: to_char(p_object_version_number));
1222: hr_utility.trace(' --------------------------------'||
1223: '---------------------------------');
1224: hr_utility.trace(' ');
1225:
1226: END IF;
1227:
1228: --
1255:
1256: --
1257: -- End of Before Process User Hook call
1258: --
1259: hr_utility.set_location(l_proc, 7);
1260: --
1261: -- What if mode
1262: --
1263: if (p_validate) then
1275: ,p_reverse_mode => 'N'
1276: ,p_what_if => l_what_if
1277: );
1278:
1279: hr_utility.set_location(l_proc, 8);
1280: --
1281: -- Call After Process User Hook
1282: --
1283: begin
1293: p_hook_type => 'AP'
1294: );
1295: end;
1296:
1297: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1298: --
1299: -- When in validation only mode raise the Validate_Enabled exception
1300: --
1301: if p_validate then
1309:
1310: --
1311: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1312: --
1313: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1314:
1315: exception
1316: when hr_api.validate_enabled then
1317: --
1323: -- Reset IN OUT parameters and set OUT parameters
1324: -- (Any key or derived arguments must be set to null
1325: -- when validation only mode is being used.)
1326: --
1327: hr_utility.set_location(' Leaving:'||l_proc, 980);
1328:
1329: when others then
1330: --
1331: -- A validation or unexpected error has occured
1334: --
1335: -- Reset IN OUT parameters and set all
1336: -- OUT parameters, including warnings, to null
1337: --
1338: hr_utility.set_location(' Leaving:'||l_proc, 990);
1339: raise;
1340:
1341: end publish_plan;
1342:
1363: begin
1364:
1365: IF g_debug THEN
1366:
1367: hr_utility.set_location('Entering:'|| l_proc, 10);
1368:
1369: hr_utility.trace(' ');
1370: hr_utility.trace(' --------------------------------'||
1371: '---------------------------------');
1365: IF g_debug THEN
1366:
1367: hr_utility.set_location('Entering:'|| l_proc, 10);
1368:
1369: hr_utility.trace(' ');
1370: hr_utility.trace(' --------------------------------'||
1371: '---------------------------------');
1372: hr_utility.trace(' IN / IN OUT PARAMETER '||
1373: ' VALUE');
1366:
1367: hr_utility.set_location('Entering:'|| l_proc, 10);
1368:
1369: hr_utility.trace(' ');
1370: hr_utility.trace(' --------------------------------'||
1371: '---------------------------------');
1372: hr_utility.trace(' IN / IN OUT PARAMETER '||
1373: ' VALUE');
1374: hr_utility.trace(' --------------------------------'||
1368:
1369: hr_utility.trace(' ');
1370: hr_utility.trace(' --------------------------------'||
1371: '---------------------------------');
1372: hr_utility.trace(' IN / IN OUT PARAMETER '||
1373: ' VALUE');
1374: hr_utility.trace(' --------------------------------'||
1375: '+--------------------------------');
1376: hr_utility.trace(' p_plan_id '||
1370: hr_utility.trace(' --------------------------------'||
1371: '---------------------------------');
1372: hr_utility.trace(' IN / IN OUT PARAMETER '||
1373: ' VALUE');
1374: hr_utility.trace(' --------------------------------'||
1375: '+--------------------------------');
1376: hr_utility.trace(' p_plan_id '||
1377: to_char(p_plan_id));
1378: hr_utility.trace(' p_object_version_number '||
1372: hr_utility.trace(' IN / IN OUT PARAMETER '||
1373: ' VALUE');
1374: hr_utility.trace(' --------------------------------'||
1375: '+--------------------------------');
1376: hr_utility.trace(' p_plan_id '||
1377: to_char(p_plan_id));
1378: hr_utility.trace(' p_object_version_number '||
1379: to_char(p_object_version_number));
1380: hr_utility.trace(' --------------------------------'||
1374: hr_utility.trace(' --------------------------------'||
1375: '+--------------------------------');
1376: hr_utility.trace(' p_plan_id '||
1377: to_char(p_plan_id));
1378: hr_utility.trace(' p_object_version_number '||
1379: to_char(p_object_version_number));
1380: hr_utility.trace(' --------------------------------'||
1381: '---------------------------------');
1382: hr_utility.trace(' ');
1376: hr_utility.trace(' p_plan_id '||
1377: to_char(p_plan_id));
1378: hr_utility.trace(' p_object_version_number '||
1379: to_char(p_object_version_number));
1380: hr_utility.trace(' --------------------------------'||
1381: '---------------------------------');
1382: hr_utility.trace(' ');
1383:
1384: END IF;
1378: hr_utility.trace(' p_object_version_number '||
1379: to_char(p_object_version_number));
1380: hr_utility.trace(' --------------------------------'||
1381: '---------------------------------');
1382: hr_utility.trace(' ');
1383:
1384: END IF;
1385:
1386: --
1411:
1412: --
1413: -- End of Before Process User Hook call
1414: --
1415: hr_utility.set_location(l_proc, 7);
1416: --
1417: -- What if mode
1418: --
1419: if (p_validate) then
1432: ,p_what_if => l_what_if);
1433:
1434:
1435:
1436: hr_utility.set_location(l_proc, 8);
1437: --
1438: -- Call After Process User Hook
1439: --
1440: begin
1449: p_hook_type => 'AP'
1450: );
1451: end;
1452:
1453: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1454: --
1455: -- When in validation only mode raise the Validate_Enabled exception
1456: --
1457: if p_validate then
1465:
1466: --
1467: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1468: --
1469: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1470:
1471: exception
1472: when hr_api.validate_enabled then
1473: --
1479: -- Reset IN OUT parameters and set OUT parameters
1480: -- (Any key or derived arguments must be set to null
1481: -- when validation only mode is being used.)
1482: --
1483: hr_utility.set_location(' Leaving:'||l_proc, 980);
1484:
1485: when others then
1486: --
1487: -- A validation or unexpected error has occured
1490: --
1491: -- Reset IN OUT parameters and set all
1492: -- OUT parameters, including warnings, to null
1493: --
1494: hr_utility.set_location(' Leaving:'||l_proc, 990);
1495: raise;
1496:
1497: end reverse_publish_plan;
1498: