DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);

22:
23: --
24: procedure get_asg_from_tt
25: (p_transaction_step_id in number
26: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);
27: --
28: procedure get_assignment_from_tt
29: (p_item_type in varchar2
30: ,p_item_key in varchar2

Line 590: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

586: ,p_job_post_source_name in varchar2 default null
587: ,p_perf_review_period in number default null
588: ,p_perf_review_period_frequency in varchar2 default null
589: ,p_internal_address_line in varchar2 default null
590: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
591: --GSP change
592: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
593: -- End of GSP change
594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

Line 592: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE

588: ,p_perf_review_period_frequency in varchar2 default null
589: ,p_internal_address_line in varchar2 default null
590: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
591: --GSP change
592: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
593: -- End of GSP change
594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
595: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
596: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE

Line 594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

590: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
591: --GSP change
592: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
593: -- End of GSP change
594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
595: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
596: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
597: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
598: ,p_person_id in per_all_assignments_f.person_id%TYPE

Line 595: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

591: --GSP change
592: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
593: -- End of GSP change
594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
595: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
596: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
597: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
598: ,p_person_id in per_all_assignments_f.person_id%TYPE
599: ,p_effective_start_date out nocopy date

Line 596: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE

592: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
593: -- End of GSP change
594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
595: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
596: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
597: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
598: ,p_person_id in per_all_assignments_f.person_id%TYPE
599: ,p_effective_start_date out nocopy date
600: ,p_effective_end_date out nocopy date

Line 597: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

593: -- End of GSP change
594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
595: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
596: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
597: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
598: ,p_person_id in per_all_assignments_f.person_id%TYPE
599: ,p_effective_start_date out nocopy date
600: ,p_effective_end_date out nocopy date
601: ,p_element_warning in boolean

Line 598: ,p_person_id in per_all_assignments_f.person_id%TYPE

594: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
595: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
596: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
597: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
598: ,p_person_id in per_all_assignments_f.person_id%TYPE
599: ,p_effective_start_date out nocopy date
600: ,p_effective_end_date out nocopy date
601: ,p_element_warning in boolean
602: ,p_element_changed in out nocopy varchar2

Line 641: p_assignment_rec in out nocopy per_all_assignments_f%rowtype,

637: );
638:
639: procedure update_apl_assignment
640: (p_validate in boolean default false,
641: p_assignment_rec in out nocopy per_all_assignments_f%rowtype,
642: p_effective_date in date,
643: p_person_id in number,
644: p_appl_assignment_id in number,
645: p_person_type_id in number,