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

Line 32: htp.htmlopen;

28: --
29: -----------------------------------------------------------------------------------------------
30: begin
31: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
32: htp.htmlopen;
33: htp.headOpen;
34: htp.title('Territories - No Accesses Report');
35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 33: htp.headOpen;

29: -----------------------------------------------------------------------------------------------
30: begin
31: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
32: htp.htmlopen;
33: htp.headOpen;
34: htp.title('Territories - No Accesses Report');
35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');

Line 34: htp.title('Territories - No Accesses Report');

30: begin
31: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
32: htp.htmlopen;
33: htp.headOpen;
34: htp.title('Territories - No Accesses Report');
35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );

Line 35: htp.headClose;

31: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
32: htp.htmlopen;
33: htp.headOpen;
34: htp.title('Territories - No Accesses Report');
35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));

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

32: htp.htmlopen;
33: htp.headOpen;
34: htp.title('Territories - No Accesses Report');
35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');

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

33: htp.headOpen;
34: htp.title('Territories - No Accesses Report');
35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

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

34: htp.title('Territories - No Accesses Report');
35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;

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

35: htp.headClose;
36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;
43: htp.tableClose;

Line 40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');

36: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );

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

37: htp.tableOpen('border="0" ');
38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
45: htp.tableRowOpen( cvalign => 'top' );

Line 42: htp.tableRowClose;

38: htp.tableRowOpen( calign => 'TOP' );
39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
45: htp.tableRowOpen( cvalign => 'top' );
46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

Line 43: htp.tableClose;

39: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
45: htp.tableRowOpen( cvalign => 'top' );
46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

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

40: htp.tableData( '' || 'Territories - No Accesses Report', cnowrap => 'TRUE');
41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
45: htp.tableRowOpen( cvalign => 'top' );
46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');

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

41: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
42: htp.tableRowClose;
43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
45: htp.tableRowOpen( cvalign => 'top' );
46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
49: htp.tableData( ' ', ccolspan => '6');

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

42: htp.tableRowClose;
43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
45: htp.tableRowOpen( cvalign => 'top' );
46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
49: htp.tableData( ' ', ccolspan => '6');
50: htp.Br;

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

43: htp.tableClose;
44: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
45: htp.tableRowOpen( cvalign => 'top' );
46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
49: htp.tableData( ' ', ccolspan => '6');
50: htp.Br;
51: htp.tableRowClose;

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

45: htp.tableRowOpen( cvalign => 'top' );
46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
49: htp.tableData( ' ', ccolspan => '6');
50: htp.Br;
51: htp.tableRowClose;
52: htp.tableClose;
53: htp.bodyClose;

Line 50: htp.Br;

46: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
49: htp.tableData( ' ', ccolspan => '6');
50: htp.Br;
51: htp.tableRowClose;
52: htp.tableClose;
53: htp.bodyClose;
54: htp.headClose;

Line 51: htp.tableRowClose;

47: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
49: htp.tableData( ' ', ccolspan => '6');
50: htp.Br;
51: htp.tableRowClose;
52: htp.tableClose;
53: htp.bodyClose;
54: htp.headClose;
55: htp.htmlClose;

Line 52: htp.tableClose;

48: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
49: htp.tableData( ' ', ccolspan => '6');
50: htp.Br;
51: htp.tableRowClose;
52: htp.tableClose;
53: htp.bodyClose;
54: htp.headClose;
55: htp.htmlClose;
56: end;

Line 53: htp.bodyClose;

49: htp.tableData( ' ', ccolspan => '6');
50: htp.Br;
51: htp.tableRowClose;
52: htp.tableClose;
53: htp.bodyClose;
54: htp.headClose;
55: htp.htmlClose;
56: end;
57: -----------------------------------------------------------------------------------------------

Line 54: htp.headClose;

50: htp.Br;
51: htp.tableRowClose;
52: htp.tableClose;
53: htp.bodyClose;
54: htp.headClose;
55: htp.htmlClose;
56: end;
57: -----------------------------------------------------------------------------------------------
58: procedure terr_miss_acc_param is

Line 55: htp.htmlClose;

51: htp.tableRowClose;
52: htp.tableClose;
53: htp.bodyClose;
54: htp.headClose;
55: htp.htmlClose;
56: end;
57: -----------------------------------------------------------------------------------------------
58: procedure terr_miss_acc_param is
59:

Line 82: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_acc_report.report_wrapper',

78: header;
79:
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_TERR_MISS_acc_report.report_wrapper',
83: cattributes => ' NAME="param"');
84: htp.htmlopen;
85: htp.headOpen;
86: htp.title('Territories - No Accesses Report');

Line 84: htp.htmlopen;

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_TERR_MISS_acc_report.report_wrapper',
83: cattributes => ' NAME="param"');
84: htp.htmlopen;
85: htp.headOpen;
86: htp.title('Territories - No Accesses Report');
87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 85: htp.headOpen;

81: -------------------- Returns login user Id--------------------------
82: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_acc_report.report_wrapper',
83: cattributes => ' NAME="param"');
84: htp.htmlopen;
85: htp.headOpen;
86: htp.title('Territories - No Accesses Report');
87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;

Line 86: htp.title('Territories - No Accesses Report');

82: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_acc_report.report_wrapper',
83: cattributes => ' NAME="param"');
84: htp.htmlopen;
85: htp.headOpen;
86: htp.title('Territories - No Accesses Report');
87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );

Line 87: htp.headClose;

83: cattributes => ' NAME="param"');
84: htp.htmlopen;
85: htp.headOpen;
86: htp.title('Territories - No Accesses Report');
87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');

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

84: htp.htmlopen;
85: htp.headOpen;
86: htp.title('Territories - No Accesses Report');
87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

Line 89: htp.tableopen;

85: htp.headOpen;
86: htp.title('Territories - No Accesses Report');
87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');

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

86: htp.title('Territories - No Accesses Report');
87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');
94: htp.tableRowClose;

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

87: htp.headClose;
88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');
94: htp.tableRowClose;
95: htp.tableClose;

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

88: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');
94: htp.tableRowClose;
95: htp.tableClose;
96: htp.tableOpen(cattributes=>'width="600" ');

Line 93: htp.tableData( ' ');

89: htp.tableopen;
90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');
94: htp.tableRowClose;
95: htp.tableClose;
96: htp.tableOpen(cattributes=>'width="600" ');
97:

Line 94: htp.tableRowClose;

90: htp.tableRowOpen( cvalign => 'top' );
91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');
94: htp.tableRowClose;
95: htp.tableClose;
96: htp.tableOpen(cattributes=>'width="600" ');
97:
98: htp.tableRowOpen();

Line 95: htp.tableClose;

91: htp.tableData( ' ', cattributes => ' height=9');
92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');
94: htp.tableRowClose;
95: htp.tableClose;
96: htp.tableOpen(cattributes=>'width="600" ');
97:
98: htp.tableRowOpen();
99: htp.p('Select Output Format');

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

92: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
93: htp.tableData( ' ');
94: htp.tableRowClose;
95: htp.tableClose;
96: htp.tableOpen(cattributes=>'width="600" ');
97:
98: htp.tableRowOpen();
99: htp.p('Select Output Format');
100: htp.p('');

Line 98: htp.tableRowOpen();

94: htp.tableRowClose;
95: htp.tableClose;
96: htp.tableOpen(cattributes=>'width="600" ');
97:
98: htp.tableRowOpen();
99: htp.p('Select Output Format');
100: htp.p('');
101: htp.p ('');
102: htp.FormSelectOption('Excel');
103: htp.FormSelectOption('HTML',cselected => 'TRUE');

Line 100: htp.p('');

96: htp.tableOpen(cattributes=>'width="600" ');
97:
98: htp.tableRowOpen();
99: htp.p('Select Output Format');
100: htp.p('');
101: htp.p ('');

97:
98: htp.tableRowOpen();
99: htp.p('Select Output Format');
100: htp.p('');
101: htp.p ('');
102: htp.FormSelectOption('Excel');
103: htp.FormSelectOption('HTML',cselected => 'TRUE');
104: htp.FormSelectClose;
105: htp.tableRowClose;
106:

Line 103: htp.FormSelectOption('HTML',cselected => 'TRUE');

99: htp.p('Select Output Format');
100: htp.p('');
101: htp.p ('');
102: htp.FormSelectOption('Excel');
103: htp.FormSelectOption('HTML',cselected => 'TRUE');
104: htp.FormSelectClose;
105: htp.tableRowClose;
106:
107: --htp.tableRowClose;
108: /*

Line 105: htp.tableRowClose;

101: htp.p ('');

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

140: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
141: htp.tableRowOpen;
142: htp.formOpen( curl => l_agent||'/AST_OFL_TERR_MISS_acc_report.report_wrapper', cmethod => 'GET',
143: cattributes => ' NAME="MyForm" TARGET="_top"');
144: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
145:
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;

Line 146: htp.tableData( '');

142: htp.formOpen( curl => l_agent||'/AST_OFL_TERR_MISS_acc_report.report_wrapper', cmethod => 'GET',
143: cattributes => ' NAME="MyForm" TARGET="_top"');
144: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
145:
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;

Line 147: htp.tableRowClose;

143: cattributes => ' NAME="MyForm" TARGET="_top"');
144: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
145:
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;
151: END;

Line 148: htp.tableClose;

144: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
145:
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;
151: END;

Line 149: htp.htmlClose;

145:
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;
151: END;