APPS.HR_QSV_BUS dependencies on HR_QSV_SHD

Line 23: (p_rec in hr_qsv_shd.g_rec_type

19: -- |------------------------< chk_non_updateable_args >-----------------------|
20: -- ----------------------------------------------------------------------------
21: --
22: Procedure chk_non_updateable_args
23: (p_rec in hr_qsv_shd.g_rec_type
24: )
25: is
26: --
27: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';

Line 38: if not hr_qsv_shd.api_updating

34: --
35: -- Only proceed with validation if a row exists for the
36: -- current record in the HR Schema.
37: --
38: if not hr_qsv_shd.api_updating
39: (p_quest_answer_val_id => p_rec.quest_answer_val_id
40: ,p_object_version_number => p_rec.object_version_number
41: ) then
42: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');

Line 50: <> hr_qsv_shd.g_old_rec.questionnaire_answer_id then

46: end if;
47: hr_utility.set_location(l_proc, 30);
48: --
49: if nvl(p_rec.questionnaire_answer_id, hr_api.g_number)
50: <> hr_qsv_shd.g_old_rec.questionnaire_answer_id then
51: l_argument := 'questionnaire_answer_id';
52: raise l_error;
53: end if;
54: hr_utility.set_location(l_proc, 40);

Line 56: if nvl(p_rec.field_id, hr_api.g_number) <> hr_qsv_shd.g_old_rec.field_id then

52: raise l_error;
53: end if;
54: hr_utility.set_location(l_proc, 40);
55: --
56: if nvl(p_rec.field_id, hr_api.g_number) <> hr_qsv_shd.g_old_rec.field_id then
57: l_argument := 'field_id';
58: raise l_error;
59: end if;
60: hr_utility.set_location('Leaving: '||l_proc,50);

Line 108: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK1');

104: fetch csr_id_exists into g_questionnaire_template_id;
105: if csr_id_exists%NOTFOUND then
106: -- id doent exist, so error.
107: close csr_id_exists;
108: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK1');
109: end if;
110: close csr_id_exists;
111: end if;
112: --

Line 163: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK2');

159: fetch csr_id_exists into l_questionnaire_template_id;
160: if csr_id_exists%NOTFOUND then
161: -- Id does not exist, so error.
162: close csr_id_exists;
163: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK2');
164: end if;
165: close csr_id_exists;
166: --
167: hr_utility.set_location(l_proc,20);

Line 176: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_UK1');

172: fetch csr_chk_unique into l_exists;
173: if csr_chk_unique%FOUND then
174: -- field_id is not unique, so error
175: close csr_chk_unique;
176: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_UK1');
177: end if;
178: close csr_chk_unique;
179: --
180: hr_utility.set_location(l_proc,30);

Line 224: Procedure insert_validate(p_rec in hr_qsv_shd.g_rec_type) is

220: --
221: -- ----------------------------------------------------------------------------
222: -- |---------------------------< insert_validate >----------------------------|
223: -- ----------------------------------------------------------------------------
224: Procedure insert_validate(p_rec in hr_qsv_shd.g_rec_type) is
225: --
226: l_proc varchar2(72) := g_package||'insert_validate';
227: --
228: Begin

Line 259: Procedure update_validate(p_rec in hr_qsv_shd.g_rec_type) is

255: --
256: -- ----------------------------------------------------------------------------
257: -- |---------------------------< update_validate >----------------------------|
258: -- ----------------------------------------------------------------------------
259: Procedure update_validate(p_rec in hr_qsv_shd.g_rec_type) is
260: --
261: l_proc varchar2(72) := g_package||'update_validate';
262: --
263: Begin

Line 288: Procedure delete_validate(p_rec in hr_qsv_shd.g_rec_type) is

284: --
285: -- ----------------------------------------------------------------------------
286: -- |---------------------------< delete_validate >----------------------------|
287: -- ----------------------------------------------------------------------------
288: Procedure delete_validate(p_rec in hr_qsv_shd.g_rec_type) is
289: --
290: l_proc varchar2(72) := g_package||'delete_validate';
291: --
292: Begin

Line 298: (p_value => hr_qsv_shd.g_old_rec.value);

294: --
295: -- Call all supporting business operations
296: --
297: chk_delete_allowed
298: (p_value => hr_qsv_shd.g_old_rec.value);
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: End delete_validate;
302: --