1 Package BEN_CWB_WEBADI_UTILS AUTHID CURRENT_USER as
2 /* $Header: bencwbadiutl.pkh 120.4 2011/05/17 11:45:49 nchinnam ship $ */
3
4 TYPE column_rec IS RECORD(
5 p_sequence NUMBER
6 ,p_interface_seq NUMBER
7 );
8
9 TYPE column_list IS TABLE OF column_rec;
10
11 TYPE proposed_grade_rec IS RECORD(
12 group_per_in_ler_id NUMBER
13 ,proposed_grade_range VARCHAR2(2000)
14 ,proposed_grade_mid NUMBER
15 ,proposed_grade_comparatio NUMBER
16 );
17
18 g_proposed_grade_rec proposed_grade_rec;
19
20 PROCEDURE create_cwb_layout(
21 p_layout_code IN VARCHAR2
22 ,p_user_name IN VARCHAR2
23 ,p_base_layout_code IN VARCHAR2);
24
25 PROCEDURE update_cwb_layout(
26 p_layout_code IN VARCHAR2
27 ,p_base_layout IN VARCHAR2
28 ,p_interface_seq IN VARCHAR2
29 ,p_rendered_seq IN VARCHAR2
30 ,p_group_pl_id IN NUMBER Default Null
31 ,p_lf_evt_ocrd_dt IN DATE Default Null
32 ,p_download_switch OUT NOCOPY VARCHAR2);
33
34
35 FUNCTION encrypt(input_string IN VARCHAR2) RETURN VARCHAR2;
36
37 FUNCTION decrypt(input_string IN VARCHAR2) RETURN VARCHAR2;
38
39 FUNCTION lock_cwb_layout(p_integrator_code IN Varchar2
40 ,p_base_layout_code IN VARCHAR2) RETURN VARCHAR2;
41
42 PROCEDURE unlock_cwb_layout(p_layout_code IN VARCHAR2);
43
44 PROCEDURE delete_custom_data(p_key IN VARCHAR2,
45 p_region_key IN VARCHAR2,
46 p_integrator_code IN VARCHAR2);
47
48 PROCEDURE manipulate_selected_data( p_key IN VARCHAR2
49 ,p_region_key IN VARCHAR2
50 ,p_integrator_code IN VARCHAR2
51 ,p_interface_code IN VARCHAR2
52 ,p_interface_col_code IN VARCHAR2
53 ,p_display_seq IN Number );
54
55 PROCEDURE update_cwb_custom_layout( p_key IN VARCHAR2
56 ,p_region_key IN VARCHAR2
57 ,p_integrator_code IN VARCHAR2
58 ,p_interface_code IN VARCHAR2
59 ,p_act_layout_code IN VARCHAR2
60 ,p_base_layout_code IN VARCHAR2
61 ,p_group_pl_id IN NUMBER Default Null
62 ,p_lf_evt_ocrd_dt IN DATE Default Null
63 ,p_download_switch OUT NOCOPY VARCHAR2);
64
65 FUNCTION chk_entry_in_custom_table( p_key IN VARCHAR2
66 ,p_region_key IN VARCHAR2
67 ,p_integrator_code IN VARCHAR2
68 ) Return Varchar;
69
70 FUNCTION validate_grade_range(
71 P_PL_PERSON_RATE_ID IN VARCHAR2
72 ,P_P_OPT1_PERSON_RATE_ID IN VARCHAR2
73 ,P_P_OPT2_PERSON_RATE_ID IN VARCHAR2
74 ,P_P_OPT3_PERSON_RATE_ID IN VARCHAR2
75 ,P_P_OPT4_PERSON_RATE_ID IN VARCHAR2
76 ,P_PL_WS_VAL IN VARCHAR2
77 ,P_OPT1_WS_VAL IN VARCHAR2
78 ,P_OPT2_WS_VAL IN VARCHAR2
79 ,P_OPT3_WS_VAL IN VARCHAR2
80 ,P_OPT4_WS_VAL IN VARCHAR2
81 )
82 RETURN VARCHAR2;
83
84 FUNCTION get_new_salary(
85 P_PL_PERSON_RATE_ID IN VARCHAR2 Default Null
86 ,P_P_OPT1_PERSON_RATE_ID IN VARCHAR2 Default Null
87 ,P_P_OPT2_PERSON_RATE_ID IN VARCHAR2 Default Null
88 ,P_P_OPT3_PERSON_RATE_ID IN VARCHAR2 Default Null
89 ,P_P_OPT4_PERSON_RATE_ID IN VARCHAR2 Default Null
90 ,P_PL_WS_VAL IN VARCHAR2 Default Null
91 ,P_OPT1_WS_VAL IN VARCHAR2 Default Null
92 ,P_OPT2_WS_VAL IN VARCHAR2 Default Null
93 ,P_OPT3_WS_VAL IN VARCHAR2 Default Null
94 ,P_OPT4_WS_VAL IN VARCHAR2 Default Null
95 )
96 RETURN NUMBER;
97
98 FUNCTION get_new_salary(
99 p_group_per_in_ler_id IN number Default Null
100 )
101 RETURN NUMBER;
102
103 FUNCTION get_proposed_grade_range(
104 p_group_per_in_ler_id IN number
105 ,p_asg_updt_eff_date IN varchar2
106 )
107 RETURN varchar2 ;
108
109 FUNCTION get_proposed_grade_mid(
110 p_group_per_in_ler_id IN number
111 ,p_asg_updt_eff_date IN varchar2
112 )
113 RETURN number;
114
115 FUNCTION get_proposed_grade_comparatio(
116 p_group_per_in_ler_id IN number
117 ,p_asg_updt_eff_date IN varchar2
118 )
119 RETURN number;
120
121 FUNCTION get_group_per_in_ler_id (P_PERSON_RATE_ID IN NUMBER Default Null
122 ,P_OPT1_PERSON_RATE_ID IN NUMBER Default Null
123 ,P_OPT2_PERSON_RATE_ID IN NUMBER Default Null
124 ,P_OPT3_PERSON_RATE_ID IN NUMBER Default Null
125 ,P_OPT4_PERSON_RATE_ID IN NUMBER Default Null)
126 Return Number;
127
128 Type show_hide_data_tab IS RECORD
129 ( p_type Varchar2(5)
130 ,p_opt_defined Varchar2(1)
131 ,p_ws_defined Varchar2(1)
132 ,p_eligy_sal_defined Varchar2(1)
133 ,p_nnmntry_uom Varchar2(1)
134 ,p_ws_sub_acty_typ_cd Varchar2(1)
135 );
136
137 TYPE p_show_hide_data IS TABLE OF show_hide_data_tab INDEX BY BINARY_INTEGER;
138
139 procedure check_hidden_worksheet_columns( p_group_pl_id IN NUMBER
140 ,p_lf_evt_ocrd_dt IN DATE
141 ,p_show_hide_data OUT NOCOPY p_show_hide_data
142 );
143
144 procedure upsert_webadi_download_records(p_session_id IN Varchar2,
145 p_download_type IN Varchar2,
146 p_param1 IN Varchar2 default null,
147 p_param2 IN Varchar2 default null,
148 p_param3 IN Varchar2 default null,
149 p_param4 IN Varchar2 default null,
150 p_param5 IN Varchar2 default null,
151 p_param6 IN Varchar2 default null,
152 p_param7 IN Varchar2 default null,
153 p_param8 IN Varchar2 default null,
154 p_param9 IN Varchar2 default null,
155 p_param10 IN Varchar2 default null
156 );
157 /*
158 || BINARY TO INTEGER CONVERSION
159 ||
160 || In: a binary value as a string, e.g. '100101'
161 || Out: an integer value
162 */
163 FUNCTION bin2int(bin VARCHAR2) RETURN PLS_INTEGER;
164
165 /*
166 || INTEGER TO BINARY CONVERSION
167 ||
168 || In: an integer value
169 || Out: a binary value as a string
170 */
171 FUNCTION int2bin(int PLS_INTEGER) RETURN VARCHAR2;
172
173 /*
174 || HEXADECIMAL TO INTEGER CONVERSION
175 ||
176 || In: a hexadecimal value as a string, e.g. 'AE0'
177 || Out: an integer value
178 */
179 FUNCTION hex2int(hex VARCHAR2) RETURN PLS_INTEGER;
180
181 /*
182 || INTEGER TO HEXADECIMAL CONVERSION
183 ||
184 || In: an integer value
185 || Out: a hexadecimal value as a string
186 */
187 FUNCTION int2hex(n PLS_INTEGER) RETURN VARCHAR2;
188
189 /*
190 || INTEGER TO ANY BASE CONVERSION
191 ||
192 || In: an integer value,
193 || the base to convert to (up to 16)
194 || Out: the value in the specified base as a string
195 */
196 FUNCTION int2base(int PLS_INTEGER,base PLS_INTEGER) RETURN VARCHAR2;
197
198 /*
199 || ANY BASE TO INTEGER CONVERSION
200 ||
201 || In: a number in any base (up to 16) as a string,
202 || the base to convert from
203 || Out: an integer value
204 */
205 FUNCTION base2int(num VARCHAR2,base PLS_INTEGER) RETURN PLS_INTEGER;
206
207
208 END ben_cwb_webadi_utils;
[Home] [Help]