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_BUS dependencies on AME_CONDITIONS

Line 50: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_ID'

46: hr_utility.set_location(' Leaving:'||l_proc,30);
47: exception
48: when app_exception.application_exception then
49: if hr_multi_message.exception_add
50: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_ID'
51: ) then
52: hr_utility.set_location(' Leaving:'||l_proc, 40);
53: raise;
54: end if;

Line 107: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_TYPE'

103: hr_utility.set_location(' Leaving:'||l_proc,30);
104: exception
105: when app_exception.application_exception then
106: if hr_multi_message.exception_add
107: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
108: ) then
109: hr_utility.set_location(' Leaving:'||l_proc, 40);
110: raise;
111: end if;

Line 166: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE') then

162: Begin
163: hr_utility.set_location(' Entering:'||l_proc,10);
164: -- Check whether any dependencies on CONDITION_KEY have failed
165: if hr_multi_message.no_all_inclusive_error
166: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE') then
167: hr_api.mandatory_arg_error(p_api_name => l_proc
168: ,p_argument => 'ATTRIBUTE_ID'
169: ,p_argument_value => p_attribute_id
170: );

Line 193: (p_associated_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID'

189: hr_utility.set_location(' Leaving:'||l_proc,30);
190: exception
191: when app_exception.application_exception then
192: if hr_multi_message.exception_add
193: (p_associated_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID'
194: ) then
195: hr_utility.set_location(' Leaving:'||l_proc, 40);
196: raise;
197: end if;

Line 255: (p_check_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID') then

251: Begin
252: hr_utility.set_location('Entering:'||l_proc,10);
253: -- Check for dependency issues with ATTRIBUTE_ID
254: if hr_multi_message.no_all_inclusive_error
255: (p_check_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID') then
256: -- Check if the attribute_type is not ame_util.stringType
257: open csr_atr_type;
258: fetch csr_atr_type into l_key;
259: close csr_atr_type;

Line 276: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_ONE'

272: hr_utility.set_location(' Leaving:'||l_proc,30);
273: exception
274: when app_exception.application_exception then
275: if hr_multi_message.exception_add
276: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_ONE'
277: ) then
278: hr_utility.set_location(' Leaving:'||l_proc, 40);
279: raise;
280: end if;

Line 354: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'

350: Begin
351: hr_utility.set_location('Entering:'||l_proc,10);
352: -- Check for dependency over CONDITION_TYPE.ATTRIBUTE_ID and PARAMETER_ONE
353: if hr_multi_message.no_all_inclusive_error
354: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
355: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
356: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
357: ) then
358: if(p_condition_type = ame_util.ordinaryConditionType)

Line 355: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'

351: hr_utility.set_location('Entering:'||l_proc,10);
352: -- Check for dependency over CONDITION_TYPE.ATTRIBUTE_ID and PARAMETER_ONE
353: if hr_multi_message.no_all_inclusive_error
354: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
355: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
356: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
357: ) then
358: if(p_condition_type = ame_util.ordinaryConditionType)
359: or (p_condition_type = ame_util.exceptionConditionType) then

Line 356: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'

352: -- Check for dependency over CONDITION_TYPE.ATTRIBUTE_ID and PARAMETER_ONE
353: if hr_multi_message.no_all_inclusive_error
354: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
355: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
356: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
357: ) then
358: if(p_condition_type = ame_util.ordinaryConditionType)
359: or (p_condition_type = ame_util.exceptionConditionType) then
360: open csr_atr_type;

Line 427: (p_associated_column1 => 'AME_CONDITIONS.PARAMETERS'

423: hr_utility.set_location(' Leaving:'||l_proc,30);
424: exception
425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
427: (p_associated_column1 => 'AME_CONDITIONS.PARAMETERS'
428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;
431: end if;

Line 491: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'

487: Begin
488: hr_utility.set_location('Entering:'||l_proc,10);
489: -- Check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
490: if hr_multi_message.no_all_inclusive_error
491: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
492: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
493: ) then
494: -- Check condition_type and attribute_type.
495: if(p_condition_type = ame_util.ordinaryConditionType or

Line 492: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'

488: hr_utility.set_location('Entering:'||l_proc,10);
489: -- Check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
490: if hr_multi_message.no_all_inclusive_error
491: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
492: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
493: ) then
494: -- Check condition_type and attribute_type.
495: if(p_condition_type = ame_util.ordinaryConditionType or
496: p_condition_type = ame_util.exceptionConditionType)

Line 520: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_THREE'

516: hr_utility.set_location(' Leaving:'||l_proc,30);
517: exception
518: when app_exception.application_exception then
519: if hr_multi_message.exception_add
520: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_THREE'
521: ) then
522: hr_utility.set_location(' Leaving:'||l_proc, 40);
523: raise;
524: end if;

Line 564: from ame_conditions

560: ) IS
561: --
562: cursor csr_name is
563: select condition_id
564: from ame_conditions
565: where condition_type = p_rec.condition_type
566: and nvl(parameter_one, hr_api.g_varchar2)
567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)
568: and nvl(parameter_two, hr_api.g_varchar2)

Line 594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'

590: hr_utility.set_location('Entering:'||l_proc,10);
591: -- check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
592: -- PARAMETER_ONE,PARAMETER_THREE and LIMITS
593: if hr_multi_message.no_all_inclusive_error
594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
595: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
596: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
597: ,p_check_column4 => 'AME_CONDITIONS.PARAMETER_THREE'
598: ,p_check_column5 => 'AME_CONDITIONS.LIMITS'

Line 595: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'

591: -- check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
592: -- PARAMETER_ONE,PARAMETER_THREE and LIMITS
593: if hr_multi_message.no_all_inclusive_error
594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
595: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
596: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
597: ,p_check_column4 => 'AME_CONDITIONS.PARAMETER_THREE'
598: ,p_check_column5 => 'AME_CONDITIONS.LIMITS'
599: ) then

Line 596: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'

592: -- PARAMETER_ONE,PARAMETER_THREE and LIMITS
593: if hr_multi_message.no_all_inclusive_error
594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
595: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
596: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
597: ,p_check_column4 => 'AME_CONDITIONS.PARAMETER_THREE'
598: ,p_check_column5 => 'AME_CONDITIONS.LIMITS'
599: ) then
600: open csr_name;

Line 597: ,p_check_column4 => 'AME_CONDITIONS.PARAMETER_THREE'

593: if hr_multi_message.no_all_inclusive_error
594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
595: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
596: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
597: ,p_check_column4 => 'AME_CONDITIONS.PARAMETER_THREE'
598: ,p_check_column5 => 'AME_CONDITIONS.LIMITS'
599: ) then
600: open csr_name;
601: fetch csr_name into l_key;

Line 598: ,p_check_column5 => 'AME_CONDITIONS.LIMITS'

594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
595: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
596: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
597: ,p_check_column4 => 'AME_CONDITIONS.PARAMETER_THREE'
598: ,p_check_column5 => 'AME_CONDITIONS.LIMITS'
599: ) then
600: open csr_name;
601: fetch csr_name into l_key;
602: -- and l_key <> p_rec.condition_id

Line 618: (p_associated_column1 => 'AME_CONDITIONS.UNIQUE'

614: hr_utility.set_location(' Leaving:'||l_proc,30);
615: exception
616: when app_exception.application_exception then
617: if hr_multi_message.exception_add
618: (p_associated_column1 => 'AME_CONDITIONS.UNIQUE'
619: ) then
620: hr_utility.set_location(' Leaving:'||l_proc, 40);
621: raise;
622: end if;

Line 684: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'

680: --
681: Begin
682: hr_utility.set_location( 'Entering:'||l_proc,10 );
683: if hr_multi_message.no_all_inclusive_error
684: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
685: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
686: ,p_check_column3 => 'AME_CONDITIONS.PARAMETERS'
687: ) then
688: if(p_condition_type <> ame_util.listModConditionType) then

Line 685: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'

681: Begin
682: hr_utility.set_location( 'Entering:'||l_proc,10 );
683: if hr_multi_message.no_all_inclusive_error
684: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
685: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
686: ,p_check_column3 => 'AME_CONDITIONS.PARAMETERS'
687: ) then
688: if(p_condition_type <> ame_util.listModConditionType) then
689: open csr_atr_type;

Line 686: ,p_check_column3 => 'AME_CONDITIONS.PARAMETERS'

682: hr_utility.set_location( 'Entering:'||l_proc,10 );
683: if hr_multi_message.no_all_inclusive_error
684: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
685: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
686: ,p_check_column3 => 'AME_CONDITIONS.PARAMETERS'
687: ) then
688: if(p_condition_type <> ame_util.listModConditionType) then
689: open csr_atr_type;
690: fetch csr_atr_type into l_key;

Line 735: (p_associated_column1 => 'AME_CONDITIONS.LIMITS'

731: hr_utility.set_location(' Leaving:'||l_proc,30);
732: exception
733: when app_exception.application_exception then
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'AME_CONDITIONS.LIMITS'
736: ) then
737: hr_utility.set_location(' Leaving:'||l_proc, 40);
738: raise;
739: end if;

Line 778: from ame_conditions

774: ) IS
775: --
776: cursor csr_name is
777: select 'Y'
778: from ame_conditions
779: where condition_key = p_condition_key
780: and p_effective_date between start_date
781: and nvl(end_date - ame_util.oneSecond, p_effective_date);
782: l_proc varchar2(72) := g_package || 'CHK_CONDITION_KEY';

Line 808: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_KEY'

804: hr_utility.set_location(' Leaving:'||l_proc,30);
805: exception
806: when app_exception.application_exception then
807: if hr_multi_message.exception_add
808: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_KEY'
809: ) then
810: hr_utility.set_location(' Leaving:'||l_proc, 40);
811: raise;
812: end if;

Line 860: -- from ame_conditions

856: p_effective_date <= nvl(end_date - ame_util.oneSecond, p_effective_date))
857: );
858: -- cursor c_sel2 is
859: -- select null
860: -- from ame_conditions
861: -- where ame_utility_pkg.check_seeddb = 'N'
862: -- and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
863: -- and condition_id = p_condition_id
864: -- and p_effective_date between start_date and

Line 896: (p_associated_column1 => 'AME_CONDITIONS.DELETE'

892: hr_utility.set_location(' Leaving:'||l_proc,30);
893: exception
894: when app_exception.application_exception then
895: if hr_multi_message.exception_add
896: (p_associated_column1 => 'AME_CONDITIONS.DELETE'
897: ) then
898: hr_utility.set_location(' Leaving:'||l_proc, 40);
899: raise;
900: end if;