APPS.PE_JEI_BUS dependencies on PER_JOB_INFO_TYPES

Line 106: -- per_job_info_types where active_inactive_flag is 'Y'.

102: -- {Start Of Comments}
103: --
104: -- Description:
105: -- Validates that the job information type exists in table
106: -- per_job_info_types where active_inactive_flag is 'Y'.
107: --
108: -- Pre Conditions:
109: -- Data must be existed in table per_job_info_types.
110: --

Line 109: -- Data must be existed in table per_job_info_types.

105: -- Validates that the job information type exists in table
106: -- per_job_info_types where active_inactive_flag is 'Y'.
107: --
108: -- Pre Conditions:
109: -- Data must be existed in table per_job_info_types.
110: --
111: -- In Parameters:
112: -- p_information_type
113: --

Line 132: (p_information_type in per_job_info_types.information_type%type

128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130:
131: Procedure chk_job_info_type
132: (p_information_type in per_job_info_types.information_type%type
133: ) is
134: --
135: l_proc varchar2(72) := g_package||'chk_job_info_type';
136: l_flag per_job_info_types.active_inactive_flag%type;

Line 136: l_flag per_job_info_types.active_inactive_flag%type;

132: (p_information_type in per_job_info_types.information_type%type
133: ) is
134: --
135: l_proc varchar2(72) := g_package||'chk_job_info_type';
136: l_flag per_job_info_types.active_inactive_flag%type;
137: --
138: cursor c_job_info_type (code varchar2) is
139: select jeit.active_inactive_flag
140: from per_job_info_types jeit

Line 140: from per_job_info_types jeit

136: l_flag per_job_info_types.active_inactive_flag%type;
137: --
138: cursor c_job_info_type (code varchar2) is
139: select jeit.active_inactive_flag
140: from per_job_info_types jeit
141: where jeit.information_type = code;
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 1);

Line 296: l_multi_occur_flag per_job_info_types.multiple_occurences_flag%type;

292: ,p_job_id in per_job_extra_info.job_id%type
293: ) is
294: --
295: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
296: l_multi_occur_flag per_job_info_types.multiple_occurences_flag%type;
297: l_dummy varchar2(1);
298: l_found_jei boolean;
299: --
300: cursor c_multi_occur_flag (code varchar2) is

Line 302: from per_job_info_types

298: l_found_jei boolean;
299: --
300: cursor c_multi_occur_flag (code varchar2) is
301: select multiple_occurences_flag
302: from per_job_info_types
303: where information_type = code;
304: --
305: cursor c_get_row (code varchar2, id number) is
306: select 'x'