[Home] [Help]
APPS.AST_OFL_ACCESSES_REPORT dependencies on HTP
Line 25: htp.htmlOpen;
21: SELECT to_char(SYSDATE,'DD-MON-YYYY')
22: INTO v_date_time
23: FROM dual;
24:
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title('Accesses Report');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
Line 26: htp.headOpen;
22: INTO v_date_time
23: FROM dual;
24:
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title('Accesses Report');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
Line 27: htp.title('Accesses Report');
23: FROM dual;
24:
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title('Accesses Report');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
Line 28: htp.headClose;
24:
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title('Accesses Report');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
Line 29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title('Accesses Report');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
Line 30: htp.tableOpen();
26: htp.headOpen;
27: htp.title('Accesses Report');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
Line 31: htp.tableRowOpen(cAlign => 'TOP');
27: htp.title('Accesses Report');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
35: htp.tableClose;
Line 32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
28: htp.headClose;
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
Line 33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
29: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
Line 34: htp.tableRowClose;
30: htp.tableOpen();
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
Line 35: htp.tableClose;
31: htp.tableRowOpen(cAlign => 'TOP');
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
Line 36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
32: htp.tableData( '' || 'Accesses Report', cnowrap => 'TRUE');
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
Line 37: htp.tableRowOpen(cVAlign => 'top' );
33: htp.tableData(htf.bold(v_date_time), cAlign => 'right', cColSpan => '110');
34: htp.tableRowClose;
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
Line 38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
34: htp.tableRowClose;
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
42: htp.tableRowClose;
Line 39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
35: htp.tableClose;
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
42: htp.tableRowClose;
43: htp.tableClose;
Line 40: htp.tableData(' ', cColSpan => '6');
36: htp.tableOpen(cAttributes => ' border=0 cellspacing=0 cellpadding=0 width=561' );
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.bodyClose;
Line 41: htp.br;
37: htp.tableRowOpen(cVAlign => 'top' );
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.bodyClose;
45: htp.headClose;
Line 42: htp.tableRowClose;
38: htp.tableData(' ', cColSpan => '2', cAttributes => ' height=9');
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.bodyClose;
45: htp.headClose;
46: htp.htmlClose;
Line 43: htp.tableClose;
39: htp.tableData('' || htf.bold( 'Please specify the criteria and select OK. ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.bodyClose;
45: htp.headClose;
46: htp.htmlClose;
47: END;
Line 44: htp.bodyClose;
40: htp.tableData(' ', cColSpan => '6');
41: htp.br;
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.bodyClose;
45: htp.headClose;
46: htp.htmlClose;
47: END;
48:
Line 45: htp.headClose;
41: htp.br;
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.bodyClose;
45: htp.headClose;
46: htp.htmlClose;
47: END;
48:
49: ----------------------------------------------------------------------------------------------------
Line 46: htp.htmlClose;
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.bodyClose;
45: htp.headClose;
46: htp.htmlClose;
47: END;
48:
49: ----------------------------------------------------------------------------------------------------
50: PROCEDURE accesses_paramform
Line 148: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_accesses_report_pkg.accesses_wrapper', cattributes => ' NAME="param"');
144:
145: IF (icx_sec.validateSession(c_commit => FALSE))
146: THEN
147: l_user_id := icx_sec.getID(icx_sec.pv_user_id); -- Returns login user Id
148: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_accesses_report_pkg.accesses_wrapper', cattributes => ' NAME="param"');
149: header;
150: htp.htmlOpen;
151: htp.headOpen;
152: htp.title('Accesses Report');
Line 150: htp.htmlOpen;
146: THEN
147: l_user_id := icx_sec.getID(icx_sec.pv_user_id); -- Returns login user Id
148: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_accesses_report_pkg.accesses_wrapper', cattributes => ' NAME="param"');
149: header;
150: htp.htmlOpen;
151: htp.headOpen;
152: htp.title('Accesses Report');
153: htp.headClose;
154: footer;
Line 151: htp.headOpen;
147: l_user_id := icx_sec.getID(icx_sec.pv_user_id); -- Returns login user Id
148: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_accesses_report_pkg.accesses_wrapper', cattributes => ' NAME="param"');
149: header;
150: htp.htmlOpen;
151: htp.headOpen;
152: htp.title('Accesses Report');
153: htp.headClose;
154: footer;
155:
Line 152: htp.title('Accesses Report');
148: htp.formOpen(owa_util.Get_Owa_Service_Path || 'ast_ofl_accesses_report_pkg.accesses_wrapper', cattributes => ' NAME="param"');
149: header;
150: htp.htmlOpen;
151: htp.headOpen;
152: htp.title('Accesses Report');
153: htp.headClose;
154: footer;
155:
156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
Line 153: htp.headClose;
149: header;
150: htp.htmlOpen;
151: htp.headOpen;
152: htp.title('Accesses Report');
153: htp.headClose;
154: footer;
155:
156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
157: htp.tableOpen;
Line 156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
152: htp.title('Accesses Report');
153: htp.headClose;
154: footer;
155:
156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
157: htp.tableOpen;
158: htp.tableRowOpen(cVAlign => 'top');
159: htp.tableData(' ', cAttributes => ' height=9');
160: htp.tableData('' || '',
Line 157: htp.tableOpen;
153: htp.headClose;
154: footer;
155:
156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
157: htp.tableOpen;
158: htp.tableRowOpen(cVAlign => 'top');
159: htp.tableData(' ', cAttributes => ' height=9');
160: htp.tableData('' || '',
161: cAlign => 'right',
Line 158: htp.tableRowOpen(cVAlign => 'top');
154: footer;
155:
156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
157: htp.tableOpen;
158: htp.tableRowOpen(cVAlign => 'top');
159: htp.tableData(' ', cAttributes => ' height=9');
160: htp.tableData('' || '',
161: cAlign => 'right',
162: cRowSpan => '2',
Line 159: htp.tableData(' ', cAttributes => ' height=9');
155:
156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
157: htp.tableOpen;
158: htp.tableRowOpen(cVAlign => 'top');
159: htp.tableData(' ', cAttributes => ' height=9');
160: htp.tableData('' || '',
161: cAlign => 'right',
162: cRowSpan => '2',
163: cColSpan => '3',
Line 160: htp.tableData('' || '',
156: htp.bodyOpen(cAttributes => 'bgcolor="#CCCCCC"');
157: htp.tableOpen;
158: htp.tableRowOpen(cVAlign => 'top');
159: htp.tableData(' ', cAttributes => ' height=9');
160: htp.tableData('' || '',
161: cAlign => 'right',
162: cRowSpan => '2',
163: cColSpan => '3',
164: cAttributes => ' width=154');
Line 165: htp.tableData(' ');
161: cAlign => 'right',
162: cRowSpan => '2',
163: cColSpan => '3',
164: cAttributes => ' width=154');
165: htp.tableData(' ');
166: htp.tableRowClose;
167: htp.tableClose;
168:
169: htp.tableOpen(cAttributes => 'width="700"');
Line 166: htp.tableRowClose;
162: cRowSpan => '2',
163: cColSpan => '3',
164: cAttributes => ' width=154');
165: htp.tableData(' ');
166: htp.tableRowClose;
167: htp.tableClose;
168:
169: htp.tableOpen(cAttributes => 'width="700"');
170: htp.tableRowOpen();
Line 167: htp.tableClose;
163: cColSpan => '3',
164: cAttributes => ' width=154');
165: htp.tableData(' ');
166: htp.tableRowClose;
167: htp.tableClose;
168:
169: htp.tableOpen(cAttributes => 'width="700"');
170: htp.tableRowOpen();
171: htp.p('
Select Output Format | ');
Line 169: htp.tableOpen(cAttributes => 'width="700"');
165: htp.tableData(' ');
166: htp.tableRowClose;
167: htp.tableClose;
168:
169: htp.tableOpen(cAttributes => 'width="700"');
170: htp.tableRowOpen();
171: htp.p('
Select Output Format | ');
172: htp.p('');
173: htp.p(' |