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 error_text
from icx_req_cart_errors
where cart_id = v_cart_id;
procedure updateCartHeaderObject is
------------------------------------------------
begin
htp.p('//Update the requestor.
function Update_requestor(id, name,org_id,loc_id,loc_cd) {
document.KEVIN.ICX_DEST_ORG_ID.value = document.KEVIN.ICX_REQ_ORG_ID.value;
end updateCartHeaderObject;
FND_MESSAGE.SET_NAME('RG', 'RG_DELETE_ROW');
document.LINE.cartLineAction.value = "DELETE";
htp.p('function delete_saved_cart() {
// if (parent.frames[0].document.LINE.itemCount.value == 0) {
// alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).update_flag = 'Y' and v_req_overwrite_flag = 'Y' then
v_table_attribute := ' COLSPAN=2 ';
ak_query_pkg.g_items_table(i).update_flag = 'Y' then
if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' then
v_table_attribute := ' COLSPAN=2 ';
if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELETE'
then
htp.tableData(cvalue => '
if ak_query_pkg.g_items_table(i).update_flag = 'Y'
then
l_colspan := 1;
ELSE /* if update_flag <> 'Y' */
if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
l_value := to_char(to_number(l_value),v_money_fmt_mask);
/* Even if update_flag <> 'Y', we still want it to be an
input text field so that it can be dynamically changed
when ICX_SUGGESTED_VENDOR_NAME is changed */
htp.tableData(cvalue => '
end if; -- update_flag
ak_query_pkg.g_items_table(i).update_flag = 'Y' then
v_vendor_LOV_flag := 'Y';
procedure updateCarts is
------------------------------------------------------------
begin
htp.p('function resetItemCount(fld) {
fld.value = 0;
htp.p('function updateCarts(value1,value2,value3,value4) {
var seq1 = LOVSequence1.sequence
var seq2 = LOVSequence2.sequence
var seq3 = LOVSequence3.sequence
var seq4 = LOVSequence4.sequence
document.KEVIN.elements[seq1].value = value1
document.KEVIN.elements[seq2].value = value2
document.KEVIN.elements[seq3].value = value3
document.KEVIN.elements[seq4].value = value4
}
');
htp.p('function Updatelineloc(value1,value2,value3) {
var seq5 = LOVSequence5.sequence
var seq6 = LOVSequence6.sequence
var seq7 = LOVSequence7.sequence
document.KEVIN.elements[seq5].value = value1
document.KEVIN.elements[seq6].value = value2
document.KEVIN.elements[seq7].value = value3
}
');
end updateCarts;
select hrev.full_name
from hr_employees_current_v hrev
where hrev.employee_id = requestor_id;
select hrl.location_code
from hr_locations hrl,
org_organization_definitions ood,
financials_system_parameters fsp
where hrl.location_id = v_location_id
and ood.organization_id = nvl(hrl.inventory_organization_id,
fsp.inventory_organization_id)
and sysdate < nvl(hrl.inactive_date, sysdate + 1);
if ( ak_query_pkg.g_items_table(i).update_flag = 'Y' and
ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') then
where_clause :='';--' = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID);
elsif (ak_query_pkg.g_items_table(i).update_flag = 'N' ) then
htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ');
Line: 1381
if ak_query_pkg.g_items_table(i).update_flag = 'Y' then
if ( ak_query_pkg.g_items_table(i).item_style = 'TEXT' ) then
htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ');
Line: 1435
else -- Update falg not set
if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' ) then
htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ');
Line: 1496
ak_query_pkg.g_items_table(i).update_flag = 'Y') or
( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG'
) then
htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ');
Line: 1513
ak_query_pkg.g_items_table(i).update_flag = 'N') then
display_text := display_text || ' onBlur=''this.value ="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"''>';
Line: 1583
ak_query_pkg.g_items_table(i).update_flag = 'Y' and
ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
where_clause := 'WEB_USER_ID = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID);
Line: 1624
ak_query_pkg.g_items_table(i).update_flag = 'N' ) then
htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ');
Line: 1768
elsif cartLineAction = 'DELETE' then
delete_line(n_org,cartId,cartLineId);
Line: 1792
select cart_line_number
from icx_shopping_cart_lines
where cart_id = v_cart_id
and cart_line_id = v_cart_line_id;
Line: 1798
select *
from icx_cart_line_distributions
where cart_id = v_cart_id
and cart_line_id = v_cart_line_id
and nvl(org_id,-9999) = nvl(v_org_id,-9999);
Line: 1818
select 1 into l_dummy
from icx_shopping_carts
where cart_id = l_cart_id
for update;
Line: 1823
update icx_shopping_cart_lines
set cart_line_number = cart_line_number + 1
where cart_id = l_cart_id
and cart_line_number > l_cart_line_number;
Line: 1832
select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
Line: 1835
insert into icx_shopping_cart_lines
(CART_LINE_ID, CART_LINE_NUMBER,LAST_UPDATE_DATE, LAST_UPDATED_BY,
CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
CART_ID, ITEM_ID, ITEM_REVISION,
UNIT_OF_MEASURE, QUANTITY, UNIT_PRICE,
SUPPLIER_ITEM_NUM, CATEGORY_ID, LINE_TYPE_ID,
LINE_ID, ITEM_DESCRIPTION,
EXPENDITURE_TYPE,
DESTINATION_ORGANIZATION_ID, DELIVER_TO_LOCATION,DELIVER_TO_LOCATION_ID, SUGGESTED_BUYER_ID,
SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE,LINE_ATTRIBUTE_CATEGORY,
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, AUTOSOURCE_DOC_HEADER_ID, AUTOSOURCE_DOC_LINE_NUM,
PROJECT_ID,TASK_ID , EXPENDITURE_ITEM_DATE,
SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_ITEM_NUM,
EXPENDITURE_ORGANIZATION_ID,ORG_ID,EXPRESS_NAME,ITEM_NUMBER,CUSTOM_DEFAULTED)
select l_cart_line_id,l_cart_line_number,
LAST_UPDATE_DATE, LAST_UPDATED_BY,
CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
CART_ID, ITEM_ID, ITEM_REVISION,
UNIT_OF_MEASURE, QUANTITY, UNIT_PRICE,
SUPPLIER_ITEM_NUM, CATEGORY_ID, LINE_TYPE_ID,
LINE_ID, ITEM_DESCRIPTION,
EXPENDITURE_TYPE,
DESTINATION_ORGANIZATION_ID, DELIVER_TO_LOCATION,DELIVER_TO_LOCATION_ID, SUGGESTED_BUYER_ID,
SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE,LINE_ATTRIBUTE_CATEGORY,
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, AUTOSOURCE_DOC_HEADER_ID, AUTOSOURCE_DOC_LINE_NUM,
PROJECT_ID,TASK_ID , EXPENDITURE_ITEM_DATE,
SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_ITEM_NUM,
EXPENDITURE_ORGANIZATION_ID,ORG_ID,EXPRESS_NAME,ITEM_NUMBER,CUSTOM_DEFAULTED
from icx_shopping_cart_lines
where cart_line_id = cartLineId
and cart_id = l_cart_id;
Line: 1881
INSERT INTO icx_cart_line_distributions
(cart_line_id,
distribution_id,
last_updated_by,
last_update_date,
last_update_login,
creation_date,
created_by,
org_id,
cart_id,
distribution_num,
charge_account_id,
charge_account_num,
allocation_type,
allocation_value,
charge_account_segment1,
charge_account_segment2,
charge_account_segment3,
charge_account_segment4,
charge_account_segment5,
charge_account_segment6,
charge_account_segment7,
charge_account_segment8,
charge_account_segment9,
charge_account_segment10,
charge_account_segment11,
charge_account_segment12,
charge_account_segment13,
charge_account_segment14,
charge_account_segment15,
charge_account_segment16,
charge_account_segment17,
charge_account_segment18,
charge_account_segment19,
charge_account_segment20,
charge_account_segment21,
charge_account_segment22,
charge_account_segment23,
charge_account_segment24,
charge_account_segment25,
charge_account_segment26,
charge_account_segment27,
charge_account_segment28,
charge_account_segment29,
charge_account_segment30)
VALUES (l_cart_line_id,
icx_cart_line_distributions_s.nextval,
prec.last_updated_by,
sysdate,
prec.last_updated_by,
sysdate,
prec.created_by,
prec.org_id,
l_cart_id,
prec.distribution_num,
prec.charge_account_id,
prec.charge_account_num,
prec.allocation_type,
prec.allocation_value,
prec.charge_account_segment1,
prec.charge_account_segment2,
prec.charge_account_segment3,
prec.charge_account_segment4,
prec.charge_account_segment5,
prec.charge_account_segment6,
prec.charge_account_segment7,
prec.charge_account_segment8,
prec.charge_account_segment9,
prec.charge_account_segment10,
prec.charge_account_segment11,
prec.charge_account_segment12,
prec.charge_account_segment13,
prec.charge_account_segment14,
prec.charge_account_segment15,
prec.charge_account_segment16,
prec.charge_account_segment17,
prec.charge_account_segment18,
prec.charge_account_segment19,
prec.charge_account_segment20,
prec.charge_account_segment21,
prec.charge_account_segment22,
prec.charge_account_segment23,
prec.charge_account_segment24,
prec.charge_account_segment25,
prec.charge_account_segment26,
prec.charge_account_segment27,
prec.charge_account_segment28,
prec.charge_account_segment29,
prec.charge_account_segment30);
Line: 1973
update icx_shopping_carts
set last_update_date = sysdate
where cart_id = l_cart_id;
Line: 1984
procedure delete_line(n_org number,cartId number,cartLineId number) is
l_org_id number;
Line: 1991
select cart_line_number
from icx_shopping_cart_lines
where cart_id = v_cart_id
and cart_line_id = v_cart_line_id;
Line: 2012
select 1 into l_dummy
from icx_shopping_carts
where cart_id = l_cart_id
for update;
Line: 2017
delete from icx_shopping_cart_lines
where cart_line_id = cartLineId
and cart_id = l_cart_id;
Line: 2022
delete from icx_cart_line_distributions
where cart_line_id = cartLineId
and cart_id = l_cart_id;
Line: 2026
update icx_shopping_cart_lines
set cart_line_number = cart_line_number - 1
where cart_id = l_cart_id
and cart_line_number > l_cart_line_number;
Line: 2031
update icx_shopping_carts
set last_update_date = sysdate
where cart_id = l_cart_id;
Line: 2265
updateCartHeaderObject;
Line: 2270
updateCarts;
Line: 2505
FND_MESSAGE.SET_NAME('ICX','ICX_RQS_DELETE_ORDER');
Line: 2510
P_HyperTextCall => 'javascript:delete_saved_cart()',
P_LanguageCode => v_lang,
P_JavaScriptFlag => FALSE);
Line: 2545
CURSOR C3 IS SELECT to_char(current_max_unique_identifier + 1)
FROM po_unique_identifier_control
WHERE table_name = 'PO_HEADERS'
FOR UPDATE OF current_max_unique_identifier;
Line: 2562
UPDATE po_unique_identifier_control
SET current_max_unique_identifier =
current_max_unique_identifier + 1
WHERE CURRENT of C3;
Line: 2571
update icx_shopping_carts
set reserved_po_num = l_po_num
where cart_id = l_cart_id;
Line: 2632
select gsob.CURRENCY_CODE,
fc.PRECISION
from gl_sets_of_books gsob,
FND_CURRENCIES fc,
org_organization_definitions ood
where ood.ORGANIZATION_ID = v_org
and fc.CURRENCY_CODE = gsob.CURRENCY_CODE
and ood.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID;
Line: 2669
select hrev.full_name,
hrl.location_id,
hrl.location_code,
ood.organization_id,
ood.organization_code
from hr_locations hrl,
hr_employees_current_v hrev,
org_organization_definitions ood,
financials_system_parameters fsp
where hrev.employee_id = v_shop_id
and hrev.location_id = hrl.location_id
and ood.organization_id = nvl(hrl.inventory_organization_id,
fsp.inventory_organization_id)
and sysdate < nvl(hrl.inactive_date, sysdate + 1);