1 Package hr_questionnaire_api as
2 /* $Header: hrqsnapi.pkh 120.1 2005/09/09 02:11:47 pveerepa noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_questionnaire >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:This procedure is the API wrapper procedure to the following
10 --
11 -- RHI: hr_qsn_ins.ins
12 --
13 -- Pre-requisites
14 --
15 -- All 'IN' parameters to this procedure have been appropriately derived.
16 --
17 -- Post Success:
18 --
19 -- p_object_version_number will have the latest OVN.
20 -- p_questionnaire_template_id with have the newly generated and passed surrogate value.
21 --
22 -- Post Failure:
23 --
24 -- p_object_version_number will be null.
25 -- p_questionnaire_template_id with be null.
26 --
27 --
28 -- Access Status:
29 --
30 -- Internal Development use only.
31 --
32 -- {End of comments}
33 --
34 procedure create_questionnaire
35 (
36 p_validate in boolean default false
37 ,p_name in varchar2
38 ,p_available_flag in varchar2
39 ,p_business_group_id in number
40 ,p_text in CLOB
41 ,p_effective_date in date
42 ,p_questionnaire_template_id out nocopy number
43 ,p_object_version_number out nocopy number
44 );
45
46
47 --
48 -- ----------------------------------------------------------------------------
49 -- |--------------------------< update_questionnaire >--------------------------|
50 -- ----------------------------------------------------------------------------
51 -- {Start Of Comments}
52 --
53 -- Description:This procedure is the API wrapper procedure to the following
54 --
55 -- RHI: hr_qsn_upd.upd
56 --
57 -- Pre-requisites
58 --
59 -- All 'IN' parameters to this procedure have been appropriately derived.
60 --
61 -- Post Success:
62
63 -- p_object_version_number will contain latest OVN.
64 --
65 -- Post Failure:
66
67 -- p_object_version_number with the old one.
68 --
69 -- Access Status:
70 --
71 -- Internal Development use only.
72 --
73 -- {End of comments}
74 --
75
76 procedure update_questionnaire
77 (
78 p_validate in boolean default false
79 ,p_questionnaire_template_id in number
80 ,p_object_version_number in out nocopy number
81 ,p_effective_date in date
82 ,p_name in varchar2 default hr_api.g_varchar2
83 ,p_available_flag in varchar2 default hr_api.g_varchar2
84 ,p_business_group_id in number default hr_api.g_number
85 ,p_text in CLOB
86 );
87
88 --
89 -- ----------------------------------------------------------------------------
90 -- |--------------------------< delete_questionnaire> >--------------------------|
91 -- ----------------------------------------------------------------------------
92 -- {Start Of Comments}
93 --
94 -- Description:This procedure is the API wrapper procedure to the following
95 --
96 -- RHI: hr_qsn_del.del
97 --
98 -- Pre-requisites
99 --
100 -- All 'IN' parameters to this procedure have been appropriately derived.
101 --
102 -- Post Success:
103 --
104 --
105 -- Post Failure:
106 --
107 --
108 -- Access Status:
109 --
110 -- Internal Development use only.
111 --
112 -- {End of comments}
113 --
114
115 procedure delete_questionnaire
116 (
117 p_validate in boolean default false
118 ,p_questionnaire_template_id in number
119 ,p_object_version_number in number
120 );
121
122 end hr_questionnaire_api;