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 464: approverTypeId ame_approver_types.approver_type_id%type;

460: raise;
461: return(null);
462: end getApproverOrigSystemId;
463: function getApproverTypeId(origSystemIn in varchar2) return integer as
464: approverTypeId ame_approver_types.approver_type_id%type;
465: begin
466: select approver_type_id
467: into approverTypeId
468: from ame_approver_types

Line 468: from ame_approver_types

464: approverTypeId ame_approver_types.approver_type_id%type;
465: begin
466: select approver_type_id
467: into approverTypeId
468: from ame_approver_types
469: where
470: orig_system = origSystemIn and
471: sysdate between
472: start_date and

Line 486: origSystem ame_approver_types.orig_system%type;

482: raise;
483: return(null);
484: end getApproverTypeId;
485: function getApproverTypeOrigSystem(approverTypeIdIn in integer) return varchar2 as
486: origSystem ame_approver_types.orig_system%type;
487: begin
488: select orig_system
489: into origSystem
490: from ame_approver_types

Line 490: from ame_approver_types

486: origSystem ame_approver_types.orig_system%type;
487: begin
488: select orig_system
489: into origSystem
490: from ame_approver_types
491: where
492: approver_type_id = approverTypeIdIn and
493: sysdate between
494: start_date and

Line 508: origSystem ame_approver_types.orig_system%type;

504: raise;
505: return(null);
506: end getApproverTypeOrigSystem;
507: function getApproverTypeDisplayName(approverTypeIdIn in integer) return varchar2 as
508: origSystem ame_approver_types.orig_system%type;
509: begin
510: select orig_system
511: into origSystem
512: from ame_approver_types

Line 512: from ame_approver_types

508: origSystem ame_approver_types.orig_system%type;
509: begin
510: select orig_system
511: into origSystem
512: from ame_approver_types
513: where
514: approver_type_id = approverTypeIdIn and
515: sysdate between start_date and
516: nvl(end_date - ame_util.oneSecond, sysdate) and

Line 552: queryProcedure ame_approver_types.query_procedure%type;

548: raise;
549: return(null);
550: end getOrigSystemDisplayName;
551: function getQueryProcedure(approverTypeIdIn in integer) return varchar2 as
552: queryProcedure ame_approver_types.query_procedure%type;
553: begin
554: select query_procedure
555: into queryProcedure
556: from ame_approver_types

Line 556: from ame_approver_types

552: queryProcedure ame_approver_types.query_procedure%type;
553: begin
554: select query_procedure
555: into queryProcedure
556: from ame_approver_types
557: where
558: approver_type_id = approverTypeIdIn and
559: sysdate between
560: start_date and

Line 1233: from ame_approver_types

1229: variableLovQueries(2),
1230: variableLovQueries(3),
1231: variableLovQueries(4),
1232: variableLovQueries(5)
1233: from ame_approver_types
1234: where
1235: approver_type_id = approverTypeIdIn and
1236: sysdate between
1237: start_date and

Line 1267: from ame_approver_types

1263: cursor getApproverTypeDataCursor is
1264: select
1265: approver_type_id,
1266: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1267: from ame_approver_types
1268: where sysdate between
1269: start_date and
1270: nvl(end_date - ame_util.oneSecond, sysdate);
1271: cursor getApproverTypeDataCursor2 is

Line 1275: from ame_approver_types

1271: cursor getApproverTypeDataCursor2 is
1272: select
1273: approver_type_id,
1274: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1275: from ame_approver_types
1276: where
1277: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
1278: sysdate between
1279: start_date and

Line 1330: from ame_approver_types

1326: cursor unusedApproverTypeCursor is
1327: select
1328: approver_type_id,
1329: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1330: from ame_approver_types
1331: where sysdate between
1332: start_date and
1333: nvl(end_date - ame_util.oneSecond, sysdate)
1334: minus

Line 1336: ame_approver_types.approver_type_id,

1332: start_date and
1333: nvl(end_date - ame_util.oneSecond, sysdate)
1334: minus
1335: select
1336: ame_approver_types.approver_type_id,
1337: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1338: from ame_approver_types,
1339: ame_approver_type_usages
1340: where

Line 1338: from ame_approver_types,

1334: minus
1335: select
1336: ame_approver_types.approver_type_id,
1337: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1338: from ame_approver_types,
1339: ame_approver_type_usages
1340: where
1341: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1342: ame_approver_type_usages.action_type_id = actionTypeIdIn and

Line 1341: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and

1337: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1338: from ame_approver_types,
1339: ame_approver_type_usages
1340: where
1341: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1342: ame_approver_type_usages.action_type_id = actionTypeIdIn and
1343: sysdate between
1344: ame_approver_types.start_date and
1345: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and

Line 1344: ame_approver_types.start_date and

1340: where
1341: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1342: ame_approver_type_usages.action_type_id = actionTypeIdIn and
1343: sysdate between
1344: ame_approver_types.start_date and
1345: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
1346: sysdate between
1347: ame_approver_type_usages.start_date and
1348: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)

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

1341: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
1342: ame_approver_type_usages.action_type_id = actionTypeIdIn and
1343: sysdate between
1344: ame_approver_types.start_date and
1345: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
1346: sysdate between
1347: ame_approver_type_usages.start_date and
1348: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)
1349: order by approver_type_name;