DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on PER_PREVIOUS_EMPLOYERS

Line 182: in per_previous_employers.previous_employer_id%type

178: --
179: -- Bug 14316052
180: procedure chk_start_end_dates
181: (p_previous_employer_id
182: in per_previous_employers.previous_employer_id%type
183: ,p_object_version_number
184: in per_previous_employers.object_version_number%type
185: ,p_start_date
186: in per_previous_employers.start_date%type

Line 184: in per_previous_employers.object_version_number%type

180: procedure chk_start_end_dates
181: (p_previous_employer_id
182: in per_previous_employers.previous_employer_id%type
183: ,p_object_version_number
184: in per_previous_employers.object_version_number%type
185: ,p_start_date
186: in per_previous_employers.start_date%type
187: ,p_end_date
188: in per_previous_employers.end_date%TYPE

Line 186: in per_previous_employers.start_date%type

182: in per_previous_employers.previous_employer_id%type
183: ,p_object_version_number
184: in per_previous_employers.object_version_number%type
185: ,p_start_date
186: in per_previous_employers.start_date%type
187: ,p_end_date
188: in per_previous_employers.end_date%TYPE
189: ,p_effective_date
190: IN per_previous_employers.start_date%type

Line 188: in per_previous_employers.end_date%TYPE

184: in per_previous_employers.object_version_number%type
185: ,p_start_date
186: in per_previous_employers.start_date%type
187: ,p_end_date
188: in per_previous_employers.end_date%TYPE
189: ,p_effective_date
190: IN per_previous_employers.start_date%type
191: ,p_business_group_id
192: IN per_previous_employers.business_group_id%type

Line 190: IN per_previous_employers.start_date%type

186: in per_previous_employers.start_date%type
187: ,p_end_date
188: in per_previous_employers.end_date%TYPE
189: ,p_effective_date
190: IN per_previous_employers.start_date%type
191: ,p_business_group_id
192: IN per_previous_employers.business_group_id%type
193: ,p_employer_type
194: IN per_previous_employers.employer_type%type);

Line 192: IN per_previous_employers.business_group_id%type

188: in per_previous_employers.end_date%TYPE
189: ,p_effective_date
190: IN per_previous_employers.start_date%type
191: ,p_business_group_id
192: IN per_previous_employers.business_group_id%type
193: ,p_employer_type
194: IN per_previous_employers.employer_type%type);
195: --
196: procedure get_period_values

Line 194: IN per_previous_employers.employer_type%type);

190: IN per_previous_employers.start_date%type
191: ,p_business_group_id
192: IN per_previous_employers.business_group_id%type
193: ,p_employer_type
194: IN per_previous_employers.employer_type%type);
195: --
196: procedure get_period_values
197: (p_start_date in per_previous_employers.start_date%type
198: ,p_end_date in per_previous_employers.end_date%type

Line 197: (p_start_date in per_previous_employers.start_date%type

193: ,p_employer_type
194: IN per_previous_employers.employer_type%type);
195: --
196: procedure get_period_values
197: (p_start_date in per_previous_employers.start_date%type
198: ,p_end_date in per_previous_employers.end_date%type
199: ,p_period_years out nocopy per_previous_employers.period_years%type
200: ,p_period_months out nocopy per_previous_employers.period_months%type
201: ,p_period_days out nocopy per_previous_employers.period_days%type

Line 198: ,p_end_date in per_previous_employers.end_date%type

194: IN per_previous_employers.employer_type%type);
195: --
196: procedure get_period_values
197: (p_start_date in per_previous_employers.start_date%type
198: ,p_end_date in per_previous_employers.end_date%type
199: ,p_period_years out nocopy per_previous_employers.period_years%type
200: ,p_period_months out nocopy per_previous_employers.period_months%type
201: ,p_period_days out nocopy per_previous_employers.period_days%type
202: );

Line 199: ,p_period_years out nocopy per_previous_employers.period_years%type

195: --
196: procedure get_period_values
197: (p_start_date in per_previous_employers.start_date%type
198: ,p_end_date in per_previous_employers.end_date%type
199: ,p_period_years out nocopy per_previous_employers.period_years%type
200: ,p_period_months out nocopy per_previous_employers.period_months%type
201: ,p_period_days out nocopy per_previous_employers.period_days%type
202: );
203: --

Line 200: ,p_period_months out nocopy per_previous_employers.period_months%type

196: procedure get_period_values
197: (p_start_date in per_previous_employers.start_date%type
198: ,p_end_date in per_previous_employers.end_date%type
199: ,p_period_years out nocopy per_previous_employers.period_years%type
200: ,p_period_months out nocopy per_previous_employers.period_months%type
201: ,p_period_days out nocopy per_previous_employers.period_days%type
202: );
203: --
204: procedure chk_all_assignments

Line 201: ,p_period_days out nocopy per_previous_employers.period_days%type

197: (p_start_date in per_previous_employers.start_date%type
198: ,p_end_date in per_previous_employers.end_date%type
199: ,p_period_years out nocopy per_previous_employers.period_years%type
200: ,p_period_months out nocopy per_previous_employers.period_months%type
201: ,p_period_days out nocopy per_previous_employers.period_days%type
202: );
203: --
204: procedure chk_all_assignments
205: (p_previous_employer_id

Line 206: in per_previous_employers.previous_employer_id%type

202: );
203: --
204: procedure chk_all_assignments
205: (p_previous_employer_id
206: in per_previous_employers.previous_employer_id%type
207: ,p_object_version_number
208: in per_previous_employers.object_version_number%type
209: ,p_all_assignments
210: in per_previous_employers.all_assignments%type);

Line 208: in per_previous_employers.object_version_number%type

204: procedure chk_all_assignments
205: (p_previous_employer_id
206: in per_previous_employers.previous_employer_id%type
207: ,p_object_version_number
208: in per_previous_employers.object_version_number%type
209: ,p_all_assignments
210: in per_previous_employers.all_assignments%type);
211: --
212: -- -----------------------------------------------------------------------

Line 210: in per_previous_employers.all_assignments%type);

206: in per_previous_employers.previous_employer_id%type
207: ,p_object_version_number
208: in per_previous_employers.object_version_number%type
209: ,p_all_assignments
210: in per_previous_employers.all_assignments%type);
211: --
212: -- -----------------------------------------------------------------------
213: -- |---------------------------< chk_period_years >----------------------|
214: -- -----------------------------------------------------------------------

Line 239: (p_period_years in per_previous_employers.period_years%type

235: --
236: -- {End Of Comments}
237: -- ----------------------------------------------------------------------------
238: procedure chk_period_years
239: (p_period_years in per_previous_employers.period_years%type
240: ,p_previous_employer_id
241: in per_previous_employers.previous_employer_id%type
242: ,p_object_version_number
243: in per_previous_employers.object_version_number%type);

Line 241: in per_previous_employers.previous_employer_id%type

237: -- ----------------------------------------------------------------------------
238: procedure chk_period_years
239: (p_period_years in per_previous_employers.period_years%type
240: ,p_previous_employer_id
241: in per_previous_employers.previous_employer_id%type
242: ,p_object_version_number
243: in per_previous_employers.object_version_number%type);
244: --
245: -- -----------------------------------------------------------------------

Line 243: in per_previous_employers.object_version_number%type);

239: (p_period_years in per_previous_employers.period_years%type
240: ,p_previous_employer_id
241: in per_previous_employers.previous_employer_id%type
242: ,p_object_version_number
243: in per_previous_employers.object_version_number%type);
244: --
245: -- -----------------------------------------------------------------------
246: -- |---------------------------< chk_period_months >---------------------|
247: -- -----------------------------------------------------------------------

Line 272: (p_period_months in per_previous_employers.period_months%type

268: --
269: -- {End Of Comments}
270: -- ----------------------------------------------------------------------------
271: procedure chk_period_months
272: (p_period_months in per_previous_employers.period_months%type
273: ,p_previous_employer_id
274: in per_previous_employers.previous_employer_id%type
275: ,p_object_version_number
276: in per_previous_employers.object_version_number%type);

Line 274: in per_previous_employers.previous_employer_id%type

270: -- ----------------------------------------------------------------------------
271: procedure chk_period_months
272: (p_period_months in per_previous_employers.period_months%type
273: ,p_previous_employer_id
274: in per_previous_employers.previous_employer_id%type
275: ,p_object_version_number
276: in per_previous_employers.object_version_number%type);
277: --
278: -- -----------------------------------------------------------------------

Line 276: in per_previous_employers.object_version_number%type);

272: (p_period_months in per_previous_employers.period_months%type
273: ,p_previous_employer_id
274: in per_previous_employers.previous_employer_id%type
275: ,p_object_version_number
276: in per_previous_employers.object_version_number%type);
277: --
278: -- -----------------------------------------------------------------------
279: -- |---------------------------< chk_period_days >-----------------------|
280: -- -----------------------------------------------------------------------

Line 305: (p_period_days in per_previous_employers.period_days%type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: procedure chk_period_days
305: (p_period_days in per_previous_employers.period_days%type
306: ,p_previous_employer_id
307: in per_previous_employers.previous_employer_id%type
308: ,p_object_version_number
309: in per_previous_employers.object_version_number%type);

Line 307: in per_previous_employers.previous_employer_id%type

303: -- ----------------------------------------------------------------------------
304: procedure chk_period_days
305: (p_period_days in per_previous_employers.period_days%type
306: ,p_previous_employer_id
307: in per_previous_employers.previous_employer_id%type
308: ,p_object_version_number
309: in per_previous_employers.object_version_number%type);
310: --
311: end per_pem_bus;

Line 309: in per_previous_employers.object_version_number%type);

305: (p_period_days in per_previous_employers.period_days%type
306: ,p_previous_employer_id
307: in per_previous_employers.previous_employer_id%type
308: ,p_object_version_number
309: in per_previous_employers.object_version_number%type);
310: --
311: end per_pem_bus;