1 package pqh_cpd_hr_to_stage AUTHID CURRENT_USER as
2 /* $Header: pqcpdhrs.pkh 120.0 2005/05/29 01:44 appldev noship $ */
3 function get_crpth_hier_ver return number;
4 procedure corps_to_stage(p_copy_entity_txn_id in number,
5 p_pgm_id in number,
6 p_effective_date in date,
7 p_pgm_cer_id in number);
8 function check_cpd_row(p_copy_entity_txn_id in number) return varchar2;
9 function check_cdd_row(p_copy_entity_txn_id in number) return varchar2;
10 procedure get_scale_ddf_det(p_scale_id in number,
11 p_information_category out nocopy varchar2,
12 p_information1 out nocopy varchar2,
13 p_information2 out nocopy varchar2);
14 procedure get_point_details(p_point_id in number,
15 p_information_category out nocopy varchar2,
16 p_information1 out nocopy varchar2,
17 p_information2 out nocopy varchar2,
18 p_information3 out nocopy varchar2,
19 p_information4 out nocopy varchar2,
20 p_information5 out nocopy varchar2);
21 procedure get_corp(p_pgm_cer_id in number,
22 p_corps_id out nocopy number,
23 p_cet_id out nocopy number);
24 procedure get_grd_quota(p_pgm_cer_id in number,
25 p_grade_id in number,
26 p_corps_definition_id in number,
27 p_cet_id in number,
28 p_perc_quota out nocopy number,
29 p_population_cd out nocopy varchar2,
30 p_comb_grade out nocopy varchar2,
31 p_max_speed_quota out nocopy number,
32 p_avg_speed_quota out nocopy number,
33 p_corps_extra_info_id out nocopy number);
34 procedure stage_to_corps(p_copy_entity_txn_id in number,
35 p_effective_date in date,
36 p_business_group_id in number,
37 p_datetrack_mode in varchar2);
38 procedure grd_quota_update(p_effective_date in date,
39 p_grade_id in number,
40 p_corps_definition_id in number,
41 p_corps_extra_info_id in number,
42 p_perc_quota in number,
43 p_population_cd in varchar2,
44 p_comb_grades in varchar2,
45 p_max_speed_quota in number,
46 p_avg_speed_quota in number);
47 procedure pull_career_path(p_copy_entity_txn_id in number,
48 p_step_id in number,
49 p_effective_date in date,
50 p_grade_id in number);
51 procedure update_point(p_point_id in number,
52 p_point_ovn in out nocopy number,
53 p_information_category in varchar2,
54 p_information1 in varchar2,
55 p_information2 in varchar2,
56 p_information3 in varchar2,
57 p_information4 in varchar2,
58 p_information5 in varchar2,
59 p_effective_date in date,
60 p_business_group_id in number,
61 p_parent_spine_id in number,
62 p_sequence in number,
63 p_spinal_point in varchar2);
64 procedure create_point(p_point_id out nocopy number,
65 p_point_ovn out nocopy number,
66 p_information_category in varchar2,
67 p_information1 in varchar2,
68 p_information2 in varchar2,
69 p_information3 in varchar2,
70 p_information4 in varchar2,
71 p_information5 in varchar2,
72 p_effective_date in date,
73 p_business_group_id in number,
74 p_parent_spine_id in number,
75 p_sequence in number,
76 p_spinal_point in varchar2);
77 procedure create_scale(p_scale_id out nocopy number,
78 p_scale_ovn out nocopy number,
79 p_information_category in varchar2,
80 p_information1 in varchar2,
81 p_information2 in varchar2,
82 p_business_group_id in number,
83 p_name in varchar2,
84 p_effective_date in date,
85 p_increment_frequency in number,
86 p_increment_period in varchar2);
87 procedure update_scale(p_scale_id in number,
88 p_scale_ovn in out nocopy number,
89 p_information_category in varchar2,
90 p_information1 in varchar2,
91 p_information2 in varchar2,
92 p_business_group_id in number,
93 p_name in varchar2,
94 p_effective_date in date,
95 p_increment_frequency in number,
96 p_increment_period in varchar2);
97 procedure get_pgm_extra_info(p_pgm_id in number,
98 p_quota_flag out nocopy varchar2,
99 p_appraisal_type out nocopy varchar2,
100 p_review_period out nocopy number,
101 p_pgm_extra_info_id out nocopy number);
102 end pqh_cpd_hr_to_stage;