[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select org_id into l_org_id
from po_headers_all where po_header_id = to_number(pk1);
update icx_sessions
set org_id = l_org_id
where session_id = l_session_id;
select segment1 into l_po_number
from po_headers_all
where po_header_id = to_number(pk1);
');
fnd_message.get_string('ICX', 'ICX_POS_ACK_SELECT_RESULT') ||
'
' ||
l_msg ||
' '
);
l_rows_inserted IN NUMBER DEFAULT 0
)
IS
l_language VARCHAR2(5);
function SubmitDlg(p_start, p_end, p_total, p_rows_inserted, p_string)
{
var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" +
"p_first=" + p_start +
"&p_last=" + p_end +
"&p_total=" + p_total;
openDlg(p_rows_inserted);
l_msg := replace(l_msg, '&TOTAL', to_char(l_rows_inserted));
to_char(l_rows_inserted) || ', ''' || l_msg || ''')">');
select vs.vendor_id
into l_supplier_id
from po_vendor_sites vs,
po_vendor_contacts vc,
fnd_user fu
where fu.user_id = p_user_id
and fu.supplier_id = vc.vendor_contact_id
and vc.vendor_site_id = vs.vendor_site_id;
IF item_updateable(l_attribute_index) THEN
htp.p('' ||
item_reqd(l_attribute_index) || ''
|| item_name(l_attribute_index) || ' ' || '' ||
' ');
IF item_updateable(l_attribute_index) THEN
htp.p('' ||
'' || item_name(l_attribute_index)
|| ' ' || '' || ' ');
' ');
select responsibility_id into g_responsibility_id from ICX_SESSIONS
WHERE session_id = l_session_id;
select user_id into g_user_id from ICX_SESSIONS
WHERE session_id = l_session_id;
delete from pos_ack_select;
select count(*) into l_count
from pos_ack_select;
l_rows_inserted IN NUMBER default 0
)
IS
l_count NUMBER := 0;
function LoadCounter(p_start, p_end, p_total, p_rows_inserted, p_string1, p_string2)
{
if (p_rows_inserted > 0)
alert(p_string1);
select count(*) into l_count
from pos_ack_select;
l_msg1 := replace(l_msg1, '&TOTAL', to_char(l_rows_inserted));
veera_debug('no of rows inserted: ' || to_char(l_rows_inserted));
',' || to_char(l_rows_inserted) ||
', ''' || l_msg1 || ''',''' || l_msg2 || '''' ||
')">');
return ' ';
return ' ';
FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
BEGIN
RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');
END item_updateable;
veera_debug('After AK Select' || to_char(ak_query_pkg.g_items_table.count));
veera_debug('After AK Select: no of rows:' || to_char(ak_query_pkg.g_results_table.count));
'' || '' ||
'' ||
'');
IF item_updateable(l_attribute_index) THEN
htp.p('' ||
'' ||
'' ||
--LOV Test
'" >'
);
Line: 1765
select *
from pos_ack_select_v
where
acceptance_status = nvl(l_acceptance_status, acceptance_status)
and acceptance_required = nvl(l_Acceptance_Reqd_Flag, acceptance_required)
-- and acceptance_required_by between nvl(l_Start_Date, acceptance_required_by) and nvl(l_End_Date, acceptance_required_by)
and ( acceptance_required_by >= decode(l_Start_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_Start_Date)) or (acceptance_required_by is null and l_Start_Date is null) )
and (acceptance_required_by <= decode(l_End_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_End_Date)) or (acceptance_required_by is null and l_End_Date is null) )
and po_number like nvl(l_PO_Number, po_number)
and supplier_site_id = nvl(l_Supplier_Site_Id, supplier_site_id)
and document_type_code = nvl(l_Document_Type_Code, document_type_code) order by po_number;
Line: 1786
delete from pos_ack_select;
Line: 1795
select date_format_mask
into l_format_mask
from icx_sessions
where session_id = l_session_id;
Line: 1807
insert into pos_ack_select
(
acceptance_flag,
accept,
reject,
acceptance_type_code,
acceptance_type,
comments,
po_header_id,
po_release_id,
po_number,
release_number,
revision_number,
document_type_code,
document_type,
currency_code,
total,
acceptance_required,
acceptance_status,
acceptance_required_by,
approval_status,
shipto_location_id,
shipto_location,
carrier_code,
carrier,
buyer_id,
buyer_name,
supplier_org_id,
supplier_id,
supplier_name,
supplier_site_id,
supplier_site,
row_num
)
values
(
l_po_rec.acceptance_flag,
l_po_rec.accept,
l_po_rec.reject,
nvl(l_po_rec.acceptance_type_code,'-99999'),
l_po_rec.acceptance_type,
l_po_rec.comments,
l_po_rec.po_header_id,
l_po_rec.po_release_id,
l_po_rec.po_number,
l_po_rec.release_number,
l_po_rec.revision_number,
l_po_rec.document_type_code,
l_po_rec.document_type,
l_po_rec.currency_code,
l_po_rec.total,
decode(l_po_rec.acceptance_required, 'Yes', l_temp1, l_temp2),
l_po_rec.acceptance_status,
l_po_rec.acceptance_required_by,
l_po_rec.approval_status,
l_po_rec.shipto_location_id,
l_po_rec.shipto_location,
l_po_rec.carrier_code,
l_po_rec.carrier,
l_po_rec.buyer_id,
l_po_rec.buyer_name,
l_po_rec.supplier_org_id,
l_po_rec.supplier_id,
l_po_rec.supplier_name,
l_po_rec.supplier_site_id,
l_po_rec.supplier_site,
l_rows+1
);
Line: 1878
Veera_Debug('No of Rows Selected: ' || to_char(l_rows));
Line: 1901
l_rows_inserted NUMBER := 0;
Line: 1928
l_rows_inserted := l_rows_inserted + 1;
Line: 1929
select po_acceptances_s.nextval into l_acceptance_id
from dual;
Line: 1932
select revision_num,org_id into l_revision_num , l_org_id
from po_headers_all
where po_header_id = pos_ack_po_header_id(l_counter);
Line: 1936
select description into l_accp_type
from POS_ACK_ACC_TYPE_LOV_V
where LOOKUP_CODE = pos_ack_acc_type_code(l_counter);
Line: 1949
insert into po_acceptances (
acceptance_id,
last_update_Date,
last_updated_by,
last_update_login,
creation_date,
created_by,
po_header_id,
po_release_id,
action,
action_date,
employee_id,
revision_num,
accepted_flag,
acceptance_lookup_code,
note
)
values (
l_acceptance_id,
sysdate,
l_user_id,
l_user_id,
sysdate,
l_user_id,
pos_ack_po_header_id(l_counter),
decode(pos_ack_release_id(l_counter), -1,null,pos_ack_release_id(l_counter)),
l_temp1,
sysdate,
pos_ack_buyer_id(l_counter),
l_revision_num,
pos_ack_accept(l_counter),
pos_ack_acc_type_code(l_counter),
pos_ack_comments(l_counter)
);
Line: 1985
select po_wf_itemkey_s.nextval
into l_seq_val
from dual;
Line: 2042
delete from pos_ack_select
where row_num = to_number(pos_ack_row_num(l_counter));
Line: 2049
delete from pos_ack_select
where row_num = to_number(pos_ack_row_num(l_counter));
Line: 2053
veera_debug('Rows Inserted in PO ACKs :' || to_char(l_rows_inserted));
Line: 2056
blank_frame(1, l_rows_inserted);
Line: 2058
show_pos(l_rows_inserted => l_rows_inserted);
Line: 2085
select rowidtochar(ROWID)
into p_rowid
from AK_FLOW_REGION_RELATIONS
where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
and FROM_REGION_APPL_ID = 178
and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
and FROM_PAGE_APPL_ID = 178
and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'
and TO_PAGE_APPL_ID = 178
and FLOW_CODE = 'ICX_INQUIRIES'
and FLOW_APPLICATION_ID = 178;
Line: 2098
select po_header_id
into header_id
from po_headers
where segment1 = decode(instrb(seg1,'-'), 0, seg1, substr(seg1, 1, (instrb(seg1,'-')-1)));
Line: 2138
select rowidtochar(ROWID)
into p_rowid
from AK_FLOW_REGION_RELATIONS
where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
and FROM_REGION_APPL_ID = 178
and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
and FROM_PAGE_APPL_ID = 178
and TO_PAGE_CODE = 'ICX_PO_BUYER_DTL'
and TO_PAGE_APPL_ID = 178
and FLOW_CODE = 'ICX_INQUIRIES'
and FLOW_APPLICATION_ID = 178;
Line: 2151
select po_header_id
into header_id
from po_headers
where segment1 = decode(instrb(seg1,'-'), 0, seg1, substr(seg1, 1, (instrb(seg1,'-')-1)));
Line: 2187
select sysdate from dual;