30: -- Internal Development Use Only.
31: --
32: -- {End Of Comments}
33: --
34: procedure set_security_group_id(p_questionnaire_answer_id in hr_quest_answers.questionnaire_answer_id%TYPE);
35: -- ----------------------------------------------------------------------------
36: -- |-------------------------< chk_type >-------------------------------------|
37: -- ----------------------------------------------------------------------------
38: --
61: -- Internal Development Use Only.
62: --
63: -- ----------------------------------------------------------------------------
64: procedure chk_type
65: (p_type in HR_QUEST_ANSWERS.TYPE%TYPE
66: ,p_effective_date in date
67: );
68: --
69: -- ----------------------------------------------------------------------------
102: -- Internal Development Use Only.
103: --
104: -- ----------------------------------------------------------------------------
105: procedure chk_type_object_id
106: (p_type_object_id in HR_QUEST_ANSWERS.type_object_id%TYPE
107: ,p_type in HR_QUEST_ANSWERS.type%TYPE
108: ,p_business_group_id in HR_QUEST_ANSWERS.business_group_id%TYPE
109: );
110: --
103: --
104: -- ----------------------------------------------------------------------------
105: procedure chk_type_object_id
106: (p_type_object_id in HR_QUEST_ANSWERS.type_object_id%TYPE
107: ,p_type in HR_QUEST_ANSWERS.type%TYPE
108: ,p_business_group_id in HR_QUEST_ANSWERS.business_group_id%TYPE
109: );
110: --
111: -- ----------------------------------------------------------------------------
104: -- ----------------------------------------------------------------------------
105: procedure chk_type_object_id
106: (p_type_object_id in HR_QUEST_ANSWERS.type_object_id%TYPE
107: ,p_type in HR_QUEST_ANSWERS.type%TYPE
108: ,p_business_group_id in HR_QUEST_ANSWERS.business_group_id%TYPE
109: );
110: --
111: -- ----------------------------------------------------------------------------
112: -- |------------------< chk_questionnaire_template_id >----------------------|
142: --
143: -- ----------------------------------------------------------------------------
144: procedure chk_questionnaire_template_id
145: (p_questionnaire_template_id in
146: HR_QUEST_ANSWERS.questionnaire_template_id%TYPE
147: ,p_type in
148: HR_QUEST_ANSWERS.type%TYPE
149: ,p_type_object_id in
150: HR_QUEST_ANSWERS.type_object_id%TYPE
144: procedure chk_questionnaire_template_id
145: (p_questionnaire_template_id in
146: HR_QUEST_ANSWERS.questionnaire_template_id%TYPE
147: ,p_type in
148: HR_QUEST_ANSWERS.type%TYPE
149: ,p_type_object_id in
150: HR_QUEST_ANSWERS.type_object_id%TYPE
151: ,p_business_group_id in
152: HR_QUEST_ANSWERS.business_group_id%TYPE
146: HR_QUEST_ANSWERS.questionnaire_template_id%TYPE
147: ,p_type in
148: HR_QUEST_ANSWERS.type%TYPE
149: ,p_type_object_id in
150: HR_QUEST_ANSWERS.type_object_id%TYPE
151: ,p_business_group_id in
152: HR_QUEST_ANSWERS.business_group_id%TYPE
153: );
154: --
148: HR_QUEST_ANSWERS.type%TYPE
149: ,p_type_object_id in
150: HR_QUEST_ANSWERS.type_object_id%TYPE
151: ,p_business_group_id in
152: HR_QUEST_ANSWERS.business_group_id%TYPE
153: );
154: --
155: -- ----------------------------------------------------------------------------
156: -- |------------------------< chk_row_delete >--------------------------------|
181: --
182: -- ----------------------------------------------------------------------------
183: procedure chk_row_delete
184: (p_questionnaire_answer_id
185: in hr_quest_answers.questionnaire_answer_id%TYPE
186: );
187: --
188: -- ----------------------------------------------------------------------------
189: -- |---------------------------< insert_validate >----------------------------|
295: -- |-----------------< return_legislation_code >------------------------------|
296: -- ----------------------------------------------------------------------------
297: --
298: function return_legislation_code
299: (p_questionnaire_answer_id in hr_quest_answers.questionnaire_answer_id%TYPE
300: ) return varchar2;
301: --
302: --
303: end hr_qsa_bus;