1: package body WF_LOV as
2: /* $Header: wflovb.pls 120.1 2005/07/02 03:49:13 appldev ship $ */
3:
4: --
5: -- Error (PRIVATE)
145: END IF;
146:
147: exception
148: when others then
149: Wf_Core.Context('wf_lov', 'OpenLovWinHtml');
150: raise;
151:
152: end OpenLovWinHtml;
153:
177:
178: BEGIN
179:
180: l_url := '"javascript:fnd_open_window('||''''||
181: 'wf_lov.lovapplet'||
182: '?doc_name=' ||p_form_name||
183: '&column_names=' ||p_column_names||
184: '&query_params=' ||p_query_params||
185: '&query_plsql=' ||p_query_plsql||
201:
202: exception
203: when others then
204: rollback;
205: wf_core.context('Wf_Lov', 'GenerateLovURL',
206: p_form_name ,
207: p_query_plsql ,
208: p_query_params ,
209: p_column_names ,
208: p_query_params ,
209: p_column_names ,
210: p_longlist );
211:
212: wf_lov.Error;
213: END GenerateLovURL;
214:
215: procedure CreateButton (when_pressed_url in varchar2,
216: onmouseover in varchar2,
242:
243: exception
244: when others then
245: rollback;
246: wf_core.context('Wf_Lov', 'create_reg_button',when_pressed_url,onmouseover,
247: icon_top,icon_name,show_text);
248: wf_lov.Error;
249:
250: end CreateButton;
244: when others then
245: rollback;
246: wf_core.context('Wf_Lov', 'create_reg_button',when_pressed_url,onmouseover,
247: icon_top,icon_name,show_text);
248: wf_lov.Error;
249:
250: end CreateButton;
251:
252: procedure LovApplet(doc_name varchar2,
456: 'function helper()
457: {
458: var encoded_value = '||initial_find|| '
459:
460: document.write("461:
462: document.write("")');
463:
464: htp.p('document.write("
526: wf_lov.error;
527:
528: end LovApplet;
529:
530:
589:
590: htp.p ('
591: 'SRC='||
592: owa_util.get_owa_service_path||
593: 'wf_lov.display_lov_find?p_lov_name='||
594: wfa_html.conv_special_url_chars(p_lov_name)||
595: '&p_display_name='||p_display_name||
596: '&p_validation_callback='|| p_validation_callback||
597: '&p_dest_hidden_field='||p_dest_hidden_field||
610: htp.p('details frame p_display_name is '||p_display_name);
611: htp.p ('
612: 'SRC='||
613: owa_util.get_owa_service_path||
614: 'wf_lov.display_lov_details?p_lov_name='||
615: wfa_html.conv_special_url_chars(p_lov_name)||
616: '&p_display_name='||p_display_name||
617: '&p_validation_callback='||p_validation_callback||
618: '&p_dest_hidden_field='||p_dest_hidden_field||
644:
645: exception
646: when others then
647: rollback;
648: wf_core.context('Wf_Lov', 'display_lov');
649: wf_lov.error;
650:
651: end display_lov;
652:
645: exception
646: when others then
647: rollback;
648: wf_core.context('Wf_Lov', 'display_lov');
649: wf_lov.error;
650:
651: end display_lov;
652:
653:
780:
781: exception
782: when others then
783: rollback;
784: wf_core.context('Wf_Lov', 'display_lov_find');
785: wf_lov.error;
786:
787: end display_lov_find;
788:
781: exception
782: when others then
783: rollback;
784: wf_core.context('Wf_Lov', 'display_lov_find');
785: wf_lov.error;
786:
787: end display_lov_find;
788:
789:
908: end if;
909:
910: htp.p('function LOV_copy(num) {
911: '||
912: p_dest_display_field||'=document.WF_LOV_FRM.h_display[num].value;
913: '||
914: p_dest_hidden_field||'=document.WF_LOV_FRM.h_hidden[num].value;
915: parent.self.close();
916: }');
910: htp.p('function LOV_copy(num) {
911: '||
912: p_dest_display_field||'=document.WF_LOV_FRM.h_display[num].value;
913: '||
914: p_dest_hidden_field||'=document.WF_LOV_FRM.h_hidden[num].value;
915: parent.self.close();
916: }');
917:
918: htp.p('');
923:
924: htp.p('
953:
954: end if;
955:
956:
957: wf_lov.g_define_rec.total_rows := 0;
958: wf_lov.g_define_rec.add_attr1_title := null;
959: wf_lov.g_define_rec.add_attr2_title := null;
960: wf_lov.g_define_rec.add_attr3_title := null;
961: wf_lov.g_define_rec.add_attr4_title := null;
954: end if;
955:
956:
957: wf_lov.g_define_rec.total_rows := 0;
958: wf_lov.g_define_rec.add_attr1_title := null;
959: wf_lov.g_define_rec.add_attr2_title := null;
960: wf_lov.g_define_rec.add_attr3_title := null;
961: wf_lov.g_define_rec.add_attr4_title := null;
962: wf_lov.g_define_rec.add_attr5_title := null;
955:
956:
957: wf_lov.g_define_rec.total_rows := 0;
958: wf_lov.g_define_rec.add_attr1_title := null;
959: wf_lov.g_define_rec.add_attr2_title := null;
960: wf_lov.g_define_rec.add_attr3_title := null;
961: wf_lov.g_define_rec.add_attr4_title := null;
962: wf_lov.g_define_rec.add_attr5_title := null;
963: wf_lov.g_value_tbl.delete;
956:
957: wf_lov.g_define_rec.total_rows := 0;
958: wf_lov.g_define_rec.add_attr1_title := null;
959: wf_lov.g_define_rec.add_attr2_title := null;
960: wf_lov.g_define_rec.add_attr3_title := null;
961: wf_lov.g_define_rec.add_attr4_title := null;
962: wf_lov.g_define_rec.add_attr5_title := null;
963: wf_lov.g_value_tbl.delete;
964:
957: wf_lov.g_define_rec.total_rows := 0;
958: wf_lov.g_define_rec.add_attr1_title := null;
959: wf_lov.g_define_rec.add_attr2_title := null;
960: wf_lov.g_define_rec.add_attr3_title := null;
961: wf_lov.g_define_rec.add_attr4_title := null;
962: wf_lov.g_define_rec.add_attr5_title := null;
963: wf_lov.g_value_tbl.delete;
964:
965: if (p_autoquery <> 'Y') THEN
958: wf_lov.g_define_rec.add_attr1_title := null;
959: wf_lov.g_define_rec.add_attr2_title := null;
960: wf_lov.g_define_rec.add_attr3_title := null;
961: wf_lov.g_define_rec.add_attr4_title := null;
962: wf_lov.g_define_rec.add_attr5_title := null;
963: wf_lov.g_value_tbl.delete;
964:
965: if (p_autoquery <> 'Y') THEN
966: --<3310020:rwunderl>
959: wf_lov.g_define_rec.add_attr2_title := null;
960: wf_lov.g_define_rec.add_attr3_title := null;
961: wf_lov.g_define_rec.add_attr4_title := null;
962: wf_lov.g_define_rec.add_attr5_title := null;
963: wf_lov.g_value_tbl.delete;
964:
965: if (p_autoquery <> 'Y') THEN
966: --<3310020:rwunderl>
967: --Validating that the callback is authorized.
1054: htp.tableRowOpen;
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1063:
1089: p_display_name || '">'||
1090: ''|| p_display_name ||
1091: '');
1092: end if;
1093: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1094:
1095: htp.p('
1092: end if;
1093: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1094:
1095: htp.p('
1093: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1094:
1095: htp.p('
1100: l_ncols := l_ncols + 1;
1101:
1102: end if;
1103:
1104: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1105:
1106: htp.p('
1103:
1104: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1105:
1106: htp.p('
1104: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1105:
1106: htp.p('
1111: l_ncols := l_ncols + 1;
1112:
1113: end if;
1114:
1115: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1116:
1117: htp.p('
1114:
1115: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1116:
1117: htp.p('
1115: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1116:
1117: htp.p('
1122: l_ncols := l_ncols + 1;
1123:
1124: end if;
1125:
1126: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1127:
1128: htp.p('
1125:
1126: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1127:
1128: htp.p('
1126: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1127:
1128: htp.p('
1133: l_ncols := l_ncols + 1;
1134:
1135: end if;
1136:
1137: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1138:
1139: htp.p('
1136:
1137: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1138:
1139: htp.p('
1137: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1138:
1139: htp.p('
1148: htp.tablerowclose;
1149: /*
1150: ** Loop through the data
1151: */
1152: for ii in 1..wf_lov.g_value_tbl.count loop
1153:
1154: -- display one row of data
1155: if (round(ii/2) = ii/2) then
1156: htp.p('
1159: end if;
1160:
1161: if (p_display_key='Y') then
1162: htp.tabledata (''||
1163: wf_lov.g_value_tbl(ii).display_value||'',
1164: cattributes=>'headers="' || l_display_name || '"');
1165: else
1166: htp.tabledata (''||
1167: wf_lov.g_value_tbl(ii).display_value||'',
1163: wf_lov.g_value_tbl(ii).display_value||'',
1164: cattributes=>'headers="' || l_display_name || '"');
1165: else
1166: htp.tabledata (''||
1167: wf_lov.g_value_tbl(ii).display_value||'',
1168: cattributes=>'headers="' || p_display_name || '"');
1169: end if;
1170:
1171: if (l_ncols > 0) then
1169: end if;
1170:
1171: if (l_ncols > 0) then
1172:
1173: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr1_value,
1174: cattributes=>'headers="' ||
1175: wf_lov.g_define_rec.add_attr1_title ||
1176: '"');
1177:
1171: if (l_ncols > 0) then
1172:
1173: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr1_value,
1174: cattributes=>'headers="' ||
1175: wf_lov.g_define_rec.add_attr1_title ||
1176: '"');
1177:
1178: end if;
1179: if (l_ncols > 1) then
1177:
1178: end if;
1179: if (l_ncols > 1) then
1180:
1181: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr2_value,
1182: cattributes=>'headers="' ||
1183: wf_lov.g_define_rec.add_attr2_title ||
1184: '"');
1185:
1179: if (l_ncols > 1) then
1180:
1181: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr2_value,
1182: cattributes=>'headers="' ||
1183: wf_lov.g_define_rec.add_attr2_title ||
1184: '"');
1185:
1186: end if;
1187: if (l_ncols > 2) then
1185:
1186: end if;
1187: if (l_ncols > 2) then
1188:
1189: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr3_value,
1190: cattributes=>'headers="' ||
1191: wf_lov.g_define_rec.add_attr3_title ||
1192: '"');
1193:
1187: if (l_ncols > 2) then
1188:
1189: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr3_value,
1190: cattributes=>'headers="' ||
1191: wf_lov.g_define_rec.add_attr3_title ||
1192: '"');
1193:
1194:
1195: end if;
1194:
1195: end if;
1196: if (l_ncols > 3) then
1197:
1198: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr4_value,
1199: cattributes=>'headers="' ||
1200: wf_lov.g_define_rec.add_attr4_title ||
1201: '"');
1202:
1196: if (l_ncols > 3) then
1197:
1198: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr4_value,
1199: cattributes=>'headers="' ||
1200: wf_lov.g_define_rec.add_attr4_title ||
1201: '"');
1202:
1203:
1204: end if;
1203:
1204: end if;
1205: if (l_ncols > 4) then
1206:
1207: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr5_value,
1208: cattributes=>'headers="' ||
1209: wf_lov.g_define_rec.add_attr5_title ||
1210: '"');
1211:
1205: if (l_ncols > 4) then
1206:
1207: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr5_value,
1208: cattributes=>'headers="' ||
1209: wf_lov.g_define_rec.add_attr5_title ||
1210: '"');
1211:
1212:
1213: end if;
1263:
1264: /*
1265: ** Check to see if you should create the Next button
1266: */
1267: IF (wf_lov.g_value_tbl.count = 10) THEN
1268:
1269: l_start_row := TO_NUMBER(p_start_row) + 10;
1270: if (l_start_row <= wf_lov.g_define_rec.total_rows) then
1271:
1266: */
1267: IF (wf_lov.g_value_tbl.count = 10) THEN
1268:
1269: l_start_row := TO_NUMBER(p_start_row) + 10;
1270: if (l_start_row <= wf_lov.g_define_rec.total_rows) then
1271:
1272: htp.p('
1301: htp.formHidden('h_display', 'xxx');
1302: htp.formHidden('h_hidden', 'xxx');
1303:
1304: for ii in 1..wf_lov.g_value_tbl.count loop
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);
1306: -- ### does not work for double quotes
1307: -- ### replace(wf_lov.g_value_tbl(ii).display_value, '"', '\"'));
1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);
1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));
1303:
1304: for ii in 1..wf_lov.g_value_tbl.count loop
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);
1306: -- ### does not work for double quotes
1307: -- ### replace(wf_lov.g_value_tbl(ii).display_value, '"', '\"'));
1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);
1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));
1310: end loop;
1311:
1304: for ii in 1..wf_lov.g_value_tbl.count loop
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);
1306: -- ### does not work for double quotes
1307: -- ### replace(wf_lov.g_value_tbl(ii).display_value, '"', '\"'));
1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);
1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));
1310: end loop;
1311:
1312: htp.formClose;
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);
1306: -- ### does not work for double quotes
1307: -- ### replace(wf_lov.g_value_tbl(ii).display_value, '"', '\"'));
1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);
1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));
1310: end loop;
1311:
1312: htp.formClose;
1313:
1317:
1318: exception
1319: when others then
1320: rollback;
1321: wf_core.context('Wf_Lov', 'Display_Lov_Details' );
1322: raise;
1323: end display_lov_details;
1324:
1325: /*
1536: htp.tableRowClose;
1537:
1538: htp.formClose;
1539: htp.formOpen(curl=>owa_util.get_owa_service_path||
1540: 'wf_lov.display_lov_no_frame',
1541: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
1542:
1543: htp.formhidden('p_lov_name', p_lov_name);
1544: htp.formhidden('p_display_name', p_display_name);
1560: htp.p('');
1561:
1562: end if;
1563:
1564: wf_lov.g_define_rec.total_rows := 0;
1565: wf_lov.g_define_rec.add_attr1_title := null;
1566: wf_lov.g_define_rec.add_attr2_title := null;
1567: wf_lov.g_define_rec.add_attr3_title := null;
1568: wf_lov.g_define_rec.add_attr4_title := null;
1561:
1562: end if;
1563:
1564: wf_lov.g_define_rec.total_rows := 0;
1565: wf_lov.g_define_rec.add_attr1_title := null;
1566: wf_lov.g_define_rec.add_attr2_title := null;
1567: wf_lov.g_define_rec.add_attr3_title := null;
1568: wf_lov.g_define_rec.add_attr4_title := null;
1569: wf_lov.g_define_rec.add_attr5_title := null;
1562: end if;
1563:
1564: wf_lov.g_define_rec.total_rows := 0;
1565: wf_lov.g_define_rec.add_attr1_title := null;
1566: wf_lov.g_define_rec.add_attr2_title := null;
1567: wf_lov.g_define_rec.add_attr3_title := null;
1568: wf_lov.g_define_rec.add_attr4_title := null;
1569: wf_lov.g_define_rec.add_attr5_title := null;
1570: wf_lov.g_value_tbl.delete;
1563:
1564: wf_lov.g_define_rec.total_rows := 0;
1565: wf_lov.g_define_rec.add_attr1_title := null;
1566: wf_lov.g_define_rec.add_attr2_title := null;
1567: wf_lov.g_define_rec.add_attr3_title := null;
1568: wf_lov.g_define_rec.add_attr4_title := null;
1569: wf_lov.g_define_rec.add_attr5_title := null;
1570: wf_lov.g_value_tbl.delete;
1571:
1564: wf_lov.g_define_rec.total_rows := 0;
1565: wf_lov.g_define_rec.add_attr1_title := null;
1566: wf_lov.g_define_rec.add_attr2_title := null;
1567: wf_lov.g_define_rec.add_attr3_title := null;
1568: wf_lov.g_define_rec.add_attr4_title := null;
1569: wf_lov.g_define_rec.add_attr5_title := null;
1570: wf_lov.g_value_tbl.delete;
1571:
1572: if (p_autoquery <> 'Y') THEN
1565: wf_lov.g_define_rec.add_attr1_title := null;
1566: wf_lov.g_define_rec.add_attr2_title := null;
1567: wf_lov.g_define_rec.add_attr3_title := null;
1568: wf_lov.g_define_rec.add_attr4_title := null;
1569: wf_lov.g_define_rec.add_attr5_title := null;
1570: wf_lov.g_value_tbl.delete;
1571:
1572: if (p_autoquery <> 'Y') THEN
1573:
1566: wf_lov.g_define_rec.add_attr2_title := null;
1567: wf_lov.g_define_rec.add_attr3_title := null;
1568: wf_lov.g_define_rec.add_attr4_title := null;
1569: wf_lov.g_define_rec.add_attr5_title := null;
1570: wf_lov.g_value_tbl.delete;
1571:
1572: if (p_autoquery <> 'Y') THEN
1573:
1574: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('WFITD_INTERNAL_NAME');
1570: wf_lov.g_value_tbl.delete;
1571:
1572: if (p_autoquery <> 'Y') THEN
1573:
1574: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('WFITD_INTERNAL_NAME');
1575:
1576: -- these 4 criteria variables were extracted from the sql in cursor
1577: -- c_user_lov. Without doing this, the optimizer did not know to
1578: -- use indexes in the base tables.
1599: end if;
1600:
1601: for ii in to_number(p_start_row)..l_end_row loop
1602: nn := nn + 1;
1603: wf_lov.g_value_tbl(nn).hidden_key := names(ii);
1604: wf_lov.g_value_tbl(nn).display_value := dnames(ii);
1605: wf_lov.g_value_tbl(nn).add_attr1_value := names(ii);
1606: end loop;
1607: end if;
1600:
1601: for ii in to_number(p_start_row)..l_end_row loop
1602: nn := nn + 1;
1603: wf_lov.g_value_tbl(nn).hidden_key := names(ii);
1604: wf_lov.g_value_tbl(nn).display_value := dnames(ii);
1605: wf_lov.g_value_tbl(nn).add_attr1_value := names(ii);
1606: end loop;
1607: end if;
1608:
1601: for ii in to_number(p_start_row)..l_end_row loop
1602: nn := nn + 1;
1603: wf_lov.g_value_tbl(nn).hidden_key := names(ii);
1604: wf_lov.g_value_tbl(nn).display_value := dnames(ii);
1605: wf_lov.g_value_tbl(nn).add_attr1_value := names(ii);
1606: end loop;
1607: end if;
1608:
1609: wf_lov.g_define_rec.total_rows := l_total_rows;
1605: wf_lov.g_value_tbl(nn).add_attr1_value := names(ii);
1606: end loop;
1607: end if;
1608:
1609: wf_lov.g_define_rec.total_rows := l_total_rows;
1610:
1611: l_result := 1;
1612:
1613: else
1627: htp.p('
1632: wf_core.clear;
1633: wf_core.token('NAME', p_display_name);
1634: wf_core.token('VALUE', p_current_value);
1635: htp.p('
1651: end if;
1652: l_from := to_char(l_temp_start_row);
1653:
1654: if (l_temp_start_row =0) then
1655: l_to := TO_CHAR(l_temp_start_row + wf_lov.g_value_tbl.count);
1656:
1657: else
1658: l_to := TO_CHAR(l_temp_start_row + wf_lov.g_value_tbl.count -1);
1659: end if;
1654: if (l_temp_start_row =0) then
1655: l_to := TO_CHAR(l_temp_start_row + wf_lov.g_value_tbl.count);
1656:
1657: else
1658: l_to := TO_CHAR(l_temp_start_row + wf_lov.g_value_tbl.count -1);
1659: end if;
1660:
1661:
1662: htp.p('
1692: END IF;
1693: Wf_Core.Clear;
1694: Wf_Core.Token('START_REC', l_from);
1695: Wf_Core.Token('END_REC', l_to);
1696: Wf_Core.Token('TOTAL_REC', TO_CHAR(wf_lov.g_define_rec.total_rows));
1697: htp.p(''||Wf_Core.Translate('PAGE_MSG')||'');
1698:
1699: /*
1700: ** Check to see if you should create the Next button
1698:
1699: /*
1700: ** Check to see if you should create the Next button
1701: */
1702: IF (p_start_row + p_max_rows - 1 < wf_lov.g_define_rec.total_rows) THEN
1703: -- IF (wf_lov.g_value_tbl.count = p_max_rows) THEN
1704:
1705: l_start_row := TO_NUMBER(p_start_row) + p_max_rows;
1706:
1699: /*
1700: ** Check to see if you should create the Next button
1701: */
1702: IF (p_start_row + p_max_rows - 1 < wf_lov.g_define_rec.total_rows) THEN
1703: -- IF (wf_lov.g_value_tbl.count = p_max_rows) THEN
1704:
1705: l_start_row := TO_NUMBER(p_start_row) + p_max_rows;
1706:
1707: htp.p(''|| p_display_name ||
1744: '
1744: '
1751: l_ncols := l_ncols + 1;
1752:
1753: end if;
1754:
1755: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1756:
1757: htp.p('
1753: end if;
1754:
1755: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1756:
1757: htp.p('
1760: l_ncols := l_ncols + 1;
1761:
1762: end if;
1763:
1764: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1765:
1766: htp.p('
1762: end if;
1763:
1764: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1765:
1766: htp.p('
1769: l_ncols := l_ncols + 1;
1770:
1771: end if;
1772:
1773: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1774:
1775: htp.p('
1771: end if;
1772:
1773: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1774:
1775: htp.p('
1778: l_ncols := l_ncols + 1;
1779:
1780: end if;
1781:
1782: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1783:
1784: htp.p('
1780: end if;
1781:
1782: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1783:
1784: htp.p('
1790: htp.tablerowclose;
1791: /*
1792: ** Loop through the data
1793: */
1794: for ii in 1..wf_lov.g_value_tbl.count loop
1795:
1796: -- display one row of data
1797:
1798: htp.p('
1801: '''','\047')||''''||
1802: ';'||p_dest_hidden_field||'='||''''||
1803: replace(wf_lov.g_value_tbl(ii).hidden_key,
1804: '''','\047')||''''||
1805: ';parent.self.close();">'||wf_core.translate('SELECT')||'
1804: '''','\047')||''''||
1805: ';parent.self.close();">'||wf_core.translate('SELECT')||'
1808: htp.p('
1812: htp.p('
1817:
1818: end if;
1819:
1820: if (l_ncols > 3) then
1821: htp.p('
1821: htp.p('
1834:
1835: htp.p('');
1836: htp.p('');
1837:
1838: if (wf_lov.g_value_tbl.count > 5) then
1839: htp.tableRowOpen;
1840: htp.p('
1874:
1875: Wf_Core.Clear;
1876: Wf_Core.Token('START_REC', l_from);
1877: Wf_Core.Token('END_REC', l_to);
1878: Wf_Core.Token('TOTAL_REC', TO_CHAR(wf_lov.g_define_rec.total_rows));
1879: htp.p(''||Wf_Core.Translate('PAGE_MSG')||'');
1880:
1881: /*
1882: ** Check to see if you should create the Next button
1880:
1881: /*
1882: ** Check to see if you should create the Next button
1883: */
1884: IF (wf_lov.g_value_tbl.count = p_max_rows) THEN
1885:
1886:
1887: l_start_row := TO_NUMBER(p_start_row) + p_max_rows;
1888:
1902:
1903: htp.p('