eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_APG_UPD dependencies on AME_APG_SHD

Line 58: (p_rec in out nocopy ame_apg_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_apg_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_apg_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_apg_shd.get_object_version_number
78: (p_approval_group_id => p_rec.approval_group_id
79: );
80: --
81: --

Line 112: ame_apg_shd.constraint_error

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

Line 117: ame_apg_shd.constraint_error

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

Line 156: (p_rec in out nocopy ame_apg_shd.g_rec_type

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

Line 223: (p_rec in out nocopy ame_apg_shd.g_rec_type

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

Line 239: ame_apg_shd.upd_end_date

235: If (p_datetrack_mode <> hr_api.g_correction) then
236: --
237: -- Update the current effective end date
238: --
239: ame_apg_shd.upd_end_date
240: (p_effective_date => p_effective_date
241: ,p_approval_group_id => p_rec.approval_group_id
242: ,p_new_end_date => p_validation_start_date
243: ,p_object_version_number => l_dummy_version_number

Line 306: (p_rec in out nocopy ame_apg_shd.g_rec_type

302: --
303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: Procedure pre_update
306: (p_rec in out nocopy ame_apg_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_apg_shd.g_rec_type

360: --
361: -- {End Of Comments}
362: -- ----------------------------------------------------------------------------
363: Procedure post_update
364: (p_rec in ame_apg_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 405: => ame_apg_shd.g_old_rec.name

401: => p_rec.security_group_id
402: ,p_object_version_number
403: => p_rec.object_version_number
404: ,p_name_o
405: => ame_apg_shd.g_old_rec.name
406: ,p_start_date_o
407: => ame_apg_shd.g_old_rec.start_date
408: ,p_end_date_o
409: => ame_apg_shd.g_old_rec.end_date

Line 407: => ame_apg_shd.g_old_rec.start_date

403: => p_rec.object_version_number
404: ,p_name_o
405: => ame_apg_shd.g_old_rec.name
406: ,p_start_date_o
407: => ame_apg_shd.g_old_rec.start_date
408: ,p_end_date_o
409: => ame_apg_shd.g_old_rec.end_date
410: ,p_description_o
411: => ame_apg_shd.g_old_rec.description

Line 409: => ame_apg_shd.g_old_rec.end_date

405: => ame_apg_shd.g_old_rec.name
406: ,p_start_date_o
407: => ame_apg_shd.g_old_rec.start_date
408: ,p_end_date_o
409: => ame_apg_shd.g_old_rec.end_date
410: ,p_description_o
411: => ame_apg_shd.g_old_rec.description
412: ,p_query_string_o
413: => ame_apg_shd.g_old_rec.query_string

Line 411: => ame_apg_shd.g_old_rec.description

407: => ame_apg_shd.g_old_rec.start_date
408: ,p_end_date_o
409: => ame_apg_shd.g_old_rec.end_date
410: ,p_description_o
411: => ame_apg_shd.g_old_rec.description
412: ,p_query_string_o
413: => ame_apg_shd.g_old_rec.query_string
414: ,p_is_static_o
415: => ame_apg_shd.g_old_rec.is_static

Line 413: => ame_apg_shd.g_old_rec.query_string

409: => ame_apg_shd.g_old_rec.end_date
410: ,p_description_o
411: => ame_apg_shd.g_old_rec.description
412: ,p_query_string_o
413: => ame_apg_shd.g_old_rec.query_string
414: ,p_is_static_o
415: => ame_apg_shd.g_old_rec.is_static
416: ,p_security_group_id_o
417: => ame_apg_shd.g_old_rec.security_group_id

Line 415: => ame_apg_shd.g_old_rec.is_static

411: => ame_apg_shd.g_old_rec.description
412: ,p_query_string_o
413: => ame_apg_shd.g_old_rec.query_string
414: ,p_is_static_o
415: => ame_apg_shd.g_old_rec.is_static
416: ,p_security_group_id_o
417: => ame_apg_shd.g_old_rec.security_group_id
418: ,p_object_version_number_o
419: => ame_apg_shd.g_old_rec.object_version_number

Line 417: => ame_apg_shd.g_old_rec.security_group_id

413: => ame_apg_shd.g_old_rec.query_string
414: ,p_is_static_o
415: => ame_apg_shd.g_old_rec.is_static
416: ,p_security_group_id_o
417: => ame_apg_shd.g_old_rec.security_group_id
418: ,p_object_version_number_o
419: => ame_apg_shd.g_old_rec.object_version_number
420: );
421: --

Line 419: => ame_apg_shd.g_old_rec.object_version_number

415: => ame_apg_shd.g_old_rec.is_static
416: ,p_security_group_id_o
417: => ame_apg_shd.g_old_rec.security_group_id
418: ,p_object_version_number_o
419: => ame_apg_shd.g_old_rec.object_version_number
420: );
421: --
422: exception
423: --

Line 479: (p_rec in out nocopy ame_apg_shd.g_rec_type

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

Line 491: ame_apg_shd.g_old_rec.name;

487: -- is being used then we must set to the 'current' argument value.
488: --
489: If (p_rec.name = hr_api.g_varchar2) then
490: p_rec.name :=
491: ame_apg_shd.g_old_rec.name;
492: End If;
493: If (p_rec.description = hr_api.g_varchar2) then
494: p_rec.description :=
495: ame_apg_shd.g_old_rec.description;

Line 495: ame_apg_shd.g_old_rec.description;

491: ame_apg_shd.g_old_rec.name;
492: End If;
493: If (p_rec.description = hr_api.g_varchar2) then
494: p_rec.description :=
495: ame_apg_shd.g_old_rec.description;
496: End If;
497: If (p_rec.query_string = hr_api.g_varchar2) then
498: p_rec.query_string :=
499: ame_apg_shd.g_old_rec.query_string;

Line 499: ame_apg_shd.g_old_rec.query_string;

495: ame_apg_shd.g_old_rec.description;
496: End If;
497: If (p_rec.query_string = hr_api.g_varchar2) then
498: p_rec.query_string :=
499: ame_apg_shd.g_old_rec.query_string;
500: End If;
501: If (p_rec.is_static = hr_api.g_varchar2) then
502: p_rec.is_static :=
503: ame_apg_shd.g_old_rec.is_static;

Line 503: ame_apg_shd.g_old_rec.is_static;

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

Line 507: ame_apg_shd.g_old_rec.security_group_id;

503: ame_apg_shd.g_old_rec.is_static;
504: End If;
505: If (p_rec.security_group_id = hr_api.g_number) then
506: p_rec.security_group_id :=
507: ame_apg_shd.g_old_rec.security_group_id;
508: End If;
509: --
510: End convert_defs;
511: --

Line 518: ,p_rec in out nocopy ame_apg_shd.g_rec_type

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

Line 534: ame_apg_shd.lck

530: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
531: --
532: -- We must lock the row which we need to update.
533: --
534: ame_apg_shd.lck
535: (p_effective_date => p_effective_date
536: ,p_datetrack_mode => p_datetrack_mode
537: ,p_approval_group_id => p_rec.approval_group_id
538: ,p_object_version_number => p_rec.object_version_number

Line 613: l_rec ame_apg_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_apg_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_apg_shd.convert_args

619: -- Call conversion function to turn arguments into the
620: -- l_rec structure.
621: --
622: l_rec :=
623: ame_apg_shd.convert_args
624: (p_approval_group_id
625: ,p_name
626: ,null
627: ,null