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

APPS.PAY_COST_ALLOCATION_API dependencies on HR_API

Line 118: When HR_Api.Object_Locked then

114: end if;
115: --
116: hr_utility.set_location('Leaving:'|| l_proc, 30);
117: Exception
118: When HR_Api.Object_Locked then
119: --
120: -- This autonomous transaction was unable to lock the row.
121: -- It can be assumed that another transaction has locked the
122: -- row and is performing the update. Hence the error can

Line 307: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then

303: -- -- check whether any segment is not required for flexfield and value has been
304: -- -- assigned for the same.
305: -- for i in 1..30 loop
306: -- if l_required_segment(i) = 'N' then
307: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then
308: -- --
309: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
310: -- hr_utility.set_message_token('PROCEDURE', l_proc);
311: -- hr_utility.set_message_token('STEP','20');

Line 461: when hr_api.cannot_find_prog_unit then

457: ,p_program_update_date => p_program_update_date
458:
459: );
460: exception
461: when hr_api.cannot_find_prog_unit then
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'CREATE_COST_ALLOCATION'
464: ,p_hook_type => 'BP'
465: );

Line 462: hr_api.cannot_find_prog_unit_error

458:
459: );
460: exception
461: when hr_api.cannot_find_prog_unit then
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'CREATE_COST_ALLOCATION'
464: ,p_hook_type => 'BP'
465: );
466: end;

Line 471: hr_api.validate_bus_grp_id(p_business_group_id);

467: --
468: -- Need to set CLIENT_INFO as HR_LOOKUPS may be referenced
469: -- by SEGMENT Value Sets.
470: --
471: hr_api.validate_bus_grp_id(p_business_group_id);
472: --
473: open csr_cost_structure;
474: fetch csr_cost_structure into l_flex_num;
475: if csr_cost_structure%notfound then

Line 663: when hr_api.cannot_find_prog_unit then

659: ,p_object_version_number => l_object_version_number
660: ,p_cost_allocation_keyflex_id => l_cost_allocation_keyflex_id
661: );
662: exception
663: when hr_api.cannot_find_prog_unit then
664: hr_api.cannot_find_prog_unit_error
665: (p_module_name => 'CREATE_COST_ALLOCATION'
666: ,p_hook_type => 'AP'
667: );

Line 664: hr_api.cannot_find_prog_unit_error

660: ,p_cost_allocation_keyflex_id => l_cost_allocation_keyflex_id
661: );
662: exception
663: when hr_api.cannot_find_prog_unit then
664: hr_api.cannot_find_prog_unit_error
665: (p_module_name => 'CREATE_COST_ALLOCATION'
666: ,p_hook_type => 'AP'
667: );
668: end;

Line 673: raise hr_api.validate_enabled;

669: --
670: -- When in validation only mode raise the Validate_Enabled exception
671: --
672: if p_validate then
673: raise hr_api.validate_enabled;
674: end if;
675: --
676: -- Set all output arguments
677: --

Line 687: when hr_api.validate_enabled then

683: p_object_version_number := l_object_version_number;
684: --
685: hr_utility.set_location(' Leaving:'||l_proc, 70);
686: exception
687: when hr_api.validate_enabled then
688: --
689: -- As the Validate_Enabled exception has been raised
690: -- we must rollback to the savepoint
691: --

Line 734: ,p_proportion in number default hr_api.g_number

730: ,p_effective_date in date
731: ,p_datetrack_update_mode in varchar2
732: ,p_cost_allocation_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_proportion in number default hr_api.g_number
735: ,p_segment1 in varchar2 default hr_api.g_varchar2
736: ,p_segment2 in varchar2 default hr_api.g_varchar2
737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 735: ,p_segment1 in varchar2 default hr_api.g_varchar2

731: ,p_datetrack_update_mode in varchar2
732: ,p_cost_allocation_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_proportion in number default hr_api.g_number
735: ,p_segment1 in varchar2 default hr_api.g_varchar2
736: ,p_segment2 in varchar2 default hr_api.g_varchar2
737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 736: ,p_segment2 in varchar2 default hr_api.g_varchar2

732: ,p_cost_allocation_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_proportion in number default hr_api.g_number
735: ,p_segment1 in varchar2 default hr_api.g_varchar2
736: ,p_segment2 in varchar2 default hr_api.g_varchar2
737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 737: ,p_segment3 in varchar2 default hr_api.g_varchar2

733: ,p_object_version_number in out nocopy number
734: ,p_proportion in number default hr_api.g_number
735: ,p_segment1 in varchar2 default hr_api.g_varchar2
736: ,p_segment2 in varchar2 default hr_api.g_varchar2
737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 738: ,p_segment4 in varchar2 default hr_api.g_varchar2

734: ,p_proportion in number default hr_api.g_number
735: ,p_segment1 in varchar2 default hr_api.g_varchar2
736: ,p_segment2 in varchar2 default hr_api.g_varchar2
737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 739: ,p_segment5 in varchar2 default hr_api.g_varchar2

735: ,p_segment1 in varchar2 default hr_api.g_varchar2
736: ,p_segment2 in varchar2 default hr_api.g_varchar2
737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 740: ,p_segment6 in varchar2 default hr_api.g_varchar2

736: ,p_segment2 in varchar2 default hr_api.g_varchar2
737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 741: ,p_segment7 in varchar2 default hr_api.g_varchar2

737: ,p_segment3 in varchar2 default hr_api.g_varchar2
738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 742: ,p_segment8 in varchar2 default hr_api.g_varchar2

738: ,p_segment4 in varchar2 default hr_api.g_varchar2
739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 743: ,p_segment9 in varchar2 default hr_api.g_varchar2

739: ,p_segment5 in varchar2 default hr_api.g_varchar2
740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 744: ,p_segment10 in varchar2 default hr_api.g_varchar2

740: ,p_segment6 in varchar2 default hr_api.g_varchar2
741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 745: ,p_segment11 in varchar2 default hr_api.g_varchar2

741: ,p_segment7 in varchar2 default hr_api.g_varchar2
742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 746: ,p_segment12 in varchar2 default hr_api.g_varchar2

742: ,p_segment8 in varchar2 default hr_api.g_varchar2
743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 747: ,p_segment13 in varchar2 default hr_api.g_varchar2

743: ,p_segment9 in varchar2 default hr_api.g_varchar2
744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 748: ,p_segment14 in varchar2 default hr_api.g_varchar2

744: ,p_segment10 in varchar2 default hr_api.g_varchar2
745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 749: ,p_segment15 in varchar2 default hr_api.g_varchar2

745: ,p_segment11 in varchar2 default hr_api.g_varchar2
746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 750: ,p_segment16 in varchar2 default hr_api.g_varchar2

746: ,p_segment12 in varchar2 default hr_api.g_varchar2
747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 751: ,p_segment17 in varchar2 default hr_api.g_varchar2

747: ,p_segment13 in varchar2 default hr_api.g_varchar2
748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 752: ,p_segment18 in varchar2 default hr_api.g_varchar2

748: ,p_segment14 in varchar2 default hr_api.g_varchar2
749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 753: ,p_segment19 in varchar2 default hr_api.g_varchar2

749: ,p_segment15 in varchar2 default hr_api.g_varchar2
750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 754: ,p_segment20 in varchar2 default hr_api.g_varchar2

750: ,p_segment16 in varchar2 default hr_api.g_varchar2
751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 755: ,p_segment21 in varchar2 default hr_api.g_varchar2

751: ,p_segment17 in varchar2 default hr_api.g_varchar2
752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 756: ,p_segment22 in varchar2 default hr_api.g_varchar2

752: ,p_segment18 in varchar2 default hr_api.g_varchar2
753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 757: ,p_segment23 in varchar2 default hr_api.g_varchar2

753: ,p_segment19 in varchar2 default hr_api.g_varchar2
754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 758: ,p_segment24 in varchar2 default hr_api.g_varchar2

754: ,p_segment20 in varchar2 default hr_api.g_varchar2
755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 759: ,p_segment25 in varchar2 default hr_api.g_varchar2

755: ,p_segment21 in varchar2 default hr_api.g_varchar2
756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 760: ,p_segment26 in varchar2 default hr_api.g_varchar2

756: ,p_segment22 in varchar2 default hr_api.g_varchar2
757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 761: ,p_segment27 in varchar2 default hr_api.g_varchar2

757: ,p_segment23 in varchar2 default hr_api.g_varchar2
758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 762: ,p_segment28 in varchar2 default hr_api.g_varchar2

758: ,p_segment24 in varchar2 default hr_api.g_varchar2
759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number

Line 763: ,p_segment29 in varchar2 default hr_api.g_varchar2

759: ,p_segment25 in varchar2 default hr_api.g_varchar2
760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number
767: ,p_program_application_id in number default hr_api.g_number

Line 764: ,p_segment30 in varchar2 default hr_api.g_varchar2

760: ,p_segment26 in varchar2 default hr_api.g_varchar2
761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number
767: ,p_program_application_id in number default hr_api.g_number
768: ,p_program_id in number default hr_api.g_number

Line 765: ,p_concat_segments in varchar2 default hr_api.g_varchar2

761: ,p_segment27 in varchar2 default hr_api.g_varchar2
762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number
767: ,p_program_application_id in number default hr_api.g_number
768: ,p_program_id in number default hr_api.g_number
769: ,p_program_update_date in date default hr_api.g_date

Line 766: ,p_request_id in number default hr_api.g_number

762: ,p_segment28 in varchar2 default hr_api.g_varchar2
763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number
767: ,p_program_application_id in number default hr_api.g_number
768: ,p_program_id in number default hr_api.g_number
769: ,p_program_update_date in date default hr_api.g_date
770: ,p_combination_name out nocopy varchar2

Line 767: ,p_program_application_id in number default hr_api.g_number

763: ,p_segment29 in varchar2 default hr_api.g_varchar2
764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number
767: ,p_program_application_id in number default hr_api.g_number
768: ,p_program_id in number default hr_api.g_number
769: ,p_program_update_date in date default hr_api.g_date
770: ,p_combination_name out nocopy varchar2
771: ,p_cost_allocation_keyflex_id in out nocopy number

Line 768: ,p_program_id in number default hr_api.g_number

764: ,p_segment30 in varchar2 default hr_api.g_varchar2
765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number
767: ,p_program_application_id in number default hr_api.g_number
768: ,p_program_id in number default hr_api.g_number
769: ,p_program_update_date in date default hr_api.g_date
770: ,p_combination_name out nocopy varchar2
771: ,p_cost_allocation_keyflex_id in out nocopy number
772: ,p_effective_start_date out nocopy date

Line 769: ,p_program_update_date in date default hr_api.g_date

765: ,p_concat_segments in varchar2 default hr_api.g_varchar2
766: ,p_request_id in number default hr_api.g_number
767: ,p_program_application_id in number default hr_api.g_number
768: ,p_program_id in number default hr_api.g_number
769: ,p_program_update_date in date default hr_api.g_date
770: ,p_combination_name out nocopy varchar2
771: ,p_cost_allocation_keyflex_id in out nocopy number
772: ,p_effective_start_date out nocopy date
773: ,p_effective_end_date out nocopy date

Line 902: if (l_new_segment(i) = hr_api.g_varchar2) then

898: --
899: -- Make null to all segment default value
900: --
901: for i in 1..30 loop
902: if (l_new_segment(i) = hr_api.g_varchar2) then
903: -- if default value then retain previous value from database
904: l_new_segment(i) := nvl(l_previous_segment(i),null);
905: else
906: -- call the flex code if and only if any one of the segment or the

Line 907: -- concatenated segment is not hr_api.g_varchar2.

903: -- if default value then retain previous value from database
904: l_new_segment(i) := nvl(l_previous_segment(i),null);
905: else
906: -- call the flex code if and only if any one of the segment or the
907: -- concatenated segment is not hr_api.g_varchar2.
908: --
909: l_validate_flex := TRUE;
910: end if;
911: end loop;

Line 959: when hr_api.cannot_find_prog_unit then

955: ,p_program_id => p_program_id
956: ,p_program_update_date => p_program_update_date
957: );
958: exception
959: when hr_api.cannot_find_prog_unit then
960: hr_api.cannot_find_prog_unit_error
961: (p_module_name => 'UPDATE_COST_ALLOCATION'
962: ,p_hook_type => 'BP'
963: );

Line 960: hr_api.cannot_find_prog_unit_error

956: ,p_program_update_date => p_program_update_date
957: );
958: exception
959: when hr_api.cannot_find_prog_unit then
960: hr_api.cannot_find_prog_unit_error
961: (p_module_name => 'UPDATE_COST_ALLOCATION'
962: ,p_hook_type => 'BP'
963: );
964: end;

Line 984: hr_api.validate_bus_grp_id(l_business_group_id);

980: --
981: -- Need to set CLIENT_INFO as HR_LOOKUPS may be referenced
982: -- by SEGMENT Value Sets.
983: --
984: hr_api.validate_bus_grp_id(l_business_group_id);
985: --
986: open csr_cost_structure(l_business_group_id);
987: fetch csr_cost_structure into l_flex_num;
988: if csr_cost_structure%notfound then

Line 1054: -- concatenated segment is not hr_api.g_varchar2.

1050: ,p_concatenated_segments => l_combination_name
1051: );
1052: */
1053: -- Validate the key flex field only if any one of the segment or the
1054: -- concatenated segment is not hr_api.g_varchar2.
1055:
1056: if (l_validate_flex or (p_concat_segments <> hr_api.g_varchar2)) then
1057:
1058: -- check mandatory segment

Line 1056: if (l_validate_flex or (p_concat_segments <> hr_api.g_varchar2)) then

1052: */
1053: -- Validate the key flex field only if any one of the segment or the
1054: -- concatenated segment is not hr_api.g_varchar2.
1055:
1056: if (l_validate_flex or (p_concat_segments <> hr_api.g_varchar2)) then
1057:
1058: -- check mandatory segment
1059: check_mandatory_segments(
1060: p_level =>'ASSIGNMENT',

Line 1067: if p_concat_segments = hr_api.g_varchar2 then

1063: p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id);
1064:
1065: -- if concatenated segment has default value then assign it null
1066: --
1067: if p_concat_segments = hr_api.g_varchar2 then
1068: l_concat_segments := null;
1069: else
1070: l_concat_segments := p_concat_segments;
1071: end if;

Line 1194: when hr_api.cannot_find_prog_unit then

1190: ,p_effective_end_date => l_effective_end_date
1191: ,p_cost_allocation_keyflex_id => l_cost_allocation_keyflex_id
1192: );
1193: exception
1194: when hr_api.cannot_find_prog_unit then
1195: hr_api.cannot_find_prog_unit_error
1196: (p_module_name => 'UPDATE_COST_ALLOCATION'
1197: ,p_hook_type => 'AP'
1198: );

Line 1195: hr_api.cannot_find_prog_unit_error

1191: ,p_cost_allocation_keyflex_id => l_cost_allocation_keyflex_id
1192: );
1193: exception
1194: when hr_api.cannot_find_prog_unit then
1195: hr_api.cannot_find_prog_unit_error
1196: (p_module_name => 'UPDATE_COST_ALLOCATION'
1197: ,p_hook_type => 'AP'
1198: );
1199: end;

Line 1204: raise hr_api.validate_enabled;

1200: --
1201: -- When in validation only mode raise the Validate_Enabled exception
1202: --
1203: if p_validate then
1204: raise hr_api.validate_enabled;
1205: end if;
1206: --
1207: -- Set all output arguments
1208: --

Line 1217: when hr_api.validate_enabled then

1213: p_object_version_number := l_object_version_number;
1214: --
1215: hr_utility.set_location(' Leaving:'||l_proc, 70);
1216: exception
1217: when hr_api.validate_enabled then
1218: --
1219: -- As the Validate_Enabled exception has been raised
1220: -- we must rollback to the savepoint
1221: --

Line 1299: when hr_api.cannot_find_prog_unit then

1295: ,p_cost_allocation_id => p_cost_allocation_id
1296: ,p_object_version_number => l_object_version_number
1297: );
1298: exception
1299: when hr_api.cannot_find_prog_unit then
1300: hr_api.cannot_find_prog_unit_error
1301: (p_module_name => 'DELETE_COST_ALLOCATION'
1302: ,p_hook_type => 'BP'
1303: );

Line 1300: hr_api.cannot_find_prog_unit_error

1296: ,p_object_version_number => l_object_version_number
1297: );
1298: exception
1299: when hr_api.cannot_find_prog_unit then
1300: hr_api.cannot_find_prog_unit_error
1301: (p_module_name => 'DELETE_COST_ALLOCATION'
1302: ,p_hook_type => 'BP'
1303: );
1304: end;

Line 1329: when hr_api.cannot_find_prog_unit then

1325: ,p_effective_start_date => l_effective_start_date
1326: ,p_effective_end_date => l_effective_end_date
1327: );
1328: exception
1329: when hr_api.cannot_find_prog_unit then
1330: hr_api.cannot_find_prog_unit_error
1331: (p_module_name => 'DELETE_COST_ALLOCATION'
1332: ,p_hook_type => 'AP'
1333: );

Line 1330: hr_api.cannot_find_prog_unit_error

1326: ,p_effective_end_date => l_effective_end_date
1327: );
1328: exception
1329: when hr_api.cannot_find_prog_unit then
1330: hr_api.cannot_find_prog_unit_error
1331: (p_module_name => 'DELETE_COST_ALLOCATION'
1332: ,p_hook_type => 'AP'
1333: );
1334: end;

Line 1339: raise hr_api.validate_enabled;

1335: --
1336: -- When in validation only mode raise the Validate_Enabled exception
1337: --
1338: if p_validate then
1339: raise hr_api.validate_enabled;
1340: end if;
1341: --
1342: -- Set all output arguments
1343: --

Line 1350: when hr_api.validate_enabled then

1346: p_object_version_number := l_object_version_number;
1347: --
1348: hr_utility.set_location(' Leaving:'||l_proc, 70);
1349: exception
1350: when hr_api.validate_enabled then
1351: --
1352: -- As the Validate_Enabled exception has been raised
1353: -- we must rollback to the savepoint
1354: --