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_QSV_BUS dependencies on HR_QUEST_FIELDS

Line 15: g_questionnaire_template_id hr_quest_fields.questionnaire_template_id%TYPE;

11: -- return_legislation_code function.
12: --
13: g_legislation_code varchar2(150) default null;
14: g_quest_answer_val_id number default null;
15: g_questionnaire_template_id hr_quest_fields.questionnaire_template_id%TYPE;
16: --
17:
18: -- ----------------------------------------------------------------------------
19: -- |------------------------< chk_non_updateable_args >-----------------------|

Line 131: l_questionnaire_template_id hr_quest_fields.questionnaire_template_id%TYPE;

127: --
128: l_proc varchar2(72) := g_package || 'chk_field_id';
129: l_exists varchar2(1);
130: l_qsa_qu_temp_id hr_quest_answers.questionnaire_template_id%TYPE;
131: l_questionnaire_template_id hr_quest_fields.questionnaire_template_id%TYPE;
132: --
133: -- Cursor to check that field_id exists in HR_QUEST_FIELDS
134: --
135: cursor csr_id_exists is

Line 133: -- Cursor to check that field_id exists in HR_QUEST_FIELDS

129: l_exists varchar2(1);
130: l_qsa_qu_temp_id hr_quest_answers.questionnaire_template_id%TYPE;
131: l_questionnaire_template_id hr_quest_fields.questionnaire_template_id%TYPE;
132: --
133: -- Cursor to check that field_id exists in HR_QUEST_FIELDS
134: --
135: cursor csr_id_exists is
136: select qsf.questionnaire_template_id
137: from hr_quest_fields qsf

Line 137: from hr_quest_fields qsf

133: -- Cursor to check that field_id exists in HR_QUEST_FIELDS
134: --
135: cursor csr_id_exists is
136: select qsf.questionnaire_template_id
137: from hr_quest_fields qsf
138: where qsf.field_id = p_field_id;
139: --
140: -- Cursor to determine if id is unique for the given questionnaire_answer_id
141: --

Line 157: -- determine if id exists in HR_QUEST_FIELDS

153: -- Error, as this is mandatory
154: fnd_message.set_name('PER','PER_52447_QSV_MAND_FIELD_ID');
155: fnd_message.raise_error;
156: else
157: -- determine if id exists in HR_QUEST_FIELDS
158: open csr_id_exists;
159: fetch csr_id_exists into l_questionnaire_template_id;
160: if csr_id_exists%NOTFOUND then
161: -- Id does not exist, so error.