APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 52: p_business_group_id in per_all_assignments_f.business_group_id%type,

48:
49: -- This function returns the termination reason from the user tables.
50: function get_termination_reason
51: (
52: p_business_group_id in per_all_assignments_f.business_group_id%type,
53: p_report_date in per_all_assignments_f.effective_end_date%type,
54: p_reason_code in per_periods_of_service.leaving_reason%type
55: ) return varchar2;
56:

Line 53: p_report_date in per_all_assignments_f.effective_end_date%type,

49: -- This function returns the termination reason from the user tables.
50: function get_termination_reason
51: (
52: p_business_group_id in per_all_assignments_f.business_group_id%type,
53: p_report_date in per_all_assignments_f.effective_end_date%type,
54: p_reason_code in per_periods_of_service.leaving_reason%type
55: ) return varchar2;
56:
57: -- This procedure resets all the data structures for the Income Differentials report.

Line 63: p_report_date in per_all_assignments_f.effective_end_date%type,

59:
60: -- This function returns the average 5 highest paid employees per category or level.
61: function get_avg_5_highest_salary
62: (
63: p_report_date in per_all_assignments_f.effective_end_date%type,
64: p_business_group_id in per_all_assignments_f.business_group_id%type,
65: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
66: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
67: p_occupational_level_cat in hr_lookups.meaning%type,

Line 64: p_business_group_id in per_all_assignments_f.business_group_id%type,

60: -- This function returns the average 5 highest paid employees per category or level.
61: function get_avg_5_highest_salary
62: (
63: p_report_date in per_all_assignments_f.effective_end_date%type,
64: p_business_group_id in per_all_assignments_f.business_group_id%type,
65: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
66: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
67: p_occupational_level_cat in hr_lookups.meaning%type,
68: p_lookup_code in hr_lookups.lookup_code%type,

Line 76: p_report_date in per_all_assignments_f.effective_end_date%type,

72:
73: -- This function returns the average 5 lowest paid employees per category or level.
74: function get_avg_5_lowest_salary
75: (
76: p_report_date in per_all_assignments_f.effective_end_date%type,
77: p_business_group_id in per_all_assignments_f.business_group_id%type,
78: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
79: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
80: p_occupational_level_cat in hr_lookups.meaning%type,

Line 77: p_business_group_id in per_all_assignments_f.business_group_id%type,

73: -- This function returns the average 5 lowest paid employees per category or level.
74: function get_avg_5_lowest_salary
75: (
76: p_report_date in per_all_assignments_f.effective_end_date%type,
77: p_business_group_id in per_all_assignments_f.business_group_id%type,
78: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
79: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
80: p_occupational_level_cat in hr_lookups.meaning%type,
81: p_lookup_code in hr_lookups.lookup_code%type,

Line 90: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type

86: -- This function returns the person's legislated employment type (permanent or non-permanent)
87: function get_ee_employment_type_name
88: (
89: p_report_date in per_all_people_f.start_date%type,
90: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type
91: ) return varchar2;
92:
93: -- This function returns the occupational categories from the user tables.
94: function get_occupational_category

Line 96: p_report_date in per_all_assignments_f.effective_end_date%type,

92:
93: -- This function returns the occupational categories from the user tables.
94: function get_occupational_category
95: (
96: p_report_date in per_all_assignments_f.effective_end_date%type,
97: p_assignment_id in per_all_assignments_f.assignment_id%type,
98: p_job_id in per_all_assignments_f.job_id%type,
99: p_grade_id in per_all_assignments_f.grade_id%type,
100: p_position_id in per_all_assignments_f.position_id%type,

Line 97: p_assignment_id in per_all_assignments_f.assignment_id%type,

93: -- This function returns the occupational categories from the user tables.
94: function get_occupational_category
95: (
96: p_report_date in per_all_assignments_f.effective_end_date%type,
97: p_assignment_id in per_all_assignments_f.assignment_id%type,
98: p_job_id in per_all_assignments_f.job_id%type,
99: p_grade_id in per_all_assignments_f.grade_id%type,
100: p_position_id in per_all_assignments_f.position_id%type,
101: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 98: p_job_id in per_all_assignments_f.job_id%type,

94: function get_occupational_category
95: (
96: p_report_date in per_all_assignments_f.effective_end_date%type,
97: p_assignment_id in per_all_assignments_f.assignment_id%type,
98: p_job_id in per_all_assignments_f.job_id%type,
99: p_grade_id in per_all_assignments_f.grade_id%type,
100: p_position_id in per_all_assignments_f.position_id%type,
101: p_business_group_id in per_all_assignments_f.business_group_id%type
102: ) return varchar2;

Line 99: p_grade_id in per_all_assignments_f.grade_id%type,

95: (
96: p_report_date in per_all_assignments_f.effective_end_date%type,
97: p_assignment_id in per_all_assignments_f.assignment_id%type,
98: p_job_id in per_all_assignments_f.job_id%type,
99: p_grade_id in per_all_assignments_f.grade_id%type,
100: p_position_id in per_all_assignments_f.position_id%type,
101: p_business_group_id in per_all_assignments_f.business_group_id%type
102: ) return varchar2;
103:

Line 100: p_position_id in per_all_assignments_f.position_id%type,

96: p_report_date in per_all_assignments_f.effective_end_date%type,
97: p_assignment_id in per_all_assignments_f.assignment_id%type,
98: p_job_id in per_all_assignments_f.job_id%type,
99: p_grade_id in per_all_assignments_f.grade_id%type,
100: p_position_id in per_all_assignments_f.position_id%type,
101: p_business_group_id in per_all_assignments_f.business_group_id%type
102: ) return varchar2;
103:
104: -- This function returns the occupational levels from the user tables.

Line 101: p_business_group_id in per_all_assignments_f.business_group_id%type

97: p_assignment_id in per_all_assignments_f.assignment_id%type,
98: p_job_id in per_all_assignments_f.job_id%type,
99: p_grade_id in per_all_assignments_f.grade_id%type,
100: p_position_id in per_all_assignments_f.position_id%type,
101: p_business_group_id in per_all_assignments_f.business_group_id%type
102: ) return varchar2;
103:
104: -- This function returns the occupational levels from the user tables.
105: function get_occupational_level

Line 107: p_report_date in per_all_assignments_f.effective_end_date%type,

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

Line 108: p_assignment_id in per_all_assignments_f.assignment_id%type,

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

Line 109: p_job_id in per_all_assignments_f.job_id%type,

105: function get_occupational_level
106: (
107: p_report_date in per_all_assignments_f.effective_end_date%type,
108: p_assignment_id in per_all_assignments_f.assignment_id%type,
109: p_job_id in per_all_assignments_f.job_id%type,
110: p_grade_id in per_all_assignments_f.grade_id%type,
111: p_position_id in per_all_assignments_f.position_id%type,
112: p_business_group_id in per_all_assignments_f.business_group_id%type
113: ) return varchar2;

Line 110: p_grade_id in per_all_assignments_f.grade_id%type,

106: (
107: p_report_date in per_all_assignments_f.effective_end_date%type,
108: p_assignment_id in per_all_assignments_f.assignment_id%type,
109: p_job_id in per_all_assignments_f.job_id%type,
110: p_grade_id in per_all_assignments_f.grade_id%type,
111: p_position_id in per_all_assignments_f.position_id%type,
112: p_business_group_id in per_all_assignments_f.business_group_id%type
113: ) return varchar2;
114:

Line 111: p_position_id in per_all_assignments_f.position_id%type,

107: p_report_date in per_all_assignments_f.effective_end_date%type,
108: p_assignment_id in per_all_assignments_f.assignment_id%type,
109: p_job_id in per_all_assignments_f.job_id%type,
110: p_grade_id in per_all_assignments_f.grade_id%type,
111: p_position_id in per_all_assignments_f.position_id%type,
112: p_business_group_id in per_all_assignments_f.business_group_id%type
113: ) return varchar2;
114:
115: -- This function retrieves the occupational data via dynamic sql from the appropriate flexfield segment

Line 112: p_business_group_id in per_all_assignments_f.business_group_id%type

108: p_assignment_id in per_all_assignments_f.assignment_id%type,
109: p_job_id in per_all_assignments_f.job_id%type,
110: p_grade_id in per_all_assignments_f.grade_id%type,
111: p_position_id in per_all_assignments_f.position_id%type,
112: p_business_group_id in per_all_assignments_f.business_group_id%type
113: ) return varchar2;
114:
115: -- This function retrieves the occupational data via dynamic sql from the appropriate flexfield segment
116: function get_occupational_data

Line 121: p_job_id in per_all_assignments_f.job_id%type,

117: (
118: p_type in varchar2,
119: p_flex in varchar2,
120: p_segment in varchar2,
121: p_job_id in per_all_assignments_f.job_id%type,
122: p_grade_id in per_all_assignments_f.grade_id%type,
123: p_position_id in per_all_assignments_f.position_id%type
124: ) return varchar2;
125:

Line 122: p_grade_id in per_all_assignments_f.grade_id%type,

118: p_type in varchar2,
119: p_flex in varchar2,
120: p_segment in varchar2,
121: p_job_id in per_all_assignments_f.job_id%type,
122: p_grade_id in per_all_assignments_f.grade_id%type,
123: p_position_id in per_all_assignments_f.position_id%type
124: ) return varchar2;
125:
126: -- This procedure caches the location of the occupational category and level data.

Line 123: p_position_id in per_all_assignments_f.position_id%type

119: p_flex in varchar2,
120: p_segment in varchar2,
121: p_job_id in per_all_assignments_f.job_id%type,
122: p_grade_id in per_all_assignments_f.grade_id%type,
123: p_position_id in per_all_assignments_f.position_id%type
124: ) return varchar2;
125:
126: -- This procedure caches the location of the occupational category and level data.
127: procedure cache_occupational_location

Line 130: p_business_group_id in per_all_assignments_f.business_group_id%type

126: -- This procedure caches the location of the occupational category and level data.
127: procedure cache_occupational_location
128: (
129: p_report_date in date,
130: p_business_group_id in per_all_assignments_f.business_group_id%type
131: );
132:
133: -- This function returns the lookup_code from the user tables.
134: function get_lookup_code

Line 143: p_report_date in per_all_assignments_f.effective_end_date%type,

139: -- This function populates an entity's sex and race and category matches.
140: procedure populate_ee_table
141: (
142: p_report_code in varchar2,
143: p_report_date in per_all_assignments_f.effective_end_date%type,
144: p_business_group_id in per_all_assignments_f.business_group_id%type,
145: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
146: );
147:

Line 144: p_business_group_id in per_all_assignments_f.business_group_id%type,

140: procedure populate_ee_table
141: (
142: p_report_code in varchar2,
143: p_report_date in per_all_assignments_f.effective_end_date%type,
144: p_business_group_id in per_all_assignments_f.business_group_id%type,
145: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
146: );
147:
148: -- This function retrieves the functional data via dynamic sql from the appropriate flexfield segment

Line 153: p_job_id in per_all_assignments_f.job_id%type,

149: function get_functional_data
150: (
151: p_flex in varchar2,
152: p_segment in varchar2,
153: p_job_id in per_all_assignments_f.job_id%type,
154: p_grade_id in per_all_assignments_f.grade_id%type,
155: p_position_id in per_all_assignments_f.position_id%type
156: ) return varchar2;
157:

Line 154: p_grade_id in per_all_assignments_f.grade_id%type,

150: (
151: p_flex in varchar2,
152: p_segment in varchar2,
153: p_job_id in per_all_assignments_f.job_id%type,
154: p_grade_id in per_all_assignments_f.grade_id%type,
155: p_position_id in per_all_assignments_f.position_id%type
156: ) return varchar2;
157:
158:

Line 155: p_position_id in per_all_assignments_f.position_id%type

151: p_flex in varchar2,
152: p_segment in varchar2,
153: p_job_id in per_all_assignments_f.job_id%type,
154: p_grade_id in per_all_assignments_f.grade_id%type,
155: p_position_id in per_all_assignments_f.position_id%type
156: ) return varchar2;
157:
158:
159: function get_functional_type

Line 161: p_report_date in per_all_assignments_f.effective_end_date%type,

157:
158:
159: function get_functional_type
160: (
161: p_report_date in per_all_assignments_f.effective_end_date%type,
162: p_assignment_id in per_all_assignments_f.assignment_id%type,
163: p_job_id in per_all_assignments_f.job_id%type,
164: p_grade_id in per_all_assignments_f.grade_id%type,
165: p_position_id in per_all_assignments_f.position_id%type,

Line 162: p_assignment_id in per_all_assignments_f.assignment_id%type,

158:
159: function get_functional_type
160: (
161: p_report_date in per_all_assignments_f.effective_end_date%type,
162: p_assignment_id in per_all_assignments_f.assignment_id%type,
163: p_job_id in per_all_assignments_f.job_id%type,
164: p_grade_id in per_all_assignments_f.grade_id%type,
165: p_position_id in per_all_assignments_f.position_id%type,
166: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 163: p_job_id in per_all_assignments_f.job_id%type,

159: function get_functional_type
160: (
161: p_report_date in per_all_assignments_f.effective_end_date%type,
162: p_assignment_id in per_all_assignments_f.assignment_id%type,
163: p_job_id in per_all_assignments_f.job_id%type,
164: p_grade_id in per_all_assignments_f.grade_id%type,
165: p_position_id in per_all_assignments_f.position_id%type,
166: p_business_group_id in per_all_assignments_f.business_group_id%type
167: ) return varchar2;

Line 164: p_grade_id in per_all_assignments_f.grade_id%type,

160: (
161: p_report_date in per_all_assignments_f.effective_end_date%type,
162: p_assignment_id in per_all_assignments_f.assignment_id%type,
163: p_job_id in per_all_assignments_f.job_id%type,
164: p_grade_id in per_all_assignments_f.grade_id%type,
165: p_position_id in per_all_assignments_f.position_id%type,
166: p_business_group_id in per_all_assignments_f.business_group_id%type
167: ) return varchar2;
168:

Line 165: p_position_id in per_all_assignments_f.position_id%type,

161: p_report_date in per_all_assignments_f.effective_end_date%type,
162: p_assignment_id in per_all_assignments_f.assignment_id%type,
163: p_job_id in per_all_assignments_f.job_id%type,
164: p_grade_id in per_all_assignments_f.grade_id%type,
165: p_position_id in per_all_assignments_f.position_id%type,
166: p_business_group_id in per_all_assignments_f.business_group_id%type
167: ) return varchar2;
168:
169: -- Report will call this procedure which n terms call the populate_ee_table

Line 166: p_business_group_id in per_all_assignments_f.business_group_id%type

162: p_assignment_id in per_all_assignments_f.assignment_id%type,
163: p_job_id in per_all_assignments_f.job_id%type,
164: p_grade_id in per_all_assignments_f.grade_id%type,
165: p_position_id in per_all_assignments_f.position_id%type,
166: p_business_group_id in per_all_assignments_f.business_group_id%type
167: ) return varchar2;
168:
169: -- Report will call this procedure which n terms call the populate_ee_table
170: procedure populate_ee_table_EEWF

Line 172: p_report_date in per_all_assignments_f.effective_end_date%type,

168:
169: -- Report will call this procedure which n terms call the populate_ee_table
170: procedure populate_ee_table_EEWF
171: (
172: p_report_date in per_all_assignments_f.effective_end_date%type,
173: p_business_group_id in per_all_assignments_f.business_group_id%type,
174: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
175: );
176:

Line 173: p_business_group_id in per_all_assignments_f.business_group_id%type,

169: -- Report will call this procedure which n terms call the populate_ee_table
170: procedure populate_ee_table_EEWF
171: (
172: p_report_date in per_all_assignments_f.effective_end_date%type,
173: p_business_group_id in per_all_assignments_f.business_group_id%type,
174: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
175: );
176:
177:

Line 217: p_report_date in per_all_assignments_f.effective_end_date%type,

213: ) ;
214:
215: procedure init_g_cat_lev_table
216: (
217: p_report_date in per_all_assignments_f.effective_end_date%type,
218: p_business_group_id in per_all_assignments_f.business_group_id%type,
219: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
220: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
221: );

Line 218: p_business_group_id in per_all_assignments_f.business_group_id%type,

214:
215: procedure init_g_cat_lev_table
216: (
217: p_report_date in per_all_assignments_f.effective_end_date%type,
218: p_business_group_id in per_all_assignments_f.business_group_id%type,
219: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
220: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
221: );
222: