eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_QSN_BUS dependencies on HR_QUESTIONNAIRES

Line 32: , hr_questionnaires qsn

28: --
29: cursor csr_sec_grp is
30: select inf.org_information14
31: from hr_organization_information inf
32: , hr_questionnaires qsn
33: where qsn.questionnaire_template_id = p_questionnaire_template_id
34: and inf.organization_id = qsn.business_group_id(+)
35: and inf.org_information_context || '' = 'Business Group Information';
36: -- order by per.effective_start_date;

Line 128: (p_name in hr_questionnaires.name%TYPE

124: -- |------------------------< chk_name >------------------------------------|
125: -- --------------------------------------------------------------------------
126: --
127: Procedure chk_name
128: (p_name in hr_questionnaires.name%TYPE
129: ,p_business_group_id in hr_questionnaires.name%TYPE
130: )
131: is
132: --

Line 129: ,p_business_group_id in hr_questionnaires.name%TYPE

125: -- --------------------------------------------------------------------------
126: --
127: Procedure chk_name
128: (p_name in hr_questionnaires.name%TYPE
129: ,p_business_group_id in hr_questionnaires.name%TYPE
130: )
131: is
132: --
133: l_proc varchar2(72) := g_package || 'chk_name';

Line 140: from hr_questionnaires

136: -- Cursor to check that name is unique.
137: --
138: cursor csr_unique_name is
139: select null
140: from hr_questionnaires
141: where name = p_name
142: and ((p_business_group_id is null and business_group_id is null)
143: or business_group_id = p_business_group_id);
144: --

Line 155: hr_qsn_shd.constraint_error('HR_QUESTIONNAIRES_UK1');

151: fetch csr_unique_name into l_exists;
152: if csr_unique_name%FOUND then
153: -- Name is not unique - raise error by calling constraint error
154: close csr_unique_name;
155: hr_qsn_shd.constraint_error('HR_QUESTIONNAIRES_UK1');
156: end if;
157: close csr_unique_name;
158: else
159: -- Name is null - raise error

Line 167: (p_associated_column1 => 'HR_QUESTIONNAIRES.NAME'

163: --
164: hr_utility.set_location(' Leaving: '||l_proc, 50);
165: exception when app_exception.application_exception then
166: if hr_multi_message.exception_add
167: (p_associated_column1 => 'HR_QUESTIONNAIRES.NAME'
168: ) then
169: hr_utility.set_location(' Leaving:'|| l_proc, 60);
170: raise;
171: end if;

Line 180: (p_text in hr_questionnaires.text%TYPE

176: -- |----------------------------< chk_text >---------------------------------|
177: -- ---------------------------------------------------------------------------
178: --
179: Procedure chk_text
180: (p_text in hr_questionnaires.text%TYPE
181: )
182: is
183: --
184: c_max_size CONSTANT number := 27648;

Line 208: (p_associated_column1 => 'HR_QUESTIONNAIRES.TEXT'

204: --
205: hr_utility.set_location('Leaving: '||l_proc,50);
206: exception when app_exception.application_exception then
207: if hr_multi_message.exception_add
208: (p_associated_column1 => 'HR_QUESTIONNAIRES.TEXT'
209: ) then
210: hr_utility.set_location(' Leaving:'|| l_proc, 60);
211: raise;
212: end if;

Line 223: (p_available_flag in hr_questionnaires.available_flag%TYPE

219: -- |----------------------< chk_available_flag >-----------------------------|
220: -- ---------------------------------------------------------------------------
221: --
222: Procedure chk_available_flag
223: (p_available_flag in hr_questionnaires.available_flag%TYPE
224: ,p_effective_date in date
225: ,p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE
226: ,p_object_version_number in hr_questionnaires.object_version_number%TYPE
227: )

Line 225: ,p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE

221: --
222: Procedure chk_available_flag
223: (p_available_flag in hr_questionnaires.available_flag%TYPE
224: ,p_effective_date in date
225: ,p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE
226: ,p_object_version_number in hr_questionnaires.object_version_number%TYPE
227: )
228: is
229: --

Line 226: ,p_object_version_number in hr_questionnaires.object_version_number%TYPE

222: Procedure chk_available_flag
223: (p_available_flag in hr_questionnaires.available_flag%TYPE
224: ,p_effective_date in date
225: ,p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE
226: ,p_object_version_number in hr_questionnaires.object_version_number%TYPE
227: )
228: is
229: --
230: l_proc varchar2(72) := g_package ||'chk_available_flag';

Line 271: (p_associated_column1 => 'HR_QUESTIONNAIRES.AVAILABLE_FLAG'

267: --
268: hr_utility.set_location('Leaving: '||l_proc,50);
269: exception when app_exception.application_exception then
270: if hr_multi_message.exception_add
271: (p_associated_column1 => 'HR_QUESTIONNAIRES.AVAILABLE_FLAG'
272: ) then
273: hr_utility.set_location(' Leaving:'|| l_proc, 60);
274: raise;
275: end if;

Line 284: (p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE)

280: -- ----------------------------------------------------------------------------
281: -- |-------------------------< chk_row_delete >-------------------------------|
282: -- ----------------------------------------------------------------------------
283: procedure chk_row_delete
284: (p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE)
285: is
286: --
287: l_proc varchar2(72) := g_package || 'chk_row_delete';
288: l_exists varchar2(1);

Line 320: (p_associated_column1 => 'HR_QUESTIONNAIRES.AVAILABLE_FLAG'

316: --
317: hr_utility.set_location('Leaving: '||l_proc, 20);
318: exception when app_exception.application_exception then
319: if hr_multi_message.exception_add
320: (p_associated_column1 => 'HR_QUESTIONNAIRES.AVAILABLE_FLAG'
321: ) then
322: hr_utility.set_location(' Leaving:'|| l_proc, 30);
323: raise;
324: end if;

Line 420: (p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE

416: -- ----------------------------------------------------------------------------
417: -- |--------------------< return_legislation_code >---------------------------|
418: -- ----------------------------------------------------------------------------
419: Function return_legislation_code
420: (p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE
421: ) return varchar2 is
422: --
423: -- Cursor to find legislation code
424: --

Line 428: , hr_questionnaires qsn

424: --
425: cursor csr_leg_code is
426: select pbg.legislation_code
427: from per_business_groups pbg
428: , hr_questionnaires qsn
429: where qsn.questionnaire_template_id = p_questionnaire_template_id
430: and pbg.business_group_id = qsn.business_group_id;
431: --
432: -- Declare local variables