[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select attribute_code
from ak_excluded_items
where responsibility_id = resp_id
and resp_application_id = appl_id
and attribute_code = attr_code;
select category_set_id,
validate_flag
from mtl_default_sets_view
WHERE functional_area_id = 2;
select count(-1) into v_no_of_children
from icx_related_categories_val_v
where CATEGORY_ID = v_node_id
and CATEGORY_SET_ID = v_category_set_id /* new*/
and RELATIONSHIP_TYPE <> 'TOP';
select category_set_id,
validate_flag
from mtl_default_sets_view
WHERE functional_area_id = 2;
select category_id
from icx_related_categories_val_v
where relationship_type = 'TOP'
and category_set_id = v_category_set_id;
select count(-1) into v_no_of_children
from icx_related_categories_val_v
where CATEGORY_ID = v_node_id
and CATEGORY_SET_ID = v_cat_set_id
and RELATIONSHIP_TYPE <> 'TOP';
l_rows_updated number default 0,
p_cat_name varchar2 default NULL,
p_start_row IN number default 1,
p_end_row IN number default NULL,
p_where IN varchar2,
end_row IN number default null,
p_query_set IN number default null,
p_row_count IN number default null) is
l_message varchar2(2000);
select sum(quantity * unit_price) total_price
from icx_shopping_cart_lines
where cart_id = v_cart_id;
if l_rows_updated > 0 then
FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
select cart_line_id
from icx_shopping_cart_lines
where cart_id = v_cart_id
and line_id = v_line_id
and nvl(org_id, -9999) = nvl(v_org_id,-9999);
select need_by_date,
deliver_to_requestor_id,
deliver_to_location_id,
deliver_to_location,
destination_organization_id,
org_id
from icx_shopping_carts
where cart_id = v_cart_id;
select max(cart_line_number)
from icx_shopping_cart_lines
where cart_id = v_cart_id;
l_rows_updated number;
l_rows_updated := 0;
select 1 into l_dummy
from icx_shopping_carts
where cart_id = l_cart_id
for update;
update icx_shopping_carts
set last_update_date = sysdate
where cart_id = l_cart_id;
select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
insert into icx_shopping_cart_lines(cart_line_id,cart_id,cart_line_number,creation_date,created_by,quantity,line_id,item_id,item_revision,unit_of_measure,
unit_price,category_id,line_type_id,item_description,destination_organization_id,deliver_to_location_id,deliver_to_location,
suggested_buyer_id,suggested_vendor_name,suggested_vendor_site,
need_by_date,suggested_vendor_contact,
suggested_vendor_item_num,item_number,last_update_date,last_updated_by,org_id,custom_defaulted, autosource_doc_header_id, autosource_doc_line_num)
select l_cart_line_id,l_cart_id,l_cart_line_number,sysdate,l_shopper_id,l_qty,Line_Id(i),a.item_id,a.item_revision,a.line_uom,
a.price,a.category_id,a.line_type_id,a.item_description,l_dest_org_id,
/* comment out this line for bug 696626
l_deliver_to_location_id,l_deliver_to_location,a.vendor_id,a.vendor_name,a.vendor_site_code,
and replace with the following line*/
l_deliver_to_location_id,l_deliver_to_location,a.agent_id,a.vendor_name,a.vendor_site_code,
l_need_by_date,a.vendor_contact_name,
a.vendor_product_num,a.item_number,sysdate,l_shopper_id,l_org_id,'N',
a.po_header_id, a.line_num
from icx_po_suppl_catalog_items_v a
where a.po_line_id = l_line_id;
insert into icx_cart_line_distributions(cart_id,cart_line_id,distribution_id,
last_updated_by,last_update_date,last_update_login,
creation_date,created_by,org_id)
values (l_cart_id,l_cart_line_id,icx_cart_line_distributions_s.nextval,l_shopper_id,
sysdate,l_shopper_id,sysdate,l_shopper_id,l_org_id);
update icx_shopping_cart_lines
set quantity = quantity + l_qty
where cart_id = l_cart_id
and cart_line_id = l_cart_line_id
and nvl(org_id, -9999) = nvl(l_org_id,-9999);
l_rows_updated := l_rows_updated + 1;
total_page(l_cart_id,l_dest_org_id,l_rows_added,l_rows_updated,p_cat_name,
p_start_row,p_end_row,p_where,end_row,p_query_set,p_row_count);
select substr(l_error_message,12,512) into l_err_mesg from dual;
select substr(l_error_message,12,512) into l_err_mesg from dual;
SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
select QUERY_SET into c_query_size from ICX_PARAMETERS;