[Home] [Help]
PACKAGE: APPS.HR_QUEST_FIELDS_API
Source
1 Package hr_quest_fields_api as
2 /* $Header: hrqsfapi.pkh 120.0 2005/05/31 02:27:13 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< insert_quest_fields >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:This procedure is the API wrapper procedure to the following
10 --
11 -- RHI: hr_qsf_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_field_id will contain newly generated one or surrogate value.
20 -- p_object_version_number will contain newly modified OVN.
21 --
22 --
23 -- Post Failure:
24 --
25 -- p_field_id will contain null
26 -- p_object_version_number will contain null
27 --
28 --
29 -- Access Status:
30 --
31 -- Internal Development use only.
32 --
33 -- {End of comments}
34 --
35
36 procedure insert_quest_fields
37 ( p_validate in boolean default false
38 ,p_effective_date in date
39 ,p_questionnaire_template_id in number
40 ,p_name in varchar2
41 ,p_type in varchar2
42 ,p_sql_required_flag in varchar2
43 ,p_html_text in varchar2
44 ,p_sql_text in varchar2 default null
45 ,p_field_id out nocopy number
46 ,p_object_version_number out nocopy number
47 );
48
49 --
50 -- ----------------------------------------------------------------------------
51 -- |--------------------------< update_quest_fields >--------------------------|
52 -- ----------------------------------------------------------------------------
53 -- {Start Of Comments}
54 --
55 -- Description:This procedure is the API wrapper procedure to the following
56 --
57 -- RHI: hr_qsf_upd.upd
58 --
59 -- Pre-requisites
60 --
61 -- All 'IN' parameters to this procedure have been appropriately derived.
62 --
63 -- Post Success:
64 --
65 -- p_object_version_number will contain newly modified OVN.
66 --
67 --
68 -- Post Failure:
69 --
70 -- p_object_version_number will contain unmodified OVN.
71 --
72 --
73 -- Access Status:
74 --
75 -- Internal Development use only.
76 --
77 -- {End of comments}
78 --
79
80 procedure update_quest_fields
81 (p_validate in boolean default false
82 ,p_effective_date in date
83 ,p_field_id in number
84 ,p_object_version_number in out nocopy number
85 ,p_questionnaire_template_id in number default hr_api.g_number
86 ,p_name in varchar2 default hr_api.g_varchar2
87 ,p_type in varchar2 default hr_api.g_varchar2
88 ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
89 ,p_html_text in varchar2 default hr_api.g_varchar2
90 ,p_sql_text in varchar2 default hr_api.g_varchar2
91 );
92
93 --
94 -- ----------------------------------------------------------------------------
95 -- |--------------------------< delete_quest_fields >--------------------------|
96 -- ----------------------------------------------------------------------------
97 -- {Start Of Comments}
98 --
99 -- Description:This procedure is the API wrapper procedure to the following
100 --
101 -- RHI: hr_qsf_del.del
102 --
103 -- Pre-requisites
104 --
105 -- All 'IN' parameters to this procedure have been appropriately derived.
106 --
107 -- Post Success:
108 --
109 --
110 --
111 -- Post Failure:
112 --
113 --
114 --
115 -- Access Status:
116 --
117 -- Internal Development use only.
118 --
119 -- {End of comments}
120 --
121
122 procedure delete_quest_fields
123 (p_validate in boolean default false
124 ,p_field_id in number
125 ,p_object_version_number in number
126 );
127 --
128 end hr_quest_fields_api;