APPS.ICX_REQ_CATEGORIES dependencies on ICX_REQ_CATEGORIES

Line 1: PACKAGE BODY ICX_REQ_CATEGORIES as

1: PACKAGE BODY ICX_REQ_CATEGORIES as
2: /* $Header: ICXRQCAB.pls 115.4 99/07/17 03:22:45 porting sh $ */
3:
4: --*********************************************************
5: -- GLOBAL VAR

Line 28: htp.formOpen(curl =>'ICX_REQ_CATEGORIES.GetCategoryChildren',

24: else
25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
26: end if;
27:
28: htp.formOpen(curl =>'ICX_REQ_CATEGORIES.GetCategoryChildren',
29: cmethod => 'POST',
30: cattributes => 'name=''GetChildren'''
31: );
32:

Line 151: v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || p_where -- Node Link

147: end if;
148:
149: htp.p('TOP_CATEGORIES[' || counter || ']= new node(' || v_node_id || ',"' ||
150: v_name || '",' || v_children_loaded || ',"' ||
151: v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || p_where -- Node Link
152: || '","' || p_where || '");');
153: counter := counter + 1;
154:
155: end loop; -- end i

Line 160: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',

156:
157: else -- No hierchy setup use regular categories
158:
159: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
160: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
161: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
162: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
163: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',
164:

Line 182: v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || p_where -- Node Link

178:
179: v_children_loaded := 'true';
180: htp.p('TOP_CATEGORIES[' || counter || ']= new node(' || v_node_id || ',"' ||
181: v_name || '",' || v_children_loaded || ',"' ||
182: v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || p_where -- Node Link
183: || '","' || p_where || '");');
184: counter := counter + 1;
185:
186: end loop;

Line 224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL

220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL
225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL
226: cname => 'dummy', --Window Name
227: cmarginwidth => '0', -- Value in pixels
228: cmarginheight => '0', -- Value in pixels

Line 225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL

221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL
225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL
226: cname => 'dummy', --Window Name
227: cmarginwidth => '0', -- Value in pixels
228: cmarginheight => '0', -- Value in pixels
229: cscrolling => 'NO',

Line 236: v_frame_location := v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?';

232: -- cscrolling => 'NO',-- yes | no | auto
233: -- cnoresize => 'NORESIZE' );
234: htp.framesetClose;
235:
236: v_frame_location := v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?';
237:
238: if c_end_row is not null then
239: v_frame_location := v_frame_location || 'p_start_row=' || start_row ||'&p_end_row=' || c_end_row || '&p_where=' || p_where;
240: else

Line 358: || v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || v_p_where -- Node Link

354: and RELATIONSHIP_TYPE <> 'TOP';
355:
356: childrenString := childrenString || v_node_id || '~~' || v_name || '~~'
357: || v_no_of_children || '~~'
358: || v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || v_p_where -- Node Link
359: || '~~' || v_p_where || '~~' ;
360:
361:
362: end loop; -- end i

Line 457: '/ICX_REQ_CATEGORIES.catalog_items?p_start_row=' || p_start_row || '&p_end_row=' || p_end_row || '&p_where=' || p_where || '">' || l_href1 || '';

453: l_href1 := FND_MESSAGE.GET;
454: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT');
455: l_href2 := FND_MESSAGE.GET;
456: l_messg := '';
458:
459: /* find next set start row and next set end row */
460: if end_row < p_row_count
461: and p_query_set is not NULL then

Line 472: '/ICX_REQ_CATEGORIES.catalog_items?p_start_row=' || next_start_row || '&p_end_row=' || next_end_row || '&p_where=' || p_where || '">' || l_href2 || '';

468: end if;
469:
470:
471: l_messg := l_messg || '

';
473:
474: end if;
475:
476: -- MESSAGE NEEDS TO BE SWITCHED TO REVIEW MY ORDER

Line 743: '/ICX_REQ_CATEGORIES.catalog_items_buttons?p_start_row=" +

739: js.scriptOpen;
740: htp.p('function openButWin(start_row, end_row, total_row, where) {
741:
742: var result = "' || v_dcdName ||
743: '/ICX_REQ_CATEGORIES.catalog_items_buttons?p_start_row=" +
744: start_row + "&p_end_row=" + end_row + "&p_total_rows=" +
745: total_row + "&p_where=" + where;
746: open(result, ''k_buttons'');
747: }

Line 754: '/ICX_REQ_CATEGORIES.catalog_items_display?p_start_row=' ||

750: js.scriptClose;
751:
752: htp.p('');
753: htp.p('');
757:
758: htp.p('');

977: ';parent.openButWin('|| p_start_row || ',' ||
978: end_row || ',' || total_rows || ',' || p_where || ');"');
979: htp.br;
980:
981: htp.p('

');
982:
983: htp.formHidden('cartId','');
984: htp.formHidden('p_emergency','');
985: js.scriptOpen;

Line 1189: end ICX_REQ_CATEGORIES;

1185: --**********************************************************
1186:
1187:
1188:
1189: end ICX_REQ_CATEGORIES;

			' || '' || l_href1 || '
			' || '' || l_href2 || '