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_APPROVER_TYPE_PKG dependencies on AME_APPROVER_TYPES

Line 425: approverTypeId ame_approver_types.approver_type_id%type;

421: raise;
422: return(null);
423: end getApproverOrigSystemId;
424: function getApproverTypeId(origSystemIn in varchar2) return integer as
425: approverTypeId ame_approver_types.approver_type_id%type;
426: begin
427: select approver_type_id
428: into approverTypeId
429: from ame_approver_types

Line 429: from ame_approver_types

425: approverTypeId ame_approver_types.approver_type_id%type;
426: begin
427: select approver_type_id
428: into approverTypeId
429: from ame_approver_types
430: where
431: orig_system = origSystemIn and
432: sysdate between
433: start_date and

Line 447: origSystem ame_approver_types.orig_system%type;

443: raise;
444: return(null);
445: end getApproverTypeId;
446: function getApproverTypeOrigSystem(approverTypeIdIn in integer) return varchar2 as
447: origSystem ame_approver_types.orig_system%type;
448: begin
449: select orig_system
450: into origSystem
451: from ame_approver_types

Line 451: from ame_approver_types

447: origSystem ame_approver_types.orig_system%type;
448: begin
449: select orig_system
450: into origSystem
451: from ame_approver_types
452: where
453: approver_type_id = approverTypeIdIn and
454: sysdate between
455: start_date and

Line 469: origSystem ame_approver_types.orig_system%type;

465: raise;
466: return(null);
467: end getApproverTypeOrigSystem;
468: function getApproverTypeDisplayName(approverTypeIdIn in integer) return varchar2 as
469: origSystem ame_approver_types.orig_system%type;
470: begin
471: select orig_system
472: into origSystem
473: from ame_approver_types

Line 473: from ame_approver_types

469: origSystem ame_approver_types.orig_system%type;
470: begin
471: select orig_system
472: into origSystem
473: from ame_approver_types
474: where
475: approver_type_id = approverTypeIdIn and
476: sysdate between start_date and
477: nvl(end_date - ame_util.oneSecond, sysdate) and

Line 513: queryProcedure ame_approver_types.query_procedure%type;

509: raise;
510: return(null);
511: end getOrigSystemDisplayName;
512: function getQueryProcedure(approverTypeIdIn in integer) return varchar2 as
513: queryProcedure ame_approver_types.query_procedure%type;
514: begin
515: select query_procedure
516: into queryProcedure
517: from ame_approver_types

Line 517: from ame_approver_types

513: queryProcedure ame_approver_types.query_procedure%type;
514: begin
515: select query_procedure
516: into queryProcedure
517: from ame_approver_types
518: where
519: approver_type_id = approverTypeIdIn and
520: sysdate between
521: start_date and

Line 1189: from ame_approver_types

1185: variableLovQueries(2),
1186: variableLovQueries(3),
1187: variableLovQueries(4),
1188: variableLovQueries(5)
1189: from ame_approver_types
1190: where
1191: approver_type_id = approverTypeIdIn and
1192: sysdate between
1193: start_date and

Line 1223: from ame_approver_types

1219: cursor getApproverTypeDataCursor is
1220: select
1221: approver_type_id,
1222: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1223: from ame_approver_types
1224: where sysdate between
1225: start_date and
1226: nvl(end_date - ame_util.oneSecond, sysdate);
1227: cursor getApproverTypeDataCursor2 is

Line 1231: from ame_approver_types

1227: cursor getApproverTypeDataCursor2 is
1228: select
1229: approver_type_id,
1230: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1231: from ame_approver_types
1232: where
1233: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
1234: sysdate between
1235: start_date and

Line 1286: from ame_approver_types

1282: cursor unusedApproverTypeCursor is
1283: select
1284: approver_type_id,
1285: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1286: from ame_approver_types
1287: where sysdate between
1288: start_date and
1289: nvl(end_date - ame_util.oneSecond, sysdate)
1290: minus

Line 1292: ame_approver_types.approver_type_id,

1288: start_date and
1289: nvl(end_date - ame_util.oneSecond, sysdate)
1290: minus
1291: select
1292: ame_approver_types.approver_type_id,
1293: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1294: from ame_approver_types,
1295: ame_approver_type_usages
1296: where

Line 1294: from ame_approver_types,

1290: minus
1291: select
1292: ame_approver_types.approver_type_id,
1293: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1294: from ame_approver_types,
1295: ame_approver_type_usages
1296: where
1297: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1298: ame_approver_type_usages.action_type_id = actionTypeIdIn and

Line 1297: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and

1293: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1294: from ame_approver_types,
1295: ame_approver_type_usages
1296: where
1297: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1298: ame_approver_type_usages.action_type_id = actionTypeIdIn and
1299: sysdate between
1300: ame_approver_types.start_date and
1301: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and

Line 1300: ame_approver_types.start_date and

1296: where
1297: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1298: ame_approver_type_usages.action_type_id = actionTypeIdIn and
1299: sysdate between
1300: ame_approver_types.start_date and
1301: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
1302: sysdate between
1303: ame_approver_type_usages.start_date and
1304: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)

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

1297: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1298: ame_approver_type_usages.action_type_id = actionTypeIdIn and
1299: sysdate between
1300: ame_approver_types.start_date and
1301: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
1302: sysdate between
1303: ame_approver_type_usages.start_date and
1304: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)
1305: order by approver_type_name;