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 56: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsf_shd.g_old_rec.name then

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

Line 61: ,p_base_table => hr_qsf_shd.g_tab_nam

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

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

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

Line 71: ,p_base_table => hr_qsf_shd.g_tab_nam

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

Line 77: <> hr_qsf_shd.g_old_rec.html_text then

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

Line 82: ,p_base_table => hr_qsf_shd.g_tab_nam

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

Line 88: <> hr_qsf_shd.g_old_rec.sql_required_flag then

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

Line 93: ,p_base_table => hr_qsf_shd.g_tab_nam

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

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

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

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

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

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

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

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

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

Line 350: Procedure update_validate(p_rec in hr_qsf_shd.g_rec_type

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

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

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