DBA Data[Home] [Help]

APPS.AME_ACA_BUS dependencies on AME_CALLING_APPS

Line 65: (p_associated_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID'

61: hr_utility.set_location(' Leaving:'||l_proc,30);
62: exception
63: when app_exception.application_exception then
64: if hr_multi_message.exception_add
65: (p_associated_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID'
66: ) then
67: hr_utility.set_location(' Leaving:'||l_proc, 40);
68: raise;
69: end if;

Line 107: from ame_calling_apps

103: ) IS
104: --
105: cursor csr_application_name is
106: select null
107: from ame_calling_apps
108: where application_name=p_application_name;
109: -- Modified for 4540774.
110: /* and p_effective_date between start_date
111: and nvl(end_date - ame_util.oneSecond, p_effective_date);*/

Line 133: (p_associated_column1 => 'AME_CALLING_APPS.APPLICATION_NAME'

129: hr_utility.set_location(' Leaving:'||l_proc,30);
130: exception
131: when app_exception.application_exception then
132: if hr_multi_message.exception_add
133: (p_associated_column1 => 'AME_CALLING_APPS.APPLICATION_NAME'
134: ) then
135: hr_utility.set_location(' Leaving:'||l_proc, 40);
136: raise;
137: end if;

Line 177: from ame_calling_apps

173: ) IS
174: --
175: cursor csr_fnd_app_tx_type is
176: select null
177: from ame_calling_apps
178: where fnd_application_id=p_fnd_application_id
179: and ((transaction_type_id is null and p_transaction_type_id is null)
180: or (transaction_type_id = p_transaction_type_id)
181: );

Line 189: (p_check_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID') then

185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc,10);
188: if hr_multi_message.no_all_inclusive_error
189: (p_check_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID') then
190: open csr_fnd_app_tx_type;
191: fetch csr_fnd_app_tx_type into l_key;
192: if(csr_fnd_app_tx_type%found) then
193: close csr_fnd_app_tx_type;

Line 203: (p_associated_column1 => 'AME_CALLING_APPS.FND_APP_TX_TYP_ID'

199: hr_utility.set_location(' Leaving:'||l_proc,30);
200: exception
201: when app_exception.application_exception then
202: if hr_multi_message.exception_add
203: (p_associated_column1 => 'AME_CALLING_APPS.FND_APP_TX_TYP_ID'
204: ) then
205: hr_utility.set_location(' Leaving:'||l_proc, 40);
206: raise;
207: end if;

Line 281: from ame_calling_apps

277: ) IS
278: --
279: cursor csr_isSeeded is
280: select ame_utility_pkg.is_seed_user(created_by)
281: from ame_calling_apps
282: where application_id=p_application_id
283: and p_effective_date between start_date and
284: nvl(end_date - ame_util.oneSecond,p_effective_date);
285: l_proc varchar2(72) := g_package || 'CHK_DELETE';

Line 303: (p_associated_column1 => 'AME_CALLING_APPS.DELETE'

299: hr_utility.set_location(' Leaving:'||l_proc,30);
300: exception
301: when app_exception.application_exception then
302: if hr_multi_message.exception_add
303: (p_associated_column1 => 'AME_CALLING_APPS.DELETE'
304: ) then
305: hr_utility.set_location(' Leaving:'||l_proc, 40);
306: raise;
307: end if;