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

Line 67: htp.htmlOpen;

63: SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY')
64: INTO v_date_time
65: FROM DUAL;
66:
67: htp.htmlOpen;
68: htp.headOpen;
69: htp.title('Pipeline Buckets by Range');
70: htp.headClose;
71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

Line 68: htp.headOpen;

64: INTO v_date_time
65: FROM DUAL;
66:
67: htp.htmlOpen;
68: htp.headOpen;
69: htp.title('Pipeline Buckets by Range');
70: htp.headClose;
71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
72: htp.tableOpen('border="0" ');

Line 69: htp.title('Pipeline Buckets by Range');

65: FROM DUAL;
66:
67: htp.htmlOpen;
68: htp.headOpen;
69: htp.title('Pipeline Buckets by Range');
70: htp.headClose;
71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
72: htp.tableOpen('border="0" ');
73: htp.tableRowOpen(cAlign => 'TOP');

Line 70: htp.headClose;

66:
67: htp.htmlOpen;
68: htp.headOpen;
69: htp.title('Pipeline Buckets by Range');
70: htp.headClose;
71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
72: htp.tableOpen('border="0" ');
73: htp.tableRowOpen(cAlign => 'TOP');
74:

Line 71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

67: htp.htmlOpen;
68: htp.headOpen;
69: htp.title('Pipeline Buckets by Range');
70: htp.headClose;
71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
72: htp.tableOpen('border="0" ');
73: htp.tableRowOpen(cAlign => 'TOP');
74:
75: -- Begin Mod. Raam on 13/12/2000

Line 72: htp.tableOpen('border="0" ');

68: htp.headOpen;
69: htp.title('Pipeline Buckets by Range');
70: htp.headClose;
71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
72: htp.tableOpen('border="0" ');
73: htp.tableRowOpen(cAlign => 'TOP');
74:
75: -- Begin Mod. Raam on 13/12/2000
76: -- Images are not available at the media directory.

Line 73: htp.tableRowOpen(cAlign => 'TOP');

69: htp.title('Pipeline Buckets by Range');
70: htp.headClose;
71: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
72: htp.tableOpen('border="0" ');
73: htp.tableRowOpen(cAlign => 'TOP');
74:
75: -- Begin Mod. Raam on 13/12/2000
76: -- Images are not available at the media directory.
77: -- Once it is available the follwing code should be

Line 79: --htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));

75: -- Begin Mod. Raam on 13/12/2000
76: -- Images are not available at the media directory.
77: -- Once it is available the follwing code should be
78: -- uncommented.
79: --htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
80: -- End Mod.
81:
82: htp.tableData('' || 'Pipeline Buckets by Range Report', cNoWrap => 'TRUE');
83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');

Line 82: htp.tableData('' || 'Pipeline Buckets by Range Report', cNoWrap => 'TRUE');

78: -- uncommented.
79: --htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
80: -- End Mod.
81:
82: htp.tableData('' || 'Pipeline Buckets by Range Report', cNoWrap => 'TRUE');
83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
84: htp.tableRowClose;
85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');

Line 83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');

79: --htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
80: -- End Mod.
81:
82: htp.tableData('' || 'Pipeline Buckets by Range Report', cNoWrap => 'TRUE');
83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
84: htp.tableRowClose;
85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');

Line 84: htp.tableRowClose;

80: -- End Mod.
81:
82: htp.tableData('' || 'Pipeline Buckets by Range Report', cNoWrap => 'TRUE');
83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
84: htp.tableRowClose;
85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');

Line 85: htp.tableClose;

81:
82: htp.tableData('' || 'Pipeline Buckets by Range Report', cNoWrap => 'TRUE');
83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
84: htp.tableRowClose;
85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');

Line 86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');

82: htp.tableData('' || 'Pipeline Buckets by Range Report', cNoWrap => 'TRUE');
83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
84: htp.tableRowClose;
85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');

Line 87: htp.tableRowOpen(cVAlign => 'top');

83: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
84: htp.tableRowClose;
85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');
91: htp.br;

Line 88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');

84: htp.tableRowClose;
85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');
91: htp.br;
92: htp.tableRowClose;

Line 89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');

85: htp.tableClose;
86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');
91: htp.br;
92: htp.tableRowClose;
93: htp.tableClose;

Line 90: htp.tableData(' ', cColSpan => '6');

86: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');
91: htp.br;
92: htp.tableRowClose;
93: htp.tableClose;
94: htp.bodyClose;

Line 91: htp.br;

87: htp.tableRowOpen(cVAlign => 'top');
88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');
91: htp.br;
92: htp.tableRowClose;
93: htp.tableClose;
94: htp.bodyClose;
95: htp.headClose;

Line 92: htp.tableRowClose;

88: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');
91: htp.br;
92: htp.tableRowClose;
93: htp.tableClose;
94: htp.bodyClose;
95: htp.headClose;
96: htp.htmlClose;

Line 93: htp.tableClose;

89: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
90: htp.tableData(' ', cColSpan => '6');
91: htp.br;
92: htp.tableRowClose;
93: htp.tableClose;
94: htp.bodyClose;
95: htp.headClose;
96: htp.htmlClose;
97: END;

Line 94: htp.bodyClose;

90: htp.tableData(' ', cColSpan => '6');
91: htp.br;
92: htp.tableRowClose;
93: htp.tableClose;
94: htp.bodyClose;
95: htp.headClose;
96: htp.htmlClose;
97: END;
98: --------------------------------------------------------------------------------

Line 95: htp.headClose;

91: htp.br;
92: htp.tableRowClose;
93: htp.tableClose;
94: htp.bodyClose;
95: htp.headClose;
96: htp.htmlClose;
97: END;
98: --------------------------------------------------------------------------------
99: PROCEDURE pipeline_buckets_paramform IS

Line 96: htp.htmlClose;

92: htp.tableRowClose;
93: htp.tableClose;
94: htp.bodyClose;
95: htp.headClose;
96: htp.htmlClose;
97: END;
98: --------------------------------------------------------------------------------
99: PROCEDURE pipeline_buckets_paramform IS
100: day_counter NUMBER := 1;

Line 201: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cAttributes => ' NAME="param"');

197: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
198: -- Returns login user Id
199: -- set user's currency code
200: v_usr_currency_code := FND_PROFILE.Value('JTF_PROFILE_DEFAULT_CURRENCY');
201: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cAttributes => ' NAME="param"');
202: htp.htmlOpen;
203: htp.headOpen;
204: htp.title('Pipeline Buckets by Range Report');
205: htp.p('');

Line 264: htp.p(' if (p_valid){');

260: htp.p(' }');
261: htp.p(' if (low_prob > high_prob){');
262: htp.p(' alert(''Low probability must be less than High probability'');');
263: htp.p(' p_valid = false;}');
264: htp.p(' if (p_valid){');
265: htp.p(' objform.submit();}');
266: htp.p('}');
267: htp.p('');
268: htp.headClose;

Line 265: htp.p(' objform.submit();}');

261: htp.p(' if (low_prob > high_prob){');
262: htp.p(' alert(''Low probability must be less than High probability'');');
263: htp.p(' p_valid = false;}');
264: htp.p(' if (p_valid){');
265: htp.p(' objform.submit();}');
266: htp.p('}');
267: htp.p('');
268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

Line 266: htp.p('}');

262: htp.p(' alert(''Low probability must be less than High probability'');');
263: htp.p(' p_valid = false;}');
264: htp.p(' if (p_valid){');
265: htp.p(' objform.submit();}');
266: htp.p('}');
267: htp.p('');
268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;

Line 267: htp.p('');

263: htp.p(' p_valid = false;}');
264: htp.p(' if (p_valid){');
265: htp.p(' objform.submit();}');
266: htp.p('}');
267: htp.p('');
268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');

Line 268: htp.headClose;

264: htp.p(' if (p_valid){');
265: htp.p(' objform.submit();}');
266: htp.p('}');
267: htp.p('');
268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');

Line 269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

265: htp.p(' objform.submit();}');
266: htp.p('}');
267: htp.p('');
268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');

Line 270: htp.tableOpen;

266: htp.p('}');
267: htp.p('');
268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');

Line 271: htp.tableRowOpen(cVAlign => 'top');

267: htp.p('');
268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');
275: htp.tableRowClose;

Line 272: htp.tableData(' ', cAttributes => ' height=9');

268: htp.headClose;
269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');
275: htp.tableRowClose;
276: htp.tableClose;

Line 273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');

269: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');
275: htp.tableRowClose;
276: htp.tableClose;
277: htp.tableOpen(cAttributes => 'width="600" ');

Line 274: htp.tableData( ' ');

270: htp.tableOpen;
271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');
275: htp.tableRowClose;
276: htp.tableClose;
277: htp.tableOpen(cAttributes => 'width="600" ');
278: htp.tableRowOpen();

Line 275: htp.tableRowClose;

271: htp.tableRowOpen(cVAlign => 'top');
272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');
275: htp.tableRowClose;
276: htp.tableClose;
277: htp.tableOpen(cAttributes => 'width="600" ');
278: htp.tableRowOpen();
279: -- htp.p(L_USER_ID);

Line 276: htp.tableClose;

272: htp.tableData(' ', cAttributes => ' height=9');
273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');
275: htp.tableRowClose;
276: htp.tableClose;
277: htp.tableOpen(cAttributes => 'width="600" ');
278: htp.tableRowOpen();
279: -- htp.p(L_USER_ID);
280: htp.p('Select Output Format');

Line 277: htp.tableOpen(cAttributes => 'width="600" ');

273: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
274: htp.tableData( ' ');
275: htp.tableRowClose;
276: htp.tableClose;
277: htp.tableOpen(cAttributes => 'width="600" ');
278: htp.tableRowOpen();
279: -- htp.p(L_USER_ID);
280: htp.p('Select Output Format');
281: htp.p('');

Line 278: htp.tableRowOpen();

274: htp.tableData( ' ');
275: htp.tableRowClose;
276: htp.tableClose;
277: htp.tableOpen(cAttributes => 'width="600" ');
278: htp.tableRowOpen();
279: -- htp.p(L_USER_ID);
280: htp.p('Select Output Format');
281: htp.p('');
282: htp.p('');
283: htp.formSelectOption('Excel');

Line 280: htp.p('Select Output Format');

276: htp.tableClose;
277: htp.tableOpen(cAttributes => 'width="600" ');
278: htp.tableRowOpen();
279: -- htp.p(L_USER_ID);
280: htp.p('Select Output Format');
281: htp.p('');
282: htp.p('');
283: htp.formSelectOption('Excel');
284: htp.formSelectOption('HTML', cSelected => 'TRUE');
285: htp.formSelectClose;

Line 282: htp.p('');
283: htp.formSelectOption('Excel');
284: htp.formSelectOption('HTML', cSelected => 'TRUE');
285: htp.formSelectClose;
286: htp.tableRowClose;

Line 283: htp.formSelectOption('Excel');

279: -- htp.p(L_USER_ID);
280: htp.p('Select Output Format');
281: htp.p('');
282: htp.p('');
283: htp.formSelectOption('Excel');
284: htp.formSelectOption('HTML', cSelected => 'TRUE');
285: htp.formSelectClose;
286: htp.tableRowClose;
287: htp.tableRowClose;
288: htp.tableRowOpen();

Line 285: htp.formSelectClose;

281: htp.p('');
282: htp.p('');
283: htp.formSelectOption('Excel');
284: htp.formSelectOption('HTML', cSelected => 'TRUE');
285: htp.formSelectClose;
286: htp.tableRowClose;
287: htp.tableRowClose;
288: htp.tableRowOpen();
289: htp.p('Please Enter Start Date');
290: htp.p('');

Line 287: htp.tableRowClose;

283: htp.formSelectOption('Excel');
284: htp.formSelectOption('HTML', cSelected => 'TRUE');
285: htp.formSelectClose;
286: htp.tableRowClose;
287: htp.tableRowClose;
288: htp.tableRowOpen();
289: htp.p('Please Enter Start Date');
290: htp.p('');
291: htp.p('');
292: FOR i IN 1..day_data.count LOOP

Line 289: htp.p('Please Enter Start Date');

285: htp.formSelectClose;
286: htp.tableRowClose;
287: htp.tableRowClose;
288: htp.tableRowOpen();
289: htp.p('Please Enter Start Date');
290: htp.p('');
291: htp.p('');
292: FOR i IN 1..day_data.count LOOP
293: htp.formSelectOption(day_data(i),
294: cAttributes => ' value= ' || day_data(i),

Line 291: htp.p('');
292: FOR i IN 1..day_data.count LOOP
293: htp.formSelectOption(day_data(i),
294: cAttributes => ' value= ' || day_data(i),
295: cSelected => 'TRUE' );

Line 293: htp.formSelectOption(day_data(i),

289: htp.p('Please Enter Start Date');
290: htp.p('');
291: htp.p('');
300: FOR i IN 1..12 LOOP
301: IF i = 1 THEN

Line 298: htp.p('-');

294: cAttributes => ' value= ' || day_data(i),
295: cSelected => 'TRUE' );
296: END LOOP;
297: htp.formSelectClose;
298: htp.p('-');
299: htp.p('');

295: cSelected => 'TRUE' );
296: END LOOP;
297: htp.formSelectClose;
298: htp.p('-');
299: htp.p('');
300: FOR i IN 1..12 LOOP
301: IF i = 1 THEN
302: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
303: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'),
304: cSelected => 'TRUE');
305: ELSE
306: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

Line 306: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

302: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
303: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'),
304: cSelected => 'TRUE');
305: ELSE
306: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
307: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));
308: END IF;
309: END LOOP;
310: htp.formSelectClose;

Line 310: htp.formSelectClose;

306: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
307: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));
308: END IF;
309: END LOOP;
310: htp.formSelectClose;
311: htp.p('-');
312: htp.p('');
313: FOR i IN 1..year_data.count LOOP
314: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
315: htp.formSelectOption(year_data(i),

Line 312: htp.p('');
313: FOR i IN 1..year_data.count LOOP
314: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
315: htp.formSelectOption(year_data(i),
316: cAttributes => ' value= ' || year_data(i),

Line 315: htp.formSelectOption(year_data(i),

311: htp.p('-');
312: htp.p('');

Line 326: htp.tableRowOpen();

322: END LOOP;
323: htp.formSelectClose;
324: htp.p('');
325: htp.tableRowClose;
326: htp.tableRowOpen();
327: htp.p('Please Enter End Date');
328: htp.p('');
329: htp.p('');
330: FOR i IN 1..day_data.count LOOP
331: htp.formSelectOption(day_data(i),

Line 328: htp.p('');

324: htp.p('');
325: htp.tableRowClose;
326: htp.tableRowOpen();
327: htp.p('Please Enter End Date');
328: htp.p('');
329: htp.p('');

325: htp.tableRowClose;
326: htp.tableRowOpen();
327: htp.p('Please Enter End Date');
328: htp.p('');
329: htp.p('');
330: FOR i IN 1..day_data.count LOOP
331: htp.formSelectOption(day_data(i),
332: cAttributes => ' value= ' || day_data(i),
333: cSelected => 'TRUE' );
334: END LOOP;
335: htp.formSelectClose;

Line 335: htp.formSelectClose;

331: htp.formSelectOption(day_data(i),
332: cAttributes => ' value= ' || day_data(i),
333: cSelected => 'TRUE' );
334: END LOOP;
335: htp.formSelectClose;
336: htp.p('-');
337: htp.p('');
338: FOR i IN 1..12 LOOP
339: IF i=1 THEN
340: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

Line 337: htp.p('');
338: FOR i IN 1..12 LOOP
339: IF i=1 THEN
340: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
341: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'),

Line 340: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

336: htp.p('-');
337: htp.p('');
351: FOR i IN 1..year_data.count LOOP
352: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN

Line 349: htp.p('-');

345: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));
346: END IF;
347: END LOOP;
348: htp.formSelectClose;
349: htp.p('-');
350: htp.p ('');

346: END IF;
347: END LOOP;
348: htp.formSelectClose;
349: htp.p('-');
350: htp.p ('');
351: FOR i IN 1..year_data.count LOOP
352: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
353: htp.formSelectOption(year_data(i),
354: cAttributes => ' value= ' || year_data(i),
355: cSelected => 'TRUE' );
356: ELSE
357: htp.formSelectOption(year_data(i),

Line 357: htp.formSelectOption(year_data(i),

353: htp.formSelectOption(year_data(i),
354: cAttributes => ' value= ' || year_data(i),
355: cSelected => 'TRUE' );
356: ELSE
357: htp.formSelectOption(year_data(i),
358: cAttributes => ' value= ' || year_data(i));
359: END IF;
360: END LOOP;
361: htp.formSelectClose;

Line 361: htp.formSelectClose;

357: htp.formSelectOption(year_data(i),
358: cAttributes => ' value= ' || year_data(i));
359: END IF;
360: END LOOP;
361: htp.formSelectClose;
362: htp.p('');
363: htp.tableRowClose;
364: htp.tableRowOpen();
365: htp.p('Are these Close Dates or Creation Dates');

Line 362: htp.p('');

358: cAttributes => ' value= ' || year_data(i));
359: END IF;
360: END LOOP;
361: htp.formSelectClose;
362: htp.p('');
363: htp.tableRowClose;
364: htp.tableRowOpen();
365: htp.p('Are these Close Dates or Creation Dates');
366: htp.p('');

Line 363: htp.tableRowClose;

359: END IF;
360: END LOOP;
361: htp.formSelectClose;
362: htp.p('');
363: htp.tableRowClose;
364: htp.tableRowOpen();
365: htp.p('Are these Close Dates or Creation Dates');
366: htp.p('');
367: htp.p ('');
368: htp.formSelectOption('Creation Dates',

Line 365: htp.p('Are these Close Dates or Creation Dates');

361: htp.formSelectClose;
362: htp.p('');
363: htp.tableRowClose;
364: htp.tableRowOpen();
365: htp.p('Are these Close Dates or Creation Dates');
366: htp.p('');
367: htp.p ('');
368: htp.formSelectOption('Creation Dates',
369: cAttributes => ' value= ' || 'ENTRY');
370: htp.formSelectOption('Close Dates',

Line 367: htp.p ('');
368: htp.formSelectOption('Creation Dates',
369: cAttributes => ' value= ' || 'ENTRY');
370: htp.formSelectOption('Close Dates',
371: cAttributes => ' value= ' || 'CLOSE',

Line 368: htp.formSelectOption('Creation Dates',

364: htp.tableRowOpen();
365: htp.p('Are these Close Dates or Creation Dates');
366: htp.p('');
367: htp.p ('');
368: htp.formSelectOption('Creation Dates',
369: cAttributes => ' value= ' || 'ENTRY');
370: htp.formSelectOption('Close Dates',
371: cAttributes => ' value= ' || 'CLOSE',
372: cSelected => 'TRUE' );
373: htp.formSelectClose;
374: htp.p('');

Line 373: htp.formSelectClose;

369: cAttributes => ' value= ' || 'ENTRY');
370: htp.formSelectOption('Close Dates',
371: cAttributes => ' value= ' || 'CLOSE',
372: cSelected => 'TRUE' );
373: htp.formSelectClose;
374: htp.p('');
375: htp.tableRowClose;
376: htp.tableRowOpen();
377: htp.p('Sales Group');

Line 374: htp.p('');

370: htp.formSelectOption('Close Dates',
371: cAttributes => ' value= ' || 'CLOSE',
372: cSelected => 'TRUE' );
373: htp.formSelectClose;
374: htp.p('');
375: htp.tableRowClose;
376: htp.tableRowOpen();
377: htp.p('Sales Group');
378: htp.p('');

Line 375: htp.tableRowClose;

371: cAttributes => ' value= ' || 'CLOSE',
372: cSelected => 'TRUE' );
373: htp.formSelectClose;
374: htp.p('');
375: htp.tableRowClose;
376: htp.tableRowOpen();
377: htp.p('Sales Group');
378: htp.p('');
379: htp.p('');
380: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP

Line 377: htp.p('Sales Group');

373: htp.formSelectClose;
374: htp.p('');
375: htp.tableRowClose;
376: htp.tableRowOpen();
377: htp.p('Sales Group');
378: htp.p('');
379: htp.p('');
380: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
381: htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
382: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);

Line 379: htp.p('');
380: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
381: htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
382: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);
383: END LOOP;

Line 381: htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);

377: htp.p('Sales Group');
378: htp.p('');
379: htp.p('');
380: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
381: htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
382: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);
383: END LOOP;
384: htp.formSelectClose;
385: htp.p('');
386: htp.tableRowClose;

Line 384: htp.formSelectClose;

380: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
381: htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
382: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);
383: END LOOP;
384: htp.formSelectClose;
385: htp.p('');
386: htp.tableRowClose;
387: -- htp.tableRowOpen();
388: -- htp.p('Sales Rep');

Line 385: htp.p('');

381: htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
382: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);
383: END LOOP;
384: htp.formSelectClose;
385: htp.p('');
386: htp.tableRowClose;
387: -- htp.tableRowOpen();
388: -- htp.p('Sales Rep');
389: -- htp.p('');

Line 386: htp.tableRowClose;

382: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);
383: END LOOP;
384: htp.formSelectClose;
385: htp.p('');
386: htp.tableRowClose;
387: -- htp.tableRowOpen();
388: -- htp.p('Sales Rep');
389: -- htp.p('');
390: -- htp.p ('');
391: -- FOR rec_sales_rep IN cur_sales_rep LOOP

Line 388: -- htp.p('Sales Rep');

384: htp.formSelectClose;
385: htp.p('');
386: htp.tableRowClose;
387: -- htp.tableRowOpen();
388: -- htp.p('Sales Rep');
389: -- htp.p('');
390: -- htp.p ('');
391: -- FOR rec_sales_rep IN cur_sales_rep LOOP
392: -- IF rec_sales_rep.flname ='ALL' THEN
393: -- htp.formSelectOption(rec_sales_rep.flname, cAttributes => ' value= ' || rec_sales_rep.pid, cSelected => 'TRUE');

Line 390: -- htp.p ('');
391: -- FOR rec_sales_rep IN cur_sales_rep LOOP
392: -- IF rec_sales_rep.flname ='ALL' THEN
393: -- htp.formSelectOption(rec_sales_rep.flname, cAttributes => ' value= ' || rec_sales_rep.pid, cSelected => 'TRUE');
394: -- ELSE

Line 393: -- htp.formSelectOption(rec_sales_rep.flname, cAttributes => ' value= ' || rec_sales_rep.pid, cSelected => 'TRUE');

389: -- htp.p('');
390: -- htp.p ('');

Line 401: htp.tableRowOpen();

397: -- END LOOP;
398: -- htp.formSelectClose;
399: -- htp.p('');
400: -- htp.tableRowClose;
401: htp.tableRowOpen();
402: htp.p('Please Enter Low probability');
403: htp.p('');
404: htp.p('');
405: htp.formSelectOption(' ');
406: FOR cur_rec IN prob_cursor LOOP

Line 403: htp.p('');

399: -- htp.p('');
400: -- htp.tableRowClose;
401: htp.tableRowOpen();
402: htp.p('Please Enter Low probability');
403: htp.p('');
404: htp.p('');

400: -- htp.tableRowClose;
401: htp.tableRowOpen();
402: htp.p('Please Enter Low probability');
403: htp.p('');
404: htp.p('');
405: htp.formSelectOption(' ');
406: FOR cur_rec IN prob_cursor LOOP
407: htp.formSelectOption(cur_rec.win_probability, cAttributes => ' value= ' || cur_rec.win_probability);
408: END LOOP;
409: htp.formSelectClose;

Line 407: htp.formSelectOption(cur_rec.win_probability, cAttributes => ' value= ' || cur_rec.win_probability);

403: htp.p('');
404: htp.p('');

Line 412: htp.tableRowOpen();

408: END LOOP;
409: htp.formSelectClose;
410: htp.p('');
411: htp.tableRowClose;
412: htp.tableRowOpen();
413: htp.p('Please Enter High probability');
414: htp.p('');
415: htp.p('');
416: htp.formSelectOption(' ');
417: FOR cur_rec IN prob_cursor LOOP

Line 414: htp.p('');

410: htp.p('');
411: htp.tableRowClose;
412: htp.tableRowOpen();
413: htp.p('Please Enter High probability');
414: htp.p('');
415: htp.p('');

411: htp.tableRowClose;
412: htp.tableRowOpen();
413: htp.p('Please Enter High probability');
414: htp.p('');
415: htp.p('');
416: htp.formSelectOption(' ');
417: FOR cur_rec IN prob_cursor LOOP
418: htp.formSelectOption(cur_rec.win_probability, cAttributes => ' value= ' || cur_rec.win_probability);
419: END LOOP;
420: htp.formSelectClose;

Line 418: htp.formSelectOption(cur_rec.win_probability, cAttributes => ' value= ' || cur_rec.win_probability);

414: htp.p('');
415: htp.p('');

Line 423: htp.tableRowOpen();

419: END LOOP;
420: htp.formSelectClose;
421: htp.p('');
422: htp.tableRowClose;
423: htp.tableRowOpen();
424: htp.p('Internal Process Status');
425: htp.p('');
426: htp.p('');
427: htp.formSelectOption(' ');
428: FOR cur_rec IN intern_process_cursor LOOP

Line 425: htp.p('');

421: htp.p('');
422: htp.tableRowClose;
423: htp.tableRowOpen();
424: htp.p('Internal Process Status');
425: htp.p('');
426: htp.p('');

422: htp.tableRowClose;
423: htp.tableRowOpen();
424: htp.p('Internal Process Status');
425: htp.p('');
426: htp.p('');
427: htp.formSelectOption(' ');
428: FOR cur_rec IN intern_process_cursor LOOP
429: htp.formSelectOption(cur_rec.lookup_code, cAttributes => ' value= ' || cur_rec.lookup_code);
430: END LOOP;
431: htp.formSelectClose;

Line 429: htp.formSelectOption(cur_rec.lookup_code, cAttributes => ' value= ' || cur_rec.lookup_code);

425: htp.p('');
426: htp.p('');

Line 435: htp.br;

431: htp.formSelectClose;
432: htp.p('');
433: htp.tableRowClose;
434: htp.tableRowOpen();
435: htp.br;
436: htp.p('Reporting Currency');
437: htp.p('');
438: htp.p('');
439: FOR rec_currencies IN cur_currencies LOOP
440: IF rec_currencies.currency_code = v_usr_currency_code THEN

Line 437: htp.p('');

433: htp.tableRowClose;
434: htp.tableRowOpen();
435: htp.br;
436: htp.p('Reporting Currency');
437: htp.p('');
438: htp.p('');

434: htp.tableRowOpen();
435: htp.br;
436: htp.p('Reporting Currency');
437: htp.p('');
438: htp.p('');
439: FOR rec_currencies IN cur_currencies LOOP
440: IF rec_currencies.currency_code = v_usr_currency_code THEN
441: htp.formSelectOption(rec_currencies.currency_code, cSelected => 'TRUE');
442: ELSE
443: htp.formSelectOption(rec_currencies.currency_code);
444: END IF;
445: END LOOP;

Line 443: htp.formSelectOption(rec_currencies.currency_code);

439: FOR rec_currencies IN cur_currencies LOOP
440: IF rec_currencies.currency_code = v_usr_currency_code THEN
441: htp.formSelectOption(rec_currencies.currency_code, cSelected => 'TRUE');
442: ELSE
443: htp.formSelectOption(rec_currencies.currency_code);
444: END IF;
445: END LOOP;
446: htp.formSelectClose;
447: htp.p('');

Line 446: htp.formSelectClose;

442: ELSE
443: htp.formSelectOption(rec_currencies.currency_code);
444: END IF;
445: END LOOP;
446: htp.formSelectClose;
447: htp.p('');
448: htp.tableRowClose;
449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');

Line 447: htp.p('');

443: htp.formSelectOption(rec_currencies.currency_code);
444: END IF;
445: END LOOP;
446: htp.formSelectClose;
447: htp.p('');
448: htp.tableRowClose;
449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;

Line 448: htp.tableRowClose;

444: END IF;
445: END LOOP;
446: htp.formSelectClose;
447: htp.p('');
448: htp.tableRowClose;
449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;
452: htp.p('');

Line 449: htp.tableClose;

445: END LOOP;
446: htp.formSelectClose;
447: htp.p('');
448: htp.tableRowClose;
449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;
452: htp.p('');
453: htp.p('Groups and Totals');

Line 450: htp.tableOpen(cAttributes => 'border="0" width="80%"');

446: htp.formSelectClose;
447: htp.p('');
448: htp.tableRowClose;
449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;
452: htp.p('');
453: htp.p('Groups and Totals');
454: htp.p('');

Line 451: htp.tableRowOpen;

447: htp.p('');
448: htp.tableRowClose;
449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;
452: htp.p('');
453: htp.p('Groups and Totals');
454: htp.p('');
455: htp.p(' ');

Line 452: htp.p('');

448: htp.tableRowClose;
449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;
452: htp.p('');
453: htp.p('Groups and Totals');
454: htp.p('');
455: htp.p(' ');
456: htp.p('Repeating Values');

Line 453: htp.p('Groups and Totals');

449: htp.tableClose;
450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;
452: htp.p('');
453: htp.p('Groups and Totals');
454: htp.p('');
455: htp.p(' ');
456: htp.p('Repeating Values');
457: htp.p('');

Line 454: htp.p('');

450: htp.tableOpen(cAttributes => 'border="0" width="80%"');
451: htp.tableRowOpen;
452: htp.p('');
453: htp.p('Groups and Totals');
454: htp.p('');
455: htp.p(' ');
456: htp.p('Repeating Values');
457: htp.p('');
458: htp.p('');

Line 455: htp.p(' ');

451: htp.tableRowOpen;
452: htp.p('');
453: htp.p('Groups and Totals');
454: htp.p('');
455: htp.p(' ');
456: htp.p('Repeating Values');
457: htp.p('');
458: htp.p('');
459: htp.tableRowClose;

Line 456: htp.p('Repeating Values');

452: htp.p('');
453: htp.p('Groups and Totals');
454: htp.p('');
455: htp.p(' ');
456: htp.p('Repeating Values');
457: htp.p('');
458: htp.p('');
459: htp.tableRowClose;
460: htp.tableClose;

Line 457: htp.p('');

453: htp.p('Groups and Totals');
454: htp.p('');
455: htp.p(' ');
456: htp.p('Repeating Values');
457: htp.p('');
458: htp.p('');
459: htp.tableRowClose;
460: htp.tableClose;
461: htp.br;

Line 458: htp.p('');

454: htp.p('');
455: htp.p(' ');
456: htp.p('Repeating Values');
457: htp.p('');
458: htp.p('');
459: htp.tableRowClose;
460: htp.tableClose;
461: htp.br;
462: htp.br;

Line 459: htp.tableRowClose;

455: htp.p(' ');
456: htp.p('Repeating Values');
457: htp.p('');
458: htp.p('');
459: htp.tableRowClose;
460: htp.tableClose;
461: htp.br;
462: htp.br;
463: htp.br;

Line 460: htp.tableClose;

456: htp.p('Repeating Values');
457: htp.p('');
458: htp.p('');
459: htp.tableRowClose;
460: htp.tableClose;
461: htp.br;
462: htp.br;
463: htp.br;
464: footer;

Line 461: htp.br;

457: htp.p('');
458: htp.p('');
459: htp.tableRowClose;
460: htp.tableClose;
461: htp.br;
462: htp.br;
463: htp.br;
464: footer;
465: htp.formClose;

Line 462: htp.br;

458: htp.p('');
459: htp.tableRowClose;
460: htp.tableClose;
461: htp.br;
462: htp.br;
463: htp.br;
464: footer;
465: htp.formClose;
466: htp.bodyClose;

Line 463: htp.br;

459: htp.tableRowClose;
460: htp.tableClose;
461: htp.br;
462: htp.br;
463: htp.br;
464: footer;
465: htp.formClose;
466: htp.bodyClose;
467: htp.htmlClose;

Line 465: htp.formClose;

461: htp.br;
462: htp.br;
463: htp.br;
464: footer;
465: htp.formClose;
466: htp.bodyClose;
467: htp.htmlClose;
468: rollback;
469: ELSE

Line 466: htp.bodyClose;

462: htp.br;
463: htp.br;
464: footer;
465: htp.formClose;
466: htp.bodyClose;
467: htp.htmlClose;
468: rollback;
469: ELSE
470: htp.p('Invalid session');

Line 467: htp.htmlClose;

463: htp.br;
464: footer;
465: htp.formClose;
466: htp.bodyClose;
467: htp.htmlClose;
468: rollback;
469: ELSE
470: htp.p('Invalid session');
471: END IF;

Line 470: htp.p('Invalid session');

466: htp.bodyClose;
467: htp.htmlClose;
468: rollback;
469: ELSE
470: htp.p('Invalid session');
471: END IF;
472: EXCEPTION
473: WHEN others THEN
474: htp.p(SQLERRM);

Line 474: htp.p(SQLERRM);

470: htp.p('Invalid session');
471: END IF;
472: EXCEPTION
473: WHEN others THEN
474: htp.p(SQLERRM);
475: END pipeline_buckets_paramform;
476: --------------------------------------------------------------------------------
477: PROCEDURE footer IS
478: BEGIN

Line 480: htp.htmlOpen;

476: --------------------------------------------------------------------------------
477: PROCEDURE footer IS
478: BEGIN
479: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
480: htp.htmlOpen;
481: htp.tableRowOpen;
482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');

Line 481: htp.tableRowOpen;

477: PROCEDURE footer IS
478: BEGIN
479: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
480: htp.htmlOpen;
481: htp.tableRowOpen;
482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;

Line 482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');

478: BEGIN
479: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
480: htp.htmlOpen;
481: htp.tableRowOpen;
482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');

Line 483: htp.tableRowClose;

479: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
480: htp.htmlOpen;
481: htp.tableRowOpen;
482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));

Line 484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');

480: htp.htmlOpen;
481: htp.tableRowOpen;
482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');

Line 485: htp.tableRowOpen;

481: htp.tableRowOpen;
482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');
489: htp.p('');

Line 486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');

482: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');
489: htp.p('');
490: htp.p('');

Line 487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));

483: htp.tableRowClose;
484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');
489: htp.p('');
490: htp.p('');
491: --htp.tableData('');

Line 488: htp.p('');

484: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');
489: htp.p('');
490: htp.p('');
491: --htp.tableData('');
492: htp.tableData( '');

Line 489: htp.p('');

485: htp.tableRowOpen;
486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');
489: htp.p('');
490: htp.p('');
491: --htp.tableData('');
492: htp.tableData( '');
493: htp.tableData( '');

Line 490: htp.p('');

486: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');
489: htp.p('');
490: htp.p('');
491: --htp.tableData('');
492: htp.tableData( '');
493: htp.tableData( '');
494: htp.tableRowClose;

Line 491: --htp.tableData('');

487: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
488: htp.p('');
489: htp.p('');
490: htp.p('');
491: --htp.tableData('');
492: htp.tableData( '');
493: htp.tableData( '');
494: htp.tableRowClose;
495: htp.tableClose;

Line 492: htp.tableData( '');

488: htp.p('');
489: htp.p('');
490: htp.p('');
491: --htp.tableData('');
492: htp.tableData( '');
493: htp.tableData( '');
494: htp.tableRowClose;
495: htp.tableClose;
496: htp.htmlClose;

Line 493: htp.tableData( '');

489: htp.p('');
490: htp.p('');
491: --htp.tableData('');
492: htp.tableData( '');
493: htp.tableData( '');
494: htp.tableRowClose;
495: htp.tableClose;
496: htp.htmlClose;
497: END footer;

Line 494: htp.tableRowClose;

490: htp.p('');
491: --htp.tableData('');
492: htp.tableData( '');
493: htp.tableData( '');
494: htp.tableRowClose;
495: htp.tableClose;
496: htp.htmlClose;
497: END footer;
498: END;

Line 495: htp.tableClose;

491: --htp.tableData('');
492: htp.tableData( '');
493: htp.tableData( '');
494: htp.tableRowClose;
495: htp.tableClose;
496: htp.htmlClose;
497: END footer;
498: END;

Line 496: htp.htmlClose;

492: htp.tableData( '');
493: htp.tableData( '');
494: htp.tableRowClose;
495: htp.tableClose;
496: htp.htmlClose;
497: END footer;
498: END;