51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy psp_erd_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
159: Exception
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: --
163: psp_erd_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --
168: psp_erd_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
173: psp_erd_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When Others Then
176: --
177: Raise;
209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure pre_update
213: (p_rec in psp_erd_shd.g_rec_type
214: ) is
215: --
216: l_proc varchar2(72) := g_package||'pre_update';
217: --
253: --
254: -- {End Of Comments}
255: -- ----------------------------------------------------------------------------
256: Procedure post_update
257: (p_rec in psp_erd_shd.g_rec_type
258: ) is
259: --
260: l_proc varchar2(72) := g_package||'post_update';
261: --
426: => p_rec.attribute10
427: ,p_grouping_category
428: => p_rec.grouping_category
429: ,p_effort_report_id_o
430: => psp_erd_shd.g_old_rec.effort_report_id
431: ,p_object_version_number_o
432: => psp_erd_shd.g_old_rec.object_version_number
433: ,p_assignment_id_o
434: => psp_erd_shd.g_old_rec.assignment_id
428: => p_rec.grouping_category
429: ,p_effort_report_id_o
430: => psp_erd_shd.g_old_rec.effort_report_id
431: ,p_object_version_number_o
432: => psp_erd_shd.g_old_rec.object_version_number
433: ,p_assignment_id_o
434: => psp_erd_shd.g_old_rec.assignment_id
435: ,p_assignment_number_o
436: => psp_erd_shd.g_old_rec.assignment_number
430: => psp_erd_shd.g_old_rec.effort_report_id
431: ,p_object_version_number_o
432: => psp_erd_shd.g_old_rec.object_version_number
433: ,p_assignment_id_o
434: => psp_erd_shd.g_old_rec.assignment_id
435: ,p_assignment_number_o
436: => psp_erd_shd.g_old_rec.assignment_number
437: ,p_gl_sum_criteria_segment_na_o
438: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
432: => psp_erd_shd.g_old_rec.object_version_number
433: ,p_assignment_id_o
434: => psp_erd_shd.g_old_rec.assignment_id
435: ,p_assignment_number_o
436: => psp_erd_shd.g_old_rec.assignment_number
437: ,p_gl_sum_criteria_segment_na_o
438: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
439: ,p_gl_segment1_o
440: => psp_erd_shd.g_old_rec.gl_segment1
434: => psp_erd_shd.g_old_rec.assignment_id
435: ,p_assignment_number_o
436: => psp_erd_shd.g_old_rec.assignment_number
437: ,p_gl_sum_criteria_segment_na_o
438: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
439: ,p_gl_segment1_o
440: => psp_erd_shd.g_old_rec.gl_segment1
441: ,p_gl_segment2_o
442: => psp_erd_shd.g_old_rec.gl_segment2
436: => psp_erd_shd.g_old_rec.assignment_number
437: ,p_gl_sum_criteria_segment_na_o
438: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
439: ,p_gl_segment1_o
440: => psp_erd_shd.g_old_rec.gl_segment1
441: ,p_gl_segment2_o
442: => psp_erd_shd.g_old_rec.gl_segment2
443: ,p_gl_segment3_o
444: => psp_erd_shd.g_old_rec.gl_segment3
438: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
439: ,p_gl_segment1_o
440: => psp_erd_shd.g_old_rec.gl_segment1
441: ,p_gl_segment2_o
442: => psp_erd_shd.g_old_rec.gl_segment2
443: ,p_gl_segment3_o
444: => psp_erd_shd.g_old_rec.gl_segment3
445: ,p_gl_segment4_o
446: => psp_erd_shd.g_old_rec.gl_segment4
440: => psp_erd_shd.g_old_rec.gl_segment1
441: ,p_gl_segment2_o
442: => psp_erd_shd.g_old_rec.gl_segment2
443: ,p_gl_segment3_o
444: => psp_erd_shd.g_old_rec.gl_segment3
445: ,p_gl_segment4_o
446: => psp_erd_shd.g_old_rec.gl_segment4
447: ,p_gl_segment5_o
448: => psp_erd_shd.g_old_rec.gl_segment5
442: => psp_erd_shd.g_old_rec.gl_segment2
443: ,p_gl_segment3_o
444: => psp_erd_shd.g_old_rec.gl_segment3
445: ,p_gl_segment4_o
446: => psp_erd_shd.g_old_rec.gl_segment4
447: ,p_gl_segment5_o
448: => psp_erd_shd.g_old_rec.gl_segment5
449: ,p_gl_segment6_o
450: => psp_erd_shd.g_old_rec.gl_segment6
444: => psp_erd_shd.g_old_rec.gl_segment3
445: ,p_gl_segment4_o
446: => psp_erd_shd.g_old_rec.gl_segment4
447: ,p_gl_segment5_o
448: => psp_erd_shd.g_old_rec.gl_segment5
449: ,p_gl_segment6_o
450: => psp_erd_shd.g_old_rec.gl_segment6
451: ,p_gl_segment7_o
452: => psp_erd_shd.g_old_rec.gl_segment7
446: => psp_erd_shd.g_old_rec.gl_segment4
447: ,p_gl_segment5_o
448: => psp_erd_shd.g_old_rec.gl_segment5
449: ,p_gl_segment6_o
450: => psp_erd_shd.g_old_rec.gl_segment6
451: ,p_gl_segment7_o
452: => psp_erd_shd.g_old_rec.gl_segment7
453: ,p_gl_segment8_o
454: => psp_erd_shd.g_old_rec.gl_segment8
448: => psp_erd_shd.g_old_rec.gl_segment5
449: ,p_gl_segment6_o
450: => psp_erd_shd.g_old_rec.gl_segment6
451: ,p_gl_segment7_o
452: => psp_erd_shd.g_old_rec.gl_segment7
453: ,p_gl_segment8_o
454: => psp_erd_shd.g_old_rec.gl_segment8
455: ,p_gl_segment9_o
456: => psp_erd_shd.g_old_rec.gl_segment9
450: => psp_erd_shd.g_old_rec.gl_segment6
451: ,p_gl_segment7_o
452: => psp_erd_shd.g_old_rec.gl_segment7
453: ,p_gl_segment8_o
454: => psp_erd_shd.g_old_rec.gl_segment8
455: ,p_gl_segment9_o
456: => psp_erd_shd.g_old_rec.gl_segment9
457: ,p_gl_segment10_o
458: => psp_erd_shd.g_old_rec.gl_segment10
452: => psp_erd_shd.g_old_rec.gl_segment7
453: ,p_gl_segment8_o
454: => psp_erd_shd.g_old_rec.gl_segment8
455: ,p_gl_segment9_o
456: => psp_erd_shd.g_old_rec.gl_segment9
457: ,p_gl_segment10_o
458: => psp_erd_shd.g_old_rec.gl_segment10
459: ,p_gl_segment11_o
460: => psp_erd_shd.g_old_rec.gl_segment11
454: => psp_erd_shd.g_old_rec.gl_segment8
455: ,p_gl_segment9_o
456: => psp_erd_shd.g_old_rec.gl_segment9
457: ,p_gl_segment10_o
458: => psp_erd_shd.g_old_rec.gl_segment10
459: ,p_gl_segment11_o
460: => psp_erd_shd.g_old_rec.gl_segment11
461: ,p_gl_segment12_o
462: => psp_erd_shd.g_old_rec.gl_segment12
456: => psp_erd_shd.g_old_rec.gl_segment9
457: ,p_gl_segment10_o
458: => psp_erd_shd.g_old_rec.gl_segment10
459: ,p_gl_segment11_o
460: => psp_erd_shd.g_old_rec.gl_segment11
461: ,p_gl_segment12_o
462: => psp_erd_shd.g_old_rec.gl_segment12
463: ,p_gl_segment13_o
464: => psp_erd_shd.g_old_rec.gl_segment13
458: => psp_erd_shd.g_old_rec.gl_segment10
459: ,p_gl_segment11_o
460: => psp_erd_shd.g_old_rec.gl_segment11
461: ,p_gl_segment12_o
462: => psp_erd_shd.g_old_rec.gl_segment12
463: ,p_gl_segment13_o
464: => psp_erd_shd.g_old_rec.gl_segment13
465: ,p_gl_segment14_o
466: => psp_erd_shd.g_old_rec.gl_segment14
460: => psp_erd_shd.g_old_rec.gl_segment11
461: ,p_gl_segment12_o
462: => psp_erd_shd.g_old_rec.gl_segment12
463: ,p_gl_segment13_o
464: => psp_erd_shd.g_old_rec.gl_segment13
465: ,p_gl_segment14_o
466: => psp_erd_shd.g_old_rec.gl_segment14
467: ,p_gl_segment15_o
468: => psp_erd_shd.g_old_rec.gl_segment15
462: => psp_erd_shd.g_old_rec.gl_segment12
463: ,p_gl_segment13_o
464: => psp_erd_shd.g_old_rec.gl_segment13
465: ,p_gl_segment14_o
466: => psp_erd_shd.g_old_rec.gl_segment14
467: ,p_gl_segment15_o
468: => psp_erd_shd.g_old_rec.gl_segment15
469: ,p_gl_segment16_o
470: => psp_erd_shd.g_old_rec.gl_segment16
464: => psp_erd_shd.g_old_rec.gl_segment13
465: ,p_gl_segment14_o
466: => psp_erd_shd.g_old_rec.gl_segment14
467: ,p_gl_segment15_o
468: => psp_erd_shd.g_old_rec.gl_segment15
469: ,p_gl_segment16_o
470: => psp_erd_shd.g_old_rec.gl_segment16
471: ,p_gl_segment17_o
472: => psp_erd_shd.g_old_rec.gl_segment17
466: => psp_erd_shd.g_old_rec.gl_segment14
467: ,p_gl_segment15_o
468: => psp_erd_shd.g_old_rec.gl_segment15
469: ,p_gl_segment16_o
470: => psp_erd_shd.g_old_rec.gl_segment16
471: ,p_gl_segment17_o
472: => psp_erd_shd.g_old_rec.gl_segment17
473: ,p_gl_segment18_o
474: => psp_erd_shd.g_old_rec.gl_segment18
468: => psp_erd_shd.g_old_rec.gl_segment15
469: ,p_gl_segment16_o
470: => psp_erd_shd.g_old_rec.gl_segment16
471: ,p_gl_segment17_o
472: => psp_erd_shd.g_old_rec.gl_segment17
473: ,p_gl_segment18_o
474: => psp_erd_shd.g_old_rec.gl_segment18
475: ,p_gl_segment19_o
476: => psp_erd_shd.g_old_rec.gl_segment19
470: => psp_erd_shd.g_old_rec.gl_segment16
471: ,p_gl_segment17_o
472: => psp_erd_shd.g_old_rec.gl_segment17
473: ,p_gl_segment18_o
474: => psp_erd_shd.g_old_rec.gl_segment18
475: ,p_gl_segment19_o
476: => psp_erd_shd.g_old_rec.gl_segment19
477: ,p_gl_segment20_o
478: => psp_erd_shd.g_old_rec.gl_segment20
472: => psp_erd_shd.g_old_rec.gl_segment17
473: ,p_gl_segment18_o
474: => psp_erd_shd.g_old_rec.gl_segment18
475: ,p_gl_segment19_o
476: => psp_erd_shd.g_old_rec.gl_segment19
477: ,p_gl_segment20_o
478: => psp_erd_shd.g_old_rec.gl_segment20
479: ,p_gl_segment21_o
480: => psp_erd_shd.g_old_rec.gl_segment21
474: => psp_erd_shd.g_old_rec.gl_segment18
475: ,p_gl_segment19_o
476: => psp_erd_shd.g_old_rec.gl_segment19
477: ,p_gl_segment20_o
478: => psp_erd_shd.g_old_rec.gl_segment20
479: ,p_gl_segment21_o
480: => psp_erd_shd.g_old_rec.gl_segment21
481: ,p_gl_segment22_o
482: => psp_erd_shd.g_old_rec.gl_segment22
476: => psp_erd_shd.g_old_rec.gl_segment19
477: ,p_gl_segment20_o
478: => psp_erd_shd.g_old_rec.gl_segment20
479: ,p_gl_segment21_o
480: => psp_erd_shd.g_old_rec.gl_segment21
481: ,p_gl_segment22_o
482: => psp_erd_shd.g_old_rec.gl_segment22
483: ,p_gl_segment23_o
484: => psp_erd_shd.g_old_rec.gl_segment23
478: => psp_erd_shd.g_old_rec.gl_segment20
479: ,p_gl_segment21_o
480: => psp_erd_shd.g_old_rec.gl_segment21
481: ,p_gl_segment22_o
482: => psp_erd_shd.g_old_rec.gl_segment22
483: ,p_gl_segment23_o
484: => psp_erd_shd.g_old_rec.gl_segment23
485: ,p_gl_segment24_o
486: => psp_erd_shd.g_old_rec.gl_segment24
480: => psp_erd_shd.g_old_rec.gl_segment21
481: ,p_gl_segment22_o
482: => psp_erd_shd.g_old_rec.gl_segment22
483: ,p_gl_segment23_o
484: => psp_erd_shd.g_old_rec.gl_segment23
485: ,p_gl_segment24_o
486: => psp_erd_shd.g_old_rec.gl_segment24
487: ,p_gl_segment25_o
488: => psp_erd_shd.g_old_rec.gl_segment25
482: => psp_erd_shd.g_old_rec.gl_segment22
483: ,p_gl_segment23_o
484: => psp_erd_shd.g_old_rec.gl_segment23
485: ,p_gl_segment24_o
486: => psp_erd_shd.g_old_rec.gl_segment24
487: ,p_gl_segment25_o
488: => psp_erd_shd.g_old_rec.gl_segment25
489: ,p_gl_segment26_o
490: => psp_erd_shd.g_old_rec.gl_segment26
484: => psp_erd_shd.g_old_rec.gl_segment23
485: ,p_gl_segment24_o
486: => psp_erd_shd.g_old_rec.gl_segment24
487: ,p_gl_segment25_o
488: => psp_erd_shd.g_old_rec.gl_segment25
489: ,p_gl_segment26_o
490: => psp_erd_shd.g_old_rec.gl_segment26
491: ,p_gl_segment27_o
492: => psp_erd_shd.g_old_rec.gl_segment27
486: => psp_erd_shd.g_old_rec.gl_segment24
487: ,p_gl_segment25_o
488: => psp_erd_shd.g_old_rec.gl_segment25
489: ,p_gl_segment26_o
490: => psp_erd_shd.g_old_rec.gl_segment26
491: ,p_gl_segment27_o
492: => psp_erd_shd.g_old_rec.gl_segment27
493: ,p_gl_segment28_o
494: => psp_erd_shd.g_old_rec.gl_segment28
488: => psp_erd_shd.g_old_rec.gl_segment25
489: ,p_gl_segment26_o
490: => psp_erd_shd.g_old_rec.gl_segment26
491: ,p_gl_segment27_o
492: => psp_erd_shd.g_old_rec.gl_segment27
493: ,p_gl_segment28_o
494: => psp_erd_shd.g_old_rec.gl_segment28
495: ,p_gl_segment29_o
496: => psp_erd_shd.g_old_rec.gl_segment29
490: => psp_erd_shd.g_old_rec.gl_segment26
491: ,p_gl_segment27_o
492: => psp_erd_shd.g_old_rec.gl_segment27
493: ,p_gl_segment28_o
494: => psp_erd_shd.g_old_rec.gl_segment28
495: ,p_gl_segment29_o
496: => psp_erd_shd.g_old_rec.gl_segment29
497: ,p_gl_segment30_o
498: => psp_erd_shd.g_old_rec.gl_segment30
492: => psp_erd_shd.g_old_rec.gl_segment27
493: ,p_gl_segment28_o
494: => psp_erd_shd.g_old_rec.gl_segment28
495: ,p_gl_segment29_o
496: => psp_erd_shd.g_old_rec.gl_segment29
497: ,p_gl_segment30_o
498: => psp_erd_shd.g_old_rec.gl_segment30
499: ,p_project_id_o
500: => psp_erd_shd.g_old_rec.project_id
494: => psp_erd_shd.g_old_rec.gl_segment28
495: ,p_gl_segment29_o
496: => psp_erd_shd.g_old_rec.gl_segment29
497: ,p_gl_segment30_o
498: => psp_erd_shd.g_old_rec.gl_segment30
499: ,p_project_id_o
500: => psp_erd_shd.g_old_rec.project_id
501: ,p_project_number_o
502: => psp_erd_shd.g_old_rec.project_number
496: => psp_erd_shd.g_old_rec.gl_segment29
497: ,p_gl_segment30_o
498: => psp_erd_shd.g_old_rec.gl_segment30
499: ,p_project_id_o
500: => psp_erd_shd.g_old_rec.project_id
501: ,p_project_number_o
502: => psp_erd_shd.g_old_rec.project_number
503: ,p_project_name_o
504: => psp_erd_shd.g_old_rec.project_name
498: => psp_erd_shd.g_old_rec.gl_segment30
499: ,p_project_id_o
500: => psp_erd_shd.g_old_rec.project_id
501: ,p_project_number_o
502: => psp_erd_shd.g_old_rec.project_number
503: ,p_project_name_o
504: => psp_erd_shd.g_old_rec.project_name
505: ,p_expenditure_organization_i_o
506: => psp_erd_shd.g_old_rec.expenditure_organization_id
500: => psp_erd_shd.g_old_rec.project_id
501: ,p_project_number_o
502: => psp_erd_shd.g_old_rec.project_number
503: ,p_project_name_o
504: => psp_erd_shd.g_old_rec.project_name
505: ,p_expenditure_organization_i_o
506: => psp_erd_shd.g_old_rec.expenditure_organization_id
507: ,p_exp_org_name_o
508: => psp_erd_shd.g_old_rec.exp_org_name
502: => psp_erd_shd.g_old_rec.project_number
503: ,p_project_name_o
504: => psp_erd_shd.g_old_rec.project_name
505: ,p_expenditure_organization_i_o
506: => psp_erd_shd.g_old_rec.expenditure_organization_id
507: ,p_exp_org_name_o
508: => psp_erd_shd.g_old_rec.exp_org_name
509: ,p_expenditure_type_o
510: => psp_erd_shd.g_old_rec.expenditure_type
504: => psp_erd_shd.g_old_rec.project_name
505: ,p_expenditure_organization_i_o
506: => psp_erd_shd.g_old_rec.expenditure_organization_id
507: ,p_exp_org_name_o
508: => psp_erd_shd.g_old_rec.exp_org_name
509: ,p_expenditure_type_o
510: => psp_erd_shd.g_old_rec.expenditure_type
511: ,p_task_id_o
512: => psp_erd_shd.g_old_rec.task_id
506: => psp_erd_shd.g_old_rec.expenditure_organization_id
507: ,p_exp_org_name_o
508: => psp_erd_shd.g_old_rec.exp_org_name
509: ,p_expenditure_type_o
510: => psp_erd_shd.g_old_rec.expenditure_type
511: ,p_task_id_o
512: => psp_erd_shd.g_old_rec.task_id
513: ,p_task_number_o
514: => psp_erd_shd.g_old_rec.task_number
508: => psp_erd_shd.g_old_rec.exp_org_name
509: ,p_expenditure_type_o
510: => psp_erd_shd.g_old_rec.expenditure_type
511: ,p_task_id_o
512: => psp_erd_shd.g_old_rec.task_id
513: ,p_task_number_o
514: => psp_erd_shd.g_old_rec.task_number
515: ,p_task_name_o
516: => psp_erd_shd.g_old_rec.task_name
510: => psp_erd_shd.g_old_rec.expenditure_type
511: ,p_task_id_o
512: => psp_erd_shd.g_old_rec.task_id
513: ,p_task_number_o
514: => psp_erd_shd.g_old_rec.task_number
515: ,p_task_name_o
516: => psp_erd_shd.g_old_rec.task_name
517: ,p_award_id_o
518: => psp_erd_shd.g_old_rec.award_id
512: => psp_erd_shd.g_old_rec.task_id
513: ,p_task_number_o
514: => psp_erd_shd.g_old_rec.task_number
515: ,p_task_name_o
516: => psp_erd_shd.g_old_rec.task_name
517: ,p_award_id_o
518: => psp_erd_shd.g_old_rec.award_id
519: ,p_award_number_o
520: => psp_erd_shd.g_old_rec.award_number
514: => psp_erd_shd.g_old_rec.task_number
515: ,p_task_name_o
516: => psp_erd_shd.g_old_rec.task_name
517: ,p_award_id_o
518: => psp_erd_shd.g_old_rec.award_id
519: ,p_award_number_o
520: => psp_erd_shd.g_old_rec.award_number
521: ,p_award_short_name_o
522: => psp_erd_shd.g_old_rec.award_short_name
516: => psp_erd_shd.g_old_rec.task_name
517: ,p_award_id_o
518: => psp_erd_shd.g_old_rec.award_id
519: ,p_award_number_o
520: => psp_erd_shd.g_old_rec.award_number
521: ,p_award_short_name_o
522: => psp_erd_shd.g_old_rec.award_short_name
523: ,p_actual_salary_amt_o
524: => psp_erd_shd.g_old_rec.actual_salary_amt
518: => psp_erd_shd.g_old_rec.award_id
519: ,p_award_number_o
520: => psp_erd_shd.g_old_rec.award_number
521: ,p_award_short_name_o
522: => psp_erd_shd.g_old_rec.award_short_name
523: ,p_actual_salary_amt_o
524: => psp_erd_shd.g_old_rec.actual_salary_amt
525: ,p_payroll_percent_o
526: => psp_erd_shd.g_old_rec.payroll_percent
520: => psp_erd_shd.g_old_rec.award_number
521: ,p_award_short_name_o
522: => psp_erd_shd.g_old_rec.award_short_name
523: ,p_actual_salary_amt_o
524: => psp_erd_shd.g_old_rec.actual_salary_amt
525: ,p_payroll_percent_o
526: => psp_erd_shd.g_old_rec.payroll_percent
527: ,p_proposed_salary_amt_o
528: => psp_erd_shd.g_old_rec.proposed_salary_amt
522: => psp_erd_shd.g_old_rec.award_short_name
523: ,p_actual_salary_amt_o
524: => psp_erd_shd.g_old_rec.actual_salary_amt
525: ,p_payroll_percent_o
526: => psp_erd_shd.g_old_rec.payroll_percent
527: ,p_proposed_salary_amt_o
528: => psp_erd_shd.g_old_rec.proposed_salary_amt
529: ,p_proposed_effort_percent_o
530: => psp_erd_shd.g_old_rec.proposed_effort_percent
524: => psp_erd_shd.g_old_rec.actual_salary_amt
525: ,p_payroll_percent_o
526: => psp_erd_shd.g_old_rec.payroll_percent
527: ,p_proposed_salary_amt_o
528: => psp_erd_shd.g_old_rec.proposed_salary_amt
529: ,p_proposed_effort_percent_o
530: => psp_erd_shd.g_old_rec.proposed_effort_percent
531: ,p_committed_cost_share_o
532: => psp_erd_shd.g_old_rec.committed_cost_share
526: => psp_erd_shd.g_old_rec.payroll_percent
527: ,p_proposed_salary_amt_o
528: => psp_erd_shd.g_old_rec.proposed_salary_amt
529: ,p_proposed_effort_percent_o
530: => psp_erd_shd.g_old_rec.proposed_effort_percent
531: ,p_committed_cost_share_o
532: => psp_erd_shd.g_old_rec.committed_cost_share
533: ,p_schedule_start_date_o
534: => psp_erd_shd.g_old_rec.schedule_start_date
528: => psp_erd_shd.g_old_rec.proposed_salary_amt
529: ,p_proposed_effort_percent_o
530: => psp_erd_shd.g_old_rec.proposed_effort_percent
531: ,p_committed_cost_share_o
532: => psp_erd_shd.g_old_rec.committed_cost_share
533: ,p_schedule_start_date_o
534: => psp_erd_shd.g_old_rec.schedule_start_date
535: ,p_schedule_end_date_o
536: => psp_erd_shd.g_old_rec.schedule_end_date
530: => psp_erd_shd.g_old_rec.proposed_effort_percent
531: ,p_committed_cost_share_o
532: => psp_erd_shd.g_old_rec.committed_cost_share
533: ,p_schedule_start_date_o
534: => psp_erd_shd.g_old_rec.schedule_start_date
535: ,p_schedule_end_date_o
536: => psp_erd_shd.g_old_rec.schedule_end_date
537: ,p_ame_transaction_id_o
538: => psp_erd_shd.g_old_rec.ame_transaction_id
532: => psp_erd_shd.g_old_rec.committed_cost_share
533: ,p_schedule_start_date_o
534: => psp_erd_shd.g_old_rec.schedule_start_date
535: ,p_schedule_end_date_o
536: => psp_erd_shd.g_old_rec.schedule_end_date
537: ,p_ame_transaction_id_o
538: => psp_erd_shd.g_old_rec.ame_transaction_id
539: ,p_investigator_name_o
540: => psp_erd_shd.g_old_rec.investigator_name
534: => psp_erd_shd.g_old_rec.schedule_start_date
535: ,p_schedule_end_date_o
536: => psp_erd_shd.g_old_rec.schedule_end_date
537: ,p_ame_transaction_id_o
538: => psp_erd_shd.g_old_rec.ame_transaction_id
539: ,p_investigator_name_o
540: => psp_erd_shd.g_old_rec.investigator_name
541: ,p_investigator_person_id_o
542: => psp_erd_shd.g_old_rec.investigator_person_id
536: => psp_erd_shd.g_old_rec.schedule_end_date
537: ,p_ame_transaction_id_o
538: => psp_erd_shd.g_old_rec.ame_transaction_id
539: ,p_investigator_name_o
540: => psp_erd_shd.g_old_rec.investigator_name
541: ,p_investigator_person_id_o
542: => psp_erd_shd.g_old_rec.investigator_person_id
543: ,p_investigator_org_name_o
544: => psp_erd_shd.g_old_rec.investigator_org_name
538: => psp_erd_shd.g_old_rec.ame_transaction_id
539: ,p_investigator_name_o
540: => psp_erd_shd.g_old_rec.investigator_name
541: ,p_investigator_person_id_o
542: => psp_erd_shd.g_old_rec.investigator_person_id
543: ,p_investigator_org_name_o
544: => psp_erd_shd.g_old_rec.investigator_org_name
545: ,p_investigator_primary_org_i_o
546: => psp_erd_shd.g_old_rec.investigator_primary_org_id
540: => psp_erd_shd.g_old_rec.investigator_name
541: ,p_investigator_person_id_o
542: => psp_erd_shd.g_old_rec.investigator_person_id
543: ,p_investigator_org_name_o
544: => psp_erd_shd.g_old_rec.investigator_org_name
545: ,p_investigator_primary_org_i_o
546: => psp_erd_shd.g_old_rec.investigator_primary_org_id
547: ,p_value1_o
548: => psp_erd_shd.g_old_rec.value1
542: => psp_erd_shd.g_old_rec.investigator_person_id
543: ,p_investigator_org_name_o
544: => psp_erd_shd.g_old_rec.investigator_org_name
545: ,p_investigator_primary_org_i_o
546: => psp_erd_shd.g_old_rec.investigator_primary_org_id
547: ,p_value1_o
548: => psp_erd_shd.g_old_rec.value1
549: ,p_value2_o
550: => psp_erd_shd.g_old_rec.value2
544: => psp_erd_shd.g_old_rec.investigator_org_name
545: ,p_investigator_primary_org_i_o
546: => psp_erd_shd.g_old_rec.investigator_primary_org_id
547: ,p_value1_o
548: => psp_erd_shd.g_old_rec.value1
549: ,p_value2_o
550: => psp_erd_shd.g_old_rec.value2
551: ,p_value3_o
552: => psp_erd_shd.g_old_rec.value3
546: => psp_erd_shd.g_old_rec.investigator_primary_org_id
547: ,p_value1_o
548: => psp_erd_shd.g_old_rec.value1
549: ,p_value2_o
550: => psp_erd_shd.g_old_rec.value2
551: ,p_value3_o
552: => psp_erd_shd.g_old_rec.value3
553: ,p_value4_o
554: => psp_erd_shd.g_old_rec.value4
548: => psp_erd_shd.g_old_rec.value1
549: ,p_value2_o
550: => psp_erd_shd.g_old_rec.value2
551: ,p_value3_o
552: => psp_erd_shd.g_old_rec.value3
553: ,p_value4_o
554: => psp_erd_shd.g_old_rec.value4
555: ,p_value5_o
556: => psp_erd_shd.g_old_rec.value5
550: => psp_erd_shd.g_old_rec.value2
551: ,p_value3_o
552: => psp_erd_shd.g_old_rec.value3
553: ,p_value4_o
554: => psp_erd_shd.g_old_rec.value4
555: ,p_value5_o
556: => psp_erd_shd.g_old_rec.value5
557: ,p_value6_o
558: => psp_erd_shd.g_old_rec.value6
552: => psp_erd_shd.g_old_rec.value3
553: ,p_value4_o
554: => psp_erd_shd.g_old_rec.value4
555: ,p_value5_o
556: => psp_erd_shd.g_old_rec.value5
557: ,p_value6_o
558: => psp_erd_shd.g_old_rec.value6
559: ,p_value7_o
560: => psp_erd_shd.g_old_rec.value7
554: => psp_erd_shd.g_old_rec.value4
555: ,p_value5_o
556: => psp_erd_shd.g_old_rec.value5
557: ,p_value6_o
558: => psp_erd_shd.g_old_rec.value6
559: ,p_value7_o
560: => psp_erd_shd.g_old_rec.value7
561: ,p_value8_o
562: => psp_erd_shd.g_old_rec.value8
556: => psp_erd_shd.g_old_rec.value5
557: ,p_value6_o
558: => psp_erd_shd.g_old_rec.value6
559: ,p_value7_o
560: => psp_erd_shd.g_old_rec.value7
561: ,p_value8_o
562: => psp_erd_shd.g_old_rec.value8
563: ,p_value9_o
564: => psp_erd_shd.g_old_rec.value9
558: => psp_erd_shd.g_old_rec.value6
559: ,p_value7_o
560: => psp_erd_shd.g_old_rec.value7
561: ,p_value8_o
562: => psp_erd_shd.g_old_rec.value8
563: ,p_value9_o
564: => psp_erd_shd.g_old_rec.value9
565: ,p_value10_o
566: => psp_erd_shd.g_old_rec.value10
560: => psp_erd_shd.g_old_rec.value7
561: ,p_value8_o
562: => psp_erd_shd.g_old_rec.value8
563: ,p_value9_o
564: => psp_erd_shd.g_old_rec.value9
565: ,p_value10_o
566: => psp_erd_shd.g_old_rec.value10
567: ,p_attribute1_o
568: => psp_erd_shd.g_old_rec.attribute1
562: => psp_erd_shd.g_old_rec.value8
563: ,p_value9_o
564: => psp_erd_shd.g_old_rec.value9
565: ,p_value10_o
566: => psp_erd_shd.g_old_rec.value10
567: ,p_attribute1_o
568: => psp_erd_shd.g_old_rec.attribute1
569: ,p_attribute2_o
570: => psp_erd_shd.g_old_rec.attribute2
564: => psp_erd_shd.g_old_rec.value9
565: ,p_value10_o
566: => psp_erd_shd.g_old_rec.value10
567: ,p_attribute1_o
568: => psp_erd_shd.g_old_rec.attribute1
569: ,p_attribute2_o
570: => psp_erd_shd.g_old_rec.attribute2
571: ,p_attribute3_o
572: => psp_erd_shd.g_old_rec.attribute3
566: => psp_erd_shd.g_old_rec.value10
567: ,p_attribute1_o
568: => psp_erd_shd.g_old_rec.attribute1
569: ,p_attribute2_o
570: => psp_erd_shd.g_old_rec.attribute2
571: ,p_attribute3_o
572: => psp_erd_shd.g_old_rec.attribute3
573: ,p_attribute4_o
574: => psp_erd_shd.g_old_rec.attribute4
568: => psp_erd_shd.g_old_rec.attribute1
569: ,p_attribute2_o
570: => psp_erd_shd.g_old_rec.attribute2
571: ,p_attribute3_o
572: => psp_erd_shd.g_old_rec.attribute3
573: ,p_attribute4_o
574: => psp_erd_shd.g_old_rec.attribute4
575: ,p_attribute5_o
576: => psp_erd_shd.g_old_rec.attribute5
570: => psp_erd_shd.g_old_rec.attribute2
571: ,p_attribute3_o
572: => psp_erd_shd.g_old_rec.attribute3
573: ,p_attribute4_o
574: => psp_erd_shd.g_old_rec.attribute4
575: ,p_attribute5_o
576: => psp_erd_shd.g_old_rec.attribute5
577: ,p_attribute6_o
578: => psp_erd_shd.g_old_rec.attribute6
572: => psp_erd_shd.g_old_rec.attribute3
573: ,p_attribute4_o
574: => psp_erd_shd.g_old_rec.attribute4
575: ,p_attribute5_o
576: => psp_erd_shd.g_old_rec.attribute5
577: ,p_attribute6_o
578: => psp_erd_shd.g_old_rec.attribute6
579: ,p_attribute7_o
580: => psp_erd_shd.g_old_rec.attribute7
574: => psp_erd_shd.g_old_rec.attribute4
575: ,p_attribute5_o
576: => psp_erd_shd.g_old_rec.attribute5
577: ,p_attribute6_o
578: => psp_erd_shd.g_old_rec.attribute6
579: ,p_attribute7_o
580: => psp_erd_shd.g_old_rec.attribute7
581: ,p_attribute8_o
582: => psp_erd_shd.g_old_rec.attribute8
576: => psp_erd_shd.g_old_rec.attribute5
577: ,p_attribute6_o
578: => psp_erd_shd.g_old_rec.attribute6
579: ,p_attribute7_o
580: => psp_erd_shd.g_old_rec.attribute7
581: ,p_attribute8_o
582: => psp_erd_shd.g_old_rec.attribute8
583: ,p_attribute9_o
584: => psp_erd_shd.g_old_rec.attribute9
578: => psp_erd_shd.g_old_rec.attribute6
579: ,p_attribute7_o
580: => psp_erd_shd.g_old_rec.attribute7
581: ,p_attribute8_o
582: => psp_erd_shd.g_old_rec.attribute8
583: ,p_attribute9_o
584: => psp_erd_shd.g_old_rec.attribute9
585: ,p_attribute10_o
586: => psp_erd_shd.g_old_rec.attribute10
580: => psp_erd_shd.g_old_rec.attribute7
581: ,p_attribute8_o
582: => psp_erd_shd.g_old_rec.attribute8
583: ,p_attribute9_o
584: => psp_erd_shd.g_old_rec.attribute9
585: ,p_attribute10_o
586: => psp_erd_shd.g_old_rec.attribute10
587: ,p_grouping_category_o
588: => psp_erd_shd.g_old_rec.grouping_category
582: => psp_erd_shd.g_old_rec.attribute8
583: ,p_attribute9_o
584: => psp_erd_shd.g_old_rec.attribute9
585: ,p_attribute10_o
586: => psp_erd_shd.g_old_rec.attribute10
587: ,p_grouping_category_o
588: => psp_erd_shd.g_old_rec.grouping_category
589: );
590: --
584: => psp_erd_shd.g_old_rec.attribute9
585: ,p_attribute10_o
586: => psp_erd_shd.g_old_rec.attribute10
587: ,p_grouping_category_o
588: => psp_erd_shd.g_old_rec.grouping_category
589: );
590: --
591: exception
592: --
644: --
645: -- {End Of Comments}
646: -- ----------------------------------------------------------------------------
647: Procedure convert_defs
648: (p_rec in out nocopy psp_erd_shd.g_rec_type
649: ) is
650: --
651: Begin
652: --
656: -- is being used then we must set to the 'current' argument value.
657: --
658: If (p_rec.effort_report_id = hr_api.g_number) then
659: p_rec.effort_report_id :=
660: psp_erd_shd.g_old_rec.effort_report_id;
661: End If;
662: If (p_rec.assignment_id = hr_api.g_number) then
663: p_rec.assignment_id :=
664: psp_erd_shd.g_old_rec.assignment_id;
660: psp_erd_shd.g_old_rec.effort_report_id;
661: End If;
662: If (p_rec.assignment_id = hr_api.g_number) then
663: p_rec.assignment_id :=
664: psp_erd_shd.g_old_rec.assignment_id;
665: End If;
666: If (p_rec.assignment_number = hr_api.g_varchar2) then
667: p_rec.assignment_number :=
668: psp_erd_shd.g_old_rec.assignment_number;
664: psp_erd_shd.g_old_rec.assignment_id;
665: End If;
666: If (p_rec.assignment_number = hr_api.g_varchar2) then
667: p_rec.assignment_number :=
668: psp_erd_shd.g_old_rec.assignment_number;
669: End If;
670: If (p_rec.gl_sum_criteria_segment_name = hr_api.g_varchar2) then
671: p_rec.gl_sum_criteria_segment_name :=
672: psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name;
668: psp_erd_shd.g_old_rec.assignment_number;
669: End If;
670: If (p_rec.gl_sum_criteria_segment_name = hr_api.g_varchar2) then
671: p_rec.gl_sum_criteria_segment_name :=
672: psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name;
673: End If;
674: If (p_rec.gl_segment1 = hr_api.g_varchar2) then
675: p_rec.gl_segment1 :=
676: psp_erd_shd.g_old_rec.gl_segment1;
672: psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name;
673: End If;
674: If (p_rec.gl_segment1 = hr_api.g_varchar2) then
675: p_rec.gl_segment1 :=
676: psp_erd_shd.g_old_rec.gl_segment1;
677: End If;
678: If (p_rec.gl_segment2 = hr_api.g_varchar2) then
679: p_rec.gl_segment2 :=
680: psp_erd_shd.g_old_rec.gl_segment2;
676: psp_erd_shd.g_old_rec.gl_segment1;
677: End If;
678: If (p_rec.gl_segment2 = hr_api.g_varchar2) then
679: p_rec.gl_segment2 :=
680: psp_erd_shd.g_old_rec.gl_segment2;
681: End If;
682: If (p_rec.gl_segment3 = hr_api.g_varchar2) then
683: p_rec.gl_segment3 :=
684: psp_erd_shd.g_old_rec.gl_segment3;
680: psp_erd_shd.g_old_rec.gl_segment2;
681: End If;
682: If (p_rec.gl_segment3 = hr_api.g_varchar2) then
683: p_rec.gl_segment3 :=
684: psp_erd_shd.g_old_rec.gl_segment3;
685: End If;
686: If (p_rec.gl_segment4 = hr_api.g_varchar2) then
687: p_rec.gl_segment4 :=
688: psp_erd_shd.g_old_rec.gl_segment4;
684: psp_erd_shd.g_old_rec.gl_segment3;
685: End If;
686: If (p_rec.gl_segment4 = hr_api.g_varchar2) then
687: p_rec.gl_segment4 :=
688: psp_erd_shd.g_old_rec.gl_segment4;
689: End If;
690: If (p_rec.gl_segment5 = hr_api.g_varchar2) then
691: p_rec.gl_segment5 :=
692: psp_erd_shd.g_old_rec.gl_segment5;
688: psp_erd_shd.g_old_rec.gl_segment4;
689: End If;
690: If (p_rec.gl_segment5 = hr_api.g_varchar2) then
691: p_rec.gl_segment5 :=
692: psp_erd_shd.g_old_rec.gl_segment5;
693: End If;
694: If (p_rec.gl_segment6 = hr_api.g_varchar2) then
695: p_rec.gl_segment6 :=
696: psp_erd_shd.g_old_rec.gl_segment6;
692: psp_erd_shd.g_old_rec.gl_segment5;
693: End If;
694: If (p_rec.gl_segment6 = hr_api.g_varchar2) then
695: p_rec.gl_segment6 :=
696: psp_erd_shd.g_old_rec.gl_segment6;
697: End If;
698: If (p_rec.gl_segment7 = hr_api.g_varchar2) then
699: p_rec.gl_segment7 :=
700: psp_erd_shd.g_old_rec.gl_segment7;
696: psp_erd_shd.g_old_rec.gl_segment6;
697: End If;
698: If (p_rec.gl_segment7 = hr_api.g_varchar2) then
699: p_rec.gl_segment7 :=
700: psp_erd_shd.g_old_rec.gl_segment7;
701: End If;
702: If (p_rec.gl_segment8 = hr_api.g_varchar2) then
703: p_rec.gl_segment8 :=
704: psp_erd_shd.g_old_rec.gl_segment8;
700: psp_erd_shd.g_old_rec.gl_segment7;
701: End If;
702: If (p_rec.gl_segment8 = hr_api.g_varchar2) then
703: p_rec.gl_segment8 :=
704: psp_erd_shd.g_old_rec.gl_segment8;
705: End If;
706: If (p_rec.gl_segment9 = hr_api.g_varchar2) then
707: p_rec.gl_segment9 :=
708: psp_erd_shd.g_old_rec.gl_segment9;
704: psp_erd_shd.g_old_rec.gl_segment8;
705: End If;
706: If (p_rec.gl_segment9 = hr_api.g_varchar2) then
707: p_rec.gl_segment9 :=
708: psp_erd_shd.g_old_rec.gl_segment9;
709: End If;
710: If (p_rec.gl_segment10 = hr_api.g_varchar2) then
711: p_rec.gl_segment10 :=
712: psp_erd_shd.g_old_rec.gl_segment10;
708: psp_erd_shd.g_old_rec.gl_segment9;
709: End If;
710: If (p_rec.gl_segment10 = hr_api.g_varchar2) then
711: p_rec.gl_segment10 :=
712: psp_erd_shd.g_old_rec.gl_segment10;
713: End If;
714: If (p_rec.gl_segment11 = hr_api.g_varchar2) then
715: p_rec.gl_segment11 :=
716: psp_erd_shd.g_old_rec.gl_segment11;
712: psp_erd_shd.g_old_rec.gl_segment10;
713: End If;
714: If (p_rec.gl_segment11 = hr_api.g_varchar2) then
715: p_rec.gl_segment11 :=
716: psp_erd_shd.g_old_rec.gl_segment11;
717: End If;
718: If (p_rec.gl_segment12 = hr_api.g_varchar2) then
719: p_rec.gl_segment12 :=
720: psp_erd_shd.g_old_rec.gl_segment12;
716: psp_erd_shd.g_old_rec.gl_segment11;
717: End If;
718: If (p_rec.gl_segment12 = hr_api.g_varchar2) then
719: p_rec.gl_segment12 :=
720: psp_erd_shd.g_old_rec.gl_segment12;
721: End If;
722: If (p_rec.gl_segment13 = hr_api.g_varchar2) then
723: p_rec.gl_segment13 :=
724: psp_erd_shd.g_old_rec.gl_segment13;
720: psp_erd_shd.g_old_rec.gl_segment12;
721: End If;
722: If (p_rec.gl_segment13 = hr_api.g_varchar2) then
723: p_rec.gl_segment13 :=
724: psp_erd_shd.g_old_rec.gl_segment13;
725: End If;
726: If (p_rec.gl_segment14 = hr_api.g_varchar2) then
727: p_rec.gl_segment14 :=
728: psp_erd_shd.g_old_rec.gl_segment14;
724: psp_erd_shd.g_old_rec.gl_segment13;
725: End If;
726: If (p_rec.gl_segment14 = hr_api.g_varchar2) then
727: p_rec.gl_segment14 :=
728: psp_erd_shd.g_old_rec.gl_segment14;
729: End If;
730: If (p_rec.gl_segment15 = hr_api.g_varchar2) then
731: p_rec.gl_segment15 :=
732: psp_erd_shd.g_old_rec.gl_segment15;
728: psp_erd_shd.g_old_rec.gl_segment14;
729: End If;
730: If (p_rec.gl_segment15 = hr_api.g_varchar2) then
731: p_rec.gl_segment15 :=
732: psp_erd_shd.g_old_rec.gl_segment15;
733: End If;
734: If (p_rec.gl_segment16 = hr_api.g_varchar2) then
735: p_rec.gl_segment16 :=
736: psp_erd_shd.g_old_rec.gl_segment16;
732: psp_erd_shd.g_old_rec.gl_segment15;
733: End If;
734: If (p_rec.gl_segment16 = hr_api.g_varchar2) then
735: p_rec.gl_segment16 :=
736: psp_erd_shd.g_old_rec.gl_segment16;
737: End If;
738: If (p_rec.gl_segment17 = hr_api.g_varchar2) then
739: p_rec.gl_segment17 :=
740: psp_erd_shd.g_old_rec.gl_segment17;
736: psp_erd_shd.g_old_rec.gl_segment16;
737: End If;
738: If (p_rec.gl_segment17 = hr_api.g_varchar2) then
739: p_rec.gl_segment17 :=
740: psp_erd_shd.g_old_rec.gl_segment17;
741: End If;
742: If (p_rec.gl_segment18 = hr_api.g_varchar2) then
743: p_rec.gl_segment18 :=
744: psp_erd_shd.g_old_rec.gl_segment18;
740: psp_erd_shd.g_old_rec.gl_segment17;
741: End If;
742: If (p_rec.gl_segment18 = hr_api.g_varchar2) then
743: p_rec.gl_segment18 :=
744: psp_erd_shd.g_old_rec.gl_segment18;
745: End If;
746: If (p_rec.gl_segment19 = hr_api.g_varchar2) then
747: p_rec.gl_segment19 :=
748: psp_erd_shd.g_old_rec.gl_segment19;
744: psp_erd_shd.g_old_rec.gl_segment18;
745: End If;
746: If (p_rec.gl_segment19 = hr_api.g_varchar2) then
747: p_rec.gl_segment19 :=
748: psp_erd_shd.g_old_rec.gl_segment19;
749: End If;
750: If (p_rec.gl_segment20 = hr_api.g_varchar2) then
751: p_rec.gl_segment20 :=
752: psp_erd_shd.g_old_rec.gl_segment20;
748: psp_erd_shd.g_old_rec.gl_segment19;
749: End If;
750: If (p_rec.gl_segment20 = hr_api.g_varchar2) then
751: p_rec.gl_segment20 :=
752: psp_erd_shd.g_old_rec.gl_segment20;
753: End If;
754: If (p_rec.gl_segment21 = hr_api.g_varchar2) then
755: p_rec.gl_segment21 :=
756: psp_erd_shd.g_old_rec.gl_segment21;
752: psp_erd_shd.g_old_rec.gl_segment20;
753: End If;
754: If (p_rec.gl_segment21 = hr_api.g_varchar2) then
755: p_rec.gl_segment21 :=
756: psp_erd_shd.g_old_rec.gl_segment21;
757: End If;
758: If (p_rec.gl_segment22 = hr_api.g_varchar2) then
759: p_rec.gl_segment22 :=
760: psp_erd_shd.g_old_rec.gl_segment22;
756: psp_erd_shd.g_old_rec.gl_segment21;
757: End If;
758: If (p_rec.gl_segment22 = hr_api.g_varchar2) then
759: p_rec.gl_segment22 :=
760: psp_erd_shd.g_old_rec.gl_segment22;
761: End If;
762: If (p_rec.gl_segment23 = hr_api.g_varchar2) then
763: p_rec.gl_segment23 :=
764: psp_erd_shd.g_old_rec.gl_segment23;
760: psp_erd_shd.g_old_rec.gl_segment22;
761: End If;
762: If (p_rec.gl_segment23 = hr_api.g_varchar2) then
763: p_rec.gl_segment23 :=
764: psp_erd_shd.g_old_rec.gl_segment23;
765: End If;
766: If (p_rec.gl_segment24 = hr_api.g_varchar2) then
767: p_rec.gl_segment24 :=
768: psp_erd_shd.g_old_rec.gl_segment24;
764: psp_erd_shd.g_old_rec.gl_segment23;
765: End If;
766: If (p_rec.gl_segment24 = hr_api.g_varchar2) then
767: p_rec.gl_segment24 :=
768: psp_erd_shd.g_old_rec.gl_segment24;
769: End If;
770: If (p_rec.gl_segment25 = hr_api.g_varchar2) then
771: p_rec.gl_segment25 :=
772: psp_erd_shd.g_old_rec.gl_segment25;
768: psp_erd_shd.g_old_rec.gl_segment24;
769: End If;
770: If (p_rec.gl_segment25 = hr_api.g_varchar2) then
771: p_rec.gl_segment25 :=
772: psp_erd_shd.g_old_rec.gl_segment25;
773: End If;
774: If (p_rec.gl_segment26 = hr_api.g_varchar2) then
775: p_rec.gl_segment26 :=
776: psp_erd_shd.g_old_rec.gl_segment26;
772: psp_erd_shd.g_old_rec.gl_segment25;
773: End If;
774: If (p_rec.gl_segment26 = hr_api.g_varchar2) then
775: p_rec.gl_segment26 :=
776: psp_erd_shd.g_old_rec.gl_segment26;
777: End If;
778: If (p_rec.gl_segment27 = hr_api.g_varchar2) then
779: p_rec.gl_segment27 :=
780: psp_erd_shd.g_old_rec.gl_segment27;
776: psp_erd_shd.g_old_rec.gl_segment26;
777: End If;
778: If (p_rec.gl_segment27 = hr_api.g_varchar2) then
779: p_rec.gl_segment27 :=
780: psp_erd_shd.g_old_rec.gl_segment27;
781: End If;
782: If (p_rec.gl_segment28 = hr_api.g_varchar2) then
783: p_rec.gl_segment28 :=
784: psp_erd_shd.g_old_rec.gl_segment28;
780: psp_erd_shd.g_old_rec.gl_segment27;
781: End If;
782: If (p_rec.gl_segment28 = hr_api.g_varchar2) then
783: p_rec.gl_segment28 :=
784: psp_erd_shd.g_old_rec.gl_segment28;
785: End If;
786: If (p_rec.gl_segment29 = hr_api.g_varchar2) then
787: p_rec.gl_segment29 :=
788: psp_erd_shd.g_old_rec.gl_segment29;
784: psp_erd_shd.g_old_rec.gl_segment28;
785: End If;
786: If (p_rec.gl_segment29 = hr_api.g_varchar2) then
787: p_rec.gl_segment29 :=
788: psp_erd_shd.g_old_rec.gl_segment29;
789: End If;
790: If (p_rec.gl_segment30 = hr_api.g_varchar2) then
791: p_rec.gl_segment30 :=
792: psp_erd_shd.g_old_rec.gl_segment30;
788: psp_erd_shd.g_old_rec.gl_segment29;
789: End If;
790: If (p_rec.gl_segment30 = hr_api.g_varchar2) then
791: p_rec.gl_segment30 :=
792: psp_erd_shd.g_old_rec.gl_segment30;
793: End If;
794: If (p_rec.project_id = hr_api.g_number) then
795: p_rec.project_id :=
796: psp_erd_shd.g_old_rec.project_id;
792: psp_erd_shd.g_old_rec.gl_segment30;
793: End If;
794: If (p_rec.project_id = hr_api.g_number) then
795: p_rec.project_id :=
796: psp_erd_shd.g_old_rec.project_id;
797: End If;
798: If (p_rec.project_number = hr_api.g_varchar2) then
799: p_rec.project_number :=
800: psp_erd_shd.g_old_rec.project_number;
796: psp_erd_shd.g_old_rec.project_id;
797: End If;
798: If (p_rec.project_number = hr_api.g_varchar2) then
799: p_rec.project_number :=
800: psp_erd_shd.g_old_rec.project_number;
801: End If;
802: If (p_rec.project_name = hr_api.g_varchar2) then
803: p_rec.project_name :=
804: psp_erd_shd.g_old_rec.project_name;
800: psp_erd_shd.g_old_rec.project_number;
801: End If;
802: If (p_rec.project_name = hr_api.g_varchar2) then
803: p_rec.project_name :=
804: psp_erd_shd.g_old_rec.project_name;
805: End If;
806: If (p_rec.expenditure_organization_id = hr_api.g_number) then
807: p_rec.expenditure_organization_id :=
808: psp_erd_shd.g_old_rec.expenditure_organization_id;
804: psp_erd_shd.g_old_rec.project_name;
805: End If;
806: If (p_rec.expenditure_organization_id = hr_api.g_number) then
807: p_rec.expenditure_organization_id :=
808: psp_erd_shd.g_old_rec.expenditure_organization_id;
809: End If;
810: If (p_rec.exp_org_name = hr_api.g_varchar2) then
811: p_rec.exp_org_name :=
812: psp_erd_shd.g_old_rec.exp_org_name;
808: psp_erd_shd.g_old_rec.expenditure_organization_id;
809: End If;
810: If (p_rec.exp_org_name = hr_api.g_varchar2) then
811: p_rec.exp_org_name :=
812: psp_erd_shd.g_old_rec.exp_org_name;
813: End If;
814: If (p_rec.expenditure_type = hr_api.g_varchar2) then
815: p_rec.expenditure_type :=
816: psp_erd_shd.g_old_rec.expenditure_type;
812: psp_erd_shd.g_old_rec.exp_org_name;
813: End If;
814: If (p_rec.expenditure_type = hr_api.g_varchar2) then
815: p_rec.expenditure_type :=
816: psp_erd_shd.g_old_rec.expenditure_type;
817: End If;
818: If (p_rec.task_id = hr_api.g_number) then
819: p_rec.task_id :=
820: psp_erd_shd.g_old_rec.task_id;
816: psp_erd_shd.g_old_rec.expenditure_type;
817: End If;
818: If (p_rec.task_id = hr_api.g_number) then
819: p_rec.task_id :=
820: psp_erd_shd.g_old_rec.task_id;
821: End If;
822: If (p_rec.task_number = hr_api.g_varchar2) then
823: p_rec.task_number :=
824: psp_erd_shd.g_old_rec.task_number;
820: psp_erd_shd.g_old_rec.task_id;
821: End If;
822: If (p_rec.task_number = hr_api.g_varchar2) then
823: p_rec.task_number :=
824: psp_erd_shd.g_old_rec.task_number;
825: End If;
826: If (p_rec.task_name = hr_api.g_varchar2) then
827: p_rec.task_name :=
828: psp_erd_shd.g_old_rec.task_name;
824: psp_erd_shd.g_old_rec.task_number;
825: End If;
826: If (p_rec.task_name = hr_api.g_varchar2) then
827: p_rec.task_name :=
828: psp_erd_shd.g_old_rec.task_name;
829: End If;
830: If (p_rec.award_id = hr_api.g_number) then
831: p_rec.award_id :=
832: psp_erd_shd.g_old_rec.award_id;
828: psp_erd_shd.g_old_rec.task_name;
829: End If;
830: If (p_rec.award_id = hr_api.g_number) then
831: p_rec.award_id :=
832: psp_erd_shd.g_old_rec.award_id;
833: End If;
834: If (p_rec.award_number = hr_api.g_varchar2) then
835: p_rec.award_number :=
836: psp_erd_shd.g_old_rec.award_number;
832: psp_erd_shd.g_old_rec.award_id;
833: End If;
834: If (p_rec.award_number = hr_api.g_varchar2) then
835: p_rec.award_number :=
836: psp_erd_shd.g_old_rec.award_number;
837: End If;
838: If (p_rec.award_short_name = hr_api.g_varchar2) then
839: p_rec.award_short_name :=
840: psp_erd_shd.g_old_rec.award_short_name;
836: psp_erd_shd.g_old_rec.award_number;
837: End If;
838: If (p_rec.award_short_name = hr_api.g_varchar2) then
839: p_rec.award_short_name :=
840: psp_erd_shd.g_old_rec.award_short_name;
841: End If;
842: If (p_rec.actual_salary_amt = hr_api.g_number) then
843: p_rec.actual_salary_amt :=
844: psp_erd_shd.g_old_rec.actual_salary_amt;
840: psp_erd_shd.g_old_rec.award_short_name;
841: End If;
842: If (p_rec.actual_salary_amt = hr_api.g_number) then
843: p_rec.actual_salary_amt :=
844: psp_erd_shd.g_old_rec.actual_salary_amt;
845: End If;
846: If (p_rec.payroll_percent = hr_api.g_number) then
847: p_rec.payroll_percent :=
848: psp_erd_shd.g_old_rec.payroll_percent;
844: psp_erd_shd.g_old_rec.actual_salary_amt;
845: End If;
846: If (p_rec.payroll_percent = hr_api.g_number) then
847: p_rec.payroll_percent :=
848: psp_erd_shd.g_old_rec.payroll_percent;
849: End If;
850: If (p_rec.proposed_salary_amt = hr_api.g_number) then
851: p_rec.proposed_salary_amt :=
852: psp_erd_shd.g_old_rec.proposed_salary_amt;
848: psp_erd_shd.g_old_rec.payroll_percent;
849: End If;
850: If (p_rec.proposed_salary_amt = hr_api.g_number) then
851: p_rec.proposed_salary_amt :=
852: psp_erd_shd.g_old_rec.proposed_salary_amt;
853: End If;
854: If (p_rec.proposed_effort_percent = hr_api.g_number) then
855: p_rec.proposed_effort_percent :=
856: psp_erd_shd.g_old_rec.proposed_effort_percent;
852: psp_erd_shd.g_old_rec.proposed_salary_amt;
853: End If;
854: If (p_rec.proposed_effort_percent = hr_api.g_number) then
855: p_rec.proposed_effort_percent :=
856: psp_erd_shd.g_old_rec.proposed_effort_percent;
857: End If;
858: If (p_rec.committed_cost_share = hr_api.g_number) then
859: p_rec.committed_cost_share :=
860: psp_erd_shd.g_old_rec.committed_cost_share;
856: psp_erd_shd.g_old_rec.proposed_effort_percent;
857: End If;
858: If (p_rec.committed_cost_share = hr_api.g_number) then
859: p_rec.committed_cost_share :=
860: psp_erd_shd.g_old_rec.committed_cost_share;
861: End If;
862: If (p_rec.schedule_start_date = hr_api.g_date) then
863: p_rec.schedule_start_date :=
864: psp_erd_shd.g_old_rec.schedule_start_date;
860: psp_erd_shd.g_old_rec.committed_cost_share;
861: End If;
862: If (p_rec.schedule_start_date = hr_api.g_date) then
863: p_rec.schedule_start_date :=
864: psp_erd_shd.g_old_rec.schedule_start_date;
865: End If;
866: If (p_rec.schedule_end_date = hr_api.g_date) then
867: p_rec.schedule_end_date :=
868: psp_erd_shd.g_old_rec.schedule_end_date;
864: psp_erd_shd.g_old_rec.schedule_start_date;
865: End If;
866: If (p_rec.schedule_end_date = hr_api.g_date) then
867: p_rec.schedule_end_date :=
868: psp_erd_shd.g_old_rec.schedule_end_date;
869: End If;
870: If (p_rec.ame_transaction_id = hr_api.g_varchar2) then
871: p_rec.ame_transaction_id :=
872: psp_erd_shd.g_old_rec.ame_transaction_id;
868: psp_erd_shd.g_old_rec.schedule_end_date;
869: End If;
870: If (p_rec.ame_transaction_id = hr_api.g_varchar2) then
871: p_rec.ame_transaction_id :=
872: psp_erd_shd.g_old_rec.ame_transaction_id;
873: End If;
874: If (p_rec.investigator_name = hr_api.g_varchar2) then
875: p_rec.investigator_name :=
876: psp_erd_shd.g_old_rec.investigator_name;
872: psp_erd_shd.g_old_rec.ame_transaction_id;
873: End If;
874: If (p_rec.investigator_name = hr_api.g_varchar2) then
875: p_rec.investigator_name :=
876: psp_erd_shd.g_old_rec.investigator_name;
877: End If;
878: If (p_rec.investigator_person_id = hr_api.g_number) then
879: p_rec.investigator_person_id :=
880: psp_erd_shd.g_old_rec.investigator_person_id;
876: psp_erd_shd.g_old_rec.investigator_name;
877: End If;
878: If (p_rec.investigator_person_id = hr_api.g_number) then
879: p_rec.investigator_person_id :=
880: psp_erd_shd.g_old_rec.investigator_person_id;
881: End If;
882: If (p_rec.investigator_org_name = hr_api.g_varchar2) then
883: p_rec.investigator_org_name :=
884: psp_erd_shd.g_old_rec.investigator_org_name;
880: psp_erd_shd.g_old_rec.investigator_person_id;
881: End If;
882: If (p_rec.investigator_org_name = hr_api.g_varchar2) then
883: p_rec.investigator_org_name :=
884: psp_erd_shd.g_old_rec.investigator_org_name;
885: End If;
886: If (p_rec.investigator_primary_org_id = hr_api.g_number) then
887: p_rec.investigator_primary_org_id :=
888: psp_erd_shd.g_old_rec.investigator_primary_org_id;
884: psp_erd_shd.g_old_rec.investigator_org_name;
885: End If;
886: If (p_rec.investigator_primary_org_id = hr_api.g_number) then
887: p_rec.investigator_primary_org_id :=
888: psp_erd_shd.g_old_rec.investigator_primary_org_id;
889: End If;
890: If (p_rec.value1 = hr_api.g_number) then
891: p_rec.value1 :=
892: psp_erd_shd.g_old_rec.value1;
888: psp_erd_shd.g_old_rec.investigator_primary_org_id;
889: End If;
890: If (p_rec.value1 = hr_api.g_number) then
891: p_rec.value1 :=
892: psp_erd_shd.g_old_rec.value1;
893: End If;
894: If (p_rec.value2 = hr_api.g_number) then
895: p_rec.value2 :=
896: psp_erd_shd.g_old_rec.value2;
892: psp_erd_shd.g_old_rec.value1;
893: End If;
894: If (p_rec.value2 = hr_api.g_number) then
895: p_rec.value2 :=
896: psp_erd_shd.g_old_rec.value2;
897: End If;
898: If (p_rec.value3 = hr_api.g_number) then
899: p_rec.value3 :=
900: psp_erd_shd.g_old_rec.value3;
896: psp_erd_shd.g_old_rec.value2;
897: End If;
898: If (p_rec.value3 = hr_api.g_number) then
899: p_rec.value3 :=
900: psp_erd_shd.g_old_rec.value3;
901: End If;
902: If (p_rec.value4 = hr_api.g_number) then
903: p_rec.value4 :=
904: psp_erd_shd.g_old_rec.value4;
900: psp_erd_shd.g_old_rec.value3;
901: End If;
902: If (p_rec.value4 = hr_api.g_number) then
903: p_rec.value4 :=
904: psp_erd_shd.g_old_rec.value4;
905: End If;
906: If (p_rec.value5 = hr_api.g_number) then
907: p_rec.value5 :=
908: psp_erd_shd.g_old_rec.value5;
904: psp_erd_shd.g_old_rec.value4;
905: End If;
906: If (p_rec.value5 = hr_api.g_number) then
907: p_rec.value5 :=
908: psp_erd_shd.g_old_rec.value5;
909: End If;
910: If (p_rec.value6 = hr_api.g_number) then
911: p_rec.value6 :=
912: psp_erd_shd.g_old_rec.value6;
908: psp_erd_shd.g_old_rec.value5;
909: End If;
910: If (p_rec.value6 = hr_api.g_number) then
911: p_rec.value6 :=
912: psp_erd_shd.g_old_rec.value6;
913: End If;
914: If (p_rec.value7 = hr_api.g_number) then
915: p_rec.value7 :=
916: psp_erd_shd.g_old_rec.value7;
912: psp_erd_shd.g_old_rec.value6;
913: End If;
914: If (p_rec.value7 = hr_api.g_number) then
915: p_rec.value7 :=
916: psp_erd_shd.g_old_rec.value7;
917: End If;
918: If (p_rec.value8 = hr_api.g_number) then
919: p_rec.value8 :=
920: psp_erd_shd.g_old_rec.value8;
916: psp_erd_shd.g_old_rec.value7;
917: End If;
918: If (p_rec.value8 = hr_api.g_number) then
919: p_rec.value8 :=
920: psp_erd_shd.g_old_rec.value8;
921: End If;
922: If (p_rec.value9 = hr_api.g_number) then
923: p_rec.value9 :=
924: psp_erd_shd.g_old_rec.value9;
920: psp_erd_shd.g_old_rec.value8;
921: End If;
922: If (p_rec.value9 = hr_api.g_number) then
923: p_rec.value9 :=
924: psp_erd_shd.g_old_rec.value9;
925: End If;
926: If (p_rec.value10 = hr_api.g_number) then
927: p_rec.value10 :=
928: psp_erd_shd.g_old_rec.value10;
924: psp_erd_shd.g_old_rec.value9;
925: End If;
926: If (p_rec.value10 = hr_api.g_number) then
927: p_rec.value10 :=
928: psp_erd_shd.g_old_rec.value10;
929: End If;
930: If (p_rec.attribute1 = hr_api.g_varchar2) then
931: p_rec.attribute1 :=
932: psp_erd_shd.g_old_rec.attribute1;
928: psp_erd_shd.g_old_rec.value10;
929: End If;
930: If (p_rec.attribute1 = hr_api.g_varchar2) then
931: p_rec.attribute1 :=
932: psp_erd_shd.g_old_rec.attribute1;
933: End If;
934: If (p_rec.attribute2 = hr_api.g_varchar2) then
935: p_rec.attribute2 :=
936: psp_erd_shd.g_old_rec.attribute2;
932: psp_erd_shd.g_old_rec.attribute1;
933: End If;
934: If (p_rec.attribute2 = hr_api.g_varchar2) then
935: p_rec.attribute2 :=
936: psp_erd_shd.g_old_rec.attribute2;
937: End If;
938: If (p_rec.attribute3 = hr_api.g_varchar2) then
939: p_rec.attribute3 :=
940: psp_erd_shd.g_old_rec.attribute3;
936: psp_erd_shd.g_old_rec.attribute2;
937: End If;
938: If (p_rec.attribute3 = hr_api.g_varchar2) then
939: p_rec.attribute3 :=
940: psp_erd_shd.g_old_rec.attribute3;
941: End If;
942: If (p_rec.attribute4 = hr_api.g_varchar2) then
943: p_rec.attribute4 :=
944: psp_erd_shd.g_old_rec.attribute4;
940: psp_erd_shd.g_old_rec.attribute3;
941: End If;
942: If (p_rec.attribute4 = hr_api.g_varchar2) then
943: p_rec.attribute4 :=
944: psp_erd_shd.g_old_rec.attribute4;
945: End If;
946: If (p_rec.attribute5 = hr_api.g_varchar2) then
947: p_rec.attribute5 :=
948: psp_erd_shd.g_old_rec.attribute5;
944: psp_erd_shd.g_old_rec.attribute4;
945: End If;
946: If (p_rec.attribute5 = hr_api.g_varchar2) then
947: p_rec.attribute5 :=
948: psp_erd_shd.g_old_rec.attribute5;
949: End If;
950: If (p_rec.attribute6 = hr_api.g_varchar2) then
951: p_rec.attribute6 :=
952: psp_erd_shd.g_old_rec.attribute6;
948: psp_erd_shd.g_old_rec.attribute5;
949: End If;
950: If (p_rec.attribute6 = hr_api.g_varchar2) then
951: p_rec.attribute6 :=
952: psp_erd_shd.g_old_rec.attribute6;
953: End If;
954: If (p_rec.attribute7 = hr_api.g_varchar2) then
955: p_rec.attribute7 :=
956: psp_erd_shd.g_old_rec.attribute7;
952: psp_erd_shd.g_old_rec.attribute6;
953: End If;
954: If (p_rec.attribute7 = hr_api.g_varchar2) then
955: p_rec.attribute7 :=
956: psp_erd_shd.g_old_rec.attribute7;
957: End If;
958: If (p_rec.attribute8 = hr_api.g_varchar2) then
959: p_rec.attribute8 :=
960: psp_erd_shd.g_old_rec.attribute8;
956: psp_erd_shd.g_old_rec.attribute7;
957: End If;
958: If (p_rec.attribute8 = hr_api.g_varchar2) then
959: p_rec.attribute8 :=
960: psp_erd_shd.g_old_rec.attribute8;
961: End If;
962: If (p_rec.attribute9 = hr_api.g_varchar2) then
963: p_rec.attribute9 :=
964: psp_erd_shd.g_old_rec.attribute9;
960: psp_erd_shd.g_old_rec.attribute8;
961: End If;
962: If (p_rec.attribute9 = hr_api.g_varchar2) then
963: p_rec.attribute9 :=
964: psp_erd_shd.g_old_rec.attribute9;
965: End If;
966: If (p_rec.attribute10 = hr_api.g_varchar2) then
967: p_rec.attribute10 :=
968: psp_erd_shd.g_old_rec.attribute10;
964: psp_erd_shd.g_old_rec.attribute9;
965: End If;
966: If (p_rec.attribute10 = hr_api.g_varchar2) then
967: p_rec.attribute10 :=
968: psp_erd_shd.g_old_rec.attribute10;
969: End If;
970: If (p_rec.grouping_category = hr_api.g_varchar2) then
971: p_rec.grouping_category :=
972: psp_erd_shd.g_old_rec.grouping_category;
968: psp_erd_shd.g_old_rec.attribute10;
969: End If;
970: If (p_rec.grouping_category = hr_api.g_varchar2) then
971: p_rec.grouping_category :=
972: psp_erd_shd.g_old_rec.grouping_category;
973: End If;
974: --
975: End convert_defs;
976: --
977: -- ----------------------------------------------------------------------------
978: -- |---------------------------------< upd >----------------------------------|
979: -- ----------------------------------------------------------------------------
980: Procedure upd
981: (p_rec in out nocopy psp_erd_shd.g_rec_type
982: ) is
983: --
984: l_proc varchar2(72) := g_package||'upd';
985: --
987: hr_utility.set_location('Entering:'||l_proc, 5);
988: --
989: -- We must lock the row which we need to update.
990: --
991: psp_erd_shd.lck
992: (p_rec.effort_report_detail_id
993: ,p_rec.object_version_number
994: );
995: --
1111: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1112: ,p_grouping_category in varchar2 default hr_api.g_varchar2
1113: ) is
1114: --
1115: l_rec psp_erd_shd.g_rec_type;
1116: l_proc varchar2(72) := g_package||'upd';
1117: --
1118: Begin
1119: hr_utility.set_location('Entering:'||l_proc, 5);
1121: -- Call conversion function to turn arguments into the
1122: -- l_rec structure.
1123: --
1124: l_rec :=
1125: psp_erd_shd.convert_args
1126: (p_effort_report_detail_id
1127: ,p_effort_report_id
1128: ,p_object_version_number
1129: ,p_assignment_id