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