DBA Data[Home] [Help]

APPS.AME_ATU_UPD dependencies on AME_ATU_SHD

Line 58: (p_rec in out nocopy ame_atu_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_atu_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_atu_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_atu_shd.get_object_version_number
78: (p_attribute_id => p_rec.attribute_id
79: ,p_application_id => p_rec.application_id
80: );
81: --

Line 117: ame_atu_shd.constraint_error

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

Line 122: ame_atu_shd.constraint_error

118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ame_atu_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;

Line 161: (p_rec in out nocopy ame_atu_shd.g_rec_type

157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure update_dml
161: (p_rec in out nocopy ame_atu_shd.g_rec_type
162: ,p_effective_date in date
163: ,p_datetrack_mode in varchar2
164: ,p_validation_start_date in date
165: ,p_validation_end_date in date

Line 228: (p_rec in out nocopy ame_atu_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure dt_pre_update
228: (p_rec in out nocopy ame_atu_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 244: ame_atu_shd.upd_end_date

240: If (p_datetrack_mode <> hr_api.g_correction) then
241: --
242: -- Update the current effective end date
243: --
244: ame_atu_shd.upd_end_date
245: (p_effective_date => p_effective_date
246: ,p_attribute_id => p_rec.attribute_id
247: ,p_application_id => p_rec.application_id
248: ,p_new_end_date => p_validation_start_date

Line 312: (p_rec in out nocopy ame_atu_shd.g_rec_type

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

Line 370: (p_rec in ame_atu_shd.g_rec_type

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

Line 415: => ame_atu_shd.g_old_rec.query_string

411: => p_rec.value_set_id
412: ,p_object_version_number
413: => p_rec.object_version_number
414: ,p_query_string_o
415: => ame_atu_shd.g_old_rec.query_string
416: ,p_use_count_o
417: => ame_atu_shd.g_old_rec.use_count
418: ,p_user_editable_o
419: => ame_atu_shd.g_old_rec.user_editable

Line 417: => ame_atu_shd.g_old_rec.use_count

413: => p_rec.object_version_number
414: ,p_query_string_o
415: => ame_atu_shd.g_old_rec.query_string
416: ,p_use_count_o
417: => ame_atu_shd.g_old_rec.use_count
418: ,p_user_editable_o
419: => ame_atu_shd.g_old_rec.user_editable
420: ,p_is_static_o
421: => ame_atu_shd.g_old_rec.is_static

Line 419: => ame_atu_shd.g_old_rec.user_editable

415: => ame_atu_shd.g_old_rec.query_string
416: ,p_use_count_o
417: => ame_atu_shd.g_old_rec.use_count
418: ,p_user_editable_o
419: => ame_atu_shd.g_old_rec.user_editable
420: ,p_is_static_o
421: => ame_atu_shd.g_old_rec.is_static
422: ,p_start_date_o
423: => ame_atu_shd.g_old_rec.start_date

Line 421: => ame_atu_shd.g_old_rec.is_static

417: => ame_atu_shd.g_old_rec.use_count
418: ,p_user_editable_o
419: => ame_atu_shd.g_old_rec.user_editable
420: ,p_is_static_o
421: => ame_atu_shd.g_old_rec.is_static
422: ,p_start_date_o
423: => ame_atu_shd.g_old_rec.start_date
424: ,p_end_date_o
425: => ame_atu_shd.g_old_rec.end_date

Line 423: => ame_atu_shd.g_old_rec.start_date

419: => ame_atu_shd.g_old_rec.user_editable
420: ,p_is_static_o
421: => ame_atu_shd.g_old_rec.is_static
422: ,p_start_date_o
423: => ame_atu_shd.g_old_rec.start_date
424: ,p_end_date_o
425: => ame_atu_shd.g_old_rec.end_date
426: ,p_security_group_id_o
427: => ame_atu_shd.g_old_rec.security_group_id

Line 425: => ame_atu_shd.g_old_rec.end_date

421: => ame_atu_shd.g_old_rec.is_static
422: ,p_start_date_o
423: => ame_atu_shd.g_old_rec.start_date
424: ,p_end_date_o
425: => ame_atu_shd.g_old_rec.end_date
426: ,p_security_group_id_o
427: => ame_atu_shd.g_old_rec.security_group_id
428: ,p_value_set_id_o
429: => ame_atu_shd.g_old_rec.value_set_id

Line 427: => ame_atu_shd.g_old_rec.security_group_id

423: => ame_atu_shd.g_old_rec.start_date
424: ,p_end_date_o
425: => ame_atu_shd.g_old_rec.end_date
426: ,p_security_group_id_o
427: => ame_atu_shd.g_old_rec.security_group_id
428: ,p_value_set_id_o
429: => ame_atu_shd.g_old_rec.value_set_id
430: ,p_object_version_number_o
431: => ame_atu_shd.g_old_rec.object_version_number

Line 429: => ame_atu_shd.g_old_rec.value_set_id

425: => ame_atu_shd.g_old_rec.end_date
426: ,p_security_group_id_o
427: => ame_atu_shd.g_old_rec.security_group_id
428: ,p_value_set_id_o
429: => ame_atu_shd.g_old_rec.value_set_id
430: ,p_object_version_number_o
431: => ame_atu_shd.g_old_rec.object_version_number
432: );
433: --

Line 431: => ame_atu_shd.g_old_rec.object_version_number

427: => ame_atu_shd.g_old_rec.security_group_id
428: ,p_value_set_id_o
429: => ame_atu_shd.g_old_rec.value_set_id
430: ,p_object_version_number_o
431: => ame_atu_shd.g_old_rec.object_version_number
432: );
433: --
434: exception
435: --

Line 491: (p_rec in out nocopy ame_atu_shd.g_rec_type

487: --
488: -- {End Of Comments}
489: -- ----------------------------------------------------------------------------
490: Procedure convert_defs
491: (p_rec in out nocopy ame_atu_shd.g_rec_type
492: ) is
493: --
494: Begin
495: --

Line 503: ame_atu_shd.g_old_rec.query_string;

499: -- is being used then we must set to the 'current' argument value.
500: --
501: If (p_rec.query_string = hr_api.g_varchar2) then
502: p_rec.query_string :=
503: ame_atu_shd.g_old_rec.query_string;
504: End If;
505: If (p_rec.use_count = hr_api.g_number) then
506: p_rec.use_count :=
507: ame_atu_shd.g_old_rec.use_count;

Line 507: ame_atu_shd.g_old_rec.use_count;

503: ame_atu_shd.g_old_rec.query_string;
504: End If;
505: If (p_rec.use_count = hr_api.g_number) then
506: p_rec.use_count :=
507: ame_atu_shd.g_old_rec.use_count;
508: End If;
509: If (p_rec.user_editable = hr_api.g_varchar2) then
510: p_rec.user_editable :=
511: ame_atu_shd.g_old_rec.user_editable;

Line 511: ame_atu_shd.g_old_rec.user_editable;

507: ame_atu_shd.g_old_rec.use_count;
508: End If;
509: If (p_rec.user_editable = hr_api.g_varchar2) then
510: p_rec.user_editable :=
511: ame_atu_shd.g_old_rec.user_editable;
512: End If;
513: If (p_rec.is_static = hr_api.g_varchar2) then
514: p_rec.is_static :=
515: ame_atu_shd.g_old_rec.is_static;

Line 515: ame_atu_shd.g_old_rec.is_static;

511: ame_atu_shd.g_old_rec.user_editable;
512: End If;
513: If (p_rec.is_static = hr_api.g_varchar2) then
514: p_rec.is_static :=
515: ame_atu_shd.g_old_rec.is_static;
516: End If;
517: If (p_rec.security_group_id = hr_api.g_number) then
518: p_rec.security_group_id :=
519: ame_atu_shd.g_old_rec.security_group_id;

Line 519: ame_atu_shd.g_old_rec.security_group_id;

515: ame_atu_shd.g_old_rec.is_static;
516: End If;
517: If (p_rec.security_group_id = hr_api.g_number) then
518: p_rec.security_group_id :=
519: ame_atu_shd.g_old_rec.security_group_id;
520: End If;
521: If (p_rec.value_set_id = hr_api.g_number) then
522: p_rec.value_set_id :=
523: ame_atu_shd.g_old_rec.value_set_id;

Line 523: ame_atu_shd.g_old_rec.value_set_id;

519: ame_atu_shd.g_old_rec.security_group_id;
520: End If;
521: If (p_rec.value_set_id = hr_api.g_number) then
522: p_rec.value_set_id :=
523: ame_atu_shd.g_old_rec.value_set_id;
524: End If;
525: --
526: End convert_defs;
527: --

Line 534: ,p_rec in out nocopy ame_atu_shd.g_rec_type

530: -- ----------------------------------------------------------------------------
531: Procedure upd
532: (p_effective_date in date
533: ,p_datetrack_mode in varchar2
534: ,p_rec in out nocopy ame_atu_shd.g_rec_type
535: ) is
536: --
537: l_proc varchar2(72) := g_package||'upd';
538: l_validation_start_date date;

Line 550: ame_atu_shd.lck

546: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
547: --
548: -- We must lock the row which we need to update.
549: --
550: ame_atu_shd.lck
551: (p_effective_date => p_effective_date
552: ,p_datetrack_mode => p_datetrack_mode
553: ,p_attribute_id => p_rec.attribute_id
554: ,p_application_id => p_rec.application_id

Line 632: l_rec ame_atu_shd.g_rec_type;

628: ,p_start_date out nocopy date
629: ,p_end_date out nocopy date
630: ) is
631: --
632: l_rec ame_atu_shd.g_rec_type;
633: l_proc varchar2(72) := g_package||'upd';
634: --
635: Begin
636: hr_utility.set_location('Entering:'||l_proc, 5);

Line 642: ame_atu_shd.convert_args

638: -- Call conversion function to turn arguments into the
639: -- l_rec structure.
640: --
641: l_rec :=
642: ame_atu_shd.convert_args
643: (p_attribute_id
644: ,p_application_id
645: ,p_query_string
646: ,p_use_count