DBA Data[Home] [Help]

APPS.PAY_ECU_UPD dependencies on PAY_ECU_SHD

Line 58: (p_rec in out nocopy pay_ecu_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_ecu_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 112: pay_ecu_shd.constraint_error

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

Line 117: pay_ecu_shd.constraint_error

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

Line 156: (p_rec in out nocopy pay_ecu_shd.g_rec_type

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

Line 223: (p_rec in out nocopy pay_ecu_shd.g_rec_type

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

Line 239: pay_ecu_shd.upd_effective_end_date

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

Line 308: (p_rec in out nocopy pay_ecu_shd.g_rec_type

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

Line 366: (p_rec in pay_ecu_shd.g_rec_type

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

Line 405: => pay_ecu_shd.g_old_rec.effective_start_date

401: => p_rec.legislation_code
402: ,p_object_version_number
403: => p_rec.object_version_number
404: ,p_effective_start_date_o
405: => pay_ecu_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => pay_ecu_shd.g_old_rec.effective_end_date
408: ,p_run_type_id_o
409: => pay_ecu_shd.g_old_rec.run_type_id

Line 407: => pay_ecu_shd.g_old_rec.effective_end_date

403: => p_rec.object_version_number
404: ,p_effective_start_date_o
405: => pay_ecu_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => pay_ecu_shd.g_old_rec.effective_end_date
408: ,p_run_type_id_o
409: => pay_ecu_shd.g_old_rec.run_type_id
410: ,p_classification_id_o
411: => pay_ecu_shd.g_old_rec.classification_id

Line 409: => pay_ecu_shd.g_old_rec.run_type_id

405: => pay_ecu_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => pay_ecu_shd.g_old_rec.effective_end_date
408: ,p_run_type_id_o
409: => pay_ecu_shd.g_old_rec.run_type_id
410: ,p_classification_id_o
411: => pay_ecu_shd.g_old_rec.classification_id
412: ,p_business_group_id_o
413: => pay_ecu_shd.g_old_rec.business_group_id

Line 411: => pay_ecu_shd.g_old_rec.classification_id

407: => pay_ecu_shd.g_old_rec.effective_end_date
408: ,p_run_type_id_o
409: => pay_ecu_shd.g_old_rec.run_type_id
410: ,p_classification_id_o
411: => pay_ecu_shd.g_old_rec.classification_id
412: ,p_business_group_id_o
413: => pay_ecu_shd.g_old_rec.business_group_id
414: ,p_legislation_code_o
415: => pay_ecu_shd.g_old_rec.legislation_code

Line 413: => pay_ecu_shd.g_old_rec.business_group_id

409: => pay_ecu_shd.g_old_rec.run_type_id
410: ,p_classification_id_o
411: => pay_ecu_shd.g_old_rec.classification_id
412: ,p_business_group_id_o
413: => pay_ecu_shd.g_old_rec.business_group_id
414: ,p_legislation_code_o
415: => pay_ecu_shd.g_old_rec.legislation_code
416: ,p_object_version_number_o
417: => pay_ecu_shd.g_old_rec.object_version_number

Line 415: => pay_ecu_shd.g_old_rec.legislation_code

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

Line 417: => pay_ecu_shd.g_old_rec.object_version_number

413: => pay_ecu_shd.g_old_rec.business_group_id
414: ,p_legislation_code_o
415: => pay_ecu_shd.g_old_rec.legislation_code
416: ,p_object_version_number_o
417: => pay_ecu_shd.g_old_rec.object_version_number
418: );
419: --
420: exception
421: --

Line 477: (p_rec in out nocopy pay_ecu_shd.g_rec_type

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

Line 489: pay_ecu_shd.g_old_rec.run_type_id;

485: -- is being used then we must set to the 'current' argument value.
486: --
487: If (p_rec.run_type_id = hr_api.g_number) then
488: p_rec.run_type_id :=
489: pay_ecu_shd.g_old_rec.run_type_id;
490: End If;
491: If (p_rec.classification_id = hr_api.g_number) then
492: p_rec.classification_id :=
493: pay_ecu_shd.g_old_rec.classification_id;

Line 493: pay_ecu_shd.g_old_rec.classification_id;

489: pay_ecu_shd.g_old_rec.run_type_id;
490: End If;
491: If (p_rec.classification_id = hr_api.g_number) then
492: p_rec.classification_id :=
493: pay_ecu_shd.g_old_rec.classification_id;
494: End If;
495: If (p_rec.business_group_id = hr_api.g_number) then
496: p_rec.business_group_id :=
497: pay_ecu_shd.g_old_rec.business_group_id;

Line 497: pay_ecu_shd.g_old_rec.business_group_id;

493: pay_ecu_shd.g_old_rec.classification_id;
494: End If;
495: If (p_rec.business_group_id = hr_api.g_number) then
496: p_rec.business_group_id :=
497: pay_ecu_shd.g_old_rec.business_group_id;
498: End If;
499: If (p_rec.legislation_code = hr_api.g_varchar2) then
500: p_rec.legislation_code :=
501: pay_ecu_shd.g_old_rec.legislation_code;

Line 501: pay_ecu_shd.g_old_rec.legislation_code;

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

Line 512: ,p_rec in out nocopy pay_ecu_shd.g_rec_type

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

Line 528: pay_ecu_shd.lck

524: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
525: --
526: -- We must lock the row which we need to update.
527: --
528: pay_ecu_shd.lck
529: (p_effective_date => p_effective_date
530: ,p_datetrack_mode => p_datetrack_mode
531: ,p_element_class_usage_id => p_rec.element_class_usage_id
532: ,p_object_version_number => p_rec.object_version_number

Line 606: l_rec pay_ecu_shd.g_rec_type;

602: ,p_effective_start_date out nocopy date
603: ,p_effective_end_date out nocopy date
604: ) is
605: --
606: l_rec pay_ecu_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'upd';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);

Line 616: pay_ecu_shd.convert_args

612: -- Call conversion function to turn arguments into the
613: -- l_rec structure.
614: --
615: l_rec :=
616: pay_ecu_shd.convert_args
617: (p_element_class_usage_id
618: ,null
619: ,null
620: ,p_run_type_id