51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy psp_era_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: psp_era_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: psp_era_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: psp_era_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: Raise;
180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure pre_update
184: (p_rec in psp_era_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'pre_update';
188: --
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure post_update
228: (p_rec in psp_era_shd.g_rec_type
229: ) is
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: --
339: => p_rec.eff_information14
340: ,p_eff_information15
341: => p_rec.eff_information15
342: ,p_effort_report_detail_id_o
343: => psp_era_shd.g_old_rec.effort_report_detail_id
344: ,p_wf_role_name_o
345: => psp_era_shd.g_old_rec.wf_role_name
346: ,p_wf_orig_system_id_o
347: => psp_era_shd.g_old_rec.wf_orig_system_id
341: => p_rec.eff_information15
342: ,p_effort_report_detail_id_o
343: => psp_era_shd.g_old_rec.effort_report_detail_id
344: ,p_wf_role_name_o
345: => psp_era_shd.g_old_rec.wf_role_name
346: ,p_wf_orig_system_id_o
347: => psp_era_shd.g_old_rec.wf_orig_system_id
348: ,p_wf_orig_system_o
349: => psp_era_shd.g_old_rec.wf_orig_system
343: => psp_era_shd.g_old_rec.effort_report_detail_id
344: ,p_wf_role_name_o
345: => psp_era_shd.g_old_rec.wf_role_name
346: ,p_wf_orig_system_id_o
347: => psp_era_shd.g_old_rec.wf_orig_system_id
348: ,p_wf_orig_system_o
349: => psp_era_shd.g_old_rec.wf_orig_system
350: ,p_approver_order_num_o
351: => psp_era_shd.g_old_rec.approver_order_num
345: => psp_era_shd.g_old_rec.wf_role_name
346: ,p_wf_orig_system_id_o
347: => psp_era_shd.g_old_rec.wf_orig_system_id
348: ,p_wf_orig_system_o
349: => psp_era_shd.g_old_rec.wf_orig_system
350: ,p_approver_order_num_o
351: => psp_era_shd.g_old_rec.approver_order_num
352: ,p_approval_status_o
353: => psp_era_shd.g_old_rec.approval_status
347: => psp_era_shd.g_old_rec.wf_orig_system_id
348: ,p_wf_orig_system_o
349: => psp_era_shd.g_old_rec.wf_orig_system
350: ,p_approver_order_num_o
351: => psp_era_shd.g_old_rec.approver_order_num
352: ,p_approval_status_o
353: => psp_era_shd.g_old_rec.approval_status
354: ,p_response_date_o
355: => psp_era_shd.g_old_rec.response_date
349: => psp_era_shd.g_old_rec.wf_orig_system
350: ,p_approver_order_num_o
351: => psp_era_shd.g_old_rec.approver_order_num
352: ,p_approval_status_o
353: => psp_era_shd.g_old_rec.approval_status
354: ,p_response_date_o
355: => psp_era_shd.g_old_rec.response_date
356: ,p_actual_cost_share_o
357: => psp_era_shd.g_old_rec.actual_cost_share
351: => psp_era_shd.g_old_rec.approver_order_num
352: ,p_approval_status_o
353: => psp_era_shd.g_old_rec.approval_status
354: ,p_response_date_o
355: => psp_era_shd.g_old_rec.response_date
356: ,p_actual_cost_share_o
357: => psp_era_shd.g_old_rec.actual_cost_share
358: ,p_overwritten_effort_percent_o
359: => psp_era_shd.g_old_rec.overwritten_effort_percent
353: => psp_era_shd.g_old_rec.approval_status
354: ,p_response_date_o
355: => psp_era_shd.g_old_rec.response_date
356: ,p_actual_cost_share_o
357: => psp_era_shd.g_old_rec.actual_cost_share
358: ,p_overwritten_effort_percent_o
359: => psp_era_shd.g_old_rec.overwritten_effort_percent
360: ,p_wf_item_key_o
361: => psp_era_shd.g_old_rec.wf_item_key
355: => psp_era_shd.g_old_rec.response_date
356: ,p_actual_cost_share_o
357: => psp_era_shd.g_old_rec.actual_cost_share
358: ,p_overwritten_effort_percent_o
359: => psp_era_shd.g_old_rec.overwritten_effort_percent
360: ,p_wf_item_key_o
361: => psp_era_shd.g_old_rec.wf_item_key
362: ,p_comments_o
363: => psp_era_shd.g_old_rec.comments
357: => psp_era_shd.g_old_rec.actual_cost_share
358: ,p_overwritten_effort_percent_o
359: => psp_era_shd.g_old_rec.overwritten_effort_percent
360: ,p_wf_item_key_o
361: => psp_era_shd.g_old_rec.wf_item_key
362: ,p_comments_o
363: => psp_era_shd.g_old_rec.comments
364: ,p_pera_information_category_o
365: => psp_era_shd.g_old_rec.pera_information_category
359: => psp_era_shd.g_old_rec.overwritten_effort_percent
360: ,p_wf_item_key_o
361: => psp_era_shd.g_old_rec.wf_item_key
362: ,p_comments_o
363: => psp_era_shd.g_old_rec.comments
364: ,p_pera_information_category_o
365: => psp_era_shd.g_old_rec.pera_information_category
366: ,p_pera_information1_o
367: => psp_era_shd.g_old_rec.pera_information1
361: => psp_era_shd.g_old_rec.wf_item_key
362: ,p_comments_o
363: => psp_era_shd.g_old_rec.comments
364: ,p_pera_information_category_o
365: => psp_era_shd.g_old_rec.pera_information_category
366: ,p_pera_information1_o
367: => psp_era_shd.g_old_rec.pera_information1
368: ,p_pera_information2_o
369: => psp_era_shd.g_old_rec.pera_information2
363: => psp_era_shd.g_old_rec.comments
364: ,p_pera_information_category_o
365: => psp_era_shd.g_old_rec.pera_information_category
366: ,p_pera_information1_o
367: => psp_era_shd.g_old_rec.pera_information1
368: ,p_pera_information2_o
369: => psp_era_shd.g_old_rec.pera_information2
370: ,p_pera_information3_o
371: => psp_era_shd.g_old_rec.pera_information3
365: => psp_era_shd.g_old_rec.pera_information_category
366: ,p_pera_information1_o
367: => psp_era_shd.g_old_rec.pera_information1
368: ,p_pera_information2_o
369: => psp_era_shd.g_old_rec.pera_information2
370: ,p_pera_information3_o
371: => psp_era_shd.g_old_rec.pera_information3
372: ,p_pera_information4_o
373: => psp_era_shd.g_old_rec.pera_information4
367: => psp_era_shd.g_old_rec.pera_information1
368: ,p_pera_information2_o
369: => psp_era_shd.g_old_rec.pera_information2
370: ,p_pera_information3_o
371: => psp_era_shd.g_old_rec.pera_information3
372: ,p_pera_information4_o
373: => psp_era_shd.g_old_rec.pera_information4
374: ,p_pera_information5_o
375: => psp_era_shd.g_old_rec.pera_information5
369: => psp_era_shd.g_old_rec.pera_information2
370: ,p_pera_information3_o
371: => psp_era_shd.g_old_rec.pera_information3
372: ,p_pera_information4_o
373: => psp_era_shd.g_old_rec.pera_information4
374: ,p_pera_information5_o
375: => psp_era_shd.g_old_rec.pera_information5
376: ,p_pera_information6_o
377: => psp_era_shd.g_old_rec.pera_information6
371: => psp_era_shd.g_old_rec.pera_information3
372: ,p_pera_information4_o
373: => psp_era_shd.g_old_rec.pera_information4
374: ,p_pera_information5_o
375: => psp_era_shd.g_old_rec.pera_information5
376: ,p_pera_information6_o
377: => psp_era_shd.g_old_rec.pera_information6
378: ,p_pera_information7_o
379: => psp_era_shd.g_old_rec.pera_information7
373: => psp_era_shd.g_old_rec.pera_information4
374: ,p_pera_information5_o
375: => psp_era_shd.g_old_rec.pera_information5
376: ,p_pera_information6_o
377: => psp_era_shd.g_old_rec.pera_information6
378: ,p_pera_information7_o
379: => psp_era_shd.g_old_rec.pera_information7
380: ,p_pera_information8_o
381: => psp_era_shd.g_old_rec.pera_information8
375: => psp_era_shd.g_old_rec.pera_information5
376: ,p_pera_information6_o
377: => psp_era_shd.g_old_rec.pera_information6
378: ,p_pera_information7_o
379: => psp_era_shd.g_old_rec.pera_information7
380: ,p_pera_information8_o
381: => psp_era_shd.g_old_rec.pera_information8
382: ,p_pera_information9_o
383: => psp_era_shd.g_old_rec.pera_information9
377: => psp_era_shd.g_old_rec.pera_information6
378: ,p_pera_information7_o
379: => psp_era_shd.g_old_rec.pera_information7
380: ,p_pera_information8_o
381: => psp_era_shd.g_old_rec.pera_information8
382: ,p_pera_information9_o
383: => psp_era_shd.g_old_rec.pera_information9
384: ,p_pera_information10_o
385: => psp_era_shd.g_old_rec.pera_information10
379: => psp_era_shd.g_old_rec.pera_information7
380: ,p_pera_information8_o
381: => psp_era_shd.g_old_rec.pera_information8
382: ,p_pera_information9_o
383: => psp_era_shd.g_old_rec.pera_information9
384: ,p_pera_information10_o
385: => psp_era_shd.g_old_rec.pera_information10
386: ,p_pera_information11_o
387: => psp_era_shd.g_old_rec.pera_information11
381: => psp_era_shd.g_old_rec.pera_information8
382: ,p_pera_information9_o
383: => psp_era_shd.g_old_rec.pera_information9
384: ,p_pera_information10_o
385: => psp_era_shd.g_old_rec.pera_information10
386: ,p_pera_information11_o
387: => psp_era_shd.g_old_rec.pera_information11
388: ,p_pera_information12_o
389: => psp_era_shd.g_old_rec.pera_information12
383: => psp_era_shd.g_old_rec.pera_information9
384: ,p_pera_information10_o
385: => psp_era_shd.g_old_rec.pera_information10
386: ,p_pera_information11_o
387: => psp_era_shd.g_old_rec.pera_information11
388: ,p_pera_information12_o
389: => psp_era_shd.g_old_rec.pera_information12
390: ,p_pera_information13_o
391: => psp_era_shd.g_old_rec.pera_information13
385: => psp_era_shd.g_old_rec.pera_information10
386: ,p_pera_information11_o
387: => psp_era_shd.g_old_rec.pera_information11
388: ,p_pera_information12_o
389: => psp_era_shd.g_old_rec.pera_information12
390: ,p_pera_information13_o
391: => psp_era_shd.g_old_rec.pera_information13
392: ,p_pera_information14_o
393: => psp_era_shd.g_old_rec.pera_information14
387: => psp_era_shd.g_old_rec.pera_information11
388: ,p_pera_information12_o
389: => psp_era_shd.g_old_rec.pera_information12
390: ,p_pera_information13_o
391: => psp_era_shd.g_old_rec.pera_information13
392: ,p_pera_information14_o
393: => psp_era_shd.g_old_rec.pera_information14
394: ,p_pera_information15_o
395: => psp_era_shd.g_old_rec.pera_information15
389: => psp_era_shd.g_old_rec.pera_information12
390: ,p_pera_information13_o
391: => psp_era_shd.g_old_rec.pera_information13
392: ,p_pera_information14_o
393: => psp_era_shd.g_old_rec.pera_information14
394: ,p_pera_information15_o
395: => psp_era_shd.g_old_rec.pera_information15
396: ,p_pera_information16_o
397: => psp_era_shd.g_old_rec.pera_information16
391: => psp_era_shd.g_old_rec.pera_information13
392: ,p_pera_information14_o
393: => psp_era_shd.g_old_rec.pera_information14
394: ,p_pera_information15_o
395: => psp_era_shd.g_old_rec.pera_information15
396: ,p_pera_information16_o
397: => psp_era_shd.g_old_rec.pera_information16
398: ,p_pera_information17_o
399: => psp_era_shd.g_old_rec.pera_information17
393: => psp_era_shd.g_old_rec.pera_information14
394: ,p_pera_information15_o
395: => psp_era_shd.g_old_rec.pera_information15
396: ,p_pera_information16_o
397: => psp_era_shd.g_old_rec.pera_information16
398: ,p_pera_information17_o
399: => psp_era_shd.g_old_rec.pera_information17
400: ,p_pera_information18_o
401: => psp_era_shd.g_old_rec.pera_information18
395: => psp_era_shd.g_old_rec.pera_information15
396: ,p_pera_information16_o
397: => psp_era_shd.g_old_rec.pera_information16
398: ,p_pera_information17_o
399: => psp_era_shd.g_old_rec.pera_information17
400: ,p_pera_information18_o
401: => psp_era_shd.g_old_rec.pera_information18
402: ,p_pera_information19_o
403: => psp_era_shd.g_old_rec.pera_information19
397: => psp_era_shd.g_old_rec.pera_information16
398: ,p_pera_information17_o
399: => psp_era_shd.g_old_rec.pera_information17
400: ,p_pera_information18_o
401: => psp_era_shd.g_old_rec.pera_information18
402: ,p_pera_information19_o
403: => psp_era_shd.g_old_rec.pera_information19
404: ,p_pera_information20_o
405: => psp_era_shd.g_old_rec.pera_information20
399: => psp_era_shd.g_old_rec.pera_information17
400: ,p_pera_information18_o
401: => psp_era_shd.g_old_rec.pera_information18
402: ,p_pera_information19_o
403: => psp_era_shd.g_old_rec.pera_information19
404: ,p_pera_information20_o
405: => psp_era_shd.g_old_rec.pera_information20
406: ,p_wf_role_display_name_o
407: => psp_era_shd.g_old_rec.wf_role_display_name
401: => psp_era_shd.g_old_rec.pera_information18
402: ,p_pera_information19_o
403: => psp_era_shd.g_old_rec.pera_information19
404: ,p_pera_information20_o
405: => psp_era_shd.g_old_rec.pera_information20
406: ,p_wf_role_display_name_o
407: => psp_era_shd.g_old_rec.wf_role_display_name
408: ,p_object_version_number_o
409: => psp_era_shd.g_old_rec.object_version_number
403: => psp_era_shd.g_old_rec.pera_information19
404: ,p_pera_information20_o
405: => psp_era_shd.g_old_rec.pera_information20
406: ,p_wf_role_display_name_o
407: => psp_era_shd.g_old_rec.wf_role_display_name
408: ,p_object_version_number_o
409: => psp_era_shd.g_old_rec.object_version_number
410: ,p_notification_id_o
411: => psp_era_shd.g_old_rec.notification_id
405: => psp_era_shd.g_old_rec.pera_information20
406: ,p_wf_role_display_name_o
407: => psp_era_shd.g_old_rec.wf_role_display_name
408: ,p_object_version_number_o
409: => psp_era_shd.g_old_rec.object_version_number
410: ,p_notification_id_o
411: => psp_era_shd.g_old_rec.notification_id
412: ,p_eff_information_category_o
413: => psp_era_shd.g_old_rec.eff_information_category
407: => psp_era_shd.g_old_rec.wf_role_display_name
408: ,p_object_version_number_o
409: => psp_era_shd.g_old_rec.object_version_number
410: ,p_notification_id_o
411: => psp_era_shd.g_old_rec.notification_id
412: ,p_eff_information_category_o
413: => psp_era_shd.g_old_rec.eff_information_category
414: ,p_eff_information1_o
415: => psp_era_shd.g_old_rec.eff_information1
409: => psp_era_shd.g_old_rec.object_version_number
410: ,p_notification_id_o
411: => psp_era_shd.g_old_rec.notification_id
412: ,p_eff_information_category_o
413: => psp_era_shd.g_old_rec.eff_information_category
414: ,p_eff_information1_o
415: => psp_era_shd.g_old_rec.eff_information1
416: ,p_eff_information2_o
417: => psp_era_shd.g_old_rec.eff_information2
411: => psp_era_shd.g_old_rec.notification_id
412: ,p_eff_information_category_o
413: => psp_era_shd.g_old_rec.eff_information_category
414: ,p_eff_information1_o
415: => psp_era_shd.g_old_rec.eff_information1
416: ,p_eff_information2_o
417: => psp_era_shd.g_old_rec.eff_information2
418: ,p_eff_information3_o
419: => psp_era_shd.g_old_rec.eff_information3
413: => psp_era_shd.g_old_rec.eff_information_category
414: ,p_eff_information1_o
415: => psp_era_shd.g_old_rec.eff_information1
416: ,p_eff_information2_o
417: => psp_era_shd.g_old_rec.eff_information2
418: ,p_eff_information3_o
419: => psp_era_shd.g_old_rec.eff_information3
420: ,p_eff_information4_o
421: => psp_era_shd.g_old_rec.eff_information4
415: => psp_era_shd.g_old_rec.eff_information1
416: ,p_eff_information2_o
417: => psp_era_shd.g_old_rec.eff_information2
418: ,p_eff_information3_o
419: => psp_era_shd.g_old_rec.eff_information3
420: ,p_eff_information4_o
421: => psp_era_shd.g_old_rec.eff_information4
422: ,p_eff_information5_o
423: => psp_era_shd.g_old_rec.eff_information5
417: => psp_era_shd.g_old_rec.eff_information2
418: ,p_eff_information3_o
419: => psp_era_shd.g_old_rec.eff_information3
420: ,p_eff_information4_o
421: => psp_era_shd.g_old_rec.eff_information4
422: ,p_eff_information5_o
423: => psp_era_shd.g_old_rec.eff_information5
424: ,p_eff_information6_o
425: => psp_era_shd.g_old_rec.eff_information6
419: => psp_era_shd.g_old_rec.eff_information3
420: ,p_eff_information4_o
421: => psp_era_shd.g_old_rec.eff_information4
422: ,p_eff_information5_o
423: => psp_era_shd.g_old_rec.eff_information5
424: ,p_eff_information6_o
425: => psp_era_shd.g_old_rec.eff_information6
426: ,p_eff_information7_o
427: => psp_era_shd.g_old_rec.eff_information7
421: => psp_era_shd.g_old_rec.eff_information4
422: ,p_eff_information5_o
423: => psp_era_shd.g_old_rec.eff_information5
424: ,p_eff_information6_o
425: => psp_era_shd.g_old_rec.eff_information6
426: ,p_eff_information7_o
427: => psp_era_shd.g_old_rec.eff_information7
428: ,p_eff_information8_o
429: => psp_era_shd.g_old_rec.eff_information8
423: => psp_era_shd.g_old_rec.eff_information5
424: ,p_eff_information6_o
425: => psp_era_shd.g_old_rec.eff_information6
426: ,p_eff_information7_o
427: => psp_era_shd.g_old_rec.eff_information7
428: ,p_eff_information8_o
429: => psp_era_shd.g_old_rec.eff_information8
430: ,p_eff_information9_o
431: => psp_era_shd.g_old_rec.eff_information9
425: => psp_era_shd.g_old_rec.eff_information6
426: ,p_eff_information7_o
427: => psp_era_shd.g_old_rec.eff_information7
428: ,p_eff_information8_o
429: => psp_era_shd.g_old_rec.eff_information8
430: ,p_eff_information9_o
431: => psp_era_shd.g_old_rec.eff_information9
432: ,p_eff_information10_o
433: => psp_era_shd.g_old_rec.eff_information10
427: => psp_era_shd.g_old_rec.eff_information7
428: ,p_eff_information8_o
429: => psp_era_shd.g_old_rec.eff_information8
430: ,p_eff_information9_o
431: => psp_era_shd.g_old_rec.eff_information9
432: ,p_eff_information10_o
433: => psp_era_shd.g_old_rec.eff_information10
434: ,p_eff_information11_o
435: => psp_era_shd.g_old_rec.eff_information11
429: => psp_era_shd.g_old_rec.eff_information8
430: ,p_eff_information9_o
431: => psp_era_shd.g_old_rec.eff_information9
432: ,p_eff_information10_o
433: => psp_era_shd.g_old_rec.eff_information10
434: ,p_eff_information11_o
435: => psp_era_shd.g_old_rec.eff_information11
436: ,p_eff_information12_o
437: => psp_era_shd.g_old_rec.eff_information12
431: => psp_era_shd.g_old_rec.eff_information9
432: ,p_eff_information10_o
433: => psp_era_shd.g_old_rec.eff_information10
434: ,p_eff_information11_o
435: => psp_era_shd.g_old_rec.eff_information11
436: ,p_eff_information12_o
437: => psp_era_shd.g_old_rec.eff_information12
438: ,p_eff_information13_o
439: => psp_era_shd.g_old_rec.eff_information13
433: => psp_era_shd.g_old_rec.eff_information10
434: ,p_eff_information11_o
435: => psp_era_shd.g_old_rec.eff_information11
436: ,p_eff_information12_o
437: => psp_era_shd.g_old_rec.eff_information12
438: ,p_eff_information13_o
439: => psp_era_shd.g_old_rec.eff_information13
440: ,p_eff_information14_o
441: => psp_era_shd.g_old_rec.eff_information14
435: => psp_era_shd.g_old_rec.eff_information11
436: ,p_eff_information12_o
437: => psp_era_shd.g_old_rec.eff_information12
438: ,p_eff_information13_o
439: => psp_era_shd.g_old_rec.eff_information13
440: ,p_eff_information14_o
441: => psp_era_shd.g_old_rec.eff_information14
442: ,p_eff_information15_o
443: => psp_era_shd.g_old_rec.eff_information15
437: => psp_era_shd.g_old_rec.eff_information12
438: ,p_eff_information13_o
439: => psp_era_shd.g_old_rec.eff_information13
440: ,p_eff_information14_o
441: => psp_era_shd.g_old_rec.eff_information14
442: ,p_eff_information15_o
443: => psp_era_shd.g_old_rec.eff_information15
444: );
445: --
439: => psp_era_shd.g_old_rec.eff_information13
440: ,p_eff_information14_o
441: => psp_era_shd.g_old_rec.eff_information14
442: ,p_eff_information15_o
443: => psp_era_shd.g_old_rec.eff_information15
444: );
445: --
446: exception
447: --
499: --
500: -- {End Of Comments}
501: -- ----------------------------------------------------------------------------
502: Procedure convert_defs
503: (p_rec in out nocopy psp_era_shd.g_rec_type
504: ) is
505: --
506: Begin
507: --
511: -- is being used then we must set to the 'current' argument value.
512: --
513: If (p_rec.effort_report_detail_id = hr_api.g_number) then
514: p_rec.effort_report_detail_id :=
515: psp_era_shd.g_old_rec.effort_report_detail_id;
516: End If;
517: If (p_rec.wf_role_name = hr_api.g_varchar2) then
518: p_rec.wf_role_name :=
519: psp_era_shd.g_old_rec.wf_role_name;
515: psp_era_shd.g_old_rec.effort_report_detail_id;
516: End If;
517: If (p_rec.wf_role_name = hr_api.g_varchar2) then
518: p_rec.wf_role_name :=
519: psp_era_shd.g_old_rec.wf_role_name;
520: End If;
521: If (p_rec.wf_orig_system_id = hr_api.g_number) then
522: p_rec.wf_orig_system_id :=
523: psp_era_shd.g_old_rec.wf_orig_system_id;
519: psp_era_shd.g_old_rec.wf_role_name;
520: End If;
521: If (p_rec.wf_orig_system_id = hr_api.g_number) then
522: p_rec.wf_orig_system_id :=
523: psp_era_shd.g_old_rec.wf_orig_system_id;
524: End If;
525: If (p_rec.wf_orig_system = hr_api.g_varchar2) then
526: p_rec.wf_orig_system :=
527: psp_era_shd.g_old_rec.wf_orig_system;
523: psp_era_shd.g_old_rec.wf_orig_system_id;
524: End If;
525: If (p_rec.wf_orig_system = hr_api.g_varchar2) then
526: p_rec.wf_orig_system :=
527: psp_era_shd.g_old_rec.wf_orig_system;
528: End If;
529: If (p_rec.approver_order_num = hr_api.g_number) then
530: p_rec.approver_order_num :=
531: psp_era_shd.g_old_rec.approver_order_num;
527: psp_era_shd.g_old_rec.wf_orig_system;
528: End If;
529: If (p_rec.approver_order_num = hr_api.g_number) then
530: p_rec.approver_order_num :=
531: psp_era_shd.g_old_rec.approver_order_num;
532: End If;
533: If (p_rec.approval_status = hr_api.g_varchar2) then
534: p_rec.approval_status :=
535: psp_era_shd.g_old_rec.approval_status;
531: psp_era_shd.g_old_rec.approver_order_num;
532: End If;
533: If (p_rec.approval_status = hr_api.g_varchar2) then
534: p_rec.approval_status :=
535: psp_era_shd.g_old_rec.approval_status;
536: End If;
537: If (p_rec.response_date = hr_api.g_date) then
538: p_rec.response_date :=
539: psp_era_shd.g_old_rec.response_date;
535: psp_era_shd.g_old_rec.approval_status;
536: End If;
537: If (p_rec.response_date = hr_api.g_date) then
538: p_rec.response_date :=
539: psp_era_shd.g_old_rec.response_date;
540: End If;
541: If (p_rec.actual_cost_share = hr_api.g_number) then
542: p_rec.actual_cost_share :=
543: psp_era_shd.g_old_rec.actual_cost_share;
539: psp_era_shd.g_old_rec.response_date;
540: End If;
541: If (p_rec.actual_cost_share = hr_api.g_number) then
542: p_rec.actual_cost_share :=
543: psp_era_shd.g_old_rec.actual_cost_share;
544: End If;
545: If (p_rec.overwritten_effort_percent = hr_api.g_number) then
546: p_rec.overwritten_effort_percent :=
547: psp_era_shd.g_old_rec.overwritten_effort_percent;
543: psp_era_shd.g_old_rec.actual_cost_share;
544: End If;
545: If (p_rec.overwritten_effort_percent = hr_api.g_number) then
546: p_rec.overwritten_effort_percent :=
547: psp_era_shd.g_old_rec.overwritten_effort_percent;
548: End If;
549: If (p_rec.wf_item_key = hr_api.g_varchar2) then
550: p_rec.wf_item_key :=
551: psp_era_shd.g_old_rec.wf_item_key;
547: psp_era_shd.g_old_rec.overwritten_effort_percent;
548: End If;
549: If (p_rec.wf_item_key = hr_api.g_varchar2) then
550: p_rec.wf_item_key :=
551: psp_era_shd.g_old_rec.wf_item_key;
552: End If;
553: If (p_rec.comments = hr_api.g_varchar2) then
554: p_rec.comments :=
555: psp_era_shd.g_old_rec.comments;
551: psp_era_shd.g_old_rec.wf_item_key;
552: End If;
553: If (p_rec.comments = hr_api.g_varchar2) then
554: p_rec.comments :=
555: psp_era_shd.g_old_rec.comments;
556: End If;
557: If (p_rec.pera_information_category = hr_api.g_varchar2) then
558: p_rec.pera_information_category :=
559: psp_era_shd.g_old_rec.pera_information_category;
555: psp_era_shd.g_old_rec.comments;
556: End If;
557: If (p_rec.pera_information_category = hr_api.g_varchar2) then
558: p_rec.pera_information_category :=
559: psp_era_shd.g_old_rec.pera_information_category;
560: End If;
561: If (p_rec.pera_information1 = hr_api.g_varchar2) then
562: p_rec.pera_information1 :=
563: psp_era_shd.g_old_rec.pera_information1;
559: psp_era_shd.g_old_rec.pera_information_category;
560: End If;
561: If (p_rec.pera_information1 = hr_api.g_varchar2) then
562: p_rec.pera_information1 :=
563: psp_era_shd.g_old_rec.pera_information1;
564: End If;
565: If (p_rec.pera_information2 = hr_api.g_varchar2) then
566: p_rec.pera_information2 :=
567: psp_era_shd.g_old_rec.pera_information2;
563: psp_era_shd.g_old_rec.pera_information1;
564: End If;
565: If (p_rec.pera_information2 = hr_api.g_varchar2) then
566: p_rec.pera_information2 :=
567: psp_era_shd.g_old_rec.pera_information2;
568: End If;
569: If (p_rec.pera_information3 = hr_api.g_varchar2) then
570: p_rec.pera_information3 :=
571: psp_era_shd.g_old_rec.pera_information3;
567: psp_era_shd.g_old_rec.pera_information2;
568: End If;
569: If (p_rec.pera_information3 = hr_api.g_varchar2) then
570: p_rec.pera_information3 :=
571: psp_era_shd.g_old_rec.pera_information3;
572: End If;
573: If (p_rec.pera_information4 = hr_api.g_varchar2) then
574: p_rec.pera_information4 :=
575: psp_era_shd.g_old_rec.pera_information4;
571: psp_era_shd.g_old_rec.pera_information3;
572: End If;
573: If (p_rec.pera_information4 = hr_api.g_varchar2) then
574: p_rec.pera_information4 :=
575: psp_era_shd.g_old_rec.pera_information4;
576: End If;
577: If (p_rec.pera_information5 = hr_api.g_varchar2) then
578: p_rec.pera_information5 :=
579: psp_era_shd.g_old_rec.pera_information5;
575: psp_era_shd.g_old_rec.pera_information4;
576: End If;
577: If (p_rec.pera_information5 = hr_api.g_varchar2) then
578: p_rec.pera_information5 :=
579: psp_era_shd.g_old_rec.pera_information5;
580: End If;
581: If (p_rec.pera_information6 = hr_api.g_varchar2) then
582: p_rec.pera_information6 :=
583: psp_era_shd.g_old_rec.pera_information6;
579: psp_era_shd.g_old_rec.pera_information5;
580: End If;
581: If (p_rec.pera_information6 = hr_api.g_varchar2) then
582: p_rec.pera_information6 :=
583: psp_era_shd.g_old_rec.pera_information6;
584: End If;
585: If (p_rec.pera_information7 = hr_api.g_varchar2) then
586: p_rec.pera_information7 :=
587: psp_era_shd.g_old_rec.pera_information7;
583: psp_era_shd.g_old_rec.pera_information6;
584: End If;
585: If (p_rec.pera_information7 = hr_api.g_varchar2) then
586: p_rec.pera_information7 :=
587: psp_era_shd.g_old_rec.pera_information7;
588: End If;
589: If (p_rec.pera_information8 = hr_api.g_varchar2) then
590: p_rec.pera_information8 :=
591: psp_era_shd.g_old_rec.pera_information8;
587: psp_era_shd.g_old_rec.pera_information7;
588: End If;
589: If (p_rec.pera_information8 = hr_api.g_varchar2) then
590: p_rec.pera_information8 :=
591: psp_era_shd.g_old_rec.pera_information8;
592: End If;
593: If (p_rec.pera_information9 = hr_api.g_varchar2) then
594: p_rec.pera_information9 :=
595: psp_era_shd.g_old_rec.pera_information9;
591: psp_era_shd.g_old_rec.pera_information8;
592: End If;
593: If (p_rec.pera_information9 = hr_api.g_varchar2) then
594: p_rec.pera_information9 :=
595: psp_era_shd.g_old_rec.pera_information9;
596: End If;
597: If (p_rec.pera_information10 = hr_api.g_varchar2) then
598: p_rec.pera_information10 :=
599: psp_era_shd.g_old_rec.pera_information10;
595: psp_era_shd.g_old_rec.pera_information9;
596: End If;
597: If (p_rec.pera_information10 = hr_api.g_varchar2) then
598: p_rec.pera_information10 :=
599: psp_era_shd.g_old_rec.pera_information10;
600: End If;
601: If (p_rec.pera_information11 = hr_api.g_varchar2) then
602: p_rec.pera_information11 :=
603: psp_era_shd.g_old_rec.pera_information11;
599: psp_era_shd.g_old_rec.pera_information10;
600: End If;
601: If (p_rec.pera_information11 = hr_api.g_varchar2) then
602: p_rec.pera_information11 :=
603: psp_era_shd.g_old_rec.pera_information11;
604: End If;
605: If (p_rec.pera_information12 = hr_api.g_varchar2) then
606: p_rec.pera_information12 :=
607: psp_era_shd.g_old_rec.pera_information12;
603: psp_era_shd.g_old_rec.pera_information11;
604: End If;
605: If (p_rec.pera_information12 = hr_api.g_varchar2) then
606: p_rec.pera_information12 :=
607: psp_era_shd.g_old_rec.pera_information12;
608: End If;
609: If (p_rec.pera_information13 = hr_api.g_varchar2) then
610: p_rec.pera_information13 :=
611: psp_era_shd.g_old_rec.pera_information13;
607: psp_era_shd.g_old_rec.pera_information12;
608: End If;
609: If (p_rec.pera_information13 = hr_api.g_varchar2) then
610: p_rec.pera_information13 :=
611: psp_era_shd.g_old_rec.pera_information13;
612: End If;
613: If (p_rec.pera_information14 = hr_api.g_varchar2) then
614: p_rec.pera_information14 :=
615: psp_era_shd.g_old_rec.pera_information14;
611: psp_era_shd.g_old_rec.pera_information13;
612: End If;
613: If (p_rec.pera_information14 = hr_api.g_varchar2) then
614: p_rec.pera_information14 :=
615: psp_era_shd.g_old_rec.pera_information14;
616: End If;
617: If (p_rec.pera_information15 = hr_api.g_varchar2) then
618: p_rec.pera_information15 :=
619: psp_era_shd.g_old_rec.pera_information15;
615: psp_era_shd.g_old_rec.pera_information14;
616: End If;
617: If (p_rec.pera_information15 = hr_api.g_varchar2) then
618: p_rec.pera_information15 :=
619: psp_era_shd.g_old_rec.pera_information15;
620: End If;
621: If (p_rec.pera_information16 = hr_api.g_varchar2) then
622: p_rec.pera_information16 :=
623: psp_era_shd.g_old_rec.pera_information16;
619: psp_era_shd.g_old_rec.pera_information15;
620: End If;
621: If (p_rec.pera_information16 = hr_api.g_varchar2) then
622: p_rec.pera_information16 :=
623: psp_era_shd.g_old_rec.pera_information16;
624: End If;
625: If (p_rec.pera_information17 = hr_api.g_varchar2) then
626: p_rec.pera_information17 :=
627: psp_era_shd.g_old_rec.pera_information17;
623: psp_era_shd.g_old_rec.pera_information16;
624: End If;
625: If (p_rec.pera_information17 = hr_api.g_varchar2) then
626: p_rec.pera_information17 :=
627: psp_era_shd.g_old_rec.pera_information17;
628: End If;
629: If (p_rec.pera_information18 = hr_api.g_varchar2) then
630: p_rec.pera_information18 :=
631: psp_era_shd.g_old_rec.pera_information18;
627: psp_era_shd.g_old_rec.pera_information17;
628: End If;
629: If (p_rec.pera_information18 = hr_api.g_varchar2) then
630: p_rec.pera_information18 :=
631: psp_era_shd.g_old_rec.pera_information18;
632: End If;
633: If (p_rec.pera_information19 = hr_api.g_varchar2) then
634: p_rec.pera_information19 :=
635: psp_era_shd.g_old_rec.pera_information19;
631: psp_era_shd.g_old_rec.pera_information18;
632: End If;
633: If (p_rec.pera_information19 = hr_api.g_varchar2) then
634: p_rec.pera_information19 :=
635: psp_era_shd.g_old_rec.pera_information19;
636: End If;
637: If (p_rec.pera_information20 = hr_api.g_varchar2) then
638: p_rec.pera_information20 :=
639: psp_era_shd.g_old_rec.pera_information20;
635: psp_era_shd.g_old_rec.pera_information19;
636: End If;
637: If (p_rec.pera_information20 = hr_api.g_varchar2) then
638: p_rec.pera_information20 :=
639: psp_era_shd.g_old_rec.pera_information20;
640: End If;
641: If (p_rec.wf_role_display_name = hr_api.g_varchar2) then
642: p_rec.wf_role_display_name :=
643: psp_era_shd.g_old_rec.wf_role_display_name;
639: psp_era_shd.g_old_rec.pera_information20;
640: End If;
641: If (p_rec.wf_role_display_name = hr_api.g_varchar2) then
642: p_rec.wf_role_display_name :=
643: psp_era_shd.g_old_rec.wf_role_display_name;
644: End If;
645: If (p_rec.notification_id = hr_api.g_number) then
646: p_rec.notification_id :=
647: psp_era_shd.g_old_rec.notification_id;
643: psp_era_shd.g_old_rec.wf_role_display_name;
644: End If;
645: If (p_rec.notification_id = hr_api.g_number) then
646: p_rec.notification_id :=
647: psp_era_shd.g_old_rec.notification_id;
648: End If;
649: If (p_rec.eff_information_category = hr_api.g_varchar2) then
650: p_rec.eff_information_category :=
651: psp_era_shd.g_old_rec.eff_information_category;
647: psp_era_shd.g_old_rec.notification_id;
648: End If;
649: If (p_rec.eff_information_category = hr_api.g_varchar2) then
650: p_rec.eff_information_category :=
651: psp_era_shd.g_old_rec.eff_information_category;
652: End If;
653: If (p_rec.eff_information1 = hr_api.g_varchar2) then
654: p_rec.eff_information1 :=
655: psp_era_shd.g_old_rec.eff_information1;
651: psp_era_shd.g_old_rec.eff_information_category;
652: End If;
653: If (p_rec.eff_information1 = hr_api.g_varchar2) then
654: p_rec.eff_information1 :=
655: psp_era_shd.g_old_rec.eff_information1;
656: End If;
657: If (p_rec.eff_information2 = hr_api.g_varchar2) then
658: p_rec.eff_information2 :=
659: psp_era_shd.g_old_rec.eff_information2;
655: psp_era_shd.g_old_rec.eff_information1;
656: End If;
657: If (p_rec.eff_information2 = hr_api.g_varchar2) then
658: p_rec.eff_information2 :=
659: psp_era_shd.g_old_rec.eff_information2;
660: End If;
661: If (p_rec.eff_information3 = hr_api.g_varchar2) then
662: p_rec.eff_information3 :=
663: psp_era_shd.g_old_rec.eff_information3;
659: psp_era_shd.g_old_rec.eff_information2;
660: End If;
661: If (p_rec.eff_information3 = hr_api.g_varchar2) then
662: p_rec.eff_information3 :=
663: psp_era_shd.g_old_rec.eff_information3;
664: End If;
665: If (p_rec.eff_information4 = hr_api.g_varchar2) then
666: p_rec.eff_information4 :=
667: psp_era_shd.g_old_rec.eff_information4;
663: psp_era_shd.g_old_rec.eff_information3;
664: End If;
665: If (p_rec.eff_information4 = hr_api.g_varchar2) then
666: p_rec.eff_information4 :=
667: psp_era_shd.g_old_rec.eff_information4;
668: End If;
669: If (p_rec.eff_information5 = hr_api.g_varchar2) then
670: p_rec.eff_information5 :=
671: psp_era_shd.g_old_rec.eff_information5;
667: psp_era_shd.g_old_rec.eff_information4;
668: End If;
669: If (p_rec.eff_information5 = hr_api.g_varchar2) then
670: p_rec.eff_information5 :=
671: psp_era_shd.g_old_rec.eff_information5;
672: End If;
673: If (p_rec.eff_information6 = hr_api.g_varchar2) then
674: p_rec.eff_information6 :=
675: psp_era_shd.g_old_rec.eff_information6;
671: psp_era_shd.g_old_rec.eff_information5;
672: End If;
673: If (p_rec.eff_information6 = hr_api.g_varchar2) then
674: p_rec.eff_information6 :=
675: psp_era_shd.g_old_rec.eff_information6;
676: End If;
677: If (p_rec.eff_information7 = hr_api.g_varchar2) then
678: p_rec.eff_information7 :=
679: psp_era_shd.g_old_rec.eff_information7;
675: psp_era_shd.g_old_rec.eff_information6;
676: End If;
677: If (p_rec.eff_information7 = hr_api.g_varchar2) then
678: p_rec.eff_information7 :=
679: psp_era_shd.g_old_rec.eff_information7;
680: End If;
681: If (p_rec.eff_information8 = hr_api.g_varchar2) then
682: p_rec.eff_information8 :=
683: psp_era_shd.g_old_rec.eff_information8;
679: psp_era_shd.g_old_rec.eff_information7;
680: End If;
681: If (p_rec.eff_information8 = hr_api.g_varchar2) then
682: p_rec.eff_information8 :=
683: psp_era_shd.g_old_rec.eff_information8;
684: End If;
685: If (p_rec.eff_information9 = hr_api.g_varchar2) then
686: p_rec.eff_information9 :=
687: psp_era_shd.g_old_rec.eff_information9;
683: psp_era_shd.g_old_rec.eff_information8;
684: End If;
685: If (p_rec.eff_information9 = hr_api.g_varchar2) then
686: p_rec.eff_information9 :=
687: psp_era_shd.g_old_rec.eff_information9;
688: End If;
689: If (p_rec.eff_information10 = hr_api.g_varchar2) then
690: p_rec.eff_information10 :=
691: psp_era_shd.g_old_rec.eff_information10;
687: psp_era_shd.g_old_rec.eff_information9;
688: End If;
689: If (p_rec.eff_information10 = hr_api.g_varchar2) then
690: p_rec.eff_information10 :=
691: psp_era_shd.g_old_rec.eff_information10;
692: End If;
693: If (p_rec.eff_information11 = hr_api.g_varchar2) then
694: p_rec.eff_information11 :=
695: psp_era_shd.g_old_rec.eff_information11;
691: psp_era_shd.g_old_rec.eff_information10;
692: End If;
693: If (p_rec.eff_information11 = hr_api.g_varchar2) then
694: p_rec.eff_information11 :=
695: psp_era_shd.g_old_rec.eff_information11;
696: End If;
697: If (p_rec.eff_information12 = hr_api.g_varchar2) then
698: p_rec.eff_information12 :=
699: psp_era_shd.g_old_rec.eff_information12;
695: psp_era_shd.g_old_rec.eff_information11;
696: End If;
697: If (p_rec.eff_information12 = hr_api.g_varchar2) then
698: p_rec.eff_information12 :=
699: psp_era_shd.g_old_rec.eff_information12;
700: End If;
701: If (p_rec.eff_information13 = hr_api.g_varchar2) then
702: p_rec.eff_information13 :=
703: psp_era_shd.g_old_rec.eff_information13;
699: psp_era_shd.g_old_rec.eff_information12;
700: End If;
701: If (p_rec.eff_information13 = hr_api.g_varchar2) then
702: p_rec.eff_information13 :=
703: psp_era_shd.g_old_rec.eff_information13;
704: End If;
705: If (p_rec.eff_information14 = hr_api.g_varchar2) then
706: p_rec.eff_information14 :=
707: psp_era_shd.g_old_rec.eff_information14;
703: psp_era_shd.g_old_rec.eff_information13;
704: End If;
705: If (p_rec.eff_information14 = hr_api.g_varchar2) then
706: p_rec.eff_information14 :=
707: psp_era_shd.g_old_rec.eff_information14;
708: End If;
709: If (p_rec.eff_information15 = hr_api.g_varchar2) then
710: p_rec.eff_information15 :=
711: psp_era_shd.g_old_rec.eff_information15;
707: psp_era_shd.g_old_rec.eff_information14;
708: End If;
709: If (p_rec.eff_information15 = hr_api.g_varchar2) then
710: p_rec.eff_information15 :=
711: psp_era_shd.g_old_rec.eff_information15;
712: End If;
713: --
714: End convert_defs;
715: --
716: -- ----------------------------------------------------------------------------
717: -- |---------------------------------< upd >----------------------------------|
718: -- ----------------------------------------------------------------------------
719: Procedure upd
720: (p_rec in out nocopy psp_era_shd.g_rec_type
721: ) is
722: --
723: l_proc varchar2(72) := g_package||'upd';
724: --
726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- We must lock the row which we need to update.
729: --
730: psp_era_shd.lck
731: (p_rec.effort_report_approval_id
732: ,p_rec.object_version_number
733: );
734: --
821: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
822: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
823: ) is
824: --
825: l_rec psp_era_shd.g_rec_type;
826: l_proc varchar2(72) := g_package||'upd';
827: --
828: Begin
829: hr_utility.set_location('Entering:'||l_proc, 5);
831: -- Call conversion function to turn arguments into the
832: -- l_rec structure.
833: --
834: l_rec :=
835: psp_era_shd.convert_args
836: (p_effort_report_approval_id
837: ,p_effort_report_detail_id
838: ,p_wf_role_name
839: ,p_wf_orig_system_id