13: end loop;
14: return substr( v_csv, 2 );
15: exception
16: when others then
17: htp.p(SQLERRM);
18: end;
19:
20: -- Required for padding strings with non-breaking spaces. Used in buildselectboxes
21: function nbsppad( p_string in varchar2, p_length in number ) return varchar2
42: )
43: as
44: l_label varchar2(80);
45: begin
46: htp.tableRowOpen;
47: htp.prn( '
43: as
44: l_label varchar2(80);
45: begin
46: htp.tableRowOpen;
47: htp.prn( '
45: begin
46: htp.tableRowOpen;
47: htp.prn( '
50: for i in 1 .. p_leftids.count loop
51: -- if added to prevent truncation of strings longer than 32 from the rpad function
52: -- mputman 1420084
53: IF length(p_leftnames(i))<32 THEN
54: htp.formSelectOption( replace( rpad( p_leftnames(i), 32), ' ', ' ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
55: ELSE
56: htp.formSelectOption( replace( p_leftnames(i), ' ', ' ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
57: END IF;
58: end loop;
52: -- mputman 1420084
53: IF length(p_leftnames(i))<32 THEN
54: htp.formSelectOption( replace( rpad( p_leftnames(i), 32), ' ', ' ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
55: ELSE
56: htp.formSelectOption( replace( p_leftnames(i), ' ', ' ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
57: END IF;
58: end loop;
59:
60: if p_leftids.count = 0 then
57: END IF;
58: end loop;
59:
60: if p_leftids.count = 0 then
61: htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
62: end if;
63: htp.formSelectClose;
64: htp.prn( '
59:
60: if p_leftids.count = 0 then
61: htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
62: end if;
63: htp.formSelectClose;
64: htp.prn( '
60: if p_leftids.count = 0 then
61: htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
62: end if;
63: htp.formSelectClose;
64: htp.prn( '' );
65:
66: select ATTRIBUTE_LABEL_LONG
67: into l_label
68: from AK_ATTRIBUTES_VL
67: into l_label
68: from AK_ATTRIBUTES_VL
69: where ATTRIBUTE_CODE = 'CSI_SHTL_MOVEALL';
70:
71: htp.tableData( '' ||
72: '
73: ' align=bottom border=0 alt="'|| l_label || '">' ||
74: '' );
75:
72: '
73: ' align=bottom border=0 alt="'|| l_label || '">' ||
74: '' );
75:
76: htp.prn( '
73: ' align=bottom border=0 alt="'|| l_label || '">' ||
74: '' );
75:
76: htp.prn( '
78: for i in 1 .. p_rightids.count loop
79: -- if added to prevent truncation of strings longer than 32 from the rpad function
80: -- mputman 1420084
81: IF lengthb(p_rightnames(i))<32 THEN
82: htp.formSelectOption( replace( rpad( p_rightnames(i), 32), ' ', ' ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
83: ELSE
84: htp.formSelectOption( replace( p_rightnames(i), ' ', ' ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
85: END IF;
86: end loop;
80: -- mputman 1420084
81: IF lengthb(p_rightnames(i))<32 THEN
82: htp.formSelectOption( replace( rpad( p_rightnames(i), 32), ' ', ' ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
83: ELSE
84: htp.formSelectOption( replace( p_rightnames(i), ' ', ' ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
85: END IF;
86: end loop;
87: if p_rightids.count = 0 then
88: htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
84: htp.formSelectOption( replace( p_rightnames(i), ' ', ' ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
85: END IF;
86: end loop;
87: if p_rightids.count = 0 then
88: htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
89: end if;
90: htp.formSelectClose;
91:
92:
86: end loop;
87: if p_rightids.count = 0 then
88: htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
89: end if;
90: htp.formSelectClose;
91:
92:
93: htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));
94: htp.formHidden( 'p_region_id', p_regionid);
89: end if;
90: htp.formSelectClose;
91:
92:
93: htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));
94: htp.formHidden( 'p_region_id', p_regionid);
95: htp.formHidden( 'p_page_id', p_pageid);
96: htp.prn( '
90: htp.formSelectClose;
91:
92:
93: htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));
94: htp.formHidden( 'p_region_id', p_regionid);
95: htp.formHidden( 'p_page_id', p_pageid);
96: htp.prn( '' );
97:
98: select ATTRIBUTE_LABEL_LONG
91:
92:
93: htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));
94: htp.formHidden( 'p_region_id', p_regionid);
95: htp.formHidden( 'p_page_id', p_pageid);
96: htp.prn( '' );
97:
98: select ATTRIBUTE_LABEL_LONG
99: into l_label
92:
93: htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));
94: htp.formHidden( 'p_region_id', p_regionid);
95: htp.formHidden( 'p_page_id', p_pageid);
96: htp.prn( '' );
97:
98: select ATTRIBUTE_LABEL_LONG
99: into l_label
100: from AK_ATTRIBUTES_VL
99: into l_label
100: from AK_ATTRIBUTES_VL
101: where ATTRIBUTE_CODE = 'JTFB_ADMIN_TOP';
102:
103: htp.tableData( '' ||
104: '' ||
106: '' );
107: htp.tableRowClose;
103: htp.tableData( '' ||
104: '' ||
106: '' );
107: htp.tableRowClose;
108:
109: htp.tableRowOpen;
110:
111: select ATTRIBUTE_LABEL_LONG
105: l_label || '">' ||
106: '' );
107: htp.tableRowClose;
108:
109: htp.tableRowOpen;
110:
111: select ATTRIBUTE_LABEL_LONG
112: into l_label
113: from AK_ATTRIBUTES_VL
112: into l_label
113: from AK_ATTRIBUTES_VL
114: where ATTRIBUTE_CODE = 'CSI_SHTL_MOVE';
115:
116: htp.tableData( '' ||
117: '' ||
119: '' );
120:
122: into l_label
123: from AK_ATTRIBUTES_VL
124: where ATTRIBUTE_CODE = 'BIS_UP';
125:
126: htp.tableData( '' ||
127: '' ||
129: '' );
130: htp.tableRowClose;
126: htp.tableData( '' ||
127: '' ||
129: '' );
130: htp.tableRowClose;
131:
132: htp.tableRowOpen;
133:
134: select ATTRIBUTE_LABEL_LONG
128: l_label || '">' ||
129: '' );
130: htp.tableRowClose;
131:
132: htp.tableRowOpen;
133:
134: select ATTRIBUTE_LABEL_LONG
135: into l_label
136: from AK_ATTRIBUTES_VL
135: into l_label
136: from AK_ATTRIBUTES_VL
137: where ATTRIBUTE_CODE = 'CSI_SHTL_REMOVE';
138:
139: htp.tableData( '' ||
140: '' ||
142: '' );
143:
145: into l_label
146: from AK_ATTRIBUTES_VL
147: where ATTRIBUTE_CODE = 'BIS_DOWN';
148:
149: htp.tableData( '' ||
150: '' ||
152: '' );
153: htp.tableRowClose;
149: htp.tableData( '' ||
150: '' ||
152: '' );
153: htp.tableRowClose;
154:
155: htp.tableRowOpen;
156:
157: select ATTRIBUTE_LABEL_LONG
151: l_label || '">' ||
152: '' );
153: htp.tableRowClose;
154:
155: htp.tableRowOpen;
156:
157: select ATTRIBUTE_LABEL_LONG
158: into l_label
159: from AK_ATTRIBUTES_VL
158: into l_label
159: from AK_ATTRIBUTES_VL
160: where ATTRIBUTE_CODE = 'CSI_SHTL_REMOVEALL';
161:
162: htp.tableData( '' ||
163: '' ||
165: '' );
166:
168: into l_label
169: from AK_ATTRIBUTES_VL
170: where ATTRIBUTE_CODE = 'JTFB_ADMIN_BOTTOM';
171:
172: htp.tableData( '' ||
173: '' ||
175: '' );
176: htp.tableRowClose;
172: htp.tableData( '' ||
173: '' ||
175: '' );
176: htp.tableRowClose;
177: exception
178: when others then
179: raise BUILDSELECTBOXES_EXCEPTION;
180: end buildselectboxes;