APPS.ICX_REQ_SPECIAL_ORD dependencies on ICX_REQ_SPECIAL_ORD

Line 1: PACKAGE BODY icx_req_special_ord AS

1: PACKAGE BODY icx_req_special_ord AS
2: /* $Header: ICXRQSPB.pls 115.3 99/07/17 03:23:29 porting sh $ */
3:
4: ------------------------------------------------------------
5: PROCEDURE special_order(n_org VARCHAR2,

Line 24: '/ICX_REQ_special_ord.special_order_display?n_org=' ||

20:
21: -- We need to split into 2 frames
22: htp.p('');
23: htp.p('');
27:
28: htp.p('');

25: n_org ||
26: '" NAME="data" FRAMEBORDER=NO MARGINWIDTH=0 MARGINHEIGHT=0 NORESIZE>');
27:
28: htp.p('');
30: htp.p('');
31:
32: exception
33: when others then

Line 157: P_PARENT_REGION_CODE => 'ICX_REQ_SPECIAL_ORDER',

153: -- Just get the structure, NO DATA i.e. P_RETURN_PARENTS => 'F'
154:
155: -- (MC) Use exec_query instead of execute_query to improve performance
156: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
157: P_PARENT_REGION_CODE => 'ICX_REQ_SPECIAL_ORDER',
158: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
159: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
160: P_RETURN_PARENTS => 'F',
161: P_RETURN_CHILDREN => 'F');

Line 272: htp.p('

');

268: htp.tableRowClose;
269: htp.tableClose;
270: END IF;
271:
272: htp.p('');
273:
274: htp.formHidden('n_org', n_org);
275: htp.formHidden('cartId', '');
276:

Line 473: htp.tableData(icx_util.LOVButton(178,'ICX_CATEGORY_NAME', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data','FUNCTIONAL_AREA_ID = 2'), CATTRIBUTES => 'ALIGN="LEFT" width=200');

469: END IF;
470:
471: IF (v_items_table(i).attribute_code = 'ICX_CATEGORY_NAME' AND
472: UPPER(v_items_table(i).item_style) = 'TEXT') THEN
473: htp.tableData(icx_util.LOVButton(178,'ICX_CATEGORY_NAME', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data','FUNCTIONAL_AREA_ID = 2'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
474: ELSIF (v_items_table(i).attribute_code = 'ICX_UNIT_OF_MEASUREMENT'
475: AND UPPER(v_items_table(i).item_style) = 'TEXT') THEN
476: htp.tableData(icx_util.LOVButton(178,'ICX_UNIT_OF_MEASUREMENT', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
477: ELSIF v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME'

Line 476: htp.tableData(icx_util.LOVButton(178,'ICX_UNIT_OF_MEASUREMENT', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');

472: UPPER(v_items_table(i).item_style) = 'TEXT') THEN
473: htp.tableData(icx_util.LOVButton(178,'ICX_CATEGORY_NAME', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data','FUNCTIONAL_AREA_ID = 2'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
474: ELSIF (v_items_table(i).attribute_code = 'ICX_UNIT_OF_MEASUREMENT'
475: AND UPPER(v_items_table(i).item_style) = 'TEXT') THEN
476: htp.tableData(icx_util.LOVButton(178,'ICX_UNIT_OF_MEASUREMENT', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
477: ELSIF v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME'
478: AND v_vendor_on_flag = 'Y' THEN
479: htp.tableData(icx_util.LOVButton(178,'ICX_SUGGESTED_VENDOR_NAME', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
480: ELSIF v_items_table(i).lov_attribute_code is not NULL AND

Line 479: htp.tableData(icx_util.LOVButton(178,'ICX_SUGGESTED_VENDOR_NAME', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');

475: AND UPPER(v_items_table(i).item_style) = 'TEXT') THEN
476: htp.tableData(icx_util.LOVButton(178,'ICX_UNIT_OF_MEASUREMENT', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
477: ELSIF v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME'
478: AND v_vendor_on_flag = 'Y' THEN
479: htp.tableData(icx_util.LOVButton(178,'ICX_SUGGESTED_VENDOR_NAME', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
480: ELSIF v_items_table(i).lov_attribute_code is not NULL AND
481: v_items_table(i).lov_region_code is not NULL AND
482: v_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' AND
483: v_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' AND

Line 490: htp.tableData(icx_util.LOVButton(178,v_items_table(i).attribute_code, 601, 'ICX_REQ_SPECIAL_ORDER','one_time','data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');

486: v_items_table(i).node_display_flag = 'Y' AND
487: v_items_table(i).update_flag = 'Y' AND
488: v_items_table(i).item_style <> 'HIDDEN' AND
489: v_items_table(i).item_style <> 'POPLIST' THEN
490: htp.tableData(icx_util.LOVButton(178,v_items_table(i).attribute_code, 601, 'ICX_REQ_SPECIAL_ORDER','one_time','data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
491:
492: END IF;
493: htp.tableRowClose;
494: END IF;

Line 950: END icx_req_special_ord;

946: end loop;
947:
948: v_on := v_vendor_on_flag;
949: end chk_vendor_on;
950: END icx_req_special_ord;