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_ITEMS

Line 10: ame_approval_group_items entries with that effective date. (This enables a bug

6: groups, down to the first dynamic group in each nesting recursion. When a
7: dynamic group is encountered, its query string is copied into queryStringOut.
8: If the target group itself is dynamic, its query string is copied into
9: queryStringOut. If effectiveDateIn is not null, setGroupMembers uses the
10: ame_approval_group_items entries with that effective date. (This enables a bug
11: fix in amem0015.sql.)
12: */
13: procedure getNestedMembers(groupIdIn in integer,
14: effectiveDateIn in date default null,

Line 61: from ame_approval_group_items

57: orderNumber integer;
58: begin
59: select nvl(max(order_number), 0)
60: into orderNumber
61: from ame_approval_group_items
62: where
63: approval_group_id = approvalGroupIdIn and
64: sysdate between start_date and
65: nvl(end_date - ame_util.oneSecond, sysdate);

Line 180: from ame_approval_group_items

176: approvalGroupId integer;
177: begin
178: select approval_group_id
179: into approvalGroupId
180: from ame_approval_group_items
181: where
182: approval_group_item_id = approvalGroupItemIdIn and
183: sysdate between start_date and
184: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 207: from ame_approval_group_items

203: itemId integer;
204: begin
205: select approval_group_item_id
206: into itemId
207: from ame_approval_group_items
208: where
209: upper(parameter) = upper(parameterIn) and
210: (upper(parameter_name) = upper(parameterNameIn)) and
211: sysdate between start_date and

Line 229: parameter ame_approval_group_items.parameter%type;

225: raise;
226: return(null);
227: end getItemId;
228: function getItemParameter(approvalGroupItemIdIn in integer) return varchar2 as
229: parameter ame_approval_group_items.parameter%type;
230: begin
231: select parameter
232: into parameter
233: from ame_approval_group_items

Line 233: from ame_approval_group_items

229: parameter ame_approval_group_items.parameter%type;
230: begin
231: select parameter
232: into parameter
233: from ame_approval_group_items
234: where
235: approval_group_item_id = approvalGroupItemIdIn and
236: sysdate between start_date and
237: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 254: parameterName ame_approval_group_items.parameter_name%type;

250: raise;
251: return(null);
252: end getItemParameter;
253: function getItemParameterName(approvalGroupItemIdIn in integer) return varchar2 as
254: parameterName ame_approval_group_items.parameter_name%type;
255: begin
256: select parameter_name
257: into parameterName
258: from ame_approval_group_items

Line 258: from ame_approval_group_items

254: parameterName ame_approval_group_items.parameter_name%type;
255: begin
256: select parameter_name
257: into parameterName
258: from ame_approval_group_items
259: where
260: approval_group_item_id = approvalGroupItemIdIn and
261: sysdate between start_date and
262: nvl(end_date - ame_util.oneSecond, sysdate);

Line 433: orderNumber ame_approval_group_items.order_number%type;

429: raise;
430: return(null);
431: end getParentVersionStartDate;
432: function getItemOrderNumber(approvalGroupItemIdIn in integer) return integer as
433: orderNumber ame_approval_group_items.order_number%type;
434: begin
435: select order_number
436: into orderNumber
437: from ame_approval_group_items

Line 437: from ame_approval_group_items

433: orderNumber ame_approval_group_items.order_number%type;
434: begin
435: select order_number
436: into orderNumber
437: from ame_approval_group_items
438: where
439: approval_group_item_id = approvalGroupItemIdIn and
440: sysdate between start_date and
441: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 463: from ame_approval_group_items

459: orderCount integer;
460: begin
461: select count(*)
462: into orderCount
463: from ame_approval_group_items
464: where
465: approval_group_id = approvalGroupIdIn and
466: sysdate between start_date and
467: nvl(end_date - ame_util.oneSecond, sysdate);

Line 518: from ame_approval_group_items

514: cursor groupMemberCursor(approvalGroupIdIn in integer) is
515: select
516: parameter,
517: parameter_name
518: from ame_approval_group_items
519: where
520: approval_group_id = approvalGroupIdIn and
521: sysdate between start_date and
522: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 720: from ame_approval_group_items

716: tempCount integer;
717: begin
718: select count(*)
719: into tempCount
720: from ame_approval_group_items
721: where
722: approval_group_id = approvalGroupIdIn and
723: order_number = orderNumberIn and
724: sysdate between start_date and

Line 998: parameter ame_approval_group_items.parameter%type;

994: newOrderNumber integer;
995: objectVersionNoDataException exception;
996: oldOrderNumberUnique ame_util.stringType;
997: orderNumberException exception;
998: parameter ame_approval_group_items.parameter%type;
999: parameterLengthException exception;
1000: parameterName ame_approval_group_items.parameter_name%type;
1001: parameterNameLengthException exception;
1002: startDate date;

Line 1000: parameterName ame_approval_group_items.parameter_name%type;

996: oldOrderNumberUnique ame_util.stringType;
997: orderNumberException exception;
998: parameter ame_approval_group_items.parameter%type;
999: parameterLengthException exception;
1000: parameterName ame_approval_group_items.parameter_name%type;
1001: parameterNameLengthException exception;
1002: startDate date;
1003: tempCount integer;
1004: tempCount2 integer;

Line 1017: from ame_approval_group_items

1013: end if;
1014: /* error checking */
1015: select count(*)
1016: into tempCount
1017: from ame_approval_group_items
1018: where
1019: (approvalGroupItemIdIn is null or approval_group_item_id <> approvalGroupItemIdIn) and
1020: approval_group_id = approvalGroupIdIn and
1021: upper(parameter) = upper(parameterIn) and

Line 1028: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_group_items',

1024: nvl(end_date - ame_util.oneSecond, sysdate) ;
1025: if(tempCount > 0) then
1026: raise groupExistsException;
1027: end if;
1028: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_group_items',
1029: columnNameIn => 'parameter',
1030: argumentIn => parameterIn)) then
1031: raise parameterLengthException;
1032: end if;

Line 1033: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_group_items',

1029: columnNameIn => 'parameter',
1030: argumentIn => parameterIn)) then
1031: raise parameterLengthException;
1032: end if;
1033: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_group_items',
1034: columnNameIn => 'parameter_name',
1035: argumentIn => parameterNameIn)) then
1036: raise parameterNameLengthException;
1037: end if;

Line 1043: select ame_approval_group_items_s.nextval into approvalGroupItemId from dual;

1039: currentUserId := ame_util.getCurrentUserId;
1040: if parentVersionStartDateIn = startDate then
1041: if(approvalGroupItemIdIn is null) then
1042: createdBy := currentUserId;
1043: select ame_approval_group_items_s.nextval into approvalGroupItemId from dual;
1044: else
1045: approvalGroupItemId := approvalGroupItemIdIn;
1046: select count(*)
1047: into tempCount2

Line 1048: from ame_approval_group_items

1044: else
1045: approvalGroupItemId := approvalGroupItemIdIn;
1046: select count(*)
1047: into tempCount2
1048: from ame_approval_group_items
1049: where
1050: approval_group_item_id = approvalGroupItemId and
1051: created_by = ame_util.seededDataCreatedById;
1052: if(tempCount2 > 0) then

Line 1079: update ame_approval_group_items

1075: else /* The order number is not unique. */
1076: raise orderNumberException;
1077: end if;
1078: else
1079: update ame_approval_group_items
1080: set
1081: last_updated_by = currentUserId,
1082: last_update_date = newEndDateIn,
1083: last_update_login = currentUserId,

Line 1119: insert into ame_approval_group_items(approval_group_item_id,

1115: groupIsInGroup(groupIdIn => approvalGroupIdIn,
1116: possiblyNestedGroupIdIn => to_number(parameterIn)))) then
1117: raise badNestedGroupException;
1118: end if;
1119: insert into ame_approval_group_items(approval_group_item_id,
1120: approval_group_id,
1121: parameter_name,
1122: parameter,
1123: order_number,

Line 1149: update ame_approval_group_items

1145: updateOnlyGIModified := true;
1146: end if;
1147: if(updateOnlyGIModified) then
1148: if(approvalGroupItemIdIn is not null) then
1149: update ame_approval_group_items
1150: set
1151: last_updated_by = currentUserId,
1152: last_update_date = newEndDateIn,
1153: last_update_login = currentUserId,

Line 1174: insert into ame_approval_group_items(approval_group_item_id,

1170: groupIsInGroup(groupIdIn => approvalGroupIdIn,
1171: possiblyNestedGroupIdIn => to_number(parameterIn)))) then
1172: raise badNestedGroupException;
1173: end if;
1174: insert into ame_approval_group_items(approval_group_item_id,
1175: approval_group_id,
1176: parameter_name,
1177: parameter,
1178: order_number,

Line 1286: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_group_items',

1282: errorMessage :=
1283: ame_util.getMessage(applicationShortNameIn => 'PER',
1284: messageNameIn => 'AME_400201_APG_PAR_MEM_LONG',
1285: tokenNameOneIn => 'COLUMN_LENGTH',
1286: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_group_items',
1287: columnNameIn => 'parameter'));
1288: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1289: routineNameIn => 'newApprovalGroupItem',
1290: exceptionNumberIn => errorCode,

Line 1315: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_group_items',

1311: errorMessage :=
1312: ame_util.getMessage(applicationShortNameIn => 'PER',
1313: messageNameIn => 'AME_400203_APG_PAR_GRP_LONG',
1314: tokenNameOneIn => 'COLUMN_LENGTH',
1315: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_group_items',
1316: columnNameIn => 'parameter_name'));
1317: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1318: routineNameIn => 'newApprovalGroupItem',
1319: exceptionNumberIn => errorCode,

Line 1791: parameter ame_approval_group_items.parameter%type;

1787: groupQueryString ame_approval_groups.query_string%type;
1788: newStartDate date;
1789: objectVersionNoDataException exception;
1790: oldOrderNumber integer;
1791: parameter ame_approval_group_items.parameter%type;
1792: parameterName ame_approval_group_items.parameter_name%type;
1793: startDate date;
1794: processingDate date;
1795: tempCount integer;

Line 1792: parameterName ame_approval_group_items.parameter_name%type;

1788: newStartDate date;
1789: objectVersionNoDataException exception;
1790: oldOrderNumber integer;
1791: parameter ame_approval_group_items.parameter%type;
1792: parameterName ame_approval_group_items.parameter_name%type;
1793: startDate date;
1794: processingDate date;
1795: tempCount integer;
1796: begin

Line 1892: from ame_approval_group_items

1888: orderNumberIn in integer,
1889: finalizeIn in boolean default false) as
1890: cursor orderNumberCursor is
1891: select approval_group_item_id, order_number
1892: from ame_approval_group_items
1893: where
1894: approval_group_id = approvalGroupIdIn and
1895: order_number > orderNumberIn and
1896: sysdate between start_date and

Line 1901: parameter ame_approval_group_items.parameter%type;

1897: nvl(end_date - ame_util.oneSecond, sysdate)
1898: order by order_number;
1899: approvalGroupItemIds ame_util.idList;
1900: currentUserId integer;
1901: parameter ame_approval_group_items.parameter%type;
1902: parameterName ame_approval_group_items.parameter%type;
1903: processingDate date;
1904: orderNumbers ame_util.idList;
1905: votingRegime ame_util.charType;

Line 1902: parameterName ame_approval_group_items.parameter%type;

1898: order by order_number;
1899: approvalGroupItemIds ame_util.idList;
1900: currentUserId integer;
1901: parameter ame_approval_group_items.parameter%type;
1902: parameterName ame_approval_group_items.parameter%type;
1903: processingDate date;
1904: orderNumbers ame_util.idList;
1905: votingRegime ame_util.charType;
1906: begin

Line 1918: update ame_approval_group_items

1914: parameter :=
1915: getItemParameter(approvalGroupItemIdIn => approvalGroupItemIds(i));
1916: parameterName :=
1917: getItemParameterName(approvalGroupItemIdIn => approvalGroupItemIds(i));
1918: update ame_approval_group_items
1919: set
1920: last_updated_by = currentUserId,
1921: last_update_date = processingDate,
1922: last_update_login = currentUserId,

Line 1928: insert into ame_approval_group_items(approval_group_item_id,

1924: where
1925: approval_group_item_id = approvalGroupItemIds(i) and
1926: sysdate between start_date and
1927: nvl(end_date - ame_util.oneSecond, sysdate);
1928: insert into ame_approval_group_items(approval_group_item_id,
1929: approval_group_id,
1930: parameter_name,
1931: parameter,
1932: order_number,

Line 2091: from ame_approval_group_items

2087: descriptionListOut out nocopy ame_util.longStringList,
2088: invalidMembersOut out nocopy boolean) as
2089: cursor itemCursor(approvalGroupIdIn in integer) is
2090: select approval_group_item_id
2091: from ame_approval_group_items
2092: where
2093: approval_group_id = approvalGroupIdIn and
2094: sysdate between start_date and
2095: nvl(end_date - ame_util.oneSecond, sysdate)

Line 2103: tempParameter ame_approval_group_items.parameter%type;

2099: tempFirstName per_all_people_f.first_name%type;
2100: tempItemId integer;
2101: tempLastName per_all_people_f.last_name%type;
2102: tempName ame_approval_groups.name%type;
2103: tempParameter ame_approval_group_items.parameter%type;
2104: tempParameterName ame_approval_group_items.parameter_name%type;
2105: tempUserName fnd_user.user_name%type;
2106: tempRowNumber integer;
2107: approverDesc ame_util.longStringType;

Line 2104: tempParameterName ame_approval_group_items.parameter_name%type;

2100: tempItemId integer;
2101: tempLastName per_all_people_f.last_name%type;
2102: tempName ame_approval_groups.name%type;
2103: tempParameter ame_approval_group_items.parameter%type;
2104: tempParameterName ame_approval_group_items.parameter_name%type;
2105: tempUserName fnd_user.user_name%type;
2106: tempRowNumber integer;
2107: approverDesc ame_util.longStringType;
2108: approverValid boolean;

Line 2213: from ame_approval_group_items

2209: cursor groupMemberCursor(approvalGroupIdIn in integer) is
2210: select
2211: parameter,
2212: parameter_name
2213: from ame_approval_group_items
2214: where
2215: approval_group_id = approvalGroupIdIn and
2216: sysdate between start_date and
2217: nvl(end_date - ame_util.oneSecond, sysdate)

Line 2281: from ame_approval_group_items

2277: procedure getInvalidApprGroupItemList(approvalGroupIdIn in integer,
2278: itemListOut out nocopy ame_util.idList) as
2279: cursor itemCursor(approvalGroupIdIn in integer) is
2280: select approval_group_item_id, parameter
2281: from ame_approval_group_items
2282: where
2283: approval_group_id = approvalGroupIdIn and
2284: parameter_name <> ame_util.approverOamGroupId and
2285: sysdate between start_date and

Line 2290: tempParameter ame_approval_group_items.parameter%type;

2286: nvl(end_date - ame_util.oneSecond, sysdate)
2287: order by order_number;
2288: tempIndex integer;
2289: tempItemId integer;
2290: tempParameter ame_approval_group_items.parameter%type;
2291: begin
2292: tempIndex := 1;
2293: for tempItem in itemCursor(approvalGroupIdIn) loop
2294: tempItemId := tempItem.approval_group_item_id;

Line 2327: from ame_approval_group_items

2323: select
2324: parameter,
2325: parameter_name,
2326: order_number
2327: from ame_approval_group_items
2328: where
2329: approval_group_id = approvalGroupIdIn and
2330: effectiveDateIn between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
2331: order by order_number;

Line 2413: from ame_approval_group_items

2409: procedure getOrderNumbers(approvalGroupIdIn in integer,
2410: orderNumbersOut out nocopy ame_util.stringList) as
2411: cursor getOrderNumbersCursor(approvalGroupIdIn in integer) is
2412: select order_number
2413: from ame_approval_group_items
2414: where approval_group_id = approvalGroupIdIn and
2415: sysdate between start_date and
2416: nvl(end_date - ame_util.oneSecond, sysdate)
2417: order by order_number;

Line 2448: from ame_approval_group_items

2444: cursor orderNumberCursor(approvalGroupIdIn in integer,
2445: approvalGroupItemIdIn in integer,
2446: orderNumberIn in integer) is
2447: select approval_group_Item_id, order_number
2448: from ame_approval_group_items
2449: where
2450: approval_group_id = approvalGroupIdIn and
2451: approval_group_item_id <> approvalGroupItemIdIn and
2452: order_number >= orderNumberIn and

Line 2459: parameter ame_approval_group_items.parameter%type;

2455: order by order_number;
2456: approvalGroupItemIds ame_util.idList;
2457: currentUserId integer;
2458: orderNumbers ame_util.idList;
2459: parameter ame_approval_group_items.parameter%type;
2460: parameterName ame_approval_group_items.parameter_name%type;
2461: processingDate date;
2462: begin
2463: currentUserId := ame_util.getCurrentUserId;

Line 2460: parameterName ame_approval_group_items.parameter_name%type;

2456: approvalGroupItemIds ame_util.idList;
2457: currentUserId integer;
2458: orderNumbers ame_util.idList;
2459: parameter ame_approval_group_items.parameter%type;
2460: parameterName ame_approval_group_items.parameter_name%type;
2461: processingDate date;
2462: begin
2463: currentUserId := ame_util.getCurrentUserId;
2464: processingDate := sysdate;

Line 2474: update ame_approval_group_items

2470: close orderNumberCursor;
2471: for i in 1 .. approvalGroupItemIds.count loop
2472: parameter := getItemParameter(approvalGroupItemIdIn => approvalGroupItemIds(i));
2473: parameterName := getItemParameterName(approvalGroupItemIdIn => approvalGroupItemIds(i));
2474: update ame_approval_group_items
2475: set
2476: last_updated_by = currentUserId,
2477: last_update_date = processingDate,
2478: last_update_login = currentUserId,

Line 2484: insert into ame_approval_group_items(approval_group_item_id,

2480: where
2481: approval_group_item_id = approvalGroupItemIds(i) and
2482: sysdate between start_date and
2483: nvl(end_date - ame_util.oneSecond, sysdate);
2484: insert into ame_approval_group_items(approval_group_item_id,
2485: approval_group_id,
2486: parameter_name,
2487: parameter,
2488: order_number,

Line 2763: update ame_approval_group_items

2759: approval_group_id = approvalGroupIdIn and
2760: processingDate between start_date and
2761: nvl(end_date - ame_util.oneSecond, processingDate) ;
2762: /* End-date approval-group items. */
2763: update ame_approval_group_items
2764: set
2765: last_updated_by = currentUserId,
2766: last_update_date = processingDate,
2767: last_update_login = currentUserId,

Line 2878: from ame_approval_group_items

2874: nvl(end_date - ame_util.oneSecond, sysdate)
2875: for update;
2876: cursor orderCursor(approvalGroupIdIn in integer) is
2877: select order_number, approval_group_item_id
2878: from ame_approval_group_items
2879: where approval_group_id = approvalGroupIdIn and
2880: sysdate between start_date and
2881: nvl(end_date - ame_util.oneSecond, sysdate)
2882: for update of order_number

Line 2926: update ame_approval_group_items

2922: decrementGroupItemOrderNumbers(approvalGroupIdIn => approvalGroupIdIn,
2923: orderNumberIn => itemOrderNumber,
2924: finalizeIn => false);
2925: end if;
2926: update ame_approval_group_items
2927: set
2928: last_updated_by = currentUserId,
2929: last_update_date = processingDate,
2930: last_update_login = currentUserId,

Line 3117: from ame_approval_group_items

3113: procedure updateDependentGroups(groupIdIn in integer,
3114: deleteGroupIn in boolean default false) as
3115: cursor dependentGroupCursor(groupIdIn in integer) is
3116: select distinct approval_group_id
3117: from ame_approval_group_items
3118: where
3119: parameter_name = ame_util.approverOamGroupId and
3120: parameter = to_char(groupIdIn) and
3121: sysdate between start_date and

Line 3148: update ame_approval_group_items

3144: (Don't do it for currentGroup = 1 because the group is never a member of itself.)
3145: The call to setGroupMembers below updates ame_approval_group_members for dependent
3146: groups.
3147: */
3148: update ame_approval_group_items
3149: set end_date = processingDate
3150: where
3151: approval_group_id = groupsToUpdate(currentGroup) and
3152: parameter_name = ame_util.approverOamGroupId and