23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_library_objective
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date
29: ,p_objective_name in varchar2
30: ,p_valid_from in date default null
31: ,p_valid_to in date default null
103: --
104: -- {End of comments}
105: -- ----------------------------------------------------------------------------
106: PROCEDURE delete_library_objective
107: (p_validate in number default hr_api.g_false_num
108: ,p_objective_id in number
109: ,p_object_version_number in number
110: ,p_return_status out nocopy varchar2
111: );
132: --
133: -- {End of comments}
134: -- ----------------------------------------------------------------------------
135: PROCEDURE update_library_objective
136: (p_validate in number default hr_api.g_false_num
137: ,p_effective_date in date
138: ,p_objective_id in number
139: ,p_objective_name in varchar2 default hr_api.g_varchar2
140: ,p_valid_from in date default hr_api.g_date
135: PROCEDURE update_library_objective
136: (p_validate in number default hr_api.g_false_num
137: ,p_effective_date in date
138: ,p_objective_id in number
139: ,p_objective_name in varchar2 default hr_api.g_varchar2
140: ,p_valid_from in date default hr_api.g_date
141: ,p_valid_to in date default hr_api.g_date
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
136: (p_validate in number default hr_api.g_false_num
137: ,p_effective_date in date
138: ,p_objective_id in number
139: ,p_objective_name in varchar2 default hr_api.g_varchar2
140: ,p_valid_from in date default hr_api.g_date
141: ,p_valid_to in date default hr_api.g_date
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
137: ,p_effective_date in date
138: ,p_objective_id in number
139: ,p_objective_name in varchar2 default hr_api.g_varchar2
140: ,p_valid_from in date default hr_api.g_date
141: ,p_valid_to in date default hr_api.g_date
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
138: ,p_objective_id in number
139: ,p_objective_name in varchar2 default hr_api.g_varchar2
140: ,p_valid_from in date default hr_api.g_date
141: ,p_valid_to in date default hr_api.g_date
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
139: ,p_objective_name in varchar2 default hr_api.g_varchar2
140: ,p_valid_from in date default hr_api.g_date
141: ,p_valid_to in date default hr_api.g_date
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
140: ,p_valid_from in date default hr_api.g_date
141: ,p_valid_to in date default hr_api.g_date
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
141: ,p_valid_to in date default hr_api.g_date
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
142: ,p_target_date in date default hr_api.g_date
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
143: ,p_next_review_date in date default hr_api.g_date
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
144: ,p_group_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
145: ,p_priority_code in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
146: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
147: ,p_weighting_percent in number default hr_api.g_number
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
148: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
149: ,p_measure_name in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
150: ,p_target_value in number default hr_api.g_number
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
151: ,p_uom_code in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
152: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
153: ,p_measure_comments in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
154: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
155: ,p_details in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
156: ,p_success_criteria in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
158: ,p_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
159: ,p_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
160: ,p_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
161: ,p_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
162: ,p_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
163: ,p_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
164: ,p_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
165: ,p_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
166: ,p_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
167: ,p_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
168: ,p_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
169: ,p_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
170: ,p_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
171: ,p_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
172: ,p_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
173: ,p_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
174: ,p_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
175: ,p_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
176: ,p_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
177: ,p_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
178: ,p_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
186: ,p_attribute28 in varchar2 default hr_api.g_varchar2
179: ,p_attribute21 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
186: ,p_attribute28 in varchar2 default hr_api.g_varchar2
187: ,p_attribute29 in varchar2 default hr_api.g_varchar2
180: ,p_attribute22 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
186: ,p_attribute28 in varchar2 default hr_api.g_varchar2
187: ,p_attribute29 in varchar2 default hr_api.g_varchar2
188: ,p_attribute30 in varchar2 default hr_api.g_varchar2
181: ,p_attribute23 in varchar2 default hr_api.g_varchar2
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
186: ,p_attribute28 in varchar2 default hr_api.g_varchar2
187: ,p_attribute29 in varchar2 default hr_api.g_varchar2
188: ,p_attribute30 in varchar2 default hr_api.g_varchar2
189: ,p_object_version_number in out nocopy number
182: ,p_attribute24 in varchar2 default hr_api.g_varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
186: ,p_attribute28 in varchar2 default hr_api.g_varchar2
187: ,p_attribute29 in varchar2 default hr_api.g_varchar2
188: ,p_attribute30 in varchar2 default hr_api.g_varchar2
189: ,p_object_version_number in out nocopy number
190: ,p_return_status out nocopy varchar2
183: ,p_attribute25 in varchar2 default hr_api.g_varchar2
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
186: ,p_attribute28 in varchar2 default hr_api.g_varchar2
187: ,p_attribute29 in varchar2 default hr_api.g_varchar2
188: ,p_attribute30 in varchar2 default hr_api.g_varchar2
189: ,p_object_version_number in out nocopy number
190: ,p_return_status out nocopy varchar2
191: );
184: ,p_attribute26 in varchar2 default hr_api.g_varchar2
185: ,p_attribute27 in varchar2 default hr_api.g_varchar2
186: ,p_attribute28 in varchar2 default hr_api.g_varchar2
187: ,p_attribute29 in varchar2 default hr_api.g_varchar2
188: ,p_attribute30 in varchar2 default hr_api.g_varchar2
189: ,p_object_version_number in out nocopy number
190: ,p_return_status out nocopy varchar2
191: );
192: --
224: --
225: -- {End Of Comments}
226: --
227: procedure create_eligy_profile
228: (p_validate in number default hr_api.g_false_num
229: ,p_name in varchar2 default null
230: ,p_bnft_cagr_prtn_cd in varchar2 default null
231: ,p_stat_cd in varchar2 default null
232: ,p_asmt_to_use_cd in varchar2 default null
257: -- In Parameters:
258:
259:
260: procedure update_eligy_profile
261: ( p_validate in number default hr_api.g_false_num
262: ,p_effective_date in date
263: ,p_business_group_id in number
264: ,p_name in varchar2 default null
265: ,p_bnft_cagr_prtn_cd in varchar2 default null
305: --
306: -- {End Of Comments}
307: --
308: procedure create_eligy_object
309: (p_validate in number default hr_api.g_false_num
310: ,p_elig_obj_id in out nocopy number
311: ,p_effective_start_date out nocopy date
312: ,p_effective_end_date out nocopy date
313: ,p_business_group_id in number
346: --
347: -- {End Of Comments}
348: --
349: procedure update_eligy_object
350: (p_validate in number default hr_api.g_false_num
351: ,p_elig_obj_id in number
352: ,p_effective_start_date out nocopy date
353: ,p_effective_end_date out nocopy date
354: ,p_business_group_id in number default hr_api.g_number
350: (p_validate in number default hr_api.g_false_num
351: ,p_elig_obj_id in number
352: ,p_effective_start_date out nocopy date
353: ,p_effective_end_date out nocopy date
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_table_name in varchar2 default hr_api.g_varchar2
356: ,p_column_name in varchar2 default hr_api.g_varchar2
357: ,p_column_value in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
351: ,p_elig_obj_id in number
352: ,p_effective_start_date out nocopy date
353: ,p_effective_end_date out nocopy date
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_table_name in varchar2 default hr_api.g_varchar2
356: ,p_column_name in varchar2 default hr_api.g_varchar2
357: ,p_column_value in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ,p_effective_date in date
352: ,p_effective_start_date out nocopy date
353: ,p_effective_end_date out nocopy date
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_table_name in varchar2 default hr_api.g_varchar2
356: ,p_column_name in varchar2 default hr_api.g_varchar2
357: ,p_column_value in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ,p_effective_date in date
360: ,p_datetrack_mode in varchar2
353: ,p_effective_end_date out nocopy date
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_table_name in varchar2 default hr_api.g_varchar2
356: ,p_column_name in varchar2 default hr_api.g_varchar2
357: ,p_column_value in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ,p_effective_date in date
360: ,p_datetrack_mode in varchar2
361: );
388: --
389: -- {End Of Comments}
390: --
391: procedure delete_eligy_object
392: (p_validate in number default hr_api.g_false_num
393: ,p_elig_obj_id in number
394: ,p_effective_start_date out nocopy date
395: ,p_effective_end_date out nocopy date
396: ,p_object_version_number in out nocopy number
426: --
427: -- {End Of Comments}
428: --
429: procedure create_elig_obj_elig_prfl
430: (p_validate in number default hr_api.g_false_num
431: ,p_elig_obj_elig_prfl_id in out nocopy number
432: ,p_effective_start_date out nocopy date
433: ,p_effective_end_date out nocopy date
434: ,p_business_group_id in number default null
465: --
466: -- {End Of Comments}
467: --
468: procedure update_elig_obj_elig_prfl
469: (p_validate in number default hr_api.g_false_num
470: ,p_elig_obj_elig_prfl_id in number
471: ,p_effective_start_date out nocopy date
472: ,p_effective_end_date out nocopy date
473: ,p_elig_obj_id in number default hr_api.g_number
469: (p_validate in number default hr_api.g_false_num
470: ,p_elig_obj_elig_prfl_id in number
471: ,p_effective_start_date out nocopy date
472: ,p_effective_end_date out nocopy date
473: ,p_elig_obj_id in number default hr_api.g_number
474: ,p_elig_prfl_id in number default hr_api.g_number
475: ,p_object_version_number in out nocopy number
476: ,p_effective_date in date
477: ,p_datetrack_mode in varchar2
470: ,p_elig_obj_elig_prfl_id in number
471: ,p_effective_start_date out nocopy date
472: ,p_effective_end_date out nocopy date
473: ,p_elig_obj_id in number default hr_api.g_number
474: ,p_elig_prfl_id in number default hr_api.g_number
475: ,p_object_version_number in out nocopy number
476: ,p_effective_date in date
477: ,p_datetrack_mode in varchar2
478: );
505: --
506: -- {End Of Comments}
507: --
508: procedure delete_elig_obj_elig_prfl
509: (p_validate in number default hr_api.g_false_num
510: ,p_elig_obj_elig_prfl_id in number
511: ,p_effective_start_date out nocopy date
512: ,p_effective_end_date out nocopy date
513: ,p_object_version_number in out nocopy number
544: --
545: -- {End Of Comments}
546: --
547: procedure create_eligy_grade
548: (p_validate in number default hr_api.g_false_num
549: ,p_elig_grd_prte_id in out nocopy number
550: ,p_effective_start_date out nocopy date
551: ,p_effective_end_date out nocopy date
552: ,p_business_group_id in number default null
586: --
587: -- {End Of Comments}
588: --
589: procedure update_eligy_grade
590: (p_validate in number default hr_api.g_false_num
591: ,p_elig_grd_prte_id in number
592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ,p_business_group_id in number default hr_api.g_number
590: (p_validate in number default hr_api.g_false_num
591: ,p_elig_grd_prte_id in number
592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ,p_business_group_id in number default hr_api.g_number
595: ,p_eligy_prfl_id in number default hr_api.g_number
596: ,p_grade_id in number default hr_api.g_number
597: ,p_object_version_number in out nocopy number
598: ,p_effective_date in date
591: ,p_elig_grd_prte_id in number
592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ,p_business_group_id in number default hr_api.g_number
595: ,p_eligy_prfl_id in number default hr_api.g_number
596: ,p_grade_id in number default hr_api.g_number
597: ,p_object_version_number in out nocopy number
598: ,p_effective_date in date
599: ,p_datetrack_mode in varchar2
592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ,p_business_group_id in number default hr_api.g_number
595: ,p_eligy_prfl_id in number default hr_api.g_number
596: ,p_grade_id in number default hr_api.g_number
597: ,p_object_version_number in out nocopy number
598: ,p_effective_date in date
599: ,p_datetrack_mode in varchar2
600: );
628: --
629: -- {End Of Comments}
630: --
631: procedure delete_eligy_grade
632: (p_validate in number default hr_api.g_false_num
633: ,p_elig_grd_prte_id in number
634: ,p_effective_start_date out nocopy date
635: ,p_effective_end_date out nocopy date
636: ,p_object_version_number in out nocopy number
667: --
668: -- {End Of Comments}
669: --
670: procedure create_eligy_org
671: (p_validate in number default hr_api.g_false_num
672: ,p_elig_org_unit_prte_id in out nocopy number
673: ,p_effective_start_date out nocopy date
674: ,p_effective_end_date out nocopy date
675: ,p_business_group_id in number default null
709: --
710: -- {End Of Comments}
711: --
712: procedure update_eligy_org
713: (p_validate in number default hr_api.g_false_num
714: ,p_elig_org_unit_prte_id in number
715: ,p_effective_start_date out nocopy date
716: ,p_effective_end_date out nocopy date
717: ,p_business_group_id in number default hr_api.g_number
713: (p_validate in number default hr_api.g_false_num
714: ,p_elig_org_unit_prte_id in number
715: ,p_effective_start_date out nocopy date
716: ,p_effective_end_date out nocopy date
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_eligy_prfl_id in number default hr_api.g_number
719: ,p_organization_id in number default hr_api.g_number
720: ,p_object_version_number in out nocopy number
721: ,p_effective_date in date
714: ,p_elig_org_unit_prte_id in number
715: ,p_effective_start_date out nocopy date
716: ,p_effective_end_date out nocopy date
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_eligy_prfl_id in number default hr_api.g_number
719: ,p_organization_id in number default hr_api.g_number
720: ,p_object_version_number in out nocopy number
721: ,p_effective_date in date
722: ,p_datetrack_mode in varchar2
715: ,p_effective_start_date out nocopy date
716: ,p_effective_end_date out nocopy date
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_eligy_prfl_id in number default hr_api.g_number
719: ,p_organization_id in number default hr_api.g_number
720: ,p_object_version_number in out nocopy number
721: ,p_effective_date in date
722: ,p_datetrack_mode in varchar2
723: );
751: --
752: -- {End Of Comments}
753: --
754: procedure delete_eligy_org
755: (p_validate in number default hr_api.g_false_num
756: ,p_elig_org_unit_prte_id in number
757: ,p_effective_start_date out nocopy date
758: ,p_effective_end_date out nocopy date
759: ,p_object_version_number in out nocopy number
791: --
792: -- {End Of Comments}
793: --
794: procedure create_eligy_position
795: (p_validate in number default hr_api.g_false_num
796: ,p_elig_pstn_prte_id in out nocopy number
797: ,p_effective_start_date out nocopy date
798: ,p_effective_end_date out nocopy date
799: ,p_business_group_id in number default null
833: --
834: -- {End Of Comments}
835: --
836: procedure update_eligy_position
837: (p_validate in number default hr_api.g_false_num
838: ,p_elig_pstn_prte_id in number
839: ,p_effective_start_date out nocopy date
840: ,p_effective_end_date out nocopy date
841: ,p_business_group_id in number default hr_api.g_number
837: (p_validate in number default hr_api.g_false_num
838: ,p_elig_pstn_prte_id in number
839: ,p_effective_start_date out nocopy date
840: ,p_effective_end_date out nocopy date
841: ,p_business_group_id in number default hr_api.g_number
842: ,p_eligy_prfl_id in number default hr_api.g_number
843: ,p_position_id in number default hr_api.g_number
844: ,p_object_version_number in out nocopy number
845: ,p_effective_date in date
838: ,p_elig_pstn_prte_id in number
839: ,p_effective_start_date out nocopy date
840: ,p_effective_end_date out nocopy date
841: ,p_business_group_id in number default hr_api.g_number
842: ,p_eligy_prfl_id in number default hr_api.g_number
843: ,p_position_id in number default hr_api.g_number
844: ,p_object_version_number in out nocopy number
845: ,p_effective_date in date
846: ,p_datetrack_mode in varchar2
839: ,p_effective_start_date out nocopy date
840: ,p_effective_end_date out nocopy date
841: ,p_business_group_id in number default hr_api.g_number
842: ,p_eligy_prfl_id in number default hr_api.g_number
843: ,p_position_id in number default hr_api.g_number
844: ,p_object_version_number in out nocopy number
845: ,p_effective_date in date
846: ,p_datetrack_mode in varchar2
847: );
875: --
876: -- {End Of Comments}
877: --
878: procedure delete_eligy_position
879: (p_validate in number default hr_api.g_false_num
880: ,p_elig_pstn_prte_id in number
881: ,p_effective_start_date out nocopy date
882: ,p_effective_end_date out nocopy date
883: ,p_object_version_number in out nocopy number
914: --
915: -- {End Of Comments}
916: --
917: procedure create_eligy_job
918: (p_validate in number default hr_api.g_false_num
919: ,p_elig_job_prte_id in out nocopy number
920: ,p_effective_start_date out nocopy date
921: ,p_effective_end_date out nocopy date
922: ,p_business_group_id in number default null
956: --
957: -- {End Of Comments}
958: --
959: procedure update_eligy_job
960: (p_validate in number default hr_api.g_false_num
961: ,p_elig_job_prte_id in number
962: ,p_effective_start_date out nocopy date
963: ,p_effective_end_date out nocopy date
964: ,p_business_group_id in number default hr_api.g_number
960: (p_validate in number default hr_api.g_false_num
961: ,p_elig_job_prte_id in number
962: ,p_effective_start_date out nocopy date
963: ,p_effective_end_date out nocopy date
964: ,p_business_group_id in number default hr_api.g_number
965: ,p_eligy_prfl_id in number default hr_api.g_number
966: ,p_job_id in number default hr_api.g_number
967: ,p_object_version_number in out nocopy number
968: ,p_effective_date in date
961: ,p_elig_job_prte_id in number
962: ,p_effective_start_date out nocopy date
963: ,p_effective_end_date out nocopy date
964: ,p_business_group_id in number default hr_api.g_number
965: ,p_eligy_prfl_id in number default hr_api.g_number
966: ,p_job_id in number default hr_api.g_number
967: ,p_object_version_number in out nocopy number
968: ,p_effective_date in date
969: ,p_datetrack_mode in varchar2
962: ,p_effective_start_date out nocopy date
963: ,p_effective_end_date out nocopy date
964: ,p_business_group_id in number default hr_api.g_number
965: ,p_eligy_prfl_id in number default hr_api.g_number
966: ,p_job_id in number default hr_api.g_number
967: ,p_object_version_number in out nocopy number
968: ,p_effective_date in date
969: ,p_datetrack_mode in varchar2
970: );
998: --
999: -- {End Of Comments}
1000: --
1001: procedure delete_eligy_job
1002: (p_validate in number default hr_api.g_false_num
1003: ,p_elig_job_prte_id in number
1004: ,p_effective_start_date out nocopy date
1005: ,p_effective_end_date out nocopy date
1006: ,p_object_version_number in out nocopy number