APPS.PE_JEI_BUS dependencies on PER_JOB_EXTRA_INFO

Line 28: -- per_job_extra_info and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- In the following cursor statement add join(s) between
28: -- per_job_extra_info and PER_BUSINESS_GROUPS
29: -- so that the legislation_code for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_leg_code is

Line 35: , per_job_extra_info jei

31: -- Remove this comment when the edit has been completed.
32: cursor csr_leg_code is
33: select pbg.legislation_code
34: from per_business_groups pbg
35: , per_job_extra_info jei
36: , per_jobs pj
37: where jei.job_extra_info_id = p_job_extra_info_id
38: and jei.job_id = pj.job_id
39: and pbg.business_group_id = pj.business_group_id;

Line 211: p_job_id in per_job_extra_info.job_id%type

207: -- ----------------------------------------------------------------------------
208:
209: Procedure chk_job_id
210: (
211: p_job_id in per_job_extra_info.job_id%type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'chk_job_id';
215: l_dummy varchar2(1);

Line 291: (p_information_type in per_job_extra_info.information_type%type

287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure chk_multiple_occurences_flag
291: (p_information_type in per_job_extra_info.information_type%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';

Line 292: ,p_job_id in per_job_extra_info.job_id%type

288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure chk_multiple_occurences_flag
291: (p_information_type in per_job_extra_info.information_type%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;

Line 307: from per_job_extra_info

303: where information_type = code;
304: --
305: cursor c_get_row (code varchar2, id number) is
306: select 'x'
307: from per_job_extra_info
308: where information_type = code
309: and job_id = id;
310: --
311: Begin

Line 462: ,p_descflex_name => 'PER_JOB_EXTRA_INFO'

458: pe_jei_flex.df(p_rec);
459: */
460: hr_dflex_utility.ins_or_upd_descflex_attribs
461: (p_appl_short_name => 'PER'
462: ,p_descflex_name => 'PER_JOB_EXTRA_INFO'
463: ,p_attribute_category => p_rec.jei_attribute_category
464: ,p_attribute1_name => 'JEI_ATTRIBUTE1'
465: ,p_attribute1_value => p_rec.JEI_ATTRIBUTE1
466: ,p_attribute2_name => 'JEI_ATTRIBUTE2'

Line 608: ,p_descflex_name => 'PER_JOB_EXTRA_INFO'

604: pe_jei_flex.df(p_rec);
605: */
606: hr_dflex_utility.ins_or_upd_descflex_attribs
607: (p_appl_short_name => 'PER'
608: ,p_descflex_name => 'PER_JOB_EXTRA_INFO'
609: ,p_attribute_category => p_rec.jei_attribute_category
610: ,p_attribute1_name => 'JEI_ATTRIBUTE1'
611: ,p_attribute1_value => p_rec.JEI_ATTRIBUTE1
612: ,p_attribute2_name => 'JEI_ATTRIBUTE2'