eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_EFF_REPORT_APPROVALS_API dependencies on HR_API

Line 7: p_legislation_code varchar(50):=hr_api.userenv_lang;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' psp_eff_report_approvals_api.';
7: p_legislation_code varchar(50):=hr_api.userenv_lang;
8:
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< insert_eff_report_approvals >--------------------|

Line 149: when hr_api.cannot_find_prog_unit then

145: ,p_eff_information14 => p_eff_information14
146: ,p_eff_information15 => p_eff_information15
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'insert_eff_report_approvals'
152: ,p_hook_type => 'BP'
153: );

Line 150: hr_api.cannot_find_prog_unit_error

146: ,p_eff_information15 => p_eff_information15
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'insert_eff_report_approvals'
152: ,p_hook_type => 'BP'
153: );
154: end;

Line 278: when hr_api.cannot_find_prog_unit then

274: ,p_eff_information15 => p_eff_information15
275: ,p_return_status => l_return_status
276: );
277: exception
278: when hr_api.cannot_find_prog_unit then
279: hr_api.cannot_find_prog_unit_error
280: (p_module_name => 'insert_eff_report_approvals'
281: ,p_hook_type => 'AP'
282: );

Line 279: hr_api.cannot_find_prog_unit_error

275: ,p_return_status => l_return_status
276: );
277: exception
278: when hr_api.cannot_find_prog_unit then
279: hr_api.cannot_find_prog_unit_error
280: (p_module_name => 'insert_eff_report_approvals'
281: ,p_hook_type => 'AP'
282: );
283: end;

Line 288: raise hr_api.validate_enabled;

284: --
285: -- When in validation only mode raise the Validate_Enabled exception
286: --
287: if p_validate then
288: raise hr_api.validate_enabled;
289: end if;
290: --
291: -- Set all IN OUT and OUT parameters with out values
292: --

Line 299: when hr_api.validate_enabled then

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

Line 345: ,p_effort_report_detail_id in number default hr_api.g_number

341: --
342: procedure update_eff_report_approvals
343: (p_validate in boolean default false
344: ,p_effort_report_approval_id in number
345: ,p_effort_report_detail_id in number default hr_api.g_number
346: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
347: ,p_wf_orig_system_id in number default hr_api.g_number
348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number

Line 346: ,p_wf_role_name in varchar2 default hr_api.g_varchar2

342: procedure update_eff_report_approvals
343: (p_validate in boolean default false
344: ,p_effort_report_approval_id in number
345: ,p_effort_report_detail_id in number default hr_api.g_number
346: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
347: ,p_wf_orig_system_id in number default hr_api.g_number
348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2

Line 347: ,p_wf_orig_system_id in number default hr_api.g_number

343: (p_validate in boolean default false
344: ,p_effort_report_approval_id in number
345: ,p_effort_report_detail_id in number default hr_api.g_number
346: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
347: ,p_wf_orig_system_id in number default hr_api.g_number
348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date

Line 348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2

344: ,p_effort_report_approval_id in number
345: ,p_effort_report_detail_id in number default hr_api.g_number
346: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
347: ,p_wf_orig_system_id in number default hr_api.g_number
348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number

Line 349: ,p_approver_order_num in number default hr_api.g_number

345: ,p_effort_report_detail_id in number default hr_api.g_number
346: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
347: ,p_wf_orig_system_id in number default hr_api.g_number
348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number

Line 350: ,p_approval_status in varchar2 default hr_api.g_varchar2

346: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
347: ,p_wf_orig_system_id in number default hr_api.g_number
348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2

Line 351: ,p_response_date in date default hr_api.g_date

347: ,p_wf_orig_system_id in number default hr_api.g_number
348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2

Line 352: ,p_actual_cost_share in number default hr_api.g_number

348: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2

Line 353: ,p_overwritten_effort_percent in number default hr_api.g_number

349: ,p_approver_order_num in number default hr_api.g_number
350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2

Line 354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2

350: ,p_approval_status in varchar2 default hr_api.g_varchar2
351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2

Line 355: ,p_comments in varchar2 default hr_api.g_varchar2

351: ,p_response_date in date default hr_api.g_date
352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2

Line 356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2

352: ,p_actual_cost_share in number default hr_api.g_number
353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2

Line 357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2

353: ,p_overwritten_effort_percent in number default hr_api.g_number
354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2

Line 358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2

354: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2

Line 359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2

355: ,p_comments in varchar2 default hr_api.g_varchar2
356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2

Line 360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2

356: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2

Line 361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2

357: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2

Line 362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2

358: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2

Line 363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2

359: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2

Line 364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2

360: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2

Line 365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2

361: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2

Line 366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2

362: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2

Line 367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2

363: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2

Line 368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2

364: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2

Line 369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2

365: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2

Line 370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2

366: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2

Line 371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2

367: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2

Line 372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2

368: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2

Line 373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2

369: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2

Line 374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2

370: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2

Line 375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2

371: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2

Line 376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2

372: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2

Line 377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2

373: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2

Line 378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2

374: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2

Line 379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2

375: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2

Line 380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2

376: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2

Line 381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2

377: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2

Line 382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2

378: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2

Line 383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2

379: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2

Line 384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2

380: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2

Line 385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2

381: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2

Line 386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2

382: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2

Line 387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2

383: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2

Line 388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2

384: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
392: ,p_eff_information14 in varchar2 default hr_api.g_varchar2

Line 389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2

385: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
392: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
393: ,p_eff_information15 in varchar2 default hr_api.g_varchar2

Line 390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2

386: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
392: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
393: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
394: ,p_object_version_number in out nocopy number

Line 391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2

387: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
392: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
393: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
394: ,p_object_version_number in out nocopy number
395: ,p_return_status out nocopy boolean

Line 392: ,p_eff_information14 in varchar2 default hr_api.g_varchar2

388: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
392: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
393: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
394: ,p_object_version_number in out nocopy number
395: ,p_return_status out nocopy boolean
396: ) IS

Line 393: ,p_eff_information15 in varchar2 default hr_api.g_varchar2

389: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
390: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
391: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
392: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
393: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
394: ,p_object_version_number in out nocopy number
395: ,p_return_status out nocopy boolean
396: ) IS
397: --

Line 499: g_pera_information1 := hr_api.g_varchar2;

495:
496: --
497: -- Clear Global variables
498: --
499: g_pera_information1 := hr_api.g_varchar2;
500: g_pera_information2 := hr_api.g_varchar2;
501: g_pera_information3 := hr_api.g_varchar2;
502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;

Line 500: g_pera_information2 := hr_api.g_varchar2;

496: --
497: -- Clear Global variables
498: --
499: g_pera_information1 := hr_api.g_varchar2;
500: g_pera_information2 := hr_api.g_varchar2;
501: g_pera_information3 := hr_api.g_varchar2;
502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;

Line 501: g_pera_information3 := hr_api.g_varchar2;

497: -- Clear Global variables
498: --
499: g_pera_information1 := hr_api.g_varchar2;
500: g_pera_information2 := hr_api.g_varchar2;
501: g_pera_information3 := hr_api.g_varchar2;
502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;

Line 502: g_pera_information4 := hr_api.g_varchar2;

498: --
499: g_pera_information1 := hr_api.g_varchar2;
500: g_pera_information2 := hr_api.g_varchar2;
501: g_pera_information3 := hr_api.g_varchar2;
502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;

Line 503: g_pera_information5 := hr_api.g_varchar2;

499: g_pera_information1 := hr_api.g_varchar2;
500: g_pera_information2 := hr_api.g_varchar2;
501: g_pera_information3 := hr_api.g_varchar2;
502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;

Line 504: g_pera_information6 := hr_api.g_varchar2;

500: g_pera_information2 := hr_api.g_varchar2;
501: g_pera_information3 := hr_api.g_varchar2;
502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;

Line 505: g_pera_information7 := hr_api.g_varchar2;

501: g_pera_information3 := hr_api.g_varchar2;
502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;

Line 506: g_pera_information8 := hr_api.g_varchar2;

502: g_pera_information4 := hr_api.g_varchar2;
503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;

Line 507: g_pera_information9 := hr_api.g_varchar2;

503: g_pera_information5 := hr_api.g_varchar2;
504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;

Line 508: g_pera_information10 := hr_api.g_varchar2;

504: g_pera_information6 := hr_api.g_varchar2;
505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;

Line 509: g_pera_information11 := hr_api.g_varchar2;

505: g_pera_information7 := hr_api.g_varchar2;
506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;

Line 510: g_pera_information12 := hr_api.g_varchar2;

506: g_pera_information8 := hr_api.g_varchar2;
507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;

Line 511: g_pera_information13 := hr_api.g_varchar2;

507: g_pera_information9 := hr_api.g_varchar2;
508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;

Line 512: g_pera_information14 := hr_api.g_varchar2;

508: g_pera_information10 := hr_api.g_varchar2;
509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;
516: g_pera_information18 := hr_api.g_varchar2;

Line 513: g_pera_information15 := hr_api.g_varchar2;

509: g_pera_information11 := hr_api.g_varchar2;
510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;
516: g_pera_information18 := hr_api.g_varchar2;
517: g_pera_information19 := hr_api.g_varchar2;

Line 514: g_pera_information16 := hr_api.g_varchar2;

510: g_pera_information12 := hr_api.g_varchar2;
511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;
516: g_pera_information18 := hr_api.g_varchar2;
517: g_pera_information19 := hr_api.g_varchar2;
518: g_pera_information20 := hr_api.g_varchar2;

Line 515: g_pera_information17 := hr_api.g_varchar2;

511: g_pera_information13 := hr_api.g_varchar2;
512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;
516: g_pera_information18 := hr_api.g_varchar2;
517: g_pera_information19 := hr_api.g_varchar2;
518: g_pera_information20 := hr_api.g_varchar2;
519:

Line 516: g_pera_information18 := hr_api.g_varchar2;

512: g_pera_information14 := hr_api.g_varchar2;
513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;
516: g_pera_information18 := hr_api.g_varchar2;
517: g_pera_information19 := hr_api.g_varchar2;
518: g_pera_information20 := hr_api.g_varchar2;
519:
520: g_eff_information1 := hr_api.g_varchar2;

Line 517: g_pera_information19 := hr_api.g_varchar2;

513: g_pera_information15 := hr_api.g_varchar2;
514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;
516: g_pera_information18 := hr_api.g_varchar2;
517: g_pera_information19 := hr_api.g_varchar2;
518: g_pera_information20 := hr_api.g_varchar2;
519:
520: g_eff_information1 := hr_api.g_varchar2;
521: g_eff_information2 := hr_api.g_varchar2;

Line 518: g_pera_information20 := hr_api.g_varchar2;

514: g_pera_information16 := hr_api.g_varchar2;
515: g_pera_information17 := hr_api.g_varchar2;
516: g_pera_information18 := hr_api.g_varchar2;
517: g_pera_information19 := hr_api.g_varchar2;
518: g_pera_information20 := hr_api.g_varchar2;
519:
520: g_eff_information1 := hr_api.g_varchar2;
521: g_eff_information2 := hr_api.g_varchar2;
522: g_eff_information3 := hr_api.g_varchar2;

Line 520: g_eff_information1 := hr_api.g_varchar2;

516: g_pera_information18 := hr_api.g_varchar2;
517: g_pera_information19 := hr_api.g_varchar2;
518: g_pera_information20 := hr_api.g_varchar2;
519:
520: g_eff_information1 := hr_api.g_varchar2;
521: g_eff_information2 := hr_api.g_varchar2;
522: g_eff_information3 := hr_api.g_varchar2;
523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;

Line 521: g_eff_information2 := hr_api.g_varchar2;

517: g_pera_information19 := hr_api.g_varchar2;
518: g_pera_information20 := hr_api.g_varchar2;
519:
520: g_eff_information1 := hr_api.g_varchar2;
521: g_eff_information2 := hr_api.g_varchar2;
522: g_eff_information3 := hr_api.g_varchar2;
523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;

Line 522: g_eff_information3 := hr_api.g_varchar2;

518: g_pera_information20 := hr_api.g_varchar2;
519:
520: g_eff_information1 := hr_api.g_varchar2;
521: g_eff_information2 := hr_api.g_varchar2;
522: g_eff_information3 := hr_api.g_varchar2;
523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;

Line 523: g_eff_information4 := hr_api.g_varchar2;

519:
520: g_eff_information1 := hr_api.g_varchar2;
521: g_eff_information2 := hr_api.g_varchar2;
522: g_eff_information3 := hr_api.g_varchar2;
523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;

Line 524: g_eff_information5 := hr_api.g_varchar2;

520: g_eff_information1 := hr_api.g_varchar2;
521: g_eff_information2 := hr_api.g_varchar2;
522: g_eff_information3 := hr_api.g_varchar2;
523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;

Line 525: g_eff_information6 := hr_api.g_varchar2;

521: g_eff_information2 := hr_api.g_varchar2;
522: g_eff_information3 := hr_api.g_varchar2;
523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;

Line 526: g_eff_information7 := hr_api.g_varchar2;

522: g_eff_information3 := hr_api.g_varchar2;
523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;

Line 527: g_eff_information8 := hr_api.g_varchar2;

523: g_eff_information4 := hr_api.g_varchar2;
524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;

Line 528: g_eff_information9 := hr_api.g_varchar2;

524: g_eff_information5 := hr_api.g_varchar2;
525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;
532: g_eff_information13 := hr_api.g_varchar2;

Line 529: g_eff_information10 := hr_api.g_varchar2;

525: g_eff_information6 := hr_api.g_varchar2;
526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;
532: g_eff_information13 := hr_api.g_varchar2;
533: g_eff_information14 := hr_api.g_varchar2;

Line 530: g_eff_information11 := hr_api.g_varchar2;

526: g_eff_information7 := hr_api.g_varchar2;
527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;
532: g_eff_information13 := hr_api.g_varchar2;
533: g_eff_information14 := hr_api.g_varchar2;
534: g_eff_information15 := hr_api.g_varchar2;

Line 531: g_eff_information12 := hr_api.g_varchar2;

527: g_eff_information8 := hr_api.g_varchar2;
528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;
532: g_eff_information13 := hr_api.g_varchar2;
533: g_eff_information14 := hr_api.g_varchar2;
534: g_eff_information15 := hr_api.g_varchar2;
535:

Line 532: g_eff_information13 := hr_api.g_varchar2;

528: g_eff_information9 := hr_api.g_varchar2;
529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;
532: g_eff_information13 := hr_api.g_varchar2;
533: g_eff_information14 := hr_api.g_varchar2;
534: g_eff_information15 := hr_api.g_varchar2;
535:
536: --

Line 533: g_eff_information14 := hr_api.g_varchar2;

529: g_eff_information10 := hr_api.g_varchar2;
530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;
532: g_eff_information13 := hr_api.g_varchar2;
533: g_eff_information14 := hr_api.g_varchar2;
534: g_eff_information15 := hr_api.g_varchar2;
535:
536: --
537: -- Call Before Process User Hook

Line 534: g_eff_information15 := hr_api.g_varchar2;

530: g_eff_information11 := hr_api.g_varchar2;
531: g_eff_information12 := hr_api.g_varchar2;
532: g_eff_information13 := hr_api.g_varchar2;
533: g_eff_information14 := hr_api.g_varchar2;
534: g_eff_information15 := hr_api.g_varchar2;
535:
536: --
537: -- Call Before Process User Hook
538: --

Line 594: when hr_api.cannot_find_prog_unit then

590: ,p_eff_information14 => l_eff_information14
591: ,p_eff_information15 => l_eff_information15
592: );
593: exception
594: when hr_api.cannot_find_prog_unit then
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'update_eff_report_approvals'
597: ,p_hook_type => 'BP'
598: );

Line 595: hr_api.cannot_find_prog_unit_error

591: ,p_eff_information15 => l_eff_information15
592: );
593: exception
594: when hr_api.cannot_find_prog_unit then
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'update_eff_report_approvals'
597: ,p_hook_type => 'BP'
598: );
599: end;

Line 605: IF (g_pera_information1 <> hr_api.g_varchar2) THEN

601: -- Validation in addition to Row Handlers
602: --
603:
604: -- If user has updated global pera_informations from before hook
605: IF (g_pera_information1 <> hr_api.g_varchar2) THEN
606: l_pera_information1 := g_pera_information1;
607: END IF;
608: IF (g_pera_information2 <> hr_api.g_varchar2) THEN
609: l_pera_information2 := g_pera_information2;

Line 608: IF (g_pera_information2 <> hr_api.g_varchar2) THEN

604: -- If user has updated global pera_informations from before hook
605: IF (g_pera_information1 <> hr_api.g_varchar2) THEN
606: l_pera_information1 := g_pera_information1;
607: END IF;
608: IF (g_pera_information2 <> hr_api.g_varchar2) THEN
609: l_pera_information2 := g_pera_information2;
610: END IF;
611: IF (g_pera_information3 <> hr_api.g_varchar2) THEN
612: l_pera_information3 := g_pera_information3;

Line 611: IF (g_pera_information3 <> hr_api.g_varchar2) THEN

607: END IF;
608: IF (g_pera_information2 <> hr_api.g_varchar2) THEN
609: l_pera_information2 := g_pera_information2;
610: END IF;
611: IF (g_pera_information3 <> hr_api.g_varchar2) THEN
612: l_pera_information3 := g_pera_information3;
613: END IF;
614: IF (g_pera_information4 <> hr_api.g_varchar2) THEN
615: l_pera_information4 := g_pera_information4;

Line 614: IF (g_pera_information4 <> hr_api.g_varchar2) THEN

610: END IF;
611: IF (g_pera_information3 <> hr_api.g_varchar2) THEN
612: l_pera_information3 := g_pera_information3;
613: END IF;
614: IF (g_pera_information4 <> hr_api.g_varchar2) THEN
615: l_pera_information4 := g_pera_information4;
616: END IF;
617: IF (g_pera_information5 <> hr_api.g_varchar2) THEN
618: l_pera_information5 := g_pera_information5;

Line 617: IF (g_pera_information5 <> hr_api.g_varchar2) THEN

613: END IF;
614: IF (g_pera_information4 <> hr_api.g_varchar2) THEN
615: l_pera_information4 := g_pera_information4;
616: END IF;
617: IF (g_pera_information5 <> hr_api.g_varchar2) THEN
618: l_pera_information5 := g_pera_information5;
619: END IF;
620: IF (g_pera_information6 <> hr_api.g_varchar2) THEN
621: l_pera_information6 := g_pera_information6;

Line 620: IF (g_pera_information6 <> hr_api.g_varchar2) THEN

616: END IF;
617: IF (g_pera_information5 <> hr_api.g_varchar2) THEN
618: l_pera_information5 := g_pera_information5;
619: END IF;
620: IF (g_pera_information6 <> hr_api.g_varchar2) THEN
621: l_pera_information6 := g_pera_information6;
622: END IF;
623: IF (g_pera_information7 <> hr_api.g_varchar2) THEN
624: l_pera_information7 := g_pera_information7;

Line 623: IF (g_pera_information7 <> hr_api.g_varchar2) THEN

619: END IF;
620: IF (g_pera_information6 <> hr_api.g_varchar2) THEN
621: l_pera_information6 := g_pera_information6;
622: END IF;
623: IF (g_pera_information7 <> hr_api.g_varchar2) THEN
624: l_pera_information7 := g_pera_information7;
625: END IF;
626: IF (g_pera_information8 <> hr_api.g_varchar2) THEN
627: l_pera_information8 := g_pera_information8;

Line 626: IF (g_pera_information8 <> hr_api.g_varchar2) THEN

622: END IF;
623: IF (g_pera_information7 <> hr_api.g_varchar2) THEN
624: l_pera_information7 := g_pera_information7;
625: END IF;
626: IF (g_pera_information8 <> hr_api.g_varchar2) THEN
627: l_pera_information8 := g_pera_information8;
628: END IF;
629: IF (g_pera_information9 <> hr_api.g_varchar2) THEN
630: l_pera_information9 := g_pera_information9;

Line 629: IF (g_pera_information9 <> hr_api.g_varchar2) THEN

625: END IF;
626: IF (g_pera_information8 <> hr_api.g_varchar2) THEN
627: l_pera_information8 := g_pera_information8;
628: END IF;
629: IF (g_pera_information9 <> hr_api.g_varchar2) THEN
630: l_pera_information9 := g_pera_information9;
631: END IF;
632: IF (g_pera_information10 <> hr_api.g_varchar2) THEN
633: l_pera_information10 := g_pera_information10;

Line 632: IF (g_pera_information10 <> hr_api.g_varchar2) THEN

628: END IF;
629: IF (g_pera_information9 <> hr_api.g_varchar2) THEN
630: l_pera_information9 := g_pera_information9;
631: END IF;
632: IF (g_pera_information10 <> hr_api.g_varchar2) THEN
633: l_pera_information10 := g_pera_information10;
634: END IF;
635: IF (g_pera_information11 <> hr_api.g_varchar2) THEN
636: l_pera_information11 := g_pera_information11;

Line 635: IF (g_pera_information11 <> hr_api.g_varchar2) THEN

631: END IF;
632: IF (g_pera_information10 <> hr_api.g_varchar2) THEN
633: l_pera_information10 := g_pera_information10;
634: END IF;
635: IF (g_pera_information11 <> hr_api.g_varchar2) THEN
636: l_pera_information11 := g_pera_information11;
637: END IF;
638: IF (g_pera_information12 <> hr_api.g_varchar2) THEN
639: l_pera_information12 := g_pera_information12;

Line 638: IF (g_pera_information12 <> hr_api.g_varchar2) THEN

634: END IF;
635: IF (g_pera_information11 <> hr_api.g_varchar2) THEN
636: l_pera_information11 := g_pera_information11;
637: END IF;
638: IF (g_pera_information12 <> hr_api.g_varchar2) THEN
639: l_pera_information12 := g_pera_information12;
640: END IF;
641: IF (g_pera_information13 <> hr_api.g_varchar2) THEN
642: l_pera_information13 := g_pera_information13;

Line 641: IF (g_pera_information13 <> hr_api.g_varchar2) THEN

637: END IF;
638: IF (g_pera_information12 <> hr_api.g_varchar2) THEN
639: l_pera_information12 := g_pera_information12;
640: END IF;
641: IF (g_pera_information13 <> hr_api.g_varchar2) THEN
642: l_pera_information13 := g_pera_information13;
643: END IF;
644: IF (g_pera_information14 <> hr_api.g_varchar2) THEN
645: l_pera_information14 := g_pera_information14;

Line 644: IF (g_pera_information14 <> hr_api.g_varchar2) THEN

640: END IF;
641: IF (g_pera_information13 <> hr_api.g_varchar2) THEN
642: l_pera_information13 := g_pera_information13;
643: END IF;
644: IF (g_pera_information14 <> hr_api.g_varchar2) THEN
645: l_pera_information14 := g_pera_information14;
646: END IF;
647: IF (g_pera_information15 <> hr_api.g_varchar2) THEN
648: l_pera_information15 := g_pera_information15;

Line 647: IF (g_pera_information15 <> hr_api.g_varchar2) THEN

643: END IF;
644: IF (g_pera_information14 <> hr_api.g_varchar2) THEN
645: l_pera_information14 := g_pera_information14;
646: END IF;
647: IF (g_pera_information15 <> hr_api.g_varchar2) THEN
648: l_pera_information15 := g_pera_information15;
649: END IF;
650: IF (g_pera_information16 <> hr_api.g_varchar2) THEN
651: l_pera_information16 := g_pera_information16;

Line 650: IF (g_pera_information16 <> hr_api.g_varchar2) THEN

646: END IF;
647: IF (g_pera_information15 <> hr_api.g_varchar2) THEN
648: l_pera_information15 := g_pera_information15;
649: END IF;
650: IF (g_pera_information16 <> hr_api.g_varchar2) THEN
651: l_pera_information16 := g_pera_information16;
652: END IF;
653: IF (g_pera_information17 <> hr_api.g_varchar2) THEN
654: l_pera_information17 := g_pera_information17;

Line 653: IF (g_pera_information17 <> hr_api.g_varchar2) THEN

649: END IF;
650: IF (g_pera_information16 <> hr_api.g_varchar2) THEN
651: l_pera_information16 := g_pera_information16;
652: END IF;
653: IF (g_pera_information17 <> hr_api.g_varchar2) THEN
654: l_pera_information17 := g_pera_information17;
655: END IF;
656: IF (g_pera_information18 <> hr_api.g_varchar2) THEN
657: l_pera_information18 := g_pera_information18;

Line 656: IF (g_pera_information18 <> hr_api.g_varchar2) THEN

652: END IF;
653: IF (g_pera_information17 <> hr_api.g_varchar2) THEN
654: l_pera_information17 := g_pera_information17;
655: END IF;
656: IF (g_pera_information18 <> hr_api.g_varchar2) THEN
657: l_pera_information18 := g_pera_information18;
658: END IF;
659: IF (g_pera_information19 <> hr_api.g_varchar2) THEN
660: l_pera_information19 := g_pera_information19;

Line 659: IF (g_pera_information19 <> hr_api.g_varchar2) THEN

655: END IF;
656: IF (g_pera_information18 <> hr_api.g_varchar2) THEN
657: l_pera_information18 := g_pera_information18;
658: END IF;
659: IF (g_pera_information19 <> hr_api.g_varchar2) THEN
660: l_pera_information19 := g_pera_information19;
661: END IF;
662: IF (g_pera_information20 <> hr_api.g_varchar2) THEN
663: l_pera_information20 := g_pera_information20;

Line 662: IF (g_pera_information20 <> hr_api.g_varchar2) THEN

658: END IF;
659: IF (g_pera_information19 <> hr_api.g_varchar2) THEN
660: l_pera_information19 := g_pera_information19;
661: END IF;
662: IF (g_pera_information20 <> hr_api.g_varchar2) THEN
663: l_pera_information20 := g_pera_information20;
664: END IF;
665:
666:

Line 667: IF (g_eff_information1 <> hr_api.g_varchar2) THEN

663: l_pera_information20 := g_pera_information20;
664: END IF;
665:
666:
667: IF (g_eff_information1 <> hr_api.g_varchar2) THEN
668: l_eff_information1 := g_eff_information1;
669: END IF;
670: IF (g_eff_information2 <> hr_api.g_varchar2) THEN
671: l_eff_information2 := g_eff_information2;

Line 670: IF (g_eff_information2 <> hr_api.g_varchar2) THEN

666:
667: IF (g_eff_information1 <> hr_api.g_varchar2) THEN
668: l_eff_information1 := g_eff_information1;
669: END IF;
670: IF (g_eff_information2 <> hr_api.g_varchar2) THEN
671: l_eff_information2 := g_eff_information2;
672: END IF;
673: IF (g_eff_information3 <> hr_api.g_varchar2) THEN
674: l_eff_information3 := g_eff_information3;

Line 673: IF (g_eff_information3 <> hr_api.g_varchar2) THEN

669: END IF;
670: IF (g_eff_information2 <> hr_api.g_varchar2) THEN
671: l_eff_information2 := g_eff_information2;
672: END IF;
673: IF (g_eff_information3 <> hr_api.g_varchar2) THEN
674: l_eff_information3 := g_eff_information3;
675: END IF;
676: IF (g_eff_information4 <> hr_api.g_varchar2) THEN
677: l_eff_information4 := g_eff_information4;

Line 676: IF (g_eff_information4 <> hr_api.g_varchar2) THEN

672: END IF;
673: IF (g_eff_information3 <> hr_api.g_varchar2) THEN
674: l_eff_information3 := g_eff_information3;
675: END IF;
676: IF (g_eff_information4 <> hr_api.g_varchar2) THEN
677: l_eff_information4 := g_eff_information4;
678: END IF;
679: IF (g_eff_information5 <> hr_api.g_varchar2) THEN
680: l_eff_information5 := g_eff_information5;

Line 679: IF (g_eff_information5 <> hr_api.g_varchar2) THEN

675: END IF;
676: IF (g_eff_information4 <> hr_api.g_varchar2) THEN
677: l_eff_information4 := g_eff_information4;
678: END IF;
679: IF (g_eff_information5 <> hr_api.g_varchar2) THEN
680: l_eff_information5 := g_eff_information5;
681: END IF;
682: IF (g_eff_information6 <> hr_api.g_varchar2) THEN
683: l_eff_information6 := g_eff_information6;

Line 682: IF (g_eff_information6 <> hr_api.g_varchar2) THEN

678: END IF;
679: IF (g_eff_information5 <> hr_api.g_varchar2) THEN
680: l_eff_information5 := g_eff_information5;
681: END IF;
682: IF (g_eff_information6 <> hr_api.g_varchar2) THEN
683: l_eff_information6 := g_eff_information6;
684: END IF;
685: IF (g_eff_information7 <> hr_api.g_varchar2) THEN
686: l_eff_information7 := g_eff_information7;

Line 685: IF (g_eff_information7 <> hr_api.g_varchar2) THEN

681: END IF;
682: IF (g_eff_information6 <> hr_api.g_varchar2) THEN
683: l_eff_information6 := g_eff_information6;
684: END IF;
685: IF (g_eff_information7 <> hr_api.g_varchar2) THEN
686: l_eff_information7 := g_eff_information7;
687: END IF;
688: IF (g_eff_information8 <> hr_api.g_varchar2) THEN
689: l_eff_information8 := g_eff_information8;

Line 688: IF (g_eff_information8 <> hr_api.g_varchar2) THEN

684: END IF;
685: IF (g_eff_information7 <> hr_api.g_varchar2) THEN
686: l_eff_information7 := g_eff_information7;
687: END IF;
688: IF (g_eff_information8 <> hr_api.g_varchar2) THEN
689: l_eff_information8 := g_eff_information8;
690: END IF;
691: IF (g_eff_information9 <> hr_api.g_varchar2) THEN
692: l_eff_information9 := g_eff_information9;

Line 691: IF (g_eff_information9 <> hr_api.g_varchar2) THEN

687: END IF;
688: IF (g_eff_information8 <> hr_api.g_varchar2) THEN
689: l_eff_information8 := g_eff_information8;
690: END IF;
691: IF (g_eff_information9 <> hr_api.g_varchar2) THEN
692: l_eff_information9 := g_eff_information9;
693: END IF;
694: IF (g_eff_information10 <> hr_api.g_varchar2) THEN
695: l_eff_information10 := g_eff_information10;

Line 694: IF (g_eff_information10 <> hr_api.g_varchar2) THEN

690: END IF;
691: IF (g_eff_information9 <> hr_api.g_varchar2) THEN
692: l_eff_information9 := g_eff_information9;
693: END IF;
694: IF (g_eff_information10 <> hr_api.g_varchar2) THEN
695: l_eff_information10 := g_eff_information10;
696: END IF;
697: IF (g_eff_information11 <> hr_api.g_varchar2) THEN
698: l_eff_information11 := g_eff_information11;

Line 697: IF (g_eff_information11 <> hr_api.g_varchar2) THEN

693: END IF;
694: IF (g_eff_information10 <> hr_api.g_varchar2) THEN
695: l_eff_information10 := g_eff_information10;
696: END IF;
697: IF (g_eff_information11 <> hr_api.g_varchar2) THEN
698: l_eff_information11 := g_eff_information11;
699: END IF;
700: IF (g_eff_information12 <> hr_api.g_varchar2) THEN
701: l_eff_information12 := g_eff_information12;

Line 700: IF (g_eff_information12 <> hr_api.g_varchar2) THEN

696: END IF;
697: IF (g_eff_information11 <> hr_api.g_varchar2) THEN
698: l_eff_information11 := g_eff_information11;
699: END IF;
700: IF (g_eff_information12 <> hr_api.g_varchar2) THEN
701: l_eff_information12 := g_eff_information12;
702: END IF;
703: IF (g_eff_information13 <> hr_api.g_varchar2) THEN
704: l_eff_information13 := g_eff_information13;

Line 703: IF (g_eff_information13 <> hr_api.g_varchar2) THEN

699: END IF;
700: IF (g_eff_information12 <> hr_api.g_varchar2) THEN
701: l_eff_information12 := g_eff_information12;
702: END IF;
703: IF (g_eff_information13 <> hr_api.g_varchar2) THEN
704: l_eff_information13 := g_eff_information13;
705: END IF;
706: IF (g_eff_information14 <> hr_api.g_varchar2) THEN
707: l_eff_information14 := g_eff_information14;

Line 706: IF (g_eff_information14 <> hr_api.g_varchar2) THEN

702: END IF;
703: IF (g_eff_information13 <> hr_api.g_varchar2) THEN
704: l_eff_information13 := g_eff_information13;
705: END IF;
706: IF (g_eff_information14 <> hr_api.g_varchar2) THEN
707: l_eff_information14 := g_eff_information14;
708: END IF;
709: IF (g_eff_information15 <> hr_api.g_varchar2) THEN
710: l_eff_information15 := g_eff_information15;

Line 709: IF (g_eff_information15 <> hr_api.g_varchar2) THEN

705: END IF;
706: IF (g_eff_information14 <> hr_api.g_varchar2) THEN
707: l_eff_information14 := g_eff_information14;
708: END IF;
709: IF (g_eff_information15 <> hr_api.g_varchar2) THEN
710: l_eff_information15 := g_eff_information15;
711: END IF;
712: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
713: -- Process Logic - Call the row-handler upd procedure

Line 830: when hr_api.cannot_find_prog_unit then

826: ,p_eff_information15 => l_eff_information15
827: ,p_return_status => l_return_status
828: );
829: exception
830: when hr_api.cannot_find_prog_unit then
831: hr_api.cannot_find_prog_unit_error
832: (p_module_name => 'update_eff_report_approvals'
833: ,p_hook_type => 'AP'
834: );

Line 831: hr_api.cannot_find_prog_unit_error

827: ,p_return_status => l_return_status
828: );
829: exception
830: when hr_api.cannot_find_prog_unit then
831: hr_api.cannot_find_prog_unit_error
832: (p_module_name => 'update_eff_report_approvals'
833: ,p_hook_type => 'AP'
834: );
835: end;

Line 840: raise hr_api.validate_enabled;

836: --
837: -- When in validation only mode raise the Validate_Enabled exception
838: --
839: if p_validate then
840: raise hr_api.validate_enabled;
841: end if;
842: --
843: -- Set all IN OUT and OUT parameters with out values
844: --

Line 849: when hr_api.validate_enabled then

845: p_object_version_number := l_object_version_number;
846: p_return_status := l_return_status;
847: hr_utility.set_location(' Leaving:'||l_proc, 70);
848: exception
849: when hr_api.validate_enabled then
850: --
851: -- As the Validate_Enabled exception has been raised
852: -- we must rollback to the savepoint
853: --

Line 919: when hr_api.cannot_find_prog_unit then

915: ( p_effort_report_approval_id => p_effort_report_approval_id
916: , p_object_version_number => l_object_version_number
917: );
918: exception
919: when hr_api.cannot_find_prog_unit then
920: hr_api.cannot_find_prog_unit_error
921: (p_module_name => 'delete_salary_cap'
922: ,p_hook_type => 'BP'
923: );

Line 920: hr_api.cannot_find_prog_unit_error

916: , p_object_version_number => l_object_version_number
917: );
918: exception
919: when hr_api.cannot_find_prog_unit then
920: hr_api.cannot_find_prog_unit_error
921: (p_module_name => 'delete_salary_cap'
922: ,p_hook_type => 'BP'
923: );
924: end;

Line 952: when hr_api.cannot_find_prog_unit then

948: , p_object_version_number => l_object_version_number
949: , p_return_status => l_return_status
950: );
951: exception
952: when hr_api.cannot_find_prog_unit then
953: hr_api.cannot_find_prog_unit_error
954: (p_module_name => 'delete_salary_cap'
955: ,p_hook_type => 'AP'
956: );

Line 953: hr_api.cannot_find_prog_unit_error

949: , p_return_status => l_return_status
950: );
951: exception
952: when hr_api.cannot_find_prog_unit then
953: hr_api.cannot_find_prog_unit_error
954: (p_module_name => 'delete_salary_cap'
955: ,p_hook_type => 'AP'
956: );
957: end;

Line 962: raise hr_api.validate_enabled;

958: --
959: -- When in validation only mode raise the Validate_Enabled exception
960: --
961: if p_validate then
962: raise hr_api.validate_enabled;
963: end if;
964: --
965: -- Set all IN OUT and OUT parameters with out values
966: --

Line 971: when hr_api.validate_enabled then

967: p_object_version_number := l_object_version_number;
968: p_return_status := l_return_status;
969: hr_utility.set_location(' Leaving:'||l_proc, 70);
970: exception
971: when hr_api.validate_enabled then
972: --
973: -- As the Validate_Enabled exception has been raised
974: -- we must rollback to the savepoint
975: --