APPS.HR_AHK_BUS dependencies on HR_API_MODULES

Line 72: -- the parent HR_API_MODULES table. Prohibit insert into table HR_API_HOOKS

68: -- -----------------------------------------------------------------
69: --
70: -- Description:
71: -- Check that the api_module_id is not null and that it refers to a row on
72: -- the parent HR_API_MODULES table. Prohibit insert into table HR_API_HOOKS
73: -- should the api-module-type equal 'AI' (Alternative Interface).
74: --
75: -- Pre-Requisites:
76: -- None

Line 99: l_api_module_type hr_api_modules.api_module_type%TYPE;

95: ) is
96: --
97: -- Local declarations
98: l_proc varchar2(72) := g_package||' chk_api_module_id';
99: l_api_module_type hr_api_modules.api_module_type%TYPE;
100:
101: -- Setup cursor for valid module type check
102: cursor csr_valid_module_type is
103: select api_module_type

Line 104: from hr_api_modules

100:
101: -- Setup cursor for valid module type check
102: cursor csr_valid_module_type is
103: select api_module_type
104: from hr_api_modules
105: where api_module_id = p_api_module_id;
106: --
107: begin
108: hr_utility.set_location('Entering: '||l_proc,5);

Line 191: -- the HR_API_MODULES table, using the api_module_id as a key.

187: where hah.api_module_id = p_api_module_id
188: and hah.api_hook_type = p_api_hook_type;
189:
190: -- Declare a cursor to retrieve the module type from
191: -- the HR_API_MODULES table, using the api_module_id as a key.
192: cursor csr_get_module_type is
193: select api_module_type from hr_api_modules
194: where api_module_id = p_api_module_id;
195:

Line 193: select api_module_type from hr_api_modules

189:
190: -- Declare a cursor to retrieve the module type from
191: -- the HR_API_MODULES table, using the api_module_id as a key.
192: cursor csr_get_module_type is
193: select api_module_type from hr_api_modules
194: where api_module_id = p_api_module_id;
195:
196: --
197: --

Line 541: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;

537: ) is
538: --
539: -- Local declarations
540: l_proc varchar2(72) := g_package||'chk_legislation_package';
541: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;
542: l_api_updating boolean;
543: --
544: -- Setup cursor for to retrieve data within business group from parent
545: cursor csr_get_data_within_bus_group is

Line 547: from hr_api_modules

543: --
544: -- Setup cursor for to retrieve data within business group from parent
545: cursor csr_get_data_within_bus_group is
546: select data_within_business_group
547: from hr_api_modules
548: where api_module_id = p_api_module_id;
549: --
550: --
551: begin

Line 620: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;

616: ) is
617: --
618: -- Local declarations
619: l_proc varchar2(72) := g_package||'chk_legislation_function';
620: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;
621: l_api_updating boolean;
622: --
623: -- Setup cursor for to retrieve data within business group from parent
624: cursor csr_get_data_within_bus_group is

Line 626: from hr_api_modules

622: --
623: -- Setup cursor for to retrieve data within business group from parent
624: cursor csr_get_data_within_bus_group is
625: select data_within_business_group
626: from hr_api_modules
627: where api_module_id = p_api_module_id;
628: --
629: --
630: begin