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 >--------------------|
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: );
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;
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: );
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;
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: --
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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: --
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
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: --
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: );
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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: );
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;
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: --
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: --
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: );
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;
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: );
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;
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: --
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: --