DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_COMMON_SAVE_WEB dependencies on PER_ALL_ASSIGNMENTS_F

Line 124: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

120: ,p_pgp_segment29 in varchar2 default null
121: ,p_pgp_segment30 in varchar2 default null
122:
123: --
124: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
125: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
126: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
127: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
128: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

Line 125: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

121: ,p_pgp_segment30 in varchar2 default null
122:
123: --
124: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
125: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
126: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
127: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
128: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
129: ,p_person_id in per_all_assignments_f.person_id%TYPE

Line 126: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

122:
123: --
124: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
125: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
126: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
127: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
128: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
129: ,p_person_id in per_all_assignments_f.person_id%TYPE
130: ,p_effective_start_date out nocopy date

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

123: --
124: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
125: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
126: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
127: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
128: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
129: ,p_person_id in per_all_assignments_f.person_id%TYPE
130: ,p_effective_start_date out nocopy date
131: ,p_effective_end_date out nocopy date

Line 128: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

124: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
125: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
126: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
127: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
128: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
129: ,p_person_id in per_all_assignments_f.person_id%TYPE
130: ,p_effective_start_date out nocopy date
131: ,p_effective_end_date out nocopy date
132: ,p_element_warning in boolean

Line 129: ,p_person_id in per_all_assignments_f.person_id%TYPE

125: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
126: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
127: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
128: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
129: ,p_person_id in per_all_assignments_f.person_id%TYPE
130: ,p_effective_start_date out nocopy date
131: ,p_effective_end_date out nocopy date
132: ,p_element_warning in boolean
133: ,p_element_changed in out nocopy varchar2

Line 139: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype

135: );
136: --
137: procedure get_asg_from_tt
138: (p_transaction_step_id in number
139: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype
140: );
141: --
142: procedure get_pgp_from_tt
143: (p_transaction_step_id in number

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

150: );
151: --
152: procedure get_asg_from_asg(p_assignment_id in number
153: ,p_effective_date in date
154: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);
155: --
156: procedure get_pgp_from_pgp(p_people_group_id in number
157: ,p_pgp_rec out nocopy pay_people_groups%rowtype);
158: --

Line 165: ,p_assignment_id in per_all_assignments_f.assignment_id%type

161: --
162: procedure get_asg(
163: p_item_type in wf_items.item_type%TYPE
164: ,p_item_key in wf_items.item_key%TYPE
165: ,p_assignment_id in per_all_assignments_f.assignment_id%type
166: ,p_effective_date in date
167: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);
168: --
169: procedure get_step(

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

163: p_item_type in wf_items.item_type%TYPE
164: ,p_item_key in wf_items.item_key%TYPE
165: ,p_assignment_id in per_all_assignments_f.assignment_id%type
166: ,p_effective_date in date
167: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);
168: --
169: procedure get_step(
170: p_item_type in wf_items.item_type%TYPE
171: ,p_item_key in wf_items.item_key%TYPE