1 Package hr_quest_answer_swi As
2 /* $Header: hrqsaswi.pkh 120.0 2005/05/31 02:26:48 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< create_quest_answer >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_quest_answer_api.create_quest_answer
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25
26 -- ----------------------------------------------------------------------------
27 PROCEDURE create_quest_answer
28 (p_questionnaire_answer_id in number
29 ,p_questionnaire_template_id in number
30 ,p_type in varchar2
31 ,p_type_object_id in number
32 ,p_business_group_id in number
33 ,p_effective_date in date
34 ,p_validate in number default hr_api.g_false_num
35 ,p_return_status out nocopy varchar2
36 );
37 -- ----------------------------------------------------------------------------
38 -- |--------------------------< set_base_key_value >--------------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start of comments}
41 --
42 -- Description:
43 -- This procedure is the self-service wrapper procedure to the following
44 -- API: hr_qsa_ins.set_base_key_value
45 --
46 -- Pre-requisites
47 -- All 'IN' parameters to this procedure have been appropriately derived.
48 --
49 -- Post Success:
50 -- p_return_status will return value indicating success.
51 --
52 -- Post Failure:
53 -- p_return_status will return value indication failure.
54 --
55 -- Access Status:
56 -- Internal Development use only.
57 --
58 -- {End of comments}
59 -- ----------------------------------------------------------------------------
60 PROCEDURE set_base_key_value
61 (p_questionnaire_answer_id in number
62 ,p_return_status out nocopy varchar2
63 );
64 --
65 -- ----------------------------------------------------------------------------
66 -- |-------------------------< update_quest_answer >--------------------------|
67 -- ----------------------------------------------------------------------------
68 -- {Start of comments}
69 --
70 -- Description:
71 -- This procedure is the self-service wrapper procedure to the following
72 -- API: hr_quest_answer_api.update_quest_answer
73 --
74 -- Pre-requisites
75 -- All 'IN' parameters to this procedure have been appropriately derived.
76 --
77 -- Post Success:
78 -- p_return_status will return value indicating success.
79 --
80 -- Post Failure:
81 -- p_return_status will return value indication failure.
82 --
83 -- Access Status:
84 -- Internal Development use only.
85 --
86 -- {End of comments}
87 -- ----------------------------------------------------------------------------
88 PROCEDURE update_quest_answer
89 (p_questionnaire_answer_id in number
90 ,p_questionnaire_template_id in number default hr_api.g_number
91 ,p_type in varchar2 default hr_api.g_varchar2
92 ,p_type_object_id in number default hr_api.g_number
93 ,p_business_group_id in number default hr_api.g_number
94 ,p_effective_date in date
95 ,p_validate in number default hr_api.g_false_num
96 ,p_return_status out nocopy varchar2
97 );
98 --
99 -- ----------------------------------------------------------------------------
100 -- |--------------------------< delete_quest_answer >-------------------------|
101 -- ----------------------------------------------------------------------------
102 -- {Start of comments}
103 --
104 -- Description:
105 -- This procedure is the self-service wrapper procedure to the following
106 -- API: hr_quest_answer_api.delete_quest_answer
107 --
108 -- Pre-requisites
109 -- All 'IN' parameters to this procedure have been appropriately derived.
110 --
111 -- Post Success:
112 -- p_return_status will return value indicating success.
113 --
114 -- Post Failure:
115 -- p_return_status will return value indication failure.
116 --
117 -- Access Status:
118 -- Internal Development use only.
119 --
120 -- {End of comments}
121 -- ----------------------------------------------------------------------------
122 PROCEDURE delete_quest_answer
123 (p_questionnaire_answer_id in number
124 ,p_validate in number default hr_api.g_false_num
125 ,p_return_status out nocopy varchar2
126 );
127
128 -- ----------------------------------------------------------------------------
129 -- |---------------------------< process_api >--------------------------------|
130 -- ----------------------------------------------------------------------------
131 -- {Start of comments}
132 --
133 -- Description:
134 -- This procedure is responsible for commiting data from transaction
135 -- table (hr_api_transaction_step_id) to the base table
136 --
137 -- Parameters:
138 -- p_document is the document having the data that needs to be committed
139 -- p_return_status is the return status after committing the date. In case of
140 -- any errors/warnings the p_return_status is populated with 'E' or 'W'
141 -- p_validate is the flag to indicate whether to rollback data or not
142 -- p_effective_date is the current effective date
143 --
144 -- Access Status:
145 -- Internal Development use only.
146 --
147 -- {End of comments}
148 -- ----------------------------------------------------------------------------
149
150 Procedure process_api
151 (
152 p_document in CLOB
153 ,p_return_status out nocopy VARCHAR2
154 ,p_validate in number default hr_api.g_false_num
155 ,p_effective_date in date default null
156 );
157
158 end hr_quest_answer_swi;