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_API

Line 43: if nvl(p_rec.questionnaire_template_id,hr_api.g_number) <>

39: fnd_message.raise_error;
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

Line 46: hr_api.argument_changed_error

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'
49: ,p_base_table => hr_qsf_shd.g_tab_nam
50: );

Line 54: if nvl(p_rec.html_text,hr_api.g_varchar2) <> 'BLANK' then

50: );
51: end if;
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

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 58: hr_api.argument_changed_error

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'
61: ,p_base_table => hr_qsf_shd.g_tab_nam
62: );

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 68: hr_api.argument_changed_error

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'
71: ,p_base_table => hr_qsf_shd.g_tab_nam
72: );

Line 76: if nvl(p_rec.html_text,hr_api.g_varchar2)

72: );
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

Line 79: hr_api.argument_changed_error

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'
82: ,p_base_table => hr_qsf_shd.g_tab_nam
83: );

Line 87: if nvl(p_rec.sql_required_flag,hr_api.g_varchar2)

83: );
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

Line 90: hr_api.argument_changed_error

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'
93: ,p_base_table => hr_qsf_shd.g_tab_nam
94: );

Line 204: if hr_api.not_exists_in_hr_lookups

200: hr_utility.set_location('Entering: '||l_proc,10);
201: --
202: if p_type is not null then
203: -- Check that p_type exists in lookup
204: if hr_api.not_exists_in_hr_lookups
205: (p_effective_date => p_effective_date
206: ,p_lookup_type => 'QUEST_FIELD_TYPE'
207: ,p_lookup_code => p_type
208: ) then

Line 291: if hr_api.not_exists_in_hr_lookups

287: hr_utility.set_location('Entering: '||l_proc,10);
288: --
289: if p_sql_required_flag is not null then
290: -- Check that it exists in HR_LOOKUPS
291: if hr_api.not_exists_in_hr_lookups
292: (p_effective_date => p_effective_date
293: ,p_lookup_type => 'YES_NO'
294: ,p_lookup_code => p_sql_required_flag
295: ) then

Line 415: hr_api.mandatory_arg_error(p_api_name => l_proc

411: l_legislation_code varchar2(150);
412: l_proc varchar2(72) := 'return_legislation_code';
413: begin
414: hr_utility.set_location('Entering: '||l_proc,10);
415: hr_api.mandatory_arg_error(p_api_name => l_proc
416: ,p_argument => 'field_id'
417: ,p_argument_value => p_field_id
418: );
419: if nvl(g_field_id, hr_api.g_number) = p_field_id then

Line 419: if nvl(g_field_id, hr_api.g_number) = p_field_id then

415: hr_api.mandatory_arg_error(p_api_name => l_proc
416: ,p_argument => 'field_id'
417: ,p_argument_value => p_field_id
418: );
419: if nvl(g_field_id, hr_api.g_number) = p_field_id then
420: --
421: -- The legislation code has already been found with a previous
422: -- call to this function. Just return the value in the global
423: -- variable.