DBA Data[Home] [Help]

APPS.AME_ITU_UPD dependencies on AME_ITU_SHD

Line 58: (p_rec in out nocopy ame_itu_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_itu_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 77: ame_itu_shd.get_object_version_number

73: -- Because we are updating a row we must get the next object
74: -- version number.
75: --
76: p_rec.object_version_number :=
77: ame_itu_shd.get_object_version_number
78: (p_item_class_id => p_rec.item_class_id
79: ,p_application_id => p_rec.application_id
80: );
81: --

Line 114: ame_itu_shd.constraint_error

110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: ame_itu_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: ame_itu_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: ame_itu_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 ame_itu_shd.g_rec_type

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

221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure dt_pre_update
225: (p_rec in out nocopy ame_itu_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: ame_itu_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: ame_itu_shd.upd_effective_end_date
242: (p_effective_date => p_effective_date
243: ,p_item_class_id => p_rec.item_class_id
244: ,p_application_id => p_rec.application_id
245: ,p_new_effective_end_date => p_validation_start_date

Line 311: (p_rec in out nocopy ame_itu_shd.g_rec_type

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure pre_update
311: (p_rec in out nocopy ame_itu_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 ame_itu_shd.g_rec_type

365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure post_update
369: (p_rec in ame_itu_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 396: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query

392: ,p_item_class_sublist_mode => p_rec.item_class_sublist_mode
393: ,p_start_date => p_rec.start_date
394: ,p_end_date => p_rec.end_date
395: ,p_object_version_number => p_rec.object_version_number
396: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
397: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date

Line 397: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number

393: ,p_start_date => p_rec.start_date
394: ,p_end_date => p_rec.end_date
395: ,p_object_version_number => p_rec.object_version_number
396: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
397: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
401: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date

Line 398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode

394: ,p_end_date => p_rec.end_date
395: ,p_object_version_number => p_rec.object_version_number
396: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
397: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
401: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
402: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number

Line 399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode

395: ,p_object_version_number => p_rec.object_version_number
396: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
397: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
401: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
402: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
403: );

Line 400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date

396: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
397: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
401: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
402: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
403: );
404: --

Line 401: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date

397: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
401: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
402: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
403: );
404: --
405: exception

Line 402: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number

398: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
399: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
400: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
401: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
402: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
403: );
404: --
405: exception
406: --

Line 462: (p_rec in out nocopy ame_itu_shd.g_rec_type

458: --
459: -- {End Of Comments}
460: -- ----------------------------------------------------------------------------
461: Procedure convert_defs
462: (p_rec in out nocopy ame_itu_shd.g_rec_type
463: ) is
464: --
465: Begin
466: --

Line 474: ame_itu_shd.g_old_rec.item_id_query;

470: -- is being used then we must set to the 'current' argument value.
471: --
472: If (p_rec.item_id_query = hr_api.g_varchar2) then
473: p_rec.item_id_query :=
474: ame_itu_shd.g_old_rec.item_id_query;
475: End If;
476: If (p_rec.item_class_order_number = hr_api.g_number) then
477: p_rec.item_class_order_number :=
478: ame_itu_shd.g_old_rec.item_class_order_number;

Line 478: ame_itu_shd.g_old_rec.item_class_order_number;

474: ame_itu_shd.g_old_rec.item_id_query;
475: End If;
476: If (p_rec.item_class_order_number = hr_api.g_number) then
477: p_rec.item_class_order_number :=
478: ame_itu_shd.g_old_rec.item_class_order_number;
479: End If;
480: If (p_rec.item_class_par_mode = hr_api.g_varchar2) then
481: p_rec.item_class_par_mode :=
482: ame_itu_shd.g_old_rec.item_class_par_mode;

Line 482: ame_itu_shd.g_old_rec.item_class_par_mode;

478: ame_itu_shd.g_old_rec.item_class_order_number;
479: End If;
480: If (p_rec.item_class_par_mode = hr_api.g_varchar2) then
481: p_rec.item_class_par_mode :=
482: ame_itu_shd.g_old_rec.item_class_par_mode;
483: End If;
484: If (p_rec.item_class_sublist_mode = hr_api.g_varchar2) then
485: p_rec.item_class_sublist_mode :=
486: ame_itu_shd.g_old_rec.item_class_sublist_mode;

Line 486: ame_itu_shd.g_old_rec.item_class_sublist_mode;

482: ame_itu_shd.g_old_rec.item_class_par_mode;
483: End If;
484: If (p_rec.item_class_sublist_mode = hr_api.g_varchar2) then
485: p_rec.item_class_sublist_mode :=
486: ame_itu_shd.g_old_rec.item_class_sublist_mode;
487: End If;
488: --
489: End convert_defs;
490: --

Line 497: ,p_rec in out nocopy ame_itu_shd.g_rec_type

493: -- ----------------------------------------------------------------------------
494: Procedure upd
495: (p_effective_date in date
496: ,p_datetrack_mode in varchar2
497: ,p_rec in out nocopy ame_itu_shd.g_rec_type
498: ) is
499: --
500: l_proc varchar2(72) := g_package||'upd';
501: l_validation_start_date date;

Line 513: ame_itu_shd.lck

509: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
510: --
511: -- We must lock the row which we need to update.
512: --
513: ame_itu_shd.lck
514: (p_effective_date => p_effective_date
515: ,p_datetrack_mode => p_datetrack_mode
516: ,p_item_class_id => p_rec.item_class_id
517: ,p_application_id => p_rec.application_id

Line 593: l_rec ame_itu_shd.g_rec_type;

589: ,p_start_date out nocopy date
590: ,p_end_date out nocopy date
591: ) is
592: --
593: l_rec ame_itu_shd.g_rec_type;
594: l_proc varchar2(72) := g_package||'upd';
595: --
596: Begin
597: hr_utility.set_location('Entering:'||l_proc, 5);

Line 603: ame_itu_shd.convert_args

599: -- Call conversion function to turn arguments into the
600: -- l_rec structure.
601: --
602: l_rec :=
603: ame_itu_shd.convert_args
604: (p_application_id
605: ,p_item_class_id
606: ,p_item_id_query
607: ,p_item_class_order_number