1: PACKAGE BODY ICX_REQ_TEMPLATES as
2: /* $Header: ICXRQTMB.pls 115.3 99/07/17 03:23:36 porting sh $ */
3:
4: --**********************************************************
5: -- LOCAL PROCEDURES NOT DECLARED IN SPEC
19: else
20: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
21: end if;
22:
23: htp.formOpen(curl =>'ICX_REQ_TEMPLATES.GetTemplateChildren',
24: cmethod => 'POST',
25: cattributes => 'name=''GetChildren'''
26: );
27:
193: end if;
194:
195: htp.p('TOP_TEMPLATES[' || counter || ']= new node("' || v_node_id || '","' ||
196: v_name || '",' || v_children_loaded || ',"' ||
197: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
198: || '","' || p_where || '");');
199: counter := counter + 1;
200:
201: end loop; -- end i
225:
226: htp.comment(where_clause);
227:
228: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
229: P_PARENT_REGION_CODE => 'ICX_REQ_TEMPLATES',
230: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
231: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
232: P_WHERE_CLAUSE => where_clause,
233: P_RETURN_PARENTS => 'T',
252:
253: v_children_loaded := 'true';
254: htp.p('TOP_TEMPLATES[' || counter || ']= new node("' || v_node_id || '","' ||
255: v_name || '",' || v_children_loaded || ',"' ||
256: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
257: || '","' || p_where || '");');
258: counter := counter + 1;
259:
260: end loop;
293: htp.p('for (var i = 1; i <= ' || to_char(counter - 1) || '; i ++) {'
294: || 'new_TOP_TEMPLATES[i] = TOP_TEMPLATES[i]; }');
295: htp.p('new_TOP_TEMPLATES[' || counter || ']= new node("' || v_default_template || '","' ||
296: v_default_template || '",' || v_children_loaded || ',"' ||
297: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
298: || '","' || p_where || '");');
299: htp.p('TOP_TEMPLATES = new MakeArray(' || counter || ');');
300: htp.p('for (var i = 1; i <= ' || to_char(counter) || '; i ++) {'
301: || 'TOP_TEMPLATES[i] = new_TOP_TEMPLATES[i];}');
332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');
335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');
336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL
337: cname => 'dummy', --Window Name
338: cmarginwidth => '0', -- Value in pixels
339: cmarginheight => '0', -- Value in pixels
340: -- cscrolling => 'NO',-- yes | no | auto
340: -- cscrolling => 'NO',-- yes | no | auto
341: cattributes => 'FRAMEBORDER=NO');
342: htp.framesetClose;
343:
344: v_frame_location := v_dcdName || '/ICX_REQ_TEMPLATES.template_items?';
345:
346: if c_end_row is not null then
347: v_frame_location := v_frame_location || 'p_start_row=' || start_row ||'&p_end_row=' || c_end_row || '&p_where=' || p_where;
348: else
554:
555:
556: /* desmond -- for beta 1 show default template as a leaf displaying from parent tree and no emergency po case */
557: -- if v_node_id = get_default_template('NO') then
558: -- childrenString := childrenString || v_node_id || '~~' || v_name || '~~' || '0' || '~~' || v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || v_p_where || '~~' || v_p_where || '~~';
559: -- else
560:
561: childrenString := childrenString || v_node_id || '~~' || v_name || '~~' || v_no_of_children || '~~'|| v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || v_p_where -- Node Link
562: || '~~' || v_p_where || '~~' ;
557: -- if v_node_id = get_default_template('NO') then
558: -- childrenString := childrenString || v_node_id || '~~' || v_name || '~~' || '0' || '~~' || v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || v_p_where || '~~' || v_p_where || '~~';
559: -- else
560:
561: childrenString := childrenString || v_node_id || '~~' || v_name || '~~' || v_no_of_children || '~~'|| v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || v_p_where -- Node Link
562: || '~~' || v_p_where || '~~' ;
563: -- end if;
564:
565:
622: js.scriptOpen;
623: htp.p('function openButWin(start_row, end_row, total_row, where) {
624:
625: var result = "' || v_dcdName ||
626: '/ICX_REQ_TEMPLATES.template_items_buttons?p_start_row=" +
627: start_row + "&p_end_row=" + end_row + "&p_total_rows=" +
628: total_row + "&p_where=" + where;
629: open(result, ''k_buttons'');
630: }
632:
633: js.scriptClose;
634: htp.p('