78: --
79: -- When in validation only mode raise the Validate_Enabled exception
80: --
81: if p_validate then
82: raise hr_api.validate_enabled;
83: end if;
84: --
85: -- Set all output arguments
86: --
90: hr_utility.set_location(' Leaving:'||l_proc, 70);
91: --
92: exception
93: --
94: when hr_api.validate_enabled then
95: --
96: -- As the Validate_Enabled exception has been raised
97: -- we must rollback to the savepoint
98: --
124: --
125: procedure update_reporting
126: (p_validate in boolean default false
127: ,p_reporting_id in number
128: ,p_benefit_action_id in number default hr_api.g_number
129: ,p_thread_id in number default hr_api.g_number
130: ,p_sequence in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
125: procedure update_reporting
126: (p_validate in boolean default false
127: ,p_reporting_id in number
128: ,p_benefit_action_id in number default hr_api.g_number
129: ,p_thread_id in number default hr_api.g_number
130: ,p_sequence in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
126: (p_validate in boolean default false
127: ,p_reporting_id in number
128: ,p_benefit_action_id in number default hr_api.g_number
129: ,p_thread_id in number default hr_api.g_number
130: ,p_sequence in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
127: ,p_reporting_id in number
128: ,p_benefit_action_id in number default hr_api.g_number
129: ,p_thread_id in number default hr_api.g_number
130: ,p_sequence in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
128: ,p_benefit_action_id in number default hr_api.g_number
129: ,p_thread_id in number default hr_api.g_number
130: ,p_sequence in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
129: ,p_thread_id in number default hr_api.g_number
130: ,p_sequence in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
130: ,p_sequence in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
131: ,p_text in varchar2 default hr_api.g_varchar2
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
132: ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
133: ,p_error_message_code in varchar2 default hr_api.g_varchar2
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
134: ,p_national_identifier in varchar2 default hr_api.g_varchar2
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
135: ,p_related_person_ler_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
136: ,p_temporal_ler_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
137: ,p_ler_id in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
145: ,p_val in number default hr_api.g_number
138: ,p_person_id in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
145: ,p_val in number default hr_api.g_number
146: ,p_mo_num in number default hr_api.g_number
139: ,p_pgm_id in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
145: ,p_val in number default hr_api.g_number
146: ,p_mo_num in number default hr_api.g_number
147: ,p_yr_num in number default hr_api.g_number
140: ,p_pl_id in number default hr_api.g_number
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
145: ,p_val in number default hr_api.g_number
146: ,p_mo_num in number default hr_api.g_number
147: ,p_yr_num in number default hr_api.g_number
148: ,p_object_version_number in out nocopy number) is
141: ,p_related_person_id in number default hr_api.g_number
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
145: ,p_val in number default hr_api.g_number
146: ,p_mo_num in number default hr_api.g_number
147: ,p_yr_num in number default hr_api.g_number
148: ,p_object_version_number in out nocopy number) is
149: --
142: ,p_oipl_id in number default hr_api.g_number
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
145: ,p_val in number default hr_api.g_number
146: ,p_mo_num in number default hr_api.g_number
147: ,p_yr_num in number default hr_api.g_number
148: ,p_object_version_number in out nocopy number) is
149: --
150: -- Declare cursors and local variables
143: ,p_pl_typ_id in number default hr_api.g_number
144: ,p_actl_prem_id in number default hr_api.g_number
145: ,p_val in number default hr_api.g_number
146: ,p_mo_num in number default hr_api.g_number
147: ,p_yr_num in number default hr_api.g_number
148: ,p_object_version_number in out nocopy number) is
149: --
150: -- Declare cursors and local variables
151: --
194: --
195: -- When in validation only mode raise the Validate_Enabled exception
196: --
197: if p_validate then
198: raise hr_api.validate_enabled;
199: end if;
200: --
201: -- Set all output arguments
202: --
205: hr_utility.set_location(' Leaving:'||l_proc, 70);
206: --
207: exception
208: --
209: when hr_api.validate_enabled then
210: --
211: -- As the Validate_Enabled exception has been raised
212: -- we must rollback to the savepoint
213: --
266: --
267: -- When in validation only mode raise the Validate_Enabled exception
268: --
269: if p_validate then
270: raise hr_api.validate_enabled;
271: end if;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 70);
274: --
273: hr_utility.set_location(' Leaving:'||l_proc, 70);
274: --
275: exception
276: --
277: when hr_api.validate_enabled then
278: --
279: -- As the Validate_Enabled exception has been raised
280: -- we must rollback to the savepoint
281: --