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_UCI_UPD dependencies on PAY_UCI_SHD

Line 58: (p_rec in out nocopy pay_uci_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_uci_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 83: pay_uci_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'user_column_instance_id'
80: ,p_base_key_value => p_rec.user_column_instance_id
81: );
82: --
83: pay_uci_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_user_column_instances_f Row
86: --
87: update pay_user_column_instances_f

Line 100: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

96: where user_column_instance_id = p_rec.user_column_instance_id
97: and effective_start_date = p_validation_start_date
98: and effective_end_date = p_validation_end_date;
99: --
100: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: -- Set the effective start and end dates
103: --
104: p_rec.effective_start_date := p_validation_start_date;

Line 112: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

108: hr_utility.set_location(' Leaving:'||l_proc, 15);
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
113: pay_uci_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

Line 113: pay_uci_shd.constraint_error

109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
113: pay_uci_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: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

Line 117: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

113: pay_uci_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: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
118: pay_uci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

Line 118: pay_uci_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: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
118: pay_uci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;

Line 121: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

117: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
118: pay_uci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End dt_update_dml;
124: --
125: -- ----------------------------------------------------------------------------

Line 157: (p_rec in out nocopy pay_uci_shd.g_rec_type

153: --
154: -- {End Of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure update_dml
157: (p_rec in out nocopy pay_uci_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_uci_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure dt_pre_update
224: (p_rec in out nocopy pay_uci_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_uci_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_uci_shd.upd_effective_end_date
241: (p_effective_date => p_effective_date
242: ,p_base_key_value => p_rec.user_column_instance_id
243: ,p_new_effective_end_date => (p_validation_start_date - 1)
244: ,p_validation_start_date => p_validation_start_date

Line 309: (p_rec in out nocopy pay_uci_shd.g_rec_type

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

Line 367: (p_rec in pay_uci_shd.g_rec_type

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

Line 400: => pay_uci_shd.g_old_rec.effective_start_date

396: => p_rec.value
397: ,p_object_version_number
398: => p_rec.object_version_number
399: ,p_effective_start_date_o
400: => pay_uci_shd.g_old_rec.effective_start_date
401: ,p_effective_end_date_o
402: => pay_uci_shd.g_old_rec.effective_end_date
403: ,p_user_row_id_o
404: => pay_uci_shd.g_old_rec.user_row_id

Line 402: => pay_uci_shd.g_old_rec.effective_end_date

398: => p_rec.object_version_number
399: ,p_effective_start_date_o
400: => pay_uci_shd.g_old_rec.effective_start_date
401: ,p_effective_end_date_o
402: => pay_uci_shd.g_old_rec.effective_end_date
403: ,p_user_row_id_o
404: => pay_uci_shd.g_old_rec.user_row_id
405: ,p_user_column_id_o
406: => pay_uci_shd.g_old_rec.user_column_id

Line 404: => pay_uci_shd.g_old_rec.user_row_id

400: => pay_uci_shd.g_old_rec.effective_start_date
401: ,p_effective_end_date_o
402: => pay_uci_shd.g_old_rec.effective_end_date
403: ,p_user_row_id_o
404: => pay_uci_shd.g_old_rec.user_row_id
405: ,p_user_column_id_o
406: => pay_uci_shd.g_old_rec.user_column_id
407: ,p_business_group_id_o
408: => pay_uci_shd.g_old_rec.business_group_id

Line 406: => pay_uci_shd.g_old_rec.user_column_id

402: => pay_uci_shd.g_old_rec.effective_end_date
403: ,p_user_row_id_o
404: => pay_uci_shd.g_old_rec.user_row_id
405: ,p_user_column_id_o
406: => pay_uci_shd.g_old_rec.user_column_id
407: ,p_business_group_id_o
408: => pay_uci_shd.g_old_rec.business_group_id
409: ,p_legislation_code_o
410: => pay_uci_shd.g_old_rec.legislation_code

Line 408: => pay_uci_shd.g_old_rec.business_group_id

404: => pay_uci_shd.g_old_rec.user_row_id
405: ,p_user_column_id_o
406: => pay_uci_shd.g_old_rec.user_column_id
407: ,p_business_group_id_o
408: => pay_uci_shd.g_old_rec.business_group_id
409: ,p_legislation_code_o
410: => pay_uci_shd.g_old_rec.legislation_code
411: ,p_value_o
412: => pay_uci_shd.g_old_rec.value

Line 410: => pay_uci_shd.g_old_rec.legislation_code

406: => pay_uci_shd.g_old_rec.user_column_id
407: ,p_business_group_id_o
408: => pay_uci_shd.g_old_rec.business_group_id
409: ,p_legislation_code_o
410: => pay_uci_shd.g_old_rec.legislation_code
411: ,p_value_o
412: => pay_uci_shd.g_old_rec.value
413: ,p_object_version_number_o
414: => pay_uci_shd.g_old_rec.object_version_number

Line 412: => pay_uci_shd.g_old_rec.value

408: => pay_uci_shd.g_old_rec.business_group_id
409: ,p_legislation_code_o
410: => pay_uci_shd.g_old_rec.legislation_code
411: ,p_value_o
412: => pay_uci_shd.g_old_rec.value
413: ,p_object_version_number_o
414: => pay_uci_shd.g_old_rec.object_version_number
415: );
416: --

Line 414: => pay_uci_shd.g_old_rec.object_version_number

410: => pay_uci_shd.g_old_rec.legislation_code
411: ,p_value_o
412: => pay_uci_shd.g_old_rec.value
413: ,p_object_version_number_o
414: => pay_uci_shd.g_old_rec.object_version_number
415: );
416: --
417: exception
418: --

Line 474: (p_rec in out nocopy pay_uci_shd.g_rec_type

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

Line 486: pay_uci_shd.g_old_rec.user_row_id;

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

Line 490: pay_uci_shd.g_old_rec.user_column_id;

486: pay_uci_shd.g_old_rec.user_row_id;
487: End If;
488: If (p_rec.user_column_id = hr_api.g_number) then
489: p_rec.user_column_id :=
490: pay_uci_shd.g_old_rec.user_column_id;
491: End If;
492: If (p_rec.business_group_id = hr_api.g_number) then
493: p_rec.business_group_id :=
494: pay_uci_shd.g_old_rec.business_group_id;

Line 494: pay_uci_shd.g_old_rec.business_group_id;

490: pay_uci_shd.g_old_rec.user_column_id;
491: End If;
492: If (p_rec.business_group_id = hr_api.g_number) then
493: p_rec.business_group_id :=
494: pay_uci_shd.g_old_rec.business_group_id;
495: End If;
496: If (p_rec.legislation_code = hr_api.g_varchar2) then
497: p_rec.legislation_code :=
498: pay_uci_shd.g_old_rec.legislation_code;

Line 498: pay_uci_shd.g_old_rec.legislation_code;

494: pay_uci_shd.g_old_rec.business_group_id;
495: End If;
496: If (p_rec.legislation_code = hr_api.g_varchar2) then
497: p_rec.legislation_code :=
498: pay_uci_shd.g_old_rec.legislation_code;
499: End If;
500: If (p_rec.value = hr_api.g_varchar2) then
501: p_rec.value :=
502: pay_uci_shd.g_old_rec.value;

Line 502: pay_uci_shd.g_old_rec.value;

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

Line 513: ,p_rec in out nocopy pay_uci_shd.g_rec_type

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

Line 529: pay_uci_shd.lck

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

Line 604: l_rec pay_uci_shd.g_rec_type;

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

Line 614: pay_uci_shd.convert_args

610: -- Call conversion function to turn arguments into the
611: -- l_rec structure.
612: --
613: l_rec :=
614: pay_uci_shd.convert_args
615: (p_user_column_instance_id
616: ,null
617: ,null
618: ,hr_api.g_number