14: ,p_type in varchar2
15: ,p_type_object_id in number
16: ,p_business_group_id in number
17: ,p_effective_date in date
18: ,p_validate in number default hr_api.g_false_num
19: ,p_return_status out nocopy varchar2
20: ) is
21: --
22: -- Variables for API Boolean parameters
43: --
44: -- Convert constant values to their corresponding boolean value
45: --
46: l_validate :=
47: hr_api.constant_to_boolean
48: (p_constant_value => p_validate);
49: --
50: --
51: -- Register Surrogate ID or user key values
207: -- |-------------------------< update_quest_answer >--------------------------|
208: -- ----------------------------------------------------------------------------
209: PROCEDURE update_quest_answer
210: (p_questionnaire_answer_id in number
211: ,p_questionnaire_template_id in number default hr_api.g_number
212: ,p_type in varchar2 default hr_api.g_varchar2
213: ,p_type_object_id in number default hr_api.g_number
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_effective_date in date
208: -- ----------------------------------------------------------------------------
209: PROCEDURE update_quest_answer
210: (p_questionnaire_answer_id in number
211: ,p_questionnaire_template_id in number default hr_api.g_number
212: ,p_type in varchar2 default hr_api.g_varchar2
213: ,p_type_object_id in number default hr_api.g_number
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_effective_date in date
216: ,p_validate in number default hr_api.g_false_num
209: PROCEDURE update_quest_answer
210: (p_questionnaire_answer_id in number
211: ,p_questionnaire_template_id in number default hr_api.g_number
212: ,p_type in varchar2 default hr_api.g_varchar2
213: ,p_type_object_id in number default hr_api.g_number
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_effective_date in date
216: ,p_validate in number default hr_api.g_false_num
217: ,p_return_status out nocopy varchar2
210: (p_questionnaire_answer_id in number
211: ,p_questionnaire_template_id in number default hr_api.g_number
212: ,p_type in varchar2 default hr_api.g_varchar2
213: ,p_type_object_id in number default hr_api.g_number
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_effective_date in date
216: ,p_validate in number default hr_api.g_false_num
217: ,p_return_status out nocopy varchar2
218: ) is
212: ,p_type in varchar2 default hr_api.g_varchar2
213: ,p_type_object_id in number default hr_api.g_number
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_effective_date in date
216: ,p_validate in number default hr_api.g_false_num
217: ,p_return_status out nocopy varchar2
218: ) is
219: --
220: -- Variables for API Boolean parameters
240: --
241: -- Convert constant values to their corresponding boolean value
242: --
243: l_validate :=
244: hr_api.constant_to_boolean
245: (p_constant_value => p_validate);
246: --
247: -- Register Surrogate ID or user key values
248: --
313: -- |--------------------------< delete_quest_answer >-------------------------|
314: -- ----------------------------------------------------------------------------
315: PROCEDURE delete_quest_answer
316: (p_questionnaire_answer_id in number
317: ,p_validate in number default hr_api.g_false_num
318: ,p_return_status out nocopy varchar2
319: ) is
320: --
321: -- Variables for API Boolean parameters
341: --
342: -- Convert constant values to their corresponding boolean value
343: --
344: l_validate :=
345: hr_api.constant_to_boolean
346: (p_constant_value => p_validate);
347: --
348: -- Register Surrogate ID or user key values
349: --
412: Procedure process_api
413: (
414: p_document in CLOB
415: ,p_return_status out nocopy VARCHAR2
416: ,p_validate in number default hr_api.g_false_num
417: ,p_effective_date in date default null
418: )
419: IS
420: l_postState VARCHAR2(2);