DBA Data[Home] [Help]

APPS.ICX_PAGE_WIDGET dependencies on HTP

Line 17: htp.p(SQLERRM);

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

Line 46: htp.tableRowOpen;

42: )
43: as
44: l_label varchar2(80);
45: begin
46: htp.tableRowOpen;
47: htp.prn( '' );
48:
49: htp.formSelectOpen( 'p_leftselect', nsize => 8, cattributes=>'multiple');
50: for i in 1 .. p_leftids.count loop

Line 47: htp.prn( '' );

43: as
44: l_label varchar2(80);
45: begin
46: htp.tableRowOpen;
47: htp.prn( '' );
48:
49: htp.formSelectOpen( 'p_leftselect', nsize => 8, cattributes=>'multiple');
50: for i in 1 .. p_leftids.count loop
51: -- if added to prevent truncation of strings longer than 32 from the rpad function

Line 49: htp.formSelectOpen( 'p_leftselect', nsize => 8, cattributes=>'multiple');

45: begin
46: htp.tableRowOpen;
47: htp.prn( '' );
48:
49: htp.formSelectOpen( 'p_leftselect', nsize => 8, cattributes=>'multiple');
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

Line 54: htp.formSelectOption( replace( rpad( p_leftnames(i), 32), ' ', '  ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );

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;

Line 56: htp.formSelectOption( replace( p_leftnames(i), ' ', '  ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );

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

Line 61: htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );

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( '' );
65:

Line 63: htp.formSelectClose;

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( '' );
65:
66: select ATTRIBUTE_LABEL_LONG
67: into l_label

Line 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

Line 71: htp.tableData( '' ||

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:

Line 76: htp.prn( '' );

72: ' 73: ' align=bottom border=0 alt="'|| l_label || '">' ||
74: '' );
75:
76: htp.prn( '' );
77: htp.formSelectOpen('p_rightselect', nsize => 8, cattributes=>'multiple');
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

Line 77: htp.formSelectOpen('p_rightselect', nsize => 8, cattributes=>'multiple');

73: ' align=bottom border=0 alt="'|| l_label || '">' ||
74: '' );
75:
76: htp.prn( '' );
77: htp.formSelectOpen('p_rightselect', nsize => 8, cattributes=>'multiple');
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

Line 82: htp.formSelectOption( replace( rpad( p_rightnames(i), 32), ' ', '  ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );

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;

Line 84: htp.formSelectOption( replace( p_rightnames(i), ' ', '  ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );

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=""' );

Line 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:

Line 90: htp.formSelectClose;

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);

Line 93: htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));

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( '' );
97:

Line 94: htp.formHidden( 'p_region_id', p_regionid);

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

Line 95: htp.formHidden( 'p_page_id', p_pageid);

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

Line 96: htp.prn( '' );

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

Line 103: htp.tableData( '' ||

99: into l_label
100: from AK_ATTRIBUTES_VL
101: where ATTRIBUTE_CODE = 'JTFB_ADMIN_TOP';
102:
103: htp.tableData( '
' ||
104: ''||<br>
105:               l_label || '' ||
106: '
' );
107: htp.tableRowClose;

Line 107: htp.tableRowClose;

103: htp.tableData( '' ||
104: ''||<br>
105:               l_label || '' ||
106: '
' );
107: htp.tableRowClose;
108:
109: htp.tableRowOpen;
110:
111: select ATTRIBUTE_LABEL_LONG

Line 109: htp.tableRowOpen;

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

Line 116: htp.tableData( '' ||

112: into l_label
113: from AK_ATTRIBUTES_VL
114: where ATTRIBUTE_CODE = 'CSI_SHTL_MOVE';
115:
116: htp.tableData( '
' ||
117: ''||<br>
118:               l_label || '' ||
119: '
' );
120:

Line 126: htp.tableData( '' ||

122: into l_label
123: from AK_ATTRIBUTES_VL
124: where ATTRIBUTE_CODE = 'BIS_UP';
125:
126: htp.tableData( '
' ||
127: ''||<br>
128:               l_label || '' ||
129: '
' );
130: htp.tableRowClose;

Line 130: htp.tableRowClose;

126: htp.tableData( '' ||
127: ''||<br>
128:               l_label || '' ||
129: '
' );
130: htp.tableRowClose;
131:
132: htp.tableRowOpen;
133:
134: select ATTRIBUTE_LABEL_LONG

Line 132: htp.tableRowOpen;

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

Line 139: htp.tableData( '' ||

135: into l_label
136: from AK_ATTRIBUTES_VL
137: where ATTRIBUTE_CODE = 'CSI_SHTL_REMOVE';
138:
139: htp.tableData( '
' ||
140: ''||<br>
141:                   l_label || '' ||
142: '
' );
143:

Line 149: htp.tableData( '' ||

145: into l_label
146: from AK_ATTRIBUTES_VL
147: where ATTRIBUTE_CODE = 'BIS_DOWN';
148:
149: htp.tableData( '
' ||
150: ''||<br>
151:               l_label || '' ||
152: '
' );
153: htp.tableRowClose;

Line 153: htp.tableRowClose;

149: htp.tableData( '' ||
150: ''||<br>
151:               l_label || '' ||
152: '
' );
153: htp.tableRowClose;
154:
155: htp.tableRowOpen;
156:
157: select ATTRIBUTE_LABEL_LONG

Line 155: htp.tableRowOpen;

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

Line 162: htp.tableData( '' ||

158: into l_label
159: from AK_ATTRIBUTES_VL
160: where ATTRIBUTE_CODE = 'CSI_SHTL_REMOVEALL';
161:
162: htp.tableData( '
' ||
163: ''||<br>
164:                   l_label || '' ||
165: '
' );
166:

Line 172: htp.tableData( '' ||

168: into l_label
169: from AK_ATTRIBUTES_VL
170: where ATTRIBUTE_CODE = 'JTFB_ADMIN_BOTTOM';
171:
172: htp.tableData( '
' ||
173: ''||<br>
174:               l_label || '' ||
175: '
' );
176: htp.tableRowClose;

Line 176: htp.tableRowClose;

172: htp.tableData( '' ||
173: ''||<br>
174:               l_label || '' ||
175: '
' );
176: htp.tableRowClose;
177: exception
178: when others then
179: raise BUILDSELECTBOXES_EXCEPTION;
180: end buildselectboxes;