APPS.AME_ADMIN_PKG dependencies on FND_APPLICATION_VL

Line 268: description fnd_application_vl.application_name%type;

264: return(null);
265: end getAttributeStripingUseCount;
266: */
267: function getFndAppDescription(fndAppIdIn in integer) return varchar2 as
268: description fnd_application_vl.application_name%type;
269: begin
270: select ltrim(fnd_application_vl.application_name)
271: into description
272: from fnd_application_vl

Line 270: select ltrim(fnd_application_vl.application_name)

266: */
267: function getFndAppDescription(fndAppIdIn in integer) return varchar2 as
268: description fnd_application_vl.application_name%type;
269: begin
270: select ltrim(fnd_application_vl.application_name)
271: into description
272: from fnd_application_vl
273: where application_id = fndAppIdIn;
274: return(description);

Line 272: from fnd_application_vl

268: description fnd_application_vl.application_name%type;
269: begin
270: select ltrim(fnd_application_vl.application_name)
271: into description
272: from fnd_application_vl
273: where application_id = fndAppIdIn;
274: return(description);
275: exception
276: when others then

Line 286: description fnd_application_vl.application_name%type;

282: raise;
283: return(null);
284: end getFndAppDescription;
285: function getFndAppDescription1(applicationIdIn in integer) return varchar2 as
286: description fnd_application_vl.application_name%type;
287: begin
288: select ltrim(fnd_application_vl.application_name)
289: into description
290: from

Line 288: select ltrim(fnd_application_vl.application_name)

284: end getFndAppDescription;
285: function getFndAppDescription1(applicationIdIn in integer) return varchar2 as
286: description fnd_application_vl.application_name%type;
287: begin
288: select ltrim(fnd_application_vl.application_name)
289: into description
290: from
291: fnd_application_vl,
292: ame_calling_apps

Line 291: fnd_application_vl,

287: begin
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

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 298: order by fnd_application_vl.application_name;

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
302: rollback;

Line 2919: from fnd_application_vl

2915: cursor fndAppNamesCursor is
2916: select
2917: application_id,
2918: substrb(ltrim(application_name),1,99) application_name
2919: from fnd_application_vl
2920: order by application_name;
2921: tempIndex integer;
2922: begin
2923: tempIndex := 0;