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_TYPE_USAGES

Line 653: from ame_approver_type_usages

649: rowCount integer;
650: begin
651: select count(*)
652: into rowCount
653: from ame_approver_type_usages
654: where
655: action_type_id = actionTypeIdIn and
656: approver_type_id = ame_util.anyApproverType and
657: sysdate between

Line 1163: ame_approver_type_usages

1159: cursor getApprovalTypeCursor is
1160: select name
1161: from
1162: ame_action_types,
1163: ame_approver_type_usages
1164: where
1165: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1166: approver_type_id = approverTypeIdIn and
1167: sysdate between ame_action_types.start_date and

Line 1165: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and

1161: from
1162: ame_action_types,
1163: ame_approver_type_usages
1164: where
1165: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1166: approver_type_id = approverTypeIdIn and
1167: sysdate between ame_action_types.start_date and
1168: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1169: sysdate between ame_approver_type_usages.start_date and

Line 1169: sysdate between ame_approver_type_usages.start_date and

1165: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1166: approver_type_id = approverTypeIdIn and
1167: sysdate between ame_action_types.start_date and
1168: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1169: sysdate between ame_approver_type_usages.start_date and
1170: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1171: cursor getApprovalTypeCursor2 is
1172: select name
1173: from

Line 1170: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);

1166: approver_type_id = approverTypeIdIn and
1167: sysdate between ame_action_types.start_date and
1168: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1169: sysdate between ame_approver_type_usages.start_date and
1170: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1171: cursor getApprovalTypeCursor2 is
1172: select name
1173: from
1174: ame_action_types,

Line 1175: ame_approver_type_usages

1171: cursor getApprovalTypeCursor2 is
1172: select name
1173: from
1174: ame_action_types,
1175: ame_approver_type_usages
1176: where
1177: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1178: approver_type_id = ame_util.anyApproverType and
1179: sysdate between ame_action_types.start_date and

Line 1177: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and

1173: from
1174: ame_action_types,
1175: ame_approver_type_usages
1176: where
1177: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1178: approver_type_id = ame_util.anyApproverType and
1179: sysdate between ame_action_types.start_date and
1180: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1181: sysdate between ame_approver_type_usages.start_date and

Line 1181: sysdate between ame_approver_type_usages.start_date and

1177: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1178: approver_type_id = ame_util.anyApproverType and
1179: sysdate between ame_action_types.start_date and
1180: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1181: sysdate between ame_approver_type_usages.start_date and
1182: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1183: tempIndex integer;
1184: begin
1185: tempIndex := 1;

Line 1182: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);

1178: approver_type_id = ame_util.anyApproverType and
1179: sysdate between ame_action_types.start_date and
1180: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1181: sysdate between ame_approver_type_usages.start_date and
1182: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1183: tempIndex integer;
1184: begin
1185: tempIndex := 1;
1186: for getApprovalTypeRec in getApprovalTypeCursor loop

Line 1339: ame_approver_type_usages

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
1343: sysdate between

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 1342: ame_approver_type_usages.action_type_id = actionTypeIdIn and

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
1346: sysdate between

Line 1347: ame_approver_type_usages.start_date 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;
1350: tempIndex integer;
1351: begin

Line 1348: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)

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;
1350: tempIndex integer;
1351: begin
1352: approverTypeIdsOut(1) := ame_util.anyApproverType;

Line 1376: from ame_approver_type_usages

1372: procedure getAvailableApproverTypes3(actionTypeIdIn in integer,
1373: approverTypeIdsOut out nocopy ame_util.idList) as
1374: cursor availableApproverTypesCursor(actionTypeIdIn in integer) is
1375: select approver_type_id
1376: from ame_approver_type_usages
1377: where
1378: action_type_id = actionTypeIdIn and
1379: approver_type_id <> ame_util.anyApproverType and
1380: sysdate between

Line 1927: insert into ame_approver_type_usages(approver_type_id,

1923: processingDateIn in date) as
1924: currentUserId integer;
1925: begin
1926: currentUserId := ame_util.getCurrentUserId;
1927: insert into ame_approver_type_usages(approver_type_id,
1928: action_type_id,
1929: created_by,
1930: creation_date,
1931: last_updated_by,

Line 2305: update ame_approver_type_usages

2301: inUseException exception;
2302: processingDate date;
2303: begin
2304: currentUserId := ame_util.getCurrentUserId;
2305: update ame_approver_type_usages
2306: set
2307: last_updated_by = currentUserId,
2308: last_update_date = processingDateIn,
2309: last_update_login = currentUserId,

Line 2337: ame_approver_type_usages */

2333: processingDate date;
2334: begin
2335: processingDate := sysdate;
2336: /* loop through approverTypeIdsIn and update/end date
2337: ame_approver_type_usages */
2338: for i in 1..approverTypeIdsIn.count loop
2339: removeApproverTypeUsage(actionTypeIdIn => actionTypeIdIn,
2340: approverTypeIdIn => approverTypeIdsIn(i),
2341: processingDateIn => processingDate);