[Home] [Help]
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy pqh_sts_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: pqh_sts_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
129: pqh_sts_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: --
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: --
134: pqh_sts_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: --
138: Raise;
170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure pre_update
174: (p_rec in pqh_sts_shd.g_rec_type
175: ) is
176: --
177: l_proc varchar2(72) := g_package||'pre_update';
178: --
219: -- {End Of Comments}
220: -- ----------------------------------------------------------------------------
221: Procedure post_update
222: (p_effective_date in date
223: ,p_rec in pqh_sts_shd.g_rec_type
224: ) is
225: --
226: l_proc varchar2(72) := g_package||'post_update';
227: --
301: => p_rec.object_version_number
302: ,p_remunerate_assign_status_id
303: => p_rec.remunerate_assign_status_id
304: ,p_business_group_id_o
305: => pqh_sts_shd.g_old_rec.business_group_id
306: ,p_situation_name_o
307: => pqh_sts_shd.g_old_rec.situation_name
308: ,p_type_of_ps_o
309: => pqh_sts_shd.g_old_rec.type_of_ps
303: => p_rec.remunerate_assign_status_id
304: ,p_business_group_id_o
305: => pqh_sts_shd.g_old_rec.business_group_id
306: ,p_situation_name_o
307: => pqh_sts_shd.g_old_rec.situation_name
308: ,p_type_of_ps_o
309: => pqh_sts_shd.g_old_rec.type_of_ps
310: ,p_situation_type_o
311: => pqh_sts_shd.g_old_rec.situation_type
305: => pqh_sts_shd.g_old_rec.business_group_id
306: ,p_situation_name_o
307: => pqh_sts_shd.g_old_rec.situation_name
308: ,p_type_of_ps_o
309: => pqh_sts_shd.g_old_rec.type_of_ps
310: ,p_situation_type_o
311: => pqh_sts_shd.g_old_rec.situation_type
312: ,p_sub_type_o
313: => pqh_sts_shd.g_old_rec.sub_type
307: => pqh_sts_shd.g_old_rec.situation_name
308: ,p_type_of_ps_o
309: => pqh_sts_shd.g_old_rec.type_of_ps
310: ,p_situation_type_o
311: => pqh_sts_shd.g_old_rec.situation_type
312: ,p_sub_type_o
313: => pqh_sts_shd.g_old_rec.sub_type
314: ,p_source_o
315: => pqh_sts_shd.g_old_rec.source
309: => pqh_sts_shd.g_old_rec.type_of_ps
310: ,p_situation_type_o
311: => pqh_sts_shd.g_old_rec.situation_type
312: ,p_sub_type_o
313: => pqh_sts_shd.g_old_rec.sub_type
314: ,p_source_o
315: => pqh_sts_shd.g_old_rec.source
316: ,p_location_o
317: => pqh_sts_shd.g_old_rec.location
311: => pqh_sts_shd.g_old_rec.situation_type
312: ,p_sub_type_o
313: => pqh_sts_shd.g_old_rec.sub_type
314: ,p_source_o
315: => pqh_sts_shd.g_old_rec.source
316: ,p_location_o
317: => pqh_sts_shd.g_old_rec.location
318: ,p_reason_o
319: => pqh_sts_shd.g_old_rec.reason
313: => pqh_sts_shd.g_old_rec.sub_type
314: ,p_source_o
315: => pqh_sts_shd.g_old_rec.source
316: ,p_location_o
317: => pqh_sts_shd.g_old_rec.location
318: ,p_reason_o
319: => pqh_sts_shd.g_old_rec.reason
320: ,p_is_default_o
321: => pqh_sts_shd.g_old_rec.is_default
315: => pqh_sts_shd.g_old_rec.source
316: ,p_location_o
317: => pqh_sts_shd.g_old_rec.location
318: ,p_reason_o
319: => pqh_sts_shd.g_old_rec.reason
320: ,p_is_default_o
321: => pqh_sts_shd.g_old_rec.is_default
322: ,p_date_from_o
323: => pqh_sts_shd.g_old_rec.date_from
317: => pqh_sts_shd.g_old_rec.location
318: ,p_reason_o
319: => pqh_sts_shd.g_old_rec.reason
320: ,p_is_default_o
321: => pqh_sts_shd.g_old_rec.is_default
322: ,p_date_from_o
323: => pqh_sts_shd.g_old_rec.date_from
324: ,p_date_to_o
325: => pqh_sts_shd.g_old_rec.date_to
319: => pqh_sts_shd.g_old_rec.reason
320: ,p_is_default_o
321: => pqh_sts_shd.g_old_rec.is_default
322: ,p_date_from_o
323: => pqh_sts_shd.g_old_rec.date_from
324: ,p_date_to_o
325: => pqh_sts_shd.g_old_rec.date_to
326: ,p_request_type_o
327: => pqh_sts_shd.g_old_rec.request_type
321: => pqh_sts_shd.g_old_rec.is_default
322: ,p_date_from_o
323: => pqh_sts_shd.g_old_rec.date_from
324: ,p_date_to_o
325: => pqh_sts_shd.g_old_rec.date_to
326: ,p_request_type_o
327: => pqh_sts_shd.g_old_rec.request_type
328: ,p_employee_agreement_needed_o
329: => pqh_sts_shd.g_old_rec.employee_agreement_needed
323: => pqh_sts_shd.g_old_rec.date_from
324: ,p_date_to_o
325: => pqh_sts_shd.g_old_rec.date_to
326: ,p_request_type_o
327: => pqh_sts_shd.g_old_rec.request_type
328: ,p_employee_agreement_needed_o
329: => pqh_sts_shd.g_old_rec.employee_agreement_needed
330: ,p_manager_agreement_needed_o
331: => pqh_sts_shd.g_old_rec.manager_agreement_needed
325: => pqh_sts_shd.g_old_rec.date_to
326: ,p_request_type_o
327: => pqh_sts_shd.g_old_rec.request_type
328: ,p_employee_agreement_needed_o
329: => pqh_sts_shd.g_old_rec.employee_agreement_needed
330: ,p_manager_agreement_needed_o
331: => pqh_sts_shd.g_old_rec.manager_agreement_needed
332: ,p_print_arrette_o
333: => pqh_sts_shd.g_old_rec.print_arrette
327: => pqh_sts_shd.g_old_rec.request_type
328: ,p_employee_agreement_needed_o
329: => pqh_sts_shd.g_old_rec.employee_agreement_needed
330: ,p_manager_agreement_needed_o
331: => pqh_sts_shd.g_old_rec.manager_agreement_needed
332: ,p_print_arrette_o
333: => pqh_sts_shd.g_old_rec.print_arrette
334: ,p_reserve_position_o
335: => pqh_sts_shd.g_old_rec.reserve_position
329: => pqh_sts_shd.g_old_rec.employee_agreement_needed
330: ,p_manager_agreement_needed_o
331: => pqh_sts_shd.g_old_rec.manager_agreement_needed
332: ,p_print_arrette_o
333: => pqh_sts_shd.g_old_rec.print_arrette
334: ,p_reserve_position_o
335: => pqh_sts_shd.g_old_rec.reserve_position
336: ,p_allow_progressions_o
337: => pqh_sts_shd.g_old_rec.allow_progressions
331: => pqh_sts_shd.g_old_rec.manager_agreement_needed
332: ,p_print_arrette_o
333: => pqh_sts_shd.g_old_rec.print_arrette
334: ,p_reserve_position_o
335: => pqh_sts_shd.g_old_rec.reserve_position
336: ,p_allow_progressions_o
337: => pqh_sts_shd.g_old_rec.allow_progressions
338: ,p_extend_probation_period_o
339: => pqh_sts_shd.g_old_rec.extend_probation_period
333: => pqh_sts_shd.g_old_rec.print_arrette
334: ,p_reserve_position_o
335: => pqh_sts_shd.g_old_rec.reserve_position
336: ,p_allow_progressions_o
337: => pqh_sts_shd.g_old_rec.allow_progressions
338: ,p_extend_probation_period_o
339: => pqh_sts_shd.g_old_rec.extend_probation_period
340: ,p_remuneration_paid_o
341: => pqh_sts_shd.g_old_rec.remuneration_paid
335: => pqh_sts_shd.g_old_rec.reserve_position
336: ,p_allow_progressions_o
337: => pqh_sts_shd.g_old_rec.allow_progressions
338: ,p_extend_probation_period_o
339: => pqh_sts_shd.g_old_rec.extend_probation_period
340: ,p_remuneration_paid_o
341: => pqh_sts_shd.g_old_rec.remuneration_paid
342: ,p_pay_share_o
343: => pqh_sts_shd.g_old_rec.pay_share
337: => pqh_sts_shd.g_old_rec.allow_progressions
338: ,p_extend_probation_period_o
339: => pqh_sts_shd.g_old_rec.extend_probation_period
340: ,p_remuneration_paid_o
341: => pqh_sts_shd.g_old_rec.remuneration_paid
342: ,p_pay_share_o
343: => pqh_sts_shd.g_old_rec.pay_share
344: ,p_pay_periods_o
345: => pqh_sts_shd.g_old_rec.pay_periods
339: => pqh_sts_shd.g_old_rec.extend_probation_period
340: ,p_remuneration_paid_o
341: => pqh_sts_shd.g_old_rec.remuneration_paid
342: ,p_pay_share_o
343: => pqh_sts_shd.g_old_rec.pay_share
344: ,p_pay_periods_o
345: => pqh_sts_shd.g_old_rec.pay_periods
346: ,p_frequency_o
347: => pqh_sts_shd.g_old_rec.frequency
341: => pqh_sts_shd.g_old_rec.remuneration_paid
342: ,p_pay_share_o
343: => pqh_sts_shd.g_old_rec.pay_share
344: ,p_pay_periods_o
345: => pqh_sts_shd.g_old_rec.pay_periods
346: ,p_frequency_o
347: => pqh_sts_shd.g_old_rec.frequency
348: ,p_first_period_max_duration_o
349: => pqh_sts_shd.g_old_rec.first_period_max_duration
343: => pqh_sts_shd.g_old_rec.pay_share
344: ,p_pay_periods_o
345: => pqh_sts_shd.g_old_rec.pay_periods
346: ,p_frequency_o
347: => pqh_sts_shd.g_old_rec.frequency
348: ,p_first_period_max_duration_o
349: => pqh_sts_shd.g_old_rec.first_period_max_duration
350: ,p_min_duration_per_request_o
351: => pqh_sts_shd.g_old_rec.min_duration_per_request
345: => pqh_sts_shd.g_old_rec.pay_periods
346: ,p_frequency_o
347: => pqh_sts_shd.g_old_rec.frequency
348: ,p_first_period_max_duration_o
349: => pqh_sts_shd.g_old_rec.first_period_max_duration
350: ,p_min_duration_per_request_o
351: => pqh_sts_shd.g_old_rec.min_duration_per_request
352: ,p_max_duration_per_request_o
353: => pqh_sts_shd.g_old_rec.max_duration_per_request
347: => pqh_sts_shd.g_old_rec.frequency
348: ,p_first_period_max_duration_o
349: => pqh_sts_shd.g_old_rec.first_period_max_duration
350: ,p_min_duration_per_request_o
351: => pqh_sts_shd.g_old_rec.min_duration_per_request
352: ,p_max_duration_per_request_o
353: => pqh_sts_shd.g_old_rec.max_duration_per_request
354: ,p_max_duration_whole_career_o
355: => pqh_sts_shd.g_old_rec.max_duration_whole_career
349: => pqh_sts_shd.g_old_rec.first_period_max_duration
350: ,p_min_duration_per_request_o
351: => pqh_sts_shd.g_old_rec.min_duration_per_request
352: ,p_max_duration_per_request_o
353: => pqh_sts_shd.g_old_rec.max_duration_per_request
354: ,p_max_duration_whole_career_o
355: => pqh_sts_shd.g_old_rec.max_duration_whole_career
356: ,p_renewable_allowed_o
357: => pqh_sts_shd.g_old_rec.renewable_allowed
351: => pqh_sts_shd.g_old_rec.min_duration_per_request
352: ,p_max_duration_per_request_o
353: => pqh_sts_shd.g_old_rec.max_duration_per_request
354: ,p_max_duration_whole_career_o
355: => pqh_sts_shd.g_old_rec.max_duration_whole_career
356: ,p_renewable_allowed_o
357: => pqh_sts_shd.g_old_rec.renewable_allowed
358: ,p_max_no_of_renewals_o
359: => pqh_sts_shd.g_old_rec.max_no_of_renewals
353: => pqh_sts_shd.g_old_rec.max_duration_per_request
354: ,p_max_duration_whole_career_o
355: => pqh_sts_shd.g_old_rec.max_duration_whole_career
356: ,p_renewable_allowed_o
357: => pqh_sts_shd.g_old_rec.renewable_allowed
358: ,p_max_no_of_renewals_o
359: => pqh_sts_shd.g_old_rec.max_no_of_renewals
360: ,p_max_duration_per_renewal_o
361: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
355: => pqh_sts_shd.g_old_rec.max_duration_whole_career
356: ,p_renewable_allowed_o
357: => pqh_sts_shd.g_old_rec.renewable_allowed
358: ,p_max_no_of_renewals_o
359: => pqh_sts_shd.g_old_rec.max_no_of_renewals
360: ,p_max_duration_per_renewal_o
361: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
362: ,p_max_tot_continuous_duratio_o
363: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
357: => pqh_sts_shd.g_old_rec.renewable_allowed
358: ,p_max_no_of_renewals_o
359: => pqh_sts_shd.g_old_rec.max_no_of_renewals
360: ,p_max_duration_per_renewal_o
361: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
362: ,p_max_tot_continuous_duratio_o
363: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
364: ,p_object_version_number_o
365: => pqh_sts_shd.g_old_rec.object_version_number
359: => pqh_sts_shd.g_old_rec.max_no_of_renewals
360: ,p_max_duration_per_renewal_o
361: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
362: ,p_max_tot_continuous_duratio_o
363: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
364: ,p_object_version_number_o
365: => pqh_sts_shd.g_old_rec.object_version_number
366: ,p_remunerate_assign_stat_id_o
367: => pqh_sts_shd.g_old_rec.remunerate_assign_status_id
361: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
362: ,p_max_tot_continuous_duratio_o
363: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
364: ,p_object_version_number_o
365: => pqh_sts_shd.g_old_rec.object_version_number
366: ,p_remunerate_assign_stat_id_o
367: => pqh_sts_shd.g_old_rec.remunerate_assign_status_id
368: );
369: --
363: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
364: ,p_object_version_number_o
365: => pqh_sts_shd.g_old_rec.object_version_number
366: ,p_remunerate_assign_stat_id_o
367: => pqh_sts_shd.g_old_rec.remunerate_assign_status_id
368: );
369: --
370: exception
371: --
428: --
429: -- {End Of Comments}
430: -- ----------------------------------------------------------------------------
431: Procedure convert_defs
432: (p_rec in out nocopy pqh_sts_shd.g_rec_type
433: ) is
434: --
435: Begin
436: --
440: -- is being used then we must set to the 'current' argument value.
441: --
442: If (p_rec.business_group_id = hr_api.g_number) then
443: p_rec.business_group_id :=
444: pqh_sts_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.situation_name = hr_api.g_varchar2) then
447: p_rec.situation_name :=
448: pqh_sts_shd.g_old_rec.situation_name;
444: pqh_sts_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.situation_name = hr_api.g_varchar2) then
447: p_rec.situation_name :=
448: pqh_sts_shd.g_old_rec.situation_name;
449: End If;
450: If (p_rec.type_of_ps = hr_api.g_varchar2) then
451: p_rec.type_of_ps :=
452: pqh_sts_shd.g_old_rec.type_of_ps;
448: pqh_sts_shd.g_old_rec.situation_name;
449: End If;
450: If (p_rec.type_of_ps = hr_api.g_varchar2) then
451: p_rec.type_of_ps :=
452: pqh_sts_shd.g_old_rec.type_of_ps;
453: End If;
454: If (p_rec.situation_type = hr_api.g_varchar2) then
455: p_rec.situation_type :=
456: pqh_sts_shd.g_old_rec.situation_type;
452: pqh_sts_shd.g_old_rec.type_of_ps;
453: End If;
454: If (p_rec.situation_type = hr_api.g_varchar2) then
455: p_rec.situation_type :=
456: pqh_sts_shd.g_old_rec.situation_type;
457: End If;
458: If (p_rec.sub_type = hr_api.g_varchar2) then
459: p_rec.sub_type :=
460: pqh_sts_shd.g_old_rec.sub_type;
456: pqh_sts_shd.g_old_rec.situation_type;
457: End If;
458: If (p_rec.sub_type = hr_api.g_varchar2) then
459: p_rec.sub_type :=
460: pqh_sts_shd.g_old_rec.sub_type;
461: End If;
462: If (p_rec.source = hr_api.g_varchar2) then
463: p_rec.source :=
464: pqh_sts_shd.g_old_rec.source;
460: pqh_sts_shd.g_old_rec.sub_type;
461: End If;
462: If (p_rec.source = hr_api.g_varchar2) then
463: p_rec.source :=
464: pqh_sts_shd.g_old_rec.source;
465: End If;
466: If (p_rec.location = hr_api.g_varchar2) then
467: p_rec.location :=
468: pqh_sts_shd.g_old_rec.location;
464: pqh_sts_shd.g_old_rec.source;
465: End If;
466: If (p_rec.location = hr_api.g_varchar2) then
467: p_rec.location :=
468: pqh_sts_shd.g_old_rec.location;
469: End If;
470: If (p_rec.reason = hr_api.g_varchar2) then
471: p_rec.reason :=
472: pqh_sts_shd.g_old_rec.reason;
468: pqh_sts_shd.g_old_rec.location;
469: End If;
470: If (p_rec.reason = hr_api.g_varchar2) then
471: p_rec.reason :=
472: pqh_sts_shd.g_old_rec.reason;
473: End If;
474: If (p_rec.is_default = hr_api.g_varchar2) then
475: p_rec.is_default :=
476: pqh_sts_shd.g_old_rec.is_default;
472: pqh_sts_shd.g_old_rec.reason;
473: End If;
474: If (p_rec.is_default = hr_api.g_varchar2) then
475: p_rec.is_default :=
476: pqh_sts_shd.g_old_rec.is_default;
477: End If;
478: If (p_rec.date_from = hr_api.g_date) then
479: p_rec.date_from :=
480: pqh_sts_shd.g_old_rec.date_from;
476: pqh_sts_shd.g_old_rec.is_default;
477: End If;
478: If (p_rec.date_from = hr_api.g_date) then
479: p_rec.date_from :=
480: pqh_sts_shd.g_old_rec.date_from;
481: End If;
482: If (p_rec.date_to = hr_api.g_date) then
483: p_rec.date_to :=
484: pqh_sts_shd.g_old_rec.date_to;
480: pqh_sts_shd.g_old_rec.date_from;
481: End If;
482: If (p_rec.date_to = hr_api.g_date) then
483: p_rec.date_to :=
484: pqh_sts_shd.g_old_rec.date_to;
485: End If;
486: If (p_rec.request_type = hr_api.g_varchar2) then
487: p_rec.request_type :=
488: pqh_sts_shd.g_old_rec.request_type;
484: pqh_sts_shd.g_old_rec.date_to;
485: End If;
486: If (p_rec.request_type = hr_api.g_varchar2) then
487: p_rec.request_type :=
488: pqh_sts_shd.g_old_rec.request_type;
489: End If;
490: If (p_rec.employee_agreement_needed = hr_api.g_varchar2) then
491: p_rec.employee_agreement_needed :=
492: pqh_sts_shd.g_old_rec.employee_agreement_needed;
488: pqh_sts_shd.g_old_rec.request_type;
489: End If;
490: If (p_rec.employee_agreement_needed = hr_api.g_varchar2) then
491: p_rec.employee_agreement_needed :=
492: pqh_sts_shd.g_old_rec.employee_agreement_needed;
493: End If;
494: If (p_rec.manager_agreement_needed = hr_api.g_varchar2) then
495: p_rec.manager_agreement_needed :=
496: pqh_sts_shd.g_old_rec.manager_agreement_needed;
492: pqh_sts_shd.g_old_rec.employee_agreement_needed;
493: End If;
494: If (p_rec.manager_agreement_needed = hr_api.g_varchar2) then
495: p_rec.manager_agreement_needed :=
496: pqh_sts_shd.g_old_rec.manager_agreement_needed;
497: End If;
498: If (p_rec.print_arrette = hr_api.g_varchar2) then
499: p_rec.print_arrette :=
500: pqh_sts_shd.g_old_rec.print_arrette;
496: pqh_sts_shd.g_old_rec.manager_agreement_needed;
497: End If;
498: If (p_rec.print_arrette = hr_api.g_varchar2) then
499: p_rec.print_arrette :=
500: pqh_sts_shd.g_old_rec.print_arrette;
501: End If;
502: If (p_rec.reserve_position = hr_api.g_varchar2) then
503: p_rec.reserve_position :=
504: pqh_sts_shd.g_old_rec.reserve_position;
500: pqh_sts_shd.g_old_rec.print_arrette;
501: End If;
502: If (p_rec.reserve_position = hr_api.g_varchar2) then
503: p_rec.reserve_position :=
504: pqh_sts_shd.g_old_rec.reserve_position;
505: End If;
506: If (p_rec.allow_progressions = hr_api.g_varchar2) then
507: p_rec.allow_progressions :=
508: pqh_sts_shd.g_old_rec.reserve_position;
504: pqh_sts_shd.g_old_rec.reserve_position;
505: End If;
506: If (p_rec.allow_progressions = hr_api.g_varchar2) then
507: p_rec.allow_progressions :=
508: pqh_sts_shd.g_old_rec.reserve_position;
509: End If;
510: If (p_rec.extend_probation_period = hr_api.g_varchar2) then
511: p_rec.extend_probation_period :=
512: pqh_sts_shd.g_old_rec.reserve_position;
508: pqh_sts_shd.g_old_rec.reserve_position;
509: End If;
510: If (p_rec.extend_probation_period = hr_api.g_varchar2) then
511: p_rec.extend_probation_period :=
512: pqh_sts_shd.g_old_rec.reserve_position;
513: End If;
514: If (p_rec.remuneration_paid = hr_api.g_varchar2) then
515: p_rec.remuneration_paid :=
516: pqh_sts_shd.g_old_rec.remuneration_paid;
512: pqh_sts_shd.g_old_rec.reserve_position;
513: End If;
514: If (p_rec.remuneration_paid = hr_api.g_varchar2) then
515: p_rec.remuneration_paid :=
516: pqh_sts_shd.g_old_rec.remuneration_paid;
517: End If;
518: If (p_rec.pay_share = hr_api.g_number) then
519: p_rec.pay_share :=
520: pqh_sts_shd.g_old_rec.pay_share;
516: pqh_sts_shd.g_old_rec.remuneration_paid;
517: End If;
518: If (p_rec.pay_share = hr_api.g_number) then
519: p_rec.pay_share :=
520: pqh_sts_shd.g_old_rec.pay_share;
521: End If;
522: If (p_rec.pay_periods = hr_api.g_number) then
523: p_rec.pay_periods :=
524: pqh_sts_shd.g_old_rec.pay_periods;
520: pqh_sts_shd.g_old_rec.pay_share;
521: End If;
522: If (p_rec.pay_periods = hr_api.g_number) then
523: p_rec.pay_periods :=
524: pqh_sts_shd.g_old_rec.pay_periods;
525: End If;
526: If (p_rec.frequency = hr_api.g_varchar2) then
527: p_rec.frequency :=
528: pqh_sts_shd.g_old_rec.frequency;
524: pqh_sts_shd.g_old_rec.pay_periods;
525: End If;
526: If (p_rec.frequency = hr_api.g_varchar2) then
527: p_rec.frequency :=
528: pqh_sts_shd.g_old_rec.frequency;
529: End If;
530: If (p_rec.first_period_max_duration = hr_api.g_number) then
531: p_rec.first_period_max_duration :=
532: pqh_sts_shd.g_old_rec.first_period_max_duration;
528: pqh_sts_shd.g_old_rec.frequency;
529: End If;
530: If (p_rec.first_period_max_duration = hr_api.g_number) then
531: p_rec.first_period_max_duration :=
532: pqh_sts_shd.g_old_rec.first_period_max_duration;
533: End If;
534: If (p_rec.min_duration_per_request = hr_api.g_number) then
535: p_rec.min_duration_per_request :=
536: pqh_sts_shd.g_old_rec.min_duration_per_request;
532: pqh_sts_shd.g_old_rec.first_period_max_duration;
533: End If;
534: If (p_rec.min_duration_per_request = hr_api.g_number) then
535: p_rec.min_duration_per_request :=
536: pqh_sts_shd.g_old_rec.min_duration_per_request;
537: End If;
538: If (p_rec.max_duration_per_request = hr_api.g_number) then
539: p_rec.max_duration_per_request :=
540: pqh_sts_shd.g_old_rec.max_duration_per_request;
536: pqh_sts_shd.g_old_rec.min_duration_per_request;
537: End If;
538: If (p_rec.max_duration_per_request = hr_api.g_number) then
539: p_rec.max_duration_per_request :=
540: pqh_sts_shd.g_old_rec.max_duration_per_request;
541: End If;
542: If (p_rec.max_duration_whole_career = hr_api.g_number) then
543: p_rec.max_duration_whole_career :=
544: pqh_sts_shd.g_old_rec.max_duration_whole_career;
540: pqh_sts_shd.g_old_rec.max_duration_per_request;
541: End If;
542: If (p_rec.max_duration_whole_career = hr_api.g_number) then
543: p_rec.max_duration_whole_career :=
544: pqh_sts_shd.g_old_rec.max_duration_whole_career;
545: End If;
546: If (p_rec.renewable_allowed = hr_api.g_varchar2) then
547: p_rec.renewable_allowed :=
548: pqh_sts_shd.g_old_rec.renewable_allowed;
544: pqh_sts_shd.g_old_rec.max_duration_whole_career;
545: End If;
546: If (p_rec.renewable_allowed = hr_api.g_varchar2) then
547: p_rec.renewable_allowed :=
548: pqh_sts_shd.g_old_rec.renewable_allowed;
549: End If;
550: If (p_rec.max_no_of_renewals = hr_api.g_number) then
551: p_rec.max_no_of_renewals :=
552: pqh_sts_shd.g_old_rec.max_no_of_renewals;
548: pqh_sts_shd.g_old_rec.renewable_allowed;
549: End If;
550: If (p_rec.max_no_of_renewals = hr_api.g_number) then
551: p_rec.max_no_of_renewals :=
552: pqh_sts_shd.g_old_rec.max_no_of_renewals;
553: End If;
554: If (p_rec.max_duration_per_renewal = hr_api.g_number) then
555: p_rec.max_duration_per_renewal :=
556: pqh_sts_shd.g_old_rec.max_duration_per_renewal;
552: pqh_sts_shd.g_old_rec.max_no_of_renewals;
553: End If;
554: If (p_rec.max_duration_per_renewal = hr_api.g_number) then
555: p_rec.max_duration_per_renewal :=
556: pqh_sts_shd.g_old_rec.max_duration_per_renewal;
557: End If;
558: If (p_rec.max_tot_continuous_duration = hr_api.g_number) then
559: p_rec.max_tot_continuous_duration :=
560: pqh_sts_shd.g_old_rec.max_tot_continuous_duration;
556: pqh_sts_shd.g_old_rec.max_duration_per_renewal;
557: End If;
558: If (p_rec.max_tot_continuous_duration = hr_api.g_number) then
559: p_rec.max_tot_continuous_duration :=
560: pqh_sts_shd.g_old_rec.max_tot_continuous_duration;
561: End If;
562: If (p_rec.remunerate_assign_status_id = hr_api.g_number) then
563: p_rec.remunerate_assign_status_id :=
564: pqh_sts_shd.g_old_rec.remunerate_assign_status_id;
560: pqh_sts_shd.g_old_rec.max_tot_continuous_duration;
561: End If;
562: If (p_rec.remunerate_assign_status_id = hr_api.g_number) then
563: p_rec.remunerate_assign_status_id :=
564: pqh_sts_shd.g_old_rec.remunerate_assign_status_id;
565: End If;
566: --
567: End convert_defs;
568: --
570: -- |---------------------------------< upd >----------------------------------|
571: -- ----------------------------------------------------------------------------
572: Procedure upd
573: (p_effective_date in date
574: ,p_rec in out nocopy pqh_sts_shd.g_rec_type
575: ) is
576: --
577: l_proc varchar2(72) := g_package||'upd';
578: --
587: End if;
588: --
589: -- We must lock the row which we need to update.
590: --
591: pqh_sts_shd.lck
592: (p_rec.statutory_situation_id
593: ,p_rec.object_version_number
594: );
595: --
666: ,p_max_tot_continuous_duration in number default hr_api.g_number
667: ,p_remunerate_assign_status_id in number default hr_api.g_number
668: ) is
669: --
670: l_rec pqh_sts_shd.g_rec_type;
671: l_proc varchar2(72) := g_package||'upd';
672: --
673: Begin
674:
683: -- Call conversion function to turn arguments into the
684: -- l_rec structure.
685: --
686: l_rec :=
687: pqh_sts_shd.convert_args
688: (p_statutory_situation_id
689: ,p_business_group_id
690: ,p_situation_name
691: ,p_type_of_ps