171: --
172: -- Check Procedures
173: procedure chk_valid_job_dates
174: (p_previous_job_usage_id
175: in per_previous_job_usages.previous_job_usage_id%type
176: ,p_object_version_number
177: in per_previous_job_usages.object_version_number%type
178: ,p_start_date
179: in per_previous_job_usages.start_date%type
173: procedure chk_valid_job_dates
174: (p_previous_job_usage_id
175: in per_previous_job_usages.previous_job_usage_id%type
176: ,p_object_version_number
177: in per_previous_job_usages.object_version_number%type
178: ,p_start_date
179: in per_previous_job_usages.start_date%type
180: ,p_end_date
181: in per_previous_job_usages.end_date%type);
175: in per_previous_job_usages.previous_job_usage_id%type
176: ,p_object_version_number
177: in per_previous_job_usages.object_version_number%type
178: ,p_start_date
179: in per_previous_job_usages.start_date%type
180: ,p_end_date
181: in per_previous_job_usages.end_date%type);
182: --
183: procedure chk_period_years
177: in per_previous_job_usages.object_version_number%type
178: ,p_start_date
179: in per_previous_job_usages.start_date%type
180: ,p_end_date
181: in per_previous_job_usages.end_date%type);
182: --
183: procedure chk_period_years
184: (p_period_years
185: in per_previous_job_usages.period_years%type
181: in per_previous_job_usages.end_date%type);
182: --
183: procedure chk_period_years
184: (p_period_years
185: in per_previous_job_usages.period_years%type
186: ,p_previous_job_usage_id
187: in per_previous_job_usages.previous_job_usage_id%type
188: ,p_object_version_number
189: in per_previous_job_usages.object_version_number%type);
183: procedure chk_period_years
184: (p_period_years
185: in per_previous_job_usages.period_years%type
186: ,p_previous_job_usage_id
187: in per_previous_job_usages.previous_job_usage_id%type
188: ,p_object_version_number
189: in per_previous_job_usages.object_version_number%type);
190: --
191: procedure chk_period_months
185: in per_previous_job_usages.period_years%type
186: ,p_previous_job_usage_id
187: in per_previous_job_usages.previous_job_usage_id%type
188: ,p_object_version_number
189: in per_previous_job_usages.object_version_number%type);
190: --
191: procedure chk_period_months
192: (p_period_months
193: in per_previous_job_usages.period_months%type
189: in per_previous_job_usages.object_version_number%type);
190: --
191: procedure chk_period_months
192: (p_period_months
193: in per_previous_job_usages.period_months%type
194: ,p_previous_job_usage_id
195: in per_previous_job_usages.previous_job_usage_id%type
196: ,p_object_version_number
197: in per_previous_job_usages.object_version_number%type);
191: procedure chk_period_months
192: (p_period_months
193: in per_previous_job_usages.period_months%type
194: ,p_previous_job_usage_id
195: in per_previous_job_usages.previous_job_usage_id%type
196: ,p_object_version_number
197: in per_previous_job_usages.object_version_number%type);
198: --
199: procedure chk_period_days
193: in per_previous_job_usages.period_months%type
194: ,p_previous_job_usage_id
195: in per_previous_job_usages.previous_job_usage_id%type
196: ,p_object_version_number
197: in per_previous_job_usages.object_version_number%type);
198: --
199: procedure chk_period_days
200: (p_period_days
201: in per_previous_job_usages.period_days%type
197: in per_previous_job_usages.object_version_number%type);
198: --
199: procedure chk_period_days
200: (p_period_days
201: in per_previous_job_usages.period_days%type
202: ,p_previous_job_usage_id
203: in per_previous_job_usages.previous_job_usage_id%type
204: ,p_object_version_number
205: in per_previous_job_usages.object_version_number%type);
199: procedure chk_period_days
200: (p_period_days
201: in per_previous_job_usages.period_days%type
202: ,p_previous_job_usage_id
203: in per_previous_job_usages.previous_job_usage_id%type
204: ,p_object_version_number
205: in per_previous_job_usages.object_version_number%type);
206: --
207: procedure chk_pju_start_end_dates
201: in per_previous_job_usages.period_days%type
202: ,p_previous_job_usage_id
203: in per_previous_job_usages.previous_job_usage_id%type
204: ,p_object_version_number
205: in per_previous_job_usages.object_version_number%type);
206: --
207: procedure chk_pju_start_end_dates
208: (p_previous_job_usage_id
209: in per_previous_job_usages.previous_job_usage_id%type
205: in per_previous_job_usages.object_version_number%type);
206: --
207: procedure chk_pju_start_end_dates
208: (p_previous_job_usage_id
209: in per_previous_job_usages.previous_job_usage_id%type
210: ,p_object_version_number
211: in per_previous_job_usages.object_version_number%type
212: ,p_previous_employer_id
213: in per_previous_job_usages.previous_employer_id%type
207: procedure chk_pju_start_end_dates
208: (p_previous_job_usage_id
209: in per_previous_job_usages.previous_job_usage_id%type
210: ,p_object_version_number
211: in per_previous_job_usages.object_version_number%type
212: ,p_previous_employer_id
213: in per_previous_job_usages.previous_employer_id%type
214: ,p_start_date
215: in per_previous_job_usages.start_date%type
209: in per_previous_job_usages.previous_job_usage_id%type
210: ,p_object_version_number
211: in per_previous_job_usages.object_version_number%type
212: ,p_previous_employer_id
213: in per_previous_job_usages.previous_employer_id%type
214: ,p_start_date
215: in per_previous_job_usages.start_date%type
216: ,p_end_date
217: in per_previous_job_usages.end_date%type);
211: in per_previous_job_usages.object_version_number%type
212: ,p_previous_employer_id
213: in per_previous_job_usages.previous_employer_id%type
214: ,p_start_date
215: in per_previous_job_usages.start_date%type
216: ,p_end_date
217: in per_previous_job_usages.end_date%type);
218: --
219: procedure get_previous_job_dates
213: in per_previous_job_usages.previous_employer_id%type
214: ,p_start_date
215: in per_previous_job_usages.start_date%type
216: ,p_end_date
217: in per_previous_job_usages.end_date%type);
218: --
219: procedure get_previous_job_dates
220: (p_previous_employer_id
221: in per_previous_job_usages.previous_employer_id%type
217: in per_previous_job_usages.end_date%type);
218: --
219: procedure get_previous_job_dates
220: (p_previous_employer_id
221: in per_previous_job_usages.previous_employer_id%type
222: ,p_previous_job_id
223: in per_previous_job_usages.previous_job_id%type
224: ,p_start_date
225: out nocopy per_previous_job_usages.start_date%type
219: procedure get_previous_job_dates
220: (p_previous_employer_id
221: in per_previous_job_usages.previous_employer_id%type
222: ,p_previous_job_id
223: in per_previous_job_usages.previous_job_id%type
224: ,p_start_date
225: out nocopy per_previous_job_usages.start_date%type
226: ,p_end_date
227: out nocopy per_previous_job_usages.end_date%type
221: in per_previous_job_usages.previous_employer_id%type
222: ,p_previous_job_id
223: in per_previous_job_usages.previous_job_id%type
224: ,p_start_date
225: out nocopy per_previous_job_usages.start_date%type
226: ,p_end_date
227: out nocopy per_previous_job_usages.end_date%type
228: ,p_period_years
229: out nocopy per_previous_job_usages.period_years%type
223: in per_previous_job_usages.previous_job_id%type
224: ,p_start_date
225: out nocopy per_previous_job_usages.start_date%type
226: ,p_end_date
227: out nocopy per_previous_job_usages.end_date%type
228: ,p_period_years
229: out nocopy per_previous_job_usages.period_years%type
230: ,p_period_months
231: out nocopy per_previous_job_usages.period_months%type
225: out nocopy per_previous_job_usages.start_date%type
226: ,p_end_date
227: out nocopy per_previous_job_usages.end_date%type
228: ,p_period_years
229: out nocopy per_previous_job_usages.period_years%type
230: ,p_period_months
231: out nocopy per_previous_job_usages.period_months%type
232: ,p_period_days
233: out nocopy per_previous_job_usages.period_days%type
227: out nocopy per_previous_job_usages.end_date%type
228: ,p_period_years
229: out nocopy per_previous_job_usages.period_years%type
230: ,p_period_months
231: out nocopy per_previous_job_usages.period_months%type
232: ,p_period_days
233: out nocopy per_previous_job_usages.period_days%type
234: );
235: --
229: out nocopy per_previous_job_usages.period_years%type
230: ,p_period_months
231: out nocopy per_previous_job_usages.period_months%type
232: ,p_period_days
233: out nocopy per_previous_job_usages.period_days%type
234: );
235: --
236: end per_pju_bus;