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_ADMIN_PKG dependencies on AME_CALLING_APPS

Line 24: itemIdQuery ame_calling_apps.line_item_id_query%type;

20: end arePrioritiesDisabled;
21: function canHaveItemAttributes(applicationIdIn in integer,
22: itemClassIdIn in integer) return boolean is
23: itemCount integer;
24: itemIdQuery ame_calling_apps.line_item_id_query%type;
25: begin
26: select item_id_query
27: into itemIdQuery
28: from

Line 140: from ame_calling_apps

136: appId integer;
137: begin
138: select application_id
139: into appId
140: from ame_calling_apps
141: where
142: fnd_application_id = fndAppIdIn and
143: ((transaction_type_id is null and transactionTypeIdIn is null) or
144: transaction_type_id = transactionTypeIdIn) and

Line 163: from ame_calling_apps

159: appId integer;
160: begin
161: select application_id
162: into appId
163: from ame_calling_apps
164: where
165: application_name = nameIn and
166: sysdate between start_date and
167: nvl(end_date - ame_util.oneSecond, sysdate);

Line 180: applicationName ame_calling_apps.application_name%type;

176: raise;
177: return(null);
178: end getApplicationIdByName;
179: function getApplicationName(applicationIdIn in integer) return varchar2 as
180: applicationName ame_calling_apps.application_name%type;
181: begin
182: select application_name
183: into applicationName
184: from ame_calling_apps

Line 184: from ame_calling_apps

180: applicationName ame_calling_apps.application_name%type;
181: begin
182: select application_name
183: into applicationName
184: from ame_calling_apps
185: where
186: application_id = applicationIdIn and
187: sysdate between start_date and
188: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 292: ame_calling_apps

288: select ltrim(fnd_application_vl.application_name)
289: into description
290: from
291: fnd_application_vl,
292: ame_calling_apps
293: where
294: fnd_application_vl.application_id = ame_calling_apps.fnd_application_id and
295: ame_calling_apps.application_id = applicationIdIn and
296: sysdate between ame_calling_apps.start_date and

Line 294: fnd_application_vl.application_id = ame_calling_apps.fnd_application_id and

290: from
291: fnd_application_vl,
292: ame_calling_apps
293: where
294: fnd_application_vl.application_id = ame_calling_apps.fnd_application_id and
295: ame_calling_apps.application_id = applicationIdIn and
296: sysdate between ame_calling_apps.start_date and
297: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
298: order by fnd_application_vl.application_name;

Line 295: ame_calling_apps.application_id = applicationIdIn and

291: fnd_application_vl,
292: ame_calling_apps
293: where
294: fnd_application_vl.application_id = ame_calling_apps.fnd_application_id and
295: ame_calling_apps.application_id = applicationIdIn and
296: sysdate between ame_calling_apps.start_date and
297: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
298: order by fnd_application_vl.application_name;
299: return(description);

Line 296: sysdate between ame_calling_apps.start_date and

292: ame_calling_apps
293: where
294: fnd_application_vl.application_id = ame_calling_apps.fnd_application_id and
295: ame_calling_apps.application_id = applicationIdIn and
296: sysdate between ame_calling_apps.start_date and
297: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
298: order by fnd_application_vl.application_name;
299: return(description);
300: exception

Line 297: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)

293: where
294: fnd_application_vl.application_id = ame_calling_apps.fnd_application_id and
295: ame_calling_apps.application_id = applicationIdIn and
296: sysdate between ame_calling_apps.start_date and
297: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
298: order by fnd_application_vl.application_name;
299: return(description);
300: exception
301: when others then

Line 311: fndApplicationId ame_calling_apps.fnd_application_id%type;

307: raise;
308: return(null);
309: end getFndAppDescription1;
310: function getFndApplicationId(applicationIdIn in integer) return integer as
311: fndApplicationId ame_calling_apps.fnd_application_id%type;
312: begin
313: select fnd_application_id
314: into fndApplicationId
315: from ame_calling_apps

Line 315: from ame_calling_apps

311: fndApplicationId ame_calling_apps.fnd_application_id%type;
312: begin
313: select fnd_application_id
314: into fndApplicationId
315: from ame_calling_apps
316: where
317: application_id = applicationIdIn and
318: sysdate between start_date and
319: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 423: lineItemQueryString ame_calling_apps.line_item_id_query%type;

419: raise;
420: return(null);
421: end getItemClassName;
422: function getLineItemQueryString(applicationIdIn in integer) return varchar2 as
423: lineItemQueryString ame_calling_apps.line_item_id_query%type;
424: begin
425: select line_item_id_query
426: into lineItemQueryString
427: from ame_calling_apps

Line 427: from ame_calling_apps

423: lineItemQueryString ame_calling_apps.line_item_id_query%type;
424: begin
425: select line_item_id_query
426: into lineItemQueryString
427: from ame_calling_apps
428: where
429: application_id = applicationIdIn and
430: sysdate between start_date and
431: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 609: tempTransactionTypeId ame_calling_apps.transaction_type_id%type;

605: raise;
606: return(null);
607: end getSubordinateItemClassId;
608: function getTransactionTypeId(applicationIdIn in integer) return varchar2 as
609: tempTransactionTypeId ame_calling_apps.transaction_type_id%type;
610: begin
611: select transaction_type_id
612: into tempTransactionTypeId
613: from ame_calling_apps

Line 613: from ame_calling_apps

609: tempTransactionTypeId ame_calling_apps.transaction_type_id%type;
610: begin
611: select transaction_type_id
612: into tempTransactionTypeId
613: from ame_calling_apps
614: where application_id = applicationIdIn and
615: sysdate between start_date and
616: nvl(end_date - ame_util.oneSecond, sysdate) ;
617: return tempTransactionTypeId;

Line 636: from ame_calling_apps

632: stringStartDate varchar2(50);
633: begin
634: select start_date
635: into startDate
636: from ame_calling_apps
637: where
638: application_id = applicationIdIn and
639: sysdate between start_date and
640: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 873: from ame_calling_apps

869: appCount integer;
870: begin
871: select count(*)
872: into appCount
873: from ame_calling_apps
874: where
875: application_id = applicationIdIn and
876: sysdate between start_date and
877: nvl(end_date - ame_util.oneSecond, sysdate);

Line 929: from ame_calling_apps

925: createdByValue integer;
926: begin
927: select created_by
928: into createdByValue
929: from ame_calling_apps
930: where application_id = applicationIdIn and
931: sysdate between start_date and
932: nvl(end_date - ame_util.oneSecond, sysdate) ;
933: if(createdByValue = 1) then

Line 1710: from ame_calling_apps

1706: transactionTypeDescriptionIn in varchar2,
1707: versionStartDateIn in date) as
1708: cursor startDateCursor is
1709: select start_date
1710: from ame_calling_apps
1711: where
1712: application_id = applicationIdIn and
1713: sysdate between start_date and
1714: nvl(end_date - ame_util.oneSecond, sysdate)

Line 1721: fndApplicationId ame_calling_apps.fnd_application_id%type;

1717: createdBy integer;
1718: currentUserId integer;
1719: errorCode integer;
1720: errorMessage ame_util.longestStringType;
1721: fndApplicationId ame_calling_apps.fnd_application_id%type;
1722: invalidOrderException exception;
1723: multipleTransTypesException exception;
1724: processingDate date;
1725: startDate date;

Line 1740: update ame_calling_apps

1736: close startDateCursor;
1737: raise ame_util.objectVersionException;
1738: end if;
1739: close startDateCursor;
1740: update ame_calling_apps
1741: set
1742: last_updated_by = currentUserId,
1743: last_update_date = processingDate,
1744: last_update_login = currentUserId,

Line 1759: from ame_calling_apps

1755: transTypeIdIn => transactionTypeIdIn,
1756: transTypeDescIn => transactionTypeDescriptionIn);
1757: select count(*)
1758: into tempCount
1759: from ame_calling_apps
1760: where
1761: application_id = applicationIdIn and
1762: created_by = ame_util.seededDataCreatedById;
1763: if(tempCount > 0) then

Line 1769: insert into ame_calling_apps(fnd_application_id,

1765: else
1766: createdBy := currentUserId;
1767: end if;
1768: /* Perform update. */
1769: insert into ame_calling_apps(fnd_application_id,
1770: application_name,
1771: application_id,
1772: transaction_type_id,
1773: created_by,

Line 2225: from ame_calling_apps

2221: begin
2222: /* You can't add a trans type if a null trans type ID already exists for the same app. */
2223: select count(*)
2224: into tempCount
2225: from ame_calling_apps
2226: where
2227: fnd_application_id = fndAppIdIn and
2228: transaction_type_id is null and
2229: sysdate between start_date and

Line 2238: from ame_calling_apps

2234: /* You can't add a null trans type ID if a trans type already exists for same app. */
2235: if(transTypeIdIn is null) then
2236: select count(*)
2237: into tempCount
2238: from ame_calling_apps
2239: where
2240: fnd_application_id = fndAppIdIn and
2241: sysdate between start_date and
2242: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 2250: from ame_calling_apps

2246: end if;
2247: /* You can't add the same trans type as one that already exists. */
2248: select count(*)
2249: into tempCount
2250: from ame_calling_apps
2251: where
2252: fnd_application_id = fndAppIdIn and
2253: transaction_type_id = transTypeIdIn and
2254: sysdate between start_date and

Line 2262: from ame_calling_apps

2258: end if;
2259: /* You can't add the same desc as one that already exists. */
2260: select count(*)
2261: into tempCount
2262: from ame_calling_apps
2263: where
2264: upper(application_name) = upper(transTypeDescIn) and
2265: sysdate between start_date and
2266: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 3684: ame_calling_apps

3680: created_by,
3681: application_name,
3682: transaction_type_id
3683: from
3684: ame_calling_apps
3685: where
3686: sysdate between start_date and
3687: nvl(end_date - ame_util.oneSecond, sysdate)
3688: order by application_name;

Line 3931: transactionTypeId ame_calling_apps.transaction_type_id%type;

3927: fndAppId integer;
3928: logCursor logCursorType;
3929: logCursorValues logCursorReturnType;
3930: tempIndex integer;
3931: transactionTypeId ame_calling_apps.transaction_type_id%type;
3932: workflowItemKey wf_item_activity_statuses.item_key%type;
3933: workflowItemType wf_item_activity_statuses.item_type%type;
3934: begin
3935: ame_util.getFndApplicationId(applicationIdIn => applicationIdIn,

Line 4554: insert into ame_calling_apps(fnd_application_id,

4550: currentUserId := ame_util.getCurrentUserId;
4551: select ame_applications_s.nextval
4552: into applicationId
4553: from dual;
4554: insert into ame_calling_apps(fnd_application_id,
4555: application_name,
4556: application_id,
4557: transaction_type_id,
4558: created_by,

Line 5325: from ame_calling_apps

5321: procedure removeTransactionType(applicationIdIn in integer,
5322: versionStartDateIn in date) as
5323: cursor startDateCursor is
5324: select start_date
5325: from ame_calling_apps
5326: where
5327: application_id = applicationIdIn and
5328: sysdate between start_date and
5329: nvl(end_date - ame_util.oneSecond, sysdate)

Line 5382: update ame_calling_apps

5378: allowAttributeUsageDeleteIn => true,
5379: finalizeIn => false,
5380: itemClassIdIn => itemClassId);
5381: end loop;
5382: update ame_calling_apps
5383: set
5384: last_updated_by = currentUserId,
5385: last_update_date = processingDate,
5386: last_update_login = currentUserId,