177: );
178: --
179: procedure chk_start_end_dates
180: (p_previous_employer_id
181: in per_previous_employers.previous_employer_id%type
182: ,p_object_version_number
183: in per_previous_employers.object_version_number%type
184: ,p_start_date
185: in per_previous_employers.start_date%type
179: procedure chk_start_end_dates
180: (p_previous_employer_id
181: in per_previous_employers.previous_employer_id%type
182: ,p_object_version_number
183: in per_previous_employers.object_version_number%type
184: ,p_start_date
185: in per_previous_employers.start_date%type
186: ,p_end_date
187: in per_previous_employers.end_date%TYPE
181: in per_previous_employers.previous_employer_id%type
182: ,p_object_version_number
183: in per_previous_employers.object_version_number%type
184: ,p_start_date
185: in per_previous_employers.start_date%type
186: ,p_end_date
187: in per_previous_employers.end_date%TYPE
188: ,p_effective_date
189: IN per_previous_employers.start_date%type);
183: in per_previous_employers.object_version_number%type
184: ,p_start_date
185: in per_previous_employers.start_date%type
186: ,p_end_date
187: in per_previous_employers.end_date%TYPE
188: ,p_effective_date
189: IN per_previous_employers.start_date%type);
190: --
191: procedure get_period_values
185: in per_previous_employers.start_date%type
186: ,p_end_date
187: in per_previous_employers.end_date%TYPE
188: ,p_effective_date
189: IN per_previous_employers.start_date%type);
190: --
191: procedure get_period_values
192: (p_start_date in per_previous_employers.start_date%type
193: ,p_end_date in per_previous_employers.end_date%type
188: ,p_effective_date
189: IN per_previous_employers.start_date%type);
190: --
191: procedure get_period_values
192: (p_start_date in per_previous_employers.start_date%type
193: ,p_end_date in per_previous_employers.end_date%type
194: ,p_period_years out nocopy per_previous_employers.period_years%type
195: ,p_period_months out nocopy per_previous_employers.period_months%type
196: ,p_period_days out nocopy per_previous_employers.period_days%type
189: IN per_previous_employers.start_date%type);
190: --
191: procedure get_period_values
192: (p_start_date in per_previous_employers.start_date%type
193: ,p_end_date in per_previous_employers.end_date%type
194: ,p_period_years out nocopy per_previous_employers.period_years%type
195: ,p_period_months out nocopy per_previous_employers.period_months%type
196: ,p_period_days out nocopy per_previous_employers.period_days%type
197: );
190: --
191: procedure get_period_values
192: (p_start_date in per_previous_employers.start_date%type
193: ,p_end_date in per_previous_employers.end_date%type
194: ,p_period_years out nocopy per_previous_employers.period_years%type
195: ,p_period_months out nocopy per_previous_employers.period_months%type
196: ,p_period_days out nocopy per_previous_employers.period_days%type
197: );
198: --
191: procedure get_period_values
192: (p_start_date in per_previous_employers.start_date%type
193: ,p_end_date in per_previous_employers.end_date%type
194: ,p_period_years out nocopy per_previous_employers.period_years%type
195: ,p_period_months out nocopy per_previous_employers.period_months%type
196: ,p_period_days out nocopy per_previous_employers.period_days%type
197: );
198: --
199: procedure chk_all_assignments
192: (p_start_date in per_previous_employers.start_date%type
193: ,p_end_date in per_previous_employers.end_date%type
194: ,p_period_years out nocopy per_previous_employers.period_years%type
195: ,p_period_months out nocopy per_previous_employers.period_months%type
196: ,p_period_days out nocopy per_previous_employers.period_days%type
197: );
198: --
199: procedure chk_all_assignments
200: (p_previous_employer_id
197: );
198: --
199: procedure chk_all_assignments
200: (p_previous_employer_id
201: in per_previous_employers.previous_employer_id%type
202: ,p_object_version_number
203: in per_previous_employers.object_version_number%type
204: ,p_all_assignments
205: in per_previous_employers.all_assignments%type);
199: procedure chk_all_assignments
200: (p_previous_employer_id
201: in per_previous_employers.previous_employer_id%type
202: ,p_object_version_number
203: in per_previous_employers.object_version_number%type
204: ,p_all_assignments
205: in per_previous_employers.all_assignments%type);
206: --
207: -- -----------------------------------------------------------------------
201: in per_previous_employers.previous_employer_id%type
202: ,p_object_version_number
203: in per_previous_employers.object_version_number%type
204: ,p_all_assignments
205: in per_previous_employers.all_assignments%type);
206: --
207: -- -----------------------------------------------------------------------
208: -- |---------------------------< chk_period_years >----------------------|
209: -- -----------------------------------------------------------------------
230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: procedure chk_period_years
234: (p_period_years in per_previous_employers.period_years%type
235: ,p_previous_employer_id
236: in per_previous_employers.previous_employer_id%type
237: ,p_object_version_number
238: in per_previous_employers.object_version_number%type);
232: -- ----------------------------------------------------------------------------
233: procedure chk_period_years
234: (p_period_years in per_previous_employers.period_years%type
235: ,p_previous_employer_id
236: in per_previous_employers.previous_employer_id%type
237: ,p_object_version_number
238: in per_previous_employers.object_version_number%type);
239: --
240: -- -----------------------------------------------------------------------
234: (p_period_years in per_previous_employers.period_years%type
235: ,p_previous_employer_id
236: in per_previous_employers.previous_employer_id%type
237: ,p_object_version_number
238: in per_previous_employers.object_version_number%type);
239: --
240: -- -----------------------------------------------------------------------
241: -- |---------------------------< chk_period_months >---------------------|
242: -- -----------------------------------------------------------------------
263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: procedure chk_period_months
267: (p_period_months in per_previous_employers.period_months%type
268: ,p_previous_employer_id
269: in per_previous_employers.previous_employer_id%type
270: ,p_object_version_number
271: in per_previous_employers.object_version_number%type);
265: -- ----------------------------------------------------------------------------
266: procedure chk_period_months
267: (p_period_months in per_previous_employers.period_months%type
268: ,p_previous_employer_id
269: in per_previous_employers.previous_employer_id%type
270: ,p_object_version_number
271: in per_previous_employers.object_version_number%type);
272: --
273: -- -----------------------------------------------------------------------
267: (p_period_months in per_previous_employers.period_months%type
268: ,p_previous_employer_id
269: in per_previous_employers.previous_employer_id%type
270: ,p_object_version_number
271: in per_previous_employers.object_version_number%type);
272: --
273: -- -----------------------------------------------------------------------
274: -- |---------------------------< chk_period_days >-----------------------|
275: -- -----------------------------------------------------------------------
296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: procedure chk_period_days
300: (p_period_days in per_previous_employers.period_days%type
301: ,p_previous_employer_id
302: in per_previous_employers.previous_employer_id%type
303: ,p_object_version_number
304: in per_previous_employers.object_version_number%type);
298: -- ----------------------------------------------------------------------------
299: procedure chk_period_days
300: (p_period_days in per_previous_employers.period_days%type
301: ,p_previous_employer_id
302: in per_previous_employers.previous_employer_id%type
303: ,p_object_version_number
304: in per_previous_employers.object_version_number%type);
305: --
306: end per_pem_bus;
300: (p_period_days in per_previous_employers.period_days%type
301: ,p_previous_employer_id
302: in per_previous_employers.previous_employer_id%type
303: ,p_object_version_number
304: in per_previous_employers.object_version_number%type);
305: --
306: end per_pem_bus;