APPS.AME_MULTI_TENANCY_PKG dependencies on AME_CALLING_APPS

Line 84: from ame_calling_apps

80: l_application_id number;
81: l_proc_name varchar2(100);
82: cursor chkTxnType(c_txn_type_id in varchar2) is
83: select application_id
84: from ame_calling_apps
85: where transaction_type_id = c_txn_type_id
86: and sysdate between start_date and nvl(end_Date,sysdate);
87: --
88: cursor chkTxnCust(c_txn_type_id in varchar2) is

Line 90: from ame_calling_apps

86: and sysdate between start_date and nvl(end_Date,sysdate);
87: --
88: cursor chkTxnCust(c_txn_type_id in varchar2) is
89: select count(*)
90: from ame_calling_apps
91: where transaction_type_id = c_txn_type_id
92: -- and isSeedUser(last_updated_by) = ame_util.booleanFalse;
93: and isEntDataModified(creation_date,last_update_date) = ame_util.booleanTrue;
94: --

Line 97: from ame_calling_Apps ent

93: and isEntDataModified(creation_date,last_update_date) = ame_util.booleanTrue;
94: --
95: cursor getTxnUpdDets(l_seed_apl_name in varchar2) is
96: select ent.object_version_number
97: from ame_calling_Apps ent
98: where ent.application_id = g_ent_appl_id
99: and (ent.fnd_application_id <> g_fnd_application_id
100: or ent.application_name <> l_seed_apl_name)
101: and sysdate between ent.start_date and nvl(ent.end_Date,sysdate)

Line 126: update ame_calling_apps_tl

122: ,p_object_version_number => l_ovn
123: ,p_start_date => l_start_date
124: ,p_end_date => l_end_Date
125: );
126: update ame_calling_apps_tl
127: set created_by = getSeedUser
128: ,last_updated_by = getSeedUser
129: where application_id = g_ent_appl_id
130: and language = userenv('LANG');

Line 158: update ame_calling_apps

154: ,p_start_date => l_start_date
155: ,p_end_date => l_end_Date
156: );
157: g_ent_appl_id := l_applicationId;
158: update ame_calling_apps
159: set created_by = getSeedUser
160: ,last_updated_by = getSeedUser
161: where application_id = g_ent_appl_id
162: and sysdate between start_date and nvl(end_Date,sysdate);

Line 164: update ame_calling_apps_tl

160: ,last_updated_by = getSeedUser
161: where application_id = g_ent_appl_id
162: and sysdate between start_date and nvl(end_Date,sysdate);
163: --
164: update ame_calling_apps_tl
165: set created_by = getSeedUser
166: ,last_updated_by = getSeedUser
167: where application_id = g_ent_appl_id;
168: --

Line 1246: from ame_calling_apps

1242: --+
1243: logMessage(l_proc_name,'Reading transaction type data for ' || g_seed_txntype);
1244: open seed_row for
1245: select *
1246: from ame_calling_apps
1247: where transaction_type_id = g_seed_txntype
1248: and fnd_application_id = g_fnd_application_id
1249: and sysdate between start_date and nvl(end_Date,sysdate);
1250: fetch seed_row bulk collect into g_seed_call_apps;

Line 1496: from ame_calling_apps

1492: l_fnd_appl_id number;
1493: cursor getTxnType(c_applIdIn in number) is
1494: select transaction_type_id
1495: ,fnd_application_id
1496: from ame_calling_apps
1497: where application_id = c_applIdIn
1498: and sysdate between start_date and nvl(end_date,sysdate);
1499: --
1500: cursor getEnterpriseName(c_enterpriseId in number) is