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: );

Line 368: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

364: -- Access Status
365: -- Internal Table Handler Use Only.
366: --
367: procedure chk_approved
368: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
369: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
371: ,p_change_date in per_pay_proposals.change_date%TYPE
372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 369: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

365: -- Internal Table Handler Use Only.
366: --
367: procedure chk_approved
368: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
369: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
371: ,p_change_date in per_pay_proposals.change_date%TYPE
372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
373: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

366: --
367: procedure chk_approved
368: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
369: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
371: ,p_change_date in per_pay_proposals.change_date%TYPE
372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
373: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
374: ,p_approved in per_pay_proposals.approved%TYPE

Line 371: ,p_change_date in per_pay_proposals.change_date%TYPE

367: procedure chk_approved
368: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
369: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
371: ,p_change_date in per_pay_proposals.change_date%TYPE
372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
373: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
374: ,p_approved in per_pay_proposals.approved%TYPE
375: ,p_approved_warning out nocopy boolean

Line 372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

368: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
369: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
371: ,p_change_date in per_pay_proposals.change_date%TYPE
372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
373: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
374: ,p_approved in per_pay_proposals.approved%TYPE
375: ,p_approved_warning out nocopy boolean
376: );

Line 373: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

369: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
371: ,p_change_date in per_pay_proposals.change_date%TYPE
372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
373: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
374: ,p_approved in per_pay_proposals.approved%TYPE
375: ,p_approved_warning out nocopy boolean
376: );
377: --

Line 374: ,p_approved in per_pay_proposals.approved%TYPE

370: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
371: ,p_change_date in per_pay_proposals.change_date%TYPE
372: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
373: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
374: ,p_approved in per_pay_proposals.approved%TYPE
375: ,p_approved_warning out nocopy boolean
376: );
377: --
378: -- -----------------------------------------------------------------------

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

397: -- - p_forced_ranking is less than 1
398: --
399: --
400: procedure chk_forced_ranking
401: (p_forced_ranking in per_pay_proposals.forced_ranking%TYPE);
402: --
403: -- ----------------------------------------------------------------------------
404: -- |----------------------< chk_performance_review_id >-----------------------|
405: -- ----------------------------------------------------------------------------

Line 431: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

427: -- Access Status:
428: -- Internal Table Handler Use Only.
429: --
430: procedure chk_performance_review_id
431: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
432: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
433: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
434: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
435: );

Line 432: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

428: -- Internal Table Handler Use Only.
429: --
430: procedure chk_performance_review_id
431: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
432: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
433: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
434: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
435: );
436: --

Line 433: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE

429: --
430: procedure chk_performance_review_id
431: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
432: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
433: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
434: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
435: );
436: --
437: -------------------------------------------------------------------------------

Line 434: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

430: procedure chk_performance_review_id
431: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
432: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
433: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
434: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
435: );
436: --
437: -------------------------------------------------------------------------------
438: -- |---------------------------< insert_validate >----------------------------|