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

Line 1: package BODY ame_utility_pkg as

1: package BODY ame_utility_pkg as
2: /* $Header: ameutility.pkb 120.10 2008/04/11 05:30:41 prasashe noship $ */
3: --private method
4: procedure checkBindVariables(queryStringIn in varchar2
5: ,allowedBindVars in ame_util.stringList) as

Line 5: ,allowedBindVars in ame_util.stringList) as

1: package BODY ame_utility_pkg as
2: /* $Header: ameutility.pkb 120.10 2008/04/11 05:30:41 prasashe noship $ */
3: --private method
4: procedure checkBindVariables(queryStringIn in varchar2
5: ,allowedBindVars in ame_util.stringList) as
6: tempstring1 varchar2(4000);
7: tempstring varchar2(4000);
8: col1Position number;
9: col2Position number;

Line 73: l_allowed_bind_vars ame_util.stringList;

69: temp_query_string varchar2(4000);
70: columna varchar2(100);
71: columnb varchar2(100);
72: error_string varchar2(1000);
73: l_allowed_bind_vars ame_util.stringList;
74: begin
75: if (check_seeddb = 'Y') then
76: return 'Y';
77: end if;

Line 205: if(p_object in ( ame_util2.attributeObject, ame_util2.itemClassObject) ) then

201:
202: --Check for valid bind variable for the module
203: if(p_object is not null) then
204: begin
205: if(p_object in ( ame_util2.attributeObject, ame_util2.itemClassObject) ) then
206: l_allowed_bind_vars(1) := 'transactionId';
207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';

Line 207: elsif (p_object = ame_util2.actionTypeObject) then

203: if(p_object is not null) then
204: begin
205: if(p_object in ( ame_util2.attributeObject, ame_util2.itemClassObject) ) then
206: l_allowed_bind_vars(1) := 'transactionId';
207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';
210: elsif (p_object = ame_util2.approverGroupObject or
211: p_object = ame_util2.specialObject) then

Line 210: elsif (p_object = ame_util2.approverGroupObject or

206: l_allowed_bind_vars(1) := 'transactionId';
207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';
210: elsif (p_object = ame_util2.approverGroupObject or
211: p_object = ame_util2.specialObject) then
212: l_allowed_bind_vars(1) := 'transactionId';
213: l_allowed_bind_vars(2) := 'itemId';
214: l_allowed_bind_vars(3) := 'itemClass';

Line 211: p_object = ame_util2.specialObject) then

207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';
210: elsif (p_object = ame_util2.approverGroupObject or
211: p_object = ame_util2.specialObject) then
212: l_allowed_bind_vars(1) := 'transactionId';
213: l_allowed_bind_vars(2) := 'itemId';
214: l_allowed_bind_vars(3) := 'itemClass';
215: end if;

Line 221: if (p_object = ame_util2.attributeObject) then

217: ,allowedBindVars => l_allowed_bind_vars
218: );
219: exception
220: when others then
221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then

Line 223: elsif p_object = ame_util2.specialObject then

219: exception
220: when others then
221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then

Line 225: elsif p_object = ame_util2.itemClassObject then

221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then

Line 227: elsif p_object = ame_util2.actionTypeObject then

223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');
231: end if;

Line 229: elsif p_object = ame_util2.approverGroupObject then

225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');
231: end if;
232: return fnd_message.get;
233: end;

Line 395: if l_name = ame_util.substitutionTypeName or l_name = ame_util.positionTypeName then

391: and rownum < 2;
392:
393: l_return_value := 'N';
394:
395: if l_name = ame_util.substitutionTypeName or l_name = ame_util.positionTypeName then
396: select 'Y' into l_return_value
397: from wf_roles wfroles
398: ,ame_actions act
399: where wfroles.name = act.parameter

Line 762: action_types_list ame_util.longStringList;

758: end get_condition_description;
759:
760: function get_action_types(p_attribute_id number) return varchar2 is
761:
762: action_types_list ame_util.longStringList;
763: list varchar2(4000);
764:
765: cursor action_types_cursor(l_attribute_id number)is
766: select act.name

Line 800: action_type_id_list ame_util.idList;

796: end get_action_types;
797:
798: function get_attribute_category(p_attribute_id number) return varchar2 as
799:
800: action_type_id_list ame_util.idList;
801: man_category varchar2(25);
802: req_category varchar2(25);
803: oth_category varchar2(25);
804:

Line 1549: return ame_util.seededDataCreatedById;

1545: (p_user_id integer
1546: ) return number is
1547: begin
1548: if p_user_id in (1,2,120,121) then
1549: return ame_util.seededDataCreatedById;
1550: else
1551: return 0;
1552: end if;
1553: end is_seed_user;

Line 1569: end ame_utility_pkg;

1565: return nextSequence;
1566: end if;
1567: end loop;
1568: end getNextApproverTypeId;
1569: end ame_utility_pkg;