The following lines contain the word 'select', 'insert', 'update' or 'delete':
v_rows_inserted IN VARCHAR2 DEFAULT NULL,
v_order_total_message IN VARCHAR2 DEFAULT NULL) IS
------------------------------------------------------------
v_dcdName varchar2(1000);
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 (+);
SELECT unit_of_measure, uom_code
FROM mtl_units_of_measure
WHERE NVL( disable_date, SYSDATE+1) > SYSDATE
ORDER BY unit_of_measure;
SELECT category_set_id,
validate_flag
FROM mtl_default_sets_view
WHERE functional_area_id = 2;
v_select_text LONG := NULL;
FND_MESSAGE.SET_NAME('ICX', 'ICX_SELECT_CATG_ENT');
IF (to_number(v_rows_inserted) > 0 ) THEN
FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY', v_rows_inserted);
v_select_text := '';
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 || ' ');
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
v_select_text := v_select_text || '
htp.tableData((htf.formSelectOpen(v_items_table(i).attribute_code) || v_select_text || htf.formSelectClose), 'LEFT');
/* 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 || '
v_select_text := v_select_text || '
htp.tableData((htf.formSelectOpen(v_items_table(i).attribute_code) || v_select_text || htf.formSelectClose), 'LEFT');
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');
v_rows_inserted VARCHAR2(3) := NULL;
v_qty_inserted VARCHAR2(3) := NULL;
SELECT category_id
FROM mtl_categories_kfv
WHERE concatenated_segments = catname;
SELECT unit_of_measure
FROM mtl_units_of_measure
WHERE unit_of_measure = v_uom;
insert_order_to_cart_line (v_special_order_rec, l_order_total_message);
v_rows_inserted := '1'; /* Number of lines added; one in this case */
special_order_display(n_org, v_rows_inserted => v_rows_inserted,
v_order_total_message => l_order_total_message);
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;
SELECT * FROM icx_shopping_carts
WHERE CART_ID = to_number(v_cart_id)
FOR UPDATE;
SELECT line_type_id INTO v_line_type_id
FROM po_system_parameters
WHERE rownum < 2;
SELECT PO_REQUISITION_LINES_S.nextval INTO l_cart_line_id
FROM DUAL;
/* 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;
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
);
SELECT SUM(quantity * unit_price) INTO l_order_total
FROM icx_shopping_cart_lines
WHERE cart_id = v_cart_id;
END insert_order_to_cart_line;
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';