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.BIS_LOV_PVT dependencies on HTP

Line 26: htp.p('

22:
23: Procedure null_alert
24: is
25: begin
26: htp.p('
27: function null_alert(value, alert_text) {
28: if (value == "") {
29: alert(alert_text);
30: return true;

Line 51: htp.p('

47: )
48: IS
49: begin
50:
51: htp.p('
52: function '||p_lov_func_name||'{
53: if (!null_alert('||p_null_variable||','||p_null_alert_text||')){
54: var l_where_clause;
55:

Line 186: htp.p('In get list no label'||l_br);

182: l_prompts icx_util.g_prompts_table;
183: BEGIN
184:
185: /*
186: htp.p('In get list no label'||l_br);
187: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
188: htp.p('p_attribute_name :'||p_attribute_name||l_br);
189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);

Line 187: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);

183: BEGIN
184:
185: /*
186: htp.p('In get list no label'||l_br);
187: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
188: htp.p('p_attribute_name :'||p_attribute_name||l_br);
189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);

Line 188: htp.p('p_attribute_name :'||p_attribute_name||l_br);

184:
185: /*
186: htp.p('In get list no label'||l_br);
187: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
188: htp.p('p_attribute_name :'||p_attribute_name||l_br);
189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);
192: htp.p('p_form_name :'||p_form_name||l_br);

Line 189: htp.p('p_attribute_code :'||p_attribute_code||l_br);

185: /*
186: htp.p('In get list no label'||l_br);
187: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
188: htp.p('p_attribute_name :'||p_attribute_name||l_br);
189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);
192: htp.p('p_form_name :'||p_form_name||l_br);
193: htp.p('p_frame_name :'||p_frame_name||l_br);

Line 190: htp.p('p_region_app_id :'||p_region_app_id||l_br);

186: htp.p('In get list no label'||l_br);
187: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
188: htp.p('p_attribute_name :'||p_attribute_name||l_br);
189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);
192: htp.p('p_form_name :'||p_form_name||l_br);
193: htp.p('p_frame_name :'||p_frame_name||l_br);
194: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);

Line 191: htp.p('p_region_code :'||p_region_code||l_br);

187: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
188: htp.p('p_attribute_name :'||p_attribute_name||l_br);
189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);
192: htp.p('p_form_name :'||p_form_name||l_br);
193: htp.p('p_frame_name :'||p_frame_name||l_br);
194: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
195: */

Line 192: htp.p('p_form_name :'||p_form_name||l_br);

188: htp.p('p_attribute_name :'||p_attribute_name||l_br);
189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);
192: htp.p('p_form_name :'||p_form_name||l_br);
193: htp.p('p_frame_name :'||p_frame_name||l_br);
194: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
195: */
196:

Line 193: htp.p('p_frame_name :'||p_frame_name||l_br);

189: htp.p('p_attribute_code :'||p_attribute_code||l_br);
190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);
192: htp.p('p_form_name :'||p_form_name||l_br);
193: htp.p('p_frame_name :'||p_frame_name||l_br);
194: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
195: */
196:
197: l_list_str := htf.tableOpen;--(cattributes=> 'BORDER="0"');

Line 194: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);

190: htp.p('p_region_app_id :'||p_region_app_id||l_br);
191: htp.p('p_region_code :'||p_region_code||l_br);
192: htp.p('p_form_name :'||p_form_name||l_br);
193: htp.p('p_frame_name :'||p_frame_name||l_br);
194: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
195: */
196:
197: l_list_str := htf.tableOpen;--(cattributes=> 'BORDER="0"');
198: x_list_str(x_list_str.count + 1) := l_list_str;

Line 292: htp.p('Get_List Exception: '||SQLERRM);

288: x_list_str(x_list_str.count + 1) := l_list_str;
289:
290: EXCEPTION
291: WHEN OTHERS THEN
292: htp.p('Get_List Exception: '||SQLERRM);
293:
294: END Get_List;
295:
296: procedure Get_List

Line 318: htp.p('In get list with label'||l_br);

314:
315: BEGIN
316:
317: /*
318: htp.p('In get list with label'||l_br);
319: htp.p('p_label :'||p_label||l_br);
320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);

Line 319: htp.p('p_label :'||p_label||l_br);

315: BEGIN
316:
317: /*
318: htp.p('In get list with label'||l_br);
319: htp.p('p_label :'||p_label||l_br);
320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);

Line 320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);

316:
317: /*
318: htp.p('In get list with label'||l_br);
319: htp.p('p_label :'||p_label||l_br);
320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);

Line 321: htp.p('p_attribute_name :'||p_attribute_name||l_br);

317: /*
318: htp.p('In get list with label'||l_br);
319: htp.p('p_label :'||p_label||l_br);
320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);
325: htp.p('p_form_name :'||p_form_name||l_br);

Line 322: htp.p('p_attribute_code :'||p_attribute_code||l_br);

318: htp.p('In get list with label'||l_br);
319: htp.p('p_label :'||p_label||l_br);
320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);
325: htp.p('p_form_name :'||p_form_name||l_br);
326: htp.p('p_frame_name :'||p_frame_name||l_br);

Line 323: htp.p('p_region_app_id :'||p_region_app_id||l_br);

319: htp.p('p_label :'||p_label||l_br);
320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);
325: htp.p('p_form_name :'||p_form_name||l_br);
326: htp.p('p_frame_name :'||p_frame_name||l_br);
327: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);

Line 324: htp.p('p_region_code :'||p_region_code||l_br);

320: htp.p('p_attribute_app_id :'||p_attribute_app_id||l_br);
321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);
325: htp.p('p_form_name :'||p_form_name||l_br);
326: htp.p('p_frame_name :'||p_frame_name||l_br);
327: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
328: */

Line 325: htp.p('p_form_name :'||p_form_name||l_br);

321: htp.p('p_attribute_name :'||p_attribute_name||l_br);
322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);
325: htp.p('p_form_name :'||p_form_name||l_br);
326: htp.p('p_frame_name :'||p_frame_name||l_br);
327: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
328: */
329:

Line 326: htp.p('p_frame_name :'||p_frame_name||l_br);

322: htp.p('p_attribute_code :'||p_attribute_code||l_br);
323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);
325: htp.p('p_form_name :'||p_form_name||l_br);
326: htp.p('p_frame_name :'||p_frame_name||l_br);
327: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
328: */
329:
330: l_list_str := htf.tableOpen;--( cattributes => 'BORDER="0"');

Line 327: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);

323: htp.p('p_region_app_id :'||p_region_app_id||l_br);
324: htp.p('p_region_code :'||p_region_code||l_br);
325: htp.p('p_form_name :'||p_form_name||l_br);
326: htp.p('p_frame_name :'||p_frame_name||l_br);
327: htp.p('p_where_clause :'||p_where_clause||l_br||l_br);
328: */
329:
330: l_list_str := htf.tableOpen;--( cattributes => 'BORDER="0"');
331: x_list_str(x_list_str.count + 1) := l_list_str;

Line 377: htp.p('Get_List Exception: '||SQLERRM);

373: x_list_str(x_list_str.count + 1) := l_list_str;
374:
375: EXCEPTION
376: WHEN OTHERS THEN
377: htp.p('Get_List Exception: '||SQLERRM);
378:
379: END Get_List;
380:
381: procedure Get_List

Line 415: htp.p('In get list 2 with label'||l_br);

411:
412: BEGIN
413:
414: /*
415: htp.p('In get list 2 with label'||l_br);
416: htp.p('p_label :'||p_label||l_br);
417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);
418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);

Line 416: htp.p('p_label :'||p_label||l_br);

412: BEGIN
413:
414: /*
415: htp.p('In get list 2 with label'||l_br);
416: htp.p('p_label :'||p_label||l_br);
417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);
418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);

Line 417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);

413:
414: /*
415: htp.p('In get list 2 with label'||l_br);
416: htp.p('p_label :'||p_label||l_br);
417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);
418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);

Line 418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);

414: /*
415: htp.p('In get list 2 with label'||l_br);
416: htp.p('p_label :'||p_label||l_br);
417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);
418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);

Line 419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);

415: htp.p('In get list 2 with label'||l_br);
416: htp.p('p_label :'||p_label||l_br);
417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);
418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);

Line 420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);

416: htp.p('p_label :'||p_label||l_br);
417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);
418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);

Line 421: htp.p('p_region1_code :'||p_region_code||l_br);

417: htp.p('p_attribute1_app_id :'||p_attribute_app_id||l_br);
418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);

Line 422: htp.p('p_form1_name :'||p_form_name||l_br);

418: htp.p('p_attribute1_name :'||p_attribute_name||l_br);
419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);

Line 423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);

419: htp.p('p_attribute1_code :'||p_attribute_code||l_br);
420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);

Line 424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);

420: htp.p('p_region1_app_id :'||p_region_app_id||l_br);
421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);
428: htp.p('p_region2_code :'||p_region_code||l_br);

Line 425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);

421: htp.p('p_region1_code :'||p_region_code||l_br);
422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);
428: htp.p('p_region2_code :'||p_region_code||l_br);
429: htp.p('p_form2_name :'||p_form_name||l_br);

Line 426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);

422: htp.p('p_form1_name :'||p_form_name||l_br);
423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);
428: htp.p('p_region2_code :'||p_region_code||l_br);
429: htp.p('p_form2_name :'||p_form_name||l_br);
430: htp.p('p_where_clause2 :'||p_where_clause||l_br||l_br);

Line 427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);

423: htp.p('p_where_clause1 :'||p_where_clause||l_br||l_br);
424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);
428: htp.p('p_region2_code :'||p_region_code||l_br);
429: htp.p('p_form2_name :'||p_form_name||l_br);
430: htp.p('p_where_clause2 :'||p_where_clause||l_br||l_br);
431: */

Line 428: htp.p('p_region2_code :'||p_region_code||l_br);

424: htp.p('p_attribute2_app_id :'||p_attribute_app_id||l_br);
425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);
428: htp.p('p_region2_code :'||p_region_code||l_br);
429: htp.p('p_form2_name :'||p_form_name||l_br);
430: htp.p('p_where_clause2 :'||p_where_clause||l_br||l_br);
431: */
432:

Line 429: htp.p('p_form2_name :'||p_form_name||l_br);

425: htp.p('p_attribute2_name :'||p_attribute_name||l_br);
426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);
428: htp.p('p_region2_code :'||p_region_code||l_br);
429: htp.p('p_form2_name :'||p_form_name||l_br);
430: htp.p('p_where_clause2 :'||p_where_clause||l_br||l_br);
431: */
432:
433: l_list_str := htf.tableOpen;

Line 430: htp.p('p_where_clause2 :'||p_where_clause||l_br||l_br);

426: htp.p('p_attribute2_code :'||p_attribute_code||l_br);
427: htp.p('p_region2_app_id :'||p_region_app_id||l_br);
428: htp.p('p_region2_code :'||p_region_code||l_br);
429: htp.p('p_form2_name :'||p_form_name||l_br);
430: htp.p('p_where_clause2 :'||p_where_clause||l_br||l_br);
431: */
432:
433: l_list_str := htf.tableOpen;
434: -- ( calign => 'CENTER'

Line 525: htp.p('Get_List Exception: '||SQLERRM);

521: x_list_str(x_list_str.count + 1) := l_list_str;
522:
523: EXCEPTION
524: WHEN OTHERS THEN
525: htp.p('Get_List Exception: '||SQLERRM);
526:
527: END Get_List;
528:
529: --