APPS.PER_QH_POPULATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 88: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type

84: --
85: procedure get_bg_defaults
86: (p_business_group_id IN per_business_groups.business_group_id%type
87: ,p_defaulting IN varchar2
88: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
89: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
90: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
91: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
92: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 89: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type

85: procedure get_bg_defaults
86: (p_business_group_id IN per_business_groups.business_group_id%type
87: ,p_defaulting IN varchar2
88: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
89: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
90: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
91: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
92: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
93: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 90: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type

86: (p_business_group_id IN per_business_groups.business_group_id%type
87: ,p_defaulting IN varchar2
88: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
89: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
90: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
91: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
92: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
93: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
94: ,p_location OUT NOCOPY hr_locations.location_code%type

Line 91: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

87: ,p_defaulting IN varchar2
88: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
89: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
90: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
91: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
92: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
93: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
94: ,p_location OUT NOCOPY hr_locations.location_code%type
95: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type);

Line 93: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

89: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
90: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
91: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
92: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
93: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
94: ,p_location OUT NOCOPY hr_locations.location_code%type
95: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type);
96: --
97: -- ----------------------------------------------------------------------------

Line 102: (p_position_id IN per_all_assignments_f.position_id%type

98: -- |--------------------------< get_pos_defaults >----------------------------|
99: -- ----------------------------------------------------------------------------
100: --
101: procedure get_pos_defaults
102: (p_position_id IN per_all_assignments_f.position_id%type
103: ,p_effective_date IN date
104: ,p_defaulting IN varchar2
105: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
106: ,p_organization OUT NOCOPY hr_organization_units.name%type

Line 105: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type

101: procedure get_pos_defaults
102: (p_position_id IN per_all_assignments_f.position_id%type
103: ,p_effective_date IN date
104: ,p_defaulting IN varchar2
105: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
106: ,p_organization OUT NOCOPY hr_organization_units.name%type
107: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
108: ,p_job OUT NOCOPY per_jobs.name%type
109: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type

Line 107: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type

103: ,p_effective_date IN date
104: ,p_defaulting IN varchar2
105: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
106: ,p_organization OUT NOCOPY hr_organization_units.name%type
107: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
108: ,p_job OUT NOCOPY per_jobs.name%type
109: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
110: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
111: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

Line 111: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

107: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
108: ,p_job OUT NOCOPY per_jobs.name%type
109: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
110: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
111: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
112: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
113: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
114: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
115: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 112: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

108: ,p_job OUT NOCOPY per_jobs.name%type
109: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
110: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
111: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
112: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
113: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
114: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
115: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
116: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 113: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

109: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
110: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
111: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
112: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
113: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
114: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
115: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
116: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
117: ,p_location OUT NOCOPY hr_locations.location_code%type

Line 114: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

110: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
111: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
112: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
113: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
114: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
115: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
116: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
117: ,p_location OUT NOCOPY hr_locations.location_code%type
118: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

Line 116: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

112: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
113: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
114: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
115: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
116: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
117: ,p_location OUT NOCOPY hr_locations.location_code%type
118: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
119: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
120: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 118: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

114: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
115: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
116: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
117: ,p_location OUT NOCOPY hr_locations.location_code%type
118: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
119: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
120: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
121: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
122: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

Line 119: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

115: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
116: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
117: ,p_location OUT NOCOPY hr_locations.location_code%type
118: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
119: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
120: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
121: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
122: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
123: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

Line 121: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

117: ,p_location OUT NOCOPY hr_locations.location_code%type
118: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
119: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
120: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
121: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
122: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
123: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
124: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
125: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

Line 125: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

121: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
122: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
123: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
124: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
125: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
126: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
127: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
128: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
129: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type

Line 127: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

123: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
124: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
125: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
126: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
127: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
128: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
129: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
130: ,p_grade OUT NOCOPY per_grades.name%type
131: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

Line 129: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type

125: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
126: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
127: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
128: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
129: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
130: ,p_grade OUT NOCOPY per_grades.name%type
131: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
132: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
133: );

Line 131: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

127: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
128: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
129: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
130: ,p_grade OUT NOCOPY per_grades.name%type
131: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
132: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
133: );
134: --
135: -- ----------------------------------------------------------------------------

Line 140: (p_organization_id IN per_all_assignments_f.organization_id%type

136: -- |--------------------------< get_org_defaults >----------------------------|
137: -- ----------------------------------------------------------------------------
138: --
139: procedure get_org_defaults
140: (p_organization_id IN per_all_assignments_f.organization_id%type
141: ,p_defaulting IN varchar2
142: ,p_effective_date IN date
143: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
144: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type

Line 145: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

141: ,p_defaulting IN varchar2
142: ,p_effective_date IN date
143: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
144: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
145: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
146: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
147: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
148: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
149: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 146: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

142: ,p_effective_date IN date
143: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
144: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
145: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
146: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
147: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
148: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
149: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
150: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 147: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

143: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
144: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
145: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
146: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
147: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
148: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
149: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
150: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
151: ,p_location OUT NOCOPY hr_locations.location_code%type

Line 148: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

144: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
145: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
146: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
147: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
148: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
149: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
150: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
151: ,p_location OUT NOCOPY hr_locations.location_code%type
152: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

Line 150: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

146: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
147: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
148: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
149: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
150: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
151: ,p_location OUT NOCOPY hr_locations.location_code%type
152: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
153: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
154: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 152: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

148: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
149: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
150: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
151: ,p_location OUT NOCOPY hr_locations.location_code%type
152: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
153: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
154: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
155: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
156: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

Line 153: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

149: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
150: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
151: ,p_location OUT NOCOPY hr_locations.location_code%type
152: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
153: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
154: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
155: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
156: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
157: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

Line 155: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

151: ,p_location OUT NOCOPY hr_locations.location_code%type
152: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
153: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
154: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
155: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
156: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
157: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
158: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
159: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

Line 159: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

155: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
156: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
157: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
158: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
159: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
160: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
161: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
162: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
163: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

Line 161: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

157: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
158: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
159: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
160: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
161: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
162: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
163: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
164: );
165: --

Line 163: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

159: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
160: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
161: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
162: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
163: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
164: );
165: --
166: -- ----------------------------------------------------------------------------
167: -- |--------------------------< get_vac_defaults >----------------------------|

Line 171: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type

167: -- |--------------------------< get_vac_defaults >----------------------------|
168: -- ----------------------------------------------------------------------------
169: --
170: procedure get_vac_defaults
171: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
172: ,p_defaulting IN varchar2
173: ,p_effective_date IN date
174: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
175: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type

Line 174: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type

170: procedure get_vac_defaults
171: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
172: ,p_defaulting IN varchar2
173: ,p_effective_date IN date
174: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
175: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
176: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
177: ,p_grade OUT NOCOPY per_grades.name%type
178: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

Line 176: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type

172: ,p_defaulting IN varchar2
173: ,p_effective_date IN date
174: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
175: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
176: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
177: ,p_grade OUT NOCOPY per_grades.name%type
178: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
179: ,p_position OUT NOCOPY hr_all_positions_f.name%type
180: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type

Line 178: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

174: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
175: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
176: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
177: ,p_grade OUT NOCOPY per_grades.name%type
178: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
179: ,p_position OUT NOCOPY hr_all_positions_f.name%type
180: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
181: ,p_job OUT NOCOPY per_jobs.name%type
182: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 180: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type

176: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
177: ,p_grade OUT NOCOPY per_grades.name%type
178: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
179: ,p_position OUT NOCOPY hr_all_positions_f.name%type
180: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
181: ,p_job OUT NOCOPY per_jobs.name%type
182: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
183: ,p_location OUT NOCOPY hr_locations.location_code%type
184: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type

Line 182: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

178: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
179: ,p_position OUT NOCOPY hr_all_positions_f.name%type
180: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
181: ,p_job OUT NOCOPY per_jobs.name%type
182: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
183: ,p_location OUT NOCOPY hr_locations.location_code%type
184: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
185: ,p_organization OUT NOCOPY hr_organization_units.name%type
186: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

Line 184: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type

180: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
181: ,p_job OUT NOCOPY per_jobs.name%type
182: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
183: ,p_location OUT NOCOPY hr_locations.location_code%type
184: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
185: ,p_organization OUT NOCOPY hr_organization_units.name%type
186: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
187: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

Line 186: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

182: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
183: ,p_location OUT NOCOPY hr_locations.location_code%type
184: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
185: ,p_organization OUT NOCOPY hr_organization_units.name%type
186: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
187: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
189: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
190: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 187: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

183: ,p_location OUT NOCOPY hr_locations.location_code%type
184: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
185: ,p_organization OUT NOCOPY hr_organization_units.name%type
186: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
187: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
189: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
190: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
191: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

Line 188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

184: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
185: ,p_organization OUT NOCOPY hr_organization_units.name%type
186: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
187: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
189: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
190: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
191: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
192: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

Line 189: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

185: ,p_organization OUT NOCOPY hr_organization_units.name%type
186: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
187: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
189: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
190: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
191: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
192: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
193: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 191: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

187: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
189: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
190: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
191: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
192: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
193: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
194: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
195: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

Line 192: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

188: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
189: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
190: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
191: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
192: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
193: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
194: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
195: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
196: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

Line 194: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

190: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
191: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
192: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
193: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
194: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
195: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
196: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
197: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
198: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

Line 198: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

194: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
195: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
196: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
197: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
198: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
199: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
200: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
201: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
202: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

Line 200: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

196: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
197: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
198: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
199: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
200: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
201: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
202: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
203: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
204: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type

Line 202: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

198: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
199: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
200: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
201: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
202: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
203: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
204: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
205: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
206: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type

Line 204: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type

200: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
201: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
202: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
203: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
204: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
205: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
206: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type
207: ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%type
208: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type