DBA Data[Home] [Help]

APPS.AME_API5 dependencies on AME_ITEM_CLASSES

Line 13: from ame_item_classes

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;

Line 16: item_class_name ame_item_classes.name%type;

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,

Line 89: from ame_item_classes

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;

Line 92: item_class_id ame_item_classes.item_class_id%type;

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,