1 Package ben_pl_extract_id_api as
2 /* $Header: bepeiapi.pkh 120.0 2005/05/28 10:33:31 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_pl_extract_id >------------------------|
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_pl_id No number
18 -- p_plip_id No number
19 -- p_oipl_id No number
20 -- p_third_party_identifier No varchar
21 -- p_organization_id No number
22 -- p_job_id No number
23 -- p_position_id No number
24 -- p_people_group_id No number
25 -- p_grade_id No number
26 -- p_payroll_id No number
27 -- p_home_state No varchar
28 -- p_home_zip No varchar
29 -- p_business_group_id No number
30 -- p_effective_date Yes date Session Date.
31 --
32 -- Post Success:
33 --
34 -- Out Parameters:
35 -- Name Type Description
36 -- p_pl_extract_identifier_id Yes number
37 -- p_effective_start_date Yes date Effective Start Date of Record
38 -- p_effective_end_date Yes date Effective End Date of Record
39 -- p_object_version_number No number OVN of record
40 --
41 -- Post Failure:
42 --
43 -- Access Status:
44 -- Public.
45 --
46 -- {End Of Comments}
47 --
48 procedure create_pl_extract_id
49 (
50 p_validate in boolean default false
51 ,p_pl_extract_identifier_id out nocopy number
52 ,p_effective_start_date out nocopy date
53 ,p_effective_end_date out nocopy date
54 ,p_pl_id in number default null
55 ,p_plip_id in number default null
56 ,p_oipl_id in number default null
57 ,p_third_party_identifier in varchar2 default null
58 ,p_organization_id in number default null
59 ,p_job_id in number default null
60 ,p_position_id in number default null
61 ,p_people_group_id in number default null
62 ,p_grade_id in number default null
63 ,p_payroll_id in number default null
64 ,p_home_state in varchar2 default null
65 ,p_home_zip in varchar2 default null
66 ,p_object_version_number out nocopy number
67 ,p_business_group_id in number default null
68 ,p_effective_date in date
69 );
70 -- ----------------------------------------------------------------------------
71 -- |-------------------------< update_pl_extract_id >-------------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 --
77 -- Prerequisites:
78 --
79 --
80 -- In Parameters:
81 -- Name Reqd Type Description
82 -- p_validate Yes boolean Commit or Rollback.
83 -- p_pl_extract_identifier_id Yes number
84 -- p_pl_id No number
85 -- p_plip_id No number
86 -- p_oipl_id No number
87 -- p_third_party_identifier No varchar
88 -- p_organization_id No number
89 -- p_job_id No number
90 -- p_position_id No number
91 -- p_people_group_id No number
92 -- p_grade_id No number
93 -- p_payroll_id No number
94 -- p_home_state No varchar
95 -- p_home_zip No varchar
96 -- p_object_version_number No number
97 -- p_business_group_id No number
98 -- p_effective_date Yes date Session Date.
99 -- p_datetrack_mode Yes varchar2 Datetrack mode.
100 --
101 -- Post Success:
102 --
103 -- Name Type Description
104 -- p_effective_start_date Yes date Effective Start Date of Record
105 -- p_effective_end_date Yes date Effective End Date of Record
106 -- p_object_version_number No number OVN of record
107 --
108 -- Post Failure:
109 --
110 -- Access Status:
111 -- Public.
112 --
113 -- {End Of Comments}
114 --
115 procedure update_pl_extract_id
116 (
117 p_validate in boolean default false
118 ,p_pl_extract_identifier_id in number
119 ,p_effective_start_date out nocopy date
120 ,p_effective_end_date out nocopy date
121 ,p_pl_id in number default hr_api.g_number
122 ,p_plip_id in number default hr_api.g_number
123 ,p_oipl_id in number default hr_api.g_number
124 ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
125 ,p_organization_id in number default hr_api.g_number
126 ,p_job_id in number default hr_api.g_number
127 ,p_position_id in number default hr_api.g_number
128 ,p_people_group_id in number default hr_api.g_number
129 ,p_grade_id in number default hr_api.g_number
130 ,p_payroll_id in number default hr_api.g_number
131 ,p_home_state in varchar2 default hr_api.g_varchar2
132 ,p_home_zip in varchar2 default hr_api.g_varchar2
133 ,p_object_version_number in out nocopy number
134 ,p_business_group_id in number default hr_api.g_number
135 ,p_effective_date in date
136 ,p_datetrack_mode in varchar2
137 );
138 --
139 -- ----------------------------------------------------------------------------
140 -- |-------------------------< delete_pl_extract_id >-------------------------|
141 -- ----------------------------------------------------------------------------
142 -- {Start Of Comments}
143 --
144 -- Description:
145 --
146 -- Prerequisites:
147 --
148 --
149 -- In Parameters:
150 -- Name Reqd Type Description
151 -- p_validate Yes boolean Commit or Rollback.
152 -- p_pl_extract_identifier_id Yes number
153 -- p_effective_date Yes date Session Date.
154 -- p_datetrack_mode Yes varchar2 Datetrack mode.
155 --
156 -- Post Success:
157 --
158 -- Name Type Description
159 -- p_effective_start_date Yes date Effective Start Date of Record
160 -- p_effective_end_date Yes date Effective End Date of Record
161 -- p_object_version_number No number OVN of record
162 --
163 -- Post Failure:
164 --
165 -- Access Status:
166 -- Public.
167 --
168 -- {End Of Comments}
169 --
170 procedure delete_pl_extract_id
171 (
172 p_validate in boolean default false
173 ,p_pl_extract_identifier_id in number
174 ,p_effective_start_date out nocopy date
175 ,p_effective_end_date out nocopy date
176 ,p_object_version_number in out nocopy number
177 ,p_effective_date in date
178 ,p_datetrack_mode in varchar2
179 );
180 --
181 -- ----------------------------------------------------------------------------
182 -- |----------------------------------< lck >---------------------------------|
183 -- ----------------------------------------------------------------------------
184 -- {Start Of Comments}
185 --
186 -- Description:
187 --
188 -- Prerequisites:
189 --
190 --
191 -- In Parameters:
192 -- Name Reqd Type Description
193 -- p_pl_extract_identifier_id Yes number PK of record
194 -- p_object_version_number Yes number OVN of record
195 -- p_effective_date Yes date Session Date.
196 -- p_datetrack_mode Yes varchar2 Datetrack mode.
197 --
198 -- Post Success:
199 --
200 -- Name Type Description
201 -- p_validation_start_date Yes Derived Effective Start Date.
202 -- p_validation_end_date Yes Derived Effective End Date.
203 --
204 -- Post Failure:
205 --
206 -- Access Status:
207 -- Public.
208 --
209 -- {End Of Comments}
210 --
211 procedure lck
212 (
213 p_pl_extract_identifier_id in number
214 ,p_object_version_number in number
215 ,p_effective_date in date
216 ,p_datetrack_mode in varchar2
217 ,p_validation_start_date out nocopy date
218 ,p_validation_end_date out nocopy date
219 );
220 --
221 end ben_pl_extract_id_api;