eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_LOV dependencies on WF_LOV

Line 1: package body WF_LOV as

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)

Line 149: Wf_Core.Context('wf_lov', 'OpenLovWinHtml');

145: END IF;
146:
147: exception
148: when others then
149: Wf_Core.Context('wf_lov', 'OpenLovWinHtml');
150: raise;
151:
152: end OpenLovWinHtml;
153:

Line 181: 'wf_lov.lovapplet'||

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

Line 205: wf_core.context('Wf_Lov', 'GenerateLovURL',

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 ,

Line 212: wf_lov.Error;

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,

Line 246: wf_core.context('Wf_Lov', 'create_reg_button',when_pressed_url,onmouseover,

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;

Line 248: wf_lov.Error;

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,

Line 460: document.write("");

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:

Line 593: 'wf_lov.display_lov_find?p_lov_name='||

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

Line 614: 'wf_lov.display_lov_details?p_lov_name='||

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

Line 648: wf_core.context('Wf_Lov', 'display_lov');

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:

Line 649: wf_lov.error;

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:

Line 784: wf_core.context('Wf_Lov', 'display_lov_find');

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:

Line 785: wf_lov.error;

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:

Line 912: p_dest_display_field||'=document.WF_LOV_FRM.h_display[num].value;

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

Line 914: p_dest_hidden_field||'=document.WF_LOV_FRM.h_hidden[num].value;

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

Line 927: 'wf_lov.display_lov_details',

923:
924: htp.p('');
925:
926: htp.formOpen(curl=>owa_util.get_owa_service_path||
927: 'wf_lov.display_lov_details',
928: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
929:
930: htp.formhidden('p_lov_name', p_lov_name);
931: htp.formhidden('p_display_name', p_display_name);

Line 957: wf_lov.g_define_rec.total_rows := 0;

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;

Line 958: wf_lov.g_define_rec.add_attr1_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;

Line 959: wf_lov.g_define_rec.add_attr2_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;

Line 960: wf_lov.g_define_rec.add_attr3_title := null;

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:

Line 961: wf_lov.g_define_rec.add_attr4_title := null;

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

Line 962: wf_lov.g_define_rec.add_attr5_title := null;

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>

Line 963: wf_lov.g_value_tbl.delete;

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.

Line 1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));

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

Line 1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');

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:

Line 1093: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then

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(''||
1097: ''|| wf_lov.g_define_rec.add_attr1_title ||

Line 1096: wf_lov.g_define_rec.add_attr1_title || '">'||

1092: end if;
1093: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1094:
1095: htp.p(''||
1097: ''|| wf_lov.g_define_rec.add_attr1_title ||
1098: '');
1099:
1100: l_ncols := l_ncols + 1;

Line 1097: ''|| wf_lov.g_define_rec.add_attr1_title ||

1093: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1094:
1095: htp.p(''||
1097: ''|| wf_lov.g_define_rec.add_attr1_title ||
1098: '');
1099:
1100: l_ncols := l_ncols + 1;
1101:

Line 1104: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then

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(''||
1108: ''|| wf_lov.g_define_rec.add_attr2_title ||

Line 1107: wf_lov.g_define_rec.add_attr2_title || '">'||

1103:
1104: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1105:
1106: htp.p(''||
1108: ''|| wf_lov.g_define_rec.add_attr2_title ||
1109: '');
1110:
1111: l_ncols := l_ncols + 1;

Line 1108: ''|| wf_lov.g_define_rec.add_attr2_title ||

1104: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1105:
1106: htp.p(''||
1108: ''|| wf_lov.g_define_rec.add_attr2_title ||
1109: '');
1110:
1111: l_ncols := l_ncols + 1;
1112:

Line 1115: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then

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(''||
1119: ''|| wf_lov.g_define_rec.add_attr3_title ||

Line 1118: wf_lov.g_define_rec.add_attr3_title || '">'||

1114:
1115: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1116:
1117: htp.p(''||
1119: ''|| wf_lov.g_define_rec.add_attr3_title ||
1120: '');
1121:
1122: l_ncols := l_ncols + 1;

Line 1119: ''|| wf_lov.g_define_rec.add_attr3_title ||

1115: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1116:
1117: htp.p(''||
1119: ''|| wf_lov.g_define_rec.add_attr3_title ||
1120: '');
1121:
1122: l_ncols := l_ncols + 1;
1123:

Line 1126: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then

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(''||
1130: ''|| wf_lov.g_define_rec.add_attr4_title ||

Line 1129: wf_lov.g_define_rec.add_attr4_title || '">'||

1125:
1126: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1127:
1128: htp.p(''||
1130: ''|| wf_lov.g_define_rec.add_attr4_title ||
1131: '');
1132:
1133: l_ncols := l_ncols + 1;

Line 1130: ''|| wf_lov.g_define_rec.add_attr4_title ||

1126: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1127:
1128: htp.p(''||
1130: ''|| wf_lov.g_define_rec.add_attr4_title ||
1131: '');
1132:
1133: l_ncols := l_ncols + 1;
1134:

Line 1137: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then

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(''||
1141: ''|| wf_lov.g_define_rec.add_attr5_title ||

Line 1140: wf_lov.g_define_rec.add_attr5_title || '">'||

1136:
1137: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1138:
1139: htp.p(''||
1141: ''|| wf_lov.g_define_rec.add_attr5_title ||
1142: '');
1143:
1144: l_ncols := l_ncols + 1;

Line 1141: ''|| wf_lov.g_define_rec.add_attr5_title ||

1137: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1138:
1139: htp.p(''||
1141: ''|| wf_lov.g_define_rec.add_attr5_title ||
1142: '');
1143:
1144: l_ncols := l_ncols + 1;
1145:

Line 1152: for ii in 1..wf_lov.g_value_tbl.count loop

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

Line 1163: wf_lov.g_value_tbl(ii).display_value||'',

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||'',

Line 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

Line 1173: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr1_value,

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:

Line 1175: wf_lov.g_define_rec.add_attr1_title ||

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

Line 1181: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr2_value,

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:

Line 1183: wf_lov.g_define_rec.add_attr2_title ||

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

Line 1189: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr3_value,

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:

Line 1191: wf_lov.g_define_rec.add_attr3_title ||

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;

Line 1198: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr4_value,

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:

Line 1200: wf_lov.g_define_rec.add_attr4_title ||

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;

Line 1207: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr5_value,

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:

Line 1209: wf_lov.g_define_rec.add_attr5_title ||

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;

Line 1267: IF (wf_lov.g_value_tbl.count = 10) THEN

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:

Line 1270: if (l_start_row <= wf_lov.g_define_rec.total_rows) then

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('');
1273:
1274: htp.p(' 1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);

Line 1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);

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

Line 1307: -- ### replace(wf_lov.g_value_tbl(ii).display_value, '"', '\"'));

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:

Line 1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);

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;

Line 1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));

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:

Line 1321: wf_core.context('Wf_Lov', 'Display_Lov_Details' );

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: /*

Line 1540: 'wf_lov.display_lov_no_frame',

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

Line 1564: wf_lov.g_define_rec.total_rows := 0;

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;

Line 1565: wf_lov.g_define_rec.add_attr1_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;

Line 1566: wf_lov.g_define_rec.add_attr2_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;

Line 1567: wf_lov.g_define_rec.add_attr3_title := null;

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:

Line 1568: wf_lov.g_define_rec.add_attr4_title := null;

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

Line 1569: wf_lov.g_define_rec.add_attr5_title := null;

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:

Line 1570: wf_lov.g_value_tbl.delete;

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

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

Line 1603: wf_lov.g_value_tbl(nn).hidden_key := names(ii);

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;

Line 1604: wf_lov.g_value_tbl(nn).display_value := dnames(ii);

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:

Line 1605: wf_lov.g_value_tbl(nn).add_attr1_value := names(ii);

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;

Line 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

Line 1631: elsif (wf_lov.g_define_rec.total_rows=0) then

1627: htp.p(' ');
1628: htp.p(' ');
1629: htp.p(' ');
1630: htp.p(' ');
1631: elsif (wf_lov.g_define_rec.total_rows=0) then
1632: wf_core.clear;
1633: wf_core.token('NAME', p_display_name);
1634: wf_core.token('VALUE', p_current_value);
1635: htp.p(''||wf_core.translate('WFLOV_NO_MATCH')||'');

Line 1636: elsif (wf_lov.g_define_rec.total_rows>0) then

1632: wf_core.clear;
1633: wf_core.token('NAME', p_display_name);
1634: wf_core.token('VALUE', p_current_value);
1635: htp.p(''||wf_core.translate('WFLOV_NO_MATCH')||'');
1636: elsif (wf_lov.g_define_rec.total_rows>0) then
1637:
1638: if (l_result > 0) then
1639:
1640: /*

Line 1655: l_to := TO_CHAR(l_temp_start_row + wf_lov.g_value_tbl.count);

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;

Line 1658: l_to := TO_CHAR(l_temp_start_row + wf_lov.g_value_tbl.count -1);

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

Line 1696: Wf_Core.Token('TOTAL_REC', TO_CHAR(wf_lov.g_define_rec.total_rows));

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

Line 1702: IF (p_start_row + p_max_rows - 1 < wf_lov.g_define_rec.total_rows) THEN

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:

Line 1703: -- IF (wf_lov.g_value_tbl.count = p_max_rows) THEN

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: '');
1745:
1746: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1747:
1748: htp.p(''|| wf_lov.g_define_rec.add_attr1_title||
1749: '');
1750:

Line 1748: htp.p(''|| wf_lov.g_define_rec.add_attr1_title||

1744: '');
1745:
1746: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1747:
1748: htp.p(''|| wf_lov.g_define_rec.add_attr1_title||
1749: '');
1750:
1751: l_ncols := l_ncols + 1;
1752:

Line 1755: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then

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(''|| wf_lov.g_define_rec.add_attr2_title||
1758: '');
1759:

Line 1757: htp.p(''|| wf_lov.g_define_rec.add_attr2_title||

1753: end if;
1754:
1755: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1756:
1757: htp.p(''|| wf_lov.g_define_rec.add_attr2_title||
1758: '');
1759:
1760: l_ncols := l_ncols + 1;
1761:

Line 1764: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then

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(''|| wf_lov.g_define_rec.add_attr3_title||
1767: '');
1768:

Line 1766: htp.p(''|| wf_lov.g_define_rec.add_attr3_title||

1762: end if;
1763:
1764: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1765:
1766: htp.p(''|| wf_lov.g_define_rec.add_attr3_title||
1767: '');
1768:
1769: l_ncols := l_ncols + 1;
1770:

Line 1773: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then

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(''|| wf_lov.g_define_rec.add_attr4_title||
1776: '');
1777:

Line 1775: htp.p(''|| wf_lov.g_define_rec.add_attr4_title||

1771: end if;
1772:
1773: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1774:
1775: htp.p(''|| wf_lov.g_define_rec.add_attr4_title||
1776: '');
1777:
1778: l_ncols := l_ncols + 1;
1779:

Line 1782: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then

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(''|| wf_lov.g_define_rec.add_attr5_title||
1785: '');
1786: l_ncols := l_ncols + 1;

Line 1784: htp.p(''|| wf_lov.g_define_rec.add_attr5_title||

1780: end if;
1781:
1782: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1783:
1784: htp.p(''|| wf_lov.g_define_rec.add_attr5_title||
1785: '');
1786: l_ncols := l_ncols + 1;
1787:
1788: end if;

Line 1794: for ii in 1..wf_lov.g_value_tbl.count loop

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(''||wf_core.translate('SELECT')||''||wf_lov.g_value_tbl(ii).display_value||'');
1806:
1807: if (l_ncols > 0) then

Line 1805: ';parent.self.close();">'||wf_core.translate('SELECT')||''||wf_lov.g_value_tbl(ii).display_value||'');

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')||''||wf_lov.g_value_tbl(ii).display_value||'');
1806:
1807: if (l_ncols > 0) then
1808: htp.p(''||wf_lov.g_value_tbl(ii).add_attr1_value||'');
1809:

Line 1808: htp.p(''||wf_lov.g_value_tbl(ii).add_attr1_value||'');

1804: '''','\047')||''''||
1805: ';parent.self.close();">'||wf_core.translate('SELECT')||''||wf_lov.g_value_tbl(ii).display_value||'');
1806:
1807: if (l_ncols > 0) then
1808: htp.p(''||wf_lov.g_value_tbl(ii).add_attr1_value||'');
1809:
1810: end if;
1811: if (l_ncols > 1) then
1812: htp.p(''||wf_lov.g_value_tbl(ii).add_attr2_value||'');

Line 1812: htp.p(''||wf_lov.g_value_tbl(ii).add_attr2_value||'');

1808: htp.p(''||wf_lov.g_value_tbl(ii).add_attr1_value||'');
1809:
1810: end if;
1811: if (l_ncols > 1) then
1812: htp.p(''||wf_lov.g_value_tbl(ii).add_attr2_value||'');
1813:
1814: end if;
1815: if (l_ncols > 2) then
1816: htp.p(''||wf_lov.g_value_tbl(ii).add_attr3_value||'');

Line 1816: htp.p(''||wf_lov.g_value_tbl(ii).add_attr3_value||'');

1812: htp.p(''||wf_lov.g_value_tbl(ii).add_attr2_value||'');
1813:
1814: end if;
1815: if (l_ncols > 2) then
1816: htp.p(''||wf_lov.g_value_tbl(ii).add_attr3_value||'');
1817:
1818: end if;
1819:
1820: if (l_ncols > 3) then

Line 1821: htp.p(''||wf_lov.g_value_tbl(ii).add_attr4_value||'');

1817:
1818: end if;
1819:
1820: if (l_ncols > 3) then
1821: htp.p(''||wf_lov.g_value_tbl(ii).add_attr4_value||'');
1822: end if;
1823:
1824: if (l_ncols > 4) then
1825: htp.p(''||wf_lov.g_value_tbl(ii).add_attr5_value||'');

Line 1825: htp.p(''||wf_lov.g_value_tbl(ii).add_attr5_value||'');

1821: htp.p(''||wf_lov.g_value_tbl(ii).add_attr4_value||'');
1822: end if;
1823:
1824: if (l_ncols > 4) then
1825: htp.p(''||wf_lov.g_value_tbl(ii).add_attr5_value||'');
1826:
1827: end if;
1828:
1829: htp.tablerowclose;

Line 1838: if (wf_lov.g_value_tbl.count > 5) then

1834:
1835: htp.p('');
1836: htp.p('');
1837:
1838: if (wf_lov.g_value_tbl.count > 5) then
1839: htp.tableRowOpen;
1840: htp.p('');
1841: htp.p('');
1842: /

Line 1878: Wf_Core.Token('TOTAL_REC', TO_CHAR(wf_lov.g_define_rec.total_rows));

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

Line 1884: IF (wf_lov.g_value_tbl.count = p_max_rows) THEN

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:

Line 1906: end if; -- if (wf_lov.g_define_rec.total_rows=0)

1902:
1903: htp.p('');
1904: htp.tableRowClose;
1905: end if;
1906: end if; -- if (wf_lov.g_define_rec.total_rows=0)
1907: -- htp.tableclose;
1908:
1909: -- blue separator
1910: -- htp.p('');
Line 1932: wf_core.context('Wf_Lov', 'display_lov_no_frame');

1928:
1929: exception
1930: when others then
1931: rollback;
1932: wf_core.context('Wf_Lov', 'display_lov_no_frame');
1933: wf_lov.error;
1934:
1935: end display_lov_no_frame;
1936:

Line 1933: wf_lov.error;

1929: exception
1930: when others then
1931: rollback;
1932: wf_core.context('Wf_Lov', 'display_lov_no_frame');
1933: wf_lov.error;
1934:
1935: end display_lov_no_frame;
1936:
1937: /

Line 1996: wf_core.context('Wf_Lov', 'display_lov_no_frame_key');

1992:
1993: exception
1994: when others then
1995: rollback;
1996: wf_core.context('Wf_Lov', 'display_lov_no_frame_key');
1997: wf_lov.error;
1998:
1999: end display_lov_no_frame_key;
2000:

Line 1997: wf_lov.error;

1993: exception
1994: when others then
1995: rollback;
1996: wf_core.context('Wf_Lov', 'display_lov_no_frame_key');
1997: wf_lov.error;
1998:
1999: end display_lov_no_frame_key;
2000:
2001:

Line 2002: end WF_LOV;

1998:
1999: end display_lov_no_frame_key;
2000:
2001:
2002: end WF_LOV;