DBA Data[Home] [Help]

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

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

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

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

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

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

Line 77: hr_api.argument_changed_error

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

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

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

Line 88: hr_api.argument_changed_error

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

Line 201: if hr_api.not_exists_in_hr_lookups

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

Line 288: if hr_api.not_exists_in_hr_lookups

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

Line 412: hr_api.mandatory_arg_error(p_api_name => l_proc

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

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

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