APPS.AME_MULTI_TENANCY_PKG dependencies on AME_ATTRIBUTE_USAGES

Line 180: update ame_attribute_usages

176: where name = ame_util.headerItemClassName
177: and sysdate between start_date and nvl(end_date,sysdate))
178: and sysdate between start_date and nvl(end_Date,sysdate);
179: --
180: update ame_attribute_usages
181: set created_by = getSeedUser
182: ,last_updated_by = getSeedUser
183: where application_id = g_ent_appl_id
184: and sysdate between start_date and nvl(end_Date,sysdate);

Line 393: from ame_attribute_usages

389: l_proc_name varchar2(100);
390: --
391: cursor getEnterpriseMandAttrUsageRow(c_attr_id number,c_is_static varchar2,c_query_string varchar2,c_value_set_id in number) is
392: select *
393: from ame_attribute_usages
394: where attribute_id = c_attr_id
395: and (is_static <> c_is_static or nvl(query_string,'PRASAD') <> nvl(c_query_string,'PRASAD') or
396: nvl(value_set_id,-1) <> NVL(c_value_set_id,-1))
397: and application_id = g_ent_appl_id

Line 424: update ame_attribute_usages

420: ,p_start_date => l_start_Date
421: ,p_end_date => l_end_Date
422: );
423: --
424: update ame_attribute_usages
425: set created_by = getSeedUser
426: ,last_updated_by = getSeedUser
427: where application_id = g_ent_appl_id
428: and attribute_id = g_seed_mand_attr_usg(i).attribute_id

Line 451: from ame_attribute_usages

447: l_attribute_id number;
448: --
449: cursor checkUsageExists(c_atr_id in number) is
450: select count(*)
451: from ame_attribute_usages
452: where application_id = g_ent_appl_id
453: and attribute_id = c_atr_id
454: and sysdate between start_date and nvl(end_Date,sysdate);
455: --

Line 459: from ame_attribute_usages ent

455: --
456: cursor getEnterpriseAtteUsageRow(c_atr_id in number,c_is_static varchar2,
457: c_query_string varchar2,c_value_set_id in number) is
458: select ent.object_version_number
459: from ame_attribute_usages ent
460: where ent.attribute_id = c_atr_id
461: and ent.application_id = g_ent_appl_id
462: and (ent.is_static <> c_is_static or nvl(ent.query_string,'PRASAD') <> nvl(c_query_string,'PRASAD'))
463: and sysdate between ent.start_date and nvl(ent.end_Date,sysdate)

Line 496: update ame_attribute_usages

492: ,p_start_date => l_start_date
493: ,p_end_date => l_end_Date
494: );
495: --
496: update ame_attribute_usages
497: set created_by = getSeedUser
498: ,last_updated_by = getSeedUser
499: where application_id = g_ent_appl_id
500: and attribute_id = l_attribute_id

Line 520: update ame_attribute_usages

516: ,p_start_date => l_start_date
517: ,p_end_date => l_end_Date
518: );
519: --
520: update ame_attribute_usages
521: set created_by = getSeedUser
522: ,last_updated_by = getSeedUser
523: where application_id = g_ent_appl_id
524: and attribute_id = l_attribute_id

Line 1296: from ame_attribute_usages seed

1292: --+
1293: logMessage(l_proc_name,'Reading mandatory attribute usage data');
1294: open seed_row for
1295: select seed.*
1296: from ame_attribute_usages seed
1297: ,ame_attributes atr
1298: where seed.attribute_id = atr.attribute_id
1299: and exists
1300: (select null

Line 1316: ,ame_attribute_usages atu

1312: logMessage(l_proc_name,'Reading Transaction Type Attribute Usage data');
1313: open seed_row for
1314: select atu.*
1315: from ame_attributes atr
1316: ,ame_attribute_usages atu
1317: where atr.attribute_id = atu.attribute_id
1318: and atu.application_id = g_seed_appl_id
1319: and sysdate between atr.start_Date and nvl(atr.end_Date,sysdate)
1320: and sysdate between atu.start_date and nvl(atu.end_Date,sysdate)