APPS.PE_POI_BUS dependencies on PER_POSITION_INFO_TYPES

Line 176: -- per_position_info_types where active_inactive_flag is 'Y'.

172: -- {Start Of Comments}
173: --
174: -- Description:
175: -- Validates that the position information type exists in table
176: -- per_position_info_types where active_inactive_flag is 'Y'.
177: --
178: -- Pre Conditions:
179: -- Data must be existed in table per_position_info_types.
180: --

Line 179: -- Data must be existed in table per_position_info_types.

175: -- Validates that the position information type exists in table
176: -- per_position_info_types where active_inactive_flag is 'Y'.
177: --
178: -- Pre Conditions:
179: -- Data must be existed in table per_position_info_types.
180: --
181: -- In Parameters:
182: -- p_information_type
183: --

Line 202: p_information_type in per_position_info_types.information_type%type

198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure chk_position_info_type
201: (
202: p_information_type in per_position_info_types.information_type%type
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'chk_position_info_type';
206: l_flag per_position_info_types.active_inactive_flag%type;

Line 206: l_flag per_position_info_types.active_inactive_flag%type;

202: p_information_type in per_position_info_types.information_type%type
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'chk_position_info_type';
206: l_flag per_position_info_types.active_inactive_flag%type;
207: --
208: cursor c_pos_info_type (code varchar2) is
209: select poit.active_inactive_flag
210: from per_position_info_types poit

Line 210: from per_position_info_types poit

206: l_flag per_position_info_types.active_inactive_flag%type;
207: --
208: cursor c_pos_info_type (code varchar2) is
209: select poit.active_inactive_flag
210: from per_position_info_types poit
211: where poit.information_type = code;
212: --
213: Begin
214: hr_utility.set_location('Entering:'||l_proc, 1);

Line 360: l_multi_occur_flag per_position_info_types.multiple_occurences_flag%type;

356: ,p_position_id in per_position_extra_info.position_id%type
357: ) is
358: --
359: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
360: l_multi_occur_flag per_position_info_types.multiple_occurences_flag%type;
361: l_dummy varchar2(1);
362: l_found_poi boolean;
363: --
364: cursor c_multi_occur_flag (code varchar2) is

Line 366: from per_position_info_types

362: l_found_poi boolean;
363: --
364: cursor c_multi_occur_flag (code varchar2) is
365: select multiple_occurences_flag
366: from per_position_info_types
367: where information_type = code;
368: --
369: cursor c_get_row (code varchar2, id number) is
370: select 'x'