DBA Data[Home] [Help]

APPS.AST_OFL_EVENT_INFO_PARAM dependencies on HTP

Line 49: htp.htmlOpen;

45: -- End Mod.
46: SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY')
47: INTO v_date_time
48: FROM DUAL;
49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Event Information');
52: htp.headClose;
53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

Line 50: htp.headOpen;

46: SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY')
47: INTO v_date_time
48: FROM DUAL;
49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Event Information');
52: htp.headClose;
53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
54: htp.tableOpen('border="0" ');

Line 51: htp.title('Event Information');

47: INTO v_date_time
48: FROM DUAL;
49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Event Information');
52: htp.headClose;
53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
54: htp.tableOpen('border="0" ');
55: htp.tableRowOpen(cAlign => 'TOP');

Line 52: htp.headClose;

48: FROM DUAL;
49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Event Information');
52: htp.headClose;
53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
54: htp.tableOpen('border="0" ');
55: htp.tableRowOpen(cAlign => 'TOP');
56:

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

49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Event Information');
52: htp.headClose;
53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
54: htp.tableOpen('border="0" ');
55: htp.tableRowOpen(cAlign => 'TOP');
56:
57: --htp.tableData(htf.img( cUrl => g_image_prefix || 'oppty.gif'));

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

50: htp.headOpen;
51: htp.title('Event Information');
52: htp.headClose;
53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
54: htp.tableOpen('border="0" ');
55: htp.tableRowOpen(cAlign => 'TOP');
56:
57: --htp.tableData(htf.img( cUrl => g_image_prefix || 'oppty.gif'));
58:

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

51: htp.title('Event Information');
52: htp.headClose;
53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
54: htp.tableOpen('border="0" ');
55: htp.tableRowOpen(cAlign => 'TOP');
56:
57: --htp.tableData(htf.img( cUrl => g_image_prefix || 'oppty.gif'));
58:
59: htp.tableData('' || 'Event Information Report',

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

53: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
54: htp.tableOpen('border="0" ');
55: htp.tableRowOpen(cAlign => 'TOP');
56:
57: --htp.tableData(htf.img( cUrl => g_image_prefix || 'oppty.gif'));
58:
59: htp.tableData('' || 'Event Information Report',
60: cNoWrap => 'TRUE');
61: htp.tableData(htf.bold(v_date_time),

Line 59: htp.tableData('' || 'Event Information Report',

55: htp.tableRowOpen(cAlign => 'TOP');
56:
57: --htp.tableData(htf.img( cUrl => g_image_prefix || 'oppty.gif'));
58:
59: htp.tableData('' || 'Event Information Report',
60: cNoWrap => 'TRUE');
61: htp.tableData(htf.bold(v_date_time),
62: cAlign => 'right',
63: cColSpan => '110');

Line 61: htp.tableData(htf.bold(v_date_time),

57: --htp.tableData(htf.img( cUrl => g_image_prefix || 'oppty.gif'));
58:
59: htp.tableData('' || 'Event Information Report',
60: cNoWrap => 'TRUE');
61: htp.tableData(htf.bold(v_date_time),
62: cAlign => 'right',
63: cColSpan => '110');
64: htp.tableRowClose;
65: htp.tableClose;

Line 64: htp.tableRowClose;

60: cNoWrap => 'TRUE');
61: htp.tableData(htf.bold(v_date_time),
62: cAlign => 'right',
63: cColSpan => '110');
64: htp.tableRowClose;
65: htp.tableClose;
66: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
67:
68: htp.tableRowOpen( cvalign => 'top' );

Line 65: htp.tableClose;

61: htp.tableData(htf.bold(v_date_time),
62: cAlign => 'right',
63: cColSpan => '110');
64: htp.tableRowClose;
65: htp.tableClose;
66: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
67:
68: htp.tableRowOpen( cvalign => 'top' );
69: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

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

62: cAlign => 'right',
63: cColSpan => '110');
64: htp.tableRowClose;
65: htp.tableClose;
66: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
67:
68: htp.tableRowOpen( cvalign => 'top' );
69: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
70: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

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

64: htp.tableRowClose;
65: htp.tableClose;
66: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
67:
68: htp.tableRowOpen( cvalign => 'top' );
69: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
70: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
71: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
72: htp.tableData( ' ', ccolspan => '6');

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

65: htp.tableClose;
66: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
67:
68: htp.tableRowOpen( cvalign => 'top' );
69: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
70: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
71: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
72: htp.tableData( ' ', ccolspan => '6');
73: htp.Br;

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

66: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
67:
68: htp.tableRowOpen( cvalign => 'top' );
69: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
70: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
71: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
72: htp.tableData( ' ', ccolspan => '6');
73: htp.Br;
74: htp.tableRowClose;

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

68: htp.tableRowOpen( cvalign => 'top' );
69: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
70: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
71: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
72: htp.tableData( ' ', ccolspan => '6');
73: htp.Br;
74: htp.tableRowClose;
75: htp.tableClose;
76: htp.bodyClose;

Line 73: htp.Br;

69: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
70: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
71: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
72: htp.tableData( ' ', ccolspan => '6');
73: htp.Br;
74: htp.tableRowClose;
75: htp.tableClose;
76: htp.bodyClose;
77: htp.headClose;

Line 74: htp.tableRowClose;

70: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
71: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
72: htp.tableData( ' ', ccolspan => '6');
73: htp.Br;
74: htp.tableRowClose;
75: htp.tableClose;
76: htp.bodyClose;
77: htp.headClose;
78: htp.htmlClose;

Line 75: htp.tableClose;

71: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
72: htp.tableData( ' ', ccolspan => '6');
73: htp.Br;
74: htp.tableRowClose;
75: htp.tableClose;
76: htp.bodyClose;
77: htp.headClose;
78: htp.htmlClose;
79: end;

Line 76: htp.bodyClose;

72: htp.tableData( ' ', ccolspan => '6');
73: htp.Br;
74: htp.tableRowClose;
75: htp.tableClose;
76: htp.bodyClose;
77: htp.headClose;
78: htp.htmlClose;
79: end;
80: -----------------------------------------------------------------------------------------------

Line 77: htp.headClose;

73: htp.Br;
74: htp.tableRowClose;
75: htp.tableClose;
76: htp.bodyClose;
77: htp.headClose;
78: htp.htmlClose;
79: end;
80: -----------------------------------------------------------------------------------------------
81: procedure event_information_paramform is

Line 78: htp.htmlClose;

74: htp.tableRowClose;
75: htp.tableClose;
76: htp.bodyClose;
77: htp.headClose;
78: htp.htmlClose;
79: end;
80: -----------------------------------------------------------------------------------------------
81: procedure event_information_paramform is
82:

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

122: header;
123:
124: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
125: -------------------- Returns login user Id--------------------------
126: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_EVENT_INFO_REPORT.report_wrapper', cattributes => ' NAME="param"');
127: htp.htmlopen;
128: htp.headOpen;
129: htp.title('Event Information Report');
130: htp.p('');

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

195: htp.p(' alert(''Start Date must be less than End Date'');');
196: htp.p(' p_valid = false;}');
197: htp.p(' }');
198: htp.p(' }');
199: htp.p(' if (p_valid){');
200: htp.p(' objform.submit();}');
201: htp.p('}');
202: htp.p('');
203: htp.headClose;

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

196: htp.p(' p_valid = false;}');
197: htp.p(' }');
198: htp.p(' }');
199: htp.p(' if (p_valid){');
200: htp.p(' objform.submit();}');
201: htp.p('}');
202: htp.p('');
203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

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

197: htp.p(' }');
198: htp.p(' }');
199: htp.p(' if (p_valid){');
200: htp.p(' objform.submit();}');
201: htp.p('}');
202: htp.p('');
203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;

Line 202: htp.p('');

198: htp.p(' }');
199: htp.p(' if (p_valid){');
200: htp.p(' objform.submit();}');
201: htp.p('}');
202: htp.p('');
203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );

Line 203: htp.headClose;

199: htp.p(' if (p_valid){');
200: htp.p(' objform.submit();}');
201: htp.p('}');
202: htp.p('');
203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');

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

200: htp.p(' objform.submit();}');
201: htp.p('}');
202: htp.p('');
203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

Line 205: htp.tableopen;

201: htp.p('}');
202: htp.p('');
203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');

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

202: htp.p('');
203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');
210: htp.tableRowClose;

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

203: htp.headClose;
204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');
210: htp.tableRowClose;
211: htp.tableClose;

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

204: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');
210: htp.tableRowClose;
211: htp.tableClose;
212: htp.tableOpen(cattributes=>'width="600" ');

Line 209: htp.tableData( ' ');

205: htp.tableopen;
206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');
210: htp.tableRowClose;
211: htp.tableClose;
212: htp.tableOpen(cattributes=>'width="600" ');
213: htp.tableRowClose;

Line 210: htp.tableRowClose;

206: htp.tableRowOpen( cvalign => 'top' );
207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');
210: htp.tableRowClose;
211: htp.tableClose;
212: htp.tableOpen(cattributes=>'width="600" ');
213: htp.tableRowClose;
214:

Line 211: htp.tableClose;

207: htp.tableData( ' ', cattributes => ' height=9');
208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');
210: htp.tableRowClose;
211: htp.tableClose;
212: htp.tableOpen(cattributes=>'width="600" ');
213: htp.tableRowClose;
214:
215: htp.tableRowOpen();

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

208: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
209: htp.tableData( ' ');
210: htp.tableRowClose;
211: htp.tableClose;
212: htp.tableOpen(cattributes=>'width="600" ');
213: htp.tableRowClose;
214:
215: htp.tableRowOpen();
216: htp.p('Start Date');

Line 213: htp.tableRowClose;

209: htp.tableData( ' ');
210: htp.tableRowClose;
211: htp.tableClose;
212: htp.tableOpen(cattributes=>'width="600" ');
213: htp.tableRowClose;
214:
215: htp.tableRowOpen();
216: htp.p('Start Date');
217: htp.p('');

Line 215: htp.tableRowOpen();

211: htp.tableClose;
212: htp.tableOpen(cattributes=>'width="600" ');
213: htp.tableRowClose;
214:
215: htp.tableRowOpen();
216: htp.p('Start Date');
217: htp.p('');
218: htp.p ('');
219: FOR i IN 1..day_data.count LOOP
220: htp.FormSelectOption(day_data(i),

Line 217: htp.p('');

213: htp.tableRowClose;
214:
215: htp.tableRowOpen();
216: htp.p('Start Date');
217: htp.p('');
218: htp.p ('');

214:
215: htp.tableRowOpen();
216: htp.p('Start Date');
217: htp.p('');
218: htp.p ('');
219: FOR i IN 1..day_data.count LOOP
220: htp.FormSelectOption(day_data(i),
221: cattributes => ' value= '||day_data(i),
222: cselected => 'TRUE' );
223: END LOOP;
224: htp.FormSelectClose;

Line 224: htp.FormSelectClose;

220: htp.FormSelectOption(day_data(i),
221: cattributes => ' value= '||day_data(i),
222: cselected => 'TRUE' );
223: END LOOP;
224: htp.FormSelectClose;
225: htp.p('-');
226:
227: htp.p ('');
228: FOR i IN 1..12 LOOP
229: if i=1 then

Line 227: htp.p ('');
228: FOR i IN 1..12 LOOP
229: if i=1 then
230: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
231: cattributes => ' value='||lpad(to_char(i),2,'0'),

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

226:
227: htp.p ('');
242: FOR i IN 1..year_data.count LOOP

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

235: cattributes => ' value='||lpad(to_char(i),2,'0'));
236: end if;
237: END LOOP;
238: htp.FormSelectClose;
239: htp.p('-');
240:
241: htp.p ('');

237: END LOOP;
238: htp.FormSelectClose;
239: htp.p('-');
240:
241: htp.p ('');
242: FOR i IN 1..year_data.count LOOP
243: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
244: htp.FormSelectOption(year_data(i),
245: cattributes => ' value= '||year_data(i),
246: cselected => 'TRUE' );
247: ELSE
248: htp.FormSelectOption(year_data(i),

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

244: htp.FormSelectOption(year_data(i),
245: cattributes => ' value= '||year_data(i),
246: cselected => 'TRUE' );
247: ELSE
248: htp.FormSelectOption(year_data(i),
249: cattributes => ' value= '||year_data(i));
250: END IF;
251: END LOOP;
252: htp.FormSelectClose;

Line 252: htp.FormSelectClose;

248: htp.FormSelectOption(year_data(i),
249: cattributes => ' value= '||year_data(i));
250: END IF;
251: END LOOP;
252: htp.FormSelectClose;
253: htp.p('');
254: htp.tableRowClose;
255:
256: htp.tableRowOpen();

Line 253: htp.p('');

249: cattributes => ' value= '||year_data(i));
250: END IF;
251: END LOOP;
252: htp.FormSelectClose;
253: htp.p('');
254: htp.tableRowClose;
255:
256: htp.tableRowOpen();
257: htp.p('End Date');

Line 254: htp.tableRowClose;

250: END IF;
251: END LOOP;
252: htp.FormSelectClose;
253: htp.p('');
254: htp.tableRowClose;
255:
256: htp.tableRowOpen();
257: htp.p('End Date');
258: htp.p('');

Line 256: htp.tableRowOpen();

252: htp.FormSelectClose;
253: htp.p('');
254: htp.tableRowClose;
255:
256: htp.tableRowOpen();
257: htp.p('End Date');
258: htp.p('');
259: htp.p ('');
260: FOR i IN 1..day_data.count LOOP
261: htp.FormSelectOption(day_data(i),

Line 258: htp.p('');

254: htp.tableRowClose;
255:
256: htp.tableRowOpen();
257: htp.p('End Date');
258: htp.p('');
259: htp.p ('');

255:
256: htp.tableRowOpen();
257: htp.p('End Date');
258: htp.p('');
259: htp.p ('');
260: FOR i IN 1..day_data.count LOOP
261: htp.FormSelectOption(day_data(i),
262: cattributes => ' value= '||day_data(i),
263: cselected => 'TRUE' );
264: END LOOP;
265: htp.FormSelectClose;

Line 265: htp.FormSelectClose;

261: htp.FormSelectOption(day_data(i),
262: cattributes => ' value= '||day_data(i),
263: cselected => 'TRUE' );
264: END LOOP;
265: htp.FormSelectClose;
266: htp.p('-');
267:
268: htp.p ('');
269: FOR i IN 1..12 LOOP
270: if i=1 then

Line 268: htp.p ('');
269: FOR i IN 1..12 LOOP
270: if i=1 then
271: htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
272: cattributes => ' value='||lpad(to_char(i),2,'0'),

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

267:
268: htp.p ('');
283: FOR i IN 1..year_data.count LOOP

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

276: cattributes => ' value='||lpad(to_char(i),2,'0'));
277: end if;
278: END LOOP;
279: htp.FormSelectClose;
280: htp.p('-');
281:
282: htp.p ('');

278: END LOOP;
279: htp.FormSelectClose;
280: htp.p('-');
281:
282: htp.p ('');
283: FOR i IN 1..year_data.count LOOP
284: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
285: htp.FormSelectOption(year_data(i),
286: cattributes => ' value= '||year_data(i),
287: cselected => 'TRUE' );
288: ELSE
289: htp.FormSelectOption(year_data(i),

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

285: htp.FormSelectOption(year_data(i),
286: cattributes => ' value= '||year_data(i),
287: cselected => 'TRUE' );
288: ELSE
289: htp.FormSelectOption(year_data(i),
290: cattributes => ' value= '||year_data(i));
291: END IF;
292: END LOOP;
293: htp.FormSelectClose;

Line 293: htp.FormSelectClose;

289: htp.FormSelectOption(year_data(i),
290: cattributes => ' value= '||year_data(i));
291: END IF;
292: END LOOP;
293: htp.FormSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296:
297: htp.tableRowOpen;

Line 294: htp.p('');

290: cattributes => ' value= '||year_data(i));
291: END IF;
292: END LOOP;
293: htp.FormSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296:
297: htp.tableRowOpen;
298: htp.p('Range of Event Codes:');

Line 295: htp.tableRowClose;

291: END IF;
292: END LOOP;
293: htp.FormSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296:
297: htp.tableRowOpen;
298: htp.p('Range of Event Codes:');
299: htp.tableRowClose;

Line 297: htp.tableRowOpen;

293: htp.FormSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296:
297: htp.tableRowOpen;
298: htp.p('Range of Event Codes:');
299: htp.tableRowClose;
300:
301: htp.tableRowOpen();

Line 298: htp.p('Range of Event Codes:');

294: htp.p('');
295: htp.tableRowClose;
296:
297: htp.tableRowOpen;
298: htp.p('Range of Event Codes:');
299: htp.tableRowClose;
300:
301: htp.tableRowOpen();
302: htp.p('From Event Code');

Line 299: htp.tableRowClose;

295: htp.tableRowClose;
296:
297: htp.tableRowOpen;
298: htp.p('Range of Event Codes:');
299: htp.tableRowClose;
300:
301: htp.tableRowOpen();
302: htp.p('From Event Code');
303: htp.p('');

Line 301: htp.tableRowOpen();

297: htp.tableRowOpen;
298: htp.p('Range of Event Codes:');
299: htp.tableRowClose;
300:
301: htp.tableRowOpen();
302: htp.p('From Event Code');
303: htp.p('');
304:
305: htp.formHidden('p_promotion_code_low',null,null);

Line 302: htp.p('From Event Code');

298: htp.p('Range of Event Codes:');
299: htp.tableRowClose;
300:
301: htp.tableRowOpen();
302: htp.p('From Event Code');
303: htp.p('');
304:
305: htp.formHidden('p_promotion_code_low',null,null);
306: htp.formText('p_low_description',50,null);

Line 303: htp.p('');

299: htp.tableRowClose;
300:
301: htp.tableRowOpen();
302: htp.p('From Event Code');
303: htp.p('');
304:
305: htp.formHidden('p_promotion_code_low',null,null);
306: htp.formText('p_low_description',50,null);
307: htp.p('LOV');

Line 305: htp.formHidden('p_promotion_code_low',null,null);

301: htp.tableRowOpen();
302: htp.p('From Event Code');
303: htp.p('');
304:
305: htp.formHidden('p_promotion_code_low',null,null);
306: htp.formText('p_low_description',50,null);
307: htp.p('LOV');
308: htp.p('');
309: htp.tableRowClose;

Line 306: htp.formText('p_low_description',50,null);

302: htp.p('From Event Code');
303: htp.p('');
304:
305: htp.formHidden('p_promotion_code_low',null,null);
306: htp.formText('p_low_description',50,null);
307: htp.p('LOV');
308: htp.p('');
309: htp.tableRowClose;
310:

Line 307: htp.p('LOV');

303: htp.p('');
304:
305: htp.formHidden('p_promotion_code_low',null,null);
306: htp.formText('p_low_description',50,null);
307: htp.p('LOV');
308: htp.p('');
309: htp.tableRowClose;
310:
311: htp.tableRowOpen();

Line 308: htp.p('');

304:
305: htp.formHidden('p_promotion_code_low',null,null);
306: htp.formText('p_low_description',50,null);
307: htp.p('LOV');
308: htp.p('');
309: htp.tableRowClose;
310:
311: htp.tableRowOpen();
312: htp.p('To Event Code');

Line 309: htp.tableRowClose;

305: htp.formHidden('p_promotion_code_low',null,null);
306: htp.formText('p_low_description',50,null);
307: htp.p('LOV');
308: htp.p('');
309: htp.tableRowClose;
310:
311: htp.tableRowOpen();
312: htp.p('To Event Code');
313: htp.p('');

Line 311: htp.tableRowOpen();

307: htp.p('LOV');
308: htp.p('');
309: htp.tableRowClose;
310:
311: htp.tableRowOpen();
312: htp.p('To Event Code');
313: htp.p('');
314:
315: htp.formHidden('p_promotion_code_high',null,null);

Line 312: htp.p('To Event Code');

308: htp.p('');
309: htp.tableRowClose;
310:
311: htp.tableRowOpen();
312: htp.p('To Event Code');
313: htp.p('');
314:
315: htp.formHidden('p_promotion_code_high',null,null);
316: htp.formText('p_high_description',50,null);

Line 313: htp.p('');

309: htp.tableRowClose;
310:
311: htp.tableRowOpen();
312: htp.p('To Event Code');
313: htp.p('');
314:
315: htp.formHidden('p_promotion_code_high',null,null);
316: htp.formText('p_high_description',50,null);
317: htp.p('LOV');

Line 315: htp.formHidden('p_promotion_code_high',null,null);

311: htp.tableRowOpen();
312: htp.p('To Event Code');
313: htp.p('');
314:
315: htp.formHidden('p_promotion_code_high',null,null);
316: htp.formText('p_high_description',50,null);
317: htp.p('LOV');
318: htp.p('');
319: htp.tableRowClose;

Line 316: htp.formText('p_high_description',50,null);

312: htp.p('To Event Code');
313: htp.p('');
314:
315: htp.formHidden('p_promotion_code_high',null,null);
316: htp.formText('p_high_description',50,null);
317: htp.p('LOV');
318: htp.p('');
319: htp.tableRowClose;
320:

Line 317: htp.p('LOV');

313: htp.p('');
314:
315: htp.formHidden('p_promotion_code_high',null,null);
316: htp.formText('p_high_description',50,null);
317: htp.p('LOV');
318: htp.p('');
319: htp.tableRowClose;
320:
321: htp.tableClose;

Line 318: htp.p('');

314:
315: htp.formHidden('p_promotion_code_high',null,null);
316: htp.formText('p_high_description',50,null);
317: htp.p('LOV');
318: htp.p('');
319: htp.tableRowClose;
320:
321: htp.tableClose;
322: htp.Br;

Line 319: htp.tableRowClose;

315: htp.formHidden('p_promotion_code_high',null,null);
316: htp.formText('p_high_description',50,null);
317: htp.p('LOV');
318: htp.p('');
319: htp.tableRowClose;
320:
321: htp.tableClose;
322: htp.Br;
323: htp.Br;

Line 321: htp.tableClose;

317: htp.p('LOV');
318: htp.p('');
319: htp.tableRowClose;
320:
321: htp.tableClose;
322: htp.Br;
323: htp.Br;
324: htp.Br;
325: footer;

Line 322: htp.Br;

318: htp.p('');
319: htp.tableRowClose;
320:
321: htp.tableClose;
322: htp.Br;
323: htp.Br;
324: htp.Br;
325: footer;
326: htp.FormClose;

Line 323: htp.Br;

319: htp.tableRowClose;
320:
321: htp.tableClose;
322: htp.Br;
323: htp.Br;
324: htp.Br;
325: footer;
326: htp.FormClose;
327: htp.bodyclose;

Line 324: htp.Br;

320:
321: htp.tableClose;
322: htp.Br;
323: htp.Br;
324: htp.Br;
325: footer;
326: htp.FormClose;
327: htp.bodyclose;
328: htp.htmlclose;

Line 326: htp.FormClose;

322: htp.Br;
323: htp.Br;
324: htp.Br;
325: footer;
326: htp.FormClose;
327: htp.bodyclose;
328: htp.htmlclose;
329: else
330: htp.p('Invalid session');

Line 327: htp.bodyclose;

323: htp.Br;
324: htp.Br;
325: footer;
326: htp.FormClose;
327: htp.bodyclose;
328: htp.htmlclose;
329: else
330: htp.p('Invalid session');
331: end if;

Line 328: htp.htmlclose;

324: htp.Br;
325: footer;
326: htp.FormClose;
327: htp.bodyclose;
328: htp.htmlclose;
329: else
330: htp.p('Invalid session');
331: end if;
332: exception

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

326: htp.FormClose;
327: htp.bodyclose;
328: htp.htmlclose;
329: else
330: htp.p('Invalid session');
331: end if;
332: exception
333: when others then
334: htp.p(SQLERRM);

Line 334: htp.p(SQLERRM);

330: htp.p('Invalid session');
331: end if;
332: exception
333: when others then
334: htp.p(SQLERRM);
335: END event_information_paramform;
336:
337: procedure popup_window (p_event_code in varchar2 default null,
338: p_submit in varchar2 default null,

Line 354: htp.htmlOpen;

350: -- and (upper(code) like nvl(upper(p_event_code),'%')||'%' or upper(name) like nvl(upper(p_event_code),'%')||'%')
351: order by 1;
352:
353: BEGIN
354: htp.htmlOpen;
355: htp.headOpen;
356: htp.title('Event Information Report - Event Codes');
357: htp.p('');

373: close();
374:
375: }');
376:
377: htp.p('');
378: htp.headClose;
379: htp.p('');
380: htp.p('

');
381: htp.bold('Search Events');

Line 378: htp.headClose;

374:
375: }');
376:
377: htp.p('');
378: htp.headClose;
379: htp.p('');
380: htp.p('

');
381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');

Line 379: htp.p('');

375: }');
376:
377: htp.p('');
378: htp.headClose;
379: htp.p('');
380: htp.p('

');
381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;

Line 380: htp.p('
');

376:
377: htp.p('');
378: htp.headClose;
379: htp.p('');
380: htp.p('

');
381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;
384: htp.tableRowOpen;

Line 381: htp.bold('Search Events');

377: htp.p('');
378: htp.headClose;
379: htp.p('');
380: htp.p('

');
381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;
384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');

Line 382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');

378: htp.headClose;
379: htp.p('');
380: htp.p('

');
381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;
384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));

Line 383: htp.tableOpen;

379: htp.p('');
380: htp.p('

');
381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;
384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;

Line 384: htp.tableRowOpen;

380: htp.p('

');
381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;
384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;
388: htp.tableClose;

Line 385: htp.tableData('Event Code: ');

381: htp.bold('Search Events');
382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;
384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;
388: htp.tableClose;
389: htp.nl;

Line 386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));

382: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.popup_window','POST');
383: htp.tableOpen;
384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;
388: htp.tableClose;
389: htp.nl;
390: htp.formSubmit('p_submit','Search Events');

Line 387: htp.tableRowClose;

383: htp.tableOpen;
384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;
388: htp.tableClose;
389: htp.nl;
390: htp.formSubmit('p_submit','Search Events');
391: htp.formClose;

Line 388: htp.tableClose;

384: htp.tableRowOpen;
385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;
388: htp.tableClose;
389: htp.nl;
390: htp.formSubmit('p_submit','Search Events');
391: htp.formClose;
392: htp.tableOpen;

Line 389: htp.nl;

385: htp.tableData('Event Code: ');
386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;
388: htp.tableClose;
389: htp.nl;
390: htp.formSubmit('p_submit','Search Events');
391: htp.formClose;
392: htp.tableOpen;
393: if p_event_code is NULL then

Line 390: htp.formSubmit('p_submit','Search Events');

386: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
387: htp.tableRowClose;
388: htp.tableClose;
389: htp.nl;
390: htp.formSubmit('p_submit','Search Events');
391: htp.formClose;
392: htp.tableOpen;
393: if p_event_code is NULL then
394: htp.tableRowOpen;

Line 391: htp.formClose;

387: htp.tableRowClose;
388: htp.tableClose;
389: htp.nl;
390: htp.formSubmit('p_submit','Search Events');
391: htp.formClose;
392: htp.tableOpen;
393: if p_event_code is NULL then
394: htp.tableRowOpen;
395: --htp.p('Enter ''%'' to search for all events.');

Line 392: htp.tableOpen;

388: htp.tableClose;
389: htp.nl;
390: htp.formSubmit('p_submit','Search Events');
391: htp.formClose;
392: htp.tableOpen;
393: if p_event_code is NULL then
394: htp.tableRowOpen;
395: --htp.p('Enter ''%'' to search for all events.');
396: htp.p('Enter the first few characters of the Event Code or Event Name');

Line 394: htp.tableRowOpen;

390: htp.formSubmit('p_submit','Search Events');
391: htp.formClose;
392: htp.tableOpen;
393: if p_event_code is NULL then
394: htp.tableRowOpen;
395: --htp.p('Enter ''%'' to search for all events.');
396: htp.p('Enter the first few characters of the Event Code or Event Name');
397: htp.tableRowClose;
398: htp.tableRowOpen;

Line 395: --htp.p('Enter ''%'' to search for all events.');

391: htp.formClose;
392: htp.tableOpen;
393: if p_event_code is NULL then
394: htp.tableRowOpen;
395: --htp.p('Enter ''%'' to search for all events.');
396: htp.p('Enter the first few characters of the Event Code or Event Name');
397: htp.tableRowClose;
398: htp.tableRowOpen;
399: htp.p('to search by (wildcards such as _ and % are supported)');

Line 396: htp.p('Enter the first few characters of the Event Code or Event Name');

392: htp.tableOpen;
393: if p_event_code is NULL then
394: htp.tableRowOpen;
395: --htp.p('Enter ''%'' to search for all events.');
396: htp.p('Enter the first few characters of the Event Code or Event Name');
397: htp.tableRowClose;
398: htp.tableRowOpen;
399: htp.p('to search by (wildcards such as _ and % are supported)');
400: htp.tableRowClose;

Line 397: htp.tableRowClose;

393: if p_event_code is NULL then
394: htp.tableRowOpen;
395: --htp.p('Enter ''%'' to search for all events.');
396: htp.p('Enter the first few characters of the Event Code or Event Name');
397: htp.tableRowClose;
398: htp.tableRowOpen;
399: htp.p('to search by (wildcards such as _ and % are supported)');
400: htp.tableRowClose;
401: else

Line 398: htp.tableRowOpen;

394: htp.tableRowOpen;
395: --htp.p('Enter ''%'' to search for all events.');
396: htp.p('Enter the first few characters of the Event Code or Event Name');
397: htp.tableRowClose;
398: htp.tableRowOpen;
399: htp.p('to search by (wildcards such as _ and % are supported)');
400: htp.tableRowClose;
401: else
402: for c_rec in cur_promotion_code(p_event_code) loop

Line 399: htp.p('to search by (wildcards such as _ and % are supported)');

395: --htp.p('Enter ''%'' to search for all events.');
396: htp.p('Enter the first few characters of the Event Code or Event Name');
397: htp.tableRowClose;
398: htp.tableRowOpen;
399: htp.p('to search by (wildcards such as _ and % are supported)');
400: htp.tableRowClose;
401: else
402: for c_rec in cur_promotion_code(p_event_code) loop
403: htp.tableRowOpen;

Line 400: htp.tableRowClose;

396: htp.p('Enter the first few characters of the Event Code or Event Name');
397: htp.tableRowClose;
398: htp.tableRowOpen;
399: htp.p('to search by (wildcards such as _ and % are supported)');
400: htp.tableRowClose;
401: else
402: for c_rec in cur_promotion_code(p_event_code) loop
403: htp.tableRowOpen;
404: display_event_name := c_rec.name;

Line 403: htp.tableRowOpen;

399: htp.p('to search by (wildcards such as _ and % are supported)');
400: htp.tableRowClose;
401: else
402: for c_rec in cur_promotion_code(p_event_code) loop
403: htp.tableRowOpen;
404: display_event_name := c_rec.name;
405: -- check for any special characters ..... BJANI (12/03/2001)
406: if instr(c_rec.name,'''') > 0 then
407: -- adding an escape character .... BJANI

Line 411: htp.p(''||c_rec.code||' '||display_event_name||'');

407: -- adding an escape character .... BJANI
408: c_rec.name := REPLACE(c_rec.name,'''','?$');
409: end if;
410: -- BJANI end
411: htp.p(''||c_rec.code||' '||display_event_name||'');
412: htp.tableRowClose;
413: end loop;
414: end if;
415: htp.tableClose;

Line 412: htp.tableRowClose;

408: c_rec.name := REPLACE(c_rec.name,'''','?$');
409: end if;
410: -- BJANI end
411: htp.p(''||c_rec.code||' '||display_event_name||'');
412: htp.tableRowClose;
413: end loop;
414: end if;
415: htp.tableClose;
416: htp.p('

');

Line 415: htp.tableClose;

411: htp.p(''||c_rec.code||' '||display_event_name||'');
412: htp.tableRowClose;
413: end loop;
414: end if;
415: htp.tableClose;
416: htp.p('

');
417: htp.bodyClose;
418: htp.htmlClose;
419: END popup_window;

Line 416: htp.p('
');

412: htp.tableRowClose;
413: end loop;
414: end if;
415: htp.tableClose;
416: htp.p('

');
417: htp.bodyClose;
418: htp.htmlClose;
419: END popup_window;
420:

Line 417: htp.bodyClose;

413: end loop;
414: end if;
415: htp.tableClose;
416: htp.p('

');
417: htp.bodyClose;
418: htp.htmlClose;
419: END popup_window;
420:
421: procedure high_popup_window (p_event_code in varchar2 default null,

Line 418: htp.htmlClose;

414: end if;
415: htp.tableClose;
416: htp.p('

');
417: htp.bodyClose;
418: htp.htmlClose;
419: END popup_window;
420:
421: procedure high_popup_window (p_event_code in varchar2 default null,
422: p_submit in varchar2 default null,

Line 438: htp.htmlOpen;

434: -- and (upper(code) like nvl(upper(Event_Code),'%')||'%' or upper(name) like nvl(upper(Event_Code),'%')||'%')
435: order by 1;
436:
437: BEGIN
438: htp.htmlOpen;
439: htp.headOpen;
440: htp.title('Event Information Report - Event Codes');
441: htp.p('');

458: close();
459:
460: }');
461:
462: htp.p('');
463:
464: htp.headClose;
465: htp.p('');
466: htp.p('

');

Line 464: htp.headClose;

460: }');
461:
462: htp.p('');
463:
464: htp.headClose;
465: htp.p('');
466: htp.p('

');
467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');

Line 465: htp.p('');

461:
462: htp.p('');
463:
464: htp.headClose;
465: htp.p('');
466: htp.p('

');
467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;

Line 466: htp.p('
');

462: htp.p('');
463:
464: htp.headClose;
465: htp.p('');
466: htp.p('

');
467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;
470: htp.tableRowOpen;

Line 467: htp.bold('Search Events');

463:
464: htp.headClose;
465: htp.p('');
466: htp.p('

');
467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;
470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');

Line 468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');

464: htp.headClose;
465: htp.p('');
466: htp.p('

');
467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;
470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));

Line 469: htp.tableOpen;

465: htp.p('');
466: htp.p('

');
467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;
470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;

Line 470: htp.tableRowOpen;

466: htp.p('

');
467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;
470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;
474: htp.tableClose;

Line 471: htp.tableData('Event Code: ');

467: htp.bold('Search Events');
468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;
470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;
474: htp.tableClose;
475: htp.nl;

Line 472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));

468: htp.formOpen('AST_OFL_EVENT_INFO_PARAM.high_popup_window','POST');
469: htp.tableOpen;
470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;
474: htp.tableClose;
475: htp.nl;
476: htp.formSubmit('p_submit','Search Events');

Line 473: htp.tableRowClose;

469: htp.tableOpen;
470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;
474: htp.tableClose;
475: htp.nl;
476: htp.formSubmit('p_submit','Search Events');
477: htp.formClose;

Line 474: htp.tableClose;

470: htp.tableRowOpen;
471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;
474: htp.tableClose;
475: htp.nl;
476: htp.formSubmit('p_submit','Search Events');
477: htp.formClose;
478: htp.tableOpen;

Line 475: htp.nl;

471: htp.tableData('Event Code: ');
472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;
474: htp.tableClose;
475: htp.nl;
476: htp.formSubmit('p_submit','Search Events');
477: htp.formClose;
478: htp.tableOpen;
479: if p_event_code is NULL then

Line 476: htp.formSubmit('p_submit','Search Events');

472: htp.tableData(htf.formText('p_event_code',null,null,nvl(p_event_code,'%')));
473: htp.tableRowClose;
474: htp.tableClose;
475: htp.nl;
476: htp.formSubmit('p_submit','Search Events');
477: htp.formClose;
478: htp.tableOpen;
479: if p_event_code is NULL then
480: htp.tableRowOpen;

Line 477: htp.formClose;

473: htp.tableRowClose;
474: htp.tableClose;
475: htp.nl;
476: htp.formSubmit('p_submit','Search Events');
477: htp.formClose;
478: htp.tableOpen;
479: if p_event_code is NULL then
480: htp.tableRowOpen;
481: --htp.p('Enter ''%'' to search for all events.');

Line 478: htp.tableOpen;

474: htp.tableClose;
475: htp.nl;
476: htp.formSubmit('p_submit','Search Events');
477: htp.formClose;
478: htp.tableOpen;
479: if p_event_code is NULL then
480: htp.tableRowOpen;
481: --htp.p('Enter ''%'' to search for all events.');
482: htp.p('Enter the first few characters of the Event Code or Event Name');

Line 480: htp.tableRowOpen;

476: htp.formSubmit('p_submit','Search Events');
477: htp.formClose;
478: htp.tableOpen;
479: if p_event_code is NULL then
480: htp.tableRowOpen;
481: --htp.p('Enter ''%'' to search for all events.');
482: htp.p('Enter the first few characters of the Event Code or Event Name');
483: htp.tableRowClose;
484: htp.tableRowOpen;

Line 481: --htp.p('Enter ''%'' to search for all events.');

477: htp.formClose;
478: htp.tableOpen;
479: if p_event_code is NULL then
480: htp.tableRowOpen;
481: --htp.p('Enter ''%'' to search for all events.');
482: htp.p('Enter the first few characters of the Event Code or Event Name');
483: htp.tableRowClose;
484: htp.tableRowOpen;
485: htp.p('to search by (wildcards such as _ and % are supported)');

Line 482: htp.p('Enter the first few characters of the Event Code or Event Name');

478: htp.tableOpen;
479: if p_event_code is NULL then
480: htp.tableRowOpen;
481: --htp.p('Enter ''%'' to search for all events.');
482: htp.p('Enter the first few characters of the Event Code or Event Name');
483: htp.tableRowClose;
484: htp.tableRowOpen;
485: htp.p('to search by (wildcards such as _ and % are supported)');
486: htp.tableRowClose;

Line 483: htp.tableRowClose;

479: if p_event_code is NULL then
480: htp.tableRowOpen;
481: --htp.p('Enter ''%'' to search for all events.');
482: htp.p('Enter the first few characters of the Event Code or Event Name');
483: htp.tableRowClose;
484: htp.tableRowOpen;
485: htp.p('to search by (wildcards such as _ and % are supported)');
486: htp.tableRowClose;
487: else

Line 484: htp.tableRowOpen;

480: htp.tableRowOpen;
481: --htp.p('Enter ''%'' to search for all events.');
482: htp.p('Enter the first few characters of the Event Code or Event Name');
483: htp.tableRowClose;
484: htp.tableRowOpen;
485: htp.p('to search by (wildcards such as _ and % are supported)');
486: htp.tableRowClose;
487: else
488: for c_rec in cur_promotion_code(p_event_code) loop

Line 485: htp.p('to search by (wildcards such as _ and % are supported)');

481: --htp.p('Enter ''%'' to search for all events.');
482: htp.p('Enter the first few characters of the Event Code or Event Name');
483: htp.tableRowClose;
484: htp.tableRowOpen;
485: htp.p('to search by (wildcards such as _ and % are supported)');
486: htp.tableRowClose;
487: else
488: for c_rec in cur_promotion_code(p_event_code) loop
489: htp.tableRowOpen;

Line 486: htp.tableRowClose;

482: htp.p('Enter the first few characters of the Event Code or Event Name');
483: htp.tableRowClose;
484: htp.tableRowOpen;
485: htp.p('to search by (wildcards such as _ and % are supported)');
486: htp.tableRowClose;
487: else
488: for c_rec in cur_promotion_code(p_event_code) loop
489: htp.tableRowOpen;
490: display_event_name := c_rec.name;

Line 489: htp.tableRowOpen;

485: htp.p('to search by (wildcards such as _ and % are supported)');
486: htp.tableRowClose;
487: else
488: for c_rec in cur_promotion_code(p_event_code) loop
489: htp.tableRowOpen;
490: display_event_name := c_rec.name;
491: -- check for any special characters ..... BJANI (12/03/2001)
492: if instr(c_rec.name,'''') > 0 then
493: -- adding an escape character .... BJANI

Line 497: htp.p(''||c_rec.code||' '||display_event_name||'');

493: -- adding an escape character .... BJANI
494: c_rec.name := REPLACE(c_rec.name,'''','?$');
495: end if;
496: -- BJANI end
497: htp.p(''||c_rec.code||' '||display_event_name||'');
498: htp.tableRowClose;
499: end loop;
500: end if;
501: htp.tableClose;

Line 498: htp.tableRowClose;

494: c_rec.name := REPLACE(c_rec.name,'''','?$');
495: end if;
496: -- BJANI end
497: htp.p(''||c_rec.code||' '||display_event_name||'');
498: htp.tableRowClose;
499: end loop;
500: end if;
501: htp.tableClose;
502: htp.p('

');

Line 501: htp.tableClose;

497: htp.p(''||c_rec.code||' '||display_event_name||'');
498: htp.tableRowClose;
499: end loop;
500: end if;
501: htp.tableClose;
502: htp.p('

');
503: htp.bodyClose;
504: htp.htmlClose;
505: END high_popup_window;

Line 502: htp.p('
');

498: htp.tableRowClose;
499: end loop;
500: end if;
501: htp.tableClose;
502: htp.p('

');
503: htp.bodyClose;
504: htp.htmlClose;
505: END high_popup_window;
506:

Line 503: htp.bodyClose;

499: end loop;
500: end if;
501: htp.tableClose;
502: htp.p('

');
503: htp.bodyClose;
504: htp.htmlClose;
505: END high_popup_window;
506:
507: procedure footer is

Line 504: htp.htmlClose;

500: end if;
501: htp.tableClose;
502: htp.p('

');
503: htp.bodyClose;
504: htp.htmlClose;
505: END high_popup_window;
506:
507: procedure footer is
508: BEGIN

Line 510: htp.htmlopen;

506:
507: procedure footer is
508: BEGIN
509: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
510: htp.htmlopen;
511: htp.tableRowOpen;
512: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );

Line 511: htp.tableRowOpen;

507: procedure footer is
508: BEGIN
509: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
510: htp.htmlopen;
511: htp.tableRowOpen;
512: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;

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

508: BEGIN
509: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
510: htp.htmlopen;
511: htp.tableRowOpen;
512: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');

Line 513: htp.tableRowClose;

509: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
510: htp.htmlopen;
511: htp.tableRowOpen;
512: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));

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

510: htp.htmlopen;
511: htp.tableRowOpen;
512: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');

Line 515: htp.tableRowOpen;

511: htp.tableRowOpen;
512: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');
519: htp.p('');

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

512: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');
519: htp.p('');
520: htp.p('');

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

513: htp.tableRowClose;
514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');
519: htp.p('');
520: htp.p('');
521: --htp.tableData( '');

Line 518: htp.p('');

514: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');
519: htp.p('');
520: htp.p('');
521: --htp.tableData( '');
522: htp.tableData( '');

Line 519: htp.p('');

515: htp.tableRowOpen;
516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');
519: htp.p('');
520: htp.p('');
521: --htp.tableData( '');
522: htp.tableData( '');
523: htp.tableData( '');

Line 520: htp.p('');

516: htp.formOpen( curl => l_agent||'/AST_OFL_EVENT_INFO_REPORT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');
519: htp.p('');
520: htp.p('');
521: --htp.tableData( '');
522: htp.tableData( '');
523: htp.tableData( '');
524: htp.tableRowClose;

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

517: --htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
518: htp.p('');
519: htp.p('');
520: htp.p('');
521: --htp.tableData( '');
522: htp.tableData( '');
523: htp.tableData( '');
524: htp.tableRowClose;
525: htp.tableClose;

Line 522: htp.tableData( '');

518: htp.p('');
519: htp.p('');
520: htp.p('');
521: --htp.tableData( '');
522: htp.tableData( '');
523: htp.tableData( '');
524: htp.tableRowClose;
525: htp.tableClose;
526: htp.htmlClose;

Line 523: htp.tableData( '');

519: htp.p('');
520: htp.p('');
521: --htp.tableData( '');
522: htp.tableData( '');
523: htp.tableData( '');
524: htp.tableRowClose;
525: htp.tableClose;
526: htp.htmlClose;
527: END footer;

Line 524: htp.tableRowClose;

520: htp.p('');
521: --htp.tableData( '');
522: htp.tableData( '');
523: htp.tableData( '');
524: htp.tableRowClose;
525: htp.tableClose;
526: htp.htmlClose;
527: END footer;
528: END;

Line 525: htp.tableClose;

521: --htp.tableData( '');
522: htp.tableData( '');
523: htp.tableData( '');
524: htp.tableRowClose;
525: htp.tableClose;
526: htp.htmlClose;
527: END footer;
528: END;

Line 526: htp.htmlClose;

522: htp.tableData( '');
523: htp.tableData( '');
524: htp.tableRowClose;
525: htp.tableClose;
526: htp.htmlClose;
527: END footer;
528: END;