APPS.PER_PJI_BUS dependencies on PER_PREV_JOB_EXTRA_INFO

Line 44: in per_prev_job_extra_info.previous_job_extra_info_id%type

40: procedure chk_previous_job_id
41: (p_previous_job_id
42: in per_previous_jobs.previous_job_id%type
43: ,p_previous_job_extra_info_id
44: in per_prev_job_extra_info.previous_job_extra_info_id%type
45: ,p_object_version_number
46: in per_prev_job_extra_info.object_version_number%type) is
47: cursor csr_previous_job_id is
48: select previous_job_id

Line 46: in per_prev_job_extra_info.object_version_number%type) is

42: in per_previous_jobs.previous_job_id%type
43: ,p_previous_job_extra_info_id
44: in per_prev_job_extra_info.previous_job_extra_info_id%type
45: ,p_object_version_number
46: in per_prev_job_extra_info.object_version_number%type) is
47: cursor csr_previous_job_id is
48: select previous_job_id
49: from per_previous_jobs
50: where previous_job_id = p_previous_job_id;

Line 118: in per_prev_job_extra_info.previous_job_extra_info_id%type

114: -- {End Of Comments}
115: -- ----------------------------------------------------------------------------
116: procedure chk_information_type
117: (p_previous_job_extra_info_id
118: in per_prev_job_extra_info.previous_job_extra_info_id%type
119: ,p_object_version_number
120: in per_prev_job_extra_info.object_version_number%type
121: ,p_information_type
122: in per_prev_job_extra_info.information_type%type) is

Line 120: in per_prev_job_extra_info.object_version_number%type

116: procedure chk_information_type
117: (p_previous_job_extra_info_id
118: in per_prev_job_extra_info.previous_job_extra_info_id%type
119: ,p_object_version_number
120: in per_prev_job_extra_info.object_version_number%type
121: ,p_information_type
122: in per_prev_job_extra_info.information_type%type) is
123: cursor csr_information_type is
124: select information_type

Line 122: in per_prev_job_extra_info.information_type%type) is

118: in per_prev_job_extra_info.previous_job_extra_info_id%type
119: ,p_object_version_number
120: in per_prev_job_extra_info.object_version_number%type
121: ,p_information_type
122: in per_prev_job_extra_info.information_type%type) is
123: cursor csr_information_type is
124: select information_type
125: from per_prev_job_info_types
126: where information_type = p_information_type

Line 128: l_information_type per_prev_job_extra_info.information_type%type;

124: select information_type
125: from per_prev_job_info_types
126: where information_type = p_information_type
127: and active_inactive_flag = 'Y';
128: l_information_type per_prev_job_extra_info.information_type%type;
129: --
130: l_proc varchar2(72) := g_package||'chk_information_type';
131: l_api_updating boolean;
132: begin

Line 180: , per_prev_job_extra_info pji

176: --
177: cursor csr_sec_grp is
178: select pbg.security_group_id
179: from per_business_groups pbg
180: , per_prev_job_extra_info pji
181: , per_previous_jobs pjo
182: , per_previous_employers pem
183: where pji.previous_job_extra_info_id = p_previous_job_extra_info_id
184: and pji.previous_job_id = pjo.previous_job_id

Line 243: , per_prev_job_extra_info pji

239: -- Declare cursor
240: cursor csr_leg_code is
241: select pbg.legislation_code
242: from per_business_groups pbg
243: , per_prev_job_extra_info pji
244: , per_previous_jobs pjo
245: , per_previous_employers pem
246: where pji.previous_job_extra_info_id = p_previous_job_extra_info_id
247: and pji.previous_job_id = pjo.previous_job_id

Line 594: ,p_descflex_name => 'PER_PREV_JOB_EXTRA_INFO'

590: -- b) During insert.
591: --
592: hr_dflex_utility.ins_or_upd_descflex_attribs
593: (p_appl_short_name => 'PER'
594: ,p_descflex_name => 'PER_PREV_JOB_EXTRA_INFO'
595: ,p_attribute_category => p_rec.pji_attribute_category
596: ,p_attribute1_name => 'PJI_ATTRIBUTE1'
597: ,p_attribute1_value => p_rec.pji_attribute1
598: ,p_attribute2_name => 'PJI_ATTRIBUTE2'