23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_objective
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date
29: ,p_business_group_id in number
30: ,p_name in varchar2
31: ,p_start_date in date
115: --
116: -- {End of comments}
117: -- ----------------------------------------------------------------------------
118: PROCEDURE delete_objective
119: (p_validate in number default hr_api.g_false_num
120: ,p_objective_id in number
121: ,p_object_version_number in number
122: ,p_return_status out nocopy varchar2
123: );
144: --
145: -- {End of comments}
146: -- ----------------------------------------------------------------------------
147: PROCEDURE update_objective
148: (p_validate in number default hr_api.g_false_num
149: ,p_effective_date in date
150: ,p_objective_id in number
151: ,p_object_version_number in out nocopy number
152: ,p_name in varchar2 default hr_api.g_varchar2
148: (p_validate in number default hr_api.g_false_num
149: ,p_effective_date in date
150: ,p_objective_id in number
151: ,p_object_version_number in out nocopy number
152: ,p_name in varchar2 default hr_api.g_varchar2
153: ,p_target_date in date default hr_api.g_date
154: ,p_start_date in date default hr_api.g_date
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
149: ,p_effective_date in date
150: ,p_objective_id in number
151: ,p_object_version_number in out nocopy number
152: ,p_name in varchar2 default hr_api.g_varchar2
153: ,p_target_date in date default hr_api.g_date
154: ,p_start_date in date default hr_api.g_date
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
150: ,p_objective_id in number
151: ,p_object_version_number in out nocopy number
152: ,p_name in varchar2 default hr_api.g_varchar2
153: ,p_target_date in date default hr_api.g_date
154: ,p_start_date in date default hr_api.g_date
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
151: ,p_object_version_number in out nocopy number
152: ,p_name in varchar2 default hr_api.g_varchar2
153: ,p_target_date in date default hr_api.g_date
154: ,p_start_date in date default hr_api.g_date
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
152: ,p_name in varchar2 default hr_api.g_varchar2
153: ,p_target_date in date default hr_api.g_date
154: ,p_start_date in date default hr_api.g_date
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
153: ,p_target_date in date default hr_api.g_date
154: ,p_start_date in date default hr_api.g_date
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
154: ,p_start_date in date default hr_api.g_date
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
155: ,p_achievement_date in date default hr_api.g_date
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
156: ,p_detail in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
157: ,p_comments in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
158: ,p_success_criteria in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
159: ,p_attribute_category in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
160: ,p_attribute1 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
161: ,p_attribute2 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
162: ,p_attribute3 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
163: ,p_attribute4 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
164: ,p_attribute5 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
165: ,p_attribute6 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
166: ,p_attribute7 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
167: ,p_attribute8 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
168: ,p_attribute9 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
169: ,p_attribute10 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
170: ,p_attribute11 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
171: ,p_attribute12 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
172: ,p_attribute13 in varchar2 default hr_api.g_varchar2
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
180:
173: ,p_attribute14 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
180:
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
174: ,p_attribute15 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
180:
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
175: ,p_attribute16 in varchar2 default hr_api.g_varchar2
176: ,p_attribute17 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
180:
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
177: ,p_attribute18 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
180:
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
178: ,p_attribute19 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
180:
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
179: ,p_attribute20 in varchar2 default hr_api.g_varchar2
180:
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
180:
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
181: ,p_attribute21 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
182: ,p_attribute22 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
183: ,p_attribute23 in varchar2 default hr_api.g_varchar2
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
184: ,p_attribute24 in varchar2 default hr_api.g_varchar2
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
185: ,p_attribute25 in varchar2 default hr_api.g_varchar2
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
186: ,p_attribute26 in varchar2 default hr_api.g_varchar2
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
187: ,p_attribute27 in varchar2 default hr_api.g_varchar2
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
188: ,p_attribute28 in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
189: ,p_attribute29 in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
190: ,p_attribute30 in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
191: ,p_scorecard_id in number default hr_api.g_number
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
192: ,p_copied_from_library_id in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
193: ,p_copied_from_objective_id in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
194: ,p_aligned_with_objective_id in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
195: ,p_next_review_date in date default hr_api.g_date
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
196: ,p_group_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
197: ,p_priority_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
198: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
199: ,p_verified_flag in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
200: ,p_target_value in number default hr_api.g_number
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
208: ,p_measure_comments in varchar2 default hr_api.g_varchar2
201: ,p_actual_value in number default hr_api.g_number
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
208: ,p_measure_comments in varchar2 default hr_api.g_varchar2
209: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
202: ,p_weighting_percent in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
208: ,p_measure_comments in varchar2 default hr_api.g_varchar2
209: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
210: ,p_appraisal_id in number default hr_api.g_number
203: ,p_complete_percent in number default hr_api.g_number
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
208: ,p_measure_comments in varchar2 default hr_api.g_varchar2
209: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
210: ,p_appraisal_id in number default hr_api.g_number
211: ,p_return_status out nocopy varchar2
204: ,p_uom_code in varchar2 default hr_api.g_varchar2
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
208: ,p_measure_comments in varchar2 default hr_api.g_varchar2
209: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
210: ,p_appraisal_id in number default hr_api.g_number
211: ,p_return_status out nocopy varchar2
212: );
205: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
208: ,p_measure_comments in varchar2 default hr_api.g_varchar2
209: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
210: ,p_appraisal_id in number default hr_api.g_number
211: ,p_return_status out nocopy varchar2
212: );
213:
206: ,p_measure_name in varchar2 default hr_api.g_varchar2
207: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
208: ,p_measure_comments in varchar2 default hr_api.g_varchar2
209: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
210: ,p_appraisal_id in number default hr_api.g_number
211: ,p_return_status out nocopy varchar2
212: );
213:
214: -- ----------------------------------------------------------------------------
217: -- {Start of comments}
218: --
219: -- Description:
220: -- This procedure is responsible for commiting data from transaction
221: -- table (hr_api_transaction_step_id) to the base table
222: --
223: -- Parameters:
224: --
225: -- p_document is the document having the data that needs to be committed
236:
237: Procedure process_api
238: ( p_document in CLOB
239: ,p_return_status out nocopy VARCHAR2
240: ,p_validate in number default hr_api.g_false_num
241: ,p_effective_date in date default null
242: );
243:
244: end hr_objectives_swi;