APPS.AME_MULTI_TENANCY_PKG dependencies on AME_ITEM_CLASS_USAGES

Line 169: update ame_item_class_usages

165: set created_by = getSeedUser
166: ,last_updated_by = getSeedUser
167: where application_id = g_ent_appl_id;
168: --
169: update ame_item_class_usages
170: set created_by = getSeedUser
171: ,last_updated_by = getSeedUser
172: where application_id = g_ent_appl_id
173: and item_class_id =

Line 294: from ame_item_class_usages

290: l_proc_name varchar2(100);
291: --
292: cursor chkExists(c_item_class_id in number) is
293: select count(*)
294: from ame_item_class_usages
295: where item_class_id = c_item_class_id
296: and application_id = g_ent_appl_id
297: and sysdate between start_date and nvl(end_date,sysdate);
298: --

Line 305: from ame_item_class_usages ent

301: ,seed.item_id_query
302: ,seed.item_class_order_number
303: ,seed.item_class_par_mode
304: ,seed.item_class_sublist_mode
305: from ame_item_class_usages ent
306: ,ame_item_class_usages seed
307: where ent.item_class_id = c_item_class_id
308: and seed.item_class_id = c_item_class_id
309: and seed.application_id = g_seed_appl_id

Line 306: ,ame_item_class_usages seed

302: ,seed.item_class_order_number
303: ,seed.item_class_par_mode
304: ,seed.item_class_sublist_mode
305: from ame_item_class_usages ent
306: ,ame_item_class_usages seed
307: where ent.item_class_id = c_item_class_id
308: and seed.item_class_id = c_item_class_id
309: and seed.application_id = g_seed_appl_id
310: and ent.application_id = g_ent_appl_id

Line 346: update ame_item_class_usages

342: ,p_object_version_number => l_ovn
343: ,p_start_date => l_start_date
344: ,p_end_date => l_end_date
345: );
346: update ame_item_class_usages
347: set created_by = getSeedUser
348: ,last_updated_by = getSeedUser
349: where application_id = g_ent_appl_id
350: and item_class_id = l_item_class_id

Line 369: update ame_item_class_usages

365: ,p_object_version_number => l_ovn
366: ,p_start_date => l_start_date
367: ,p_end_date => l_end_date
368: );
369: update ame_item_class_usages
370: set created_by = getSeedUser
371: ,last_updated_by = getSeedUser
372: where application_id = g_ent_appl_id
373: and item_class_id = l_item_class_id

Line 1364: from ame_item_class_usages

1360: --+
1361: logMessage(l_proc_name,'Reading Item Class Usage data');
1362: open seed_row for
1363: select *
1364: from ame_item_class_usages
1365: where application_id = g_seed_appl_id
1366: and sysdate between start_date and nvl(end_Date,sysdate);
1367: fetch seed_row bulk collect into g_seed_ic_usg;
1368: close seed_row;