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

Line 38: htp.htmlOpen;

34: SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY')
35: INTO v_date_time
36: FROM DUAL;
37:
38: htp.htmlOpen;
39: htp.headOpen;
40: htp.title('Lead Assignment');
41: htp.headClose;
42: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

Line 39: htp.headOpen;

35: INTO v_date_time
36: FROM DUAL;
37:
38: htp.htmlOpen;
39: htp.headOpen;
40: htp.title('Lead Assignment');
41: htp.headClose;
42: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
43: htp.tableOpen('border="0" ');

Line 40: htp.title('Lead Assignment');

36: FROM DUAL;
37:
38: htp.htmlOpen;
39: htp.headOpen;
40: htp.title('Lead Assignment');
41: htp.headClose;
42: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
43: htp.tableOpen('border="0" ');
44: htp.tableRowOpen(cAlign => 'TOP');

Line 41: htp.headClose;

37:
38: htp.htmlOpen;
39: htp.headOpen;
40: htp.title('Lead Assignment');
41: htp.headClose;
42: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
43: htp.tableOpen('border="0" ');
44: htp.tableRowOpen(cAlign => 'TOP');
45:

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

38: htp.htmlOpen;
39: htp.headOpen;
40: htp.title('Lead Assignment');
41: htp.headClose;
42: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
43: htp.tableOpen('border="0" ');
44: htp.tableRowOpen(cAlign => 'TOP');
45:
46:

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

39: htp.headOpen;
40: htp.title('Lead Assignment');
41: htp.headClose;
42: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
43: htp.tableOpen('border="0" ');
44: htp.tableRowOpen(cAlign => 'TOP');
45:
46:
47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');

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

40: htp.title('Lead Assignment');
41: htp.headClose;
42: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
43: htp.tableOpen('border="0" ');
44: htp.tableRowOpen(cAlign => 'TOP');
45:
46:
47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');
48: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');

Line 47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');

43: htp.tableOpen('border="0" ');
44: htp.tableRowOpen(cAlign => 'TOP');
45:
46:
47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');
48: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
49: htp.tableRowClose;
50: htp.tableClose;
51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');

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

44: htp.tableRowOpen(cAlign => 'TOP');
45:
46:
47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');
48: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
49: htp.tableRowClose;
50: htp.tableClose;
51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
52: htp.tableRowOpen(cVAlign => 'top');

Line 49: htp.tableRowClose;

45:
46:
47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');
48: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
49: htp.tableRowClose;
50: htp.tableClose;
51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
52: htp.tableRowOpen(cVAlign => 'top');
53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');

Line 50: htp.tableClose;

46:
47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');
48: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
49: htp.tableRowClose;
50: htp.tableClose;
51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
52: htp.tableRowOpen(cVAlign => 'top');
53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');

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

47: htp.tableData('' || 'Lead Assignment Report', cNoWrap => 'TRUE');
48: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
49: htp.tableRowClose;
50: htp.tableClose;
51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
52: htp.tableRowOpen(cVAlign => 'top');
53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
55: htp.tableData(' ', cColSpan => '6');

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

48: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
49: htp.tableRowClose;
50: htp.tableClose;
51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
52: htp.tableRowOpen(cVAlign => 'top');
53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
55: htp.tableData(' ', cColSpan => '6');
56: htp.br;

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

49: htp.tableRowClose;
50: htp.tableClose;
51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
52: htp.tableRowOpen(cVAlign => 'top');
53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
55: htp.tableData(' ', cColSpan => '6');
56: htp.br;
57: htp.tableRowClose;

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

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

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

51: htp.tableOpen(cAttributes => 'border=0 cellspacing=0 cellpadding=0 width=561');
52: htp.tableRowOpen(cVAlign => 'top');
53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
55: htp.tableData(' ', cColSpan => '6');
56: htp.br;
57: htp.tableRowClose;
58: htp.tableClose;
59: htp.bodyClose;

Line 56: htp.br;

52: htp.tableRowOpen(cVAlign => 'top');
53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
55: htp.tableData(' ', cColSpan => '6');
56: htp.br;
57: htp.tableRowClose;
58: htp.tableClose;
59: htp.bodyClose;
60: htp.headClose;

Line 57: htp.tableRowClose;

53: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
55: htp.tableData(' ', cColSpan => '6');
56: htp.br;
57: htp.tableRowClose;
58: htp.tableClose;
59: htp.bodyClose;
60: htp.headClose;
61: htp.htmlClose;

Line 58: htp.tableClose;

54: htp.tableData('' || htf.bold('Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
55: htp.tableData(' ', cColSpan => '6');
56: htp.br;
57: htp.tableRowClose;
58: htp.tableClose;
59: htp.bodyClose;
60: htp.headClose;
61: htp.htmlClose;
62: END;

Line 59: htp.bodyClose;

55: htp.tableData(' ', cColSpan => '6');
56: htp.br;
57: htp.tableRowClose;
58: htp.tableClose;
59: htp.bodyClose;
60: htp.headClose;
61: htp.htmlClose;
62: END;
63: --------------------------------------------------------------------------------

Line 60: htp.headClose;

56: htp.br;
57: htp.tableRowClose;
58: htp.tableClose;
59: htp.bodyClose;
60: htp.headClose;
61: htp.htmlClose;
62: END;
63: --------------------------------------------------------------------------------
64: PROCEDURE lead_assign_param_form IS

Line 61: htp.htmlClose;

57: htp.tableRowClose;
58: htp.tableClose;
59: htp.bodyClose;
60: htp.headClose;
61: htp.htmlClose;
62: END;
63: --------------------------------------------------------------------------------
64: PROCEDURE lead_assign_param_form IS
65: day_counter NUMBER := 1;

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

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

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

255: htp.p(' alert(''Start Date must be less than End Date'');');
256: htp.p(' p_valid = false;}');
257: htp.p(' }');
258: htp.p(' }');
259: htp.p(' if (p_valid){');
260: htp.p(' objform.submit();}');
261: htp.p('}');
262: htp.p('');
263: htp.headClose;

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

256: htp.p(' p_valid = false;}');
257: htp.p(' }');
258: htp.p(' }');
259: htp.p(' if (p_valid){');
260: htp.p(' objform.submit();}');
261: htp.p('}');
262: htp.p('');
263: htp.headClose;
264: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');

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

257: htp.p(' }');
258: htp.p(' }');
259: htp.p(' if (p_valid){');
260: htp.p(' objform.submit();}');
261: htp.p('}');
262: htp.p('');
263: htp.headClose;
264: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
265: htp.tableOpen;

Line 262: htp.p('');

258: htp.p(' }');
259: htp.p(' if (p_valid){');
260: htp.p(' objform.submit();}');
261: htp.p('}');
262: htp.p('');
263: htp.headClose;
264: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
265: htp.tableOpen;
266: htp.tableRowOpen(cVAlign => 'top');

Line 263: htp.headClose;

259: htp.p(' if (p_valid){');
260: htp.p(' objform.submit();}');
261: htp.p('}');
262: htp.p('');
263: htp.headClose;
264: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
265: htp.tableOpen;
266: htp.tableRowOpen(cVAlign => 'top');
267: htp.tableData(' ', cAttributes => ' height=9');

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

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

Line 265: htp.tableOpen;

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

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

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

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

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

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

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

Line 269: htp.tableData( ' ');

265: htp.tableOpen;
266: htp.tableRowOpen(cVAlign => 'top');
267: htp.tableData(' ', cAttributes => ' height=9');
268: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
269: htp.tableData( ' ');
270: htp.tableRowClose;
271: htp.tableClose;
272: htp.tableOpen(cAttributes => 'width="600" ');
273: htp.tableRowOpen();

Line 270: htp.tableRowClose;

266: htp.tableRowOpen(cVAlign => 'top');
267: htp.tableData(' ', cAttributes => ' height=9');
268: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
269: htp.tableData( ' ');
270: htp.tableRowClose;
271: htp.tableClose;
272: htp.tableOpen(cAttributes => 'width="600" ');
273: htp.tableRowOpen();
274: -- htp.p(L_USER_ID);

Line 271: htp.tableClose;

267: htp.tableData(' ', cAttributes => ' height=9');
268: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
269: htp.tableData( ' ');
270: htp.tableRowClose;
271: htp.tableClose;
272: htp.tableOpen(cAttributes => 'width="600" ');
273: htp.tableRowOpen();
274: -- htp.p(L_USER_ID);
275: htp.p('Select Output Format');

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

268: htp.tableData('' || '', cAlign => 'right', cRowSpan => '2', cColSpan => '3', cAttributes => ' width=154');
269: htp.tableData( ' ');
270: htp.tableRowClose;
271: htp.tableClose;
272: htp.tableOpen(cAttributes => 'width="600" ');
273: htp.tableRowOpen();
274: -- htp.p(L_USER_ID);
275: htp.p('Select Output Format');
276: htp.p('');

Line 273: htp.tableRowOpen();

269: htp.tableData( ' ');
270: htp.tableRowClose;
271: htp.tableClose;
272: htp.tableOpen(cAttributes => 'width="600" ');
273: htp.tableRowOpen();
274: -- htp.p(L_USER_ID);
275: htp.p('Select Output Format');
276: htp.p('');
277: htp.p('');
278: htp.formSelectOption('Excel');

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

271: htp.tableClose;
272: htp.tableOpen(cAttributes => 'width="600" ');
273: htp.tableRowOpen();
274: -- htp.p(L_USER_ID);
275: htp.p('Select Output Format');
276: htp.p('');
277: htp.p('');
278: htp.formSelectOption('Excel');
279: htp.formSelectOption('HTML', cSelected => 'TRUE');
280: htp.formSelectClose;

Line 277: htp.p('');
278: htp.formSelectOption('Excel');
279: htp.formSelectOption('HTML', cSelected => 'TRUE');
280: htp.formSelectClose;
281: htp.tableRowClose;

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

274: -- htp.p(L_USER_ID);
275: htp.p('Select Output Format');
276: htp.p('');
277: htp.p('');
278: htp.formSelectOption('Excel');
279: htp.formSelectOption('HTML', cSelected => 'TRUE');
280: htp.formSelectClose;
281: htp.tableRowClose;
282: htp.tableRowClose;
283: htp.tableRowOpen();

Line 280: htp.formSelectClose;

276: htp.p('');
277: htp.p('');
278: htp.formSelectOption('Excel');
279: htp.formSelectOption('HTML', cSelected => 'TRUE');
280: htp.formSelectClose;
281: htp.tableRowClose;
282: htp.tableRowClose;
283: htp.tableRowOpen();
284: htp.p('Please Enter Start Date');
285: htp.p('');

Line 282: htp.tableRowClose;

278: htp.formSelectOption('Excel');
279: htp.formSelectOption('HTML', cSelected => 'TRUE');
280: htp.formSelectClose;
281: htp.tableRowClose;
282: htp.tableRowClose;
283: htp.tableRowOpen();
284: htp.p('Please Enter Start Date');
285: htp.p('');
286: htp.p('');
287: FOR i IN 1..day_data.count LOOP

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

280: htp.formSelectClose;
281: htp.tableRowClose;
282: htp.tableRowClose;
283: htp.tableRowOpen();
284: htp.p('Please Enter Start Date');
285: htp.p('');
286: htp.p('');
287: FOR i IN 1..day_data.count LOOP
288: htp.formSelectOption(day_data(i),
289: cAttributes => ' value= ' || day_data(i),

Line 286: htp.p('');
287: FOR i IN 1..day_data.count LOOP
288: htp.formSelectOption(day_data(i),
289: cAttributes => ' value= ' || day_data(i),
290: cSelected => 'TRUE' );

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

284: htp.p('Please Enter Start Date');
285: htp.p('');
286: htp.p('');
295: FOR i IN 1..12 LOOP
296: IF i = 1 THEN

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

289: cAttributes => ' value= ' || day_data(i),
290: cSelected => 'TRUE' );
291: END LOOP;
292: htp.formSelectClose;
293: htp.p('-');
294: htp.p('');

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

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

297: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
298: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'),
299: cSelected => 'TRUE');
300: ELSE
301: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
302: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));
303: END IF;
304: END LOOP;
305: htp.formSelectClose;

Line 305: htp.formSelectClose;

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

Line 307: htp.p('');
308: FOR i IN 1..year_data.count LOOP
309: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN
310: htp.formSelectOption(year_data(i),
311: cAttributes => ' value= ' || year_data(i),

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

306: htp.p('-');
307: htp.p('');

Line 321: htp.tableRowOpen();

317: END LOOP;
318: htp.formSelectClose;
319: htp.p('');
320: htp.tableRowClose;
321: htp.tableRowOpen();
322: htp.p('Please Enter End Date');
323: htp.p('');
324: htp.p('');
325: FOR i IN 1..day_data.count LOOP
326: htp.formSelectOption(day_data(i),

Line 323: htp.p('');

319: htp.p('');
320: htp.tableRowClose;
321: htp.tableRowOpen();
322: htp.p('Please Enter End Date');
323: htp.p('');
324: htp.p('');

320: htp.tableRowClose;
321: htp.tableRowOpen();
322: htp.p('Please Enter End Date');
323: htp.p('');
324: htp.p('');
325: FOR i IN 1..day_data.count LOOP
326: htp.formSelectOption(day_data(i),
327: cAttributes => ' value= ' || day_data(i),
328: cSelected => 'TRUE' );
329: END LOOP;
330: htp.formSelectClose;

Line 330: htp.formSelectClose;

326: htp.formSelectOption(day_data(i),
327: cAttributes => ' value= ' || day_data(i),
328: cSelected => 'TRUE' );
329: END LOOP;
330: htp.formSelectClose;
331: htp.p('-');
332: htp.p('');
333: FOR i IN 1..12 LOOP
334: IF i=1 THEN
335: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),

Line 332: htp.p('');
333: FOR i IN 1..12 LOOP
334: IF i=1 THEN
335: htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
336: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'),

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

331: htp.p('-');
332: htp.p('');
346: FOR i IN 1..year_data.count LOOP
347: IF year_data(i) = TO_CHAR(SYSDATE, 'YYYY') THEN

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

340: cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));
341: END IF;
342: END LOOP;
343: htp.formSelectClose;
344: htp.p('-');
345: htp.p ('');

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

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

348: htp.formSelectOption(year_data(i),
349: cAttributes => ' value= ' || year_data(i),
350: cSelected => 'TRUE' );
351: ELSE
352: htp.formSelectOption(year_data(i),
353: cAttributes => ' value= ' || year_data(i));
354: END IF;
355: END LOOP;
356: htp.formSelectClose;

Line 356: htp.formSelectClose;

352: htp.formSelectOption(year_data(i),
353: cAttributes => ' value= ' || year_data(i));
354: END IF;
355: END LOOP;
356: htp.formSelectClose;
357: htp.p('');
358: htp.tableRowClose;
359: htp.tableRowOpen();
360: --htp.p('Are these Close Dates or Creation Dates');

Line 357: htp.p('');

353: cAttributes => ' value= ' || year_data(i));
354: END IF;
355: END LOOP;
356: htp.formSelectClose;
357: htp.p('');
358: htp.tableRowClose;
359: htp.tableRowOpen();
360: --htp.p('Are these Close Dates or Creation Dates');
361: --htp.p('');

Line 358: htp.tableRowClose;

354: END IF;
355: END LOOP;
356: htp.formSelectClose;
357: htp.p('');
358: htp.tableRowClose;
359: htp.tableRowOpen();
360: --htp.p('Are these Close Dates or Creation Dates');
361: --htp.p('');
362: --htp.p ('');
363: --htp.formSelectOption('Creation Dates',

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

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

Line 362: --htp.p ('');
363: --htp.formSelectOption('Creation Dates',
364: -- cAttributes => ' value= ' || 'ENTRY');
365: --htp.formSelectOption('Close Dates',
366: -- cAttributes => ' value= ' || 'CLOSE',

Line 363: --htp.formSelectOption('Creation Dates',

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

Line 368: --htp.formSelectClose;

364: -- cAttributes => ' value= ' || 'ENTRY');
365: --htp.formSelectOption('Close Dates',
366: -- cAttributes => ' value= ' || 'CLOSE',
367: -- cSelected => 'TRUE' );
368: --htp.formSelectClose;
369: --htp.p('');
370: htp.tableRowClose;
371: --htp.tableRowOpen();
372: --htp.p('Sales Group');

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

365: --htp.formSelectOption('Close Dates',
366: -- cAttributes => ' value= ' || 'CLOSE',
367: -- cSelected => 'TRUE' );
368: --htp.formSelectClose;
369: --htp.p('');
370: htp.tableRowClose;
371: --htp.tableRowOpen();
372: --htp.p('Sales Group');
373: --htp.p('');

Line 370: htp.tableRowClose;

366: -- cAttributes => ' value= ' || 'CLOSE',
367: -- cSelected => 'TRUE' );
368: --htp.formSelectClose;
369: --htp.p('');
370: htp.tableRowClose;
371: --htp.tableRowOpen();
372: --htp.p('Sales Group');
373: --htp.p('');
374: --htp.p('');
375: --FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP

Line 372: --htp.p('Sales Group');

368: --htp.formSelectClose;
369: --htp.p('');
370: htp.tableRowClose;
371: --htp.tableRowOpen();
372: --htp.p('Sales Group');
373: --htp.p('');
374: --htp.p('');
375: --FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
376: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
377: --htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);

Line 374: --htp.p('');
375: --FOR rec_sales_group IN cur_sales_group(l_user_id) LOOP
376: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
377: --htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);
378: --END LOOP;

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

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

Line 379: --htp.formSelectClose;

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

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

376: -- htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);
377: --htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || 7062);
378: --END LOOP;
379: --htp.formSelectClose;
380: --htp.p('');
381: --htp.tableRowClose;
382: htp.tableRowOpen();
383: htp.p('Sales Rep');
384: htp.p('');

Line 381: --htp.tableRowClose;

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

Line 383: htp.p('Sales Rep');

379: --htp.formSelectClose;
380: --htp.p('');
381: --htp.tableRowClose;
382: htp.tableRowOpen();
383: htp.p('Sales Rep');
384: htp.p('');
385: htp.p ('');
386: FOR rec_sales_rep IN cur_sales_rep(l_user_id) LOOP
387: IF rec_sales_rep.flname ='ALL' THEN
388: htp.formSelectOption(rec_sales_rep.flname, cAttributes => ' value= ' || rec_sales_rep.pid, cSelected => 'TRUE');

Line 385: htp.p ('');
386: FOR rec_sales_rep IN cur_sales_rep(l_user_id) LOOP
387: IF rec_sales_rep.flname ='ALL' THEN
388: htp.formSelectOption(rec_sales_rep.flname, cAttributes => ' value= ' || rec_sales_rep.pid, cSelected => 'TRUE');
389: ELSE

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

384: htp.p('');
385: htp.p ('');

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

420: htp.tableData(htf.hr, cRowSpan => '1', cColSpan => '190', cNoWrap => 'TRUE');
421: htp.tableRowClose;
422: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
423: htp.tableRowOpen;
424: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
425: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
426: htp.p('');
427: htp.p('');
428: htp.p('');

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

421: htp.tableRowClose;
422: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
423: htp.tableRowOpen;
424: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
425: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
426: htp.p('');
427: htp.p('');
428: htp.p('');
429: --htp.tableData('');

Line 426: htp.p('');

422: htp.tableOpen(cAlign => 'center', cAttributes => ' border=0 cellspacing=2 cellpadding=2');
423: htp.tableRowOpen;
424: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
425: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
426: htp.p('');
427: htp.p('');
428: htp.p('');
429: --htp.tableData('');
430: htp.tableData( '');

Line 427: htp.p('');

423: htp.tableRowOpen;
424: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
425: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
426: htp.p('');
427: htp.p('');
428: htp.p('');
429: --htp.tableData('');
430: htp.tableData( '');
431: htp.tableData( '');

Line 428: htp.p('');

424: htp.formOpen(cUrl => l_agent || 'ast_ofl_pipeline_buckets_rpt.report_wrapper', cMethod => 'post', cAttributes => ' NAME="MyForm" TARGET="_top"');
425: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
426: htp.p('');
427: htp.p('');
428: htp.p('');
429: --htp.tableData('');
430: htp.tableData( '');
431: htp.tableData( '');
432: htp.tableRowClose;

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

425: -- htp.tableData(htf.formSubmit(cValue => 'OK', cAttributes => ' onMouseOver="window.status=''OK'';return true"'));
426: htp.p('');
427: htp.p('');
428: htp.p('');
429: --htp.tableData('');
430: htp.tableData( '');
431: htp.tableData( '');
432: htp.tableRowClose;
433: htp.tableClose;

Line 430: htp.tableData( '');

426: htp.p('');
427: htp.p('');
428: htp.p('');
429: --htp.tableData('');
430: htp.tableData( '');
431: htp.tableData( '');
432: htp.tableRowClose;
433: htp.tableClose;
434: htp.htmlClose;

Line 431: htp.tableData( '');

427: htp.p('');
428: htp.p('');
429: --htp.tableData('');
430: htp.tableData( '');
431: htp.tableData( '');
432: htp.tableRowClose;
433: htp.tableClose;
434: htp.htmlClose;
435: END footer;

Line 432: htp.tableRowClose;

428: htp.p('');
429: --htp.tableData('');
430: htp.tableData( '');
431: htp.tableData( '');
432: htp.tableRowClose;
433: htp.tableClose;
434: htp.htmlClose;
435: END footer;
436: END;

Line 433: htp.tableClose;

429: --htp.tableData('');
430: htp.tableData( '');
431: htp.tableData( '');
432: htp.tableRowClose;
433: htp.tableClose;
434: htp.htmlClose;
435: END footer;
436: END;

Line 434: htp.htmlClose;

430: htp.tableData( '');
431: htp.tableData( '');
432: htp.tableRowClose;
433: htp.tableClose;
434: htp.htmlClose;
435: END footer;
436: END;