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_CON_UPD dependencies on AME_CON_SHD

Line 58: (p_rec in out nocopy ame_con_shd.g_rec_type

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

Line 116: ame_con_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ame_con_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_con_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_con_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_con_shd.g_rec_type

156: --
157: -- {End Of Comments}
158: -- ----------------------------------------------------------------------------
159: Procedure update_dml
160: (p_rec in out nocopy ame_con_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_con_shd.g_rec_type

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure dt_pre_update
227: (p_rec in out nocopy ame_con_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_con_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_con_shd.upd_end_date
244: (p_effective_date => p_effective_date
245: ,p_condition_id => p_rec.condition_id
246: ,p_new_end_date => p_validation_start_date
247: ,p_object_version_number => l_dummy_version_number

Line 310: (p_rec in out nocopy ame_con_shd.g_rec_type

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

364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: Procedure post_update
368: (p_rec in ame_con_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 417: => ame_con_shd.g_old_rec.condition_type

413: => p_rec.condition_key
414: ,p_object_version_number
415: => p_rec.object_version_number
416: ,p_condition_type_o
417: => ame_con_shd.g_old_rec.condition_type
418: ,p_attribute_id_o
419: => ame_con_shd.g_old_rec.attribute_id
420: ,p_parameter_one_o
421: => ame_con_shd.g_old_rec.parameter_one

Line 419: => ame_con_shd.g_old_rec.attribute_id

415: => p_rec.object_version_number
416: ,p_condition_type_o
417: => ame_con_shd.g_old_rec.condition_type
418: ,p_attribute_id_o
419: => ame_con_shd.g_old_rec.attribute_id
420: ,p_parameter_one_o
421: => ame_con_shd.g_old_rec.parameter_one
422: ,p_parameter_two_o
423: => ame_con_shd.g_old_rec.parameter_two

Line 421: => ame_con_shd.g_old_rec.parameter_one

417: => ame_con_shd.g_old_rec.condition_type
418: ,p_attribute_id_o
419: => ame_con_shd.g_old_rec.attribute_id
420: ,p_parameter_one_o
421: => ame_con_shd.g_old_rec.parameter_one
422: ,p_parameter_two_o
423: => ame_con_shd.g_old_rec.parameter_two
424: ,p_parameter_three_o
425: => ame_con_shd.g_old_rec.parameter_three

Line 423: => ame_con_shd.g_old_rec.parameter_two

419: => ame_con_shd.g_old_rec.attribute_id
420: ,p_parameter_one_o
421: => ame_con_shd.g_old_rec.parameter_one
422: ,p_parameter_two_o
423: => ame_con_shd.g_old_rec.parameter_two
424: ,p_parameter_three_o
425: => ame_con_shd.g_old_rec.parameter_three
426: ,p_include_lower_limit_o
427: => ame_con_shd.g_old_rec.include_lower_limit

Line 425: => ame_con_shd.g_old_rec.parameter_three

421: => ame_con_shd.g_old_rec.parameter_one
422: ,p_parameter_two_o
423: => ame_con_shd.g_old_rec.parameter_two
424: ,p_parameter_three_o
425: => ame_con_shd.g_old_rec.parameter_three
426: ,p_include_lower_limit_o
427: => ame_con_shd.g_old_rec.include_lower_limit
428: ,p_include_upper_limit_o
429: => ame_con_shd.g_old_rec.include_upper_limit

Line 427: => ame_con_shd.g_old_rec.include_lower_limit

423: => ame_con_shd.g_old_rec.parameter_two
424: ,p_parameter_three_o
425: => ame_con_shd.g_old_rec.parameter_three
426: ,p_include_lower_limit_o
427: => ame_con_shd.g_old_rec.include_lower_limit
428: ,p_include_upper_limit_o
429: => ame_con_shd.g_old_rec.include_upper_limit
430: ,p_start_date_o
431: => ame_con_shd.g_old_rec.start_date

Line 429: => ame_con_shd.g_old_rec.include_upper_limit

425: => ame_con_shd.g_old_rec.parameter_three
426: ,p_include_lower_limit_o
427: => ame_con_shd.g_old_rec.include_lower_limit
428: ,p_include_upper_limit_o
429: => ame_con_shd.g_old_rec.include_upper_limit
430: ,p_start_date_o
431: => ame_con_shd.g_old_rec.start_date
432: ,p_end_date_o
433: => ame_con_shd.g_old_rec.end_date

Line 431: => ame_con_shd.g_old_rec.start_date

427: => ame_con_shd.g_old_rec.include_lower_limit
428: ,p_include_upper_limit_o
429: => ame_con_shd.g_old_rec.include_upper_limit
430: ,p_start_date_o
431: => ame_con_shd.g_old_rec.start_date
432: ,p_end_date_o
433: => ame_con_shd.g_old_rec.end_date
434: ,p_security_group_id_o
435: => ame_con_shd.g_old_rec.security_group_id

Line 433: => ame_con_shd.g_old_rec.end_date

429: => ame_con_shd.g_old_rec.include_upper_limit
430: ,p_start_date_o
431: => ame_con_shd.g_old_rec.start_date
432: ,p_end_date_o
433: => ame_con_shd.g_old_rec.end_date
434: ,p_security_group_id_o
435: => ame_con_shd.g_old_rec.security_group_id
436: ,p_condition_key_o
437: => ame_con_shd.g_old_rec.condition_key

Line 435: => ame_con_shd.g_old_rec.security_group_id

431: => ame_con_shd.g_old_rec.start_date
432: ,p_end_date_o
433: => ame_con_shd.g_old_rec.end_date
434: ,p_security_group_id_o
435: => ame_con_shd.g_old_rec.security_group_id
436: ,p_condition_key_o
437: => ame_con_shd.g_old_rec.condition_key
438: ,p_object_version_number_o
439: => ame_con_shd.g_old_rec.object_version_number

Line 437: => ame_con_shd.g_old_rec.condition_key

433: => ame_con_shd.g_old_rec.end_date
434: ,p_security_group_id_o
435: => ame_con_shd.g_old_rec.security_group_id
436: ,p_condition_key_o
437: => ame_con_shd.g_old_rec.condition_key
438: ,p_object_version_number_o
439: => ame_con_shd.g_old_rec.object_version_number
440: );
441: --

Line 439: => ame_con_shd.g_old_rec.object_version_number

435: => ame_con_shd.g_old_rec.security_group_id
436: ,p_condition_key_o
437: => ame_con_shd.g_old_rec.condition_key
438: ,p_object_version_number_o
439: => ame_con_shd.g_old_rec.object_version_number
440: );
441: --
442: exception
443: --

Line 499: (p_rec in out nocopy ame_con_shd.g_rec_type

495: --
496: -- {End Of Comments}
497: -- ----------------------------------------------------------------------------
498: Procedure convert_defs
499: (p_rec in out nocopy ame_con_shd.g_rec_type
500: ) is
501: --
502: Begin
503: --

Line 511: ame_con_shd.g_old_rec.condition_type;

507: -- is being used then we must set to the 'current' argument value.
508: --
509: If (p_rec.condition_type = hr_api.g_varchar2) then
510: p_rec.condition_type :=
511: ame_con_shd.g_old_rec.condition_type;
512: End If;
513: If (p_rec.attribute_id = hr_api.g_number) then
514: p_rec.attribute_id :=
515: ame_con_shd.g_old_rec.attribute_id;

Line 515: ame_con_shd.g_old_rec.attribute_id;

511: ame_con_shd.g_old_rec.condition_type;
512: End If;
513: If (p_rec.attribute_id = hr_api.g_number) then
514: p_rec.attribute_id :=
515: ame_con_shd.g_old_rec.attribute_id;
516: End If;
517: If (p_rec.parameter_one = hr_api.g_varchar2) then
518: p_rec.parameter_one :=
519: ame_con_shd.g_old_rec.parameter_one;

Line 519: ame_con_shd.g_old_rec.parameter_one;

515: ame_con_shd.g_old_rec.attribute_id;
516: End If;
517: If (p_rec.parameter_one = hr_api.g_varchar2) then
518: p_rec.parameter_one :=
519: ame_con_shd.g_old_rec.parameter_one;
520: End If;
521: If (p_rec.parameter_two = hr_api.g_varchar2) then
522: p_rec.parameter_two :=
523: ame_con_shd.g_old_rec.parameter_two;

Line 523: ame_con_shd.g_old_rec.parameter_two;

519: ame_con_shd.g_old_rec.parameter_one;
520: End If;
521: If (p_rec.parameter_two = hr_api.g_varchar2) then
522: p_rec.parameter_two :=
523: ame_con_shd.g_old_rec.parameter_two;
524: End If;
525: If (p_rec.parameter_three = hr_api.g_varchar2) then
526: p_rec.parameter_three :=
527: ame_con_shd.g_old_rec.parameter_three;

Line 527: ame_con_shd.g_old_rec.parameter_three;

523: ame_con_shd.g_old_rec.parameter_two;
524: End If;
525: If (p_rec.parameter_three = hr_api.g_varchar2) then
526: p_rec.parameter_three :=
527: ame_con_shd.g_old_rec.parameter_three;
528: End If;
529: If (p_rec.include_lower_limit = hr_api.g_varchar2) then
530: p_rec.include_lower_limit :=
531: ame_con_shd.g_old_rec.include_lower_limit;

Line 531: ame_con_shd.g_old_rec.include_lower_limit;

527: ame_con_shd.g_old_rec.parameter_three;
528: End If;
529: If (p_rec.include_lower_limit = hr_api.g_varchar2) then
530: p_rec.include_lower_limit :=
531: ame_con_shd.g_old_rec.include_lower_limit;
532: End If;
533: If (p_rec.include_upper_limit = hr_api.g_varchar2) then
534: p_rec.include_upper_limit :=
535: ame_con_shd.g_old_rec.include_upper_limit;

Line 535: ame_con_shd.g_old_rec.include_upper_limit;

531: ame_con_shd.g_old_rec.include_lower_limit;
532: End If;
533: If (p_rec.include_upper_limit = hr_api.g_varchar2) then
534: p_rec.include_upper_limit :=
535: ame_con_shd.g_old_rec.include_upper_limit;
536: End If;
537: If (p_rec.security_group_id = hr_api.g_number) then
538: p_rec.security_group_id :=
539: ame_con_shd.g_old_rec.security_group_id;

Line 539: ame_con_shd.g_old_rec.security_group_id;

535: ame_con_shd.g_old_rec.include_upper_limit;
536: End If;
537: If (p_rec.security_group_id = hr_api.g_number) then
538: p_rec.security_group_id :=
539: ame_con_shd.g_old_rec.security_group_id;
540: End If;
541: If (p_rec.condition_key = hr_api.g_varchar2) then
542: p_rec.condition_key :=
543: ame_con_shd.g_old_rec.condition_key;

Line 543: ame_con_shd.g_old_rec.condition_key;

539: ame_con_shd.g_old_rec.security_group_id;
540: End If;
541: If (p_rec.condition_key = hr_api.g_varchar2) then
542: p_rec.condition_key :=
543: ame_con_shd.g_old_rec.condition_key;
544: End If;
545: --
546: End convert_defs;
547: --

Line 554: ,p_rec in out nocopy ame_con_shd.g_rec_type

550: -- ----------------------------------------------------------------------------
551: Procedure upd
552: (p_effective_date in date
553: ,p_datetrack_mode in varchar2
554: ,p_rec in out nocopy ame_con_shd.g_rec_type
555: ) is
556: --
557: l_proc varchar2(72) := g_package||'upd';
558: l_validation_start_date date;

Line 570: ame_con_shd.lck

566: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
567: --
568: -- We must lock the row which we need to update.
569: --
570: ame_con_shd.lck
571: (p_effective_date => p_effective_date
572: ,p_datetrack_mode => p_datetrack_mode
573: ,p_condition_id => p_rec.condition_id
574: ,p_object_version_number => p_rec.object_version_number

Line 653: l_rec ame_con_shd.g_rec_type;

649: ,p_start_date out nocopy date
650: ,p_end_date out nocopy date
651: ) is
652: --
653: l_rec ame_con_shd.g_rec_type;
654: l_proc varchar2(72) := g_package||'upd';
655: --
656: Begin
657: hr_utility.set_location('Entering:'||l_proc, 5);

Line 663: ame_con_shd.convert_args

659: -- Call conversion function to turn arguments into the
660: -- l_rec structure.
661: --
662: l_rec :=
663: ame_con_shd.convert_args
664: (p_condition_id
665: ,p_condition_type
666: ,p_attribute_id
667: ,p_parameter_one