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_TRANS_SIZES_PARAM dependencies on HTP

Line 40: htp.htmlopen;

36: begin
37:
38: select to_char(sysdate, 'DD-MON-YYYY') into v_date_time from dual;
39:
40: htp.htmlopen;
41: htp.headOpen;
42: htp.title('Transaction Counts and Deal Sizes');
43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 41: htp.headOpen;

37:
38: select to_char(sysdate, 'DD-MON-YYYY') into v_date_time from dual;
39:
40: htp.htmlopen;
41: htp.headOpen;
42: htp.title('Transaction Counts and Deal Sizes');
43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');

Line 42: htp.title('Transaction Counts and Deal Sizes');

38: select to_char(sysdate, 'DD-MON-YYYY') into v_date_time from dual;
39:
40: htp.htmlopen;
41: htp.headOpen;
42: htp.title('Transaction Counts and Deal Sizes');
43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );

Line 43: htp.headClose;

39:
40: htp.htmlopen;
41: htp.headOpen;
42: htp.title('Transaction Counts and Deal Sizes');
43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));

Line 44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

40: htp.htmlopen;
41: htp.headOpen;
42: htp.title('Transaction Counts and Deal Sizes');
43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');

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

41: htp.headOpen;
42: htp.title('Transaction Counts and Deal Sizes');
43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

Line 46: htp.tableRowOpen( calign => 'TOP' );

42: htp.title('Transaction Counts and Deal Sizes');
43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;

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

43: htp.headClose;
44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;
51: htp.tableClose;

Line 48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');

44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;
51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );

Line 49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

45: htp.tableOpen('border="0" ');
46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;
51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
53: htp.tableRowOpen( cvalign => 'top' );

Line 50: htp.tableRowClose;

46: htp.tableRowOpen( calign => 'TOP' );
47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;
51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
53: htp.tableRowOpen( cvalign => 'top' );
54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

Line 51: htp.tableClose;

47: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;
51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
53: htp.tableRowOpen( cvalign => 'top' );
54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

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

48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');
49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;
51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
53: htp.tableRowOpen( cvalign => 'top' );
54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');

Line 53: htp.tableRowOpen( cvalign => 'top' );

49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
50: htp.tableRowClose;
51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
53: htp.tableRowOpen( cvalign => 'top' );
54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
57: htp.tableData( ' ', ccolspan => '6');

Line 54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

50: htp.tableRowClose;
51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
53: htp.tableRowOpen( cvalign => 'top' );
54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
57: htp.tableData( ' ', ccolspan => '6');
58: htp.Br;

Line 55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

51: htp.tableClose;
52: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
53: htp.tableRowOpen( cvalign => 'top' );
54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
57: htp.tableData( ' ', ccolspan => '6');
58: htp.Br;
59: htp.tableRowClose;

Line 57: htp.tableData( ' ', ccolspan => '6');

53: htp.tableRowOpen( cvalign => 'top' );
54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
57: htp.tableData( ' ', ccolspan => '6');
58: htp.Br;
59: htp.tableRowClose;
60: htp.tableClose;
61: htp.bodyClose;

Line 58: htp.Br;

54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
57: htp.tableData( ' ', ccolspan => '6');
58: htp.Br;
59: htp.tableRowClose;
60: htp.tableClose;
61: htp.bodyClose;
62: htp.headClose;

Line 59: htp.tableRowClose;

55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
57: htp.tableData( ' ', ccolspan => '6');
58: htp.Br;
59: htp.tableRowClose;
60: htp.tableClose;
61: htp.bodyClose;
62: htp.headClose;
63: htp.htmlClose;

Line 60: htp.tableClose;

56: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
57: htp.tableData( ' ', ccolspan => '6');
58: htp.Br;
59: htp.tableRowClose;
60: htp.tableClose;
61: htp.bodyClose;
62: htp.headClose;
63: htp.htmlClose;
64: end;

Line 61: htp.bodyClose;

57: htp.tableData( ' ', ccolspan => '6');
58: htp.Br;
59: htp.tableRowClose;
60: htp.tableClose;
61: htp.bodyClose;
62: htp.headClose;
63: htp.htmlClose;
64: end;
65: -----------------------------------------------------------------------------------------------

Line 62: htp.headClose;

58: htp.Br;
59: htp.tableRowClose;
60: htp.tableClose;
61: htp.bodyClose;
62: htp.headClose;
63: htp.htmlClose;
64: end;
65: -----------------------------------------------------------------------------------------------
66: procedure trans_deal_sizes_paramform is

Line 63: htp.htmlClose;

59: htp.tableRowClose;
60: htp.tableClose;
61: htp.bodyClose;
62: htp.headClose;
63: htp.htmlClose;
64: end;
65: -----------------------------------------------------------------------------------------------
66: procedure trans_deal_sizes_paramform is
67:

Line 156: htp.FormOpen(owa_util.Get_Owa_Service_Path||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cattributes => ' NAME="param"');

152:
153: /* set user's currency code */
154: v_usr_currency_code := FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY');
155:
156: htp.FormOpen(owa_util.Get_Owa_Service_Path||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cattributes => ' NAME="param"');
157: htp.htmlopen;
158: htp.headOpen;
159: htp.title('Event Registration Summary Report');
160: htp.p('');

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

210: htp.p(' alert(''Start Date must be less than End Date'');');
211: htp.p(' p_valid = false;}');
212: htp.p(' }');
213: htp.p(' }');
214: htp.p(' if (p_valid){');
215: htp.p(' objform.submit();}');
216: htp.p('}');
217: htp.p('');
218: htp.headClose;

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

211: htp.p(' p_valid = false;}');
212: htp.p(' }');
213: htp.p(' }');
214: htp.p(' if (p_valid){');
215: htp.p(' objform.submit();}');
216: htp.p('}');
217: htp.p('');
218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

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

212: htp.p(' }');
213: htp.p(' }');
214: htp.p(' if (p_valid){');
215: htp.p(' objform.submit();}');
216: htp.p('}');
217: htp.p('');
218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;

Line 217: htp.p('');

213: htp.p(' }');
214: htp.p(' if (p_valid){');
215: htp.p(' objform.submit();}');
216: htp.p('}');
217: htp.p('');
218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );

Line 218: htp.headClose;

214: htp.p(' if (p_valid){');
215: htp.p(' objform.submit();}');
216: htp.p('}');
217: htp.p('');
218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');

Line 219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

215: htp.p(' objform.submit();}');
216: htp.p('}');
217: htp.p('');
218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

Line 220: htp.tableopen;

216: htp.p('}');
217: htp.p('');
218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');

Line 221: htp.tableRowOpen( cvalign => 'top' );

217: htp.p('');
218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');
225: htp.tableRowClose;

Line 222: htp.tableData( ' ', cattributes => ' height=9');

218: htp.headClose;
219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');
225: htp.tableRowClose;
226: htp.tableClose;

Line 223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');
225: htp.tableRowClose;
226: htp.tableClose;
227: htp.tableOpen(cattributes=>'width="600" ');

Line 224: htp.tableData( ' ');

220: htp.tableopen;
221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');
225: htp.tableRowClose;
226: htp.tableClose;
227: htp.tableOpen(cattributes=>'width="600" ');
228: htp.tableRowOpen();

Line 225: htp.tableRowClose;

221: htp.tableRowOpen( cvalign => 'top' );
222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');
225: htp.tableRowClose;
226: htp.tableClose;
227: htp.tableOpen(cattributes=>'width="600" ');
228: htp.tableRowOpen();
229: htp.p('Select Output Format');

Line 226: htp.tableClose;

222: htp.tableData( ' ', cattributes => ' height=9');
223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');
225: htp.tableRowClose;
226: htp.tableClose;
227: htp.tableOpen(cattributes=>'width="600" ');
228: htp.tableRowOpen();
229: htp.p('Select Output Format');
230: htp.p('');

Line 227: htp.tableOpen(cattributes=>'width="600" ');

223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
224: htp.tableData( ' ');
225: htp.tableRowClose;
226: htp.tableClose;
227: htp.tableOpen(cattributes=>'width="600" ');
228: htp.tableRowOpen();
229: htp.p('Select Output Format');
230: htp.p('');
231: htp.p ('');
232: htp.FormSelectOption('Excel');

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

225: htp.tableRowClose;
226: htp.tableClose;
227: htp.tableOpen(cattributes=>'width="600" ');
228: htp.tableRowOpen();
229: htp.p('Select Output Format');
230: htp.p('');
231: htp.p ('');
232: htp.FormSelectOption('Excel');
233: htp.FormSelectOption('HTML',cselected => 'TRUE');
234: htp.FormSelectClose;

Line 231: htp.p ('');
232: htp.FormSelectOption('Excel');
233: htp.FormSelectOption('HTML',cselected => 'TRUE');
234: htp.FormSelectClose;
235: htp.tableRowClose;

Line 232: htp.FormSelectOption('Excel');

228: htp.tableRowOpen();
229: htp.p('Select Output Format');
230: htp.p('');
231: htp.p ('');
232: htp.FormSelectOption('Excel');
233: htp.FormSelectOption('HTML',cselected => 'TRUE');
234: htp.FormSelectClose;
235: htp.tableRowClose;
236:
237: htp.tableRowClose;

Line 234: htp.FormSelectClose;

230: htp.p('');
231: htp.p ('');
232: htp.FormSelectOption('Excel');
233: htp.FormSelectOption('HTML',cselected => 'TRUE');
234: htp.FormSelectClose;
235: htp.tableRowClose;
236:
237: htp.tableRowClose;
238:
239: htp.tableRowOpen();

Line 237: htp.tableRowClose;

233: htp.FormSelectOption('HTML',cselected => 'TRUE');
234: htp.FormSelectClose;
235: htp.tableRowClose;
236:
237: htp.tableRowClose;
238:
239: htp.tableRowOpen();
240: htp.p('Start Date');
241: htp.p('');

Line 239: htp.tableRowOpen();

235: htp.tableRowClose;
236:
237: htp.tableRowClose;
238:
239: htp.tableRowOpen();
240: htp.p('Start Date');
241: htp.p('');
242: --owa_util.choose_date('p_test', sysdate);
243: htp.p ('');
244: -- htp.FormSelectOption(' ');

Line 241: htp.p('');

237: htp.tableRowClose;
238:
239: htp.tableRowOpen();
240: htp.p('Start Date');
241: htp.p('');
242: --owa_util.choose_date('p_test', sysdate);
243: htp.p ('');

239: htp.tableRowOpen();
240: htp.p('Start Date');
241: htp.p('');
242: --owa_util.choose_date('p_test', sysdate);
243: htp.p ('');
244: -- htp.FormSelectOption(' ');
245: FOR i IN 1..day_data.count LOOP
246: htp.FormSelectOption(day_data(i),
247: cattributes => ' value= '||day_data(i),
248: cselected => 'TRUE' );

Line 246: htp.FormSelectOption(day_data(i),

242: --owa_util.choose_date('p_test', sysdate);
243: htp.p ('');
254: FOR i IN 1..12 LOOP

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

247: cattributes => ' value= '||day_data(i),
248: cselected => 'TRUE' );
249: END LOOP;
250: htp.FormSelectClose;
251: htp.p('-');
252:
253: htp.p ('');

249: END LOOP;
250: htp.FormSelectClose;
251: htp.p('-');
252:
253: htp.p ('');
254: FOR i IN 1..12 LOOP
255: if i=1 then
256: --htp.FormSelectOption(lpad(to_char(i),2,'0'),
257: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
258: cattributes => ' value='||lpad(to_char(i),2,'0'),
259: cselected => 'TRUE' );
260: else

Line 257: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

253: htp.p ('');
270: -- htp.FormSelectOption(' ');

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

263: cattributes => ' value='||lpad(to_char(i),2,'0'));
264: end if;
265: END LOOP;
266: htp.FormSelectClose;
267: htp.p('-');
268:
269: htp.p ('');

265: END LOOP;
266: htp.FormSelectClose;
267: htp.p('-');
268:
269: htp.p ('');
270: -- htp.FormSelectOption(' ');
271: FOR i IN 1..year_data.count LOOP
272: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
273: htp.FormSelectOption(year_data(i),
274: cattributes => ' value= '||year_data(i),

Line 273: htp.FormSelectOption(year_data(i),

269: htp.p ('');
289: -- htp.FormSelectOption(' ');

Line 286: htp.p('End Date');

282: htp.p('');
283: htp.tableRowClose;
284:
285: htp.tableRowOpen();
286: htp.p('End Date');
287: htp.p('');
288: htp.p ('');
289: -- htp.FormSelectOption(' ');
290: FOR i IN 1..day_data.count LOOP
291: htp.FormSelectOption(day_data(i),

Line 288: htp.p ('');
289: -- htp.FormSelectOption(' ');
290: FOR i IN 1..day_data.count LOOP
291: htp.FormSelectOption(day_data(i),
292: cattributes => ' value= '||day_data(i),

Line 289: -- htp.FormSelectOption(' ');

285: htp.tableRowOpen();
286: htp.p('End Date');
287: htp.p('');
288: htp.p ('');
289: -- htp.FormSelectOption(' ');
290: FOR i IN 1..day_data.count LOOP
291: htp.FormSelectOption(day_data(i),
292: cattributes => ' value= '||day_data(i),
293: cselected => 'TRUE' );
294: END LOOP;
295: htp.FormSelectClose;

Line 295: htp.FormSelectClose;

291: htp.FormSelectOption(day_data(i),
292: cattributes => ' value= '||day_data(i),
293: cselected => 'TRUE' );
294: END LOOP;
295: htp.FormSelectClose;
296: htp.p('-');
297:
298: htp.p ('');
299: FOR i IN 1..12 LOOP
300: if i=1 then

Line 298: htp.p ('');
299: FOR i IN 1..12 LOOP
300: if i=1 then
301: --htp.FormSelectOption(lpad(to_char(i),2,'0'),
302: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

Line 301: --htp.FormSelectOption(lpad(to_char(i),2,'0'),

297:
298: htp.p ('');
299: FOR i IN 1..12 LOOP
300: if i=1 then
301: --htp.FormSelectOption(lpad(to_char(i),2,'0'),
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(lpad(to_char(i),2,'0'),

Line 306: --htp.FormSelectOption(lpad(to_char(i),2,'0'),

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(lpad(to_char(i),2,'0'),
307: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
308: cattributes => ' value='||lpad(to_char(i),2,'0'));
309: end if;
310: END LOOP;

Line 307: 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(lpad(to_char(i),2,'0'),
307: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
308: cattributes => ' value='||lpad(to_char(i),2,'0'));
309: end if;
310: END LOOP;
311: htp.FormSelectClose;

Line 311: htp.FormSelectClose;

307: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
308: cattributes => ' value='||lpad(to_char(i),2,'0'));
309: end if;
310: END LOOP;
311: htp.FormSelectClose;
312: htp.p('-');
313:
314: htp.p ('');
315: -- htp.FormSelectOption(' ');
316: FOR i IN 1..year_data.count LOOP

Line 314: htp.p ('');
315: -- htp.FormSelectOption(' ');
316: FOR i IN 1..year_data.count LOOP
317: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
318: htp.FormSelectOption(year_data(i),

Line 315: -- htp.FormSelectOption(' ');

311: htp.FormSelectClose;
312: htp.p('-');
313:
314: htp.p ('');
315: -- htp.FormSelectOption(' ');
316: FOR i IN 1..year_data.count LOOP
317: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
318: htp.FormSelectOption(year_data(i),
319: cattributes => ' value= '||year_data(i),
320: cselected => 'TRUE');
321: ELSE
322: htp.FormSelectOption(year_data(i),

Line 322: htp.FormSelectOption(year_data(i),

318: htp.FormSelectOption(year_data(i),
319: cattributes => ' value= '||year_data(i),
320: cselected => 'TRUE');
321: ELSE
322: htp.FormSelectOption(year_data(i),
323: cattributes => ' value= '||year_data(i));
324: END IF;
325: END LOOP;
326: htp.FormSelectClose;

Line 326: htp.FormSelectClose;

322: htp.FormSelectOption(year_data(i),
323: cattributes => ' value= '||year_data(i));
324: END IF;
325: END LOOP;
326: htp.FormSelectClose;
327: htp.p('');
328: htp.tableRowClose;
329:
330: htp.tableRowOpen();

Line 327: htp.p('');

323: cattributes => ' value= '||year_data(i));
324: END IF;
325: END LOOP;
326: htp.FormSelectClose;
327: htp.p('');
328: htp.tableRowClose;
329:
330: htp.tableRowOpen();
331: htp.p('Are these Close Dates or Creation Dates');

Line 328: htp.tableRowClose;

324: END IF;
325: END LOOP;
326: htp.FormSelectClose;
327: htp.p('');
328: htp.tableRowClose;
329:
330: htp.tableRowOpen();
331: htp.p('Are these Close Dates or Creation Dates');
332: htp.p('');

Line 330: htp.tableRowOpen();

326: htp.FormSelectClose;
327: htp.p('');
328: htp.tableRowClose;
329:
330: htp.tableRowOpen();
331: htp.p('Are these Close Dates or Creation Dates');
332: htp.p('');
333: htp.p ('');
334: htp.FormSelectOption('Creation Dates',
335: cattributes => ' value= '||'ENTRY');

Line 332: htp.p('');

328: htp.tableRowClose;
329:
330: htp.tableRowOpen();
331: htp.p('Are these Close Dates or Creation Dates');
332: htp.p('');
333: htp.p ('');

329:
330: htp.tableRowOpen();
331: htp.p('Are these Close Dates or Creation Dates');
332: htp.p('');
333: htp.p ('');
334: htp.FormSelectOption('Creation Dates',
335: cattributes => ' value= '||'ENTRY');
336: htp.FormSelectOption('Close Dates',
337: cattributes => ' value= '||'CLOSE',
338: cselected => 'TRUE' );

Line 336: htp.FormSelectOption('Close Dates',

332: htp.p('');
333: htp.p ('');
347: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP

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

340: htp.p('');
341: htp.tableRowClose;
342:
343: htp.tableRowOpen();
344: htp.p('Sales Group');
345: htp.p('');
346: htp.p ('');
347: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
348: htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);
349: --htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||7062);

Line 346: htp.p ('');
347: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
348: htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);
349: --htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||7062);
350: END LOOP;

Line 348: htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);

344: htp.p('Sales Group');
345: htp.p('');
346: htp.p ('');
347: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
348: htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);
349: --htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||7062);
350: END LOOP;
351: htp.FormSelectClose;
352: htp.p('');
353: htp.tableRowClose;

Line 351: htp.FormSelectClose;

347: FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
348: htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);
349: --htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||7062);
350: END LOOP;
351: htp.FormSelectClose;
352: htp.p('');
353: htp.tableRowClose;
354: --htp.p('');
355:

Line 352: htp.p('');

348: htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);
349: --htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||7062);
350: END LOOP;
351: htp.FormSelectClose;
352: htp.p('');
353: htp.tableRowClose;
354: --htp.p('');
355:
356: htp.tableRowOpen();

Line 353: htp.tableRowClose;

349: --htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||7062);
350: END LOOP;
351: htp.FormSelectClose;
352: htp.p('');
353: htp.tableRowClose;
354: --htp.p('');
355:
356: htp.tableRowOpen();
357: htp.p('Reporting Currency');

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

350: END LOOP;
351: htp.FormSelectClose;
352: htp.p('');
353: htp.tableRowClose;
354: --htp.p('');
355:
356: htp.tableRowOpen();
357: htp.p('Reporting Currency');
358: htp.p('');

Line 356: htp.tableRowOpen();

352: htp.p('');
353: htp.tableRowClose;
354: --htp.p('');
355:
356: htp.tableRowOpen();
357: htp.p('Reporting Currency');
358: htp.p('');
359: htp.p ('');
355:
356: htp.tableRowOpen();
357: htp.p('Reporting Currency');
358: htp.p('');
359: htp.p ('');
355:
356: htp.tableRowOpen();
357: htp.p('Reporting Currency');
358: htp.p('');
359: htp.p ('');

355:
356: htp.tableRowOpen();
357: htp.p('Reporting Currency');
358: htp.p('');
359: htp.p ('');

Line 375: htp.tableRowOpen;

371: htp.tableRowClose;
372: htp.tableClose;
373:
374: htp.tableOpen(cattributes=>'border="0" width="80%"');
375: htp.tableRowOpen;
376: htp.p('');
377: htp.p('Groups and Totals');
378: htp.p('');
379: htp.p(' ');

Line 376: htp.p('');

372: htp.tableClose;
373:
374: htp.tableOpen(cattributes=>'border="0" width="80%"');
375: htp.tableRowOpen;
376: htp.p('');
377: htp.p('Groups and Totals');
378: htp.p('');
379: htp.p(' ');
380: htp.p('Repeating Values');

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

373:
374: htp.tableOpen(cattributes=>'border="0" width="80%"');
375: htp.tableRowOpen;
376: htp.p('');
377: htp.p('Groups and Totals');
378: htp.p('');
379: htp.p(' ');
380: htp.p('Repeating Values');
381: htp.p('');

Line 378: htp.p('');

374: htp.tableOpen(cattributes=>'border="0" width="80%"');
375: htp.tableRowOpen;
376: htp.p('');
377: htp.p('Groups and Totals');
378: htp.p('');
379: htp.p(' ');
380: htp.p('Repeating Values');
381: htp.p('');
382: htp.p('');

Line 379: htp.p(' ');

375: htp.tableRowOpen;
376: htp.p('');
377: htp.p('Groups and Totals');
378: htp.p('');
379: htp.p(' ');
380: htp.p('Repeating Values');
381: htp.p('');
382: htp.p('');
383: htp.tableRowClose;

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

376: htp.p('');
377: htp.p('Groups and Totals');
378: htp.p('');
379: htp.p(' ');
380: htp.p('Repeating Values');
381: htp.p('');
382: htp.p('');
383: htp.tableRowClose;
384:

Line 381: htp.p('');

377: htp.p('Groups and Totals');
378: htp.p('');
379: htp.p(' ');
380: htp.p('Repeating Values');
381: htp.p('');
382: htp.p('');
383: htp.tableRowClose;
384:
385: htp.tableClose;

Line 382: htp.p('');

378: htp.p('');
379: htp.p(' ');
380: htp.p('Repeating Values');
381: htp.p('');
382: htp.p('');
383: htp.tableRowClose;
384:
385: htp.tableClose;
386: htp.Br;

Line 383: htp.tableRowClose;

379: htp.p(' ');
380: htp.p('Repeating Values');
381: htp.p('');
382: htp.p('');
383: htp.tableRowClose;
384:
385: htp.tableClose;
386: htp.Br;
387: htp.Br;

Line 385: htp.tableClose;

381: htp.p('');
382: htp.p('');
383: htp.tableRowClose;
384:
385: htp.tableClose;
386: htp.Br;
387: htp.Br;
388: htp.Br;
389: footer;

Line 386: htp.Br;

382: htp.p('');
383: htp.tableRowClose;
384:
385: htp.tableClose;
386: htp.Br;
387: htp.Br;
388: htp.Br;
389: footer;
390: htp.FormClose;

Line 387: htp.Br;

383: htp.tableRowClose;
384:
385: htp.tableClose;
386: htp.Br;
387: htp.Br;
388: htp.Br;
389: footer;
390: htp.FormClose;
391: htp.bodyclose;

Line 388: htp.Br;

384:
385: htp.tableClose;
386: htp.Br;
387: htp.Br;
388: htp.Br;
389: footer;
390: htp.FormClose;
391: htp.bodyclose;
392: htp.htmlclose;

Line 390: htp.FormClose;

386: htp.Br;
387: htp.Br;
388: htp.Br;
389: footer;
390: htp.FormClose;
391: htp.bodyclose;
392: htp.htmlclose;
393: else
394: htp.p('Invalid session');

Line 391: htp.bodyclose;

387: htp.Br;
388: htp.Br;
389: footer;
390: htp.FormClose;
391: htp.bodyclose;
392: htp.htmlclose;
393: else
394: htp.p('Invalid session');
395: end if;

Line 392: htp.htmlclose;

388: htp.Br;
389: footer;
390: htp.FormClose;
391: htp.bodyclose;
392: htp.htmlclose;
393: else
394: htp.p('Invalid session');
395: end if;
396:

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

390: htp.FormClose;
391: htp.bodyclose;
392: htp.htmlclose;
393: else
394: htp.p('Invalid session');
395: end if;
396:
397: rollback;
398:

Line 401: htp.p(SQLERRM);

397: rollback;
398:
399: exception
400: when others then
401: htp.p(SQLERRM);
402: END trans_deal_sizes_paramform;
403:
404:
405: procedure footer is

Line 408: htp.htmlopen;

404:
405: procedure footer is
406: BEGIN
407: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
408: htp.htmlopen;
409: htp.tableRowOpen;
410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );

Line 409: htp.tableRowOpen;

405: procedure footer is
406: BEGIN
407: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
408: htp.htmlopen;
409: htp.tableRowOpen;
410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;

Line 410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');

406: BEGIN
407: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
408: htp.htmlopen;
409: htp.tableRowOpen;
410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');

Line 411: htp.tableRowClose;

407: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
408: htp.htmlopen;
409: htp.tableRowOpen;
410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));

Line 412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );

408: htp.htmlopen;
409: htp.tableRowOpen;
410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');

Line 413: htp.tableRowOpen;

409: htp.tableRowOpen;
410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');
417: htp.p('');

Line 414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');

410: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');
417: htp.p('');
418: htp.p('');

Line 415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));

411: htp.tableRowClose;
412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');
417: htp.p('');
418: htp.p('');
419: --htp.tableData( '');

Line 416: htp.p('');

412: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');
417: htp.p('');
418: htp.p('');
419: --htp.tableData( '');
420: htp.tableData( '');

Line 417: htp.p('');

413: htp.tableRowOpen;
414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');
417: htp.p('');
418: htp.p('');
419: --htp.tableData( '');
420: htp.tableData( '');
421: htp.tableData( '');

Line 418: htp.p('');

414: htp.formOpen( curl => l_agent||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');
417: htp.p('');
418: htp.p('');
419: --htp.tableData( '');
420: htp.tableData( '');
421: htp.tableData( '');
422: htp.tableRowClose;

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

415: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
416: htp.p('');
417: htp.p('');
418: htp.p('');
419: --htp.tableData( '');
420: htp.tableData( '');
421: htp.tableData( '');
422: htp.tableRowClose;
423: htp.tableClose;

Line 420: htp.tableData( '');

416: htp.p('');
417: htp.p('');
418: htp.p('');
419: --htp.tableData( '');
420: htp.tableData( '');
421: htp.tableData( '');
422: htp.tableRowClose;
423: htp.tableClose;
424: htp.htmlClose;

Line 421: htp.tableData( '');

417: htp.p('');
418: htp.p('');
419: --htp.tableData( '');
420: htp.tableData( '');
421: htp.tableData( '');
422: htp.tableRowClose;
423: htp.tableClose;
424: htp.htmlClose;
425: END footer;

Line 422: htp.tableRowClose;

418: htp.p('');
419: --htp.tableData( '');
420: htp.tableData( '');
421: htp.tableData( '');
422: htp.tableRowClose;
423: htp.tableClose;
424: htp.htmlClose;
425: END footer;
426: END;

Line 423: htp.tableClose;

419: --htp.tableData( '');
420: htp.tableData( '');
421: htp.tableData( '');
422: htp.tableRowClose;
423: htp.tableClose;
424: htp.htmlClose;
425: END footer;
426: END;

Line 424: htp.htmlClose;

420: htp.tableData( '');
421: htp.tableData( '');
422: htp.tableRowClose;
423: htp.tableClose;
424: htp.htmlClose;
425: END footer;
426: END;

APPS.AST_OFL_TRANS_SIZES_PARAM dependencies on HTP

Line 40: htp.htmlopen;

Line 41: htp.headOpen;

Line 42: htp.title('Transaction Counts and Deal Sizes');

Line 43: htp.headClose;

Line 44: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

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

Line 46: htp.tableRowOpen( calign => 'TOP' );

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

Line 48: htp.tableData( '' || 'Transaction Counts and Deal Sizes Report', cnowrap => 'TRUE');

Line 49: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

Line 50: htp.tableRowClose;

Line 51: htp.tableClose;

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

Line 53: htp.tableRowOpen( cvalign => 'top' );

Line 54: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

Line 55: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

Line 57: htp.tableData( ' ', ccolspan => '6');

Line 58: htp.Br;

Line 59: htp.tableRowClose;

Line 60: htp.tableClose;

Line 61: htp.bodyClose;

Line 62: htp.headClose;

Line 63: htp.htmlClose;

Line 156: htp.FormOpen(owa_util.Get_Owa_Service_Path||'ast_ofl_TRANS_SIZES_REPORT.report_wrapper', cattributes => ' NAME="param"');

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

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

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

Line 217: htp.p('');

Line 218: htp.headClose;

Line 219: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 220: htp.tableopen;

Line 221: htp.tableRowOpen( cvalign => 'top' );

Line 222: htp.tableData( ' ', cattributes => ' height=9');

Line 223: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

Line 224: htp.tableData( ' ');

Line 225: htp.tableRowClose;

Line 226: htp.tableClose;

Line 227: htp.tableOpen(cattributes=>'width="600" ');

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

Line 232: htp.FormSelectOption('Excel');

Line 234: htp.FormSelectClose;

Line 237: htp.tableRowClose;

Line 239: htp.tableRowOpen();

Line 241: htp.p('');

Line 246: htp.FormSelectOption(day_data(i),

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

Line 257: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

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

Line 273: htp.FormSelectOption(year_data(i),

Line 286: htp.p('End Date');

Line 288: htp.p (''); 284: 285: htp.tableRowOpen(); 286: htp.p('End Date'); 287: htp.p(''); 288: htp.p (''); 289: -- htp.FormSelectOption(' '); 290: FOR i IN 1..day_data.count LOOP 291: htp.FormSelectOption(day_data(i), 292: cattributes => ' value= '||day_data(i),

Line 289: -- htp.FormSelectOption(' ');

Line 295: htp.FormSelectClose;

Line 298: htp.p (''); 294: END LOOP; 295: htp.FormSelectClose; 296: htp.p('-'); 297: 298: htp.p (''); 299: FOR i IN 1..12 LOOP 300: if i=1 then 301: --htp.FormSelectOption(lpad(to_char(i),2,'0'), 302: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

Line 301: --htp.FormSelectOption(lpad(to_char(i),2,'0'),

Line 306: --htp.FormSelectOption(lpad(to_char(i),2,'0'),

Line 307: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

Line 311: htp.FormSelectClose;

Line 314: htp.p (''); 310: END LOOP; 311: htp.FormSelectClose; 312: htp.p('-'); 313: 314: htp.p (''); 315: -- htp.FormSelectOption(' '); 316: FOR i IN 1..year_data.count LOOP 317: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN 318: htp.FormSelectOption(year_data(i),

Line 315: -- htp.FormSelectOption(' ');

Line 322: htp.FormSelectOption(year_data(i),

Line 326: htp.FormSelectClose;

Line 327: htp.p('');

Line 328: htp.tableRowClose;

Line 330: htp.tableRowOpen();

Line 332: htp.p('');

Line 336: htp.FormSelectOption('Close Dates',

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

Line 348: htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);

Line 351: htp.FormSelectClose;

Line 352: htp.p('');

Line 353: htp.tableRowClose;

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

Line 356: htp.tableRowOpen();

Line 375: htp.tableRowOpen;

Line 376: htp.p('');

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

Line 378: htp.p('');

Line 379: htp.p(' ');

Line 288: htp.p ('');
289: -- htp.FormSelectOption(' ');
290: FOR i IN 1..day_data.count LOOP
291: htp.FormSelectOption(day_data(i),
292: cattributes => ' value= '||day_data(i),

Line 298: htp.p ('');
299: FOR i IN 1..12 LOOP
300: if i=1 then
301: --htp.FormSelectOption(lpad(to_char(i),2,'0'),
302: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

Line 314: htp.p ('');
315: -- htp.FormSelectOption(' ');
316: FOR i IN 1..year_data.count LOOP
317: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
318: htp.FormSelectOption(year_data(i),