1 Package hr_questionnaire_api AUTHID CURRENT_USER as
2 /* $Header: hrqsnapi.pkh 120.1.12020000.2 2013/01/07 06:38:34 venksund ship $ */
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_quest_type_code in varchar2
42 ,p_effective_date in date
43 ,p_questionnaire_template_id out nocopy number
44 ,p_object_version_number out nocopy number
45 );
46
47
48 --
49 -- ----------------------------------------------------------------------------
50 -- |--------------------------< update_questionnaire >--------------------------|
51 -- ----------------------------------------------------------------------------
52 -- {Start Of Comments}
53 --
54 -- Description:This procedure is the API wrapper procedure to the following
55 --
56 -- RHI: hr_qsn_upd.upd
57 --
58 -- Pre-requisites
59 --
60 -- All 'IN' parameters to this procedure have been appropriately derived.
61 --
62 -- Post Success:
63
64 -- p_object_version_number will contain latest OVN.
65 --
66 -- Post Failure:
67
68 -- p_object_version_number with the old one.
69 --
70 -- Access Status:
71 --
72 -- Internal Development use only.
73 --
74 -- {End of comments}
75 --
76
77 procedure update_questionnaire
78 (
79 p_validate in boolean default false
80 ,p_questionnaire_template_id in number
81 ,p_object_version_number in out nocopy number
82 ,p_quest_type_code in varchar2
83 ,p_effective_date in date
84 ,p_name in varchar2 default hr_api.g_varchar2
85 ,p_available_flag in varchar2 default hr_api.g_varchar2
86 ,p_business_group_id in number default hr_api.g_number
87 ,p_text in CLOB
88 );
89
90 --
91 -- ----------------------------------------------------------------------------
92 -- |--------------------------< delete_questionnaire> >--------------------------|
93 -- ----------------------------------------------------------------------------
94 -- {Start Of Comments}
95 --
96 -- Description:This procedure is the API wrapper procedure to the following
97 --
98 -- RHI: hr_qsn_del.del
99 --
100 -- Pre-requisites
101 --
102 -- All 'IN' parameters to this procedure have been appropriately derived.
103 --
104 -- Post Success:
105 --
106 --
107 -- Post Failure:
108 --
109 --
110 -- Access Status:
111 --
112 -- Internal Development use only.
113 --
114 -- {End of comments}
115 --
116
117 procedure delete_questionnaire
118 (
119 p_validate in boolean default false
120 ,p_questionnaire_template_id in number
121 ,p_object_version_number in number
122 );
123
124 end hr_questionnaire_api;