4 -- ----------------------------------------------------------------------------
1 Package ben_ext_where_clause_api AUTHID CURRENT_USER as
2 /* $Header: bexwcapi.pkh 120.1 2005/10/11 06:34:58 rbingi noship $ */
3 --
5 -- |------------------------< create_ext_where_clause >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_seq_num No number
18 -- p_oper_cd No varchar2
19 -- p_val No varchar2
20 -- p_and_or_cd No varchar2
21 -- p_ext_data_elmt_id Yes number
22 -- p_cond_ext_data_elmt_id No number
23 -- p_ext_rcd_in_file_id No number
24 -- p_ext_data_elmt_in_rcd_id No number
25 -- p_business_group_id Yes number Business Group of Record
26 -- p_legislation_code No varchar2 Legislation Code
27 -- p_cond_ext_data_elmt_in_rcd_id No number
28 -- p_effective_date Yes date Session Date.
29 --
30 -- Post Success:
31 --
32 -- Out Parameters:
33 -- Name Type Description
34 -- p_ext_where_clause_id Yes number PK of record
35 -- p_object_version_number No number OVN of record
36 --
37 -- Post Failure:
38 --
39 -- Access Status:
40 -- Public.
41 --
42 -- {End Of Comments}
43 --
44 procedure create_ext_where_clause
45 (
46 p_validate in boolean default false
47 ,p_ext_where_clause_id out nocopy number
48 ,p_seq_num in number default null
49 ,p_oper_cd in varchar2 default null
50 ,p_val in varchar2 default null
51 ,p_and_or_cd in varchar2 default null
52 ,p_ext_data_elmt_id in number default null
53 ,p_cond_ext_data_elmt_id in number default null
54 ,p_ext_rcd_in_file_id in number default null
55 ,p_ext_data_elmt_in_rcd_id in number default null
56 ,p_business_group_id in number default null
57 ,p_legislation_code in varchar2 default null
58 ,p_object_version_number out nocopy number
59 ,p_cond_ext_data_elmt_in_rcd_id in number default null
60 ,p_effective_date in date
61 );
62 -- ----------------------------------------------------------------------------
63 -- |------------------------< update_ext_where_clause >------------------------|
64 -- ----------------------------------------------------------------------------
65 -- {Start Of Comments}
66 --
67 -- Description:
68 --
69 -- Prerequisites:
70 --
71 --
72 -- In Parameters:
73 -- Name Reqd Type Description
74 -- p_validate Yes boolean Commit or Rollback.
75 -- p_ext_where_clause_id Yes number PK of record
76 -- p_seq_num No number
77 -- p_oper_cd No varchar2
78 -- p_val No varchar2
79 -- p_and_or_cd No varchar2
80 -- p_ext_data_elmt_id Yes number
81 -- p_cond_ext_data_elmt_id No number
82 -- p_ext_rcd_in_file_id No number
83 -- p_ext_data_elmt_in_rcd_id No number
84 -- p_business_group_id Yes number Business Group of Record
85 -- p_legislation_code No varchar2 Legislation Code
86 -- p_cond_ext_data_elmt_in_rcd_id No number
87 -- p_effective_date Yes date Session Date.
88 --
89 -- Post Success:
90 --
91 -- Name Type Description
92 -- p_object_version_number No number OVN of record
93 --
94 -- Post Failure:
95 --
96 -- Access Status:
97 -- Public.
98 --
99 -- {End Of Comments}
100 --
101 procedure update_ext_where_clause
102 (
103 p_validate in boolean default false
104 ,p_ext_where_clause_id in number
105 ,p_seq_num in number default hr_api.g_number
106 ,p_oper_cd in varchar2 default hr_api.g_varchar2
107 ,p_val in varchar2 default hr_api.g_varchar2
108 ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109 ,p_ext_data_elmt_id in number default hr_api.g_number
110 ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111 ,p_ext_rcd_in_file_id in number default hr_api.g_number
112 ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113 ,p_business_group_id in number default hr_api.g_number
114 ,p_legislation_code in varchar2 default hr_api.g_varchar2
115 ,p_object_version_number in out nocopy number
116 ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
117 ,p_effective_date in date
118 );
119 --
120 -- ----------------------------------------------------------------------------
124 --
121 -- |------------------------< delete_ext_where_clause >------------------------|
122 -- ----------------------------------------------------------------------------
123 -- {Start Of Comments}
125 -- Description:
126 --
127 -- Prerequisites:
128 --
129 --
130 -- In Parameters:
131 -- Name Reqd Type Description
132 -- p_validate Yes boolean Commit or Rollback.
133 -- p_ext_where_clause_id Yes number PK of record
134 -- p_effective_date Yes date Session Date.
135 -- p_legislation_code No varchar2 Legislation Code
136 --
137 -- Post Success:
138 --
139 -- Name Type Description
140 -- p_object_version_number No number OVN of record
141 --
142 -- Post Failure:
143 --
144 -- Access Status:
145 -- Public.
146 --
147 -- {End Of Comments}
148 --
149 procedure delete_ext_where_clause
150 (
151 p_validate in boolean default false
152 ,p_ext_where_clause_id in number
153 ,p_legislation_code in varchar2 default null
154 ,p_object_version_number in out nocopy number
155 ,p_effective_date in date
156 );
157 --
158 -- ----------------------------------------------------------------------------
159 -- |----------------------------------< lck >---------------------------------|
160 -- ----------------------------------------------------------------------------
161 -- {Start Of Comments}
162 --
163 -- Description:
164 --
165 -- Prerequisites:
166 --
167 --
168 -- In Parameters:
169 -- Name Reqd Type Description
170 -- p_ext_where_clause_id Yes number PK of record
171 -- p_object_version_number Yes number OVN of record
172 --
173 -- Post Success:
174 --
175 -- Name Type Description
176 --
177 -- Post Failure:
178 --
179 -- Access Status:
180 -- Public.
181 --
182 -- {End Of Comments}
183 --
184 procedure lck
185 (
186 p_ext_where_clause_id in number
187 ,p_object_version_number in number
188 );
189 --
190 procedure multi_rows_edit
191 (p_business_group_id in number
192 ,p_legislation_code in varchar2
193 ,p_ext_rcd_in_file_id in number
194 ,p_ext_data_elmt_in_rcd_id in number
195 ,p_ext_data_elmt_id in number);
196 --
197 end ben_ext_where_clause_api;