DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on PER_PREVIOUS_EMPLOYERS

Line 181: in per_previous_employers.previous_employer_id%type

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

Line 183: in per_previous_employers.object_version_number%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

Line 185: in per_previous_employers.start_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);

Line 187: in per_previous_employers.end_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

Line 189: IN per_previous_employers.start_date%type);

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

Line 192: (p_start_date in per_previous_employers.start_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

Line 193: ,p_end_date in per_previous_employers.end_date%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: );

Line 194: ,p_period_years out nocopy per_previous_employers.period_years%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: );
198: --

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

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

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

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

Line 201: in per_previous_employers.previous_employer_id%type

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

Line 203: in per_previous_employers.object_version_number%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: -- -----------------------------------------------------------------------

Line 205: in per_previous_employers.all_assignments%type);

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

Line 234: (p_period_years in per_previous_employers.period_years%type

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

Line 236: in per_previous_employers.previous_employer_id%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: -- -----------------------------------------------------------------------

Line 238: in per_previous_employers.object_version_number%type);

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

Line 267: (p_period_months in per_previous_employers.period_months%type

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

Line 269: in per_previous_employers.previous_employer_id%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: -- -----------------------------------------------------------------------

Line 271: in per_previous_employers.object_version_number%type);

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

Line 300: (p_period_days in per_previous_employers.period_days%type

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

Line 302: in per_previous_employers.previous_employer_id%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;

Line 304: in per_previous_employers.object_version_number%type);

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;