APPS.PQH_REI_BUS dependencies on PQH_ROLE_INFO_TYPES

Line 165: -- pqh_role_info_types where active_inactive_flag is 'Y'.

161: -- {Start Of Comments}
162: --
163: -- Description:
164: -- Validates that the role information type exists in table
165: -- pqh_role_info_types where active_inactive_flag is 'Y'.
166: --
167: -- Pre Conditions:
168: -- Data must be existed in table pqh_role_info_types.
169: --

Line 168: -- Data must be existed in table pqh_role_info_types.

164: -- Validates that the role information type exists in table
165: -- pqh_role_info_types where active_inactive_flag is 'Y'.
166: --
167: -- Pre Conditions:
168: -- Data must be existed in table pqh_role_info_types.
169: --
170: -- In Parameters:
171: -- p_information_type
172: --

Line 191: (p_information_type in pqh_role_info_types.information_type%type

187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189:
190: Procedure chk_role_info_type
191: (p_information_type in pqh_role_info_types.information_type%type
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'chk_role_info_type';
195: l_flag pqh_role_info_types.active_inactive_flag%type;

Line 195: l_flag pqh_role_info_types.active_inactive_flag%type;

191: (p_information_type in pqh_role_info_types.information_type%type
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'chk_role_info_type';
195: l_flag pqh_role_info_types.active_inactive_flag%type;
196: --
197: cursor c_role_info_type (code varchar2) is
198: select reit.active_inactive_flag
199: from pqh_role_info_types reit

Line 199: from pqh_role_info_types reit

195: l_flag pqh_role_info_types.active_inactive_flag%type;
196: --
197: cursor c_role_info_type (code varchar2) is
198: select reit.active_inactive_flag
199: from pqh_role_info_types reit
200: where reit.information_type = code;
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 1);

Line 348: l_multi_occur_flag pqh_role_info_types.multiple_occurences_flag%type;

344: ,p_role_id in pqh_role_extra_info.role_id%type
345: ) is
346:
347: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
348: l_multi_occur_flag pqh_role_info_types.multiple_occurences_flag%type;
349: l_dummy varchar2(1);
350: l_found_rei boolean;
351: --
352: cursor c_multi_occur_flag (code varchar2) is

Line 354: from pqh_role_info_types

350: l_found_rei boolean;
351: --
352: cursor c_multi_occur_flag (code varchar2) is
353: select multiple_occurences_flag
354: from pqh_role_info_types
355: where information_type = code;
356: --
357: cursor c_get_row (code varchar2, id number) is
358: select 'x'