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
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
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
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
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);
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
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
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
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: );
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: --
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
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
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);
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: -- -----------------------------------------------------------------------
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: -- -----------------------------------------------------------------------
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);
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: -- -----------------------------------------------------------------------
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: -- -----------------------------------------------------------------------
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);
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: -- -----------------------------------------------------------------------
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: -- -----------------------------------------------------------------------
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);
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;
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;