DBA Data[Home] [Help]

APPS.JTF_TERR_CHANGES_PARAM_PVT dependencies on HTP

Line 31: htp.htmlopen;

27: --
28: -----------------------------------------------------------------------------------------------
29: begin
30: --select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
31: htp.htmlopen;
32: htp.headOpen;
33: htp.title('Territory Changes Report');
34: htp.p('');
94: htp.headClose;

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

87: htp.p(' }');
88: -- htp.p(' alert(''Start Date must be less than End Date'');');
89:
90: htp.p(' if (p_valid){');
91: htp.p(' objform.submit();}');
92: htp.p('}');
93: htp.p('');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

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

88: -- htp.p(' alert(''Start Date must be less than End Date'');');
89:
90: htp.p(' if (p_valid){');
91: htp.p(' objform.submit();}');
92: htp.p('}');
93: htp.p('');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');

Line 93: htp.p('');

89:
90: htp.p(' if (p_valid){');
91: htp.p(' objform.submit();}');
92: htp.p('}');
93: htp.p('');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );

Line 94: htp.headClose;

90: htp.p(' if (p_valid){');
91: htp.p(' objform.submit();}');
92: htp.p('}');
93: htp.p('');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));

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

91: htp.p(' objform.submit();}');
92: htp.p('}');
93: htp.p('');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');

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

92: htp.p('}');
93: htp.p('');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

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

93: htp.p('');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;

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

94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;
102: htp.tableClose;

Line 99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');

95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );

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

96: htp.tableOpen('border="0" ');
97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
104: htp.tableRowOpen( cvalign => 'top' );

Line 101: htp.tableRowClose;

97: htp.tableRowOpen( calign => 'TOP' );
98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
104: htp.tableRowOpen( cvalign => 'top' );
105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

Line 102: htp.tableClose;

98: -- htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
104: htp.tableRowOpen( cvalign => 'top' );
105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

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

99: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
104: htp.tableRowOpen( cvalign => 'top' );
105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');

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

100: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
104: htp.tableRowOpen( cvalign => 'top' );
105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
108: htp.tableData( ' ', ccolspan => '6');

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

101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
104: htp.tableRowOpen( cvalign => 'top' );
105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
108: htp.tableData( ' ', ccolspan => '6');
109: htp.Br;

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

102: htp.tableClose;
103: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
104: htp.tableRowOpen( cvalign => 'top' );
105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
108: htp.tableData( ' ', ccolspan => '6');
109: htp.Br;
110: htp.tableRowClose;

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

104: htp.tableRowOpen( cvalign => 'top' );
105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
108: htp.tableData( ' ', ccolspan => '6');
109: htp.Br;
110: htp.tableRowClose;
111: htp.tableClose;
112: htp.bodyClose;

Line 109: htp.Br;

105: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
108: htp.tableData( ' ', ccolspan => '6');
109: htp.Br;
110: htp.tableRowClose;
111: htp.tableClose;
112: htp.bodyClose;
113: htp.headClose;

Line 110: htp.tableRowClose;

106: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
108: htp.tableData( ' ', ccolspan => '6');
109: htp.Br;
110: htp.tableRowClose;
111: htp.tableClose;
112: htp.bodyClose;
113: htp.headClose;
114: htp.htmlClose;

Line 111: htp.tableClose;

107: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
108: htp.tableData( ' ', ccolspan => '6');
109: htp.Br;
110: htp.tableRowClose;
111: htp.tableClose;
112: htp.bodyClose;
113: htp.headClose;
114: htp.htmlClose;
115: end;

Line 112: htp.bodyClose;

108: htp.tableData( ' ', ccolspan => '6');
109: htp.Br;
110: htp.tableRowClose;
111: htp.tableClose;
112: htp.bodyClose;
113: htp.headClose;
114: htp.htmlClose;
115: end;
116: -----------------------------------------------------------------------------------------------

Line 113: htp.headClose;

109: htp.Br;
110: htp.tableRowClose;
111: htp.tableClose;
112: htp.bodyClose;
113: htp.headClose;
114: htp.htmlClose;
115: end;
116: -----------------------------------------------------------------------------------------------
117: procedure terr_changes_paramform is

Line 114: htp.htmlClose;

110: htp.tableRowClose;
111: htp.tableClose;
112: htp.bodyClose;
113: htp.headClose;
114: htp.htmlClose;
115: end;
116: -----------------------------------------------------------------------------------------------
117: procedure terr_changes_paramform is
118:

Line 164: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_changes_report_PVT.report_wrapper',

160: header;
161:
162: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
163: -------------------- Returns login user Id--------------------------
164: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_changes_report_PVT.report_wrapper',
165: cattributes => ' NAME="param"');
166: htp.htmlopen;
167: htp.headOpen;
168: htp.title('Territory Changes Report');

Line 166: htp.htmlopen;

162: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
163: -------------------- Returns login user Id--------------------------
164: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_changes_report_PVT.report_wrapper',
165: cattributes => ' NAME="param"');
166: htp.htmlopen;
167: htp.headOpen;
168: htp.title('Territory Changes Report');
169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 167: htp.headOpen;

163: -------------------- Returns login user Id--------------------------
164: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_changes_report_PVT.report_wrapper',
165: cattributes => ' NAME="param"');
166: htp.htmlopen;
167: htp.headOpen;
168: htp.title('Territory Changes Report');
169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;

Line 168: htp.title('Territory Changes Report');

164: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_changes_report_PVT.report_wrapper',
165: cattributes => ' NAME="param"');
166: htp.htmlopen;
167: htp.headOpen;
168: htp.title('Territory Changes Report');
169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );

Line 169: htp.headClose;

165: cattributes => ' NAME="param"');
166: htp.htmlopen;
167: htp.headOpen;
168: htp.title('Territory Changes Report');
169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');

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

166: htp.htmlopen;
167: htp.headOpen;
168: htp.title('Territory Changes Report');
169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

Line 171: htp.tableopen;

167: htp.headOpen;
168: htp.title('Territory Changes Report');
169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');

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

168: htp.title('Territory Changes Report');
169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');
176: htp.tableRowClose;

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

169: htp.headClose;
170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');
176: htp.tableRowClose;
177: htp.tableClose;

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

170: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');
176: htp.tableRowClose;
177: htp.tableClose;
178: htp.tableOpen(cattributes=>'width="600" ');

Line 175: htp.tableData( ' ');

171: htp.tableopen;
172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');
176: htp.tableRowClose;
177: htp.tableClose;
178: htp.tableOpen(cattributes=>'width="600" ');
179: -- OUTPUT FORMAT FIELD

Line 176: htp.tableRowClose;

172: htp.tableRowOpen( cvalign => 'top' );
173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');
176: htp.tableRowClose;
177: htp.tableClose;
178: htp.tableOpen(cattributes=>'width="600" ');
179: -- OUTPUT FORMAT FIELD
180: htp.tableRowOpen();

Line 177: htp.tableClose;

173: htp.tableData( ' ', cattributes => ' height=9');
174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');
176: htp.tableRowClose;
177: htp.tableClose;
178: htp.tableOpen(cattributes=>'width="600" ');
179: -- OUTPUT FORMAT FIELD
180: htp.tableRowOpen();
181: htp.p('Select Output Format');

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

174: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
175: htp.tableData( ' ');
176: htp.tableRowClose;
177: htp.tableClose;
178: htp.tableOpen(cattributes=>'width="600" ');
179: -- OUTPUT FORMAT FIELD
180: htp.tableRowOpen();
181: htp.p('Select Output Format');
182: htp.p('');

Line 180: htp.tableRowOpen();

176: htp.tableRowClose;
177: htp.tableClose;
178: htp.tableOpen(cattributes=>'width="600" ');
179: -- OUTPUT FORMAT FIELD
180: htp.tableRowOpen();
181: htp.p('Select Output Format');
182: htp.p('');
183: htp.p ('');
184: htp.FormSelectOption('Excel');
185: htp.FormSelectOption('HTML',cselected => 'TRUE');

Line 182: htp.p('');

178: htp.tableOpen(cattributes=>'width="600" ');
179: -- OUTPUT FORMAT FIELD
180: htp.tableRowOpen();
181: htp.p('Select Output Format');
182: htp.p('');
183: htp.p ('');

179: -- OUTPUT FORMAT FIELD
180: htp.tableRowOpen();
181: htp.p('Select Output Format');
182: htp.p('');
183: htp.p ('');
184: htp.FormSelectOption('Excel');
185: htp.FormSelectOption('HTML',cselected => 'TRUE');
186: htp.FormSelectClose;
187: htp.tableRowClose;
188: /* -- MANAGER/GROUP FIELD

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

181: htp.p('Select Output Format');
182: htp.p('');
183: htp.p ('');
184: htp.FormSelectOption('Excel');
185: htp.FormSelectOption('HTML',cselected => 'TRUE');
186: htp.FormSelectClose;
187: htp.tableRowClose;
188: /* -- MANAGER/GROUP FIELD
189:
190: htp.tableRowOpen();

Line 187: htp.tableRowClose;

183: htp.p ('');
194: FOR rec_get_manager IN cur_get_manager LOOP

Line 191: htp.p('Manager/Group');

187: htp.tableRowClose;
188: /* -- MANAGER/GROUP FIELD
189:
190: htp.tableRowOpen();
191: htp.p('Manager/Group');
192: htp.p('');
193: htp.p ('');
194: FOR rec_get_manager IN cur_get_manager LOOP
195: htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);
196: END LOOP;

Line 193: htp.p ('');
194: FOR rec_get_manager IN cur_get_manager LOOP
195: htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);
196: END LOOP;
197: htp.FormSelectClose;

Line 195: htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);

191: htp.p('Manager/Group');
192: htp.p('');
193: htp.p ('');
194: FOR rec_get_manager IN cur_get_manager LOOP
195: htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);
196: END LOOP;
197: htp.FormSelectClose;
198: htp.p('');
199: htp.tableRowClose;
200: */
201: -- EARLISET CHANGE DATE FIELD

Line 198: htp.p('');

194: FOR rec_get_manager IN cur_get_manager LOOP
195: htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);
196: END LOOP;
197: htp.FormSelectClose;
198: htp.p('');
199: htp.tableRowClose;
200: */
201: -- EARLISET CHANGE DATE FIELD
202: htp.tableRowOpen();

Line 199: htp.tableRowClose;

195: htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);
196: END LOOP;
197: htp.FormSelectClose;
198: htp.p('');
199: htp.tableRowClose;
200: */
201: -- EARLISET CHANGE DATE FIELD
202: htp.tableRowOpen();
203: htp.p('Earliest Change Date');

Line 202: htp.tableRowOpen();

198: htp.p('');
199: htp.tableRowClose;
200: */
201: -- EARLISET CHANGE DATE FIELD
202: htp.tableRowOpen();
203: htp.p('Earliest Change Date');
204: htp.p('');
205: htp.p ('');
206: -- htp.FormSelectOption(' ');
207: FOR i IN 1..day_data.count LOOP

Line 204: htp.p('');

200: */
201: -- EARLISET CHANGE DATE FIELD
202: htp.tableRowOpen();
203: htp.p('Earliest Change Date');
204: htp.p('');
205: htp.p ('');

201: -- EARLISET CHANGE DATE FIELD
202: htp.tableRowOpen();
203: htp.p('Earliest Change Date');
204: htp.p('');
205: htp.p ('');
206: -- htp.FormSelectOption(' ');
207: FOR i IN 1..day_data.count LOOP
208: htp.FormSelectOption(day_data(i),
209: cattributes => ' value= '||day_data(i),
210: cselected => 'TRUE' );

Line 208: htp.FormSelectOption(day_data(i),

204: htp.p('');
205: htp.p ('');
216: htp.FormSelectOption('JAN',cselected => 'TRUE');

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

209: cattributes => ' value= '||day_data(i),
210: cselected => 'TRUE' );
211: END LOOP;
212: htp.FormSelectClose;
213: htp.p('-');
214:
215: htp.p ('');

211: END LOOP;
212: htp.FormSelectClose;
213: htp.p('-');
214:
215: htp.p ('');
216: htp.FormSelectOption('JAN',cselected => 'TRUE');
217: htp.FormSelectOption('FEB');
218: htp.FormSelectOption('MAR');
219: htp.FormSelectOption('APR');
220: htp.FormSelectOption('MAY');

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

213: htp.p('-');
214:
215: htp.p ('');
216: htp.FormSelectOption('JAN',cselected => 'TRUE');
217: htp.FormSelectOption('FEB');
218: htp.FormSelectOption('MAR');
219: htp.FormSelectOption('APR');
220: htp.FormSelectOption('MAY');
221: htp.FormSelectOption('JUN');
222: htp.FormSelectOption('JUL');

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

215: htp.p ('');

Line 227: htp.FormSelectOption('DEC');

223: htp.FormSelectOption('AUG');
224: htp.FormSelectOption('SEP');
225: htp.FormSelectOption('OCT');
226: htp.FormSelectOption('NOV');
227: htp.FormSelectOption('DEC');
228: htp.FormSelectClose;
229: htp.p('-');
230: htp.p ('');
231: -- htp.FormSelectOption(' ');
232: FOR i IN 1..year_data.count LOOP

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

225: htp.FormSelectOption('OCT');
226: htp.FormSelectOption('NOV');
227: htp.FormSelectOption('DEC');
228: htp.FormSelectClose;
229: htp.p('-');
230: htp.p ('');

226: htp.FormSelectOption('NOV');
227: htp.FormSelectOption('DEC');
228: htp.FormSelectClose;
229: htp.p('-');
230: htp.p ('');
231: -- htp.FormSelectOption(' ');
232: FOR i IN 1..year_data.count LOOP
233: htp.FormSelectOption(year_data(i),
234: cattributes => ' value= '||year_data(i));
235: END LOOP;

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

229: htp.p('-');
230: htp.p ('');
245: -- htp.FormSelectOption(' ');

Line 242: htp.p('Latest Change Date');

238: htp.tableRowClose;
239:
240: -- LATEST CHANGE DATE FIELD
241: htp.tableRowOpen();
242: htp.p('Latest Change Date');
243: htp.p('');
244: htp.p ('');
245: -- htp.FormSelectOption(' ');
246: FOR i IN 1..day_data.count LOOP
247: htp.FormSelectOption(day_data(i),

Line 244: htp.p ('');
245: -- htp.FormSelectOption(' ');
246: FOR i IN 1..day_data.count LOOP
247: htp.FormSelectOption(day_data(i),
248: cattributes => ' value= '||day_data(i),

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

241: htp.tableRowOpen();
242: htp.p('Latest Change Date');
243: htp.p('');
244: htp.p ('');
245: -- htp.FormSelectOption(' ');
246: FOR i IN 1..day_data.count LOOP
247: htp.FormSelectOption(day_data(i),
248: cattributes => ' value= '||day_data(i),
249: cselected => 'TRUE' );
250: END LOOP;
251: htp.FormSelectClose;

Line 251: htp.FormSelectClose;

247: htp.FormSelectOption(day_data(i),
248: cattributes => ' value= '||day_data(i),
249: cselected => 'TRUE' );
250: END LOOP;
251: htp.FormSelectClose;
252: htp.p('-');
253:
254: htp.p ('');
255: htp.FormSelectOption('JAN',cselected => 'TRUE');
256: htp.FormSelectOption('FEB');

Line 254: htp.p ('');
255: htp.FormSelectOption('JAN',cselected => 'TRUE');
256: htp.FormSelectOption('FEB');
257: htp.FormSelectOption('MAR');
258: htp.FormSelectOption('APR');

Line 255: htp.FormSelectOption('JAN',cselected => 'TRUE');

251: htp.FormSelectClose;
252: htp.p('-');
253:
254: htp.p ('');
255: htp.FormSelectOption('JAN',cselected => 'TRUE');
256: htp.FormSelectOption('FEB');
257: htp.FormSelectOption('MAR');
258: htp.FormSelectOption('APR');
259: htp.FormSelectOption('MAY');
260: htp.FormSelectOption('JUN');

Line 257: htp.FormSelectOption('MAR');

253:
254: htp.p ('');
255: htp.FormSelectOption('JAN',cselected => 'TRUE');
256: htp.FormSelectOption('FEB');
257: htp.FormSelectOption('MAR');
258: htp.FormSelectOption('APR');
259: htp.FormSelectOption('MAY');
260: htp.FormSelectOption('JUN');
261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');

Line 259: htp.FormSelectOption('MAY');

255: htp.FormSelectOption('JAN',cselected => 'TRUE');
256: htp.FormSelectOption('FEB');
257: htp.FormSelectOption('MAR');
258: htp.FormSelectOption('APR');
259: htp.FormSelectOption('MAY');
260: htp.FormSelectOption('JUN');
261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');

Line 260: htp.FormSelectOption('JUN');

256: htp.FormSelectOption('FEB');
257: htp.FormSelectOption('MAR');
258: htp.FormSelectOption('APR');
259: htp.FormSelectOption('MAY');
260: htp.FormSelectOption('JUN');
261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');
264: htp.FormSelectOption('OCT');

Line 261: htp.FormSelectOption('JUL');

257: htp.FormSelectOption('MAR');
258: htp.FormSelectOption('APR');
259: htp.FormSelectOption('MAY');
260: htp.FormSelectOption('JUN');
261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');
264: htp.FormSelectOption('OCT');
265: htp.FormSelectOption('NOV');

Line 262: htp.FormSelectOption('AUG');

258: htp.FormSelectOption('APR');
259: htp.FormSelectOption('MAY');
260: htp.FormSelectOption('JUN');
261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');
264: htp.FormSelectOption('OCT');
265: htp.FormSelectOption('NOV');
266: htp.FormSelectOption('DEC');

Line 263: htp.FormSelectOption('SEP');

259: htp.FormSelectOption('MAY');
260: htp.FormSelectOption('JUN');
261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');
264: htp.FormSelectOption('OCT');
265: htp.FormSelectOption('NOV');
266: htp.FormSelectOption('DEC');
267: htp.FormSelectClose;

Line 264: htp.FormSelectOption('OCT');

260: htp.FormSelectOption('JUN');
261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');
264: htp.FormSelectOption('OCT');
265: htp.FormSelectOption('NOV');
266: htp.FormSelectOption('DEC');
267: htp.FormSelectClose;
268: htp.p('-');

Line 265: htp.FormSelectOption('NOV');

261: htp.FormSelectOption('JUL');
262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');
264: htp.FormSelectOption('OCT');
265: htp.FormSelectOption('NOV');
266: htp.FormSelectOption('DEC');
267: htp.FormSelectClose;
268: htp.p('-');
269:

Line 266: htp.FormSelectOption('DEC');

262: htp.FormSelectOption('AUG');
263: htp.FormSelectOption('SEP');
264: htp.FormSelectOption('OCT');
265: htp.FormSelectOption('NOV');
266: htp.FormSelectOption('DEC');
267: htp.FormSelectClose;
268: htp.p('-');
269:
270: htp.p ('');
271: -- htp.FormSelectOption(' ');

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

264: htp.FormSelectOption('OCT');
265: htp.FormSelectOption('NOV');
266: htp.FormSelectOption('DEC');
267: htp.FormSelectClose;
268: htp.p('-');
269:
270: htp.p ('');

266: htp.FormSelectOption('DEC');
267: htp.FormSelectClose;
268: htp.p('-');
269:
270: htp.p ('');
271: -- htp.FormSelectOption(' ');
272: FOR i IN 1..year_data.count LOOP
273: htp.FormSelectOption(year_data(i),
274: cattributes => ' value= '||year_data(i));
275: END LOOP;

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

269:
270: htp.p ('');

Line 308: htp.p('');

304: htp.tableRowOpen;
305: htp.formOpen( curl => l_agent||'/JTF_TERR_CHANGES_report_PVT.report_wrapper', cmethod => 'GET',
306: cattributes => ' NAME="MyForm" TARGET="_top"');
307:
308: htp.p('');
309: htp.p('');
310: htp.p('');
311: htp.tableData( '');
312: htp.tableRowClose;

Line 309: htp.p('');

305: htp.formOpen( curl => l_agent||'/JTF_TERR_CHANGES_report_PVT.report_wrapper', cmethod => 'GET',
306: cattributes => ' NAME="MyForm" TARGET="_top"');
307:
308: htp.p('');
309: htp.p('');
310: htp.p('');
311: htp.tableData( '');
312: htp.tableRowClose;
313: htp.tableClose;

Line 310: htp.p('');

306: cattributes => ' NAME="MyForm" TARGET="_top"');
307:
308: htp.p('');
309: htp.p('');
310: htp.p('');
311: htp.tableData( '');
312: htp.tableRowClose;
313: htp.tableClose;
314: htp.htmlClose;

Line 311: htp.tableData( '');

307:
308: htp.p('');
309: htp.p('');
310: htp.p('');
311: htp.tableData( '');
312: htp.tableRowClose;
313: htp.tableClose;
314: htp.htmlClose;
315: END footer;

Line 312: htp.tableRowClose;

308: htp.p('');
309: htp.p('');
310: htp.p('');
311: htp.tableData( '');
312: htp.tableRowClose;
313: htp.tableClose;
314: htp.htmlClose;
315: END footer;
316: END;

Line 313: htp.tableClose;

309: htp.p('');
310: htp.p('');
311: htp.tableData( '');
312: htp.tableRowClose;
313: htp.tableClose;
314: htp.htmlClose;
315: END footer;
316: END;

Line 314: htp.htmlClose;

310: htp.p('');
311: htp.tableData( '');
312: htp.tableRowClose;
313: htp.tableClose;
314: htp.htmlClose;
315: END footer;
316: END;