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_APPROVAL_GROUP_PKG dependencies on AME_APPROVAL_GROUP_CONFIG

Line 82: from ame_approval_group_config

78: orderNumber integer;
79: begin
80: select nvl(max(order_number), 0)
81: into orderNumber
82: from ame_approval_group_config
83: where
84: application_id = applicationIdIn and
85: sysdate between start_date and
86: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 104: from ame_approval_group_config

100: orderNumber integer;
101: begin
102: select order_number
103: into orderNumber
104: from ame_approval_group_config
105: where
106: approval_group_id = approvalGroupIdIn and
107: application_id = applicationIdIn and
108: sysdate between start_date and

Line 383: from ame_approval_group_config

379: stringStartDate varchar2(50);
380: begin
381: select start_date
382: into startDate
383: from ame_approval_group_config
384: where
385: approval_group_id = approvalGroupIdIn and
386: application_id = applicationIdIn and
387: sysdate between start_date and

Line 491: votingRegime ame_approval_group_config.voting_regime%type;

487: return(null);
488: end getOrderNumberCount;
489: function getVotingRegime(approvalGroupIdIn in integer,
490: applicationIdIn in integer) return varchar2 as
491: votingRegime ame_approval_group_config.voting_regime%type;
492: begin
493: select voting_regime
494: into votingRegime
495: from ame_approval_group_config

Line 495: from ame_approval_group_config

491: votingRegime ame_approval_group_config.voting_regime%type;
492: begin
493: select voting_regime
494: into votingRegime
495: from ame_approval_group_config
496: where
497: approval_group_id = approvalGroupIdIn and
498: application_id = applicationIdIn and
499: sysdate between start_date and

Line 612: ame_approval_group_config

608: select count(*)
609: into tempCount
610: from
611: ame_approval_groups,
612: ame_approval_group_config
613: where
614: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
615: ame_approval_groups.approval_group_id = approvalGroupIdIn and
616: ame_approval_group_config.application_id = applicationIdIn and

Line 614: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and

610: from
611: ame_approval_groups,
612: ame_approval_group_config
613: where
614: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
615: ame_approval_groups.approval_group_id = approvalGroupIdIn and
616: ame_approval_group_config.application_id = applicationIdIn and
617: ame_approval_group_config.voting_regime = votingRegimeIn and
618: ame_approval_group_config.order_number = orderNumberIn and

Line 616: ame_approval_group_config.application_id = applicationIdIn and

612: ame_approval_group_config
613: where
614: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
615: ame_approval_groups.approval_group_id = approvalGroupIdIn and
616: ame_approval_group_config.application_id = applicationIdIn and
617: ame_approval_group_config.voting_regime = votingRegimeIn and
618: ame_approval_group_config.order_number = orderNumberIn and
619: (nameIn is null or upper(name) = upper(nameIn)) and
620: (descriptionIn is null or upper(description) = upper(descriptionIn)) and

Line 617: ame_approval_group_config.voting_regime = votingRegimeIn and

613: where
614: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
615: ame_approval_groups.approval_group_id = approvalGroupIdIn and
616: ame_approval_group_config.application_id = applicationIdIn and
617: ame_approval_group_config.voting_regime = votingRegimeIn and
618: ame_approval_group_config.order_number = orderNumberIn and
619: (nameIn is null or upper(name) = upper(nameIn)) and
620: (descriptionIn is null or upper(description) = upper(descriptionIn)) and
621: is_static = isStaticIn and

Line 618: ame_approval_group_config.order_number = orderNumberIn and

614: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
615: ame_approval_groups.approval_group_id = approvalGroupIdIn and
616: ame_approval_group_config.application_id = applicationIdIn and
617: ame_approval_group_config.voting_regime = votingRegimeIn and
618: ame_approval_group_config.order_number = orderNumberIn and
619: (nameIn is null or upper(name) = upper(nameIn)) and
620: (descriptionIn is null or upper(description) = upper(descriptionIn)) and
621: is_static = isStaticIn and
622: (queryStringIn is null or upper(query_string) = upper(queryStringIn)) and

Line 625: sysdate between ame_approval_group_config.start_date and

621: is_static = isStaticIn and
622: (queryStringIn is null or upper(query_string) = upper(queryStringIn)) and
623: sysdate between ame_approval_groups.start_date and
624: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
625: sysdate between ame_approval_group_config.start_date and
626: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate);
627: if(tempCount = 0 or groupHasBeenUpdated) then
628: return(true);
629: else

Line 626: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate);

622: (queryStringIn is null or upper(query_string) = upper(queryStringIn)) and
623: sysdate between ame_approval_groups.start_date and
624: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
625: sysdate between ame_approval_group_config.start_date and
626: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate);
627: if(tempCount = 0 or groupHasBeenUpdated) then
628: return(true);
629: else
630: return(false);

Line 1363: from ame_approval_group_config

1359: tempCount integer;
1360: begin
1361: select count(*)
1362: into tempCount
1363: from ame_approval_group_config
1364: where
1365: application_id = applicationIdIn and
1366: order_number = orderNumberIn and
1367: sysdate between start_date and

Line 1461: from ame_approval_group_config

1457: nvl(end_date - ame_util.oneSecond, sysdate)
1458: for update;
1459: cursor startDateCursor2 is
1460: select start_date
1461: from ame_approval_group_config
1462: where
1463: approval_group_id = approvalGroupIdIn and
1464: application_id = applicationIdIn and
1465: sysdate between start_date and

Line 1645: update ame_approval_group_config

1641: else /* The order number is not unique. */
1642: raise orderNumberException;
1643: end if;
1644: else
1645: update ame_approval_group_config
1646: set
1647: last_updated_by = currentUserId,
1648: last_update_date = endDate,
1649: last_update_login = currentUserId,

Line 1672: insert into ame_approval_group_config(application_id,

1668: incrementGroupOrderNumbers(applicationIdIn => applicationIdIn,
1669: approvalGroupIdIn => approvalGroupIdIn,
1670: orderNumberIn => newOrderNumber);
1671: end if;
1672: insert into ame_approval_group_config(application_id,
1673: approval_group_id,
1674: voting_regime,
1675: order_number,
1676: created_by,

Line 1696: update ame_approval_group_config

1692: newStartDate,
1693: null);
1694: end if;
1695: if(updateOnlyAGModified) then
1696: update ame_approval_group_config
1697: set
1698: last_updated_by = currentUserId,
1699: last_update_date = endDate,
1700: last_update_login = currentUserId,

Line 1707: insert into ame_approval_group_config(application_id,

1703: application_id = applicationIdIn and
1704: approval_group_id = approvalGroupIdIn and
1705: sysdate between start_date and
1706: nvl(end_date - ame_util.oneSecond, sysdate);
1707: insert into ame_approval_group_config(application_id,
1708: approval_group_id,
1709: voting_regime,
1710: order_number,
1711: created_by,

Line 1970: from ame_approval_group_config

1966: orderNumberIn in integer,
1967: finalizeIn in boolean default false) as
1968: cursor orderNumberCursor is
1969: select approval_group_id, order_number
1970: from ame_approval_group_config
1971: where
1972: application_id = applicationIdIn and
1973: order_number > orderNumberIn and
1974: sysdate between start_date and

Line 1992: update ame_approval_group_config

1988: close orderNumberCursor;
1989: for i in 1 .. approvalGroupIds.count loop
1990: votingRegime := getVotingRegime(approvalGroupIdIn => approvalGroupIds(i),
1991: applicationIdIn => applicationIdIn);
1992: update ame_approval_group_config
1993: set
1994: last_updated_by = currentUserId,
1995: last_update_date = processingDate,
1996: last_update_login = currentUserId,

Line 2003: insert into ame_approval_group_config(application_id,

1999: application_id = applicationIdIn and
2000: approval_group_id = approvalGroupIds(i) and
2001: sysdate between start_date and
2002: nvl(end_date - ame_util.oneSecond, sysdate);
2003: insert into ame_approval_group_config(application_id,
2004: approval_group_id,
2005: voting_regime,
2006: order_number,
2007: created_by,

Line 2180: ame_approval_group_config

2176: groupListOut out nocopy ame_util.idList) as
2177: cursor groupCursor is
2178: select ame_approval_groups.approval_group_id
2179: from ame_approval_groups,
2180: ame_approval_group_config
2181: where
2182: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
2183: ame_approval_group_config.application_id = applicationIdIn and
2184: sysdate between ame_approval_groups.start_date and

Line 2182: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and

2178: select ame_approval_groups.approval_group_id
2179: from ame_approval_groups,
2180: ame_approval_group_config
2181: where
2182: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
2183: ame_approval_group_config.application_id = applicationIdIn and
2184: sysdate between ame_approval_groups.start_date and
2185: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
2186: sysdate between ame_approval_group_config.start_date and

Line 2183: ame_approval_group_config.application_id = applicationIdIn and

2179: from ame_approval_groups,
2180: ame_approval_group_config
2181: where
2182: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
2183: ame_approval_group_config.application_id = applicationIdIn and
2184: sysdate between ame_approval_groups.start_date and
2185: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
2186: sysdate between ame_approval_group_config.start_date and
2187: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate)

Line 2186: sysdate between ame_approval_group_config.start_date and

2182: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
2183: ame_approval_group_config.application_id = applicationIdIn and
2184: sysdate between ame_approval_groups.start_date and
2185: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
2186: sysdate between ame_approval_group_config.start_date and
2187: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate)
2188: order by ame_approval_group_config.order_number;
2189: tempIndex integer;
2190: begin

Line 2187: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate)

2183: ame_approval_group_config.application_id = applicationIdIn and
2184: sysdate between ame_approval_groups.start_date and
2185: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
2186: sysdate between ame_approval_group_config.start_date and
2187: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate)
2188: order by ame_approval_group_config.order_number;
2189: tempIndex integer;
2190: begin
2191: tempIndex := 1;

Line 2188: order by ame_approval_group_config.order_number;

2184: sysdate between ame_approval_groups.start_date and
2185: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
2186: sysdate between ame_approval_group_config.start_date and
2187: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate)
2188: order by ame_approval_group_config.order_number;
2189: tempIndex integer;
2190: begin
2191: tempIndex := 1;
2192: for tempGroup in groupCursor loop

Line 2527: from ame_approval_group_config

2523: orderNumberIn in integer,
2524: finalizeIn in boolean default false) as
2525: cursor orderNumberCursor is
2526: select approval_group_id, order_number
2527: from ame_approval_group_config
2528: where
2529: application_id = applicationIdIn and
2530: approval_group_id <> approvalGroupIdIn and
2531: order_number >= orderNumberIn and

Line 2550: update ame_approval_group_config

2546: close orderNumberCursor;
2547: for i in 1 .. approvalGroupIds.count loop
2548: votingRegime := getVotingRegime(approvalGroupIdIn => approvalGroupIds(i),
2549: applicationIdIn => applicationIdIn);
2550: update ame_approval_group_config
2551: set
2552: last_updated_by = currentUserId,
2553: last_update_date = processingDate,
2554: last_update_login = currentUserId,

Line 2561: insert into ame_approval_group_config(application_id,

2557: application_id = applicationIdIn and
2558: approval_group_id = approvalGroupIds(i) and
2559: sysdate between start_date and
2560: nvl(end_date - ame_util.oneSecond, sysdate);
2561: insert into ame_approval_group_config(application_id,
2562: approval_group_id,
2563: voting_regime,
2564: order_number,
2565: created_by,

Line 2613: orderNumber ame_approval_group_config.order_number%type;

2609: applicationId integer;
2610: applicationIds ame_util.idList;
2611: currentUserId integer;
2612: maxOrderNumber integer;
2613: orderNumber ame_approval_group_config.order_number%type;
2614: processingDate date;
2615: tempCount integer;
2616: begin
2617: currentUserId := ame_util.getCurrentUserId;

Line 2634: from ame_approval_group_config

2630: else
2631: applicationId := applicationIds(i);
2632: select count(*)
2633: into tempCount
2634: from ame_approval_group_config
2635: where
2636: application_id = applicationIds(i) and
2637: sysdate between start_date and
2638: nvl(end_date - ame_util.oneSecond, sysdate);

Line 2644: from ame_approval_group_config

2640: orderNumber := 1;
2641: else
2642: select (nvl(max(order_number), 0) + 1)
2643: into orderNumber
2644: from ame_approval_group_config
2645: where
2646: application_id = applicationIds(i) and
2647: sysdate between start_date and
2648: nvl(end_date - ame_util.oneSecond, sysdate);

Line 2651: insert into ame_approval_group_config(application_id,

2647: sysdate between start_date and
2648: nvl(end_date - ame_util.oneSecond, sysdate);
2649: end if;
2650: end if;
2651: insert into ame_approval_group_config(application_id,
2652: approval_group_id,
2653: voting_regime,
2654: order_number,
2655: created_by,

Line 2737: from ame_approval_group_config

2733: close applicationIdCursor;
2734: for i in 1 .. applicationIds.count loop
2735: select order_number
2736: into orderNumber
2737: from ame_approval_group_config
2738: where
2739: application_id = applicationIds(i) and
2740: approval_group_id = approvalGroupIdIn and
2741: sysdate between start_date and

Line 2774: update ame_approval_group_config

2770: approval_group_id = approvalGroupIdIn and
2771: processingDate between start_date and
2772: nvl(end_date - ame_util.oneSecond, processingDate);
2773: /* End-date the approval group configs */
2774: update ame_approval_group_config
2775: set
2776: last_updated_by = currentUserId,
2777: last_update_date = processingDate,
2778: last_update_login = currentUserId,