1 Package BEN_CWB_WEBADI_UTILS as
2 /* $Header: bencwbadiutl.pkh 120.0 2005/05/28 13:33:12 appldev noship $ */
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
12 PROCEDURE create_cwb_layout(
13 p_layout_code IN VARCHAR2
14 ,p_user_name IN VARCHAR2
15 ,p_base_layout_code IN VARCHAR2);
16
17 PROCEDURE update_cwb_layout(
18 p_layout_code IN VARCHAR2
19 ,p_base_layout IN VARCHAR2
20 ,p_interface_seq IN VARCHAR2
21 ,p_rendered_seq IN VARCHAR2
22 ,p_group_pl_id IN NUMBER Default Null
23 ,p_lf_evt_ocrd_dt IN DATE Default Null
24 ,p_download_switch OUT NOCOPY VARCHAR2);
25
26
27 FUNCTION encrypt(input_string IN VARCHAR2) RETURN VARCHAR2;
28
29 FUNCTION decrypt(input_string IN VARCHAR2) RETURN VARCHAR2;
30
31 FUNCTION lock_cwb_layout(p_integrator_code IN Varchar2
32 ,p_base_layout_code IN VARCHAR2) RETURN VARCHAR2;
33
34 PROCEDURE unlock_cwb_layout(p_layout_code IN VARCHAR2);
35
36 PROCEDURE delete_custom_data(p_key IN VARCHAR2,
37 p_integrator_code IN VARCHAR2);
38
39 PROCEDURE manipulate_selected_data( p_key IN VARCHAR2
40 ,p_integrator_code IN VARCHAR2
41 ,p_interface_code IN VARCHAR2
42 ,p_interface_col_code IN VARCHAR2
43 ,p_display_seq IN Number );
44
45 PROCEDURE update_cwb_custom_layout( p_key IN VARCHAR2
46 ,p_integrator_code IN VARCHAR2
47 ,p_interface_code IN VARCHAR2
48 ,p_act_layout_code IN VARCHAR2
49 ,p_base_layout_code IN VARCHAR2
50 ,p_group_pl_id IN NUMBER Default Null
51 ,p_lf_evt_ocrd_dt IN DATE Default Null
52 ,p_download_switch OUT NOCOPY VARCHAR2);
53
54 FUNCTION chk_entry_in_custom_table( p_key IN VARCHAR2
55 ,p_integrator_code IN VARCHAR2
56 ) Return Varchar;
57 Type show_hide_data_tab IS RECORD
58 ( p_type Varchar2(5)
59 ,p_opt_defined Varchar2(1)
60 ,p_ws_defined Varchar2(1)
61 ,p_eligy_sal_defined Varchar2(1)
62 ,p_nnmntry_uom Varchar2(1)
63 ,p_ws_sub_acty_typ_cd Varchar2(1)
64 );
65
66 TYPE p_show_hide_data IS TABLE OF show_hide_data_tab INDEX BY BINARY_INTEGER;
67
71 );
68 procedure check_hidden_worksheet_columns( p_group_pl_id IN NUMBER
69 ,p_lf_evt_ocrd_dt IN DATE
70 ,p_show_hide_data OUT NOCOPY p_show_hide_data
72
73 procedure upsert_webadi_download_records(p_session_id IN Varchar2,
74 p_download_type IN Varchar2,
75 p_param1 IN Varchar2 default null,
76 p_param2 IN Varchar2 default null,
77 p_param3 IN Varchar2 default null,
81 p_param7 IN Varchar2 default null,
78 p_param4 IN Varchar2 default null,
79 p_param5 IN Varchar2 default null,
80 p_param6 IN Varchar2 default null,
82 p_param8 IN Varchar2 default null,
83 p_param9 IN Varchar2 default null,
84 p_param10 IN Varchar2 default null
85 );
86 /*
87 || BINARY TO INTEGER CONVERSION
88 ||
89 || In: a binary value as a string, e.g. '100101'
90 || Out: an integer value
91 */
92 FUNCTION bin2int(bin VARCHAR2) RETURN PLS_INTEGER;
93
94 /*
95 || INTEGER TO BINARY CONVERSION
96 ||
97 || In: an integer value
98 || Out: a binary value as a string
99 */
100 FUNCTION int2bin(int PLS_INTEGER) RETURN VARCHAR2;
101
102 /*
103 || HEXADECIMAL TO INTEGER CONVERSION
104 ||
105 || In: a hexadecimal value as a string, e.g. 'AE0'
106 || Out: an integer value
107 */
108 FUNCTION hex2int(hex VARCHAR2) RETURN PLS_INTEGER;
109
110 /*
111 || INTEGER TO HEXADECIMAL CONVERSION
112 ||
113 || In: an integer value
114 || Out: a hexadecimal value as a string
115 */
116 FUNCTION int2hex(n PLS_INTEGER) RETURN VARCHAR2;
117
118 /*
119 || INTEGER TO ANY BASE CONVERSION
120 ||
121 || In: an integer value,
122 || the base to convert to (up to 16)
123 || Out: the value in the specified base as a string
124 */
125 FUNCTION int2base(int PLS_INTEGER,base PLS_INTEGER) RETURN VARCHAR2;
126
127 /*
128 || ANY BASE TO INTEGER CONVERSION
129 ||
130 || In: a number in any base (up to 16) as a string,
131 || the base to convert from
132 || Out: an integer value
133 */
134 FUNCTION base2int(num VARCHAR2,base PLS_INTEGER) RETURN PLS_INTEGER;
135
136 END ben_cwb_webadi_utils;