The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor CES is select result_column_name, qpc.char_id
from qa_plan_chars qpc, qa_chars qc
where plan_id = given_plan_id
and qpc.char_id = qc.char_id
and qpc.enabled_flag = 1
order by prompt_sequence;
select_clause VARCHAR2(32000);
select_clause := 'SELECT ';
select_clause := select_clause || column_name;
select_clause := select_clause || ', ' || column_name;
select_clause := select_clause || ', ' || 'QA_CREATED_BY_NAME'
|| ', ' || 'COLLECTION_ID'
|| ', ' || 'fnd_date.date_to_chardt(LAST_UPDATE_DATE,2) LAST_UPDATE_DATE';
select_clause := select_clause || from_clause || where_clause;
return select_clause;
FUNCTION build_select_clause (p_plan_id IN NUMBER)
RETURN VARCHAR2 IS
cursor CES is
SELECT result_column_name, qpc.char_id, qc.datatype
FROM qa_plan_chars qpc, qa_chars qc
WHERE plan_id = p_plan_id
AND qpc.char_id = qc.char_id
AND qpc.enabled_flag = 1
ORDER BY prompt_sequence;
select_clause VARCHAR2(32000);
select_clause := select_clause || column_name;
select_clause := select_clause || ', ' || column_name;
select_clause := select_clause || ', OCCURRENCE, PLAN_ID, STATUS ';
RETURN select_clause;
END build_select_clause;
SELECT collection_trigger_id
FROM qa_txn_collection_triggers
WHERE transaction_number = p_txn_number
AND search_flag = 1;
select_clause VARCHAR2(32000);
values_table.delete();
select_clause := 'SELECT ';
select_clause := select_clause || build_select_clause(p_plan_id);
select_clause := select_clause || ', '
|| 'QA_CREATED_BY_NAME'
|| ', ' || 'COLLECTION_ID' || ', '
|| 'LAST_UPDATE_DATE';
select_clause := select_clause || from_clause || where_clause
|| order_by_clause;
RETURN select_clause;
select_clause VARCHAR2(32000);
values_table.delete();
select_clause := 'SELECT ';
select_clause := select_clause || build_select_clause(p_plan_id);
select_clause := select_clause || ', '
|| 'QA_CREATED_BY_NAME'
|| ', ' || 'COLLECTION_ID' || ', '
|| 'LAST_UPDATE_DATE';
select_clause := select_clause || from_clause || where_clause
|| order_by_clause;
RETURN select_clause;
select_clause VARCHAR2(32000);
select_clause := 'SELECT ';
select_clause := select_clause || build_select_clause(p_plan_id);
select_clause := select_clause || ', '
|| 'QA_CREATED_BY_NAME'
|| ', ' || 'COLLECTION_ID' || ', '
|| 'LAST_UPDATE_DATE';
select_clause := select_clause || from_clause || where_clause
|| order_by_clause;
RETURN select_clause;
select_clause VARCHAR2(32000);
select_clause := 'SELECT ';
select_clause := select_clause || build_select_clause(p_plan_id);
select_clause := select_clause || ' , name ';
select_clause := select_clause || ', ' || 'QA_CREATED_BY_NAME' || ', '
|| 'COLLECTION_ID' || ', ' || 'LAST_UPDATE_DATE';
RETURN select_clause || from_clause;
select_clause VARCHAR2(32000);
select_clause := 'SELECT ';
select_clause := select_clause || build_select_clause(p_plan_id);
select_clause := select_clause || ', '
|| 'QA_CREATED_BY_NAME'
|| ', ' || 'COLLECTION_ID' || ', '
|| 'fnd_date.date_to_chardt(LAST_UPDATE_DATE,2) LAST_UPDATE_DATE';
select_clause := select_clause || from_clause;
RETURN select_clause;
select organization_code into org_code
from mtl_parameters
where organization_id = org_id;
select name into plan_name
from qa_plans
where plan_id = given_plan_id;
script := 'Insert into qa_results_interface ' ||
'(process_status, organization_code, plan_name, source_code, source_line_id, po_agent_id';
SELECT mso.sales_order_id
FROM mtl_sales_orders mso,
oe_order_headers_all oe,
qa_customers_lov_v rc,
oe_transaction_types_tl ot,
fnd_languages fl
WHERE mso.segment1 = to_char(oe.order_number)
AND oe.order_type_id = ot.transaction_type_id
AND ot.language = fl.language_code
AND fl.installed_flag = 'B'
AND oe.sold_to_org_id = rc.customer_id (+)
AND mso.segment2 = ot.name
AND mso.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
AND oe.header_id = p_oe_header_id;