APPS.AME_MULTI_TENANCY_PKG dependencies on AME_ACTION_TYPE_CONFIG

Line 546: from ame_action_Type_config

542: l_end_date date;
543:
544: cursor chkActionTypeUsg(c_action_type_id in number) is
545: select count(*)
546: from ame_action_Type_config
547: where sysdate between start_date and nvl(end_Date,sysdate)
548: and application_id = g_ent_appl_id
549: and action_type_id = c_action_type_id;
550:

Line 554: from ame_action_type_config ent

550:
551: cursor getActTypeUpd(c_act_type_id in number, c_voting_regime in varchar2
552: ,c_chain_ordering_mode in varchar2, c_order_number in number) is
553: select ent.object_version_number
554: from ame_action_type_config ent
555: where ent.application_id = g_ent_appl_id
556: and c_act_type_id = ent.action_type_id
557: and (nvl(ent.voting_regime,'AA') <> nvl(c_voting_regime,'AA')
558: or nvl(ent.chain_ordering_mode,'AA') <> nvl(c_chain_ordering_mode,'AA')

Line 591: update ame_action_type_config

587: p_object_version_number => l_ovn,
588: p_start_date => l_start_date,
589: p_end_date => l_end_Date
590: );
591: update ame_action_type_config
592: set created_by = getSeedUser
593: ,last_updated_by = getSeedUser
594: where application_id = g_ent_appl_id
595: and action_type_id = l_action_type_id

Line 612: update ame_action_type_config

608: ,p_object_version_number => l_ovn
609: ,p_start_date => l_start_date
610: ,p_end_date => l_end_date
611: );
612: update ame_action_type_config
613: set created_by = getSeedUser
614: ,last_updated_by = getSeedUser
615: where application_id = g_ent_appl_id
616: and action_type_id = l_action_type_id

Line 1333: from ame_action_type_config

1329: --+
1330: logMessage(l_proc_name,'Reading Action Type Configuration data');
1331: open seed_row for
1332: select *
1333: from ame_action_type_config
1334: where sysdate between start_date and nvl(end_Date,sysdate)
1335: and application_id = g_seed_appl_id;
1336: fetch seed_row bulk collect into g_seed_act_config;
1337: close seed_row;