[Home] [Help]
PACKAGE: APPS.PER_RI_CONFIG_MAIN
Source
1 PACKAGE per_ri_config_main AS
2 /* $Header: perricmn.pkh 120.2.12010000.1 2008/07/28 05:48:20 appldev ship $ */
3
4 g_configuration_user_name constant varchar2(30) := 'HRMS_USER';
5 g_description_suffix_string constant varchar2(60) := ' - Created by Enterprise Structures Configuration';
6 g_description_string constant varchar2(60) := 'Generated by Enterprise Structures Configuration';
7 g_bg_name_suffix_string constant varchar2(60) := ' BG';
8
9 g_global_job_structure_name constant varchar2(30) := 'Global Job Structure';
10 g_global_pos_structure_name constant varchar2(30) := 'Global Pos Structure';
11 g_global_grd_structure_name constant varchar2(30) := 'Global Grade Structure';
12 g_global_pea_structure_name constant varchar2(30) := 'Global Group Structure';
13 g_global_cmp_structure_name constant varchar2(30) := 'Global Comp Structure';
14 g_global_cst_structure_name constant varchar2(30) := 'Global Costing Structure';
15
16 g_job_rv_struct_def_string constant varchar2(30) default ' Job KF';
17 g_pos_rv_struct_def_string constant varchar2(30) default ' Pos KF';
18 g_grd_rv_struct_def_string constant varchar2(30) default ' Grade KF';
19
20 g_config_effective_date date := TRUNC(TO_DATE('1951/01/01', 'YYYY/MM/DD'));
21 g_config_effective_end_date date := TRUNC(TO_DATE('4712/12/31', 'YYYY/MM/DD'));
22
23 g_global_dp_link_value constant number(9) := 1;
24
25 g_global_fed_grd_struct_name constant varchar2(30) := 'US_FEDERAL_GRADE';
26 g_global_fed_grd_non_fed_att constant varchar2(30) := 'GRD_NON_FEDERAL';
27 g_global_fed_grd_non_att constant varchar2(30) := 'GRD_FEDERAL';
28 g_global_fed_grd_seg_count constant number(9) := 3;
29
30 g_global_fed_job_non_fed_att constant varchar2(30) := 'JOB_NON_FEDERAL';
31 g_global_fed_job_non_att constant varchar2(30) := 'JOB_FEDERAL';
32 g_global_fed_job_seg_count constant number(9) := 1;
33
34 g_global_fed_pos_non_fed_att constant varchar2(30) := 'POS_NON_FEDERAL';
35 g_global_fed_pos_non_att constant varchar2(30) := 'POS_FEDERAL';
36 g_global_fed_pos_seg_count constant number(9) := 4;
37
38 g_technical_summary_mode boolean default FALSE;
39
40 PROCEDURE create_technical_summary (p_errbuff out nocopy varchar2
41 ,p_retcode out nocopy number
42 ,p_configuration_code in varchar2
43 ,p_technical_summary_mode in boolean default false
44 ,p_user_clob in out nocopy clob
45 ,p_resp_clob out nocopy clob
46 ,p_location_clob out nocopy clob
47 ,p_bg_clob out nocopy clob
48 ,p_sg_clob out nocopy clob
49 ,p_int_hrms_clob out nocopy clob
50 ,p_key_str_clob out nocopy clob
51 ,p_key_seg_clob out nocopy clob
52 ,p_site_profile_clob out nocopy clob
53 ,p_profile_apps_clob out nocopy clob
54 ,p_profile_resp_clob out nocopy clob
55 ,p_organization_clob out nocopy clob
56 ,p_org_class_clob out nocopy clob
57 --balchand
58 ,p_org_class_for_pv_clob out nocopy clob
59 ,p_org_hierarchy_ele_clob out nocopy clob
60 --balchand
61 ,p_str_seg_for_pv_clob out nocopy clob
62 ,p_org_hier_ele_for_pv_clob out nocopy clob
63 ,p_org_hierarchy_clob out nocopy clob
64 ,p_post_install_clob out nocopy clob
65 ,p_kf_job_str_clob out nocopy clob
66 ,p_kf_job_rv_str_clob out nocopy clob
67 ,p_kf_job_no_rv_str_clob out nocopy clob
68 ,p_kf_pos_str_clob out nocopy clob
69 ,p_kf_pos_rv_str_clob out nocopy clob
70 ,p_kf_pos_no_rv_str_clob out nocopy clob
71 ,p_kf_grd_str_clob out nocopy clob
72 ,p_kf_cmp_str_clob out nocopy clob
73 ,p_kf_grp_str_clob out nocopy clob
74 ,p_kf_cost_str_clob out nocopy clob
75 ,p_kf_job_seg_clob out nocopy clob
76 ,p_kf_job_rv_seg_clob out nocopy clob
77 ,p_kf_job_no_rv_seg_clob out nocopy clob
78 ,p_kf_pos_seg_clob out nocopy clob
79 ,p_kf_pos_rv_seg_clob out nocopy clob
80 ,p_kf_grd_seg_clob out nocopy clob
81 ,p_kf_grd_no_rv_seg_clob out nocopy clob
82 ,p_kf_grd_rv_seg_clob out nocopy clob
83 ,p_kf_grp_seg_clob out nocopy clob
84 ,p_kf_cmp_seg_clob out nocopy clob
85 ,p_kf_cost_seg_clob out nocopy clob
86 ,p_kf_pos_no_rv_seg_clob out nocopy clob);
87
88 PROCEDURE load_enterprise_configuration (p_errbuff out nocopy varchar2
89 ,p_retcode out nocopy number
90 ,p_configuration_code in varchar2);
91 END per_ri_config_main;
92