DBA Data[Home] [Help]

APPS.PQH_FR_VALIDATION_PERIODS_API dependencies on HR_API

Line 70: when hr_api.cannot_find_prog_unit then

66: );
67:
68:
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
73: ,p_hook_type => 'BP'
74: );

Line 71: hr_api.cannot_find_prog_unit_error

67:
68:
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
73: ,p_hook_type => 'BP'
74: );
75: end;

Line 119: when hr_api.cannot_find_prog_unit then

115: ,p_comments => p_comments
116: ,p_validation_status => p_validation_status);
117:
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
122: ,p_hook_type => 'AP'
123: );

Line 120: hr_api.cannot_find_prog_unit_error

116: ,p_validation_status => p_validation_status);
117:
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
122: ,p_hook_type => 'AP'
123: );
124: end;

Line 132: -- raise hr_api.validate_enabled;

128: -- Removed p_validate from the generated code to facilitate
129: -- writing wrappers to selfservice easily.
130: --
131: -- if p_validate then
132: -- raise hr_api.validate_enabled;
133: -- end if;
134: --
135: -- Set all output arguments
136: --

Line 144: when hr_api.validate_enabled then

140:
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: exception
144: when hr_api.validate_enabled then
145: --
146: -- As the Validate_Enabled exception has been raised
147: -- we must rollback to the savepoint
148: --

Line 177: ,p_validation_id in number default hr_api.g_number

173: procedure Update_Validation_Period
174: (p_effective_date in date
175: ,p_validation_period_id in number
176: ,p_object_version_number in out nocopy number
177: ,p_validation_id in number default hr_api.g_number
178: ,p_start_date in date default hr_api.g_date
179: ,p_end_date in date default hr_api.g_date
180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 178: ,p_start_date in date default hr_api.g_date

174: (p_effective_date in date
175: ,p_validation_period_id in number
176: ,p_object_version_number in out nocopy number
177: ,p_validation_id in number default hr_api.g_number
178: ,p_start_date in date default hr_api.g_date
179: ,p_end_date in date default hr_api.g_date
180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number

Line 179: ,p_end_date in date default hr_api.g_date

175: ,p_validation_period_id in number
176: ,p_object_version_number in out nocopy number
177: ,p_validation_id in number default hr_api.g_number
178: ,p_start_date in date default hr_api.g_date
179: ,p_end_date in date default hr_api.g_date
180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 180: ,p_previous_employer_id in number default hr_api.g_number

176: ,p_object_version_number in out nocopy number
177: ,p_validation_id in number default hr_api.g_number
178: ,p_start_date in date default hr_api.g_date
179: ,p_end_date in date default hr_api.g_date
180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number

Line 181: ,p_assignment_category in varchar2 default hr_api.g_varchar2

177: ,p_validation_id in number default hr_api.g_number
178: ,p_start_date in date default hr_api.g_date
179: ,p_end_date in date default hr_api.g_date
180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number

Line 182: ,p_normal_hours in number default hr_api.g_number

178: ,p_start_date in date default hr_api.g_date
179: ,p_end_date in date default hr_api.g_date
180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number
186: ,p_period_days in number default hr_api.g_number

Line 183: ,p_frequency in varchar2 default hr_api.g_varchar2

179: ,p_end_date in date default hr_api.g_date
180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number
186: ,p_period_days in number default hr_api.g_number
187: ,p_comments in varchar2 default hr_api.g_varchar2

Line 184: ,p_period_years in number default hr_api.g_number

180: ,p_previous_employer_id in number default hr_api.g_number
181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number
186: ,p_period_days in number default hr_api.g_number
187: ,p_comments in varchar2 default hr_api.g_varchar2
188: ,p_validation_status in varchar2 default hr_api.g_varchar2) Is

Line 185: ,p_period_months in number default hr_api.g_number

181: ,p_assignment_category in varchar2 default hr_api.g_varchar2
182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number
186: ,p_period_days in number default hr_api.g_number
187: ,p_comments in varchar2 default hr_api.g_varchar2
188: ,p_validation_status in varchar2 default hr_api.g_varchar2) Is
189:

Line 186: ,p_period_days in number default hr_api.g_number

182: ,p_normal_hours in number default hr_api.g_number
183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number
186: ,p_period_days in number default hr_api.g_number
187: ,p_comments in varchar2 default hr_api.g_varchar2
188: ,p_validation_status in varchar2 default hr_api.g_varchar2) Is
189:
190: l_proc varchar2(72) := g_package||'Update_Validation_Period';

Line 187: ,p_comments in varchar2 default hr_api.g_varchar2

183: ,p_frequency in varchar2 default hr_api.g_varchar2
184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number
186: ,p_period_days in number default hr_api.g_number
187: ,p_comments in varchar2 default hr_api.g_varchar2
188: ,p_validation_status in varchar2 default hr_api.g_varchar2) Is
189:
190: l_proc varchar2(72) := g_package||'Update_Validation_Period';
191: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

Line 188: ,p_validation_status in varchar2 default hr_api.g_varchar2) Is

184: ,p_period_years in number default hr_api.g_number
185: ,p_period_months in number default hr_api.g_number
186: ,p_period_days in number default hr_api.g_number
187: ,p_comments in varchar2 default hr_api.g_varchar2
188: ,p_validation_status in varchar2 default hr_api.g_varchar2) Is
189:
190: l_proc varchar2(72) := g_package||'Update_Validation_Period';
191: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
192: L_Effective_Date Date;

Line 228: when hr_api.cannot_find_prog_unit then

224: ,p_validation_status => p_validation_status
225: );
226:
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'Update_Validation_Period'
231: ,p_hook_type => 'BP'
232: );

Line 229: hr_api.cannot_find_prog_unit_error

225: );
226:
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'Update_Validation_Period'
231: ,p_hook_type => 'BP'
232: );
233: end;

Line 276: when hr_api.cannot_find_prog_unit then

272: ,p_comments => p_comments
273: ,p_validation_status => p_validation_status);
274:
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'Update_Validation_Period'
279: ,p_hook_type => 'AP'
280: );

Line 277: hr_api.cannot_find_prog_unit_error

273: ,p_validation_status => p_validation_status);
274:
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'Update_Validation_Period'
279: ,p_hook_type => 'AP'
280: );
281: end;

Line 286: -- raise hr_api.validate_enabled;

282: --
283: -- When in validation only mode raise the Validate_Enabled exception
284: --
285: -- if p_validate then
286: -- raise hr_api.validate_enabled;
287: -- end if;
288: --
289: -- Set all output arguments
290: --

Line 297: when hr_api.validate_enabled then

293:
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 70);
296: exception
297: when hr_api.validate_enabled then
298: --
299: -- As the Validate_Enabled exception has been raised
300: -- we must rollback to the savepoint
301: --

Line 348: when hr_api.cannot_find_prog_unit then

344: (p_validation_period_id => p_validation_period_id
345: ,p_object_version_number => p_object_version_number
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'delete_Validation_period'
351: ,p_hook_type => 'BP');
352: end;

Line 349: hr_api.cannot_find_prog_unit_error

345: ,p_object_version_number => p_object_version_number
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'delete_Validation_period'
351: ,p_hook_type => 'BP');
352: end;
353: --

Line 373: when hr_api.cannot_find_prog_unit then

369: ,p_object_version_number => p_object_version_number
370: );
371:
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'delete_Validation_period'
376: ,p_hook_type => 'AP');
377: end;

Line 374: hr_api.cannot_find_prog_unit_error

370: );
371:
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'delete_Validation_period'
376: ,p_hook_type => 'AP');
377: end;
378: --

Line 382: -- raise hr_api.validate_enabled;

378: --
379: -- When in validation only mode raise the Validate_Enabled exception
380: --
381: -- if p_validate then
382: -- raise hr_api.validate_enabled;
383: -- end if;
384: --
385: -- Set all output arguments
386: --

Line 389: when hr_api.validate_enabled then

385: -- Set all output arguments
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 70);
388: exception
389: when hr_api.validate_enabled then
390: --
391: -- As the Validate_Enabled exception has been raised
392: -- we must rollback to the savepoint
393: --