APPS.AME_API dependencies on AME_ITEM_CLASS_USAGES

Line 56: from ame_item_class_usages

52: --+
53: cursor chkItemClassNonSerialPar(applicationIdIn in number,
54: itemClassIdIn in number) is
55: select 'Y'
56: from ame_item_class_usages
57: where application_id = applicationIdIn
58: and item_class_id = itemClassIdIn
59: and item_class_sublist_mode <> ame_util.serialSublists
60: and sysdate between start_date and

Line 66: from ame_item_class_usages

62: --+
63: cursor chkItemClassNonUniqueOrder(applicationIdIn in number) is
64: select 'Y'
65: from (select (count(item_class_order_number) - count(distinct item_class_order_number)) uniq
66: from ame_item_class_usages
67: where application_id = applicationIdIn
68: and sysdate between start_date and
69: nvl(end_date - ame_util.oneSecond, sysdate)
70: )

Line 160: --Check if parallelization is induced into ame_item_class_usages

156: begin
157: --+
158: ameApplicationId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,
159: transactionTypeIdIn => transactionTypeIn);
160: --Check if parallelization is induced into ame_item_class_usages
161: --by checking the columns item_class_sublist_mod for HEADER item class only.
162: --Do not check item_class_par_mode for header item class since it will always have 1 item.
163: --Do not check usages for other item classes since we throw error if allowAllItemClasses
164: --is true in one of the checks below.

Line 176: --Check if parallelization is induced into ame_item_class_usages

172: close chkItemClassNonSerialPar;
173: raise parallelizationFoundException;
174: end if;
175: close chkItemClassNonSerialPar;
176: --Check if parallelization is induced into ame_item_class_usages
177: --by ensuring that no two item classes have same order number.
178: --+
179: tempAMEObject := 'Item class non unique order number';
180: open chkItemClassNonUniqueOrder(applicationIdIn => ameApplicationId);