APPS.IRC_RAV_BUS dependencies on IRC_VAC_REC_AREA_VALUES

Line 39: (p_hierarchy_version_id in irc_vac_rec_area_values.hierarchy_version_id%TYPE

35: --
36: -- {End Of Comments}
37: -- ----------------------------------------------------------------------------
38: Procedure chk_hierarchy_version_id
39: (p_hierarchy_version_id in irc_vac_rec_area_values.hierarchy_version_id%TYPE
40: )
41: IS
42: --
43: l_proc varchar2(72) := g_package || 'chk_hierarchy_version_id';

Line 44: l_hierarchy_version_id irc_vac_rec_area_values.hierarchy_version_id%TYPE;

40: )
41: IS
42: --
43: l_proc varchar2(72) := g_package || 'chk_hierarchy_version_id';
44: l_hierarchy_version_id irc_vac_rec_area_values.hierarchy_version_id%TYPE;
45: --
46: cursor csr_chk_hierarchy_version_id is
47: select 1
48: from per_gen_hierarchy_versions

Line 76: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'

72: hr_utility.set_location(' Leaving:'||l_proc,20);
73: exception
74: when app_exception.application_exception then
75: if hr_multi_message.exception_add
76: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'
77: ) then
78: hr_utility.set_location(' Leaving:'|| l_proc, 25);
79: raise;
80: end if;

Line 109: (p_vacancy_id in irc_vac_rec_area_values.vacancy_id%TYPE

105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure chk_duplicate_vac_rec_area
109: (p_vacancy_id in irc_vac_rec_area_values.vacancy_id%TYPE
110: ,p_hierarchy_version_id in irc_vac_rec_area_values.hierarchy_version_id%TYPE
111: )
112: IS
113: --

Line 110: ,p_hierarchy_version_id in irc_vac_rec_area_values.hierarchy_version_id%TYPE

106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure chk_duplicate_vac_rec_area
109: (p_vacancy_id in irc_vac_rec_area_values.vacancy_id%TYPE
110: ,p_hierarchy_version_id in irc_vac_rec_area_values.hierarchy_version_id%TYPE
111: )
112: IS
113: --
114: l_proc varchar2(72) := g_package || 'chk_duplicate_vac_rec_area';

Line 119: from irc_vac_rec_area_values

115: l_count number;
116: --
117: cursor csr_chk_duplicate_rec_area is
118: select 1
119: from irc_vac_rec_area_values
120: where vacancy_id = p_vacancy_id
121: and hierarchy_version_id = p_hierarchy_version_id;
122: --
123: Begin

Line 142: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.VACANCY_ID'

138: hr_utility.set_location(' Leaving:'||l_proc,20);
139: exception
140: when app_exception.application_exception then
141: if hr_multi_message.exception_add
142: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.VACANCY_ID'
143: ,p_associated_column2 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'
144: ) then
145: hr_utility.set_location(' Leaving:'|| l_proc, 25);
146: raise;

Line 143: ,p_associated_column2 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'

139: exception
140: when app_exception.application_exception then
141: if hr_multi_message.exception_add
142: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.VACANCY_ID'
143: ,p_associated_column2 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'
144: ) then
145: hr_utility.set_location(' Leaving:'|| l_proc, 25);
146: raise;
147: end if;