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.PAY_ETU_UPD dependencies on PAY_ETU_SHD

Line 58: (p_rec in out nocopy pay_etu_shd.g_rec_type

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

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

Line 119: pay_etu_shd.constraint_error

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

Line 158: (p_rec in out nocopy pay_etu_shd.g_rec_type

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

Line 225: (p_rec in out nocopy pay_etu_shd.g_rec_type

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

Line 241: pay_etu_shd.upd_effective_end_date

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

Line 311: (p_rec in out nocopy pay_etu_shd.g_rec_type

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

Line 369: (p_rec in pay_etu_shd.g_rec_type

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

Line 404: => pay_etu_shd.g_old_rec.run_type_id

400: => p_rec.inclusion_flag
401: ,p_usage_type
402: => p_rec.usage_type
403: ,p_run_type_id_o
404: => pay_etu_shd.g_old_rec.run_type_id
405: ,p_element_type_id_o
406: => pay_etu_shd.g_old_rec.element_type_id
407: ,p_inclusion_flag_o
408: => pay_etu_shd.g_old_rec.inclusion_flag

Line 406: => pay_etu_shd.g_old_rec.element_type_id

402: => p_rec.usage_type
403: ,p_run_type_id_o
404: => pay_etu_shd.g_old_rec.run_type_id
405: ,p_element_type_id_o
406: => pay_etu_shd.g_old_rec.element_type_id
407: ,p_inclusion_flag_o
408: => pay_etu_shd.g_old_rec.inclusion_flag
409: ,p_effective_start_date_o
410: => pay_etu_shd.g_old_rec.effective_start_date

Line 408: => pay_etu_shd.g_old_rec.inclusion_flag

404: => pay_etu_shd.g_old_rec.run_type_id
405: ,p_element_type_id_o
406: => pay_etu_shd.g_old_rec.element_type_id
407: ,p_inclusion_flag_o
408: => pay_etu_shd.g_old_rec.inclusion_flag
409: ,p_effective_start_date_o
410: => pay_etu_shd.g_old_rec.effective_start_date
411: ,p_effective_end_date_o
412: => pay_etu_shd.g_old_rec.effective_end_date

Line 410: => pay_etu_shd.g_old_rec.effective_start_date

406: => pay_etu_shd.g_old_rec.element_type_id
407: ,p_inclusion_flag_o
408: => pay_etu_shd.g_old_rec.inclusion_flag
409: ,p_effective_start_date_o
410: => pay_etu_shd.g_old_rec.effective_start_date
411: ,p_effective_end_date_o
412: => pay_etu_shd.g_old_rec.effective_end_date
413: ,p_object_version_number_o
414: => pay_etu_shd.g_old_rec.object_version_number

Line 412: => pay_etu_shd.g_old_rec.effective_end_date

408: => pay_etu_shd.g_old_rec.inclusion_flag
409: ,p_effective_start_date_o
410: => pay_etu_shd.g_old_rec.effective_start_date
411: ,p_effective_end_date_o
412: => pay_etu_shd.g_old_rec.effective_end_date
413: ,p_object_version_number_o
414: => pay_etu_shd.g_old_rec.object_version_number
415: ,p_business_group_id_o
416: => pay_etu_shd.g_old_rec.business_group_id

Line 414: => pay_etu_shd.g_old_rec.object_version_number

410: => pay_etu_shd.g_old_rec.effective_start_date
411: ,p_effective_end_date_o
412: => pay_etu_shd.g_old_rec.effective_end_date
413: ,p_object_version_number_o
414: => pay_etu_shd.g_old_rec.object_version_number
415: ,p_business_group_id_o
416: => pay_etu_shd.g_old_rec.business_group_id
417: ,p_legislation_code_o
418: => pay_etu_shd.g_old_rec.legislation_code

Line 416: => pay_etu_shd.g_old_rec.business_group_id

412: => pay_etu_shd.g_old_rec.effective_end_date
413: ,p_object_version_number_o
414: => pay_etu_shd.g_old_rec.object_version_number
415: ,p_business_group_id_o
416: => pay_etu_shd.g_old_rec.business_group_id
417: ,p_legislation_code_o
418: => pay_etu_shd.g_old_rec.legislation_code
419: ,p_usage_type_o
420: => pay_etu_shd.g_old_rec.usage_type

Line 418: => pay_etu_shd.g_old_rec.legislation_code

414: => pay_etu_shd.g_old_rec.object_version_number
415: ,p_business_group_id_o
416: => pay_etu_shd.g_old_rec.business_group_id
417: ,p_legislation_code_o
418: => pay_etu_shd.g_old_rec.legislation_code
419: ,p_usage_type_o
420: => pay_etu_shd.g_old_rec.usage_type
421: );
422: --

Line 420: => pay_etu_shd.g_old_rec.usage_type

416: => pay_etu_shd.g_old_rec.business_group_id
417: ,p_legislation_code_o
418: => pay_etu_shd.g_old_rec.legislation_code
419: ,p_usage_type_o
420: => pay_etu_shd.g_old_rec.usage_type
421: );
422: --
423: exception
424: --

Line 480: (p_rec in out nocopy pay_etu_shd.g_rec_type

476: --
477: -- {End Of Comments}
478: -- ----------------------------------------------------------------------------
479: Procedure convert_defs
480: (p_rec in out nocopy pay_etu_shd.g_rec_type
481: ) is
482: --
483: Begin
484: --

Line 492: pay_etu_shd.g_old_rec.run_type_id;

488: -- is being used then we must set to the 'current' argument value.
489: --
490: If (p_rec.run_type_id = hr_api.g_number) then
491: p_rec.run_type_id :=
492: pay_etu_shd.g_old_rec.run_type_id;
493: End If;
494: If (p_rec.element_type_id = hr_api.g_number) then
495: p_rec.element_type_id :=
496: pay_etu_shd.g_old_rec.element_type_id;

Line 496: pay_etu_shd.g_old_rec.element_type_id;

492: pay_etu_shd.g_old_rec.run_type_id;
493: End If;
494: If (p_rec.element_type_id = hr_api.g_number) then
495: p_rec.element_type_id :=
496: pay_etu_shd.g_old_rec.element_type_id;
497: End If;
498: If (p_rec.inclusion_flag = hr_api.g_varchar2) then
499: p_rec.inclusion_flag :=
500: pay_etu_shd.g_old_rec.inclusion_flag;

Line 500: pay_etu_shd.g_old_rec.inclusion_flag;

496: pay_etu_shd.g_old_rec.element_type_id;
497: End If;
498: If (p_rec.inclusion_flag = hr_api.g_varchar2) then
499: p_rec.inclusion_flag :=
500: pay_etu_shd.g_old_rec.inclusion_flag;
501: End If;
502: If (p_rec.business_group_id = hr_api.g_number) then
503: p_rec.business_group_id :=
504: pay_etu_shd.g_old_rec.business_group_id;

Line 504: pay_etu_shd.g_old_rec.business_group_id;

500: pay_etu_shd.g_old_rec.inclusion_flag;
501: End If;
502: If (p_rec.business_group_id = hr_api.g_number) then
503: p_rec.business_group_id :=
504: pay_etu_shd.g_old_rec.business_group_id;
505: End If;
506: If (p_rec.legislation_code = hr_api.g_varchar2) then
507: p_rec.legislation_code :=
508: pay_etu_shd.g_old_rec.legislation_code;

Line 508: pay_etu_shd.g_old_rec.legislation_code;

504: pay_etu_shd.g_old_rec.business_group_id;
505: End If;
506: If (p_rec.legislation_code = hr_api.g_varchar2) then
507: p_rec.legislation_code :=
508: pay_etu_shd.g_old_rec.legislation_code;
509: End If;
510: If (p_rec.usage_type = hr_api.g_varchar2) then
511: p_rec.usage_type :=
512: pay_etu_shd.g_old_rec.usage_type;

Line 512: pay_etu_shd.g_old_rec.usage_type;

508: pay_etu_shd.g_old_rec.legislation_code;
509: End If;
510: If (p_rec.usage_type = hr_api.g_varchar2) then
511: p_rec.usage_type :=
512: pay_etu_shd.g_old_rec.usage_type;
513: End If;
514: --
515: End convert_defs;
516: --

Line 523: ,p_rec in out nocopy pay_etu_shd.g_rec_type

519: -- ----------------------------------------------------------------------------
520: Procedure upd
521: (p_effective_date in date
522: ,p_datetrack_mode in varchar2
523: ,p_rec in out nocopy pay_etu_shd.g_rec_type
524: ) is
525: --
526: l_proc varchar2(72) := g_package||'upd';
527: l_validation_start_date date;

Line 539: pay_etu_shd.lck

535: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
536: --
537: -- We must lock the row which we need to update.
538: --
539: pay_etu_shd.lck
540: (p_effective_date => p_effective_date
541: ,p_datetrack_mode => p_datetrack_mode
542: ,p_element_type_usage_id => p_rec.element_type_usage_id
543: ,p_object_version_number => p_rec.object_version_number

Line 609: l_rec pay_etu_shd.g_rec_type;

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

Line 619: pay_etu_shd.convert_args

615: -- Call conversion function to turn arguments into the
616: -- l_rec structure.
617: --
618: l_rec :=
619: pay_etu_shd.convert_args
620: (hr_api.g_number
621: ,hr_api.g_number
622: ,p_inclusion_flag
623: ,null