eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PYP_BUS dependencies on PER_PAY_PROPOSALS

Line 118: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

114: --
115: --
116:
117: procedure chk_assignment_id_change_date
118: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
119: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
120: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
121: ,p_change_date in per_pay_proposals.change_date%TYPE
122: ,p_payroll_warning out nocopy boolean

Line 119: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

115: --
116:
117: procedure chk_assignment_id_change_date
118: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
119: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
120: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
121: ,p_change_date in per_pay_proposals.change_date%TYPE
122: ,p_payroll_warning out nocopy boolean
123: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 120: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

116:
117: procedure chk_assignment_id_change_date
118: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
119: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
120: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
121: ,p_change_date in per_pay_proposals.change_date%TYPE
122: ,p_payroll_warning out nocopy boolean
123: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
124: );

Line 121: ,p_change_date in per_pay_proposals.change_date%TYPE

117: procedure chk_assignment_id_change_date
118: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
119: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
120: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
121: ,p_change_date in per_pay_proposals.change_date%TYPE
122: ,p_payroll_warning out nocopy boolean
123: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
124: );
125: --

Line 123: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

119: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
120: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
121: ,p_change_date in per_pay_proposals.change_date%TYPE
122: ,p_payroll_warning out nocopy boolean
123: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
124: );
125: --
126: -- ---------------------------------------------------------------------------
127: -- |--------------------< chk_next_sal_review_date >-------------------------|

Line 171: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

167: -- Internal Table Handler Use Only.
168: --
169: --
170: procedure chk_next_sal_review_date
171: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
172: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
173: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
174: ,p_change_date in per_pay_proposals.change_date%TYPE
175: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE

Line 172: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

168: --
169: --
170: procedure chk_next_sal_review_date
171: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
172: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
173: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
174: ,p_change_date in per_pay_proposals.change_date%TYPE
175: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
176: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 173: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

169: --
170: procedure chk_next_sal_review_date
171: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
172: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
173: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
174: ,p_change_date in per_pay_proposals.change_date%TYPE
175: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
176: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
177: ,p_inv_next_sal_date_warning out nocopy boolean

Line 174: ,p_change_date in per_pay_proposals.change_date%TYPE

170: procedure chk_next_sal_review_date
171: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
172: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
173: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
174: ,p_change_date in per_pay_proposals.change_date%TYPE
175: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
176: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
177: ,p_inv_next_sal_date_warning out nocopy boolean
178: );

Line 175: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE

171: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
172: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
173: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
174: ,p_change_date in per_pay_proposals.change_date%TYPE
175: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
176: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
177: ,p_inv_next_sal_date_warning out nocopy boolean
178: );
179:

Line 176: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

172: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
173: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
174: ,p_change_date in per_pay_proposals.change_date%TYPE
175: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
176: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
177: ,p_inv_next_sal_date_warning out nocopy boolean
178: );
179:
180: --

Line 186: (p_assignment_id in per_pay_proposals.assignment_id%TYPE

182: -- |------------------------< chk_pay_basis_change_date >-----------------|
183: -- ---------------------------------------------------------------------------
184: --
185: procedure chk_pay_basis_change_date
186: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
187: ,p_change_date in per_pay_proposals.change_date%TYPE
188: ) ;
189:
190:

Line 187: ,p_change_date in per_pay_proposals.change_date%TYPE

183: -- ---------------------------------------------------------------------------
184: --
185: procedure chk_pay_basis_change_date
186: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
187: ,p_change_date in per_pay_proposals.change_date%TYPE
188: ) ;
189:
190:
191:

Line 236: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

232: -- Internal Table Handler Use Only.
233: --
234: --
235: procedure chk_chg_next_sal_review_date
236: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
237: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
238: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
239: ,p_change_date in per_pay_proposals.change_date%TYPE
240: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE

Line 237: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

233: --
234: --
235: procedure chk_chg_next_sal_review_date
236: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
237: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
238: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
239: ,p_change_date in per_pay_proposals.change_date%TYPE
240: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
241: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 238: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

234: --
235: procedure chk_chg_next_sal_review_date
236: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
237: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
238: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
239: ,p_change_date in per_pay_proposals.change_date%TYPE
240: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
241: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
242: ,p_inv_next_sal_date_warning out nocopy boolean

Line 239: ,p_change_date in per_pay_proposals.change_date%TYPE

235: procedure chk_chg_next_sal_review_date
236: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
237: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
238: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
239: ,p_change_date in per_pay_proposals.change_date%TYPE
240: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
241: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
242: ,p_inv_next_sal_date_warning out nocopy boolean
243: );

Line 240: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE

236: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
237: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
238: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
239: ,p_change_date in per_pay_proposals.change_date%TYPE
240: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
241: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
242: ,p_inv_next_sal_date_warning out nocopy boolean
243: );
244: --

Line 241: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

237: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
238: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
239: ,p_change_date in per_pay_proposals.change_date%TYPE
240: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
241: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
242: ,p_inv_next_sal_date_warning out nocopy boolean
243: );
244: --
245: ----------------------------------------------------------------------------

Line 293: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

289: -- Access Status
290: -- Internal Table Handler Use Only.
291: --
292: procedure chk_proposed_salary
293: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
294: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
295: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
296: ,p_change_date in per_pay_proposals.change_date%TYPE
297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 294: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

290: -- Internal Table Handler Use Only.
291: --
292: procedure chk_proposed_salary
293: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
294: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
295: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
296: ,p_change_date in per_pay_proposals.change_date%TYPE
297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
298: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 295: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

291: --
292: procedure chk_proposed_salary
293: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
294: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
295: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
296: ,p_change_date in per_pay_proposals.change_date%TYPE
297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
298: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
299: ,p_proposed_salary_warning out nocopy boolean

Line 296: ,p_change_date in per_pay_proposals.change_date%TYPE

292: procedure chk_proposed_salary
293: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
294: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
295: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
296: ,p_change_date in per_pay_proposals.change_date%TYPE
297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
298: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
299: ,p_proposed_salary_warning out nocopy boolean
300: -- vkodedal added on 19-feb-2008 to fix multiple component upload issue

Line 297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

293: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
294: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
295: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
296: ,p_change_date in per_pay_proposals.change_date%TYPE
297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
298: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
299: ,p_proposed_salary_warning out nocopy boolean
300: -- vkodedal added on 19-feb-2008 to fix multiple component upload issue
301: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE

Line 298: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

294: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
295: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
296: ,p_change_date in per_pay_proposals.change_date%TYPE
297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
298: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
299: ,p_proposed_salary_warning out nocopy boolean
300: -- vkodedal added on 19-feb-2008 to fix multiple component upload issue
301: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
302: );

Line 301: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE

297: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
298: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
299: ,p_proposed_salary_warning out nocopy boolean
300: -- vkodedal added on 19-feb-2008 to fix multiple component upload issue
301: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
302: );
303: procedure is_salary_in_range_int
304: (p_organization_id in per_all_assignments_f.organization_id%TYPE
305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

Line 310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

306: ,p_position_id in per_all_assignments_f.position_id%TYPE
307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE
310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
311: ,p_change_date in per_pay_proposals.change_date%TYPE
312: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
313: ,p_prop_salary_link_warning out nocopy boolean
314: ,p_prop_salary_ele_warning out nocopy boolean

Line 311: ,p_change_date in per_pay_proposals.change_date%TYPE

307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE
310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
311: ,p_change_date in per_pay_proposals.change_date%TYPE
312: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
313: ,p_prop_salary_link_warning out nocopy boolean
314: ,p_prop_salary_ele_warning out nocopy boolean
315: ,p_prop_salary_grade_warning out nocopy boolean

Line 312: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE
310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
311: ,p_change_date in per_pay_proposals.change_date%TYPE
312: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
313: ,p_prop_salary_link_warning out nocopy boolean
314: ,p_prop_salary_ele_warning out nocopy boolean
315: ,p_prop_salary_grade_warning out nocopy boolean
316: --vkodedal 03-Jun-2009 8452388

Line 331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

327: ,p_position_id in per_all_assignments_f.position_id%TYPE
328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE
331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
332: ,p_change_date in per_pay_proposals.change_date%TYPE
333: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
334: ,p_prop_salary_link_warning out nocopy boolean
335: ,p_prop_salary_ele_warning out nocopy boolean

Line 332: ,p_change_date in per_pay_proposals.change_date%TYPE

328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE
331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
332: ,p_change_date in per_pay_proposals.change_date%TYPE
333: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
334: ,p_prop_salary_link_warning out nocopy boolean
335: ,p_prop_salary_ele_warning out nocopy boolean
336: ,p_prop_salary_grade_warning out nocopy boolean

Line 333: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE
331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
332: ,p_change_date in per_pay_proposals.change_date%TYPE
333: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
334: ,p_prop_salary_link_warning out nocopy boolean
335: ,p_prop_salary_ele_warning out nocopy boolean
336: ,p_prop_salary_grade_warning out nocopy boolean
337: );

Line 389: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

385: -- Access Status
386: -- Internal Table Handler Use Only.
387: --
388: procedure chk_approved
389: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
390: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
392: ,p_change_date in per_pay_proposals.change_date%TYPE
393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 390: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

386: -- Internal Table Handler Use Only.
387: --
388: procedure chk_approved
389: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
390: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
392: ,p_change_date in per_pay_proposals.change_date%TYPE
393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
394: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

387: --
388: procedure chk_approved
389: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
390: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
392: ,p_change_date in per_pay_proposals.change_date%TYPE
393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
394: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
395: ,p_approved in per_pay_proposals.approved%TYPE

Line 392: ,p_change_date in per_pay_proposals.change_date%TYPE

388: procedure chk_approved
389: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
390: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
392: ,p_change_date in per_pay_proposals.change_date%TYPE
393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
394: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
395: ,p_approved in per_pay_proposals.approved%TYPE
396: ,p_approved_warning out nocopy boolean

Line 393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

389: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
390: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
392: ,p_change_date in per_pay_proposals.change_date%TYPE
393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
394: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
395: ,p_approved in per_pay_proposals.approved%TYPE
396: ,p_approved_warning out nocopy boolean
397: );

Line 394: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

390: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
392: ,p_change_date in per_pay_proposals.change_date%TYPE
393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
394: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
395: ,p_approved in per_pay_proposals.approved%TYPE
396: ,p_approved_warning out nocopy boolean
397: );
398: --

Line 395: ,p_approved in per_pay_proposals.approved%TYPE

391: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
392: ,p_change_date in per_pay_proposals.change_date%TYPE
393: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
394: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
395: ,p_approved in per_pay_proposals.approved%TYPE
396: ,p_approved_warning out nocopy boolean
397: );
398: --
399: -- -----------------------------------------------------------------------

Line 422: (p_forced_ranking in per_pay_proposals.forced_ranking%TYPE);

418: -- - p_forced_ranking is less than 1
419: --
420: --
421: procedure chk_forced_ranking
422: (p_forced_ranking in per_pay_proposals.forced_ranking%TYPE);
423: --
424: -- ----------------------------------------------------------------------------
425: -- |----------------------< chk_performance_review_id >-----------------------|
426: -- ----------------------------------------------------------------------------

Line 452: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

448: -- Access Status:
449: -- Internal Table Handler Use Only.
450: --
451: procedure chk_performance_review_id
452: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
453: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
454: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
455: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
456: );

Line 453: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

449: -- Internal Table Handler Use Only.
450: --
451: procedure chk_performance_review_id
452: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
453: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
454: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
455: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
456: );
457: --

Line 454: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE

450: --
451: procedure chk_performance_review_id
452: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
453: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
454: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
455: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
456: );
457: --
458: -------------------------------------------------------------------------------

Line 455: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

451: procedure chk_performance_review_id
452: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
453: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
454: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
455: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
456: );
457: --
458: -------------------------------------------------------------------------------
459: -- |---------------------------< insert_validate >----------------------------|