DBA Data[Home] [Help]

APPS.ICX_REQ_TEMPLATES dependencies on ICX_REQ_TEMPLATES

Line 1: PACKAGE BODY ICX_REQ_TEMPLATES as

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

Line 23: htp.formOpen(curl =>'ICX_REQ_TEMPLATES.GetTemplateChildren',

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:

Line 197: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link

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

Line 229: P_PARENT_REGION_CODE => 'ICX_REQ_TEMPLATES',

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',

Line 256: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link

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;

Line 297: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link

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];}');

Line 336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL

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

Line 344: v_frame_location := v_dcdName || '/ICX_REQ_TEMPLATES.template_items?';

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

Line 558: -- childrenString := childrenString || v_node_id || '~~' || v_name || '~~' || '0' || '~~' || v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || v_p_where || '~~' || v_p_where || '~~';

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 || '~~' ;

Line 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

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:

Line 626: '/ICX_REQ_TEMPLATES.template_items_buttons?p_start_row=" +

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: }

Line 636: '/ICX_REQ_TEMPLATES.template_items_display?p_start_row=' ||

632:
633: js.scriptClose;
634: htp.p('');
635: htp.p('');
640:

Line 671: p_packproc => 'ICX_REQ_TEMPLATES.template_items',

667:
668: htp.p('');
669: htp.p('';

1551: htp.br; -- leave two line between the messages
1552: htp.br;
1553: htp.p(l_template_selected_message);
1554: l_navigation_message := '

');
670: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
671: p_packproc => 'ICX_REQ_TEMPLATES.template_items',
672: p_start_row => p_start_row,
673: p_stop_row => p_end_row,
674: p_encrypted_where => p_where,
675: p_query_set => c_query_size,

Line 878: htp.p('
');

874: htp.br;
875:
876:
877:
878: htp.p('');
879:
880: htp.formHidden('cartId','');
881: htp.formHidden('p_emergency','');
882: js.scriptOpen;

Line 1555: '/ICX_REQ_TEMPLATES.template_items?p_start_row=' || p_start_row || '&p_end_row=' || p_end_row || '&p_where=' || p_where || '">' || l_return_to_current_message || '
';
1556: /*
1557: htp.p('
');
1558: htp.p('
' || l_template_selected_message);
1559: htp.p('
');

Line 1560: htp.p('
' || '' || l_return_to_current_message || '');

1556: /*
1557: htp.p('

');
1558: htp.p('
' || l_template_selected_message);
1559: htp.p('
');
1560: htp.p('
' || '' || l_return_to_current_message || '');
1561: htp.p('
');
1562: */
1563:
1564: /* find next set start row and next set end row */

Line 1575: '/ICX_REQ_TEMPLATES.template_items?p_start_row=' || next_start_row || '&p_end_row=' || next_end_row || '&p_where=' || p_where || '">' || l_return_to_next_message || '';

1571: else
1572: next_end_row := end_row+p_query_set;
1573: end if;
1574: l_navigation_message := l_navigation_message || '

';
1576:
1577:
1578: /*
1579: htp.p('
');

Line 1580: htp.p('
' || '' || l_return_to_next_message || '');

1576:
1577:
1578: /*
1579: htp.p('

');
1580: htp.p('
' || '' || l_return_to_next_message || '');
1581:
1582: -- htp.p('
' || l_return_to_next_message);
1583: htp.p('
');
1584: */

Line 1615: end ICX_REQ_TEMPLATES;

1611: icx_util.add_error(substr(SQLERRM, 12, 512));
1612: icx_util.error_page_print;
1613: END total_page;
1614:
1615: end ICX_REQ_TEMPLATES;




' || '' || l_return_to_current_message || '



' || '' || l_return_to_next_message || '