DBA Data[Home] [Help]

APPS.PAY_RTU_UPD dependencies on PAY_RTU_SHD

Line 58: (p_rec in out nocopy pay_rtu_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_rtu_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 113: pay_rtu_shd.constraint_error

109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: pay_rtu_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --

Line 118: pay_rtu_shd.constraint_error

114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: pay_rtu_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: --
122: Raise;

Line 157: (p_rec in out nocopy pay_rtu_shd.g_rec_type

153: --
154: -- {End Of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure update_dml
157: (p_rec in out nocopy pay_rtu_shd.g_rec_type
158: ,p_effective_date in date
159: ,p_datetrack_mode in varchar2
160: ,p_validation_start_date in date
161: ,p_validation_end_date in date

Line 224: (p_rec in out nocopy pay_rtu_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure dt_pre_update
224: (p_rec in out nocopy pay_rtu_shd.g_rec_type
225: ,p_effective_date in date
226: ,p_datetrack_mode in varchar2
227: ,p_validation_start_date in date
228: ,p_validation_end_date in date

Line 240: pay_rtu_shd.upd_effective_end_date

236: If (p_datetrack_mode <> hr_api.g_correction) then
237: --
238: -- Update the current effective end date
239: --
240: pay_rtu_shd.upd_effective_end_date
241: (p_effective_date => p_effective_date
242: ,p_base_key_value => p_rec.run_type_usage_id
243: ,p_new_effective_end_date => (p_validation_start_date - 1)
244: ,p_validation_start_date => p_validation_start_date

Line 310: (p_rec in out nocopy pay_rtu_shd.g_rec_type

306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure pre_update
310: (p_rec in out nocopy pay_rtu_shd.g_rec_type
311: ,p_effective_date in date
312: ,p_datetrack_mode in varchar2
313: ,p_validation_start_date in date
314: ,p_validation_end_date in date

Line 368: (p_rec in pay_rtu_shd.g_rec_type

364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: Procedure post_update
368: (p_rec in pay_rtu_shd.g_rec_type
369: ,p_effective_date in date
370: ,p_datetrack_mode in varchar2
371: ,p_validation_start_date in date
372: ,p_validation_end_date in date

Line 401: => pay_rtu_shd.g_old_rec.parent_run_type_id

397: => p_rec.object_version_number
398: ,p_run_type_usage_id
399: => p_rec.run_type_usage_id
400: ,p_parent_run_type_id_o
401: => pay_rtu_shd.g_old_rec.parent_run_type_id
402: ,p_child_run_type_id_o
403: => pay_rtu_shd.g_old_rec.child_run_type_id
404: ,p_effective_start_date_o
405: => pay_rtu_shd.g_old_rec.effective_start_date

Line 403: => pay_rtu_shd.g_old_rec.child_run_type_id

399: => p_rec.run_type_usage_id
400: ,p_parent_run_type_id_o
401: => pay_rtu_shd.g_old_rec.parent_run_type_id
402: ,p_child_run_type_id_o
403: => pay_rtu_shd.g_old_rec.child_run_type_id
404: ,p_effective_start_date_o
405: => pay_rtu_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => pay_rtu_shd.g_old_rec.effective_end_date

Line 405: => pay_rtu_shd.g_old_rec.effective_start_date

401: => pay_rtu_shd.g_old_rec.parent_run_type_id
402: ,p_child_run_type_id_o
403: => pay_rtu_shd.g_old_rec.child_run_type_id
404: ,p_effective_start_date_o
405: => pay_rtu_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => pay_rtu_shd.g_old_rec.effective_end_date
408: ,p_sequence_o
409: => pay_rtu_shd.g_old_rec.sequence

Line 407: => pay_rtu_shd.g_old_rec.effective_end_date

403: => pay_rtu_shd.g_old_rec.child_run_type_id
404: ,p_effective_start_date_o
405: => pay_rtu_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => pay_rtu_shd.g_old_rec.effective_end_date
408: ,p_sequence_o
409: => pay_rtu_shd.g_old_rec.sequence
410: ,p_object_version_number_o
411: => pay_rtu_shd.g_old_rec.object_version_number

Line 409: => pay_rtu_shd.g_old_rec.sequence

405: => pay_rtu_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => pay_rtu_shd.g_old_rec.effective_end_date
408: ,p_sequence_o
409: => pay_rtu_shd.g_old_rec.sequence
410: ,p_object_version_number_o
411: => pay_rtu_shd.g_old_rec.object_version_number
412: ,p_business_group_id_o
413: => pay_rtu_shd.g_old_rec.business_group_id

Line 411: => pay_rtu_shd.g_old_rec.object_version_number

407: => pay_rtu_shd.g_old_rec.effective_end_date
408: ,p_sequence_o
409: => pay_rtu_shd.g_old_rec.sequence
410: ,p_object_version_number_o
411: => pay_rtu_shd.g_old_rec.object_version_number
412: ,p_business_group_id_o
413: => pay_rtu_shd.g_old_rec.business_group_id
414: ,p_legislation_code_o
415: => pay_rtu_shd.g_old_rec.legislation_code

Line 413: => pay_rtu_shd.g_old_rec.business_group_id

409: => pay_rtu_shd.g_old_rec.sequence
410: ,p_object_version_number_o
411: => pay_rtu_shd.g_old_rec.object_version_number
412: ,p_business_group_id_o
413: => pay_rtu_shd.g_old_rec.business_group_id
414: ,p_legislation_code_o
415: => pay_rtu_shd.g_old_rec.legislation_code
416: );
417: --

Line 415: => pay_rtu_shd.g_old_rec.legislation_code

411: => pay_rtu_shd.g_old_rec.object_version_number
412: ,p_business_group_id_o
413: => pay_rtu_shd.g_old_rec.business_group_id
414: ,p_legislation_code_o
415: => pay_rtu_shd.g_old_rec.legislation_code
416: );
417: --
418: exception
419: --

Line 475: (p_rec in out nocopy pay_rtu_shd.g_rec_type

471: --
472: -- {End Of Comments}
473: -- ----------------------------------------------------------------------------
474: Procedure convert_defs
475: (p_rec in out nocopy pay_rtu_shd.g_rec_type
476: ) is
477: --
478: Begin
479: --

Line 487: pay_rtu_shd.g_old_rec.parent_run_type_id;

483: -- is being used then we must set to the 'current' argument value.
484: --
485: If (p_rec.parent_run_type_id = hr_api.g_number) then
486: p_rec.parent_run_type_id :=
487: pay_rtu_shd.g_old_rec.parent_run_type_id;
488: End If;
489: If (p_rec.child_run_type_id = hr_api.g_number) then
490: p_rec.child_run_type_id :=
491: pay_rtu_shd.g_old_rec.child_run_type_id;

Line 491: pay_rtu_shd.g_old_rec.child_run_type_id;

487: pay_rtu_shd.g_old_rec.parent_run_type_id;
488: End If;
489: If (p_rec.child_run_type_id = hr_api.g_number) then
490: p_rec.child_run_type_id :=
491: pay_rtu_shd.g_old_rec.child_run_type_id;
492: End If;
493: If (p_rec.sequence = hr_api.g_number) then
494: p_rec.sequence :=
495: pay_rtu_shd.g_old_rec.sequence;

Line 495: pay_rtu_shd.g_old_rec.sequence;

491: pay_rtu_shd.g_old_rec.child_run_type_id;
492: End If;
493: If (p_rec.sequence = hr_api.g_number) then
494: p_rec.sequence :=
495: pay_rtu_shd.g_old_rec.sequence;
496: End If;
497: If (p_rec.business_group_id = hr_api.g_number) then
498: p_rec.business_group_id :=
499: pay_rtu_shd.g_old_rec.business_group_id;

Line 499: pay_rtu_shd.g_old_rec.business_group_id;

495: pay_rtu_shd.g_old_rec.sequence;
496: End If;
497: If (p_rec.business_group_id = hr_api.g_number) then
498: p_rec.business_group_id :=
499: pay_rtu_shd.g_old_rec.business_group_id;
500: End If;
501: If (p_rec.legislation_code = hr_api.g_varchar2) then
502: p_rec.legislation_code :=
503: pay_rtu_shd.g_old_rec.legislation_code;

Line 503: pay_rtu_shd.g_old_rec.legislation_code;

499: pay_rtu_shd.g_old_rec.business_group_id;
500: End If;
501: If (p_rec.legislation_code = hr_api.g_varchar2) then
502: p_rec.legislation_code :=
503: pay_rtu_shd.g_old_rec.legislation_code;
504: End If;
505: --
506: End convert_defs;
507: --

Line 514: ,p_rec in out nocopy pay_rtu_shd.g_rec_type

510: -- ----------------------------------------------------------------------------
511: Procedure upd
512: (p_effective_date in date
513: ,p_datetrack_mode in varchar2
514: ,p_rec in out nocopy pay_rtu_shd.g_rec_type
515: ) is
516: --
517: l_proc varchar2(72) := g_package||'upd';
518: l_validation_start_date date;

Line 530: pay_rtu_shd.lck

526: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
527: --
528: -- We must lock the row which we need to update.
529: --
530: pay_rtu_shd.lck
531: (p_effective_date => p_effective_date
532: ,p_datetrack_mode => p_datetrack_mode
533: ,p_run_type_usage_id => p_rec.run_type_usage_id
534: ,p_object_version_number => p_rec.object_version_number

Line 599: l_rec pay_rtu_shd.g_rec_type;

595: ,p_effective_start_date out nocopy date
596: ,p_effective_end_date out nocopy date
597: ) is
598: --
599: l_rec pay_rtu_shd.g_rec_type;
600: l_proc varchar2(72) := g_package||'upd';
601: --
602: Begin
603: hr_utility.set_location('Entering:'||l_proc, 5);

Line 609: pay_rtu_shd.convert_args

605: -- Call conversion function to turn arguments into the
606: -- l_rec structure.
607: --
608: l_rec :=
609: pay_rtu_shd.convert_args
610: (hr_api.g_number
611: ,hr_api.g_number
612: ,null
613: ,null