1 PACKAGE HR_QUESTIONNAIRE_SWI AS
2 /* $Header: hrqstswi.pkh 120.1 2005/09/09 02:12:27 pveerepa noship $ */
3
4 /*
5 Procedure update_questionnaire_recs
6 (p_effective_date IN DATE
7 ,p_quest_tbl IN OUT NOCOPY HR_QUEST_TABLE
8 ,p_error_message OUT NOCOPY LONG
9 ,p_status OUT NOCOPY VARCHAR2);
10 */
11 -- ----------------------------------------------------------------------------
12 -- |---------------------------< update_questionnaire >-----------------------|
13 -- ----------------------------------------------------------------------------
14 -- {Start of comments}
15 --
16 -- Description:
17 -- This procedure is the self-service wrapper procedure to the following
18 -- API: hr_questionnaire_api.update_questionnaire
19 --
20 -- Pre-requisites
21 -- All 'IN' parameters to this procedure have been appropriately derived.
22 --
23 -- Post Success:
24 -- p_return_status will return value indicating success.
25 --
26 -- Post Failure:
27 -- p_return_status will return value indication failure.
28 --
29 -- Access Status:
30 -- Internal Development use only.
31 --
32 -- {End of comments}
33
34 Procedure update_questionnaire
35 (p_questionnaire_template_id in number
36 ,p_object_version_number in out nocopy number
37 ,p_text in CLOB
38 ,p_available_flag in varchar2 default hr_api.g_varchar2
39 ,p_business_group_id in number default hr_api.g_number
40 ,p_effective_date in date default hr_api.g_date
41 ,p_validate in number default hr_api.g_false_num
42 ,p_return_status out nocopy varchar2);
43
44 -- ----------------------------------------------------------------------------
45 -- |-------------------------< delete_questionnaire >--------------------------|
46 -- ----------------------------------------------------------------------------
47 -- {Start of comments}
48 --
49 -- Description:
50 -- This procedure is the self-service wrapper procedure to the following
51 -- API: hr_questionnaire_api.delete_questionnaire
52 --
53 -- Pre-requisites
54 -- All 'IN' parameters to this procedure have been appropriately derived.
55 --
56 -- Post Success:
57 -- p_return_status will return value indicating success.
58 --
59 -- Post Failure:
60 -- p_return_status will return value indication failure.
61 --
62 -- Access Status:
63 -- Internal Development use only.
64 --
65 -- {End of comments}
66
67 Procedure delete_questionnaire
68 (p_questionnaire_template_id in number
69 ,p_object_version_number in number
70 ,p_validate in number default hr_api.g_false_num
71 ,p_return_status out nocopy varchar2);
72
73 -- ----------------------------------------------------------------------------
74 -- |--------------------------< create_questionnaire >------------------------|
75 -- ----------------------------------------------------------------------------
76 -- {Start of comments}
77 --
78 -- Description:
79 -- This procedure is the self-service wrapper procedure to the following
80 -- API: hr_questionnaire_api.create_questionnaire
81 --
82 -- Pre-requisites
83 -- All 'IN' parameters to this procedure have been appropriately derived.
84 --
85 -- Post Success:
86 -- p_return_status will return value indicating success.
87 --
88 -- Post Failure:
89 -- p_return_status will return value indication failure.
90 --
91 -- Access Status:
92 -- Internal Development use only.
93 --
94 -- {End of comments}
95
96 Procedure create_questionnaire
97 (p_questionnaire_template_id in number
98 ,p_name in varchar2
99 ,p_text in CLOB
100 ,p_available_flag in varchar2
101 ,p_business_group_id in number
102 ,p_object_version_number out nocopy number
103 ,p_effective_date in date default hr_api.g_date
104 ,p_validate in number default hr_api.g_false_num
105 ,p_return_status out nocopy varchar2);
106
107
108 END HR_QUESTIONNAIRE_SWI;