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_ATU_BUS dependencies on AME_UTIL

Line 33: amount ame_util.attributeValueType;

29: function inputToCanonStaticCurUsage(p_attribute_id in integer,
30: p_application_id in integer,
31: p_query_string varchar2) return varchar2 as
32: l_proc varchar2(72) := g_package||'inputToCanonStaticCurUsage';
33: amount ame_util.attributeValueType;
34: conversionType ame_util.attributeValueType;
35: convTypeException exception;
36: curCodeException exception;
37: currencyCode ame_util.attributeValueType;

Line 34: conversionType ame_util.attributeValueType;

30: p_application_id in integer,
31: p_query_string varchar2) return varchar2 as
32: l_proc varchar2(72) := g_package||'inputToCanonStaticCurUsage';
33: amount ame_util.attributeValueType;
34: conversionType ame_util.attributeValueType;
35: convTypeException exception;
36: curCodeException exception;
37: currencyCode ame_util.attributeValueType;
38: errorCode integer;

Line 37: currencyCode ame_util.attributeValueType;

33: amount ame_util.attributeValueType;
34: conversionType ame_util.attributeValueType;
35: convTypeException exception;
36: curCodeException exception;
37: currencyCode ame_util.attributeValueType;
38: errorCode integer;
39: errorMessage ame_util.longestStringType;
40: begin
41: /*

Line 39: errorMessage ame_util.longestStringType;

35: convTypeException exception;
36: curCodeException exception;
37: currencyCode ame_util.attributeValueType;
38: errorCode integer;
39: errorMessage ame_util.longestStringType;
40: begin
41: /*
42: The ame_util.parseStaticCurAttValue procedure parses the usage, if it is parse-able;
43: but it doesn't validate the individual values, or convert the amount to canonical format.

Line 42: The ame_util.parseStaticCurAttValue procedure parses the usage, if it is parse-able;

38: errorCode integer;
39: errorMessage ame_util.longestStringType;
40: begin
41: /*
42: The ame_util.parseStaticCurAttValue procedure parses the usage, if it is parse-able;
43: but it doesn't validate the individual values, or convert the amount to canonical format.
44: */
45: ame_util.parseStaticCurAttValue(applicationIdIn => p_application_id,
46: attributeIdIn => p_attribute_id,

Line 45: ame_util.parseStaticCurAttValue(applicationIdIn => p_application_id,

41: /*
42: The ame_util.parseStaticCurAttValue procedure parses the usage, if it is parse-able;
43: but it doesn't validate the individual values, or convert the amount to canonical format.
44: */
45: ame_util.parseStaticCurAttValue(applicationIdIn => p_application_id,
46: attributeIdIn => p_attribute_id,
47: attributeValueIn => p_query_string,
48: amountOut => amount,
49: localErrorIn => true,

Line 52: /* ame_util.inputNumStringToCanonNumString validates and formats the amount. */

48: amountOut => amount,
49: localErrorIn => true,
50: currencyOut => currencyCode,
51: conversionTypeOut => conversionType);
52: /* ame_util.inputNumStringToCanonNumString validates and formats the amount. */
53: amount := ame_util.inputNumStringToCanonNumString(inputNumberStringIn => amount,
54: currencyCodeIn => currencyCode);
55: if not ame_util.isCurrencyCodeValid(currencyCodeIn => currencyCode) then
56: fnd_message.set_name('PER', 'AME_400151_ATT_STA_CURR_INV');

Line 53: amount := ame_util.inputNumStringToCanonNumString(inputNumberStringIn => amount,

49: localErrorIn => true,
50: currencyOut => currencyCode,
51: conversionTypeOut => conversionType);
52: /* ame_util.inputNumStringToCanonNumString validates and formats the amount. */
53: amount := ame_util.inputNumStringToCanonNumString(inputNumberStringIn => amount,
54: currencyCodeIn => currencyCode);
55: if not ame_util.isCurrencyCodeValid(currencyCodeIn => currencyCode) then
56: fnd_message.set_name('PER', 'AME_400151_ATT_STA_CURR_INV');
57: fnd_message.raise_error;

Line 55: if not ame_util.isCurrencyCodeValid(currencyCodeIn => currencyCode) then

51: conversionTypeOut => conversionType);
52: /* ame_util.inputNumStringToCanonNumString validates and formats the amount. */
53: amount := ame_util.inputNumStringToCanonNumString(inputNumberStringIn => amount,
54: currencyCodeIn => currencyCode);
55: if not ame_util.isCurrencyCodeValid(currencyCodeIn => currencyCode) then
56: fnd_message.set_name('PER', 'AME_400151_ATT_STA_CURR_INV');
57: fnd_message.raise_error;
58: end if;
59: if not ame_util.isConversionTypeValid(conversionTypeIn => conversionType) then

Line 59: if not ame_util.isConversionTypeValid(conversionTypeIn => conversionType) then

55: if not ame_util.isCurrencyCodeValid(currencyCodeIn => currencyCode) then
56: fnd_message.set_name('PER', 'AME_400151_ATT_STA_CURR_INV');
57: fnd_message.raise_error;
58: end if;
59: if not ame_util.isConversionTypeValid(conversionTypeIn => conversionType) then
60: fnd_message.set_name('PER', 'AME_400150_ATT_STA_CONV_INV');
61: fnd_message.raise_error;
62: end if;
63: return(amount || ',' || currencyCode || ',' || conversionType);

Line 146: and nvl(end_date - ame_util.oneSecond,sysdate))

142: from ame_item_class_usages
143: where application_id = p_application_id and item_class_id =
144: ( select item_class_id from ame_attributes
145: where attribute_id = p_attribute_id and sysdate between start_date
146: and nvl(end_date - ame_util.oneSecond,sysdate))
147: and sysdate between start_date and nvl(end_date - ame_util.oneSecond,sysdate);
148: begin
149: open c_sel1;
150: fetch c_sel1 into l_exists;

Line 147: and sysdate between start_date and nvl(end_date - ame_util.oneSecond,sysdate);

143: where application_id = p_application_id and item_class_id =
144: ( select item_class_id from ame_attributes
145: where attribute_id = p_attribute_id and sysdate between start_date
146: and nvl(end_date - ame_util.oneSecond,sysdate))
147: and sysdate between start_date and nvl(end_date - ame_util.oneSecond,sysdate);
148: begin
149: open c_sel1;
150: fetch c_sel1 into l_exists;
151: if c_sel1%notfound then

Line 190: nvl(end_date - ame_util.oneSecond, sysdate) ;

186: into l_approver_type_id
187: from ame_attributes
188: where attribute_id = p_attribute_id and
189: sysdate between start_date and
190: nvl(end_date - ame_util.oneSecond, sysdate) ;
191:
192: if l_approver_type_id is not null then
193: begin
194: select variable_value

Line 201: nvl(end_date - ame_util.oneSecond, sysdate);

197: where
198: variable_name = 'allowAllApproverTypes' and
199: application_id = p_application_id and
200: sysdate between start_date and
201: nvl(end_date - ame_util.oneSecond, sysdate);
202:
203: --If no transaction-type-specific config var exists, revert to the application-wide value. */
204:
205: exception

Line 214: nvl(end_date - ame_util.oneSecond, sysdate) ;

210: where
211: variable_name = 'allowAllApproverTypes' and
212: application_id = 0 and
213: sysdate between start_date and
214: nvl(end_date - ame_util.oneSecond, sysdate) ;
215: end ;
216: if l_variable_Value = 'no' then
217: select orig_system into l_orig_system from ame_approver_types
218: where approver_type_id = l_approver_type_id and

Line 220: nvl(end_date - ame_util.oneSecond, sysdate) ;

216: if l_variable_Value = 'no' then
217: select orig_system into l_orig_system from ame_approver_types
218: where approver_type_id = l_approver_type_id and
219: sysdate between start_date and
220: nvl(end_date - ame_util.oneSecond, sysdate) ;
221: if l_orig_system = 'POS' then
222: fnd_message.set_name('PER','AME_400522_ATT_NO_APPR_TYP_USG');
223: fnd_message.raise_error;
224: end if;

Line 294: nvl(end_date - ame_util.oneSecond, sysdate) ;

290: into l_attribute_type
291: from ame_attributes
292: where attribute_id = p_attribute_id
293: and sysdate between start_date and
294: nvl(end_date - ame_util.oneSecond, sysdate) ;
295: if (l_attribute_type = ame_util.booleanAttributeType)
296: or (l_attribute_type = ame_util.dateAttributeType) then
297: if p_value_set_id is not null then
298: fnd_message.set_name('PER','AME_400554_VAL_SET_ID_NULL');

Line 295: if (l_attribute_type = ame_util.booleanAttributeType)

291: from ame_attributes
292: where attribute_id = p_attribute_id
293: and sysdate between start_date and
294: nvl(end_date - ame_util.oneSecond, sysdate) ;
295: if (l_attribute_type = ame_util.booleanAttributeType)
296: or (l_attribute_type = ame_util.dateAttributeType) then
297: if p_value_set_id is not null then
298: fnd_message.set_name('PER','AME_400554_VAL_SET_ID_NULL');
299: fnd_message.raise_error;

Line 296: or (l_attribute_type = ame_util.dateAttributeType) then

292: where attribute_id = p_attribute_id
293: and sysdate between start_date and
294: nvl(end_date - ame_util.oneSecond, sysdate) ;
295: if (l_attribute_type = ame_util.booleanAttributeType)
296: or (l_attribute_type = ame_util.dateAttributeType) then
297: if p_value_set_id is not null then
298: fnd_message.set_name('PER','AME_400554_VAL_SET_ID_NULL');
299: fnd_message.raise_error;
300: end if;

Line 307: if ((l_attribute_type = ame_util.currencyAttributeType)

303: from fnd_flex_value_sets
304: where flex_value_set_id = p_value_set_id and
305: instr(flex_value_set_name,'$') = 0 ;
306:
307: if ((l_attribute_type = ame_util.currencyAttributeType)
308: or (l_attribute_type = ame_util.numberAttributeType)) and
309: l_format_type <> 'N' then
310: fnd_message.set_name('PER','AME_400555_INV_VAL_SET_FORMAT');
311: fnd_message.raise_error;

Line 308: or (l_attribute_type = ame_util.numberAttributeType)) and

304: where flex_value_set_id = p_value_set_id and
305: instr(flex_value_set_name,'$') = 0 ;
306:
307: if ((l_attribute_type = ame_util.currencyAttributeType)
308: or (l_attribute_type = ame_util.numberAttributeType)) and
309: l_format_type <> 'N' then
310: fnd_message.set_name('PER','AME_400555_INV_VAL_SET_FORMAT');
311: fnd_message.raise_error;
312: elsif (l_attribute_type = ame_util.stringAttributeType) and

Line 312: elsif (l_attribute_type = ame_util.stringAttributeType) and

308: or (l_attribute_type = ame_util.numberAttributeType)) and
309: l_format_type <> 'N' then
310: fnd_message.set_name('PER','AME_400555_INV_VAL_SET_FORMAT');
311: fnd_message.raise_error;
312: elsif (l_attribute_type = ame_util.stringAttributeType) and
313: l_format_type <> 'C' then
314: fnd_message.set_name('PER','AME_400555_INV_VAL_SET_FORMAT');
315: fnd_message.raise_error;
316: end if;

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

370: from ame_attributes
371: where
372: attribute_id = p_attribute_id and
373: p_effective_date between start_date and
374: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
375: l_exists varchar2(1);
376: begin
377: open c_sel1;
378: fetch c_sel1 into l_exists;

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

431: from ame_calling_apps
432: where
433: application_id = p_application_id and
434: p_effective_date between start_date and
435: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
436: l_exists varchar2(1);
437: begin
438: open c_sel1;
439: fetch c_sel1 into l_exists;

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

496: where
497: attribute_id = p_attribute_id and
498: application_id = p_application_id and
499: p_effective_date between start_date and
500: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
501: begin
502: hr_api.mandatory_arg_error
503: (p_api_name => l_proc
504: ,p_argument => 'application_id'

Line 532: -- Validates that the is_static field has a value of either ame_util.booleanTrue

528: --
529: -- {Start Of Comments}
530: --
531: -- Description:
532: -- Validates that the is_static field has a value of either ame_util.booleanTrue
533: -- or ame_util.booleanFalse
534: --
535: -- Prerequisites:
536: -- None.

Line 533: -- or ame_util.booleanFalse

529: -- {Start Of Comments}
530: --
531: -- Description:
532: -- Validates that the is_static field has a value of either ame_util.booleanTrue
533: -- or ame_util.booleanFalse
534: --
535: -- Prerequisites:
536: -- None.
537: --

Line 559: if NOT (p_is_static = ame_util.booleanTrue or

555: procedure chk_is_static
556: ( p_is_static in ame_attribute_usages.is_static%type) is
557: l_proc varchar2(72) := g_package||'chk_is_static';
558: begin
559: if NOT (p_is_static = ame_util.booleanTrue or
560: (p_is_static = ame_util.booleanFalse )) then
561: fnd_message.set_name('PER','AME_400475_INV_USAGE_TYPE');
562: fnd_message.raise_error;
563: end if;

Line 560: (p_is_static = ame_util.booleanFalse )) then

556: ( p_is_static in ame_attribute_usages.is_static%type) is
557: l_proc varchar2(72) := g_package||'chk_is_static';
558: begin
559: if NOT (p_is_static = ame_util.booleanTrue or
560: (p_is_static = ame_util.booleanFalse )) then
561: fnd_message.set_name('PER','AME_400475_INV_USAGE_TYPE');
562: fnd_message.raise_error;
563: end if;
564: exception

Line 615: if (p_is_static = ame_util.booleanTrue ) then /* static usage */

611: transIdPlaceholderPosition integer;
612: transIdPlaceholderPosition2 integer;
613: upperTransIdPlaceholder varchar2(100);
614: begin
615: if (p_is_static = ame_util.booleanTrue ) then /* static usage */
616: -- Check that the query string does not contain any transaction id placeholder
617: queryString := ame_util.removeReturns(stringIn => p_query_string,
618: replaceWithSpaces => false);
619: if(instrb(upper(p_query_string), upper(ame_util.transactionIdPlaceholder))) > 0 then

Line 617: queryString := ame_util.removeReturns(stringIn => p_query_string,

613: upperTransIdPlaceholder varchar2(100);
614: begin
615: if (p_is_static = ame_util.booleanTrue ) then /* static usage */
616: -- Check that the query string does not contain any transaction id placeholder
617: queryString := ame_util.removeReturns(stringIn => p_query_string,
618: replaceWithSpaces => false);
619: if(instrb(upper(p_query_string), upper(ame_util.transactionIdPlaceholder))) > 0 then
620: fnd_message.set_name('PER','AME_400159_ATT_STAT_NOT_PLC');
621: fnd_message.raise_error;

Line 619: if(instrb(upper(p_query_string), upper(ame_util.transactionIdPlaceholder))) > 0 then

615: if (p_is_static = ame_util.booleanTrue ) then /* static usage */
616: -- Check that the query string does not contain any transaction id placeholder
617: queryString := ame_util.removeReturns(stringIn => p_query_string,
618: replaceWithSpaces => false);
619: if(instrb(upper(p_query_string), upper(ame_util.transactionIdPlaceholder))) > 0 then
620: fnd_message.set_name('PER','AME_400159_ATT_STAT_NOT_PLC');
621: fnd_message.raise_error;
622: end if;
623: else /* dynamic usage (actual query string) */

Line 637: upperTransIdPlaceholder := upper(ame_util.transactionIdPlaceholder);

633: fnd_message.raise_error;
634: end if;
635: tempInt := 1;
636: queryString := upper(p_query_string);
637: upperTransIdPlaceholder := upper(ame_util.transactionIdPlaceholder);
638: loop
639: transIdPlaceholderPosition :=
640: instrb(queryString, upperTransIdPlaceholder, 1, tempInt);
641: if(transIdPlaceholderPosition = 0) then

Line 645: instrb(p_query_string, ame_util.transactionIdPlaceholder, 1, tempInt);

641: if(transIdPlaceholderPosition = 0) then
642: exit;
643: end if;
644: transIdPlaceholderPosition2 :=
645: instrb(p_query_string, ame_util.transactionIdPlaceholder, 1, tempInt);
646: if(transIdPlaceholderPosition <> transIdPlaceholderPosition2) then
647: fnd_message.set_name('PER','AME_400414_DYNAMIC_ATTR_USAGES');
648: fnd_message.raise_error;
649: end if;

Line 652: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attribute_usages',

648: fnd_message.raise_error;
649: end if;
650: tempInt := tempInt + 1;
651: end loop;
652: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attribute_usages',
653: columnNameIn => 'query_string',
654: argumentIn => p_query_string)) then
655: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');
656: fnd_message.raise_error;

Line 659: ame_util.checkForSqlInjection(queryStringIn => queryString);

655: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');
656: fnd_message.raise_error;
657: end if;
658: /* The following utility handles the error. So nothing needs to be done here */
659: ame_util.checkForSqlInjection(queryStringIn => queryString);
660: end if;
661: exception
662: when app_exception.application_exception then
663: if hr_multi_message.exception_add

Line 711: charMonths ame_util.stringList;

707: p_query_string in ame_attribute_usages.query_string%type,
708: p_effective_date in date ) is
709: --
710: l_proc varchar2(72) := g_package||'chk_qry_str_static_attr_comb';
711: charMonths ame_util.stringList;
712: comma1Location integer;
713: comma2Location integer;
714: queryString ame_attribute_usages.query_string%type;
715: queryString1 ame_attribute_usages.query_string%type;

Line 723: numMonths ame_util.stringList;

719: l_conversionType ame_attribute_usages.query_string%type;
720: l_tmpAmount ame_attribute_usages.query_string%type;
721: l_attribute_type ame_attributes.attribute_type%type;
722: l_attribute_name ame_attributes.name%type;
723: numMonths ame_util.stringList;
724: substitutionString ame_util.stringType;
725: transIdPlaceholderPosition integer;
726: transIdPlaceholderPosition2 integer;
727: l_comma1Location integer;

Line 724: substitutionString ame_util.stringType;

720: l_tmpAmount ame_attribute_usages.query_string%type;
721: l_attribute_type ame_attributes.attribute_type%type;
722: l_attribute_name ame_attributes.name%type;
723: numMonths ame_util.stringList;
724: substitutionString ame_util.stringType;
725: transIdPlaceholderPosition integer;
726: transIdPlaceholderPosition2 integer;
727: l_comma1Location integer;
728: l_comma2Location integer;

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

738: into l_attribute_name,l_attribute_type
739: from ame_attributes
740: where attribute_id = p_attribute_id
741: and p_effective_date between start_date and
742: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
743: if (p_is_static = ame_util.booleanTrue ) then /* static usage */
744: /* Check that the format of the static usage is correct. */
745: if(l_attribute_type = ame_util.currencyAttributeType) then
746: if p_query_string is not null then

Line 743: if (p_is_static = ame_util.booleanTrue ) then /* static usage */

739: from ame_attributes
740: where attribute_id = p_attribute_id
741: and p_effective_date between start_date and
742: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
743: if (p_is_static = ame_util.booleanTrue ) then /* static usage */
744: /* Check that the format of the static usage is correct. */
745: if(l_attribute_type = ame_util.currencyAttributeType) then
746: if p_query_string is not null then
747: l_comma1Location := instrb(p_query_string, ',', -1, 2);

Line 745: if(l_attribute_type = ame_util.currencyAttributeType) then

741: and p_effective_date between start_date and
742: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
743: if (p_is_static = ame_util.booleanTrue ) then /* static usage */
744: /* Check that the format of the static usage is correct. */
745: if(l_attribute_type = ame_util.currencyAttributeType) then
746: if p_query_string is not null then
747: l_comma1Location := instrb(p_query_string, ',', -1, 2);
748: l_comma2Location := instrb(p_query_string, ',', -1, 1);
749: if(l_comma1Location = 0 or

Line 760: if not ame_util.isCurrencyCodeValid(currencyCodeIn => l_currencyCode) then

756: end if;
757: l_amount := substrb(p_query_string, 1, l_comma1Location - 1);
758: l_currencyCode := substrb(p_query_string, l_comma1Location + 1, l_comma2Location - l_comma1Location - 1);
759: l_conversionType := substrb(p_query_string, l_comma2Location + 1, lengthb(p_query_string) - l_comma2Location);
760: if not ame_util.isCurrencyCodeValid(currencyCodeIn => l_currencyCode) then
761: fnd_message.set_name('PER', 'AME_400151_ATT_STA_CURR_INV');
762: fnd_message.raise_error;
763: end if;
764: l_tmpAmount := replace(l_amount,',','.');

Line 773: if not ame_util.isConversionTypeValid(conversionTypeIn => l_conversionType) then

769: maximum => null,
770: nullok => 'Y',
771: rgeflg => l_rgeflg,
772: curcode => l_currencyCode);
773: if not ame_util.isConversionTypeValid(conversionTypeIn => l_conversionType) then
774: fnd_message.set_name('PER', 'AME_400150_ATT_STA_CONV_INV');
775: fnd_message.raise_error;
776: end if;
777: else

Line 782: elsif(l_attribute_type = ame_util.numberAttributeType) then

778: fnd_message.set_name('PER', 'AME_400670_BAD_STAT_CURR_USG');
779: fnd_message.set_token('ATTRIBUTE',l_attribute_name);
780: fnd_message.raise_error;
781: end if;
782: elsif(l_attribute_type = ame_util.numberAttributeType) then
783: if p_query_string is not null and not isNumber(p_query_string) then
784: fnd_message.set_name('PER','AME_400516_ATT_STAT_USG_NUM');
785: fnd_message.raise_error;
786: elsif p_query_string is not null then

Line 797: elsif(l_attribute_type = ame_util.stringAttributeType) then

793: nullok => 'Y',
794: rgeflg => l_rgeflg,
795: curcode => null);
796: end if;
797: elsif(l_attribute_type = ame_util.stringAttributeType) then
798: if(instrb(p_query_string, '''') > 0) or length(p_query_string) > ame_util.stringTypeLength then
799: fnd_message.set_name('PER','AME_400166_ATT_STAT_USG_STRING');
800: fnd_message.raise_error;
801: end if;

Line 798: if(instrb(p_query_string, '''') > 0) or length(p_query_string) > ame_util.stringTypeLength then

794: rgeflg => l_rgeflg,
795: curcode => null);
796: end if;
797: elsif(l_attribute_type = ame_util.stringAttributeType) then
798: if(instrb(p_query_string, '''') > 0) or length(p_query_string) > ame_util.stringTypeLength then
799: fnd_message.set_name('PER','AME_400166_ATT_STAT_USG_STRING');
800: fnd_message.raise_error;
801: end if;
802: begin

Line 820: elsif(l_attribute_type = ame_util.booleanAttributeType) then

816: exception
817: when no_data_found then
818: null;
819: end;
820: elsif(l_attribute_type = ame_util.booleanAttributeType) then
821: if trim(p_query_string) IN ('true','false') then
822: querystring :=lower(trim( p_query_string));
823: else
824: fnd_message.set_name('PER','AME_400167_ATT_STAT_USG_BOOL');

Line 827: elsif(l_attribute_type = ame_util.dateAttributeType) then

823: else
824: fnd_message.set_name('PER','AME_400167_ATT_STAT_USG_BOOL');
825: fnd_message.raise_error;
826: end if;
827: elsif(l_attribute_type = ame_util.dateAttributeType) then
828: /* check to make sure the user entered the date in the correct format */
829: begin
830: if(p_query_string is not null) then
831: if instrb(p_query_string, ':', 1, 5) = 0 or

Line 849: if(l_attribute_type = ame_util.currencyAttributeType) then

845: end;
846: end if;
847: else /* dynamic usage (actual query string) */
848: l_columns := 1;
849: if(l_attribute_type = ame_util.currencyAttributeType) then
850: l_columns := 3;
851: comma1Location := instrb(queryString, ',', -1, 2);
852: comma2Location := instrb(queryString, ',', -1, 1);
853: if(comma1Location = 0 or

Line 862: select ame_util2.specialObject

858: fnd_message.raise_error;
859: end if;
860: end if;
861: begin
862: select ame_util2.specialObject
863: into l_object
864: from ame_attributes
865: where attribute_id = p_attribute_id
866: and name in (ame_util.jobLevelStartingPointAttribute

Line 866: and name in (ame_util.jobLevelStartingPointAttribute

862: select ame_util2.specialObject
863: into l_object
864: from ame_attributes
865: where attribute_id = p_attribute_id
866: and name in (ame_util.jobLevelStartingPointAttribute
867: ,ame_util.nonDefStartingPointPosAttr
868: ,ame_util.nonDefPosStructureAttr
869: ,ame_util.supStartingPointAttribute
870: ,ame_util.firstStartingPointAttribute

Line 867: ,ame_util.nonDefStartingPointPosAttr

863: into l_object
864: from ame_attributes
865: where attribute_id = p_attribute_id
866: and name in (ame_util.jobLevelStartingPointAttribute
867: ,ame_util.nonDefStartingPointPosAttr
868: ,ame_util.nonDefPosStructureAttr
869: ,ame_util.supStartingPointAttribute
870: ,ame_util.firstStartingPointAttribute
871: ,ame_util.secondStartingPointAttribute

Line 868: ,ame_util.nonDefPosStructureAttr

864: from ame_attributes
865: where attribute_id = p_attribute_id
866: and name in (ame_util.jobLevelStartingPointAttribute
867: ,ame_util.nonDefStartingPointPosAttr
868: ,ame_util.nonDefPosStructureAttr
869: ,ame_util.supStartingPointAttribute
870: ,ame_util.firstStartingPointAttribute
871: ,ame_util.secondStartingPointAttribute
872: )

Line 869: ,ame_util.supStartingPointAttribute

865: where attribute_id = p_attribute_id
866: and name in (ame_util.jobLevelStartingPointAttribute
867: ,ame_util.nonDefStartingPointPosAttr
868: ,ame_util.nonDefPosStructureAttr
869: ,ame_util.supStartingPointAttribute
870: ,ame_util.firstStartingPointAttribute
871: ,ame_util.secondStartingPointAttribute
872: )
873: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);

Line 870: ,ame_util.firstStartingPointAttribute

866: and name in (ame_util.jobLevelStartingPointAttribute
867: ,ame_util.nonDefStartingPointPosAttr
868: ,ame_util.nonDefPosStructureAttr
869: ,ame_util.supStartingPointAttribute
870: ,ame_util.firstStartingPointAttribute
871: ,ame_util.secondStartingPointAttribute
872: )
873: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
874: exception

Line 871: ,ame_util.secondStartingPointAttribute

867: ,ame_util.nonDefStartingPointPosAttr
868: ,ame_util.nonDefPosStructureAttr
869: ,ame_util.supStartingPointAttribute
870: ,ame_util.firstStartingPointAttribute
871: ,ame_util.secondStartingPointAttribute
872: )
873: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
874: exception
875: when no_data_found then

Line 876: l_object := ame_util2.attributeObject;

872: )
873: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
874: exception
875: when no_data_found then
876: l_object := ame_util2.attributeObject;
877: end;
878: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string
879: ,p_columns => l_columns
880: ,p_object => l_object

Line 878: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string

874: exception
875: when no_data_found then
876: l_object := ame_util2.attributeObject;
877: end;
878: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string
879: ,p_columns => l_columns
880: ,p_object => l_object
881: );
882: if l_valid <> 'Y' then

Line 950: -- Validates that the user_editable field has a value of either ame_util.booleanTrue

946: --
947: -- {Start Of Comments}
948: --
949: -- Description:
950: -- Validates that the user_editable field has a value of either ame_util.booleanTrue
951: -- or ame_util.booleanFalse
952: --
953: -- Prerequisites:
954: -- None.

Line 951: -- or ame_util.booleanFalse

947: -- {Start Of Comments}
948: --
949: -- Description:
950: -- Validates that the user_editable field has a value of either ame_util.booleanTrue
951: -- or ame_util.booleanFalse
952: --
953: -- Prerequisites:
954: -- None.
955: --

Line 977: if NOT (p_user_editable = ame_util.booleanTrue or

973: procedure chk_user_editable
974: ( p_user_editable in ame_attribute_usages.user_editable%type) is
975: l_proc varchar2(72) := g_package||'chk_user_editable';
976: begin
977: if NOT (p_user_editable = ame_util.booleanTrue or
978: (p_user_editable = ame_util.booleanFalse )) then
979: fnd_message.set_name('PER','AME_400476_INV_USER_EDITABLE');
980: fnd_message.raise_error;
981: end if;

Line 978: (p_user_editable = ame_util.booleanFalse )) then

974: ( p_user_editable in ame_attribute_usages.user_editable%type) is
975: l_proc varchar2(72) := g_package||'chk_user_editable';
976: begin
977: if NOT (p_user_editable = ame_util.booleanTrue or
978: (p_user_editable = ame_util.booleanFalse )) then
979: fnd_message.set_name('PER','AME_400476_INV_USER_EDITABLE');
980: fnd_message.raise_error;
981: end if;
982: exception

Line 1050: if (ame_atu_shd.g_old_rec.user_editable = ame_util.booleanFalse) then

1046: fnd_message.set_token('PROCEDURE ', l_proc);
1047: fnd_message.set_token('STEP ', '5');
1048: fnd_message.raise_error;
1049: end if;
1050: if (ame_atu_shd.g_old_rec.user_editable = ame_util.booleanFalse) then
1051: if (ame_atu_shd.g_old_rec.is_static <> p_rec.is_static) then
1052: fnd_message.set_name('PER', 'AME_400467_NON_UPDATEABLE_FIELD');
1053: fnd_message.set_token('FIELD_NAME ', 'IS_STATIC');
1054: fnd_message.set_token('PROCEDURE ', l_proc);

Line 1078: -- 3. USER_EDITABLE is not ame_util.booleanFalse

1074: --
1075: -- Description:
1076: -- check that 1. No condition based on this attribute exist
1077: -- 2. Attribute is not an existing Mandatory attribute
1078: -- 3. USER_EDITABLE is not ame_util.booleanFalse
1079: --
1080: -- Prerequisites:
1081: -- None.
1082: --

Line 1122: nvl(end_date-(ame_util.oneSecond),sysdate);

1118: where
1119: attribute_id = p_attribute_id and
1120: application_id = p_application_id and
1121: sysdate between start_date and
1122: nvl(end_date-(ame_util.oneSecond),sysdate);
1123:
1124: cursor c_sel2 is
1125: select null
1126: from ame_mandatory_attributes

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

1127: where
1128: attribute_id = p_attribute_id and
1129: action_type_id = -1 and
1130: p_effective_date between start_date and
1131: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
1132:
1133: -- cursor c_sel3 is
1134: -- select null
1135: -- from ame_attribute_usages

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

1132:
1133: -- cursor c_sel3 is
1134: -- select null
1135: -- from ame_attribute_usages
1136: -- where ame_utility_pkg.check_seeddb = 'N'
1137: -- and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
1138: -- and attribute_id = p_attribute_id
1139: -- and application_id = p_application_id
1140: -- and p_effective_date between start_date

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

1133: -- cursor c_sel3 is
1134: -- select null
1135: -- from ame_attribute_usages
1136: -- where ame_utility_pkg.check_seeddb = 'N'
1137: -- and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
1138: -- and attribute_id = p_attribute_id
1139: -- and application_id = p_application_id
1140: -- and p_effective_date between start_date
1141: -- and nvl(end_date - (1/86400), sysdate);

Line 1147: if (ame_atu_shd.g_old_rec.user_editable = ame_util.booleanFalse) then

1143: l_use_count := 0;
1144: if (instr(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_TRANS_TYPE_API'||fnd_global.local_chr(10)) <> 0) then
1145: return;
1146: end if;
1147: if (ame_atu_shd.g_old_rec.user_editable = ame_util.booleanFalse) then
1148: fnd_message.set_name('PER', 'AME_400477_CANNOT_DEL_SEEDED');
1149: fnd_message.raise_error;
1150: end if;
1151:

Line 1162: l_seededDb := ame_utility_pkg.check_seeddb;

1158: fnd_message.raise_error;
1159: else
1160: open c_sel2;
1161: fetch c_sel2 into l_exists;
1162: l_seededDb := ame_utility_pkg.check_seeddb;
1163: if c_sel2%found and l_seededDb = 'N' then
1164: close c_sel2;
1165: fnd_message.set_name('PER','AME_400170_ATT_MAND_CANT_DEL');
1166: fnd_message.raise_error;