DBA Data[Home] [Help]

APPS.AME_ACF_UPD dependencies on AME_ACF_SHD

Line 58: (p_rec in out nocopy ame_acf_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_acf_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_acf_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_acf_shd.get_object_version_number
78: (p_action_type_id => p_rec.action_type_id
79: ,p_application_id => p_rec.application_id
80: );
81: --

Line 113: ame_acf_shd.constraint_error

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

Line 118: ame_acf_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: --
118: ame_acf_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: --
122: Raise;

Line 157: (p_rec in out nocopy ame_acf_shd.g_rec_type

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

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

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

Line 310: (p_rec in out nocopy ame_acf_shd.g_rec_type

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

Line 368: (p_rec in ame_acf_shd.g_rec_type

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

Line 407: => ame_acf_shd.g_old_rec.voting_regime

403: => p_rec.end_date
404: ,p_object_version_number
405: => p_rec.object_version_number
406: ,p_voting_regime_o
407: => ame_acf_shd.g_old_rec.voting_regime
408: ,p_order_number_o
409: => ame_acf_shd.g_old_rec.order_number
410: ,p_chain_ordering_mode_o
411: => ame_acf_shd.g_old_rec.chain_ordering_mode

Line 409: => ame_acf_shd.g_old_rec.order_number

405: => p_rec.object_version_number
406: ,p_voting_regime_o
407: => ame_acf_shd.g_old_rec.voting_regime
408: ,p_order_number_o
409: => ame_acf_shd.g_old_rec.order_number
410: ,p_chain_ordering_mode_o
411: => ame_acf_shd.g_old_rec.chain_ordering_mode
412: ,p_start_date_o
413: => ame_acf_shd.g_old_rec.start_date

Line 411: => ame_acf_shd.g_old_rec.chain_ordering_mode

407: => ame_acf_shd.g_old_rec.voting_regime
408: ,p_order_number_o
409: => ame_acf_shd.g_old_rec.order_number
410: ,p_chain_ordering_mode_o
411: => ame_acf_shd.g_old_rec.chain_ordering_mode
412: ,p_start_date_o
413: => ame_acf_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_acf_shd.g_old_rec.end_date

Line 413: => ame_acf_shd.g_old_rec.start_date

409: => ame_acf_shd.g_old_rec.order_number
410: ,p_chain_ordering_mode_o
411: => ame_acf_shd.g_old_rec.chain_ordering_mode
412: ,p_start_date_o
413: => ame_acf_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_acf_shd.g_old_rec.end_date
416: ,p_object_version_number_o
417: => ame_acf_shd.g_old_rec.object_version_number

Line 415: => ame_acf_shd.g_old_rec.end_date

411: => ame_acf_shd.g_old_rec.chain_ordering_mode
412: ,p_start_date_o
413: => ame_acf_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_acf_shd.g_old_rec.end_date
416: ,p_object_version_number_o
417: => ame_acf_shd.g_old_rec.object_version_number
418: );
419: --

Line 417: => ame_acf_shd.g_old_rec.object_version_number

413: => ame_acf_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => ame_acf_shd.g_old_rec.end_date
416: ,p_object_version_number_o
417: => ame_acf_shd.g_old_rec.object_version_number
418: );
419: --
420: exception
421: --

Line 477: (p_rec in out nocopy ame_acf_shd.g_rec_type

473: --
474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure convert_defs
477: (p_rec in out nocopy ame_acf_shd.g_rec_type
478: ) is
479: --
480: Begin
481: --

Line 489: ame_acf_shd.g_old_rec.voting_regime;

485: -- is being used then we must set to the 'current' argument value.
486: --
487: If (p_rec.voting_regime = hr_api.g_varchar2) then
488: p_rec.voting_regime :=
489: ame_acf_shd.g_old_rec.voting_regime;
490: End If;
491: If (p_rec.order_number = hr_api.g_number) then
492: p_rec.order_number :=
493: ame_acf_shd.g_old_rec.order_number;

Line 493: ame_acf_shd.g_old_rec.order_number;

489: ame_acf_shd.g_old_rec.voting_regime;
490: End If;
491: If (p_rec.order_number = hr_api.g_number) then
492: p_rec.order_number :=
493: ame_acf_shd.g_old_rec.order_number;
494: End If;
495: If (p_rec.chain_ordering_mode = hr_api.g_varchar2) then
496: p_rec.chain_ordering_mode :=
497: ame_acf_shd.g_old_rec.chain_ordering_mode;

Line 497: ame_acf_shd.g_old_rec.chain_ordering_mode;

493: ame_acf_shd.g_old_rec.order_number;
494: End If;
495: If (p_rec.chain_ordering_mode = hr_api.g_varchar2) then
496: p_rec.chain_ordering_mode :=
497: ame_acf_shd.g_old_rec.chain_ordering_mode;
498: End If;
499: --
500: End convert_defs;
501: --

Line 508: ,p_rec in out nocopy ame_acf_shd.g_rec_type

504: -- ----------------------------------------------------------------------------
505: Procedure upd
506: (p_effective_date in date
507: ,p_datetrack_mode in varchar2
508: ,p_rec in out nocopy ame_acf_shd.g_rec_type
509: ) is
510: --
511: l_proc varchar2(72) := g_package||'upd';
512: l_validation_start_date date;

Line 524: ame_acf_shd.lck

520: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
521: --
522: -- We must lock the row which we need to update.
523: --
524: ame_acf_shd.lck
525: (p_effective_date => p_effective_date
526: ,p_datetrack_mode => p_datetrack_mode
527: ,p_action_type_id => p_rec.action_type_id
528: ,p_application_id => p_rec.application_id

Line 603: l_rec ame_acf_shd.g_rec_type;

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

Line 613: ame_acf_shd.convert_args

609: -- Call conversion function to turn arguments into the
610: -- l_rec structure.
611: --
612: l_rec :=
613: ame_acf_shd.convert_args
614: (p_application_id
615: ,p_action_type_id
616: ,p_voting_regime
617: ,p_order_number