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_ADMIN_PKG dependencies on AME_ITEM_CLASSES

Line 336: from ame_item_classes

332: itemClassCount integer;
333: begin
334: select count(*)
335: into itemClassCount
336: from ame_item_classes
337: where
338: sysdate between start_date and
339: nvl(end_date - ame_util.oneSecond, sysdate);
340: return(itemClassCount);

Line 356: from ame_item_classes

352: itemId integer;
353: begin
354: select item_class_id
355: into itemId
356: from ame_item_classes
357: where
358: upper(name) = upper(itemClassNameIn) and
359: sysdate between start_date and
360: nvl(end_date - ame_util.oneSecond, sysdate);

Line 399: itemName ame_item_classes.name%type;

395: raise;
396: return(null);
397: end getItemClassIdQuery;
398: function getItemClassName(itemClassIdIn in integer) return varchar2 as
399: itemName ame_item_classes.name%type;
400: begin
401: select name
402: into itemName
403: from ame_item_classes

Line 403: from ame_item_classes

399: itemName ame_item_classes.name%type;
400: begin
401: select name
402: into itemName
403: from ame_item_classes
404: where
405: item_class_id = itemClassIdIn and
406: sysdate between start_date and
407: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 539: from ame_item_classes

535: stringStartDate varchar2(50);
536: begin
537: select start_date
538: into startDate
539: from ame_item_classes
540: where
541: item_class_id = itemClassIdIn and
542: sysdate between start_date and
543: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 585: select ame_item_classes.item_class_id

581: end getItemClassSublistMode;
582: function getSubordinateItemClassId(applicationIdIn in integer) return integer as
583: itemId integer;
584: begin
585: select ame_item_classes.item_class_id
586: into itemId
587: from ame_item_classes,
588: ame_item_class_usages
589: where

Line 587: from ame_item_classes,

583: itemId integer;
584: begin
585: select ame_item_classes.item_class_id
586: into itemId
587: from ame_item_classes,
588: ame_item_class_usages
589: where
590: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
591: ame_item_class_usages.application_id = applicationIdIn and

Line 590: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

586: into itemId
587: from ame_item_classes,
588: ame_item_class_usages
589: where
590: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
591: ame_item_class_usages.application_id = applicationIdIn and
592: ame_item_classes.name <> ame_util.headerItemClassName and
593: sysdate between ame_item_classes.start_date and
594: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

Line 592: ame_item_classes.name <> ame_util.headerItemClassName and

588: ame_item_class_usages
589: where
590: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
591: ame_item_class_usages.application_id = applicationIdIn and
592: ame_item_classes.name <> ame_util.headerItemClassName and
593: sysdate between ame_item_classes.start_date and
594: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
595: sysdate between ame_item_class_usages.start_date and
596: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

Line 593: sysdate between ame_item_classes.start_date and

589: where
590: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
591: ame_item_class_usages.application_id = applicationIdIn and
592: ame_item_classes.name <> ame_util.headerItemClassName and
593: sysdate between ame_item_classes.start_date and
594: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
595: sysdate between ame_item_class_usages.start_date and
596: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
597: return(itemId);

Line 594: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

590: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
591: ame_item_class_usages.application_id = applicationIdIn and
592: ame_item_classes.name <> ame_util.headerItemClassName and
593: sysdate between ame_item_classes.start_date and
594: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
595: sysdate between ame_item_class_usages.start_date and
596: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
597: return(itemId);
598: exception

Line 1087: from ame_item_classes

1083: tempCount integer;
1084: begin
1085: select count(*)
1086: into tempCount
1087: from ame_item_classes
1088: where
1089: upper(name) = upper(itemClassNameIn) and
1090: sysdate between start_date and
1091: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 1117: itemClassName ame_item_classes.name%type;

1113: errorMessage ame_util.longestStringType;
1114: itemClassId integer;
1115: itemClassCount integer;
1116: itemClassExistsException exception;
1117: itemClassName ame_item_classes.name%type;
1118: nameLengthException exception;
1119: processingDate date;
1120: tempCount integer;
1121: begin

Line 1133: from ame_item_classes

1129: */
1130: begin
1131: select item_class_id
1132: into itemClassId
1133: from ame_item_classes
1134: where
1135: (itemClassIdIn is null or item_class_id <> itemClassIdIn) and
1136: name = itemClassName and
1137: sysdate between start_date and

Line 1145: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_item_classes',

1141: end if;
1142: exception
1143: when no_data_found then null;
1144: end;
1145: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_item_classes',
1146: columnNameIn => 'name',
1147: argumentIn => itemClassName)) then
1148: raise nameLengthException;
1149: end if;

Line 1161: from ame_item_classes

1157: if(itemClassIdIn is null) then
1158: createdBy := currentUserId;
1159: select count(*)
1160: into itemClassCount
1161: from ame_item_classes
1162: where
1163: sysdate between start_date and
1164: nvl(end_date - ame_util.oneSecond, sysdate);
1165: /* new id */

Line 1171: from ame_item_classes

1167: else
1168: itemClassId := itemClassIdIn;
1169: select count(*)
1170: into tempCount
1171: from ame_item_classes
1172: where
1173: item_class_id = itemClassId and
1174: created_by = ame_util.seededDataCreatedById;
1175: if(tempCount > 0) then

Line 1181: insert into ame_item_classes(item_class_id,

1177: else
1178: createdBy := currentUserId;
1179: end if;
1180: end if;
1181: insert into ame_item_classes(item_class_id,
1182: name,
1183: created_by,
1184: creation_date,
1185: last_updated_by,

Line 1224: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_item_classes',

1220: errorMessage :=
1221: ame_util.getMessage(applicationShortNameIn => 'PER',
1222: messageNameIn => 'AME_400375_ADM IC_NAME_LONG',
1223: tokenNameOneIn => 'COLUMN_LENGTH',
1224: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_item_classes',
1225: columnNameIn => 'name'));
1226: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1227: routineNameIn => 'newItemClass',
1228: exceptionNumberIn => errorCode,

Line 1277: from ame_item_classes,

1273: itemClassCount integer;
1274: begin
1275: select count(*)
1276: into itemClassCount
1277: from ame_item_classes,
1278: ame_item_class_usages
1279: where
1280: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1281: ame_item_class_usages.application_id = applicationIdIn and

Line 1280: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

1276: into itemClassCount
1277: from ame_item_classes,
1278: ame_item_class_usages
1279: where
1280: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1281: ame_item_class_usages.application_id = applicationIdIn and
1282: ame_item_classes.name <> ame_util.headerItemClassName and
1283: sysdate between ame_item_classes.start_date and
1284: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

Line 1282: ame_item_classes.name <> ame_util.headerItemClassName and

1278: ame_item_class_usages
1279: where
1280: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1281: ame_item_class_usages.application_id = applicationIdIn and
1282: ame_item_classes.name <> ame_util.headerItemClassName and
1283: sysdate between ame_item_classes.start_date and
1284: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
1285: sysdate between ame_item_class_usages.start_date and
1286: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

Line 1283: sysdate between ame_item_classes.start_date and

1279: where
1280: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1281: ame_item_class_usages.application_id = applicationIdIn and
1282: ame_item_classes.name <> ame_util.headerItemClassName and
1283: sysdate between ame_item_classes.start_date and
1284: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
1285: sysdate between ame_item_class_usages.start_date and
1286: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
1287: return(itemClassCount);

Line 1284: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

1280: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1281: ame_item_class_usages.application_id = applicationIdIn and
1282: ame_item_classes.name <> ame_util.headerItemClassName and
1283: sysdate between ame_item_classes.start_date and
1284: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
1285: sysdate between ame_item_class_usages.start_date and
1286: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
1287: return(itemClassCount);
1288: exception

Line 1873: update ame_item_classes

1869: itemClassId integer;
1870: currentUserId integer;
1871: begin
1872: currentUserId := ame_util.getCurrentUserId;
1873: update ame_item_classes
1874: set
1875: last_updated_by = currentUserId,
1876: last_update_date = endDateIn,
1877: last_update_login = currentUserId,

Line 1915: from ame_item_classes

1911: childVersionStartDateIn in date,
1912: finalizeIn in boolean default false) as
1913: cursor startDateCursor is
1914: select start_date
1915: from ame_item_classes
1916: where
1917: item_class_id = itemClassIdIn and
1918: sysdate between start_date and
1919: nvl(end_date - ame_util.oneSecond, sysdate)

Line 1963: ame_item_classes,

1959: /* Check whether the input values match the existing values; if so, just return. */
1960: select count(*)
1961: into tempCount
1962: from
1963: ame_item_classes,
1964: ame_item_class_usages
1965: where
1966: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1967: ame_item_classes.item_class_id = itemClassIdIn and

Line 1966: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

1962: from
1963: ame_item_classes,
1964: ame_item_class_usages
1965: where
1966: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1967: ame_item_classes.item_class_id = itemClassIdIn and
1968: ame_item_class_usages.application_id = applicationIdIn and
1969: ame_item_class_usages.item_id_query = itemClassIdQueryIn and
1970: ame_item_class_usages.item_class_par_mode = itemClassParModeIn and

Line 1967: ame_item_classes.item_class_id = itemClassIdIn and

1963: ame_item_classes,
1964: ame_item_class_usages
1965: where
1966: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
1967: ame_item_classes.item_class_id = itemClassIdIn and
1968: ame_item_class_usages.application_id = applicationIdIn and
1969: ame_item_class_usages.item_id_query = itemClassIdQueryIn and
1970: ame_item_class_usages.item_class_par_mode = itemClassParModeIn and
1971: ame_item_class_usages.item_class_sublist_mode = itemClassSublistModeIn and

Line 1973: sysdate between ame_item_classes.start_date and

1969: ame_item_class_usages.item_id_query = itemClassIdQueryIn and
1970: ame_item_class_usages.item_class_par_mode = itemClassParModeIn and
1971: ame_item_class_usages.item_class_sublist_mode = itemClassSublistModeIn and
1972: ame_item_class_usages.item_class_order_number = orderNumberIn and
1973: sysdate between ame_item_classes.start_date and
1974: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
1975: sysdate between ame_item_class_usages.start_date and
1976: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) ;
1977: if(tempCount > 0) then

Line 1974: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

1970: ame_item_class_usages.item_class_par_mode = itemClassParModeIn and
1971: ame_item_class_usages.item_class_sublist_mode = itemClassSublistModeIn and
1972: ame_item_class_usages.item_class_order_number = orderNumberIn and
1973: sysdate between ame_item_classes.start_date and
1974: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
1975: sysdate between ame_item_class_usages.start_date and
1976: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) ;
1977: if(tempCount > 0) then
1978: return;

Line 2871: ame_item_classes

2867: select
2868: item_class_id,
2869: name
2870: from
2871: ame_item_classes
2872: where
2873: (start_date <= sysdate and
2874: (end_date is null or sysdate < end_date))
2875: minus

Line 2877: ame_item_classes.item_class_id,

2873: (start_date <= sysdate and
2874: (end_date is null or sysdate < end_date))
2875: minus
2876: select
2877: ame_item_classes.item_class_id,
2878: name
2879: from
2880: ame_item_classes,
2881: ame_item_class_usages

Line 2880: ame_item_classes,

2876: select
2877: ame_item_classes.item_class_id,
2878: name
2879: from
2880: ame_item_classes,
2881: ame_item_class_usages
2882: where
2883: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2884: ame_item_class_usages.application_id = applicationIdIn and

Line 2883: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

2879: from
2880: ame_item_classes,
2881: ame_item_class_usages
2882: where
2883: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2884: ame_item_class_usages.application_id = applicationIdIn and
2885: sysdate between ame_item_classes.start_date and
2886: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2887: sysdate between ame_item_class_usages.start_date and

Line 2885: sysdate between ame_item_classes.start_date and

2881: ame_item_class_usages
2882: where
2883: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2884: ame_item_class_usages.application_id = applicationIdIn and
2885: sysdate between ame_item_classes.start_date and
2886: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2887: sysdate between ame_item_class_usages.start_date and
2888: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
2889: order by name;

Line 2886: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

2882: where
2883: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2884: ame_item_class_usages.application_id = applicationIdIn and
2885: sysdate between ame_item_classes.start_date and
2886: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2887: sysdate between ame_item_class_usages.start_date and
2888: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
2889: order by name;
2890: tempIndex integer;

Line 2984: select ame_item_classes.item_class_id,

2980: itemClassIdListOut out nocopy ame_util.idList,
2981: itemClassNameListOut out nocopy ame_util.stringList,
2982: itemClassOrderNumbersOut out nocopy ame_util.idList) as
2983: cursor itemClassCursor(applicationIdIn in integer) is
2984: select ame_item_classes.item_class_id,
2985: ame_item_classes.name,
2986: ame_item_class_usages.item_class_order_number
2987: from ame_item_classes,
2988: ame_item_class_usages

Line 2985: ame_item_classes.name,

2981: itemClassNameListOut out nocopy ame_util.stringList,
2982: itemClassOrderNumbersOut out nocopy ame_util.idList) as
2983: cursor itemClassCursor(applicationIdIn in integer) is
2984: select ame_item_classes.item_class_id,
2985: ame_item_classes.name,
2986: ame_item_class_usages.item_class_order_number
2987: from ame_item_classes,
2988: ame_item_class_usages
2989: where

Line 2987: from ame_item_classes,

2983: cursor itemClassCursor(applicationIdIn in integer) is
2984: select ame_item_classes.item_class_id,
2985: ame_item_classes.name,
2986: ame_item_class_usages.item_class_order_number
2987: from ame_item_classes,
2988: ame_item_class_usages
2989: where
2990: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2991: ame_item_class_usages.application_id = applicationIdIn and

Line 2990: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

2986: ame_item_class_usages.item_class_order_number
2987: from ame_item_classes,
2988: ame_item_class_usages
2989: where
2990: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2991: ame_item_class_usages.application_id = applicationIdIn and
2992: sysdate between ame_item_classes.start_date and
2993: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2994: sysdate between ame_item_class_usages.start_date and

Line 2992: sysdate between ame_item_classes.start_date and

2988: ame_item_class_usages
2989: where
2990: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2991: ame_item_class_usages.application_id = applicationIdIn and
2992: sysdate between ame_item_classes.start_date and
2993: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2994: sysdate between ame_item_class_usages.start_date and
2995: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
2996: order by ame_item_class_usages.item_class_order_number;

Line 2993: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

2989: where
2990: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2991: ame_item_class_usages.application_id = applicationIdIn and
2992: sysdate between ame_item_classes.start_date and
2993: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2994: sysdate between ame_item_class_usages.start_date and
2995: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
2996: order by ame_item_class_usages.item_class_order_number;
2997: tempIndex integer;

Line 3716: select ame_item_classes.item_class_id,

3712: procedure getTransTypeItemClasses(applicationIdIn in integer,
3713: itemClassIdsOut out nocopy ame_util.stringList,
3714: itemClassNamesOut out nocopy ame_util.stringList) as
3715: cursor getItemClassesCursor(applicationIdIn in integer) is
3716: select ame_item_classes.item_class_id,
3717: ame_item_classes.name
3718: from ame_item_classes,
3719: ame_item_class_usages
3720: where

Line 3717: ame_item_classes.name

3713: itemClassIdsOut out nocopy ame_util.stringList,
3714: itemClassNamesOut out nocopy ame_util.stringList) as
3715: cursor getItemClassesCursor(applicationIdIn in integer) is
3716: select ame_item_classes.item_class_id,
3717: ame_item_classes.name
3718: from ame_item_classes,
3719: ame_item_class_usages
3720: where
3721: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

Line 3718: from ame_item_classes,

3714: itemClassNamesOut out nocopy ame_util.stringList) as
3715: cursor getItemClassesCursor(applicationIdIn in integer) is
3716: select ame_item_classes.item_class_id,
3717: ame_item_classes.name
3718: from ame_item_classes,
3719: ame_item_class_usages
3720: where
3721: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3722: ame_item_class_usages.application_id = applicationIdIn and

Line 3721: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

3717: ame_item_classes.name
3718: from ame_item_classes,
3719: ame_item_class_usages
3720: where
3721: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3722: ame_item_class_usages.application_id = applicationIdIn and
3723: sysdate between ame_item_classes.start_date and
3724: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3725: sysdate between ame_item_class_usages.start_date and

Line 3723: sysdate between ame_item_classes.start_date and

3719: ame_item_class_usages
3720: where
3721: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3722: ame_item_class_usages.application_id = applicationIdIn and
3723: sysdate between ame_item_classes.start_date and
3724: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3725: sysdate between ame_item_class_usages.start_date and
3726: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3727: order by ame_item_class_usages.item_class_order_number;

Line 3724: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

3720: where
3721: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3722: ame_item_class_usages.application_id = applicationIdIn and
3723: sysdate between ame_item_classes.start_date and
3724: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3725: sysdate between ame_item_class_usages.start_date and
3726: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3727: order by ame_item_class_usages.item_class_order_number;
3728: begin

Line 3749: select ame_item_classes.item_class_id,

3745: procedure getTransTypeItemClasses2(applicationIdIn in integer,
3746: itemClassIdsOut out nocopy ame_util.idList,
3747: itemClassNamesOut out nocopy ame_util.stringList) as
3748: cursor getItemClassesCursor(applicationIdIn in integer) is
3749: select ame_item_classes.item_class_id,
3750: ame_item_classes.name
3751: from ame_item_classes,
3752: ame_item_class_usages
3753: where

Line 3750: ame_item_classes.name

3746: itemClassIdsOut out nocopy ame_util.idList,
3747: itemClassNamesOut out nocopy ame_util.stringList) as
3748: cursor getItemClassesCursor(applicationIdIn in integer) is
3749: select ame_item_classes.item_class_id,
3750: ame_item_classes.name
3751: from ame_item_classes,
3752: ame_item_class_usages
3753: where
3754: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

Line 3751: from ame_item_classes,

3747: itemClassNamesOut out nocopy ame_util.stringList) as
3748: cursor getItemClassesCursor(applicationIdIn in integer) is
3749: select ame_item_classes.item_class_id,
3750: ame_item_classes.name
3751: from ame_item_classes,
3752: ame_item_class_usages
3753: where
3754: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3755: ame_item_class_usages.application_id = applicationIdIn and

Line 3754: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

3750: ame_item_classes.name
3751: from ame_item_classes,
3752: ame_item_class_usages
3753: where
3754: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3755: ame_item_class_usages.application_id = applicationIdIn and
3756: ame_item_classes.name <> ame_util.headerItemClassName and
3757: sysdate between ame_item_classes.start_date and
3758: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

Line 3756: ame_item_classes.name <> ame_util.headerItemClassName and

3752: ame_item_class_usages
3753: where
3754: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3755: ame_item_class_usages.application_id = applicationIdIn and
3756: ame_item_classes.name <> ame_util.headerItemClassName and
3757: sysdate between ame_item_classes.start_date and
3758: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3759: sysdate between ame_item_class_usages.start_date and
3760: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 3757: sysdate between ame_item_classes.start_date and

3753: where
3754: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3755: ame_item_class_usages.application_id = applicationIdIn and
3756: ame_item_classes.name <> ame_util.headerItemClassName and
3757: sysdate between ame_item_classes.start_date and
3758: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3759: sysdate between ame_item_class_usages.start_date and
3760: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3761: order by ame_item_class_usages.item_class_order_number;

Line 3758: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

3754: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3755: ame_item_class_usages.application_id = applicationIdIn and
3756: ame_item_classes.name <> ame_util.headerItemClassName and
3757: sysdate between ame_item_classes.start_date and
3758: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3759: sysdate between ame_item_class_usages.start_date and
3760: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3761: order by ame_item_class_usages.item_class_order_number;
3762: begin

Line 3783: select ame_item_classes.item_class_id,

3779: procedure getTransTypeItemClasses3(applicationIdIn in integer,
3780: itemClassIdsOut out nocopy ame_util.idList,
3781: itemClassNamesOut out nocopy ame_util.stringList) as
3782: cursor getItemClassesCursor(applicationIdIn in integer) is
3783: select ame_item_classes.item_class_id,
3784: ame_item_classes.name
3785: from ame_item_classes,
3786: ame_item_class_usages
3787: where

Line 3784: ame_item_classes.name

3780: itemClassIdsOut out nocopy ame_util.idList,
3781: itemClassNamesOut out nocopy ame_util.stringList) as
3782: cursor getItemClassesCursor(applicationIdIn in integer) is
3783: select ame_item_classes.item_class_id,
3784: ame_item_classes.name
3785: from ame_item_classes,
3786: ame_item_class_usages
3787: where
3788: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

Line 3785: from ame_item_classes,

3781: itemClassNamesOut out nocopy ame_util.stringList) as
3782: cursor getItemClassesCursor(applicationIdIn in integer) is
3783: select ame_item_classes.item_class_id,
3784: ame_item_classes.name
3785: from ame_item_classes,
3786: ame_item_class_usages
3787: where
3788: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3789: ame_item_class_usages.application_id = applicationIdIn and

Line 3788: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

3784: ame_item_classes.name
3785: from ame_item_classes,
3786: ame_item_class_usages
3787: where
3788: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3789: ame_item_class_usages.application_id = applicationIdIn and
3790: sysdate between ame_item_classes.start_date and
3791: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3792: sysdate between ame_item_class_usages.start_date and

Line 3790: sysdate between ame_item_classes.start_date and

3786: ame_item_class_usages
3787: where
3788: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3789: ame_item_class_usages.application_id = applicationIdIn and
3790: sysdate between ame_item_classes.start_date and
3791: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3792: sysdate between ame_item_class_usages.start_date and
3793: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3794: order by ame_item_class_usages.item_class_order_number,

Line 3791: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

3787: where
3788: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3789: ame_item_class_usages.application_id = applicationIdIn and
3790: sysdate between ame_item_classes.start_date and
3791: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3792: sysdate between ame_item_class_usages.start_date and
3793: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3794: order by ame_item_class_usages.item_class_order_number,
3795: ame_item_classes.name;

Line 3795: ame_item_classes.name;

3791: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3792: sysdate between ame_item_class_usages.start_date and
3793: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3794: order by ame_item_class_usages.item_class_order_number,
3795: ame_item_classes.name;
3796: begin
3797: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3798: fetch getItemClassesCursor bulk collect
3799: into itemClassIdsOut,

Line 3817: select ame_item_classes.item_class_id,

3813: procedure getTransTypeItemClasses4(applicationIdIn in integer,
3814: itemClassIdsOut out nocopy ame_util.stringList,
3815: itemClassNamesOut out nocopy ame_util.stringList) as
3816: cursor getItemClassesCursor(applicationIdIn in integer) is
3817: select ame_item_classes.item_class_id,
3818: ame_item_classes.name
3819: from ame_item_classes,
3820: ame_item_class_usages
3821: where

Line 3818: ame_item_classes.name

3814: itemClassIdsOut out nocopy ame_util.stringList,
3815: itemClassNamesOut out nocopy ame_util.stringList) as
3816: cursor getItemClassesCursor(applicationIdIn in integer) is
3817: select ame_item_classes.item_class_id,
3818: ame_item_classes.name
3819: from ame_item_classes,
3820: ame_item_class_usages
3821: where
3822: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

Line 3819: from ame_item_classes,

3815: itemClassNamesOut out nocopy ame_util.stringList) as
3816: cursor getItemClassesCursor(applicationIdIn in integer) is
3817: select ame_item_classes.item_class_id,
3818: ame_item_classes.name
3819: from ame_item_classes,
3820: ame_item_class_usages
3821: where
3822: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3823: ame_item_class_usages.application_id = applicationIdIn and

Line 3822: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

3818: ame_item_classes.name
3819: from ame_item_classes,
3820: ame_item_class_usages
3821: where
3822: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3823: ame_item_class_usages.application_id = applicationIdIn and
3824: ame_item_classes.name <> ame_util.headerItemClassName and
3825: sysdate between ame_item_classes.start_date and
3826: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

Line 3824: ame_item_classes.name <> ame_util.headerItemClassName and

3820: ame_item_class_usages
3821: where
3822: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3823: ame_item_class_usages.application_id = applicationIdIn and
3824: ame_item_classes.name <> ame_util.headerItemClassName and
3825: sysdate between ame_item_classes.start_date and
3826: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3827: sysdate between ame_item_class_usages.start_date and
3828: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 3825: sysdate between ame_item_classes.start_date and

3821: where
3822: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3823: ame_item_class_usages.application_id = applicationIdIn and
3824: ame_item_classes.name <> ame_util.headerItemClassName and
3825: sysdate between ame_item_classes.start_date and
3826: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3827: sysdate between ame_item_class_usages.start_date and
3828: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3829: order by ame_item_class_usages.item_class_order_number;

Line 3826: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

3822: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3823: ame_item_class_usages.application_id = applicationIdIn and
3824: ame_item_classes.name <> ame_util.headerItemClassName and
3825: sysdate between ame_item_classes.start_date and
3826: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3827: sysdate between ame_item_class_usages.start_date and
3828: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3829: order by ame_item_class_usages.item_class_order_number;
3830: begin

Line 3850: select ame_item_classes.item_class_id

3846: end getTransTypeItemClasses4;
3847: procedure getTransTypeItemClassIds(applicationIdIn in integer,
3848: itemClassIdsOut out nocopy ame_util.idList) as
3849: cursor getItemClassesCursor(applicationIdIn in integer) is
3850: select ame_item_classes.item_class_id
3851: from ame_item_classes,
3852: ame_item_class_usages
3853: where
3854: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

Line 3851: from ame_item_classes,

3847: procedure getTransTypeItemClassIds(applicationIdIn in integer,
3848: itemClassIdsOut out nocopy ame_util.idList) as
3849: cursor getItemClassesCursor(applicationIdIn in integer) is
3850: select ame_item_classes.item_class_id
3851: from ame_item_classes,
3852: ame_item_class_usages
3853: where
3854: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3855: ame_item_class_usages.application_id = applicationIdIn and

Line 3854: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

3850: select ame_item_classes.item_class_id
3851: from ame_item_classes,
3852: ame_item_class_usages
3853: where
3854: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3855: ame_item_class_usages.application_id = applicationIdIn and
3856: sysdate between ame_item_classes.start_date and
3857: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3858: sysdate between ame_item_class_usages.start_date and

Line 3856: sysdate between ame_item_classes.start_date and

3852: ame_item_class_usages
3853: where
3854: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3855: ame_item_class_usages.application_id = applicationIdIn and
3856: sysdate between ame_item_classes.start_date and
3857: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3858: sysdate between ame_item_class_usages.start_date and
3859: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3860: order by ame_item_class_usages.item_class_order_number;

Line 3857: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

3853: where
3854: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
3855: ame_item_class_usages.application_id = applicationIdIn and
3856: sysdate between ame_item_classes.start_date and
3857: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
3858: sysdate between ame_item_class_usages.start_date and
3859: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
3860: order by ame_item_class_usages.item_class_order_number;
3861: begin

Line 4165: from ame_item_classes

4161: finalizeIn in boolean default false,
4162: parentVersionStartDateIn in date default null) as
4163: cursor startDateCursor is
4164: select start_date
4165: from ame_item_classes
4166: where
4167: item_class_id = itemClassIdIn and
4168: (start_date <= sysdate and
4169: (end_date is null or sysdate < end_date))

Line 4181: name ame_item_classes.name%type;

4177: itemId integer;
4178: itemIdQuery ame_item_class_usages.item_id_query%type;
4179: lastUpdatedBy integer;
4180: maxOrderNumber integer;
4181: name ame_item_classes.name%type;
4182: nullQueryStringException exception;
4183: objectVersionNoDataException exception;
4184: orderNumber integer;
4185: startDate date;

Line 4307: update ame_item_classes

4303: if(finalizeIn) then
4304: if(updateParentObjectIn) then
4305: name := getItemClassName(itemClassIdIn => itemClassIdIn);
4306: endDate := newStartDateIn;
4307: update ame_item_classes
4308: set
4309: last_updated_by = currentUserId,
4310: last_update_date = endDate,
4311: last_update_login = currentUserId,

Line 5148: from ame_item_classes

5144: applicationIdIn in integer,
5145: finalizeIn in boolean default false) as
5146: cursor startDateCursor is
5147: select start_date
5148: from ame_item_classes
5149: where
5150: item_class_id = itemClassIdIn and
5151: sysdate between start_date and
5152: nvl(end_date - ame_util.oneSecond, sysdate)

Line 5169: itemClassName ame_item_classes.name%type;

5165: errorMessage ame_util.longestStringType;
5166: icUsageDeletionException exception;
5167: inUseException exception;
5168: itemClassId integer;
5169: itemClassName ame_item_classes.name%type;
5170: objectVersionNoDataException exception;
5171: orderNumber integer;
5172: startDate date;
5173: startDate2 date;

Line 5230: update ame_item_classes

5226: application_id = applicationIdIn and
5227: processingDate between start_date and
5228: nvl(end_date - ame_util.oneSecond, processingDate);
5229: itemClassName := ame_admin_pkg.getItemClassName(itemClassIdIn => itemClassIdIn);
5230: update ame_item_classes
5231: set
5232: last_updated_by = currentUserId,
5233: last_update_date = processingDate,
5234: last_update_login = currentUserId,