APPS.AME_GCF_BUS dependencies on AME_CALLING_APPS

Line 250: -- Cursor to find if application_id exists in ame_calling_apps

246: --
247: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_ID';
248: l_count number;
249: --
250: -- Cursor to find if application_id exists in ame_calling_apps
251: --
252: Cursor C_Sel1 Is
253: select count(application_id)
254: from ame_calling_apps t

Line 254: from ame_calling_apps t

250: -- Cursor to find if application_id exists in ame_calling_apps
251: --
252: Cursor C_Sel1 Is
253: select count(application_id)
254: from ame_calling_apps t
255: where t.application_id = p_application_id
256: and p_effective_date between t.start_date and nvl(t.end_date-(1/84600),sysdate);
257:
258: Begin

Line 264: -- Check if the application_id is existing in ame_calling_apps.

260: hr_api.mandatory_arg_error(p_api_name => l_proc
261: ,p_argument => 'APPLICATION_ID'
262: ,p_argument_value => p_application_id
263: );
264: -- Check if the application_id is existing in ame_calling_apps.
265: open C_Sel1;
266: fetch C_Sel1 into l_count;
267: close C_Sel1;
268: if l_count = 0 then