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_UTIL

Line 96: if p_condition_type not in(ame_util.ordinaryConditionType

92: ,p_argument => 'CONDITION_TYPE'
93: ,p_argument_value => p_condition_type
94: );
95: -- Check if the value exist in the lookup list
96: if p_condition_type not in(ame_util.ordinaryConditionType
97: ,ame_util.exceptionConditionType
98: ,ame_util.listModConditionType
99: ) then
100: fnd_message.set_name('PER','AME_400496_INV_CON_TYPE');

Line 97: ,ame_util.exceptionConditionType

93: ,p_argument_value => p_condition_type
94: );
95: -- Check if the value exist in the lookup list
96: if p_condition_type not in(ame_util.ordinaryConditionType
97: ,ame_util.exceptionConditionType
98: ,ame_util.listModConditionType
99: ) then
100: fnd_message.set_name('PER','AME_400496_INV_CON_TYPE');
101: fnd_message.raise_error;

Line 98: ,ame_util.listModConditionType

94: );
95: -- Check if the value exist in the lookup list
96: if p_condition_type not in(ame_util.ordinaryConditionType
97: ,ame_util.exceptionConditionType
98: ,ame_util.listModConditionType
99: ) then
100: fnd_message.set_name('PER','AME_400496_INV_CON_TYPE');
101: fnd_message.raise_error;
102: end if;

Line 158: and nvl(end_date - ame_util.oneSecond, p_effective_date);

154: select attribute_id
155: from ame_attributes
156: where attribute_id=p_attribute_id
157: and p_effective_date between start_date
158: and nvl(end_date - ame_util.oneSecond, p_effective_date);
159: l_proc varchar2(72) := g_package || 'CHK_ATTRIBUTE_ID';
160: l_key number;
161: --
162: Begin

Line 173: if(p_condition_type <> ame_util.listModConditionType) then

169: ,p_argument_value => p_attribute_id
170: );
171: -- Check if the condition_type is ListModification type. Else check if
172: -- the value exists in the parent table
173: if(p_condition_type <> ame_util.listModConditionType) then
174: open csr_name;
175: fetch csr_name into l_key;
176: if(csr_name%notfound) then
177: close csr_name;

Line 247: and nvl(end_date - ame_util.oneSecond, p_effective_date);

243: select attribute_type
244: from ame_attributes
245: where attribute_id = p_attribute_id
246: and p_effective_date between start_date
247: and nvl(end_date - ame_util.oneSecond, p_effective_date);
248: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_ONE';
249: l_key varchar2(30);
250: --
251: Begin

Line 256: -- Check if the attribute_type is not ame_util.stringType

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;
260: if(l_key = ame_util.booleanAttributeType) then

Line 260: if(l_key = ame_util.booleanAttributeType) 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;
260: if(l_key = ame_util.booleanAttributeType) then
261: hr_api.mandatory_arg_error(p_api_name => l_proc
262: ,p_argument => 'PARAMETER_ONE'
263: ,p_argument_value => p_parameter_one
264: );

Line 265: elsif(l_key <> ame_util.stringAttributeType) then

261: hr_api.mandatory_arg_error(p_api_name => l_proc
262: ,p_argument => 'PARAMETER_ONE'
263: ,p_argument_value => p_parameter_one
264: );
265: elsif(l_key <> ame_util.stringAttributeType) then
266: if(p_parameter_one is null and p_parameter_two is null) then
267: fnd_message.set_name('PER','AME_400330_CND_NULL_LUB');
268: fnd_message.raise_error;
269: end if;

Line 301: -- set to either ame_util.anyApprover or ame_util.finalApprover,while

297: -- string attribute must have both parameters set to null, while a boolean
298: -- attribute must have parameter1 set to either 'true' or 'false'
299: --
300: -- Conditions of type ListModConditionTypes must have their parameter_one
301: -- set to either ame_util.anyApprover or ame_util.finalApprover,while
302: -- parameter2 must reference a valid WF_Role.
303: --
304: -- Pre-Requisites:
305: -- chk_condition_type,chk_attribute_id and chk_parameter_one must have been

Line 340: and nvl(end_date - ame_util.oneSecond, p_effective_date);

336: select attribute_type,approver_type_id
337: from ame_attributes
338: where attribute_id = p_attribute_id
339: and p_effective_date between start_date
340: and nvl(end_date - ame_util.oneSecond, p_effective_date);
341: cursor csr_wf_role(p_name varchar2,p_date date) is
342: select 'Y'
343: from wf_roles
344: where name = p_name

Line 358: if(p_condition_type = ame_util.ordinaryConditionType)

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;
361: fetch csr_atr_type into l_key,l_key_approver;
362: close csr_atr_type;

Line 359: or (p_condition_type = ame_util.exceptionConditionType) then

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;
361: fetch csr_atr_type into l_key,l_key_approver;
362: close csr_atr_type;
363: -- Determine the attribute type

Line 364: if(l_key = ame_util.dateAttributeType) then

360: open csr_atr_type;
361: fetch csr_atr_type into l_key,l_key_approver;
362: close csr_atr_type;
363: -- Determine the attribute type
364: if(l_key = ame_util.dateAttributeType) then
365: -- Either one parameter ( of parameter1 or parametr2) can exist with
366: -- the other being null.If both exist, then parameter1 must be less
367: -- than parameter2 or they must be equal.
368: if(to_date(nvl(p_parameter_one,p_parameter_two),'yyyy:mm:dd:hh24:mi:ss')

Line 374: elsif(l_key = ame_util.currencyAttributeType) then

370: then
371: fnd_message.set_name('PER','AME_400186_CON_START_LESS_END');
372: fnd_message.raise_error;
373: end if;
374: elsif(l_key = ame_util.currencyAttributeType) then
375: -- Either one parameter ( of parameter1 or parametr2) can exist with
376: -- the other being null.If both exist, then parameter1 must be less
377: -- than parameter2 or they must be equal.
378: if(to_number(nvl(p_parameter_one, p_parameter_two))> to_number(nvl(p_parameter_two, p_parameter_one)))

Line 383: elsif(l_key = ame_util.numberAttributeType) then

379: then
380: fnd_message.set_name('PER','AME_400187_CON_LWR_LESS_UPP');
381: fnd_message.raise_error;
382: end if;
383: elsif(l_key = ame_util.numberAttributeType) then
384: -- When there is no approver, Either one parameter ( of parameter1 or
385: -- parameter2) can exist with the other being null.If both exist, then
386: -- parameter1 must be less than parameter2 or they must be equal.
387: if(l_key_approver is null) then

Line 399: elsif(l_key = ame_util.stringAttributeType) and

395: fnd_message.set_name('PER','AME_400498_INV_APPROVER_PARAMS');
396: fnd_message.raise_error;
397: end if;
398: end if;
399: elsif(l_key = ame_util.stringAttributeType) and
400: not (p_parameter_one is null and p_parameter_two is null) then
401: fnd_message.set_name('PER','AME_400499_INV_STR_PARAMS');
402: fnd_message.raise_error;
403: elsif(l_key = ame_util.booleanAttributeType) and

Line 403: elsif(l_key = ame_util.booleanAttributeType) and

399: elsif(l_key = ame_util.stringAttributeType) and
400: not (p_parameter_one is null and p_parameter_two is null) then
401: fnd_message.set_name('PER','AME_400499_INV_STR_PARAMS');
402: fnd_message.raise_error;
403: elsif(l_key = ame_util.booleanAttributeType) and
404: not (p_parameter_one in (ame_util.booleanAttributeTrue,ame_util.booleanAttributeFalse)
405: and p_parameter_two is null) then
406: fnd_message.set_name('PER','AME_400500_INV_BOOL_PARAMS');
407: fnd_message.raise_error;

Line 404: not (p_parameter_one in (ame_util.booleanAttributeTrue,ame_util.booleanAttributeFalse)

400: not (p_parameter_one is null and p_parameter_two is null) then
401: fnd_message.set_name('PER','AME_400499_INV_STR_PARAMS');
402: fnd_message.raise_error;
403: elsif(l_key = ame_util.booleanAttributeType) and
404: not (p_parameter_one in (ame_util.booleanAttributeTrue,ame_util.booleanAttributeFalse)
405: and p_parameter_two is null) then
406: fnd_message.set_name('PER','AME_400500_INV_BOOL_PARAMS');
407: fnd_message.raise_error;
408: end if;

Line 409: elsif(p_condition_type = ame_util.listModConditionType) then

405: and p_parameter_two is null) then
406: fnd_message.set_name('PER','AME_400500_INV_BOOL_PARAMS');
407: fnd_message.raise_error;
408: end if;
409: elsif(p_condition_type = ame_util.listModConditionType) then
410: open csr_wf_role(p_parameter_two,p_effective_date);
411: fetch csr_wf_role into l_key;
412: if(csr_wf_role%notfound) or
413: not (p_parameter_one in (ame_util.anyApprover

Line 413: not (p_parameter_one in (ame_util.anyApprover

409: elsif(p_condition_type = ame_util.listModConditionType) then
410: open csr_wf_role(p_parameter_two,p_effective_date);
411: fetch csr_wf_role into l_key;
412: if(csr_wf_role%notfound) or
413: not (p_parameter_one in (ame_util.anyApprover
414: ,ame_util.finalApprover)) then
415: close csr_wf_role;
416: fnd_message.set_name('PER','AME_400501_INV_LMCOND_PARAM');
417: fnd_message.raise_error;

Line 414: ,ame_util.finalApprover)) then

410: open csr_wf_role(p_parameter_two,p_effective_date);
411: fetch csr_wf_role into l_key;
412: if(csr_wf_role%notfound) or
413: not (p_parameter_one in (ame_util.anyApprover
414: ,ame_util.finalApprover)) then
415: close csr_wf_role;
416: fnd_message.set_name('PER','AME_400501_INV_LMCOND_PARAM');
417: fnd_message.raise_error;
418: end if;

Line 479: and nvl(end_date - ame_util.oneSecond, p_effective_date);

475: select attribute_type
476: from ame_attributes
477: where attribute_id = p_attribute_id
478: and p_effective_date between start_date
479: and nvl(end_date - ame_util.oneSecond, p_effective_date);
480: cursor csr_cur_code(p_currency_code varchar2) is
481: select currency_code
482: from fnd_currencies
483: where currency_code = p_currency_code;

Line 495: if(p_condition_type = ame_util.ordinaryConditionType or

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)
497: then
498: open csr_atr_type;
499: fetch csr_atr_type into l_key;

Line 496: p_condition_type = ame_util.exceptionConditionType)

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)
497: then
498: open csr_atr_type;
499: fetch csr_atr_type into l_key;
500: close csr_atr_type;

Line 501: if(l_key = ame_util.currencyAttributeType) then

497: then
498: open csr_atr_type;
499: fetch csr_atr_type into l_key;
500: close csr_atr_type;
501: if(l_key = ame_util.currencyAttributeType) then
502: open csr_cur_code(p_parameter_three);
503: fetch csr_cur_code into l_key;
504: if(csr_cur_code%notfound) then
505: close csr_cur_code;

Line 577: and nvl(end_date - ame_util.oneSecond, p_effective_date)

573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)
574: and nvl(include_upper_limit, hr_api.g_varchar2)
575: = nvl(p_rec.include_upper_limit, hr_api.g_varchar2)
576: and p_effective_date between start_date
577: and nvl(end_date - ame_util.oneSecond, p_effective_date)
578: and attribute_id = p_rec.attribute_id
579: and attribute_id not in ( select attribute_id
580: from ame_attributes
581: where attribute_type = ame_util.stringAttributeType

Line 581: where attribute_type = ame_util.stringAttributeType

577: and nvl(end_date - ame_util.oneSecond, p_effective_date)
578: and attribute_id = p_rec.attribute_id
579: and attribute_id not in ( select attribute_id
580: from ame_attributes
581: where attribute_type = ame_util.stringAttributeType
582: and p_effective_date between
583: start_date and
584: nvl(end_date - ame_util.oneSecond, p_effective_date)
585: );

Line 584: nvl(end_date - ame_util.oneSecond, p_effective_date)

580: from ame_attributes
581: where attribute_type = ame_util.stringAttributeType
582: and p_effective_date between
583: start_date and
584: nvl(end_date - ame_util.oneSecond, p_effective_date)
585: );
586: l_proc varchar2(72) := g_package || 'CHK_UNIQUE';
587: l_key number;
588: --

Line 677: and nvl(end_date - ame_util.oneSecond, p_effective_date);

673: select attribute_type
674: from ame_attributes
675: where attribute_id = p_attribute_id
676: and p_effective_date between start_date
677: and nvl(end_date - ame_util.oneSecond, p_effective_date);
678: l_proc varchar2(72) := g_package || 'CHK_LIMITS';
679: l_key varchar2(30);
680: --
681: Begin

Line 688: if(p_condition_type <> ame_util.listModConditionType) then

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;
691: close csr_atr_type;
692: if (l_key = ame_util.booleanAttributeType) then

Line 692: if (l_key = ame_util.booleanAttributeType) then

688: if(p_condition_type <> ame_util.listModConditionType) then
689: open csr_atr_type;
690: fetch csr_atr_type into l_key;
691: close csr_atr_type;
692: if (l_key = ame_util.booleanAttributeType) then
693: if not(p_include_lower_limit is null and p_include_upper_limit is null)
694: then
695: fnd_message.set_name('PER','AME_400504_INV_BOOL_LIMITS');
696: fnd_message.raise_error;

Line 703: (ame_util.booleanTrue,ame_util.booleanFalse))) then

699: -- The parameters 1 and 2 decide the existence of the appopriate limits
700: if(p_parameter_one is null and p_include_lower_limit is not null)
701: or(p_parameter_one is not null and (p_include_lower_limit is null
702: or p_include_lower_limit not in
703: (ame_util.booleanTrue,ame_util.booleanFalse))) then
704: fnd_message.set_name('PER','AME_400506_INV_LOWER_LIMIT');
705: fnd_message.raise_error;
706: end if;
707: if(p_parameter_two is null and p_include_upper_limit is not null)

Line 710: (ame_util.booleanTrue,ame_util.booleanFalse))) then

706: end if;
707: if(p_parameter_two is null and p_include_upper_limit is not null)
708: or (p_parameter_two is not null and (p_include_upper_limit is null
709: or p_include_upper_limit not in
710: (ame_util.booleanTrue,ame_util.booleanFalse))) then
711: fnd_message.set_name('PER','AME_400505_INV_UPPER_LIMIT');
712: fnd_message.raise_error;
713: end if;
714: if((p_parameter_one = p_parameter_two) and

Line 715: (p_include_lower_limit <> ame_util.booleanTrue or

711: fnd_message.set_name('PER','AME_400505_INV_UPPER_LIMIT');
712: fnd_message.raise_error;
713: end if;
714: if((p_parameter_one = p_parameter_two) and
715: (p_include_lower_limit <> ame_util.booleanTrue or
716: p_include_upper_limit <> ame_util.booleanTrue)
717: ) then
718: fnd_message.set_name('PER','AME_400678_CON_LMT_VAL_YES');
719: fnd_message.raise_error;

Line 716: p_include_upper_limit <> ame_util.booleanTrue)

712: fnd_message.raise_error;
713: end if;
714: if((p_parameter_one = p_parameter_two) and
715: (p_include_lower_limit <> ame_util.booleanTrue or
716: p_include_upper_limit <> ame_util.booleanTrue)
717: ) then
718: fnd_message.set_name('PER','AME_400678_CON_LMT_VAL_YES');
719: fnd_message.raise_error;
720: end if;

Line 781: and nvl(end_date - ame_util.oneSecond, p_effective_date);

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';
783: l_key varchar2(1);
784: --
785: Begin

Line 854: and nvl(end_date - ame_util.oneSecond, p_effective_date))

850: select 'Y'
851: from ame_condition_usages
852: where condition_id = p_condition_id
853: and ((p_effective_date between start_date
854: and nvl(end_date - ame_util.oneSecond, p_effective_date))
855: or(p_effective_date < start_date and
856: p_effective_date <= nvl(end_date - ame_util.oneSecond, p_effective_date))
857: );
858: -- cursor c_sel2 is

Line 856: p_effective_date <= nvl(end_date - ame_util.oneSecond, p_effective_date))

852: where condition_id = p_condition_id
853: and ((p_effective_date between start_date
854: and nvl(end_date - ame_util.oneSecond, p_effective_date))
855: or(p_effective_date < start_date and
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

Line 861: -- where ame_utility_pkg.check_seeddb = 'N'

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
865: -- nvl(end_date - (1/86400), p_effective_date);

Line 862: -- and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById

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
865: -- nvl(end_date - (1/86400), p_effective_date);
866: