DBA Data[Home] [Help]

APPS.AME_RLU_UPD dependencies on AME_RLU_SHD

Line 59: (p_rec in out nocopy ame_rlu_shd.g_rec_type

55: --
56: -- {End Of Comments}
57: -- ----------------------------------------------------------------------------
58: Procedure dt_update_dml
59: (p_rec in out nocopy ame_rlu_shd.g_rec_type
60: ,p_effective_date in date
61: ,p_datetrack_mode in varchar2
62: ,p_validation_start_date in date
63: ,p_validation_end_date in date

Line 78: ame_rlu_shd.get_object_version_number

74: -- Because we are updating a row we must get the next object
75: -- version number.
76: --
77: p_rec.object_version_number :=
78: ame_rlu_shd.get_object_version_number
79: (p_rule_id => p_rec.rule_id
80: ,p_item_id => p_rec.item_id
81: ,p_old_start_date => p_rec.old_start_date
82: );

Line 116: ame_rlu_shd.constraint_error

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

Line 121: ame_rlu_shd.constraint_error

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

Line 160: (p_rec in out nocopy ame_rlu_shd.g_rec_type

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

Line 227: (p_rec in out nocopy ame_rlu_shd.g_rec_type

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

Line 243: ame_rlu_shd.upd_end_date

239: If (p_datetrack_mode <> hr_api.g_correction) then
240: --
241: -- Update the current effective end date
242: --
243: ame_rlu_shd.upd_end_date
244: (p_effective_date => p_effective_date
245: ,p_rule_id => p_rec.rule_id
246: ,p_item_id => p_rec.item_id
247: ,p_old_start_date => p_rec.old_start_date

Line 312: (p_rec in out nocopy ame_rlu_shd.g_rec_type

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

366: --
367: -- {End Of Comments}
368: -- ----------------------------------------------------------------------------
369: Procedure post_update
370: (p_rec in ame_rlu_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 411: => ame_rlu_shd.g_old_rec.usage_type

407: => p_rec.approver_category
408: ,p_object_version_number
409: => p_rec.object_version_number
410: ,p_usage_type_o
411: => ame_rlu_shd.g_old_rec.usage_type
412: ,p_start_date_o
413: => ame_rlu_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_rlu_shd.g_old_rec.end_date

Line 413: => ame_rlu_shd.g_old_rec.start_date

409: => p_rec.object_version_number
410: ,p_usage_type_o
411: => ame_rlu_shd.g_old_rec.usage_type
412: ,p_start_date_o
413: => ame_rlu_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_rlu_shd.g_old_rec.end_date
416: ,p_security_group_id_o
417: => ame_rlu_shd.g_old_rec.security_group_id

Line 415: => ame_rlu_shd.g_old_rec.end_date

411: => ame_rlu_shd.g_old_rec.usage_type
412: ,p_start_date_o
413: => ame_rlu_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_rlu_shd.g_old_rec.end_date
416: ,p_security_group_id_o
417: => ame_rlu_shd.g_old_rec.security_group_id
418: ,p_priority_o
419: => ame_rlu_shd.g_old_rec.priority

Line 417: => ame_rlu_shd.g_old_rec.security_group_id

413: => ame_rlu_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_rlu_shd.g_old_rec.end_date
416: ,p_security_group_id_o
417: => ame_rlu_shd.g_old_rec.security_group_id
418: ,p_priority_o
419: => ame_rlu_shd.g_old_rec.priority
420: ,p_approver_category_o
421: => ame_rlu_shd.g_old_rec.approver_category

Line 419: => ame_rlu_shd.g_old_rec.priority

415: => ame_rlu_shd.g_old_rec.end_date
416: ,p_security_group_id_o
417: => ame_rlu_shd.g_old_rec.security_group_id
418: ,p_priority_o
419: => ame_rlu_shd.g_old_rec.priority
420: ,p_approver_category_o
421: => ame_rlu_shd.g_old_rec.approver_category
422: ,p_object_version_number_o
423: => ame_rlu_shd.g_old_rec.object_version_number

Line 421: => ame_rlu_shd.g_old_rec.approver_category

417: => ame_rlu_shd.g_old_rec.security_group_id
418: ,p_priority_o
419: => ame_rlu_shd.g_old_rec.priority
420: ,p_approver_category_o
421: => ame_rlu_shd.g_old_rec.approver_category
422: ,p_object_version_number_o
423: => ame_rlu_shd.g_old_rec.object_version_number
424: );
425: --

Line 423: => ame_rlu_shd.g_old_rec.object_version_number

419: => ame_rlu_shd.g_old_rec.priority
420: ,p_approver_category_o
421: => ame_rlu_shd.g_old_rec.approver_category
422: ,p_object_version_number_o
423: => ame_rlu_shd.g_old_rec.object_version_number
424: );
425: --
426: exception
427: --

Line 483: (p_rec in out nocopy ame_rlu_shd.g_rec_type

479: --
480: -- {End Of Comments}
481: -- ----------------------------------------------------------------------------
482: Procedure convert_defs
483: (p_rec in out nocopy ame_rlu_shd.g_rec_type
484: ) is
485: --
486: Begin
487: --

Line 495: ame_rlu_shd.g_old_rec.usage_type;

491: -- is being used then we must set to the 'current' argument value.
492: --
493: If (p_rec.usage_type = hr_api.g_varchar2) then
494: p_rec.usage_type :=
495: ame_rlu_shd.g_old_rec.usage_type;
496: End If;
497: If (p_rec.security_group_id = hr_api.g_number) then
498: p_rec.security_group_id :=
499: ame_rlu_shd.g_old_rec.security_group_id;

Line 499: ame_rlu_shd.g_old_rec.security_group_id;

495: ame_rlu_shd.g_old_rec.usage_type;
496: End If;
497: If (p_rec.security_group_id = hr_api.g_number) then
498: p_rec.security_group_id :=
499: ame_rlu_shd.g_old_rec.security_group_id;
500: End If;
501: If (p_rec.priority = hr_api.g_number) then
502: p_rec.priority :=
503: ame_rlu_shd.g_old_rec.priority;

Line 503: ame_rlu_shd.g_old_rec.priority;

499: ame_rlu_shd.g_old_rec.security_group_id;
500: End If;
501: If (p_rec.priority = hr_api.g_number) then
502: p_rec.priority :=
503: ame_rlu_shd.g_old_rec.priority;
504: End If;
505: If (p_rec.approver_category = hr_api.g_varchar2) then
506: p_rec.approver_category :=
507: ame_rlu_shd.g_old_rec.approver_category;

Line 507: ame_rlu_shd.g_old_rec.approver_category;

503: ame_rlu_shd.g_old_rec.priority;
504: End If;
505: If (p_rec.approver_category = hr_api.g_varchar2) then
506: p_rec.approver_category :=
507: ame_rlu_shd.g_old_rec.approver_category;
508: End If;
509: If (p_rec.start_date = hr_api.g_date) then
510: p_rec.start_date := ame_rlu_shd.g_old_rec.start_date;
511: End If;

Line 510: p_rec.start_date := ame_rlu_shd.g_old_rec.start_date;

506: p_rec.approver_category :=
507: ame_rlu_shd.g_old_rec.approver_category;
508: End If;
509: If (p_rec.start_date = hr_api.g_date) then
510: p_rec.start_date := ame_rlu_shd.g_old_rec.start_date;
511: End If;
512: If (p_rec.end_date = hr_api.g_date) then
513: p_rec.end_date := ame_rlu_shd.g_old_rec.end_date;
514: End If;

Line 513: p_rec.end_date := ame_rlu_shd.g_old_rec.end_date;

509: If (p_rec.start_date = hr_api.g_date) then
510: p_rec.start_date := ame_rlu_shd.g_old_rec.start_date;
511: End If;
512: If (p_rec.end_date = hr_api.g_date) then
513: p_rec.end_date := ame_rlu_shd.g_old_rec.end_date;
514: End If;
515: --
516: End convert_defs;
517: --

Line 524: ,p_rec in out nocopy ame_rlu_shd.g_rec_type

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

Line 549: ame_rlu_shd.lck

545: end if;
546: --
547: -- We must lock the row which we need to update.
548: --
549: ame_rlu_shd.lck
550: (p_effective_date => p_effective_date
551: ,p_datetrack_mode => p_datetrack_mode
552: ,p_rule_id => p_rec.rule_id
553: ,p_item_id => p_rec.item_id

Line 648: l_rec ame_rlu_shd.g_rec_type;

644: ,p_start_date in out nocopy date
645: ,p_end_date in out nocopy date
646: ) is
647: --
648: l_rec ame_rlu_shd.g_rec_type;
649: l_proc varchar2(72) := g_package||'upd';
650: --
651: Begin
652: hr_utility.set_location('Entering:'||l_proc, 5);

Line 658: ame_rlu_shd.convert_args

654: -- Call conversion function to turn arguments into the
655: -- l_rec structure.
656: --
657: l_rec :=
658: ame_rlu_shd.convert_args
659: (p_item_id
660: ,p_usage_type
661: ,p_rule_id
662: ,p_start_date