DBA Data[Home] [Help]

APPS.AME_STV_UPD dependencies on AME_STV_SHD

Line 58: (p_rec in out nocopy ame_stv_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_stv_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_stv_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_stv_shd.get_object_version_number
78: (p_condition_id => p_rec.condition_id
79: ,p_string_value => p_rec.string_value
80: );
81: --

Line 111: ame_stv_shd.constraint_error

107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: ame_stv_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --

Line 116: ame_stv_shd.constraint_error

112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --
116: ame_stv_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: --
120: Raise;

Line 155: (p_rec in out nocopy ame_stv_shd.g_rec_type

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure update_dml
155: (p_rec in out nocopy ame_stv_shd.g_rec_type
156: ,p_effective_date in date
157: ,p_datetrack_mode in varchar2
158: ,p_validation_start_date in date
159: ,p_validation_end_date in date

Line 222: (p_rec in out nocopy ame_stv_shd.g_rec_type

218: --
219: -- {End Of Comments}
220: -- ----------------------------------------------------------------------------
221: Procedure dt_pre_update
222: (p_rec in out nocopy ame_stv_shd.g_rec_type
223: ,p_effective_date in date
224: ,p_datetrack_mode in varchar2
225: ,p_validation_start_date in date
226: ,p_validation_end_date in date

Line 238: ame_stv_shd.upd_end_date

234: If (p_datetrack_mode <> hr_api.g_correction) then
235: --
236: -- Update the current effective end date
237: --
238: ame_stv_shd.upd_end_date
239: (p_effective_date => p_effective_date
240: ,p_condition_id => p_rec.condition_id
241: ,p_string_value => p_rec.string_value
242: ,p_new_end_date => p_validation_start_date

Line 306: (p_rec in out nocopy ame_stv_shd.g_rec_type

302: --
303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: Procedure pre_update
306: (p_rec in out nocopy ame_stv_shd.g_rec_type
307: ,p_effective_date in date
308: ,p_datetrack_mode in varchar2
309: ,p_validation_start_date in date
310: ,p_validation_end_date in date

Line 364: (p_rec in ame_stv_shd.g_rec_type

360: --
361: -- {End Of Comments}
362: -- ----------------------------------------------------------------------------
363: Procedure post_update
364: (p_rec in ame_stv_shd.g_rec_type
365: ,p_effective_date in date
366: ,p_datetrack_mode in varchar2
367: ,p_validation_start_date in date
368: ,p_validation_end_date in date

Line 399: => ame_stv_shd.g_old_rec.start_date

395: => p_rec.security_group_id
396: ,p_object_version_number
397: => p_rec.object_version_number
398: ,p_start_date_o
399: => ame_stv_shd.g_old_rec.start_date
400: ,p_end_date_o
401: => ame_stv_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_stv_shd.g_old_rec.security_group_id

Line 401: => ame_stv_shd.g_old_rec.end_date

397: => p_rec.object_version_number
398: ,p_start_date_o
399: => ame_stv_shd.g_old_rec.start_date
400: ,p_end_date_o
401: => ame_stv_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_stv_shd.g_old_rec.security_group_id
404: ,p_object_version_number_o
405: => ame_stv_shd.g_old_rec.object_version_number

Line 403: => ame_stv_shd.g_old_rec.security_group_id

399: => ame_stv_shd.g_old_rec.start_date
400: ,p_end_date_o
401: => ame_stv_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_stv_shd.g_old_rec.security_group_id
404: ,p_object_version_number_o
405: => ame_stv_shd.g_old_rec.object_version_number
406: );
407: --

Line 405: => ame_stv_shd.g_old_rec.object_version_number

401: => ame_stv_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_stv_shd.g_old_rec.security_group_id
404: ,p_object_version_number_o
405: => ame_stv_shd.g_old_rec.object_version_number
406: );
407: --
408: exception
409: --

Line 465: (p_rec in out nocopy ame_stv_shd.g_rec_type

461: --
462: -- {End Of Comments}
463: -- ----------------------------------------------------------------------------
464: Procedure convert_defs
465: (p_rec in out nocopy ame_stv_shd.g_rec_type
466: ) is
467: --
468: Begin
469: --

Line 477: ame_stv_shd.g_old_rec.security_group_id;

473: -- is being used then we must set to the 'current' argument value.
474: --
475: If (p_rec.security_group_id = hr_api.g_number) then
476: p_rec.security_group_id :=
477: ame_stv_shd.g_old_rec.security_group_id;
478: End If;
479: --
480: End convert_defs;
481: --

Line 488: ,p_rec in out nocopy ame_stv_shd.g_rec_type

484: -- ----------------------------------------------------------------------------
485: Procedure upd
486: (p_effective_date in date
487: ,p_datetrack_mode in varchar2
488: ,p_rec in out nocopy ame_stv_shd.g_rec_type
489: ) is
490: --
491: l_proc varchar2(72) := g_package||'upd';
492: l_validation_start_date date;

Line 504: ame_stv_shd.lck

500: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
501: --
502: -- We must lock the row which we need to update.
503: --
504: ame_stv_shd.lck
505: (p_effective_date => p_effective_date
506: ,p_datetrack_mode => p_datetrack_mode
507: ,p_condition_id => p_rec.condition_id
508: ,p_string_value => p_rec.string_value

Line 581: l_rec ame_stv_shd.g_rec_type;

577: ,p_start_date out nocopy date
578: ,p_end_date out nocopy date
579: ) is
580: --
581: l_rec ame_stv_shd.g_rec_type;
582: l_proc varchar2(72) := g_package||'upd';
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);

Line 591: ame_stv_shd.convert_args

587: -- Call conversion function to turn arguments into the
588: -- l_rec structure.
589: --
590: l_rec :=
591: ame_stv_shd.convert_args
592: (p_condition_id
593: ,p_string_value
594: ,null
595: ,null