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_CLASS_USAGES

Line 29: ame_item_class_usages

25: begin
26: select item_id_query
27: into itemIdQuery
28: from
29: ame_item_class_usages
30: where
31: application_id = applicationIdIn and
32: item_class_id = itemClassIdIn and
33: sysdate between start_date and

Line 56: from ame_item_class_usages

52: stringStartDate varchar2(50);
53: begin
54: select start_date
55: into startDate
56: from ame_item_class_usages
57: where
58: item_class_id = itemClassIdIn and
59: application_id = applicationIdIn and
60: sysdate between start_date and

Line 381: from ame_item_class_usages

377: itemIdQuery ame_util.longestStringType;
378: begin
379: select item_id_query
380: into itemIdQuery
381: from ame_item_class_usages
382: where
383: item_class_id = itemClassIdIn and
384: application_id = applicationIdIn and
385: sysdate between start_date and

Line 450: from ame_item_class_usages

446: orderNumber integer;
447: begin
448: select nvl(max(item_class_order_number), 0)
449: into orderNumber
450: from ame_item_class_usages
451: where
452: application_id = applicationIdIn and
453: sysdate between start_date and
454: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 472: from ame_item_class_usages

468: itemClassOrderNumber integer;
469: begin
470: select item_class_order_number
471: into itemClassOrderNumber
472: from ame_item_class_usages
473: where
474: item_class_id = itemClassIdIn and
475: application_id = applicationIdIn and
476: sysdate between start_date and

Line 494: from ame_item_class_usages

490: tempCount integer;
491: begin
492: select count(*)
493: into tempCount
494: from ame_item_class_usages
495: where
496: application_id = applicationIdIn and
497: sysdate between start_date and
498: nvl(end_date - ame_util.oneSecond, sysdate);

Line 516: from ame_item_class_usages

512: itemClassParMode ame_util.charType;
513: begin
514: select item_class_par_mode
515: into itemClassParMode
516: from ame_item_class_usages
517: where
518: item_class_id = itemClassIdIn and
519: application_id = applicationIdIn and
520: sysdate between start_date and

Line 565: from ame_item_class_usages

561: itemClassSubListMode ame_util.charType;
562: begin
563: select item_class_sublist_mode
564: into itemClassSublistMode
565: from ame_item_class_usages
566: where
567: item_class_id = itemClassIdIn and
568: application_id = applicationIdIn and
569: sysdate between start_date and

Line 588: ame_item_class_usages

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
592: ame_item_classes.name <> ame_util.headerItemClassName 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 591: ame_item_class_usages.application_id = applicationIdIn and

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
595: sysdate between ame_item_class_usages.start_date and

Line 595: sysdate between ame_item_class_usages.start_date 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
599: when others then

Line 596: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

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
599: when others then
600: rollback;

Line 898: from ame_item_class_usages

894: useCount integer;
895: begin
896: select count(*)
897: into useCount
898: from ame_item_class_usages
899: where
900: item_class_id = itemClassIdIn and
901: application_id = applicationIdIn and
902: sysdate between start_date and

Line 1251: from ame_item_class_usages

1247: tempCount integer;
1248: begin
1249: select count(*)
1250: into tempCount
1251: from ame_item_class_usages
1252: where
1253: application_id = applicationIdIn and
1254: item_class_order_number = orderNumberIn and
1255: sysdate between start_date and

Line 1278: ame_item_class_usages

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
1282: ame_item_classes.name <> ame_util.headerItemClassName 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 1281: ame_item_class_usages.application_id = applicationIdIn and

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
1285: sysdate between ame_item_class_usages.start_date and

Line 1285: sysdate between ame_item_class_usages.start_date 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
1289: when others then

Line 1286: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

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
1289: when others then
1290: rollback;

Line 1923: from ame_item_class_usages

1919: nvl(end_date - ame_util.oneSecond, sysdate)
1920: for update;
1921: cursor startDateCursor2 is
1922: select start_date
1923: from ame_item_class_usages
1924: where
1925: item_class_id = itemClassIdIn and
1926: application_id = applicationIdIn and
1927: sysdate between start_date and

Line 1964: ame_item_class_usages

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
1968: ame_item_class_usages.application_id = applicationIdIn 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 1968: ame_item_class_usages.application_id = applicationIdIn and

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
1972: ame_item_class_usages.item_class_order_number = orderNumberIn and

Line 1969: ame_item_class_usages.item_id_query = itemClassIdQueryIn and

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
1972: ame_item_class_usages.item_class_order_number = orderNumberIn and
1973: sysdate between ame_item_classes.start_date and

Line 1970: ame_item_class_usages.item_class_par_mode = itemClassParModeIn and

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
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

Line 1971: ame_item_class_usages.item_class_sublist_mode = itemClassSublistModeIn 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
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

Line 1972: ame_item_class_usages.item_class_order_number = orderNumberIn 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
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) ;

Line 1975: sysdate between ame_item_class_usages.start_date 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;
1979: end if;

Line 1976: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) ;

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;
1979: end if;
1980: /* Get current values as necessary for update. */

Line 2103: update ame_item_class_usages

2099: else /* The order number is not unique. */
2100: raise orderNumberException;
2101: end if;
2102: else
2103: update ame_item_class_usages
2104: set
2105: last_updated_by = currentUserId,
2106: last_update_date = endDate,
2107: last_update_login = currentUserId,

Line 2130: insert into ame_item_class_usages(application_id,

2126: incrementItemClassOrderNumbers(applicationIdIn => applicationIdIn,
2127: itemClassIdIn => itemClassIdIn,
2128: orderNumberIn => newOrderNumber);
2129: end if;
2130: insert into ame_item_class_usages(application_id,
2131: item_class_id,
2132: item_id_query,
2133: item_class_order_number,
2134: item_class_par_mode,

Line 2158: update ame_item_class_usages

2154: newStartDate,
2155: null);
2156: end if;
2157: if(updateOnlyICModified) then
2158: update ame_item_class_usages
2159: set
2160: last_updated_by = currentUserId,
2161: last_update_date = endDate,
2162: last_update_login = currentUserId,

Line 2169: insert into ame_item_class_usages(application_id,

2165: application_id = applicationIdIn and
2166: item_class_id = itemClassIdIn and
2167: sysdate between start_date and
2168: nvl(end_date - ame_util.oneSecond, sysdate);
2169: insert into ame_item_class_usages(application_id,
2170: item_class_id,
2171: item_id_query,
2172: item_class_order_number,
2173: item_class_par_mode,

Line 2432: from ame_item_class_usages

2428: orderNumberIn in integer,
2429: finalizeIn in boolean default false) as
2430: cursor orderNumberCursor is
2431: select item_class_id, item_class_order_number
2432: from ame_item_class_usages
2433: where
2434: application_id = applicationIdIn and
2435: item_class_order_number > orderNumberIn and
2436: sysdate between start_date and

Line 2441: itemClassIdQuery ame_item_class_usages.item_id_query%type;

2437: nvl(end_date - ame_util.oneSecond, sysdate)
2438: order by item_class_order_number;
2439: currentUserId integer;
2440: itemClassIds ame_util.idList;
2441: itemClassIdQuery ame_item_class_usages.item_id_query%type;
2442: itemClassParMode ame_item_class_usages.item_class_par_mode%type;
2443: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;
2444: orderNumbers ame_util.idList;
2445: processingDate date;

Line 2442: itemClassParMode ame_item_class_usages.item_class_par_mode%type;

2438: order by item_class_order_number;
2439: currentUserId integer;
2440: itemClassIds ame_util.idList;
2441: itemClassIdQuery ame_item_class_usages.item_id_query%type;
2442: itemClassParMode ame_item_class_usages.item_class_par_mode%type;
2443: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;
2444: orderNumbers ame_util.idList;
2445: processingDate date;
2446: votingRegime ame_util.charType;

Line 2443: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;

2439: currentUserId integer;
2440: itemClassIds ame_util.idList;
2441: itemClassIdQuery ame_item_class_usages.item_id_query%type;
2442: itemClassParMode ame_item_class_usages.item_class_par_mode%type;
2443: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;
2444: orderNumbers ame_util.idList;
2445: processingDate date;
2446: votingRegime ame_util.charType;
2447: begin

Line 2461: update ame_item_class_usages

2457: itemClassParMode := getItemClassParMode(itemClassIdIn => itemClassIds(i),
2458: applicationIdIn => applicationIdIn);
2459: itemClassSublistMode := getItemClassSublistMode(itemClassIdIn => itemClassIds(i),
2460: applicationIdIn => applicationIdIn);
2461: update ame_item_class_usages
2462: set
2463: last_updated_by = currentUserId,
2464: last_update_date = processingDate,
2465: last_update_login = currentUserId,

Line 2472: insert into ame_item_class_usages(application_id,

2468: application_id = applicationIdIn and
2469: item_class_id = itemClassIds(i) and
2470: sysdate between start_date and
2471: nvl(end_date - ame_util.oneSecond, sysdate);
2472: insert into ame_item_class_usages(application_id,
2473: item_class_id,
2474: item_id_query,
2475: item_class_order_number,
2476: item_class_par_mode,

Line 2881: ame_item_class_usages

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
2885: sysdate between ame_item_classes.start_date 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 2884: ame_item_class_usages.application_id = applicationIdIn and

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
2888: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 2887: sysdate between ame_item_class_usages.start_date and

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;
2891: begin

Line 2888: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

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;
2891: begin
2892: tempIndex := 1;

Line 2986: ame_item_class_usages.item_class_order_number

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
2990: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

Line 2988: ame_item_class_usages

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
2992: sysdate between ame_item_classes.start_date 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 2991: ame_item_class_usages.application_id = applicationIdIn and

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
2995: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 2994: sysdate between ame_item_class_usages.start_date and

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;
2998: begin

Line 2995: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

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;
2998: begin
2999: tempIndex := 1;

Line 2996: order by ame_item_class_usages.item_class_order_number;

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;
2998: begin
2999: tempIndex := 1;
3000: for tempItemClass in itemClassCursor(applicationIdIn => applicationIdIn) loop

Line 3719: ame_item_class_usages

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
3723: sysdate between ame_item_classes.start_date 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 3722: ame_item_class_usages.application_id = applicationIdIn and

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
3726: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 3725: sysdate between ame_item_class_usages.start_date and

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
3729: open getItemClassesCursor(applicationIdIn => applicationIdIn);

Line 3726: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

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
3729: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3730: fetch getItemClassesCursor bulk collect

Line 3727: order by ame_item_class_usages.item_class_order_number;

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
3729: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3730: fetch getItemClassesCursor bulk collect
3731: into itemClassIdsOut,

Line 3752: ame_item_class_usages

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
3756: ame_item_classes.name <> ame_util.headerItemClassName 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 3755: ame_item_class_usages.application_id = applicationIdIn and

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
3759: sysdate between ame_item_class_usages.start_date and

Line 3759: sysdate between ame_item_class_usages.start_date 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
3763: open getItemClassesCursor(applicationIdIn => applicationIdIn);

Line 3760: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

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
3763: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3764: fetch getItemClassesCursor bulk collect

Line 3761: order by ame_item_class_usages.item_class_order_number;

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
3763: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3764: fetch getItemClassesCursor bulk collect
3765: into itemClassIdsOut,

Line 3786: ame_item_class_usages

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
3790: sysdate between ame_item_classes.start_date 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 3789: ame_item_class_usages.application_id = applicationIdIn and

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
3793: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 3792: sysdate between ame_item_class_usages.start_date and

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;
3796: begin

Line 3793: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

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;
3796: begin
3797: open getItemClassesCursor(applicationIdIn => applicationIdIn);

Line 3794: order by ame_item_class_usages.item_class_order_number,

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;
3796: begin
3797: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3798: fetch getItemClassesCursor bulk collect

Line 3820: ame_item_class_usages

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
3824: ame_item_classes.name <> ame_util.headerItemClassName 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 3823: ame_item_class_usages.application_id = applicationIdIn and

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
3827: sysdate between ame_item_class_usages.start_date and

Line 3827: sysdate between ame_item_class_usages.start_date 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
3831: open getItemClassesCursor(applicationIdIn => applicationIdIn);

Line 3828: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

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
3831: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3832: fetch getItemClassesCursor bulk collect

Line 3829: order by ame_item_class_usages.item_class_order_number;

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
3831: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3832: fetch getItemClassesCursor bulk collect
3833: into itemClassIdsOut,

Line 3852: ame_item_class_usages

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
3856: sysdate between ame_item_classes.start_date 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 3855: ame_item_class_usages.application_id = applicationIdIn and

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
3859: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 3858: sysdate between ame_item_class_usages.start_date and

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
3862: open getItemClassesCursor(applicationIdIn => applicationIdIn);

Line 3859: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

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
3862: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3863: fetch getItemClassesCursor bulk collect

Line 3860: order by ame_item_class_usages.item_class_order_number;

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
3862: open getItemClassesCursor(applicationIdIn => applicationIdIn);
3863: fetch getItemClassesCursor bulk collect
3864: into itemClassIdsOut;

Line 4071: from ame_item_class_usages

4067: cursor orderNumberCursor(applicationIdIn in integer,
4068: itemClassIdIn in integer,
4069: orderNumberIn in integer) is
4070: select item_class_id, item_class_order_number
4071: from ame_item_class_usages
4072: where
4073: application_id = applicationIdIn and
4074: item_class_id <> itemClassIdIn and
4075: item_class_order_number >= orderNumberIn and

Line 4081: itemClassIdQuery ame_item_class_usages.item_id_query%type;

4077: nvl(end_date - ame_util.oneSecond, sysdate)
4078: order by item_class_order_number;
4079: currentUserId integer;
4080: itemClassIds ame_util.idList;
4081: itemClassIdQuery ame_item_class_usages.item_id_query%type;
4082: itemClassParMode ame_item_class_usages.item_class_par_mode%type;
4083: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;
4084: orderNumbers ame_util.idList;
4085: processingDate date;

Line 4082: itemClassParMode ame_item_class_usages.item_class_par_mode%type;

4078: order by item_class_order_number;
4079: currentUserId integer;
4080: itemClassIds ame_util.idList;
4081: itemClassIdQuery ame_item_class_usages.item_id_query%type;
4082: itemClassParMode ame_item_class_usages.item_class_par_mode%type;
4083: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;
4084: orderNumbers ame_util.idList;
4085: processingDate date;
4086: begin

Line 4083: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;

4079: currentUserId integer;
4080: itemClassIds ame_util.idList;
4081: itemClassIdQuery ame_item_class_usages.item_id_query%type;
4082: itemClassParMode ame_item_class_usages.item_class_par_mode%type;
4083: itemClassSublistMode ame_item_class_usages.item_class_sublist_mode%type;
4084: orderNumbers ame_util.idList;
4085: processingDate date;
4086: begin
4087: currentUserId := ame_util.getCurrentUserId;

Line 4102: update ame_item_class_usages

4098: itemClassParMode := getItemClassParMode(itemClassIdIn => itemClassIds(i),
4099: applicationIdIn => applicationIdIn);
4100: itemClassSublistMode := getItemClassSublistMode(itemClassIdIn => itemClassIds(i),
4101: applicationIdIn => applicationIdIn);
4102: update ame_item_class_usages
4103: set
4104: last_updated_by = currentUserId,
4105: last_update_date = processingDate,
4106: last_update_login = currentUserId,

Line 4113: insert into ame_item_class_usages(application_id,

4109: application_id = applicationIdIn and
4110: item_class_id = itemClassIds(i) and
4111: sysdate between start_date and
4112: nvl(end_date - ame_util.oneSecond, sysdate);
4113: insert into ame_item_class_usages(application_id,
4114: item_class_id,
4115: item_id_query,
4116: item_class_order_number,
4117: item_class_par_mode,

Line 4178: itemIdQuery ame_item_class_usages.item_id_query%type;

4174: endDate date;
4175: errorCode integer;
4176: errorMessage ame_util.longestStringType;
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;

Line 4192: upperItemIdQuery ame_item_class_usages.item_id_query%type;

4188: tempCount2 integer;
4189: tempInt integer;
4190: transIdPlaceholderPosition integer;
4191: transIdPlaceholderPosition2 integer;
4192: upperItemIdQuery ame_item_class_usages.item_id_query%type;
4193: upperTransIdPlaceholder ame_util.stringType;
4194: usageExistsException exception;
4195: begin
4196: if(finalizeIn) then

Line 4242: from ame_item_class_usages

4238: tempInt := tempInt + 1;
4239: end loop;
4240: select count(*)
4241: into tempCount
4242: from ame_item_class_usages
4243: where
4244: item_class_id = itemClassIdIn and
4245: application_id = applicationIdIn and
4246: (start_date <= sysdate and

Line 4254: from ame_item_class_usages

4250: end if;
4251: currentUserId := ame_util.getCurrentUserId;
4252: select count(*)
4253: into tempCount2
4254: from ame_item_class_usages
4255: where
4256: item_class_id = itemClassIdIn and
4257: application_id = applicationIdIn and
4258: created_by = ame_util.seededDataCreatedById;

Line 4270: insert into ame_item_class_usages(application_id,

4266: if(createdBy = -1 )then
4267: lastUpdatedBy := ame_util.seededDataCreatedById;
4268: createdBy := ame_util.seededDataCreatedById;
4269: end if;
4270: insert into ame_item_class_usages(application_id,
4271: item_class_id,
4272: item_id_query,
4273: item_class_order_number,
4274: item_class_par_mode,

Line 5156: from ame_item_class_usages

5152: nvl(end_date - ame_util.oneSecond, sysdate)
5153: for update;
5154: cursor startDateCursor2 is
5155: select start_date
5156: from ame_item_class_usages
5157: where
5158: item_class_id = itemClassIdIn and
5159: application_id = applicationIdIn and
5160: sysdate between start_date and

Line 5205: from ame_item_class_usages

5201: raise icUsageDeletionException;
5202: end if;
5203: select item_class_order_number
5204: into orderNumber
5205: from ame_item_class_usages
5206: where
5207: application_id = applicationIdIn and
5208: item_class_id = itemClassIdIn and
5209: sysdate between start_date and

Line 5218: update ame_item_class_usages

5214: decrementItemClassOrderNumbers(applicationIdIn => applicationIdIn,
5215: orderNumberIn => orderNumber,
5216: finalizeIn => false);
5217: end if;
5218: update ame_item_class_usages
5219: set
5220: last_updated_by = currentUserId,
5221: last_update_date = processingDate,
5222: last_update_login = currentUserId,

Line 5422: update ame_item_class_usages

5418: where
5419: application_id = applicationIdIn and
5420: processingDate between start_date and
5421: nvl(end_date - ame_util.oneSecond, processingDate);
5422: update ame_item_class_usages
5423: set
5424: last_updated_by = currentUserId,
5425: last_update_date = processingDate,
5426: last_update_login = currentUserId,