APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 59: p_business_group_id in per_all_assignments_f.business_group_id%type,

55:
56: -- This function returns the termination reason from the user tables.
57: function get_termination_reason
58: (
59: p_business_group_id in per_all_assignments_f.business_group_id%type,
60: p_report_date in per_all_assignments_f.effective_end_date%type,
61: p_reason_code in per_periods_of_service.leaving_reason%type
62: ) return varchar2;
63:

Line 60: p_report_date in per_all_assignments_f.effective_end_date%type,

56: -- This function returns the termination reason from the user tables.
57: function get_termination_reason
58: (
59: p_business_group_id in per_all_assignments_f.business_group_id%type,
60: p_report_date in per_all_assignments_f.effective_end_date%type,
61: p_reason_code in per_periods_of_service.leaving_reason%type
62: ) return varchar2;
63:
64: -- This procedure resets all the data structures for the Income Differentials report.

Line 70: p_report_date in per_all_assignments_f.effective_end_date%type,

66:
67: -- This function returns the average 5 highest paid employees per category or level.
68: function get_avg_5_highest_salary
69: (
70: p_report_date in per_all_assignments_f.effective_end_date%type,
71: p_business_group_id in per_all_assignments_f.business_group_id%type,
72: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
73: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
74: p_occupational_level_cat in hr_lookups.meaning%type,

Line 71: p_business_group_id in per_all_assignments_f.business_group_id%type,

67: -- This function returns the average 5 highest paid employees per category or level.
68: function get_avg_5_highest_salary
69: (
70: p_report_date in per_all_assignments_f.effective_end_date%type,
71: p_business_group_id in per_all_assignments_f.business_group_id%type,
72: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
73: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
74: p_occupational_level_cat in hr_lookups.meaning%type,
75: p_lookup_code in hr_lookups.lookup_code%type,

Line 83: p_report_date in per_all_assignments_f.effective_end_date%type,

79:
80: -- This function returns the average 5 lowest paid employees per category or level.
81: function get_avg_5_lowest_salary
82: (
83: p_report_date in per_all_assignments_f.effective_end_date%type,
84: p_business_group_id in per_all_assignments_f.business_group_id%type,
85: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
86: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
87: p_occupational_level_cat in hr_lookups.meaning%type,

Line 84: p_business_group_id in per_all_assignments_f.business_group_id%type,

80: -- This function returns the average 5 lowest paid employees per category or level.
81: function get_avg_5_lowest_salary
82: (
83: p_report_date in per_all_assignments_f.effective_end_date%type,
84: p_business_group_id in per_all_assignments_f.business_group_id%type,
85: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
86: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
87: p_occupational_level_cat in hr_lookups.meaning%type,
88: p_lookup_code in hr_lookups.lookup_code%type,

Line 97: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type

93: -- This function returns the person's legislated employment type (permanent or non-permanent)
94: function get_ee_employment_type_name
95: (
96: p_report_date in per_all_people_f.start_date%type,
97: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type
98: ) return varchar2;
99:
100: -- This function returns the occupational categories from the user tables.
101: function get_occupational_category

Line 103: p_report_date in per_all_assignments_f.effective_end_date%type,

99:
100: -- This function returns the occupational categories from the user tables.
101: function get_occupational_category
102: (
103: p_report_date in per_all_assignments_f.effective_end_date%type,
104: p_assignment_id in per_all_assignments_f.assignment_id%type,
105: p_job_id in per_all_assignments_f.job_id%type,
106: p_grade_id in per_all_assignments_f.grade_id%type,
107: p_position_id in per_all_assignments_f.position_id%type,

Line 104: p_assignment_id in per_all_assignments_f.assignment_id%type,

100: -- This function returns the occupational categories from the user tables.
101: function get_occupational_category
102: (
103: p_report_date in per_all_assignments_f.effective_end_date%type,
104: p_assignment_id in per_all_assignments_f.assignment_id%type,
105: p_job_id in per_all_assignments_f.job_id%type,
106: p_grade_id in per_all_assignments_f.grade_id%type,
107: p_position_id in per_all_assignments_f.position_id%type,
108: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 105: p_job_id in per_all_assignments_f.job_id%type,

101: function get_occupational_category
102: (
103: p_report_date in per_all_assignments_f.effective_end_date%type,
104: p_assignment_id in per_all_assignments_f.assignment_id%type,
105: p_job_id in per_all_assignments_f.job_id%type,
106: p_grade_id in per_all_assignments_f.grade_id%type,
107: p_position_id in per_all_assignments_f.position_id%type,
108: p_business_group_id in per_all_assignments_f.business_group_id%type
109: ) return varchar2;

Line 106: p_grade_id in per_all_assignments_f.grade_id%type,

102: (
103: p_report_date in per_all_assignments_f.effective_end_date%type,
104: p_assignment_id in per_all_assignments_f.assignment_id%type,
105: p_job_id in per_all_assignments_f.job_id%type,
106: p_grade_id in per_all_assignments_f.grade_id%type,
107: p_position_id in per_all_assignments_f.position_id%type,
108: p_business_group_id in per_all_assignments_f.business_group_id%type
109: ) return varchar2;
110:

Line 107: p_position_id in per_all_assignments_f.position_id%type,

103: p_report_date in per_all_assignments_f.effective_end_date%type,
104: p_assignment_id in per_all_assignments_f.assignment_id%type,
105: p_job_id in per_all_assignments_f.job_id%type,
106: p_grade_id in per_all_assignments_f.grade_id%type,
107: p_position_id in per_all_assignments_f.position_id%type,
108: p_business_group_id in per_all_assignments_f.business_group_id%type
109: ) return varchar2;
110:
111: -- This function returns the occupational levels from the user tables.

Line 108: p_business_group_id in per_all_assignments_f.business_group_id%type

104: p_assignment_id in per_all_assignments_f.assignment_id%type,
105: p_job_id in per_all_assignments_f.job_id%type,
106: p_grade_id in per_all_assignments_f.grade_id%type,
107: p_position_id in per_all_assignments_f.position_id%type,
108: p_business_group_id in per_all_assignments_f.business_group_id%type
109: ) return varchar2;
110:
111: -- This function returns the occupational levels from the user tables.
112: function get_occupational_level

Line 114: p_report_date in per_all_assignments_f.effective_end_date%type,

110:
111: -- This function returns the occupational levels from the user tables.
112: function get_occupational_level
113: (
114: p_report_date in per_all_assignments_f.effective_end_date%type,
115: p_assignment_id in per_all_assignments_f.assignment_id%type,
116: p_job_id in per_all_assignments_f.job_id%type,
117: p_grade_id in per_all_assignments_f.grade_id%type,
118: p_position_id in per_all_assignments_f.position_id%type,

Line 115: p_assignment_id in per_all_assignments_f.assignment_id%type,

111: -- This function returns the occupational levels from the user tables.
112: function get_occupational_level
113: (
114: p_report_date in per_all_assignments_f.effective_end_date%type,
115: p_assignment_id in per_all_assignments_f.assignment_id%type,
116: p_job_id in per_all_assignments_f.job_id%type,
117: p_grade_id in per_all_assignments_f.grade_id%type,
118: p_position_id in per_all_assignments_f.position_id%type,
119: p_business_group_id in per_all_assignments_f.business_group_id%type,

Line 116: p_job_id in per_all_assignments_f.job_id%type,

112: function get_occupational_level
113: (
114: p_report_date in per_all_assignments_f.effective_end_date%type,
115: p_assignment_id in per_all_assignments_f.assignment_id%type,
116: p_job_id in per_all_assignments_f.job_id%type,
117: p_grade_id in per_all_assignments_f.grade_id%type,
118: p_position_id in per_all_assignments_f.position_id%type,
119: p_business_group_id in per_all_assignments_f.business_group_id%type,
120: p_year in number default 2000

Line 117: p_grade_id in per_all_assignments_f.grade_id%type,

113: (
114: p_report_date in per_all_assignments_f.effective_end_date%type,
115: p_assignment_id in per_all_assignments_f.assignment_id%type,
116: p_job_id in per_all_assignments_f.job_id%type,
117: p_grade_id in per_all_assignments_f.grade_id%type,
118: p_position_id in per_all_assignments_f.position_id%type,
119: p_business_group_id in per_all_assignments_f.business_group_id%type,
120: p_year in number default 2000
121: ) return varchar2;

Line 118: p_position_id in per_all_assignments_f.position_id%type,

114: p_report_date in per_all_assignments_f.effective_end_date%type,
115: p_assignment_id in per_all_assignments_f.assignment_id%type,
116: p_job_id in per_all_assignments_f.job_id%type,
117: p_grade_id in per_all_assignments_f.grade_id%type,
118: p_position_id in per_all_assignments_f.position_id%type,
119: p_business_group_id in per_all_assignments_f.business_group_id%type,
120: p_year in number default 2000
121: ) return varchar2;
122:

Line 119: p_business_group_id in per_all_assignments_f.business_group_id%type,

115: p_assignment_id in per_all_assignments_f.assignment_id%type,
116: p_job_id in per_all_assignments_f.job_id%type,
117: p_grade_id in per_all_assignments_f.grade_id%type,
118: p_position_id in per_all_assignments_f.position_id%type,
119: p_business_group_id in per_all_assignments_f.business_group_id%type,
120: p_year in number default 2000
121: ) return varchar2;
122:
123: -- This function retrieves the occupational data via dynamic sql from the appropriate flexfield segment

Line 129: p_job_id in per_all_assignments_f.job_id%type,

125: (
126: p_type in varchar2,
127: p_flex in varchar2,
128: p_segment in varchar2,
129: p_job_id in per_all_assignments_f.job_id%type,
130: p_grade_id in per_all_assignments_f.grade_id%type,
131: p_position_id in per_all_assignments_f.position_id%type
132: ) return varchar2;
133:

Line 130: p_grade_id in per_all_assignments_f.grade_id%type,

126: p_type in varchar2,
127: p_flex in varchar2,
128: p_segment in varchar2,
129: p_job_id in per_all_assignments_f.job_id%type,
130: p_grade_id in per_all_assignments_f.grade_id%type,
131: p_position_id in per_all_assignments_f.position_id%type
132: ) return varchar2;
133:
134: -- This procedure caches the location of the occupational category and level data.

Line 131: p_position_id in per_all_assignments_f.position_id%type

127: p_flex in varchar2,
128: p_segment in varchar2,
129: p_job_id in per_all_assignments_f.job_id%type,
130: p_grade_id in per_all_assignments_f.grade_id%type,
131: p_position_id in per_all_assignments_f.position_id%type
132: ) return varchar2;
133:
134: -- This procedure caches the location of the occupational category and level data.
135: procedure cache_occupational_location

Line 138: p_business_group_id in per_all_assignments_f.business_group_id%type,

134: -- This procedure caches the location of the occupational category and level data.
135: procedure cache_occupational_location
136: (
137: p_report_date in date,
138: p_business_group_id in per_all_assignments_f.business_group_id%type,
139: p_year in number default 2000
140: );
141:
142: -- This function returns the lookup_code from the user tables.

Line 152: p_report_date in per_all_assignments_f.effective_end_date%type,

148: -- This function populates an entity's sex and race and category matches.
149: procedure populate_ee_table
150: (
151: p_report_code in varchar2,
152: p_report_date in per_all_assignments_f.effective_end_date%type,
153: p_business_group_id in per_all_assignments_f.business_group_id%type,
154: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
155: );
156:

Line 153: p_business_group_id in per_all_assignments_f.business_group_id%type,

149: procedure populate_ee_table
150: (
151: p_report_code in varchar2,
152: p_report_date in per_all_assignments_f.effective_end_date%type,
153: p_business_group_id in per_all_assignments_f.business_group_id%type,
154: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
155: );
156:
157: -- This function retrieves the functional data via dynamic sql from the appropriate flexfield segment

Line 162: p_job_id in per_all_assignments_f.job_id%type,

158: function get_functional_data
159: (
160: p_flex in varchar2,
161: p_segment in varchar2,
162: p_job_id in per_all_assignments_f.job_id%type,
163: p_grade_id in per_all_assignments_f.grade_id%type,
164: p_position_id in per_all_assignments_f.position_id%type
165: ) return varchar2;
166:

Line 163: p_grade_id in per_all_assignments_f.grade_id%type,

159: (
160: p_flex in varchar2,
161: p_segment in varchar2,
162: p_job_id in per_all_assignments_f.job_id%type,
163: p_grade_id in per_all_assignments_f.grade_id%type,
164: p_position_id in per_all_assignments_f.position_id%type
165: ) return varchar2;
166:
167:

Line 164: p_position_id in per_all_assignments_f.position_id%type

160: p_flex in varchar2,
161: p_segment in varchar2,
162: p_job_id in per_all_assignments_f.job_id%type,
163: p_grade_id in per_all_assignments_f.grade_id%type,
164: p_position_id in per_all_assignments_f.position_id%type
165: ) return varchar2;
166:
167:
168: function get_functional_type

Line 170: p_report_date in per_all_assignments_f.effective_end_date%type,

166:
167:
168: function get_functional_type
169: (
170: p_report_date in per_all_assignments_f.effective_end_date%type,
171: p_assignment_id in per_all_assignments_f.assignment_id%type,
172: p_job_id in per_all_assignments_f.job_id%type,
173: p_grade_id in per_all_assignments_f.grade_id%type,
174: p_position_id in per_all_assignments_f.position_id%type,

Line 171: p_assignment_id in per_all_assignments_f.assignment_id%type,

167:
168: function get_functional_type
169: (
170: p_report_date in per_all_assignments_f.effective_end_date%type,
171: p_assignment_id in per_all_assignments_f.assignment_id%type,
172: p_job_id in per_all_assignments_f.job_id%type,
173: p_grade_id in per_all_assignments_f.grade_id%type,
174: p_position_id in per_all_assignments_f.position_id%type,
175: p_business_group_id in per_all_assignments_f.business_group_id%type,

Line 172: p_job_id in per_all_assignments_f.job_id%type,

168: function get_functional_type
169: (
170: p_report_date in per_all_assignments_f.effective_end_date%type,
171: p_assignment_id in per_all_assignments_f.assignment_id%type,
172: p_job_id in per_all_assignments_f.job_id%type,
173: p_grade_id in per_all_assignments_f.grade_id%type,
174: p_position_id in per_all_assignments_f.position_id%type,
175: p_business_group_id in per_all_assignments_f.business_group_id%type,
176: p_year in number default 2000

Line 173: p_grade_id in per_all_assignments_f.grade_id%type,

169: (
170: p_report_date in per_all_assignments_f.effective_end_date%type,
171: p_assignment_id in per_all_assignments_f.assignment_id%type,
172: p_job_id in per_all_assignments_f.job_id%type,
173: p_grade_id in per_all_assignments_f.grade_id%type,
174: p_position_id in per_all_assignments_f.position_id%type,
175: p_business_group_id in per_all_assignments_f.business_group_id%type,
176: p_year in number default 2000
177: ) return varchar2;

Line 174: p_position_id in per_all_assignments_f.position_id%type,

170: p_report_date in per_all_assignments_f.effective_end_date%type,
171: p_assignment_id in per_all_assignments_f.assignment_id%type,
172: p_job_id in per_all_assignments_f.job_id%type,
173: p_grade_id in per_all_assignments_f.grade_id%type,
174: p_position_id in per_all_assignments_f.position_id%type,
175: p_business_group_id in per_all_assignments_f.business_group_id%type,
176: p_year in number default 2000
177: ) return varchar2;
178:

Line 175: p_business_group_id in per_all_assignments_f.business_group_id%type,

171: p_assignment_id in per_all_assignments_f.assignment_id%type,
172: p_job_id in per_all_assignments_f.job_id%type,
173: p_grade_id in per_all_assignments_f.grade_id%type,
174: p_position_id in per_all_assignments_f.position_id%type,
175: p_business_group_id in per_all_assignments_f.business_group_id%type,
176: p_year in number default 2000
177: ) return varchar2;
178:
179: -- Report will call this procedure which n terms call the populate_ee_table

Line 182: p_report_date in per_all_assignments_f.effective_end_date%type,

178:
179: -- Report will call this procedure which n terms call the populate_ee_table
180: procedure populate_ee_table_EEWF
181: (
182: p_report_date in per_all_assignments_f.effective_end_date%type,
183: p_business_group_id in per_all_assignments_f.business_group_id%type,
184: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
185: );
186:

Line 183: p_business_group_id in per_all_assignments_f.business_group_id%type,

179: -- Report will call this procedure which n terms call the populate_ee_table
180: procedure populate_ee_table_EEWF
181: (
182: p_report_date in per_all_assignments_f.effective_end_date%type,
183: p_business_group_id in per_all_assignments_f.business_group_id%type,
184: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
185: );
186:
187:

Line 227: p_report_date in per_all_assignments_f.effective_end_date%type,

223: ) ;
224:
225: procedure init_g_cat_lev_table
226: (
227: p_report_date in per_all_assignments_f.effective_end_date%type,
228: p_business_group_id in per_all_assignments_f.business_group_id%type,
229: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
230: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
231: );

Line 228: p_business_group_id in per_all_assignments_f.business_group_id%type,

224:
225: procedure init_g_cat_lev_table
226: (
227: p_report_date in per_all_assignments_f.effective_end_date%type,
228: p_business_group_id in per_all_assignments_f.business_group_id%type,
229: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
230: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
231: );
232:

Line 235: p_report_date in per_all_assignments_f.effective_end_date%type,

231: );
232:
233: procedure init_g_cat_lev_new_table
234: (
235: p_report_date in per_all_assignments_f.effective_end_date%type,
236: p_business_group_id in per_all_assignments_f.business_group_id%type,
237: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
238: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
239: );

Line 236: p_business_group_id in per_all_assignments_f.business_group_id%type,

232:
233: procedure init_g_cat_lev_new_table
234: (
235: p_report_date in per_all_assignments_f.effective_end_date%type,
236: p_business_group_id in per_all_assignments_f.business_group_id%type,
237: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
238: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
239: );
240:

Line 243: p_business_group_id in per_all_assignments_f.business_group_id%type,

239: );
240:
241: function get_termination_reason_new
242: (
243: p_business_group_id in per_all_assignments_f.business_group_id%type,
244: p_report_date in per_all_assignments_f.effective_end_date%type,
245: p_reason_code in per_periods_of_service.leaving_reason%type
246: ) return varchar2;
247:

Line 244: p_report_date in per_all_assignments_f.effective_end_date%type,

240:
241: function get_termination_reason_new
242: (
243: p_business_group_id in per_all_assignments_f.business_group_id%type,
244: p_report_date in per_all_assignments_f.effective_end_date%type,
245: p_reason_code in per_periods_of_service.leaving_reason%type
246: ) return varchar2;
247:
248: procedure populate_ee_table_new

Line 251: p_report_date in per_all_assignments_f.effective_end_date%type,

247:
248: procedure populate_ee_table_new
249: (
250: p_report_code in varchar2,
251: p_report_date in per_all_assignments_f.effective_end_date%type,
252: p_business_group_id in per_all_assignments_f.business_group_id%type,
253: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
254: );
255:

Line 252: p_business_group_id in per_all_assignments_f.business_group_id%type,

248: procedure populate_ee_table_new
249: (
250: p_report_code in varchar2,
251: p_report_date in per_all_assignments_f.effective_end_date%type,
252: p_business_group_id in per_all_assignments_f.business_group_id%type,
253: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
254: );
255:
256: procedure populate_ee_table_EEWF_new

Line 258: p_report_date in per_all_assignments_f.effective_end_date%type,

254: );
255:
256: procedure populate_ee_table_EEWF_new
257: (
258: p_report_date in per_all_assignments_f.effective_end_date%type,
259: p_business_group_id in per_all_assignments_f.business_group_id%type,
260: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
261: );
262:

Line 259: p_business_group_id in per_all_assignments_f.business_group_id%type,

255:
256: procedure populate_ee_table_EEWF_new
257: (
258: p_report_date in per_all_assignments_f.effective_end_date%type,
259: p_business_group_id in per_all_assignments_f.business_group_id%type,
260: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
261: );
262:
263: end per_za_employment_equity_pkg;