APPS.AME_CAL_BUS dependencies on AME_CALLING_APPS

Line 24: -- provided. The ID must be defined in the AME_CALLING_APPS table.

20: -- {Start Of Comments}
21: --
22: -- Description:
23: -- This procedure checks whether a valid Application ID has been
24: -- provided. The ID must be defined in the AME_CALLING_APPS table.
25: --
26: -- Pre-Requisites:
27: -- None
28: --

Line 37: -- defined or if the value is not found in AME_CALLING_APPS table.

33: -- Processing continues if a valid Application ID is found.
34: --
35: -- Post Failure:
36: -- An application error is raised either if the p_application_id is not
37: -- defined or if the value is not found in AME_CALLING_APPS table.
38: --
39: -- Access Status:
40: -- Internal Row Handler Use Only.
41: --

Line 50: from ame_calling_apps

46: ) IS
47: --
48: cursor csr_application_id is
49: select null
50: from ame_calling_apps
51: where application_id = p_application_id
52: and p_effective_date between start_date
53: and nvl(end_date - ame_util.oneSecond, p_effective_date);
54: --

Line 77: (p_associated_column1 => 'AME_CALLING_APPS_TL.APPLICATION_ID'

73: hr_utility.set_location(' Leaving:'||l_proc,30);
74: exception
75: when app_exception.application_exception then
76: if hr_multi_message.exception_add
77: (p_associated_column1 => 'AME_CALLING_APPS_TL.APPLICATION_ID'
78: ) then
79: hr_utility.set_location(' Leaving:'||l_proc, 40);
80: raise;
81: end if;

Line 119: from ame_calling_apps_tl cal

115: l_key varchar2(1);
116: l_exists varchar2(1);
117: cursor dup_app_name is
118: select null
119: from ame_calling_apps_tl cal
120: where cal.application_name = p_application_name
121: and cal.language = p_language;
122: --
123: Begin

Line 141: (p_associated_column1 => 'AME_CALLING_APPS_TL.APPLICATION_NAME'

137: close dup_app_name;
138: exception
139: when app_exception.application_exception then
140: if hr_multi_message.exception_add
141: (p_associated_column1 => 'AME_CALLING_APPS_TL.APPLICATION_NAME'
142: ) then
143: hr_utility.set_location(' Leaving:'||l_proc, 40);
144: raise;
145: end if;