1 PACKAGE per_ri_config_fnd_hr_entity AS
2 /* $Header: perrichd.pkh 120.2.12000000.1 2007/01/22 03:39:40 appldev noship $ */
3
4 TYPE security_profile_rec IS RECORD (security_profile_name varchar2(60)
5 ,responsibility_key varchar2(60));
6
7 TYPE security_profile_tab IS TABLE OF
8 security_profile_rec
9 INDEX BY BINARY_INTEGER;
10
11 TYPE int_bg_resp_rec IS RECORD (security_profile_name varchar2(60)
12 ,responsibility_key varchar2(60));
13
14 TYPE int_bg_resp_tab IS TABLE OF
15 int_bg_resp_rec
16 INDEX BY BINARY_INTEGER;
17
18 l_security_profile_tab security_profile_tab;
19 l_security_profile_tab security_profile_tab;
20
21
22 PROCEDURE create_global_grp_cmp_cost_kf
23 (p_configuration_code in varchar2
24 ,p_technical_summary_mode in boolean default FALSE
25 ,p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab
26 ,p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab
27 ,p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab
28 ,p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab
29 ,p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab
30 ,p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab
31 );
32
33 PROCEDURE create_global_job_pos_kf (p_configuration_code in varchar2
34 ,p_technical_summary_mode in boolean default FALSE
35 ,p_kf_job_tab in out nocopy
36 per_ri_config_tech_summary.kf_job_tab
37 ,p_kf_pos_tab in out nocopy
38 per_ri_config_tech_summary.kf_pos_tab
39 ,p_kf_job_seg_tab in out nocopy
40 per_ri_config_tech_summary.kf_job_seg_tab
41 ,p_kf_pos_seg_tab in out nocopy
42 per_ri_config_tech_summary.kf_pos_seg_tab);
43
44 PROCEDURE create_global_pos_kf (p_configuration_code in varchar2
45 ,p_technical_summary_mode in boolean default FALSE
46 ,p_kf_pos_tab in out nocopy
47 per_ri_config_tech_summary.kf_pos_tab
48 ,p_kf_pos_seg_tab in out nocopy
49 per_ri_config_tech_summary.kf_pos_seg_tab);
50
51 PROCEDURE create_global_grd_kf (p_configuration_code in varchar2
52 ,p_technical_summary_mode in boolean default FALSE
53 ,p_kf_grd_tab in out nocopy
54 per_ri_config_tech_summary.kf_grd_tab
55 ,p_kf_grd_seg_tab in out nocopy
56 per_ri_config_tech_summary.kf_grd_seg_tab);
57
58 PROCEDURE create_default_value_sets (p_configuration_code in varchar2);
59
60 PROCEDURE create_hrms_responsibility (p_configuration_code in varchar2
61 ,p_security_profile_tab in out nocopy security_profile_tab
62 ,p_technical_summary_mode in boolean default FALSE
63 ,p_hrms_resp_tab in out nocopy
64 per_ri_config_tech_summary.hrms_resp_tab);
65
66 PROCEDURE create_jobs_rv_keyflex (p_configuration_code in varchar2
67 ,p_technical_summary_mode in boolean default FALSE
68 ,p_kf_job_rv_tab in out nocopy
69 per_ri_config_tech_summary.kf_job_rv_tab
70 ,p_kf_job_rv_seg_tab in out nocopy
71 per_ri_config_tech_summary.kf_job_rv_seg_tab);
72
73 PROCEDURE create_positions_rv_keyflex (p_configuration_code in varchar2
74 ,p_technical_summary_mode in boolean default FALSE
75 ,p_kf_pos_rv_tab in out nocopy
76 per_ri_config_tech_summary.kf_pos_rv_tab
77 ,p_kf_pos_rv_seg_tab in out nocopy
78 per_ri_config_tech_summary.kf_pos_rv_seg_tab);
79
80 PROCEDURE create_grades_rv_keyflex (p_configuration_code in varchar2
81 ,p_technical_summary_mode in boolean default FALSE
82 ,p_kf_grd_rv_tab in out nocopy
83 per_ri_config_tech_summary.kf_grd_rv_tab
84 ,p_kf_grd_rv_seg_tab in out nocopy
85 per_ri_config_tech_summary.kf_grd_rv_seg_tab);
86
87 PROCEDURE create_jobs_no_rv_keyflex (p_configuration_code in varchar2
88 ,p_technical_summary_mode in boolean default FALSE
89 ,p_kf_job_no_rv_tab in out nocopy
90 per_ri_config_tech_summary.kf_job_no_rv_tab
91 ,p_kf_job_no_rv_seg_tab in out nocopy
92 per_ri_config_tech_summary.kf_job_no_rv_seg_tab);
93
94 PROCEDURE create_positions_no_rv_keyflex (p_configuration_code in varchar2
95 ,p_technical_summary_mode in boolean default FALSE
96 ,p_kf_pos_no_rv_tab in out nocopy
97 per_ri_config_tech_summary.kf_pos_no_rv_tab
98 ,p_kf_pos_no_rv_seg_tab in out nocopy
99 per_ri_config_tech_summary.kf_pos_no_rv_seg_tab);
100
101 PROCEDURE create_grades_no_rv_keyflex (p_configuration_code in varchar2
102 ,p_technical_summary_mode in boolean default FALSE
103 ,p_kf_grd_no_rv_tab in out nocopy
104 per_ri_config_tech_summary.kf_grd_no_rv_tab
105 ,p_kf_grd_no_rv_seg_tab in out nocopy
106 per_ri_config_tech_summary.kf_grd_no_rv_seg_tab);
107
108 PROCEDURE create_application_level_resp(p_configuration_code in varchar2
109 ,p_technical_summary_mode in boolean default FALSE
110 ,p_profile_apps_tab in out nocopy
111 per_ri_config_tech_summary.profile_apps_tab);
112
113
114 PROCEDURE create_resp_level_profile(p_configuration_code in varchar2
115 ,p_responsibility_key in varchar2
116 ,p_technical_summary_mode in boolean default FALSE
117 ,p_profile_resp_tab in out nocopy
118 per_ri_config_tech_summary.profile_resp_tab);
119
120 PROCEDURE create_bg_id_and_sg_id_profile(p_configuration_code in varchar2
121 ,p_responsibility_key in varchar2
122 ,p_business_group_name in varchar2
123 ,p_technical_summary_mode in boolean default FALSE
124 ,p_bg_sg_ut_profile_resp_tab in out nocopy
125 per_ri_config_tech_summary.profile_resp_tab);
126
127 END per_ri_config_fnd_hr_entity;
128