[Home] [Help]
1: PACKAGE BODY PER_JOBS_PKG as
2: /* $Header: pejbd01t.pkb 120.0 2005/05/31 10:32:42 appldev noship $ */
3: --
4: procedure get_next_sequence(p_job_id in out nocopy number) is
5: --
2: /* $Header: pejbd01t.pkb 120.0 2005/05/31 10:32:42 appldev noship $ */
3: --
4: procedure get_next_sequence(p_job_id in out nocopy number) is
5: --
6: cursor c1 is select per_jobs_s.nextval
7: from sys.dual;
8: --
9: begin
10: --
21: end if;
22: close c1;
23: end if;
24: --
25: hr_utility.set_location('PER_JOBS_PKG.get_next_sequence', 1);
26: --
27: end get_next_sequence;
28: --
29: procedure check_unique_name(p_job_id in number,
30: p_business_group_id in number,
31: p_name in varchar2) is
32: --
33: cursor csr_name is select null
34: from per_jobs j
35: where ((p_job_id is not null
36: and j.job_id <> p_job_id)
37: or p_job_id is null)
38: and j.business_group_id + 0 = p_business_group_id
54: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOBS_PKG.check_unique_name', 1);
59: --
60: end check_unique_name;
61: --
62: procedure check_date_from(p_job_id in number,
85: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');
86: hr_utility.raise_error;
87: end if;
88: --
89: hr_utility.set_location('PER_JOBS_PKG.check_date_from', 1);
90: --
91: end check_date_from;
92: --
93: procedure get_job_flex_structure(p_structure_defining_column in out nocopy varchar2,
121: hr_utility.set_message_token('STEP','1');
122: hr_utility.raise_error;
123: end if;
124: --
125: hr_utility.set_location('PER_JOBS_PKG.get_job_flex_structure', 1);
126: --
127: end get_job_flex_structure;
128: --
129: PROCEDURE check_altered_end_date(p_business_group_id number,
153: fetch csr_date_to into g_dummy_number;
154: p_early_date_to := csr_date_to%FOUND;
155: close csr_date_to;
156: --
157: hr_utility.set_location('PER_JOBS_PKG.check_altered_end_date', 1);
158: --
159: open csr_date_from;
160: fetch csr_date_from into g_dummy_number;
161: p_early_date_from := csr_date_from%FOUND;
160: fetch csr_date_from into g_dummy_number;
161: p_early_date_from := csr_date_from%FOUND;
162: close csr_date_from;
163: --
164: hr_utility.set_location('PER_JOBS_PKG.check_altered_end_date', 2);
165: --
166: end check_altered_end_date;
167: --
168: PROCEDURE update_valid_grades(p_business_group_id number,
307: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');
308: hr_utility.raise_error;
309: end if;
310: --
311: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 1);
312: --
313: --
314: --
315: open csr_assignment;
321: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');
322: hr_utility.raise_error;
323: end if;
324: --
325: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 2);
326: --
327: --
328: --
329: open csr_grade;
335: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');
336: hr_utility.raise_error;
337: end if;
338: --
339: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 3);
340: --
341: --
342: --
343: open csr_requirement;
349: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');
350: hr_utility.raise_error;
351: end if;
352: --
353: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 4);
354: --
355: --
356: --
357: open csr_evaluation;
363: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');
364: hr_utility.raise_error;
365: end if;
366: --
367: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 5);
368: --
369: --
370: --
371: open csr_elementp;
377: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
378: hr_utility.raise_error;
379: end if;
380: --
381: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 6);
382: --
383: --
384: --
385: open csr_elements;
391: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
392: hr_utility.raise_error;
393: end if;
394: --
395: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 7);
396: --
397: --
398: --
399: open csr_budget;
405: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');
406: hr_utility.raise_error;
407: end if;
408: --
409: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 8);
410: --
411: --
412: --
413: open csr_vacancy;
419: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');
420: hr_utility.raise_error;
421: end if;
422: --
423: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 9);
424: --
425: --
426: --
427: open csr_link;
433: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');
434: hr_utility.raise_error;
435: end if;
436: --
437: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 10);
438: --
439: --
440: open csr_role;
441: fetch csr_role into g_dummy_number;
446: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');
447: hr_utility.raise_error;
448: end if;
449: --
450: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);
451: --
452: -- is po installed?
453: --
454: if (fnd_installation.get(appl_id => 201
505: end;
506: end if;
507: end if;
508: --
509: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);
510: --
511: per_ota_predel_validation.ota_predel_job_validation(p_job_id);
512: --
513: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 12);
509: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);
510: --
511: per_ota_predel_validation.ota_predel_job_validation(p_job_id);
512: --
513: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 12);
514: --
515: pa_job.pa_predel_validation(p_job_id);
516: --
517: end check_delete_record;
557: --
558: end check_evaluation_dates;
559: --
560:
561: END PER_JOBS_PKG;