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_ATTRIBUTE_USAGES

Line 490: p_application_id in ame_attribute_usages.application_id%type) is

486: -- ----------------------------------------------------------------------------
487: procedure chk_primary_key
488: (p_attribute_id in number,
489: p_effective_date in date,
490: p_application_id in ame_attribute_usages.application_id%type) is
491: l_proc varchar2(72) := g_package||'chk_primary_key';
492: tempCount integer;
493: cursor c_sel1 is
494: select count(*)

Line 495: from ame_attribute_usages

491: l_proc varchar2(72) := g_package||'chk_primary_key';
492: tempCount integer;
493: cursor c_sel1 is
494: select count(*)
495: from ame_attribute_usages
496: where
497: attribute_id = p_attribute_id and
498: application_id = p_application_id and
499: p_effective_date between start_date and

Line 556: ( p_is_static in ame_attribute_usages.is_static%type) is

552: --
553: -- {End Of Comments}
554: -- ----------------------------------------------------------------------------
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

Line 604: ( p_is_static in ame_attribute_usages.is_static%type,

600: --
601: -- {End Of Comments}
602: -- ----------------------------------------------------------------------------
603: procedure chk_qry_string_is_static_comb
604: ( p_is_static in ame_attribute_usages.is_static%type,
605: p_query_string in ame_attribute_usages.query_string%type ) is
606:
607: l_proc varchar2(72) := g_package||'chk_qry_string_is_static_comb';
608: queryString ame_attribute_usages.query_string%type;

Line 605: p_query_string in ame_attribute_usages.query_string%type ) is

601: -- {End Of Comments}
602: -- ----------------------------------------------------------------------------
603: procedure chk_qry_string_is_static_comb
604: ( p_is_static in ame_attribute_usages.is_static%type,
605: p_query_string in ame_attribute_usages.query_string%type ) is
606:
607: l_proc varchar2(72) := g_package||'chk_qry_string_is_static_comb';
608: queryString ame_attribute_usages.query_string%type;
609: queryString1 ame_attribute_usages.query_string%type;

Line 608: queryString ame_attribute_usages.query_string%type;

604: ( p_is_static in ame_attribute_usages.is_static%type,
605: p_query_string in ame_attribute_usages.query_string%type ) is
606:
607: l_proc varchar2(72) := g_package||'chk_qry_string_is_static_comb';
608: queryString ame_attribute_usages.query_string%type;
609: queryString1 ame_attribute_usages.query_string%type;
610: tempInt integer;
611: transIdPlaceholderPosition integer;
612: transIdPlaceholderPosition2 integer;

Line 609: queryString1 ame_attribute_usages.query_string%type;

605: p_query_string in ame_attribute_usages.query_string%type ) is
606:
607: l_proc varchar2(72) := g_package||'chk_qry_string_is_static_comb';
608: queryString ame_attribute_usages.query_string%type;
609: queryString1 ame_attribute_usages.query_string%type;
610: tempInt integer;
611: transIdPlaceholderPosition integer;
612: transIdPlaceholderPosition2 integer;
613: upperTransIdPlaceholder varchar2(100);

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 704: ( p_attribute_id in ame_attribute_usages.attribute_id%type,

700: --
701: -- {End Of Comments}
702: -- ----------------------------------------------------------------------------
703: procedure chk_qry_str_static_attr_comb
704: ( p_attribute_id in ame_attribute_usages.attribute_id%type,
705: p_application_id in ame_attribute_usages.application_id%type,
706: p_is_static in ame_attribute_usages.is_static%type,
707: p_query_string in ame_attribute_usages.query_string%type,
708: p_effective_date in date ) is

Line 705: p_application_id in ame_attribute_usages.application_id%type,

701: -- {End Of Comments}
702: -- ----------------------------------------------------------------------------
703: procedure chk_qry_str_static_attr_comb
704: ( p_attribute_id in ame_attribute_usages.attribute_id%type,
705: p_application_id in ame_attribute_usages.application_id%type,
706: p_is_static in ame_attribute_usages.is_static%type,
707: p_query_string in ame_attribute_usages.query_string%type,
708: p_effective_date in date ) is
709: --

Line 706: p_is_static in ame_attribute_usages.is_static%type,

702: -- ----------------------------------------------------------------------------
703: procedure chk_qry_str_static_attr_comb
704: ( p_attribute_id in ame_attribute_usages.attribute_id%type,
705: p_application_id in ame_attribute_usages.application_id%type,
706: p_is_static in ame_attribute_usages.is_static%type,
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';

Line 707: p_query_string in ame_attribute_usages.query_string%type,

703: procedure chk_qry_str_static_attr_comb
704: ( p_attribute_id in ame_attribute_usages.attribute_id%type,
705: p_application_id in ame_attribute_usages.application_id%type,
706: p_is_static in ame_attribute_usages.is_static%type,
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;

Line 714: queryString ame_attribute_usages.query_string%type;

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;
716: l_tmpQueryString ame_attribute_usages.query_string%type;
717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;

Line 715: queryString1 ame_attribute_usages.query_string%type;

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;
716: l_tmpQueryString ame_attribute_usages.query_string%type;
717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;
719: l_conversionType ame_attribute_usages.query_string%type;

Line 716: l_tmpQueryString ame_attribute_usages.query_string%type;

712: comma1Location integer;
713: comma2Location integer;
714: queryString ame_attribute_usages.query_string%type;
715: queryString1 ame_attribute_usages.query_string%type;
716: l_tmpQueryString ame_attribute_usages.query_string%type;
717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;
719: l_conversionType ame_attribute_usages.query_string%type;
720: l_tmpAmount ame_attribute_usages.query_string%type;

Line 717: l_amount ame_attribute_usages.query_string%type;

713: comma2Location integer;
714: queryString ame_attribute_usages.query_string%type;
715: queryString1 ame_attribute_usages.query_string%type;
716: l_tmpQueryString ame_attribute_usages.query_string%type;
717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;
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;

Line 718: l_currencyCode ame_attribute_usages.query_string%type;

714: queryString ame_attribute_usages.query_string%type;
715: queryString1 ame_attribute_usages.query_string%type;
716: l_tmpQueryString ame_attribute_usages.query_string%type;
717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;
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;

Line 719: l_conversionType ame_attribute_usages.query_string%type;

715: queryString1 ame_attribute_usages.query_string%type;
716: l_tmpQueryString ame_attribute_usages.query_string%type;
717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;
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;

Line 720: l_tmpAmount ame_attribute_usages.query_string%type;

716: l_tmpQueryString ame_attribute_usages.query_string%type;
717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;
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;

Line 926: ( p_use_count in ame_attribute_usages.use_count%type) is

922: --
923: -- {End Of Comments}
924: -- ----------------------------------------------------------------------------
925: procedure chk_use_count
926: ( p_use_count in ame_attribute_usages.use_count%type) is
927: l_proc varchar2(72) := g_package||'chk_use_count';
928: begin
929: if p_use_count <> 0 then
930: fnd_message.set_name('PER','AME_400039_ATT_TTYPE_USES');

Line 974: ( p_user_editable in ame_attribute_usages.user_editable%type) is

970: --
971: -- {End Of Comments}
972: -- ----------------------------------------------------------------------------
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

Line 1117: from ame_attribute_usages

1113: l_seededDb varchar2(1);
1114:
1115: cursor c_sel1 is
1116: select use_count
1117: from ame_attribute_usages
1118: where
1119: attribute_id = p_attribute_id and
1120: application_id = p_application_id and
1121: sysdate between start_date and

Line 1135: -- from ame_attribute_usages

1131: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
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