1 package pqh_corps_copy AUTHID CURRENT_USER as
2 /* $Header: pqcpdcpy.pkh 115.3 2003/11/26 02:33:33 kgowripe noship $ */
3 procedure copy_corps(p_corps_definition_id in number,
4 p_effective_date in date,
5 p_name in varchar2,
6 p_nature_cd in varchar2,
7 p_business_group_id in number default null,
8 p_copy_grades in varchar2 default 'Y',
9 p_copy_docs in varchar2 default 'Y',
10 p_copy_exams in varchar2 default 'Y',
11 p_copy_training in varchar2 default 'Y',
12 p_copy_organizations in varchar2 default 'Y',
13 p_copy_others in varchar2 default 'Y',
14 p_copy_career in varchar2 default 'Y',
15 p_filere1_cd in varchar2 default 'NO',
16 p_filere2_cd in varchar2 default null,
17 p_filere3_cd in varchar2 default null,
18 p_filere4_cd in varchar2 default null,
19 p_filere5_cd in varchar2 default null,
20 p_filere6_cd in varchar2 default null,
21 p_filere7_cd in varchar2 default null,
22 p_filere8_cd in varchar2 default null,
23 p_filere9_cd in varchar2 default null,
24 p_filere10_cd in varchar2 default null);
25
26 function get_step_name(p_grade_step_id in number) return varchar2 ;
27
28 function get_grade_name(p_grade_step_id in number) return varchar2 ;
29
30 function get_grade_id(p_grade_step_id in number) return number ;
31
32 function get_hier_ver return number ;
33
34 procedure insert_career_path(p_effective_date in date,
35 p_hierarchy_version_id in number,
36 p_business_group_id in number,
37 p_from_corps_definition_id in number,
38 p_starting_grade_step_id in number,
39 p_ending_grade_step_id in number,
40 p_to_corps_definition_id in number,
41 p_from_seniority in number default null,
42 p_from_seniority_uom in varchar2 default null,
43 p_to_seniority in number default null,
44 p_to_seniority_uom in varchar2 default null,
45 p_node_id out nocopy number,
46 p_object_version_number out nocopy number) ;
47
48 procedure update_career_path(p_effective_date in date,
49 p_node_id in number,
50 p_from_corps_definition_id in number default null,
51 p_starting_grade_step_id in number default null,
52 p_ending_grade_step_id in number default null,
53 p_to_corps_definition_id in number default null,
54 p_from_seniority in number default null,
55 p_from_seniority_uom in varchar2 default null,
56 p_to_seniority in number default null,
57 p_to_seniority_uom in varchar2 default null,
58 p_object_version_number in out nocopy number) ;
59
60 procedure delete_career_path(p_node_id in number,
61 p_object_version_number in number) ;
62
63 --
64 procedure add_corps_fileres(p_corps_definition_id in number,
65 p_effective_date in date,
66 p_filere1_cd in varchar2 ,
67 p_filere2_cd in varchar2 default null,
68 p_filere3_cd in varchar2 default null);
69 --
70 procedure delete_corps_fileres(p_corps_definition_id in number,
71 p_filere_cd in varchar2 default null);
72 --
73 procedure delete_corps(p_corps_definition_id in number);
74 --
75 procedure delete_corps_grade(p_corps_definition_id in number,
76 p_grade_id in number);
77 --
78 end pqh_corps_copy;