9: ameAppId integer;
10: invalidItemClassException exception;
11: cursor chkItemClass is
12: select name
13: from ame_item_classes
14: where item_class_id = itemClassIdIn
15: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
16: item_class_name ame_item_classes.name%type;
17: errorCode integer;
12: select name
13: from ame_item_classes
14: where item_class_id = itemClassIdIn
15: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
16: item_class_name ame_item_classes.name%type;
17: errorCode integer;
18: errorMessage ame_util.longestStringType;
19: begin
20: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
85: ameAppId integer;
86: invalidItemClassException exception;
87: cursor chkItemClass is
88: select item_class_id
89: from ame_item_classes
90: where name = itemClassNameIn
91: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
92: item_class_id ame_item_classes.item_class_id%type;
93: errorCode integer;
88: select item_class_id
89: from ame_item_classes
90: where name = itemClassNameIn
91: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
92: item_class_id ame_item_classes.item_class_id%type;
93: errorCode integer;
94: errorMessage ame_util.longestStringType;
95: begin
96: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,