[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 d.COLUMN_NAME,b.DATA_TYPE,a.ATTRIBUTE_LABEL_LONG
from AK_ATTRIBUTES b,
AK_REGIONS c,
AK_OBJECT_ATTRIBUTES d,
AK_REGION_ITEMS_VL a
where a.REGION_APPLICATION_ID = p_region_appl_id
and a.REGION_CODE = p_region_code
and a.NODE_QUERY_FLAG = 'Y'
and a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
and a.REGION_CODE = c.REGION_CODE
and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
and a.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
and a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
and a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
and a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
and not exists (select 'X'
from AK_EXCLUDED_ITEMS
where RESPONSIBILITY_ID = l_responsibility_id
and ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
and ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID)
order by a.DISPLAY_SEQUENCE;
select category_set_id,
validate_flag
from mtl_default_sets_view
WHERE functional_area_id = 2;
/* Create queryable attribute select list */
for i in 1..p_lines_now loop
if i = 1
then
c_attributes(i) := '';
c_attributes(i) := htf.formSelectOption(' ');
c_attributes(i) := c_attributes(i)||'
c_attributes(i) := c_attributes(i)||htf.formSelectClose;
c_condition(x) := htf.formSelectOption(' ');
c_condition(x) := c_condition(x)||'
c_condition(x) := c_condition(x)||'
c_condition(x) := c_condition(x)||htf.formSelectClose;
select NAME
into l_page_title
from AK_REGIONS_VL
where REGION_CODE = p_region_code
and REGION_APPLICATION_ID = p_region_appl_id;
l_categories := htf.formSelectOpen('p_cat');
l_categories := l_categories||'
l_categories := l_categories||'
l_categories := l_categories||htf.formSelectClose;
htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
l_rows_updated number default 0,
a_1 in varchar2 default null,
c_1 in varchar2 default null,
i_1 in varchar2 default null,
a_2 in varchar2 default null,
c_2 in varchar2 default null,
i_2 in varchar2 default null,
a_3 in varchar2 default null,
c_3 in varchar2 default null,
i_3 in varchar2 default null,
a_4 in varchar2 default null,
c_4 in varchar2 default null,
i_4 in varchar2 default null,
a_5 in varchar2 default null,
c_5 in varchar2 default null,
i_5 in varchar2 default null,
p_start_row IN NUMBER default 1,
p_end_row IN NUMBER default null,
p_where IN varchar2,
p_hidden IN varchar2 default null,
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);
l_rows_updated number;
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,
destination_organization_id,
deliver_to_location,
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 := 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,
/* l_deliver_to_location_id,l_deliver_to_location,a.vendor_id,a.vendor_name,a.vendor_site_code, **/
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;
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,a_1,c_1,
i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5,
p_start_row,p_end_row,p_where,p_hidden, end_row, p_query_set,p_row_count);
select substr(l_error_message,12,512) into l_err_mesg from dual;
select QUERY_SET into c_query_size from ICX_PARAMETERS;