APPS.ICX_REQ_SPECIAL_ORD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

                        v_rows_inserted IN VARCHAR2 DEFAULT NULL,
                        v_order_total_message IN VARCHAR2 DEFAULT NULL) IS
------------------------------------------------------------
v_dcdName            varchar2(1000);

Line: 73

                        v_rows_inserted IN VARCHAR2 DEFAULT NULL,
                        v_order_total_message IN VARCHAR2 DEFAULT NULL) IS
------------------------------------------------------------
  /* No defaults set at this point
  CURSOR defaults IS
  SELECT plt.category_id,
         nvl(mck.DESCRIPTION, mck.concatenated_segments) category_name,
	 plt.unit_of_measure,
	 psp.line_type_id
  FROM   po_line_types        plt,
	 po_system_parameters psp,
         mtl_categories_kfv   mck
  WHERE  plt.line_type_id = psp.line_type_id
  AND    plt.category_id = mck.category_id (+);

Line: 90

  SELECT unit_of_measure, uom_code
  FROM mtl_units_of_measure
  WHERE NVL( disable_date, SYSDATE+1) > SYSDATE
  ORDER BY unit_of_measure;

Line: 96

  SELECT category_set_id,
         validate_flag
  FROM   mtl_default_sets_view
  WHERE  functional_area_id = 2;

Line: 125

   v_select_text       LONG := NULL;

Line: 236

  FND_MESSAGE.SET_NAME('ICX', 'ICX_SELECT_CATG_ENT');

Line: 255

  IF (to_number(v_rows_inserted) > 0 ) THEN
     FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');

Line: 257

     FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY', v_rows_inserted);

Line: 285

    v_select_text := '';

Line: 407

          ELSIF v_items_table(i).update_flag = 'Y' OR
                v_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION' or
                v_items_table(i).attribute_code = 'ICX_QTY_V' or
                v_items_table(i).attribute_code = 'ICX_UNIT_OF_MEASUREMENT' or
                v_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or
                v_items_table(i).attribute_code = 'ICX_CATEGORY_NAME' or
                (v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME'
                 AND v_vendor_on_flag = 'Y') THEN

              htp.p(' ' || v_items_table(i).attribute_label_long || '');

Line: 419

                 SELECT list box */
              IF v_items_table(i).attribute_code = 'ICX_CATEGORY_NAME' AND
                 UPPER(v_items_table(i).item_style) = 'POPLIST' THEN

                   -- No Hierarchy setup; show regular categories

Line: 440

                       v_select_text := v_select_text  || '' || v_category_name;

Line: 443

                 htp.tableData((htf.formSelectOpen(v_items_table(i).attribute_code) || v_select_text || htf.formSelectClose), 'LEFT');

Line: 450

                   /* if there is error, set the selected unit of measure in the
                      select list */
                   IF (v_error_flag = 'Y') AND
                      (uom_rec.unit_of_measure = v_special_order_rec.unit_of_measurement) THEN
                       v_select_text := v_select_text  || '' || uom_rec.unit_of_measure;

Line: 456

                       v_select_text := v_select_text  || '' || uom_rec.unit_of_measure;

Line: 460

                 htp.tableData((htf.formSelectOpen(v_items_table(i).attribute_code) || v_select_text || htf.formSelectClose), 'LEFT');

Line: 487

                 v_items_table(i).update_flag = 'Y' AND
                 v_items_table(i).item_style <> 'HIDDEN' AND
                 v_items_table(i).item_style <> 'POPLIST' THEN
               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');

Line: 578

 v_rows_inserted VARCHAR2(3) := NULL;

Line: 579

 v_qty_inserted VARCHAR2(3) := NULL;

Line: 586

 SELECT category_id
 FROM mtl_categories_kfv
 WHERE concatenated_segments = catname;

Line: 591

 SELECT unit_of_measure
 FROM mtl_units_of_measure
 WHERE unit_of_measure = v_uom;

Line: 714

   insert_order_to_cart_line (v_special_order_rec, l_order_total_message);

Line: 716

   v_rows_inserted := '1'; /* Number of lines added; one in this case */

Line: 717

   special_order_display(n_org, v_rows_inserted => v_rows_inserted,
                 v_order_total_message => l_order_total_message);

Line: 736

PROCEDURE  insert_order_to_cart_line (v_special_order_rec  IN
                                       special_order_record,
                                      l_order_total_message OUT VARCHAR2) IS

 v_cart_header_rec  icx_shopping_carts%ROWTYPE;

Line: 762

 SELECT * FROM icx_shopping_carts
 WHERE CART_ID = to_number(v_cart_id)
 FOR UPDATE;

Line: 770

  SELECT line_type_id  INTO v_line_type_id
  FROM po_system_parameters
  WHERE rownum < 2;

Line: 783

  SELECT PO_REQUISITION_LINES_S.nextval INTO l_cart_line_id
  FROM DUAL;

Line: 787

  /* Select the max of the cart_line_number for ordering */
  SELECT max(cart_line_number) + 1 into v_cart_line_number
  FROM icx_shopping_cart_lines
  WHERE cart_id = v_cart_id;

Line: 797

  INSERT INTO icx_shopping_cart_lines
             (
              CART_LINE_ID,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              CREATION_DATE,
              CREATED_BY,
              CART_ID,
              ITEM_DESCRIPTION,
              QUANTITY,
              UNIT_PRICE,
              CATEGORY_ID,
              UNIT_OF_MEASURE,
              LINE_TYPE_ID,
              DESTINATION_ORGANIZATION_ID,
              DELIVER_TO_LOCATION_ID,
              SUGGESTED_VENDOR_NAME,
              SUGGESTED_VENDOR_SITE,
              LINE_ATTRIBUTE1,
              LINE_ATTRIBUTE2,
              LINE_ATTRIBUTE3,
              LINE_ATTRIBUTE4,
              LINE_ATTRIBUTE5,
              LINE_ATTRIBUTE6,
              LINE_ATTRIBUTE7,
              LINE_ATTRIBUTE8,
              LINE_ATTRIBUTE9,
              LINE_ATTRIBUTE10,
              LINE_ATTRIBUTE11,
              LINE_ATTRIBUTE12,
              LINE_ATTRIBUTE13,
              LINE_ATTRIBUTE14,
              LINE_ATTRIBUTE15,
              NEED_BY_DATE,
              SUGGESTED_VENDOR_CONTACT,
              SUGGESTED_VENDOR_PHONE,
              SUGGESTED_VENDOR_ITEM_NUM,
              SUPPLIER_ITEM_NUM,
              ORG_ID,
              DELIVER_TO_LOCATION,
              CUSTOM_DEFAULTED,
              CART_LINE_NUMBER
             )
     VALUES  (
              l_cart_line_id,
              sysdate,
              v_cart_header_rec.created_by,
              sysdate,
              v_cart_header_rec.created_by,
              v_cart_id,
              v_special_order_rec.item_description,
              to_number(v_special_order_rec.qty_v),
              to_number(v_special_order_rec.unit_price),
              to_number(v_special_order_rec.category_id),
              v_special_order_rec.unit_of_measurement,
              v_line_type_id,
              v_cart_header_rec.destination_organization_id,
              v_cart_header_rec.deliver_to_location_id,
              v_special_order_rec.suggested_vendor_name,
              v_special_order_rec.suggested_vendor_site,
              v_special_order_rec.line_attribute_1,
              v_special_order_rec.line_attribute_2,
              v_special_order_rec.line_attribute_3,
              v_special_order_rec.line_attribute_4,
              v_special_order_rec.line_attribute_5,
              v_special_order_rec.line_attribute_6,
              v_special_order_rec.line_attribute_7,
              v_special_order_rec.line_attribute_8,
              v_special_order_rec.line_attribute_9,
              v_special_order_rec.line_attribute_10,
              v_special_order_rec.line_attribute_11,
              v_special_order_rec.line_attribute_12,
              v_special_order_rec.line_attribute_13,
              v_special_order_rec.line_attribute_14,
              v_special_order_rec.line_attribute_15,
              v_cart_header_rec.need_by_date,
              v_special_order_rec.suggested_vendor_contact,
              v_special_order_rec.suggested_vendor_phone,
              v_special_order_rec.suggested_vendor_item_num,
              v_special_order_rec.suggested_vendor_item_num,
              v_cart_header_rec.org_id,
              v_cart_header_rec.deliver_to_location,
              'N',
              v_cart_line_number
            );

Line: 898

  SELECT SUM(quantity * unit_price) INTO l_order_total
  FROM  icx_shopping_cart_lines
  WHERE cart_id = v_cart_id;

Line: 919

END insert_order_to_cart_line;

Line: 939

          v_items_table(i).update_flag = 'Y' AND
          v_items_table(i).secured_column <> 'T' AND
          v_items_table(i).item_style <> 'HIDDEN' then

           v_vendor_on_flag := 'Y';