DBA Data[Home] [Help]

APPS.AME_ACT_UPD dependencies on AME_ACT_SHD

Line 58: (p_rec in out nocopy ame_act_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_act_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_act_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_act_shd.get_object_version_number
78: (p_action_id => p_rec.action_id
79: ,p_action_type_id => p_rec.action_type_id
80: );
81: --

Line 114: ame_act_shd.constraint_error

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

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

221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure dt_pre_update
225: (p_rec in out nocopy ame_act_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_act_shd.upd_end_date

237: If (p_datetrack_mode <> hr_api.g_correction) then
238: --
239: -- Update the current effective end date
240: --
241: ame_act_shd.upd_end_date
242: (p_effective_date => p_effective_date
243: ,p_action_id => p_rec.action_id
244: ,p_action_type_id => p_rec.action_type_id
245: ,p_new_end_date => p_validation_start_date

Line 311: (p_rec in out nocopy ame_act_shd.g_rec_type

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

365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure post_update
369: (p_rec in ame_act_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 410: => ame_act_shd.g_old_rec.parameter

406: => p_rec.parameter_two
407: ,p_object_version_number
408: => p_rec.object_version_number
409: ,p_parameter_o
410: => ame_act_shd.g_old_rec.parameter
411: ,p_start_date_o
412: => ame_act_shd.g_old_rec.start_date
413: ,p_end_date_o
414: => ame_act_shd.g_old_rec.end_date

Line 412: => ame_act_shd.g_old_rec.start_date

408: => p_rec.object_version_number
409: ,p_parameter_o
410: => ame_act_shd.g_old_rec.parameter
411: ,p_start_date_o
412: => ame_act_shd.g_old_rec.start_date
413: ,p_end_date_o
414: => ame_act_shd.g_old_rec.end_date
415: ,p_description_o
416: => ame_act_shd.g_old_rec.description

Line 414: => ame_act_shd.g_old_rec.end_date

410: => ame_act_shd.g_old_rec.parameter
411: ,p_start_date_o
412: => ame_act_shd.g_old_rec.start_date
413: ,p_end_date_o
414: => ame_act_shd.g_old_rec.end_date
415: ,p_description_o
416: => ame_act_shd.g_old_rec.description
417: ,p_security_group_id_o
418: => ame_act_shd.g_old_rec.security_group_id

Line 416: => ame_act_shd.g_old_rec.description

412: => ame_act_shd.g_old_rec.start_date
413: ,p_end_date_o
414: => ame_act_shd.g_old_rec.end_date
415: ,p_description_o
416: => ame_act_shd.g_old_rec.description
417: ,p_security_group_id_o
418: => ame_act_shd.g_old_rec.security_group_id
419: ,p_parameter_two_o
420: => ame_act_shd.g_old_rec.parameter_two

Line 418: => ame_act_shd.g_old_rec.security_group_id

414: => ame_act_shd.g_old_rec.end_date
415: ,p_description_o
416: => ame_act_shd.g_old_rec.description
417: ,p_security_group_id_o
418: => ame_act_shd.g_old_rec.security_group_id
419: ,p_parameter_two_o
420: => ame_act_shd.g_old_rec.parameter_two
421: ,p_object_version_number_o
422: => ame_act_shd.g_old_rec.object_version_number

Line 420: => ame_act_shd.g_old_rec.parameter_two

416: => ame_act_shd.g_old_rec.description
417: ,p_security_group_id_o
418: => ame_act_shd.g_old_rec.security_group_id
419: ,p_parameter_two_o
420: => ame_act_shd.g_old_rec.parameter_two
421: ,p_object_version_number_o
422: => ame_act_shd.g_old_rec.object_version_number
423: );
424: --

Line 422: => ame_act_shd.g_old_rec.object_version_number

418: => ame_act_shd.g_old_rec.security_group_id
419: ,p_parameter_two_o
420: => ame_act_shd.g_old_rec.parameter_two
421: ,p_object_version_number_o
422: => ame_act_shd.g_old_rec.object_version_number
423: );
424: --
425: exception
426: --

Line 482: (p_rec in out nocopy ame_act_shd.g_rec_type

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

Line 494: ame_act_shd.g_old_rec.parameter;

490: -- is being used then we must set to the 'current' argument value.
491: --
492: If (p_rec.parameter = hr_api.g_varchar2) then
493: p_rec.parameter :=
494: ame_act_shd.g_old_rec.parameter;
495: End If;
496: If (p_rec.description = hr_api.g_varchar2) then
497: p_rec.description :=
498: ame_act_shd.g_old_rec.description;

Line 498: ame_act_shd.g_old_rec.description;

494: ame_act_shd.g_old_rec.parameter;
495: End If;
496: If (p_rec.description = hr_api.g_varchar2) then
497: p_rec.description :=
498: ame_act_shd.g_old_rec.description;
499: End If;
500: If (p_rec.security_group_id = hr_api.g_number) then
501: p_rec.security_group_id :=
502: ame_act_shd.g_old_rec.security_group_id;

Line 502: ame_act_shd.g_old_rec.security_group_id;

498: ame_act_shd.g_old_rec.description;
499: End If;
500: If (p_rec.security_group_id = hr_api.g_number) then
501: p_rec.security_group_id :=
502: ame_act_shd.g_old_rec.security_group_id;
503: End If;
504: If (p_rec.parameter_two = hr_api.g_varchar2) then
505: p_rec.parameter_two :=
506: ame_act_shd.g_old_rec.parameter_two;

Line 506: ame_act_shd.g_old_rec.parameter_two;

502: ame_act_shd.g_old_rec.security_group_id;
503: End If;
504: If (p_rec.parameter_two = hr_api.g_varchar2) then
505: p_rec.parameter_two :=
506: ame_act_shd.g_old_rec.parameter_two;
507: End If;
508: --
509: End convert_defs;
510: --

Line 517: ,p_rec in out nocopy ame_act_shd.g_rec_type

513: -- ----------------------------------------------------------------------------
514: Procedure upd
515: (p_effective_date in date
516: ,p_datetrack_mode in varchar2
517: ,p_rec in out nocopy ame_act_shd.g_rec_type
518: ) is
519: --
520: l_proc varchar2(72) := g_package||'upd';
521: l_validation_start_date date;

Line 533: ame_act_shd.lck

529: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
530: --
531: -- We must lock the row which we need to update.
532: --
533: ame_act_shd.lck
534: (p_effective_date => p_effective_date
535: ,p_datetrack_mode => p_datetrack_mode
536: ,p_action_id => p_rec.action_id
537: ,p_action_type_id => p_rec.action_type_id

Line 613: l_rec ame_act_shd.g_rec_type;

609: ,p_start_date out nocopy date
610: ,p_end_date out nocopy date
611: ) is
612: --
613: l_rec ame_act_shd.g_rec_type;
614: l_proc varchar2(72) := g_package||'upd';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);

Line 623: ame_act_shd.convert_args

619: -- Call conversion function to turn arguments into the
620: -- l_rec structure.
621: --
622: l_rec :=
623: ame_act_shd.convert_args
624: (p_action_id
625: ,p_action_type_id
626: ,p_parameter
627: ,p_start_date