DBA Data[Home] [Help]

APPS.PER_PJU_BUS dependencies on PER_PREVIOUS_JOB_USAGES

Line 175: in per_previous_job_usages.previous_job_usage_id%type

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

Line 177: in per_previous_job_usages.object_version_number%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);

Line 179: in per_previous_job_usages.start_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

Line 181: in per_previous_job_usages.end_date%type);

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

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

Line 187: in per_previous_job_usages.previous_job_usage_id%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

Line 189: in per_previous_job_usages.object_version_number%type);

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

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

Line 195: in per_previous_job_usages.previous_job_usage_id%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

Line 197: in per_previous_job_usages.object_version_number%type);

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

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

Line 203: in per_previous_job_usages.previous_job_usage_id%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

Line 205: in per_previous_job_usages.object_version_number%type);

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

Line 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

Line 211: in per_previous_job_usages.object_version_number%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

Line 213: in per_previous_job_usages.previous_employer_id%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);

Line 215: in per_previous_job_usages.start_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

Line 217: in per_previous_job_usages.end_date%type);

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

Line 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

Line 223: in per_previous_job_usages.previous_job_id%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

Line 225: out nocopy per_previous_job_usages.start_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

Line 227: out nocopy per_previous_job_usages.end_date%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

Line 229: out nocopy per_previous_job_usages.period_years%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

Line 231: out nocopy per_previous_job_usages.period_months%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: --

Line 233: out nocopy per_previous_job_usages.period_days%type

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;