115: List_OM_Plans(plan_tab, pk1, null);
116: end if; -- end icx validate session
117: EXCEPTION
118: WHEN OTHERS THEN
119: htp.p('Exception in procedure om_headers_to_quality');
120: htp.p(SQLERRM);
121:
122: END om_header_to_quality;
123:
116: end if; -- end icx validate session
117: EXCEPTION
118: WHEN OTHERS THEN
119: htp.p('Exception in procedure om_headers_to_quality');
120: htp.p(SQLERRM);
121:
122: END om_header_to_quality;
123:
124: ------------------------------------------------------------------------------------------
182:
183: end if; -- end icx validate session
184: EXCEPTION
185: WHEN OTHERS THEN
186: htp.p('Exception in procedure om_lines_to_quality');
187: htp.p(SQLERRM);
188:
189: END om_lines_to_quality;
190:
183: end if; -- end icx validate session
184: EXCEPTION
185: WHEN OTHERS THEN
186: htp.p('Exception in procedure om_lines_to_quality');
187: htp.p(SQLERRM);
188:
189: END om_lines_to_quality;
190:
191: ------------------------------------------------------------------------------------------
208: BEGIN
209: if (icx_sec.validatesession) then
210: l_language_code := icx_sec.getid(icx_sec.pv_language_code);
211:
212: htp.htmlOpen;
213: htp.p('
209: if (icx_sec.validatesession) then
210: l_language_code := icx_sec.getid(icx_sec.pv_language_code);
211:
212: htp.htmlOpen;
213: htp.p('');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
210: l_language_code := icx_sec.getid(icx_sec.pv_language_code);
211:
212: htp.htmlOpen;
213: htp.p('
211:
212: htp.htmlOpen;
213: htp.p('
212: htp.htmlOpen;
213: htp.p('
213: htp.p('
');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '', calign=>'CENTER');
222: htp.tableHeader(cvalue=>''||
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '', calign=>'CENTER');
222: htp.tableHeader(cvalue=>''||
223: fnd_message.get_string('QA', 'QA_SS_DESC'), calign=>'CENTER');
224: htp.tableHeader(cvalue=>''||
225: 'Type'|| '', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '
222: htp.tableHeader(cvalue=>''||
223: fnd_message.get_string('QA', 'QA_SS_DESC'), calign=>'CENTER');
224: htp.tableHeader(cvalue=>''||
225: 'Type'|| '', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||
227: fnd_message.get_string('QA', 'QA_SS_VIEW_BUTTON')|| '', calign=>'CENTER');
228: htp.tableRowClose;
229: htp.p('
224: htp.tableHeader(cvalue=>''||
225: 'Type'|| '', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||
227: fnd_message.get_string('QA', 'QA_SS_VIEW_BUTTON')|| '', calign=>'CENTER');
228: htp.tableRowClose;
229: htp.p('
225: 'Type'|| '
', calign=>'CENTER');
256: pdesc := NVL(substr(plan_tab(i).description,1,20), ' ');
257: ptype := NVL(substr(plan_tab(i).meaning,1,20), ' ');
258:
259: IF (row_color = 'BLUE') THEN
260: htp.tableRowOpen(cattributes=>'BGCOLOR="#99CCFF"');
261: row_color := 'WHITE';
262: ELSE
263: htp.tableRowOpen(cattributes=>'BGCOLOR="#FFFFFF"');
264: row_color := 'BLUE';
259: IF (row_color = 'BLUE') THEN
260: htp.tableRowOpen(cattributes=>'BGCOLOR="#99CCFF"');
261: row_color := 'WHITE';
262: ELSE
263: htp.tableRowOpen(cattributes=>'BGCOLOR="#FFFFFF"');
264: row_color := 'BLUE';
265: END IF; -- end if for row color
266:
267: htp.tableData(pname);
263: htp.tableRowOpen(cattributes=>'BGCOLOR="#FFFFFF"');
264: row_color := 'BLUE';
265: END IF; -- end if for row color
266:
267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
264: row_color := 'BLUE';
265: END IF; -- end if for row color
266:
267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:
265: END IF; -- end if for row color
266:
267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:
273:
267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:
273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:
273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:
272:
273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:
280: end if; -- end icx validate session
273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:
280: end if; -- end icx validate session
281:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:
280: end if; -- end icx validate session
281:
282: EXCEPTION
280: end if; -- end icx validate session
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: htp.p('Exception in procedure qa_ss_om.list_om_plans');
285: htp.p(SQLERRM);
286:
287: END List_OM_Plans;
288:
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: htp.p('Exception in procedure qa_ss_om.list_om_plans');
285: htp.p(SQLERRM);
286:
287: END List_OM_Plans;
288:
289: