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_QSA_BUS dependencies on HR_QUEST_ANSWERS

Line 22: (p_questionnaire_answer_id in hr_quest_answers.questionnaire_answer_id%TYPE

18: -- |------------------------< set_security_group_id >-------------------------|
19: -- ----------------------------------------------------------------------------
20: --
21: procedure set_security_group_id
22: (p_questionnaire_answer_id in hr_quest_answers.questionnaire_answer_id%TYPE
23: ) is
24: --
25: -- Declare cursor
26: --

Line 30: , hr_quest_answers qsa

26: --
27: cursor csr_sec_grp is
28: select inf.org_information14
29: from hr_organization_information inf
30: , hr_quest_answers qsa
31: where qsa.questionnaire_answer_id = p_questionnaire_answer_id
32: and inf.organization_id = qsa.business_group_id
33: and inf.org_information_context || '' = 'Business Group Information';
34: --

Line 102: HR_QUEST_ANSWERS.questionnaire_template_id%TYPE

98: -- Internal Row Handler Use Only.
99: --
100: procedure chk_questionnaire_template_id
101: (p_questionnaire_template_id in
102: HR_QUEST_ANSWERS.questionnaire_template_id%TYPE
103: ,p_type in
104: HR_QUEST_ANSWERS.type%TYPE
105: ,p_type_object_id in
106: HR_QUEST_ANSWERS.type_object_id%TYPE

Line 104: HR_QUEST_ANSWERS.type%TYPE

100: procedure chk_questionnaire_template_id
101: (p_questionnaire_template_id in
102: HR_QUEST_ANSWERS.questionnaire_template_id%TYPE
103: ,p_type in
104: HR_QUEST_ANSWERS.type%TYPE
105: ,p_type_object_id in
106: HR_QUEST_ANSWERS.type_object_id%TYPE
107: ,p_business_group_id in
108: HR_QUEST_ANSWERS.business_group_id%TYPE

Line 106: HR_QUEST_ANSWERS.type_object_id%TYPE

102: HR_QUEST_ANSWERS.questionnaire_template_id%TYPE
103: ,p_type in
104: HR_QUEST_ANSWERS.type%TYPE
105: ,p_type_object_id in
106: HR_QUEST_ANSWERS.type_object_id%TYPE
107: ,p_business_group_id in
108: HR_QUEST_ANSWERS.business_group_id%TYPE
109: )
110: is

Line 108: HR_QUEST_ANSWERS.business_group_id%TYPE

104: HR_QUEST_ANSWERS.type%TYPE
105: ,p_type_object_id in
106: HR_QUEST_ANSWERS.type_object_id%TYPE
107: ,p_business_group_id in
108: HR_QUEST_ANSWERS.business_group_id%TYPE
109: )
110: is
111: --
112: l_proc varchar2(72) := 'chk_questionnaire_template_id';

Line 114: l_bus_grp_id HR_QUEST_ANSWERS.business_group_id%TYPE;

110: is
111: --
112: l_proc varchar2(72) := 'chk_questionnaire_template_id';
113: l_exists varchar2(1);
114: l_bus_grp_id HR_QUEST_ANSWERS.business_group_id%TYPE;
115: --
116: -- Cursor to determins if questionnaire_template_id exists in
117: -- HR_QUESTIONNAIRES.
118: --

Line 155: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_FK1');

151: fetch csr_id_exists into l_bus_grp_id;
152: if csr_id_exists%NOTFOUND then
153: -- questionnaire_template_id doesnt exist in hr_questionnaires
154: close csr_id_exists;
155: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_FK1');
156: end if;
157: close csr_id_exists;
158: --
159: hr_utility.set_location(l_proc,30);

Line 215: (p_type in HR_QUEST_ANSWERS.TYPE%TYPE

211: -- ----------------------------------------------------------------------------
212: -- |--------------------------< chk_type >------------------------------------|
213: -- ----------------------------------------------------------------------------
214: procedure chk_type
215: (p_type in HR_QUEST_ANSWERS.TYPE%TYPE
216: ,p_effective_date in date
217: )
218: is
219: --

Line 250: (p_type_object_id in HR_QUEST_ANSWERS.type_object_id%TYPE

246: -- ----------------------------------------------------------------------------
247: -- |----------------------< chk_type_object_id >------------------------------|
248: -- ----------------------------------------------------------------------------
249: procedure chk_type_object_id
250: (p_type_object_id in HR_QUEST_ANSWERS.type_object_id%TYPE
251: ,p_type in HR_QUEST_ANSWERS.type%TYPE
252: ,p_business_group_id in HR_QUEST_ANSWERS.business_group_id%TYPE
253: )
254: is

Line 251: ,p_type in HR_QUEST_ANSWERS.type%TYPE

247: -- |----------------------< chk_type_object_id >------------------------------|
248: -- ----------------------------------------------------------------------------
249: procedure chk_type_object_id
250: (p_type_object_id in HR_QUEST_ANSWERS.type_object_id%TYPE
251: ,p_type in HR_QUEST_ANSWERS.type%TYPE
252: ,p_business_group_id in HR_QUEST_ANSWERS.business_group_id%TYPE
253: )
254: is
255: --

Line 252: ,p_business_group_id in HR_QUEST_ANSWERS.business_group_id%TYPE

248: -- ----------------------------------------------------------------------------
249: procedure chk_type_object_id
250: (p_type_object_id in HR_QUEST_ANSWERS.type_object_id%TYPE
251: ,p_type in HR_QUEST_ANSWERS.type%TYPE
252: ,p_business_group_id in HR_QUEST_ANSWERS.business_group_id%TYPE
253: )
254: is
255: --
256: l_proc varchar2(72):= g_package || 'chk_type_object_id';

Line 257: l_bus_grp_id HR_QUEST_ANSWERS.business_group_id%TYPE;

253: )
254: is
255: --
256: l_proc varchar2(72):= g_package || 'chk_type_object_id';
257: l_bus_grp_id HR_QUEST_ANSWERS.business_group_id%TYPE;
258: l_part_in_tab PER_PARTICIPANTS.participation_in_table%TYPE;
259: l_part_in_col PER_PARTICIPANTS.participation_in_column%TYPE;
260: l_exists varchar2(1);
261: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix

Line 284: from hr_quest_answers qsa

280: -- for the given type.
281: --
282: cursor csr_unique_id is
283: select null
284: from hr_quest_answers qsa
285: where qsa.type_object_id = p_type_object_id
286: and qsa.type = p_type;
287: begin
288: --

Line 301: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_UK1');

297: open csr_unique_id;
298: fetch csr_unique_id into l_exists;
299: if csr_unique_id%FOUND then
300: close csr_unique_id;
301: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_UK1');
302: end if;
303: close csr_unique_id;
304: --
305: hr_utility.set_location(l_proc,20);

Line 387: in hr_quest_answers.questionnaire_answer_id%TYPE

383: -- |-------------------------< chk_row_delete >-------------------------------|
384: -- ----------------------------------------------------------------------------
385: procedure chk_row_delete
386: (p_questionnaire_answer_id
387: in hr_quest_answers.questionnaire_answer_id%TYPE
388: )
389: is
390: --
391: l_proc varchar2(72) := g_package || 'chk_row_delete';

Line 502: (p_questionnaire_answer_id in hr_quest_answers.questionnaire_answer_id%TYPE

498: -- |--------------------< return_legislation_code >---------------------------|
499: -- ----------------------------------------------------------------------------
500: --
501: function return_legislation_code
502: (p_questionnaire_answer_id in hr_quest_answers.questionnaire_answer_id%TYPE
503: ) return varchar2 is
504: --
505: -- Cursor to find legislation code
506: --

Line 510: , hr_quest_answers qsa

506: --
507: cursor csr_leg_code is
508: select pbg.legislation_code
509: from per_business_groups pbg
510: , hr_quest_answers qsa
511: where qsa.questionnaire_answer_id = p_questionnaire_answer_id
512: and pbg.business_group_id = qsa.business_group_id;
513: --
514: -- Declare local variables