DBA Data[Home] [Help]

APPS.PER_PYP_UPD dependencies on HR_API

Line 97: -- by raising and handling the exception hr_api.validate_enabled. We use

93: -- default is false. The validation is controlled by a savepoint and
94: -- rollback mechanism. The savepoint is issued at the beginning of the
95: -- process and is rollbacked at the end of the process
96: -- when all the processing has been completed. The rollback is controlled
97: -- by raising and handling the exception hr_api.validate_enabled. We use
98: -- the exception because, by raising the exception with the
99: -- process, we can exit successfully without having any of the 'OUT'
100: -- parameters being set.
101: --

Line 175: p_change_date in date default hr_api.g_date,

171: -- ----------------------------------------------------------------------------
172: Procedure upd
173: (
174: p_pay_proposal_id in number,
175: p_change_date in date default hr_api.g_date,
176: p_comments in varchar2 default hr_api.g_varchar2,
177: p_next_sal_review_date in date default hr_api.g_date,
178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,

Line 176: p_comments in varchar2 default hr_api.g_varchar2,

172: Procedure upd
173: (
174: p_pay_proposal_id in number,
175: p_change_date in date default hr_api.g_date,
176: p_comments in varchar2 default hr_api.g_varchar2,
177: p_next_sal_review_date in date default hr_api.g_date,
178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,

Line 177: p_next_sal_review_date in date default hr_api.g_date,

173: (
174: p_pay_proposal_id in number,
175: p_change_date in date default hr_api.g_date,
176: p_comments in varchar2 default hr_api.g_varchar2,
177: p_next_sal_review_date in date default hr_api.g_date,
178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,

Line 178: p_proposal_reason in varchar2 default hr_api.g_varchar2,

174: p_pay_proposal_id in number,
175: p_change_date in date default hr_api.g_date,
176: p_comments in varchar2 default hr_api.g_varchar2,
177: p_next_sal_review_date in date default hr_api.g_date,
178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,

Line 179: p_proposed_salary_n in number default hr_api.g_number,

175: p_change_date in date default hr_api.g_date,
176: p_comments in varchar2 default hr_api.g_varchar2,
177: p_next_sal_review_date in date default hr_api.g_date,
178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 180: p_forced_ranking in number default hr_api.g_number,

176: p_comments in varchar2 default hr_api.g_varchar2,
177: p_next_sal_review_date in date default hr_api.g_date,
178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 181: p_date_to in date default hr_api.g_date,

177: p_next_sal_review_date in date default hr_api.g_date,
178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 182: p_performance_review_id in number default hr_api.g_number,

178: p_proposal_reason in varchar2 default hr_api.g_varchar2,
179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 183: p_attribute_category in varchar2 default hr_api.g_varchar2,

179: p_proposed_salary_n in number default hr_api.g_number,
180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 184: p_attribute1 in varchar2 default hr_api.g_varchar2,

180: p_forced_ranking in number default hr_api.g_number,
181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 185: p_attribute2 in varchar2 default hr_api.g_varchar2,

181: p_date_to in date default hr_api.g_date,
182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 186: p_attribute3 in varchar2 default hr_api.g_varchar2,

182: p_performance_review_id in number default hr_api.g_number,
183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 187: p_attribute4 in varchar2 default hr_api.g_varchar2,

183: p_attribute_category in varchar2 default hr_api.g_varchar2,
184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 188: p_attribute5 in varchar2 default hr_api.g_varchar2,

184: p_attribute1 in varchar2 default hr_api.g_varchar2,
185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 189: p_attribute6 in varchar2 default hr_api.g_varchar2,

185: p_attribute2 in varchar2 default hr_api.g_varchar2,
186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 190: p_attribute7 in varchar2 default hr_api.g_varchar2,

186: p_attribute3 in varchar2 default hr_api.g_varchar2,
187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 191: p_attribute8 in varchar2 default hr_api.g_varchar2,

187: p_attribute4 in varchar2 default hr_api.g_varchar2,
188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 192: p_attribute9 in varchar2 default hr_api.g_varchar2,

188: p_attribute5 in varchar2 default hr_api.g_varchar2,
189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 193: p_attribute10 in varchar2 default hr_api.g_varchar2,

189: p_attribute6 in varchar2 default hr_api.g_varchar2,
190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 194: p_attribute11 in varchar2 default hr_api.g_varchar2,

190: p_attribute7 in varchar2 default hr_api.g_varchar2,
191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 195: p_attribute12 in varchar2 default hr_api.g_varchar2,

191: p_attribute8 in varchar2 default hr_api.g_varchar2,
192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 196: p_attribute13 in varchar2 default hr_api.g_varchar2,

192: p_attribute9 in varchar2 default hr_api.g_varchar2,
193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 197: p_attribute14 in varchar2 default hr_api.g_varchar2,

193: p_attribute10 in varchar2 default hr_api.g_varchar2,
194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,
201: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 198: p_attribute15 in varchar2 default hr_api.g_varchar2,

194: p_attribute11 in varchar2 default hr_api.g_varchar2,
195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,
201: p_attribute18 in varchar2 default hr_api.g_varchar2,
202: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 199: p_attribute16 in varchar2 default hr_api.g_varchar2,

195: p_attribute12 in varchar2 default hr_api.g_varchar2,
196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,
201: p_attribute18 in varchar2 default hr_api.g_varchar2,
202: p_attribute19 in varchar2 default hr_api.g_varchar2,
203: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 200: p_attribute17 in varchar2 default hr_api.g_varchar2,

196: p_attribute13 in varchar2 default hr_api.g_varchar2,
197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,
201: p_attribute18 in varchar2 default hr_api.g_varchar2,
202: p_attribute19 in varchar2 default hr_api.g_varchar2,
203: p_attribute20 in varchar2 default hr_api.g_varchar2,
204: p_object_version_number in out nocopy number,

Line 201: p_attribute18 in varchar2 default hr_api.g_varchar2,

197: p_attribute14 in varchar2 default hr_api.g_varchar2,
198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,
201: p_attribute18 in varchar2 default hr_api.g_varchar2,
202: p_attribute19 in varchar2 default hr_api.g_varchar2,
203: p_attribute20 in varchar2 default hr_api.g_varchar2,
204: p_object_version_number in out nocopy number,
205: p_multiple_components in varchar2 default hr_api.g_varchar2,

Line 202: p_attribute19 in varchar2 default hr_api.g_varchar2,

198: p_attribute15 in varchar2 default hr_api.g_varchar2,
199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,
201: p_attribute18 in varchar2 default hr_api.g_varchar2,
202: p_attribute19 in varchar2 default hr_api.g_varchar2,
203: p_attribute20 in varchar2 default hr_api.g_varchar2,
204: p_object_version_number in out nocopy number,
205: p_multiple_components in varchar2 default hr_api.g_varchar2,
206: p_approved in varchar2 default hr_api.g_varchar2,

Line 203: p_attribute20 in varchar2 default hr_api.g_varchar2,

199: p_attribute16 in varchar2 default hr_api.g_varchar2,
200: p_attribute17 in varchar2 default hr_api.g_varchar2,
201: p_attribute18 in varchar2 default hr_api.g_varchar2,
202: p_attribute19 in varchar2 default hr_api.g_varchar2,
203: p_attribute20 in varchar2 default hr_api.g_varchar2,
204: p_object_version_number in out nocopy number,
205: p_multiple_components in varchar2 default hr_api.g_varchar2,
206: p_approved in varchar2 default hr_api.g_varchar2,
207: p_validate in boolean default false,

Line 205: p_multiple_components in varchar2 default hr_api.g_varchar2,

201: p_attribute18 in varchar2 default hr_api.g_varchar2,
202: p_attribute19 in varchar2 default hr_api.g_varchar2,
203: p_attribute20 in varchar2 default hr_api.g_varchar2,
204: p_object_version_number in out nocopy number,
205: p_multiple_components in varchar2 default hr_api.g_varchar2,
206: p_approved in varchar2 default hr_api.g_varchar2,
207: p_validate in boolean default false,
208: p_inv_next_sal_date_warning out nocopy boolean,
209: p_proposed_salary_warning out nocopy boolean,

Line 206: p_approved in varchar2 default hr_api.g_varchar2,

202: p_attribute19 in varchar2 default hr_api.g_varchar2,
203: p_attribute20 in varchar2 default hr_api.g_varchar2,
204: p_object_version_number in out nocopy number,
205: p_multiple_components in varchar2 default hr_api.g_varchar2,
206: p_approved in varchar2 default hr_api.g_varchar2,
207: p_validate in boolean default false,
208: p_inv_next_sal_date_warning out nocopy boolean,
209: p_proposed_salary_warning out nocopy boolean,
210: p_approved_warning out nocopy boolean,