APPS.PSP_PEE_UPD dependencies on HR_API

Line 111: When hr_api.check_integrity_violated Then

107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: psp_pee_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: psp_pee_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: psp_pee_shd.constraint_error

Line 116: When hr_api.parent_integrity_violated Then

112: -- A check constraint has been violated
113: --
114: psp_pee_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: psp_pee_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: psp_pee_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: psp_pee_shd.constraint_error

Line 121: When hr_api.unique_integrity_violated Then

117: -- Parent integrity has been violated
118: --
119: psp_pee_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: psp_pee_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: psp_pee_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;
129: End update_dml;

Line 348: when hr_api.cannot_find_prog_unit then

344: );
345: --
346: exception
347: --
348: when hr_api.cannot_find_prog_unit then
349: --
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'PSP_EXTERNAL_EFFORT_LINES'
352: ,p_hook_type => 'AU');

Line 350: hr_api.cannot_find_prog_unit_error

346: exception
347: --
348: when hr_api.cannot_find_prog_unit then
349: --
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'PSP_EXTERNAL_EFFORT_LINES'
352: ,p_hook_type => 'AU');
353: --
354: end;

Line 413: If (p_rec.batch_name = hr_api.g_varchar2) then

409: -- p_rec plsql record structure
410: -- to see if a system default is being used. If a system default
411: -- is being used then we must set to the 'current' argument value.
412: --
413: If (p_rec.batch_name = hr_api.g_varchar2) then
414: p_rec.batch_name :=
415: psp_pee_shd.g_old_rec.batch_name;
416: End If;
417: If (p_rec.distribution_date = hr_api.g_date) then

Line 417: If (p_rec.distribution_date = hr_api.g_date) then

413: If (p_rec.batch_name = hr_api.g_varchar2) then
414: p_rec.batch_name :=
415: psp_pee_shd.g_old_rec.batch_name;
416: End If;
417: If (p_rec.distribution_date = hr_api.g_date) then
418: p_rec.distribution_date :=
419: psp_pee_shd.g_old_rec.distribution_date;
420: End If;
421: If (p_rec.person_id = hr_api.g_number) then

Line 421: If (p_rec.person_id = hr_api.g_number) then

417: If (p_rec.distribution_date = hr_api.g_date) then
418: p_rec.distribution_date :=
419: psp_pee_shd.g_old_rec.distribution_date;
420: End If;
421: If (p_rec.person_id = hr_api.g_number) then
422: p_rec.person_id :=
423: psp_pee_shd.g_old_rec.person_id;
424: End If;
425: If (p_rec.assignment_id = hr_api.g_number) then

Line 425: If (p_rec.assignment_id = hr_api.g_number) then

421: If (p_rec.person_id = hr_api.g_number) then
422: p_rec.person_id :=
423: psp_pee_shd.g_old_rec.person_id;
424: End If;
425: If (p_rec.assignment_id = hr_api.g_number) then
426: p_rec.assignment_id :=
427: psp_pee_shd.g_old_rec.assignment_id;
428: End If;
429: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 429: If (p_rec.currency_code = hr_api.g_varchar2) then

425: If (p_rec.assignment_id = hr_api.g_number) then
426: p_rec.assignment_id :=
427: psp_pee_shd.g_old_rec.assignment_id;
428: End If;
429: If (p_rec.currency_code = hr_api.g_varchar2) then
430: p_rec.currency_code :=
431: psp_pee_shd.g_old_rec.currency_code;
432: End If;
433: If (p_rec.distribution_amount = hr_api.g_number) then

Line 433: If (p_rec.distribution_amount = hr_api.g_number) then

429: If (p_rec.currency_code = hr_api.g_varchar2) then
430: p_rec.currency_code :=
431: psp_pee_shd.g_old_rec.currency_code;
432: End If;
433: If (p_rec.distribution_amount = hr_api.g_number) then
434: p_rec.distribution_amount :=
435: psp_pee_shd.g_old_rec.distribution_amount;
436: End If;
437: If (p_rec.business_group_id = hr_api.g_number) then

Line 437: If (p_rec.business_group_id = hr_api.g_number) then

433: If (p_rec.distribution_amount = hr_api.g_number) then
434: p_rec.distribution_amount :=
435: psp_pee_shd.g_old_rec.distribution_amount;
436: End If;
437: If (p_rec.business_group_id = hr_api.g_number) then
438: p_rec.business_group_id :=
439: psp_pee_shd.g_old_rec.business_group_id;
440: End If;
441: If (p_rec.set_of_books_id = hr_api.g_number) then

Line 441: If (p_rec.set_of_books_id = hr_api.g_number) then

437: If (p_rec.business_group_id = hr_api.g_number) then
438: p_rec.business_group_id :=
439: psp_pee_shd.g_old_rec.business_group_id;
440: End If;
441: If (p_rec.set_of_books_id = hr_api.g_number) then
442: p_rec.set_of_books_id :=
443: psp_pee_shd.g_old_rec.set_of_books_id;
444: End If;
445: If (p_rec.gl_code_combination_id = hr_api.g_number) then

Line 445: If (p_rec.gl_code_combination_id = hr_api.g_number) then

441: If (p_rec.set_of_books_id = hr_api.g_number) then
442: p_rec.set_of_books_id :=
443: psp_pee_shd.g_old_rec.set_of_books_id;
444: End If;
445: If (p_rec.gl_code_combination_id = hr_api.g_number) then
446: p_rec.gl_code_combination_id :=
447: psp_pee_shd.g_old_rec.gl_code_combination_id;
448: End If;
449: If (p_rec.project_id = hr_api.g_number) then

Line 449: If (p_rec.project_id = hr_api.g_number) then

445: If (p_rec.gl_code_combination_id = hr_api.g_number) then
446: p_rec.gl_code_combination_id :=
447: psp_pee_shd.g_old_rec.gl_code_combination_id;
448: End If;
449: If (p_rec.project_id = hr_api.g_number) then
450: p_rec.project_id :=
451: psp_pee_shd.g_old_rec.project_id;
452: End If;
453: If (p_rec.task_id = hr_api.g_number) then

Line 453: If (p_rec.task_id = hr_api.g_number) then

449: If (p_rec.project_id = hr_api.g_number) then
450: p_rec.project_id :=
451: psp_pee_shd.g_old_rec.project_id;
452: End If;
453: If (p_rec.task_id = hr_api.g_number) then
454: p_rec.task_id :=
455: psp_pee_shd.g_old_rec.task_id;
456: End If;
457: If (p_rec.award_id = hr_api.g_number) then

Line 457: If (p_rec.award_id = hr_api.g_number) then

453: If (p_rec.task_id = hr_api.g_number) then
454: p_rec.task_id :=
455: psp_pee_shd.g_old_rec.task_id;
456: End If;
457: If (p_rec.award_id = hr_api.g_number) then
458: p_rec.award_id :=
459: psp_pee_shd.g_old_rec.award_id;
460: End If;
461: If (p_rec.expenditure_organization_id = hr_api.g_number) then

Line 461: If (p_rec.expenditure_organization_id = hr_api.g_number) then

457: If (p_rec.award_id = hr_api.g_number) then
458: p_rec.award_id :=
459: psp_pee_shd.g_old_rec.award_id;
460: End If;
461: If (p_rec.expenditure_organization_id = hr_api.g_number) then
462: p_rec.expenditure_organization_id :=
463: psp_pee_shd.g_old_rec.expenditure_organization_id;
464: End If;
465: If (p_rec.expenditure_type = hr_api.g_varchar2) then

Line 465: If (p_rec.expenditure_type = hr_api.g_varchar2) then

461: If (p_rec.expenditure_organization_id = hr_api.g_number) then
462: p_rec.expenditure_organization_id :=
463: psp_pee_shd.g_old_rec.expenditure_organization_id;
464: End If;
465: If (p_rec.expenditure_type = hr_api.g_varchar2) then
466: p_rec.expenditure_type :=
467: psp_pee_shd.g_old_rec.expenditure_type;
468: End If;
469: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 469: If (p_rec.attribute_category = hr_api.g_varchar2) then

465: If (p_rec.expenditure_type = hr_api.g_varchar2) then
466: p_rec.expenditure_type :=
467: psp_pee_shd.g_old_rec.expenditure_type;
468: End If;
469: If (p_rec.attribute_category = hr_api.g_varchar2) then
470: p_rec.attribute_category :=
471: psp_pee_shd.g_old_rec.attribute_category;
472: End If;
473: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 473: If (p_rec.attribute1 = hr_api.g_varchar2) then

469: If (p_rec.attribute_category = hr_api.g_varchar2) then
470: p_rec.attribute_category :=
471: psp_pee_shd.g_old_rec.attribute_category;
472: End If;
473: If (p_rec.attribute1 = hr_api.g_varchar2) then
474: p_rec.attribute1 :=
475: psp_pee_shd.g_old_rec.attribute1;
476: End If;
477: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 477: If (p_rec.attribute2 = hr_api.g_varchar2) then

473: If (p_rec.attribute1 = hr_api.g_varchar2) then
474: p_rec.attribute1 :=
475: psp_pee_shd.g_old_rec.attribute1;
476: End If;
477: If (p_rec.attribute2 = hr_api.g_varchar2) then
478: p_rec.attribute2 :=
479: psp_pee_shd.g_old_rec.attribute2;
480: End If;
481: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 481: If (p_rec.attribute3 = hr_api.g_varchar2) then

477: If (p_rec.attribute2 = hr_api.g_varchar2) then
478: p_rec.attribute2 :=
479: psp_pee_shd.g_old_rec.attribute2;
480: End If;
481: If (p_rec.attribute3 = hr_api.g_varchar2) then
482: p_rec.attribute3 :=
483: psp_pee_shd.g_old_rec.attribute3;
484: End If;
485: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 485: If (p_rec.attribute4 = hr_api.g_varchar2) then

481: If (p_rec.attribute3 = hr_api.g_varchar2) then
482: p_rec.attribute3 :=
483: psp_pee_shd.g_old_rec.attribute3;
484: End If;
485: If (p_rec.attribute4 = hr_api.g_varchar2) then
486: p_rec.attribute4 :=
487: psp_pee_shd.g_old_rec.attribute4;
488: End If;
489: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 489: If (p_rec.attribute5 = hr_api.g_varchar2) then

485: If (p_rec.attribute4 = hr_api.g_varchar2) then
486: p_rec.attribute4 :=
487: psp_pee_shd.g_old_rec.attribute4;
488: End If;
489: If (p_rec.attribute5 = hr_api.g_varchar2) then
490: p_rec.attribute5 :=
491: psp_pee_shd.g_old_rec.attribute5;
492: End If;
493: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 493: If (p_rec.attribute6 = hr_api.g_varchar2) then

489: If (p_rec.attribute5 = hr_api.g_varchar2) then
490: p_rec.attribute5 :=
491: psp_pee_shd.g_old_rec.attribute5;
492: End If;
493: If (p_rec.attribute6 = hr_api.g_varchar2) then
494: p_rec.attribute6 :=
495: psp_pee_shd.g_old_rec.attribute6;
496: End If;
497: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 497: If (p_rec.attribute7 = hr_api.g_varchar2) then

493: If (p_rec.attribute6 = hr_api.g_varchar2) then
494: p_rec.attribute6 :=
495: psp_pee_shd.g_old_rec.attribute6;
496: End If;
497: If (p_rec.attribute7 = hr_api.g_varchar2) then
498: p_rec.attribute7 :=
499: psp_pee_shd.g_old_rec.attribute7;
500: End If;
501: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 501: If (p_rec.attribute8 = hr_api.g_varchar2) then

497: If (p_rec.attribute7 = hr_api.g_varchar2) then
498: p_rec.attribute7 :=
499: psp_pee_shd.g_old_rec.attribute7;
500: End If;
501: If (p_rec.attribute8 = hr_api.g_varchar2) then
502: p_rec.attribute8 :=
503: psp_pee_shd.g_old_rec.attribute8;
504: End If;
505: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 505: If (p_rec.attribute9 = hr_api.g_varchar2) then

501: If (p_rec.attribute8 = hr_api.g_varchar2) then
502: p_rec.attribute8 :=
503: psp_pee_shd.g_old_rec.attribute8;
504: End If;
505: If (p_rec.attribute9 = hr_api.g_varchar2) then
506: p_rec.attribute9 :=
507: psp_pee_shd.g_old_rec.attribute9;
508: End If;
509: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 509: If (p_rec.attribute10 = hr_api.g_varchar2) then

505: If (p_rec.attribute9 = hr_api.g_varchar2) then
506: p_rec.attribute9 :=
507: psp_pee_shd.g_old_rec.attribute9;
508: End If;
509: If (p_rec.attribute10 = hr_api.g_varchar2) then
510: p_rec.attribute10 :=
511: psp_pee_shd.g_old_rec.attribute10;
512: End If;
513: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 513: If (p_rec.attribute11 = hr_api.g_varchar2) then

509: If (p_rec.attribute10 = hr_api.g_varchar2) then
510: p_rec.attribute10 :=
511: psp_pee_shd.g_old_rec.attribute10;
512: End If;
513: If (p_rec.attribute11 = hr_api.g_varchar2) then
514: p_rec.attribute11 :=
515: psp_pee_shd.g_old_rec.attribute11;
516: End If;
517: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 517: If (p_rec.attribute12 = hr_api.g_varchar2) then

513: If (p_rec.attribute11 = hr_api.g_varchar2) then
514: p_rec.attribute11 :=
515: psp_pee_shd.g_old_rec.attribute11;
516: End If;
517: If (p_rec.attribute12 = hr_api.g_varchar2) then
518: p_rec.attribute12 :=
519: psp_pee_shd.g_old_rec.attribute12;
520: End If;
521: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 521: If (p_rec.attribute13 = hr_api.g_varchar2) then

517: If (p_rec.attribute12 = hr_api.g_varchar2) then
518: p_rec.attribute12 :=
519: psp_pee_shd.g_old_rec.attribute12;
520: End If;
521: If (p_rec.attribute13 = hr_api.g_varchar2) then
522: p_rec.attribute13 :=
523: psp_pee_shd.g_old_rec.attribute13;
524: End If;
525: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 525: If (p_rec.attribute14 = hr_api.g_varchar2) then

521: If (p_rec.attribute13 = hr_api.g_varchar2) then
522: p_rec.attribute13 :=
523: psp_pee_shd.g_old_rec.attribute13;
524: End If;
525: If (p_rec.attribute14 = hr_api.g_varchar2) then
526: p_rec.attribute14 :=
527: psp_pee_shd.g_old_rec.attribute14;
528: End If;
529: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 529: If (p_rec.attribute15 = hr_api.g_varchar2) then

525: If (p_rec.attribute14 = hr_api.g_varchar2) then
526: p_rec.attribute14 :=
527: psp_pee_shd.g_old_rec.attribute14;
528: End If;
529: If (p_rec.attribute15 = hr_api.g_varchar2) then
530: p_rec.attribute15 :=
531: psp_pee_shd.g_old_rec.attribute15;
532: End If;
533: --

Line 593: ,p_batch_name in varchar2 default hr_api.g_varchar2

589: -- ----------------------------------------------------------------------------
590: Procedure upd
591: (p_external_effort_line_id in number
592: ,p_object_version_number in out nocopy number
593: ,p_batch_name in varchar2 default hr_api.g_varchar2
594: ,p_distribution_date in date default hr_api.g_date
595: ,p_person_id in number default hr_api.g_number
596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 594: ,p_distribution_date in date default hr_api.g_date

590: Procedure upd
591: (p_external_effort_line_id in number
592: ,p_object_version_number in out nocopy number
593: ,p_batch_name in varchar2 default hr_api.g_varchar2
594: ,p_distribution_date in date default hr_api.g_date
595: ,p_person_id in number default hr_api.g_number
596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number

Line 595: ,p_person_id in number default hr_api.g_number

591: (p_external_effort_line_id in number
592: ,p_object_version_number in out nocopy number
593: ,p_batch_name in varchar2 default hr_api.g_varchar2
594: ,p_distribution_date in date default hr_api.g_date
595: ,p_person_id in number default hr_api.g_number
596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number

Line 596: ,p_assignment_id in number default hr_api.g_number

592: ,p_object_version_number in out nocopy number
593: ,p_batch_name in varchar2 default hr_api.g_varchar2
594: ,p_distribution_date in date default hr_api.g_date
595: ,p_person_id in number default hr_api.g_number
596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number

Line 597: ,p_currency_code in varchar2 default hr_api.g_varchar2

593: ,p_batch_name in varchar2 default hr_api.g_varchar2
594: ,p_distribution_date in date default hr_api.g_date
595: ,p_person_id in number default hr_api.g_number
596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number

Line 598: ,p_distribution_amount in number default hr_api.g_number

594: ,p_distribution_date in date default hr_api.g_date
595: ,p_person_id in number default hr_api.g_number
596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number

Line 599: ,p_business_group_id in number default hr_api.g_number

595: ,p_person_id in number default hr_api.g_number
596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number

Line 600: ,p_set_of_books_id in number default hr_api.g_number

596: ,p_assignment_id in number default hr_api.g_number
597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number

Line 601: ,p_gl_code_combination_id in number default hr_api.g_number

597: ,p_currency_code in varchar2 default hr_api.g_varchar2
598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number

Line 602: ,p_project_id in number default hr_api.g_number

598: ,p_distribution_amount in number default hr_api.g_number
599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2

Line 603: ,p_task_id in number default hr_api.g_number

599: ,p_business_group_id in number default hr_api.g_number
600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 604: ,p_award_id in number default hr_api.g_number

600: ,p_set_of_books_id in number default hr_api.g_number
601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 605: ,p_expenditure_organization_id in number default hr_api.g_number

601: ,p_gl_code_combination_id in number default hr_api.g_number
602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2

602: ,p_project_id in number default hr_api.g_number
603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 607: ,p_attribute_category in varchar2 default hr_api.g_varchar2

603: ,p_task_id in number default hr_api.g_number
604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 608: ,p_attribute1 in varchar2 default hr_api.g_varchar2

604: ,p_award_id in number default hr_api.g_number
605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 609: ,p_attribute2 in varchar2 default hr_api.g_varchar2

605: ,p_expenditure_organization_id in number default hr_api.g_number
606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 610: ,p_attribute3 in varchar2 default hr_api.g_varchar2

606: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 611: ,p_attribute4 in varchar2 default hr_api.g_varchar2

607: ,p_attribute_category in varchar2 default hr_api.g_varchar2
608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 612: ,p_attribute5 in varchar2 default hr_api.g_varchar2

608: ,p_attribute1 in varchar2 default hr_api.g_varchar2
609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 613: ,p_attribute6 in varchar2 default hr_api.g_varchar2

609: ,p_attribute2 in varchar2 default hr_api.g_varchar2
610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 614: ,p_attribute7 in varchar2 default hr_api.g_varchar2

610: ,p_attribute3 in varchar2 default hr_api.g_varchar2
611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 615: ,p_attribute8 in varchar2 default hr_api.g_varchar2

611: ,p_attribute4 in varchar2 default hr_api.g_varchar2
612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 616: ,p_attribute9 in varchar2 default hr_api.g_varchar2

612: ,p_attribute5 in varchar2 default hr_api.g_varchar2
613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2
620: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 617: ,p_attribute10 in varchar2 default hr_api.g_varchar2

613: ,p_attribute6 in varchar2 default hr_api.g_varchar2
614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2
620: ,p_attribute13 in varchar2 default hr_api.g_varchar2
621: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 618: ,p_attribute11 in varchar2 default hr_api.g_varchar2

614: ,p_attribute7 in varchar2 default hr_api.g_varchar2
615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2
620: ,p_attribute13 in varchar2 default hr_api.g_varchar2
621: ,p_attribute14 in varchar2 default hr_api.g_varchar2
622: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 619: ,p_attribute12 in varchar2 default hr_api.g_varchar2

615: ,p_attribute8 in varchar2 default hr_api.g_varchar2
616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2
620: ,p_attribute13 in varchar2 default hr_api.g_varchar2
621: ,p_attribute14 in varchar2 default hr_api.g_varchar2
622: ,p_attribute15 in varchar2 default hr_api.g_varchar2
623: ) is

Line 620: ,p_attribute13 in varchar2 default hr_api.g_varchar2

616: ,p_attribute9 in varchar2 default hr_api.g_varchar2
617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2
620: ,p_attribute13 in varchar2 default hr_api.g_varchar2
621: ,p_attribute14 in varchar2 default hr_api.g_varchar2
622: ,p_attribute15 in varchar2 default hr_api.g_varchar2
623: ) is
624: --

Line 621: ,p_attribute14 in varchar2 default hr_api.g_varchar2

617: ,p_attribute10 in varchar2 default hr_api.g_varchar2
618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2
620: ,p_attribute13 in varchar2 default hr_api.g_varchar2
621: ,p_attribute14 in varchar2 default hr_api.g_varchar2
622: ,p_attribute15 in varchar2 default hr_api.g_varchar2
623: ) is
624: --
625: l_rec psp_pee_shd.g_rec_type;

Line 622: ,p_attribute15 in varchar2 default hr_api.g_varchar2

618: ,p_attribute11 in varchar2 default hr_api.g_varchar2
619: ,p_attribute12 in varchar2 default hr_api.g_varchar2
620: ,p_attribute13 in varchar2 default hr_api.g_varchar2
621: ,p_attribute14 in varchar2 default hr_api.g_varchar2
622: ,p_attribute15 in varchar2 default hr_api.g_varchar2
623: ) is
624: --
625: l_rec psp_pee_shd.g_rec_type;
626: l_proc varchar2(72) := g_package||'upd';