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_QSF_BUS dependencies on HR_QSF_SHD

Line 20: (p_rec in hr_qsf_shd.g_rec_type

16: -- ----------------------------------------------------------------------------
17: -- |-----------------------< chk_non_updateable_args >------------------------|
18: -- ----------------------------------------------------------------------------
19: Procedure chk_non_updateable_args
20: (p_rec in hr_qsf_shd.g_rec_type
21: ,p_effective_date in date
22: )
23: is
24: --

Line 32: if not hr_qsf_shd.api_updating

28: --
29: -- Only proceed with the validation if a row exists for the current
30: -- record in the HR Schema
31: --
32: if not hr_qsf_shd.api_updating
33: (p_field_id => p_rec.field_id
34: ,p_object_version_number => p_rec.object_version_number
35: ) then
36: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');

Line 44: hr_qsf_shd.g_old_rec.questionnaire_template_id then

40: end if;
41: hr_utility.set_location(l_proc,30);
42: --
43: if nvl(p_rec.questionnaire_template_id,hr_api.g_number) <>
44: hr_qsf_shd.g_old_rec.questionnaire_template_id then
45:
46: hr_api.argument_changed_error
47: (p_api_name => l_proc
48: ,p_argument => 'QUESTIONNAIRE_TEMPLATE_ID'

Line 49: ,p_base_table => hr_qsf_shd.g_tab_nam

45:
46: hr_api.argument_changed_error
47: (p_api_name => l_proc
48: ,p_argument => 'QUESTIONNAIRE_TEMPLATE_ID'
49: ,p_base_table => hr_qsf_shd.g_tab_nam
50: );
51: end if;
52: hr_utility.set_location(l_proc,40);
53: --

Line 54: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsf_shd.g_old_rec.name then

50: );
51: end if;
52: hr_utility.set_location(l_proc,40);
53: --
54: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsf_shd.g_old_rec.name then
55:
56: hr_api.argument_changed_error
57: (p_api_name => l_proc
58: ,p_argument => 'NAME'

Line 59: ,p_base_table => hr_qsf_shd.g_tab_nam

55:
56: hr_api.argument_changed_error
57: (p_api_name => l_proc
58: ,p_argument => 'NAME'
59: ,p_base_table => hr_qsf_shd.g_tab_nam
60: );
61: end if;
62: hr_utility.set_location(l_proc,50);
63: --

Line 64: if nvl(p_rec.type,hr_api.g_varchar2) <> hr_qsf_shd.g_old_rec.type then

60: );
61: end if;
62: hr_utility.set_location(l_proc,50);
63: --
64: if nvl(p_rec.type,hr_api.g_varchar2) <> hr_qsf_shd.g_old_rec.type then
65:
66: hr_api.argument_changed_error
67: (p_api_name => l_proc
68: ,p_argument => 'TYPE'

Line 69: ,p_base_table => hr_qsf_shd.g_tab_nam

65:
66: hr_api.argument_changed_error
67: (p_api_name => l_proc
68: ,p_argument => 'TYPE'
69: ,p_base_table => hr_qsf_shd.g_tab_nam
70: );
71: end if;
72: hr_utility.set_location(l_proc,60);
73: --

Line 75: <> hr_qsf_shd.g_old_rec.html_text then

71: end if;
72: hr_utility.set_location(l_proc,60);
73: --
74: if nvl(p_rec.html_text,hr_api.g_varchar2)
75: <> hr_qsf_shd.g_old_rec.html_text then
76:
77: hr_api.argument_changed_error
78: (p_api_name => l_proc
79: ,p_argument => 'HTML_TEXT'

Line 80: ,p_base_table => hr_qsf_shd.g_tab_nam

76:
77: hr_api.argument_changed_error
78: (p_api_name => l_proc
79: ,p_argument => 'HTML_TEXT'
80: ,p_base_table => hr_qsf_shd.g_tab_nam
81: );
82: end if;
83: hr_utility.set_location(l_proc,70);
84: --

Line 86: <> hr_qsf_shd.g_old_rec.sql_required_flag then

82: end if;
83: hr_utility.set_location(l_proc,70);
84: --
85: if nvl(p_rec.sql_required_flag,hr_api.g_varchar2)
86: <> hr_qsf_shd.g_old_rec.sql_required_flag then
87:
88: hr_api.argument_changed_error
89: (p_api_name => l_proc
90: ,p_argument => 'SQL_REQUIRED_FLAG'

Line 91: ,p_base_table => hr_qsf_shd.g_tab_nam

87:
88: hr_api.argument_changed_error
89: (p_api_name => l_proc
90: ,p_argument => 'SQL_REQUIRED_FLAG'
91: ,p_base_table => hr_qsf_shd.g_tab_nam
92: );
93: end if;
94: hr_utility.set_location('Leaving: '||l_proc,80);
95: --

Line 129: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_FK');

125: fetch csr_id_exists into l_exists;
126: if csr_id_exists%notfound then
127: -- Questionnaire template id not found - raise error
128: close csr_id_exists;
129: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_FK');
130: end if;
131: close csr_id_exists;
132: else
133: -- Questionnaire template id is null - raise error

Line 207: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_TYPE_CHK');

203: ,p_lookup_type => 'QUEST_FIELD_TYPE'
204: ,p_lookup_code => p_type
205: ) then
206: -- p_type does not exist in lookup
207: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_TYPE_CHK');
208: end if;
209: else
210: -- p_type is null
211: fnd_message.set_name('PER','PER_52426_QSF_MAND_TYPE');

Line 294: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_SQL_FLAG_CHK');

290: ,p_lookup_type => 'YES_NO'
291: ,p_lookup_code => p_sql_required_flag
292: ) then
293: -- Doesnt exist in lookups, so error
294: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_SQL_FLAG_CHK');
295: end if;
296: else
297: -- p_sql_required flag is null, yet is a mandatory column
298: fnd_message.set_name('PER','PER_52422_QSF_MAND_REQD_FLAG');

Line 318: Procedure insert_validate(p_rec in hr_qsf_shd.g_rec_type,

314: --
315: -- ----------------------------------------------------------------------------
316: -- |---------------------------< insert_validate >----------------------------|
317: -- ----------------------------------------------------------------------------
318: Procedure insert_validate(p_rec in hr_qsf_shd.g_rec_type,
319: p_effective_date in date) is
320: --
321: l_proc varchar2(72) := g_package||'insert_validate';
322: --

Line 347: Procedure update_validate(p_rec in hr_qsf_shd.g_rec_type

343: --
344: -- ----------------------------------------------------------------------------
345: -- |---------------------------< update_validate >----------------------------|
346: -- ----------------------------------------------------------------------------
347: Procedure update_validate(p_rec in hr_qsf_shd.g_rec_type
348: ,p_effective_date in date) is
349: --
350: l_proc varchar2(72) := g_package||'update_validate';
351: --

Line 376: Procedure delete_validate(p_rec in hr_qsf_shd.g_rec_type) is

372: --
373: -- ----------------------------------------------------------------------------
374: -- |---------------------------< delete_validate >----------------------------|
375: -- ----------------------------------------------------------------------------
376: Procedure delete_validate(p_rec in hr_qsf_shd.g_rec_type) is
377: --
378: l_proc varchar2(72) := g_package||'delete_validate';
379: --
380: Begin