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

Line 27: htp.htmlOpen;

23: BEGIN
24: SELECT fnd_date.date_to_chardate(SYSDATE)
25: INTO v_date_time
26: FROM DUAL;
27: htp.htmlOpen;
28: htp.headOpen;
29: htp.title('Event Attendees Information');
30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

Line 28: htp.headOpen;

24: SELECT fnd_date.date_to_chardate(SYSDATE)
25: INTO v_date_time
26: FROM DUAL;
27: htp.htmlOpen;
28: htp.headOpen;
29: htp.title('Event Attendees Information');
30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');

Line 29: htp.title('Event Attendees Information');

25: INTO v_date_time
26: FROM DUAL;
27: htp.htmlOpen;
28: htp.headOpen;
29: htp.title('Event Attendees Information');
30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');

Line 30: htp.headClose;

26: FROM DUAL;
27: htp.htmlOpen;
28: htp.headOpen;
29: htp.title('Event Attendees Information');
30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));

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

27: htp.htmlOpen;
28: htp.headOpen;
29: htp.title('Event Attendees Information');
30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');

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

28: htp.headOpen;
29: htp.title('Event Attendees Information');
30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');

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

29: htp.title('Event Attendees Information');
30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;

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

30: htp.headClose;
31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;
38: htp.tableClose;

Line 35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');

31: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;
38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');

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

32: htp.tableOpen('border="0" ');
33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;
38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');

Line 37: htp.tableRowClose;

33: htp.tableRowOpen(cAlign => 'TOP');
34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;
38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');

Line 38: htp.tableClose;

34: -- htp.tableData(htf.img(cUrl => g_image_prefix || 'oppty.gif'));
35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;
38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');

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

35: htp.tableData('' || 'Event Attendees Report', cNoWrap => 'TRUE');
36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;
38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');

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

36: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
37: htp.tableRowClose;
38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');
44: htp.br;

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

37: htp.tableRowClose;
38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');
44: htp.br;
45: htp.tableRowClose;

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

38: htp.tableClose;
39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');
44: htp.br;
45: htp.tableRowClose;
46: htp.tableClose;

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

39: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');
44: htp.br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;

Line 44: htp.br;

40: htp.tableRowOpen(cVAlign => 'top');
41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');
44: htp.br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;

Line 45: htp.tableRowClose;

41: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');
44: htp.br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;

Line 46: htp.tableClose;

42: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
43: htp.tableData(' ', cColSpan => '6');
44: htp.br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: END;

Line 47: htp.bodyClose;

43: htp.tableData(' ', cColSpan => '6');
44: htp.br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: END;
51: ----------------------------------------------------------------------------------------------------

Line 48: htp.headClose;

44: htp.br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: END;
51: ----------------------------------------------------------------------------------------------------
52: PROCEDURE event_attendees_paramform

Line 49: htp.htmlClose;

45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: END;
51: ----------------------------------------------------------------------------------------------------
52: PROCEDURE event_attendees_paramform
53: IS

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

78: IF (icx_sec.validateSession) THEN
79: header;
80: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
81: --Returns login user Id
82: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_event_attendees_report.report_wrapper', cAttributes => ' NAME="param"');
83: htp.htmlOpen;
84: htp.headOpen;
85: htp.title('Event Attendees Report');
86: htp.p('');

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

148: htp.p(' alert(''Start Date must be less than End Date'');');
149: htp.p(' p_valid = false;}');
150: htp.p(' }');
151: htp.p(' }');
152: htp.p(' if (p_valid){');
153: htp.p(' objform.submit();}');
154: htp.p('}');
155: htp.p('');
156: htp.headClose;

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

149: htp.p(' p_valid = false;}');
150: htp.p(' }');
151: htp.p(' }');
152: htp.p(' if (p_valid){');
153: htp.p(' objform.submit();}');
154: htp.p('}');
155: htp.p('');
156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

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

150: htp.p(' }');
151: htp.p(' }');
152: htp.p(' if (p_valid){');
153: htp.p(' objform.submit();}');
154: htp.p('}');
155: htp.p('');
156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;

Line 155: htp.p('');

151: htp.p(' }');
152: htp.p(' if (p_valid){');
153: htp.p(' objform.submit();}');
154: htp.p('}');
155: htp.p('');
156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');

Line 156: htp.headClose;

152: htp.p(' if (p_valid){');
153: htp.p(' objform.submit();}');
154: htp.p('}');
155: htp.p('');
156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');

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

153: htp.p(' objform.submit();}');
154: htp.p('}');
155: htp.p('');
156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');

Line 158: htp.tableOpen;

154: htp.p('}');
155: htp.p('');
156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');

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

155: htp.p('');
156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');
163: htp.tableRowClose;

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

156: htp.headClose;
157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');
163: htp.tableRowClose;
164: htp.tableClose;

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

157: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');
163: htp.tableRowClose;
164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');

Line 162: htp.tableData(' ');

158: htp.tableOpen;
159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');
163: htp.tableRowClose;
164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();

Line 163: htp.tableRowClose;

159: htp.tableRowOpen(cVAlign => 'top');
160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');
163: htp.tableRowClose;
164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();
167: --htp.p('Start Date');

Line 164: htp.tableClose;

160: htp.tableData(' ', cAttributes => ' height=9');
161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');
163: htp.tableRowClose;
164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();
167: --htp.p('Start Date');
168: --htp.p('');

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

161: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
162: htp.tableData(' ');
163: htp.tableRowClose;
164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();
167: --htp.p('Start Date');
168: --htp.p('');
169: --htp.p('');

Line 166: --htp.tableRowOpen();

162: htp.tableData(' ');
163: htp.tableRowClose;
164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();
167: --htp.p('Start Date');
168: --htp.p('');
169: --htp.p('');
170: --htp.p('');

Line 167: --htp.p('Start Date');

163: htp.tableRowClose;
164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();
167: --htp.p('Start Date');
168: --htp.p('');
169: --htp.p('');
170: --htp.p('');
171: --htp.tableRowClose;

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

164: htp.tableClose;
165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();
167: --htp.p('Start Date');
168: --htp.p('');
169: --htp.p('');
170: --htp.p('');
171: --htp.tableRowClose;
172: htp.tableRowClose;

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

165: htp.tableOpen(cAttributes => 'width="600" ');
166: --htp.tableRowOpen();
167: --htp.p('Start Date');
168: --htp.p('');
169: --htp.p('');
170: --htp.p('');
171: --htp.tableRowClose;
172: htp.tableRowClose;
173: htp.tableRowOpen();

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

166: --htp.tableRowOpen();
167: --htp.p('Start Date');
168: --htp.p('');
169: --htp.p('');
170: --htp.p('');
171: --htp.tableRowClose;
172: htp.tableRowClose;
173: htp.tableRowOpen();
174: htp.p('Start Date');

Line 171: --htp.tableRowClose;

167: --htp.p('Start Date');
168: --htp.p('');
169: --htp.p('');
170: --htp.p('');
171: --htp.tableRowClose;
172: htp.tableRowClose;
173: htp.tableRowOpen();
174: htp.p('Start Date');
175: htp.p('');

Line 172: htp.tableRowClose;

168: --htp.p('');
169: --htp.p('');
170: --htp.p('');
171: --htp.tableRowClose;
172: htp.tableRowClose;
173: htp.tableRowOpen();
174: htp.p('Start Date');
175: htp.p('');
176:

Line 173: htp.tableRowOpen();

169: --htp.p('');
170: --htp.p('');
171: --htp.tableRowClose;
172: htp.tableRowClose;
173: htp.tableRowOpen();
174: htp.p('Start Date');
175: htp.p('');
176:
177: /*

Line 174: htp.p('Start Date');

170: --htp.p('');
171: --htp.tableRowClose;
172: htp.tableRowClose;
173: htp.tableRowOpen();
174: htp.p('Start Date');
175: htp.p('');
176:
177: /*
178: htp.p('');
179: FOR i IN 1..12 LOOP

Line 178: htp.p('');
179: FOR i IN 1..12 LOOP
180: IF i = 1 THEN
181: htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'), cSelected => 'TRUE');
182: ELSE

Line 181: htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'), cSelected => 'TRUE');

177: /*
178: htp.p('');
190: FOR i IN 1..day_data.count LOOP

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

183: htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));
184: END IF;
185: END LOOP;
186: htp.formSelectClose;
187: htp.p('-');
188: */
189: htp.p('');

185: END LOOP;
186: htp.formSelectClose;
187: htp.p('-');
188: */
189: htp.p('');
190: FOR i IN 1..day_data.count LOOP
191: htp.formSelectOption(day_data(i), cAttributes => ' value= ' || day_data(i), cSelected => 'TRUE');
192: END LOOP;
193: htp.FormSelectClose;
194: htp.p('-');
195:

Line 193: htp.FormSelectClose;

189: htp.p('');
197: htp.FormSelectOption('JAN',cselected => 'TRUE');

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

190: FOR i IN 1..day_data.count LOOP
191: htp.formSelectOption(day_data(i), cAttributes => ' value= ' || day_data(i), cSelected => 'TRUE');
192: END LOOP;
193: htp.FormSelectClose;
194: htp.p('-');
195:
196: htp.p('');

192: END LOOP;
193: htp.FormSelectClose;
194: htp.p('-');
195:
196: htp.p('');
197: htp.FormSelectOption('JAN',cselected => 'TRUE');
198: htp.FormSelectOption('FEB');
199: htp.FormSelectOption('MAR');
200: htp.FormSelectOption('APR');
201: htp.FormSelectOption('MAY');

Line 198: htp.FormSelectOption('FEB');

194: htp.p('-');
195:
196: htp.p('');
197: htp.FormSelectOption('JAN',cselected => 'TRUE');
198: htp.FormSelectOption('FEB');
199: htp.FormSelectOption('MAR');
200: htp.FormSelectOption('APR');
201: htp.FormSelectOption('MAY');
202: htp.FormSelectOption('JUN');
203: htp.FormSelectOption('JUL');

Line 200: htp.FormSelectOption('APR');

196: htp.p('');

Line 209: htp.formSelectClose;

205: htp.FormSelectOption('SEP');
206: htp.FormSelectOption('OCT');
207: htp.FormSelectOption('NOV');
208: htp.FormSelectOption('DEC');
209: htp.formSelectClose;
210: htp.p('-');
211:
212: htp.p('');
213: FOR i IN 1..year_data.count LOOP
214: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i));

Line 212: htp.p('');
213: FOR i IN 1..year_data.count LOOP
214: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i));
215: END LOOP;
216: htp.formSelectClose;

Line 214: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i));

210: htp.p('-');
211:
212: htp.p('');
213: FOR i IN 1..year_data.count LOOP
214: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i));
215: END LOOP;
216: htp.formSelectClose;
217: htp.p('');
218: htp.tableRowClose;
219: htp.tableRowOpen();
220: htp.p('End Date');

Line 217: htp.p('');

213: FOR i IN 1..year_data.count LOOP
214: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i));
215: END LOOP;
216: htp.formSelectClose;
217: htp.p('');
218: htp.tableRowClose;
219: htp.tableRowOpen();
220: htp.p('End Date');
221: htp.p('');

Line 218: htp.tableRowClose;

214: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i));
215: END LOOP;
216: htp.formSelectClose;
217: htp.p('');
218: htp.tableRowClose;
219: htp.tableRowOpen();
220: htp.p('End Date');
221: htp.p('');
222: htp.p('');
223: FOR i IN 1..day_data.count LOOP

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

216: htp.formSelectClose;
217: htp.p('');
218: htp.tableRowClose;
219: htp.tableRowOpen();
220: htp.p('End Date');
221: htp.p('');
222: htp.p('');
223: FOR i IN 1..day_data.count LOOP
224: htp.formSelectOption(day_data(i), cAttributes => ' value= '||day_data(i), cSelected => 'TRUE');
225: END LOOP;

Line 222: htp.p('');
223: FOR i IN 1..day_data.count LOOP
224: htp.formSelectOption(day_data(i), cAttributes => ' value= '||day_data(i), cSelected => 'TRUE');
225: END LOOP;
226: htp.formSelectClose;

Line 224: htp.formSelectOption(day_data(i), cAttributes => ' value= '||day_data(i), cSelected => 'TRUE');

220: htp.p('End Date');
221: htp.p('');
222: htp.p('');
223: FOR i IN 1..day_data.count LOOP
224: htp.formSelectOption(day_data(i), cAttributes => ' value= '||day_data(i), cSelected => 'TRUE');
225: END LOOP;
226: htp.formSelectClose;
227: htp.p('-');
228:
229: /*
230: htp.p('');
231: FOR i IN 1..12 LOOP

Line 230: htp.p('');
231: FOR i IN 1..12 LOOP
232: IF i = 1 THEN
233: htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'), cSelected => 'TRUE');
234: ELSE

Line 233: htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'), cSelected => 'TRUE');

229: /*
230: htp.p('');
242: htp.FormSelectOption('JAN',cselected => 'TRUE');

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

235: htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), 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: htp.FormSelectOption('JAN',cselected => 'TRUE');
243: htp.FormSelectOption('FEB');
244: htp.FormSelectOption('MAR');
245: htp.FormSelectOption('APR');
246: htp.FormSelectOption('MAY');

Line 243: htp.FormSelectOption('FEB');

239: htp.p('-');
240: */
241: htp.p('');
242: htp.FormSelectOption('JAN',cselected => 'TRUE');
243: htp.FormSelectOption('FEB');
244: htp.FormSelectOption('MAR');
245: htp.FormSelectOption('APR');
246: htp.FormSelectOption('MAY');
247: htp.FormSelectOption('JUN');
248: htp.FormSelectOption('JUL');

Line 245: htp.FormSelectOption('APR');

241: htp.p('');

Line 254: htp.formSelectClose;

250: htp.FormSelectOption('SEP');
251: htp.FormSelectOption('OCT');
252: htp.FormSelectOption('NOV');
253: htp.FormSelectOption('DEC');
254: htp.formSelectClose;
255: htp.p('-');
256:
257: htp.p('');
258: -- htp.formSelectOption(' ');
259: FOR i IN 1..year_data.count LOOP

Line 257: htp.p('');
258: -- htp.formSelectOption(' ');
259: FOR i IN 1..year_data.count LOOP
260: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i), cSelected => 'TRUE');
261: END LOOP;

Line 258: -- htp.formSelectOption(' ');

254: htp.formSelectClose;
255: htp.p('-');
256:
257: htp.p('');
258: -- htp.formSelectOption(' ');
259: FOR i IN 1..year_data.count LOOP
260: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i), cSelected => 'TRUE');
261: END LOOP;
262: htp.formSelectClose;
263: htp.p('');
264: htp.tableRowClose;

Line 262: htp.formSelectClose;

258: -- htp.formSelectOption(' ');
259: FOR i IN 1..year_data.count LOOP
260: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i), cSelected => 'TRUE');
261: END LOOP;
262: htp.formSelectClose;
263: htp.p('');
264: htp.tableRowClose;
265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');

Line 263: htp.p('');

259: FOR i IN 1..year_data.count LOOP
260: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i), cSelected => 'TRUE');
261: END LOOP;
262: htp.formSelectClose;
263: htp.p('');
264: htp.tableRowClose;
265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;

Line 264: htp.tableRowClose;

260: htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i), cSelected => 'TRUE');
261: END LOOP;
262: htp.formSelectClose;
263: htp.p('');
264: htp.tableRowClose;
265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;
268: htp.tableRowOpen();

Line 265: htp.tableRowOpen;

261: END LOOP;
262: htp.formSelectClose;
263: htp.p('');
264: htp.tableRowClose;
265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;
268: htp.tableRowOpen();
269: htp.p('From Event Code');

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

262: htp.formSelectClose;
263: htp.p('');
264: htp.tableRowClose;
265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;
268: htp.tableRowOpen();
269: htp.p('From Event Code');
270: htp.p('');

Line 267: htp.tableRowClose;

263: htp.p('');
264: htp.tableRowClose;
265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;
268: htp.tableRowOpen();
269: htp.p('From Event Code');
270: htp.p('');
271: htp.formHidden('p_promotion_code_low', NULL, NULL);

Line 268: htp.tableRowOpen();

264: htp.tableRowClose;
265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;
268: htp.tableRowOpen();
269: htp.p('From Event Code');
270: htp.p('');
271: htp.formHidden('p_promotion_code_low', NULL, NULL);
272: htp.formText('p_low_description', 50, NULL);

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

265: htp.tableRowOpen;
266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;
268: htp.tableRowOpen();
269: htp.p('From Event Code');
270: htp.p('');
271: htp.formHidden('p_promotion_code_low', NULL, NULL);
272: htp.formText('p_low_description', 50, NULL);
273: htp.p('LOV');

Line 270: htp.p('');

266: htp.p('Range of Event Codes:');
267: htp.tableRowClose;
268: htp.tableRowOpen();
269: htp.p('From Event Code');
270: htp.p('');
271: htp.formHidden('p_promotion_code_low', NULL, NULL);
272: htp.formText('p_low_description', 50, NULL);
273: htp.p('LOV');
274: --htp.p('');
275: --htp.formSelectOption('0', cSelected => 'TRUE');

Line 272: htp.formText('p_low_description', 50, NULL);

268: htp.tableRowOpen();
269: htp.p('From Event Code');
270: htp.p('');
271: htp.formHidden('p_promotion_code_low', NULL, NULL);
272: htp.formText('p_low_description', 50, NULL);
273: htp.p('LOV');
274: --htp.p('');
275: --htp.formSelectOption('0', cSelected => 'TRUE');
276: --FOR rec_promotion_code IN cur_promotion_code LOOP
277: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name, cAttributes => ' value= ' || rec_promotion_code.code);

Line 274: --htp.p('');
275: --htp.formSelectOption('0', cSelected => 'TRUE');
276: --FOR rec_promotion_code IN cur_promotion_code LOOP
277: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name, cAttributes => ' value= ' || rec_promotion_code.code);
278: --END LOOP;

Line 275: --htp.formSelectOption('0', cSelected => 'TRUE');

271: htp.formHidden('p_promotion_code_low', NULL, NULL);
272: htp.formText('p_low_description', 50, NULL);
273: htp.p('LOV');
274: --htp.p('');
275: --htp.formSelectOption('0', cSelected => 'TRUE');
276: --FOR rec_promotion_code IN cur_promotion_code LOOP
277: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name, cAttributes => ' value= ' || rec_promotion_code.code);
278: --END LOOP;
279: --htp.formSelectClose;
280: htp.p('');
281: htp.tableRowClose;

Line 279: --htp.formSelectClose;

275: --htp.formSelectOption('0', cSelected => 'TRUE');
276: --FOR rec_promotion_code IN cur_promotion_code LOOP
277: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name, cAttributes => ' value= ' || rec_promotion_code.code);
278: --END LOOP;
279: --htp.formSelectClose;
280: htp.p('');
281: htp.tableRowClose;
282: htp.tableRowOpen();
283: htp.p('To Event Code');

Line 280: htp.p('');

276: --FOR rec_promotion_code IN cur_promotion_code LOOP
277: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name, cAttributes => ' value= ' || rec_promotion_code.code);
278: --END LOOP;
279: --htp.formSelectClose;
280: htp.p('');
281: htp.tableRowClose;
282: htp.tableRowOpen();
283: htp.p('To Event Code');
284: htp.p('');

Line 281: htp.tableRowClose;

277: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name, cAttributes => ' value= ' || rec_promotion_code.code);
278: --END LOOP;
279: --htp.formSelectClose;
280: htp.p('');
281: htp.tableRowClose;
282: htp.tableRowOpen();
283: htp.p('To Event Code');
284: htp.p('');
285: htp.formHidden('p_promotion_code_high', NULL, NULL);

Line 282: htp.tableRowOpen();

278: --END LOOP;
279: --htp.formSelectClose;
280: htp.p('');
281: htp.tableRowClose;
282: htp.tableRowOpen();
283: htp.p('To Event Code');
284: htp.p('');
285: htp.formHidden('p_promotion_code_high', NULL, NULL);
286: htp.formText('p_high_description', 50, NULL);

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

279: --htp.formSelectClose;
280: htp.p('');
281: htp.tableRowClose;
282: htp.tableRowOpen();
283: htp.p('To Event Code');
284: htp.p('');
285: htp.formHidden('p_promotion_code_high', NULL, NULL);
286: htp.formText('p_high_description', 50, NULL);
287: htp.p('LOV');

Line 284: htp.p('');

280: htp.p('');
281: htp.tableRowClose;
282: htp.tableRowOpen();
283: htp.p('To Event Code');
284: htp.p('');
285: htp.formHidden('p_promotion_code_high', NULL, NULL);
286: htp.formText('p_high_description', 50, NULL);
287: htp.p('LOV');
288: --htp.p('');
289: --htp.formSelectOption('9999999', cSelected => 'TRUE');

Line 286: htp.formText('p_high_description', 50, NULL);

282: htp.tableRowOpen();
283: htp.p('To Event Code');
284: htp.p('');
285: htp.formHidden('p_promotion_code_high', NULL, NULL);
286: htp.formText('p_high_description', 50, NULL);
287: htp.p('LOV');
288: --htp.p('');
289: --htp.formSelectOption('9999999', cSelected => 'TRUE');
290: --FOR rec_promotion_code IN cur_promotion_code LOOP
291: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name ,cAttributes => ' value= ' || rec_promotion_code.code);

Line 288: --htp.p('');
289: --htp.formSelectOption('9999999', cSelected => 'TRUE');
290: --FOR rec_promotion_code IN cur_promotion_code LOOP
291: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name ,cAttributes => ' value= ' || rec_promotion_code.code);
292: --END LOOP;

Line 289: --htp.formSelectOption('9999999', cSelected => 'TRUE');

285: htp.formHidden('p_promotion_code_high', NULL, NULL);
286: htp.formText('p_high_description', 50, NULL);
287: htp.p('LOV');
288: --htp.p('');
289: --htp.formSelectOption('9999999', cSelected => 'TRUE');
290: --FOR rec_promotion_code IN cur_promotion_code LOOP
291: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name ,cAttributes => ' value= ' || rec_promotion_code.code);
292: --END LOOP;
293: --htp.formSelectClose;
294: htp.p('');
295: htp.tableRowClose;

Line 293: --htp.formSelectClose;

289: --htp.formSelectOption('9999999', cSelected => 'TRUE');
290: --FOR rec_promotion_code IN cur_promotion_code LOOP
291: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name ,cAttributes => ' value= ' || rec_promotion_code.code);
292: --END LOOP;
293: --htp.formSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296: htp.tableClose;
297: htp.br;

Line 294: htp.p('');

290: --FOR rec_promotion_code IN cur_promotion_code LOOP
291: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name ,cAttributes => ' value= ' || rec_promotion_code.code);
292: --END LOOP;
293: --htp.formSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296: htp.tableClose;
297: htp.br;
298: htp.br;

Line 295: htp.tableRowClose;

291: --htp.formSelectOption(rec_promotion_code.code || ' ' || rec_promotion_code.name ,cAttributes => ' value= ' || rec_promotion_code.code);
292: --END LOOP;
293: --htp.formSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296: htp.tableClose;
297: htp.br;
298: htp.br;
299: htp.br;

Line 296: htp.tableClose;

292: --END LOOP;
293: --htp.formSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296: htp.tableClose;
297: htp.br;
298: htp.br;
299: htp.br;
300: footer;

Line 297: htp.br;

293: --htp.formSelectClose;
294: htp.p('');
295: htp.tableRowClose;
296: htp.tableClose;
297: htp.br;
298: htp.br;
299: htp.br;
300: footer;
301: htp.formClose;

Line 298: htp.br;

294: htp.p('');
295: htp.tableRowClose;
296: htp.tableClose;
297: htp.br;
298: htp.br;
299: htp.br;
300: footer;
301: htp.formClose;
302: htp.bodyClose;

Line 299: htp.br;

295: htp.tableRowClose;
296: htp.tableClose;
297: htp.br;
298: htp.br;
299: htp.br;
300: footer;
301: htp.formClose;
302: htp.bodyClose;
303: htp.htmlClose;

Line 301: htp.formClose;

297: htp.br;
298: htp.br;
299: htp.br;
300: footer;
301: htp.formClose;
302: htp.bodyClose;
303: htp.htmlClose;
304: ELSE
305: htp.p('Invalid session');

Line 302: htp.bodyClose;

298: htp.br;
299: htp.br;
300: footer;
301: htp.formClose;
302: htp.bodyClose;
303: htp.htmlClose;
304: ELSE
305: htp.p('Invalid session');
306: END IF;

Line 303: htp.htmlClose;

299: htp.br;
300: footer;
301: htp.formClose;
302: htp.bodyClose;
303: htp.htmlClose;
304: ELSE
305: htp.p('Invalid session');
306: END IF;
307: EXCEPTION

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

301: htp.formClose;
302: htp.bodyClose;
303: htp.htmlClose;
304: ELSE
305: htp.p('Invalid session');
306: END IF;
307: EXCEPTION
308: WHEN others THEN
309: htp.p(SQLERRM);

Line 309: htp.p(SQLERRM);

305: htp.p('Invalid session');
306: END IF;
307: EXCEPTION
308: WHEN others THEN
309: htp.p(SQLERRM);
310: END event_attendees_paramform;
311: ----------------------------------------------------------------------------------------------------
312: PROCEDURE popup_window
313: (p_event_code IN VARCHAR2 DEFAULT NULL,

Line 331: htp.htmlOpen;

327: -- AND (UPPER(CODE) LIKE NVL(UPPER(p_event_code), '%') || '%'
328: -- OR UPPER(name) LIKE NVL(UPPER(p_event_code), '%') || '%')
329: ORDER BY 1;
330: BEGIN
331: htp.htmlOpen;
332: htp.headOpen;
333: htp.title('Event Attendees Report - Event Codes');
334: htp.p('');

Line 338: htp.p('opener.document.forms[0].p_low_description.focus();');

334: htp.p('');
342: htp.headClose;

Line 339: htp.p('close();');

335: htp.p('function PassBack(p_low_description,p_promotion_code_low) {');
336: htp.p('opener.document.forms[0].p_low_description.value = p_low_description;');
337: htp.p('opener.document.forms[0].p_promotion_code_low.value = p_promotion_code_low;');
338: htp.p('opener.document.forms[0].p_low_description.focus();');
339: htp.p('close();');
340: htp.p('}');
341: htp.p('');
342: htp.headClose;
343: htp.p('');

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

336: htp.p('opener.document.forms[0].p_low_description.value = p_low_description;');
337: htp.p('opener.document.forms[0].p_promotion_code_low.value = p_promotion_code_low;');
338: htp.p('opener.document.forms[0].p_low_description.focus();');
339: htp.p('close();');
340: htp.p('}');
341: htp.p('');
342: htp.headClose;
343: htp.p('');
344: htp.p('

');

Line 341: htp.p('');

337: htp.p('opener.document.forms[0].p_promotion_code_low.value = p_promotion_code_low;');
338: htp.p('opener.document.forms[0].p_low_description.focus();');
339: htp.p('close();');
340: htp.p('}');
341: htp.p('');
342: htp.headClose;
343: htp.p('');
344: htp.p('

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

Line 342: htp.headClose;

338: htp.p('opener.document.forms[0].p_low_description.focus();');
339: htp.p('close();');
340: htp.p('}');
341: htp.p('');
342: htp.headClose;
343: htp.p('');
344: htp.p('

');
345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');

Line 343: htp.p('');

339: htp.p('close();');
340: htp.p('}');
341: htp.p('');
342: htp.headClose;
343: htp.p('');
344: htp.p('

');
345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;

Line 344: htp.p('');

340: htp.p('}');
341: htp.p('');
342: htp.headClose;
343: htp.p('');
344: htp.p('

');
345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;
348: htp.tableRowOpen;

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

341: htp.p('');
342: htp.headClose;
343: htp.p('');
344: htp.p('

');
345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;
348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');

Line 346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');

342: htp.headClose;
343: htp.p('');
344: htp.p('

');
345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;
348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));

Line 347: htp.tableOpen;

343: htp.p('');
344: htp.p('

');
345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;
348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));

Line 348: htp.tableRowOpen;

344: htp.p('

');
345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;
348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;

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

345: htp.bold('Search Events');
346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;
348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;
353: htp.tableClose;

Line 350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));

346: htp.formOpen('ast_ofl_event_attendees_param.popup_window', 'POST');
347: htp.tableOpen;
348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.nl;

Line 351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));

347: htp.tableOpen;
348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.nl;
355: htp.formSubmit('p_submit', 'Search Events');

Line 352: htp.tableRowClose;

348: htp.tableRowOpen;
349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.nl;
355: htp.formSubmit('p_submit', 'Search Events');
356: htp.formClose;

Line 353: htp.tableClose;

349: htp.tableData('Event Code: ');
350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.nl;
355: htp.formSubmit('p_submit', 'Search Events');
356: htp.formClose;
357: htp.tableOpen;

Line 354: htp.nl;

350: -- htp.tableData(htf.formText('p_event_code', NULL, NULL, NVL(p_event_code, '%')));
351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.nl;
355: htp.formSubmit('p_submit', 'Search Events');
356: htp.formClose;
357: htp.tableOpen;
358: if p_event_code is NULL then

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

351: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.nl;
355: htp.formSubmit('p_submit', 'Search Events');
356: htp.formClose;
357: htp.tableOpen;
358: if p_event_code is NULL then
359: htp.tableRowOpen;

Line 356: htp.formClose;

352: htp.tableRowClose;
353: htp.tableClose;
354: htp.nl;
355: htp.formSubmit('p_submit', 'Search Events');
356: htp.formClose;
357: htp.tableOpen;
358: if p_event_code is NULL then
359: htp.tableRowOpen;
360: --htp.p('Enter ''%'' to search for all events.');

Line 357: htp.tableOpen;

353: htp.tableClose;
354: htp.nl;
355: htp.formSubmit('p_submit', 'Search Events');
356: htp.formClose;
357: htp.tableOpen;
358: if p_event_code is NULL then
359: htp.tableRowOpen;
360: --htp.p('Enter ''%'' to search for all events.');
361: htp.p('Enter the first few characters of the Event Code or Event Name');

Line 359: htp.tableRowOpen;

355: htp.formSubmit('p_submit', 'Search Events');
356: htp.formClose;
357: htp.tableOpen;
358: if p_event_code is NULL then
359: htp.tableRowOpen;
360: --htp.p('Enter ''%'' to search for all events.');
361: htp.p('Enter the first few characters of the Event Code or Event Name');
362: htp.tableRowClose;
363: htp.tableRowOpen;

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

356: htp.formClose;
357: htp.tableOpen;
358: if p_event_code is NULL then
359: htp.tableRowOpen;
360: --htp.p('Enter ''%'' to search for all events.');
361: htp.p('Enter the first few characters of the Event Code or Event Name');
362: htp.tableRowClose;
363: htp.tableRowOpen;
364: htp.p('to search by (wildcards such as _ and % are supported)');

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

357: htp.tableOpen;
358: if p_event_code is NULL then
359: htp.tableRowOpen;
360: --htp.p('Enter ''%'' to search for all events.');
361: htp.p('Enter the first few characters of the Event Code or Event Name');
362: htp.tableRowClose;
363: htp.tableRowOpen;
364: htp.p('to search by (wildcards such as _ and % are supported)');
365: htp.tableRowClose;

Line 362: htp.tableRowClose;

358: if p_event_code is NULL then
359: htp.tableRowOpen;
360: --htp.p('Enter ''%'' to search for all events.');
361: htp.p('Enter the first few characters of the Event Code or Event Name');
362: htp.tableRowClose;
363: htp.tableRowOpen;
364: htp.p('to search by (wildcards such as _ and % are supported)');
365: htp.tableRowClose;
366: else

Line 363: htp.tableRowOpen;

359: htp.tableRowOpen;
360: --htp.p('Enter ''%'' to search for all events.');
361: htp.p('Enter the first few characters of the Event Code or Event Name');
362: htp.tableRowClose;
363: htp.tableRowOpen;
364: htp.p('to search by (wildcards such as _ and % are supported)');
365: htp.tableRowClose;
366: else
367: -- FOR c_rec IN cur_promotion_code(nvl(p_event_code,'') || '%') LOOP

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

360: --htp.p('Enter ''%'' to search for all events.');
361: htp.p('Enter the first few characters of the Event Code or Event Name');
362: htp.tableRowClose;
363: htp.tableRowOpen;
364: htp.p('to search by (wildcards such as _ and % are supported)');
365: htp.tableRowClose;
366: else
367: -- FOR c_rec IN cur_promotion_code(nvl(p_event_code,'') || '%') LOOP
368: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP

Line 365: htp.tableRowClose;

361: htp.p('Enter the first few characters of the Event Code or Event Name');
362: htp.tableRowClose;
363: htp.tableRowOpen;
364: htp.p('to search by (wildcards such as _ and % are supported)');
365: htp.tableRowClose;
366: else
367: -- FOR c_rec IN cur_promotion_code(nvl(p_event_code,'') || '%') LOOP
368: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
369: htp.tableRowOpen;

Line 369: htp.tableRowOpen;

365: htp.tableRowClose;
366: else
367: -- FOR c_rec IN cur_promotion_code(nvl(p_event_code,'') || '%') LOOP
368: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
369: htp.tableRowOpen;
370: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
371: htp.tableRowClose;
372: END LOOP;
373: end if;

Line 370: htp.p('' || c_rec.code || ' ' || c_rec.name || '');

366: else
367: -- FOR c_rec IN cur_promotion_code(nvl(p_event_code,'') || '%') LOOP
368: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
369: htp.tableRowOpen;
370: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
371: htp.tableRowClose;
372: END LOOP;
373: end if;
374: htp.tableClose;

Line 371: htp.tableRowClose;

367: -- FOR c_rec IN cur_promotion_code(nvl(p_event_code,'') || '%') LOOP
368: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
369: htp.tableRowOpen;
370: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
371: htp.tableRowClose;
372: END LOOP;
373: end if;
374: htp.tableClose;
375: htp.p('

');

Line 374: htp.tableClose;

370: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
371: htp.tableRowClose;
372: END LOOP;
373: end if;
374: htp.tableClose;
375: htp.p('

');
376: htp.bodyClose;
377: htp.htmlClose;
378: END popup_window;

Line 375: htp.p('

');

371: htp.tableRowClose;
372: END LOOP;
373: end if;
374: htp.tableClose;
375: htp.p('

');
376: htp.bodyClose;
377: htp.htmlClose;
378: END popup_window;
379: ----------------------------------------------------------------------------------------------------

Line 376: htp.bodyClose;

372: END LOOP;
373: end if;
374: htp.tableClose;
375: htp.p('

');
376: htp.bodyClose;
377: htp.htmlClose;
378: END popup_window;
379: ----------------------------------------------------------------------------------------------------
380: PROCEDURE high_popup_window

Line 377: htp.htmlClose;

373: end if;
374: htp.tableClose;
375: htp.p('

');
376: htp.bodyClose;
377: htp.htmlClose;
378: END popup_window;
379: ----------------------------------------------------------------------------------------------------
380: PROCEDURE high_popup_window
381: (p_event_code IN VARCHAR2 DEFAULT NULL,

Line 399: htp.htmlOpen;

395: -- AND (UPPER(code) LIKE NVL(UPPER(p_event_code), '%') || '%'
396: -- OR UPPER(name) LIKE NVL(UPPER(p_event_code), '%') || '%')
397: ORDER BY 1;
398: BEGIN
399: htp.htmlOpen;
400: htp.headOpen;
401: htp.title('Event Attendees Report - Event Codes');
402: htp.p('');

Line 406: htp.p('opener.document.forms[0].p_high_description.focus();');

402: htp.p('');
410: htp.headClose;

Line 407: htp.p('close();');

403: htp.p('function PassBack(p_high_description,p_promotion_code_high) {');
404: htp.p('opener.document.forms[0].p_high_description.value = p_high_description;');
405: htp.p('opener.document.forms[0].p_promotion_code_high.value = p_promotion_code_high;');
406: htp.p('opener.document.forms[0].p_high_description.focus();');
407: htp.p('close();');
408: htp.p('}');
409: htp.p('');
410: htp.headClose;
411: htp.p('');

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

404: htp.p('opener.document.forms[0].p_high_description.value = p_high_description;');
405: htp.p('opener.document.forms[0].p_promotion_code_high.value = p_promotion_code_high;');
406: htp.p('opener.document.forms[0].p_high_description.focus();');
407: htp.p('close();');
408: htp.p('}');
409: htp.p('');
410: htp.headClose;
411: htp.p('');
412: htp.p('

');

Line 409: htp.p('');

405: htp.p('opener.document.forms[0].p_promotion_code_high.value = p_promotion_code_high;');
406: htp.p('opener.document.forms[0].p_high_description.focus();');
407: htp.p('close();');
408: htp.p('}');
409: htp.p('');
410: htp.headClose;
411: htp.p('');
412: htp.p('

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

Line 410: htp.headClose;

406: htp.p('opener.document.forms[0].p_high_description.focus();');
407: htp.p('close();');
408: htp.p('}');
409: htp.p('');
410: htp.headClose;
411: htp.p('');
412: htp.p('

');
413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');

Line 411: htp.p('');

407: htp.p('close();');
408: htp.p('}');
409: htp.p('');
410: htp.headClose;
411: htp.p('');
412: htp.p('

');
413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;

Line 412: htp.p('');

408: htp.p('}');
409: htp.p('');
410: htp.headClose;
411: htp.p('');
412: htp.p('

');
413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;
416: htp.tableRowOpen;

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

409: htp.p('');
410: htp.headClose;
411: htp.p('');
412: htp.p('

');
413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;
416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');

Line 414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');

410: htp.headClose;
411: htp.p('');
412: htp.p('

');
413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;
416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));

Line 415: htp.tableOpen;

411: htp.p('');
412: htp.p('

');
413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;
416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;

Line 416: htp.tableRowOpen;

412: htp.p('

');
413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;
416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;
420: htp.tableClose;

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

413: htp.bold('Search Events');
414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;
416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;
420: htp.tableClose;
421: htp.nl;

Line 418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));

414: htp.formOpen('ast_ofl_event_attendees_param.high_popup_window', 'POST');
415: htp.tableOpen;
416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;
420: htp.tableClose;
421: htp.nl;
422: htp.formSubmit('p_submit', 'Search Events');

Line 419: htp.tableRowClose;

415: htp.tableOpen;
416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;
420: htp.tableClose;
421: htp.nl;
422: htp.formSubmit('p_submit', 'Search Events');
423: htp.formClose;

Line 420: htp.tableClose;

416: htp.tableRowOpen;
417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;
420: htp.tableClose;
421: htp.nl;
422: htp.formSubmit('p_submit', 'Search Events');
423: htp.formClose;
424: htp.tableOpen;

Line 421: htp.nl;

417: htp.tableData('Event Code: ');
418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;
420: htp.tableClose;
421: htp.nl;
422: htp.formSubmit('p_submit', 'Search Events');
423: htp.formClose;
424: htp.tableOpen;
425: if p_event_code is NULL then

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

418: htp.tableData(htf.formText('p_event_code', NULL, NULL, p_event_code));
419: htp.tableRowClose;
420: htp.tableClose;
421: htp.nl;
422: htp.formSubmit('p_submit', 'Search Events');
423: htp.formClose;
424: htp.tableOpen;
425: if p_event_code is NULL then
426: htp.tableRowOpen;

Line 423: htp.formClose;

419: htp.tableRowClose;
420: htp.tableClose;
421: htp.nl;
422: htp.formSubmit('p_submit', 'Search Events');
423: htp.formClose;
424: htp.tableOpen;
425: if p_event_code is NULL then
426: htp.tableRowOpen;
427: --htp.p('Enter ''%'' to search for all events.');

Line 424: htp.tableOpen;

420: htp.tableClose;
421: htp.nl;
422: htp.formSubmit('p_submit', 'Search Events');
423: htp.formClose;
424: htp.tableOpen;
425: if p_event_code is NULL then
426: htp.tableRowOpen;
427: --htp.p('Enter ''%'' to search for all events.');
428: htp.p('Enter the first few characters of the Event Code or Event Name');

Line 426: htp.tableRowOpen;

422: htp.formSubmit('p_submit', 'Search Events');
423: htp.formClose;
424: htp.tableOpen;
425: if p_event_code is NULL then
426: htp.tableRowOpen;
427: --htp.p('Enter ''%'' to search for all events.');
428: htp.p('Enter the first few characters of the Event Code or Event Name');
429: htp.tableRowClose;
430: htp.tableRowOpen;

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

423: htp.formClose;
424: htp.tableOpen;
425: if p_event_code is NULL then
426: htp.tableRowOpen;
427: --htp.p('Enter ''%'' to search for all events.');
428: htp.p('Enter the first few characters of the Event Code or Event Name');
429: htp.tableRowClose;
430: htp.tableRowOpen;
431: htp.p('to search by (wildcards such as _ and % are supported)');

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

424: htp.tableOpen;
425: if p_event_code is NULL then
426: htp.tableRowOpen;
427: --htp.p('Enter ''%'' to search for all events.');
428: htp.p('Enter the first few characters of the Event Code or Event Name');
429: htp.tableRowClose;
430: htp.tableRowOpen;
431: htp.p('to search by (wildcards such as _ and % are supported)');
432: htp.tableRowClose;

Line 429: htp.tableRowClose;

425: if p_event_code is NULL then
426: htp.tableRowOpen;
427: --htp.p('Enter ''%'' to search for all events.');
428: htp.p('Enter the first few characters of the Event Code or Event Name');
429: htp.tableRowClose;
430: htp.tableRowOpen;
431: htp.p('to search by (wildcards such as _ and % are supported)');
432: htp.tableRowClose;
433: else

Line 430: htp.tableRowOpen;

426: htp.tableRowOpen;
427: --htp.p('Enter ''%'' to search for all events.');
428: htp.p('Enter the first few characters of the Event Code or Event Name');
429: htp.tableRowClose;
430: htp.tableRowOpen;
431: htp.p('to search by (wildcards such as _ and % are supported)');
432: htp.tableRowClose;
433: else
434: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP

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

427: --htp.p('Enter ''%'' to search for all events.');
428: htp.p('Enter the first few characters of the Event Code or Event Name');
429: htp.tableRowClose;
430: htp.tableRowOpen;
431: htp.p('to search by (wildcards such as _ and % are supported)');
432: htp.tableRowClose;
433: else
434: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
435: htp.tableRowOpen;

Line 432: htp.tableRowClose;

428: htp.p('Enter the first few characters of the Event Code or Event Name');
429: htp.tableRowClose;
430: htp.tableRowOpen;
431: htp.p('to search by (wildcards such as _ and % are supported)');
432: htp.tableRowClose;
433: else
434: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
435: htp.tableRowOpen;
436: htp.p('' || c_rec.code || ' ' || c_rec.name || '');

Line 435: htp.tableRowOpen;

431: htp.p('to search by (wildcards such as _ and % are supported)');
432: htp.tableRowClose;
433: else
434: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
435: htp.tableRowOpen;
436: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
437: htp.tableRowClose;
438: END LOOP;
439: end if;

Line 436: htp.p('' || c_rec.code || ' ' || c_rec.name || '');

432: htp.tableRowClose;
433: else
434: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
435: htp.tableRowOpen;
436: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
437: htp.tableRowClose;
438: END LOOP;
439: end if;
440: htp.tableClose;

Line 437: htp.tableRowClose;

433: else
434: FOR c_rec IN cur_promotion_code(upper(p_event_code) || '%') LOOP
435: htp.tableRowOpen;
436: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
437: htp.tableRowClose;
438: END LOOP;
439: end if;
440: htp.tableClose;
441: htp.p('

');

Line 440: htp.tableClose;

436: htp.p('' || c_rec.code || ' ' || c_rec.name || '');
437: htp.tableRowClose;
438: END LOOP;
439: end if;
440: htp.tableClose;
441: htp.p('

');
442: htp.bodyClose;
443: htp.htmlClose;
444: END high_popup_window;

Line 441: htp.p('

');

437: htp.tableRowClose;
438: END LOOP;
439: end if;
440: htp.tableClose;
441: htp.p('

');
442: htp.bodyClose;
443: htp.htmlClose;
444: END high_popup_window;
445: ----------------------------------------------------------------------------------------------------

Line 442: htp.bodyClose;

438: END LOOP;
439: end if;
440: htp.tableClose;
441: htp.p('

');
442: htp.bodyClose;
443: htp.htmlClose;
444: END high_popup_window;
445: ----------------------------------------------------------------------------------------------------
446: PROCEDURE footer

Line 443: htp.htmlClose;

439: end if;
440: htp.tableClose;
441: htp.p('

');
442: htp.bodyClose;
443: htp.htmlClose;
444: END high_popup_window;
445: ----------------------------------------------------------------------------------------------------
446: PROCEDURE footer
447: IS

Line 450: htp.htmlOpen;

446: PROCEDURE footer
447: IS
448: BEGIN
449: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
450: htp.htmlOpen;
451: htp.tableRowOpen;
452: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');

Line 451: htp.tableRowOpen;

447: IS
448: BEGIN
449: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
450: htp.htmlOpen;
451: htp.tableRowOpen;
452: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;

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

448: BEGIN
449: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
450: htp.htmlOpen;
451: htp.tableRowOpen;
452: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');

Line 453: htp.tableRowClose;

449: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
450: htp.htmlOpen;
451: htp.tableRowOpen;
452: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));

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

450: htp.htmlOpen;
451: htp.tableRowOpen;
452: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');

Line 455: htp.tableRowOpen;

451: htp.tableRowOpen;
452: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');
459: htp.p('');

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

452: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');
459: htp.p('');
460: htp.p('');

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

453: htp.tableRowClose;
454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');
459: htp.p('');
460: htp.p('');
461: --htp.tableData('');

Line 458: htp.p('');

454: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');
459: htp.p('');
460: htp.p('');
461: --htp.tableData('');
462: htp.tableData( '');

Line 459: htp.p('');

455: htp.tableRowOpen;
456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');
459: htp.p('');
460: htp.p('');
461: --htp.tableData('');
462: htp.tableData( '');
463: htp.tableData( '');

Line 460: htp.p('');

456: htp.formOpen(cUrl => l_agent || 'ast_ofl_event_attendees_report.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');
459: htp.p('');
460: htp.p('');
461: --htp.tableData('');
462: htp.tableData( '');
463: htp.tableData( '');
464: htp.tableRowClose;

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

457: --htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
458: htp.p('');
459: htp.p('');
460: htp.p('');
461: --htp.tableData('');
462: htp.tableData( '');
463: htp.tableData( '');
464: htp.tableRowClose;
465: htp.tableClose;

Line 462: htp.tableData( '');

458: htp.p('');
459: htp.p('');
460: htp.p('');
461: --htp.tableData('');
462: htp.tableData( '');
463: htp.tableData( '');
464: htp.tableRowClose;
465: htp.tableClose;
466: htp.htmlClose;

Line 463: htp.tableData( '');

459: htp.p('');
460: htp.p('');
461: --htp.tableData('');
462: htp.tableData( '');
463: htp.tableData( '');
464: htp.tableRowClose;
465: htp.tableClose;
466: htp.htmlClose;
467: END footer;

Line 464: htp.tableRowClose;

460: htp.p('');
461: --htp.tableData('');
462: htp.tableData( '');
463: htp.tableData( '');
464: htp.tableRowClose;
465: htp.tableClose;
466: htp.htmlClose;
467: END footer;
468: END;

Line 465: htp.tableClose;

461: --htp.tableData('');
462: htp.tableData( '');
463: htp.tableData( '');
464: htp.tableRowClose;
465: htp.tableClose;
466: htp.htmlClose;
467: END footer;
468: END;

Line 466: htp.htmlClose;

462: htp.tableData( '');
463: htp.tableData( '');
464: htp.tableRowClose;
465: htp.tableClose;
466: htp.htmlClose;
467: END footer;
468: END;