The following lines contain the word 'select', 'insert', 'update' or 'delete':
select meaning into x_output_contracts(l_index).status_text from OKC_STATUSES_V where code = l_output_contracts(l_index).sts_code;
Select *
From csi_search_oks_temp
Where creation_date < sysdate
and rownum <= 1
For Update NoWait;
DELETE csi_search_oks_temp
WHERE creation_date < sysdate -1;
SELECT csi_search_oks_temp_S.NEXTVAL, sysdate
INTO l_Seq, l_Creation_Date
FROM dual;
Insert into csi_search_oks_temp
(
id,
creation_date,
covered_level_id,
covered_level_code
)
Values
(
l_Seq
,l_Creation_Date
,l_ent_contracts(l_rec_count).coverage_level_id
,l_ent_contracts(l_rec_count).coverage_level_code
);
l_contract_where_clause := l_instance_table_name || 'instance_id in ( select instance_id from csi_i_parties where party_id in ( '
||l_covered_party_id||' ) )' ;
l_instance_table_name || 'instance_id in ( select instance_id from csi_i_parties where party_id in ( '
||l_covered_party_id||' ) )' ;
l_contract_where_clause := l_instance_table_name || 'instance_id in ( select instance_id from ' ||
' csi_i_parties p, csi_ip_accounts a where a.instance_party_id = p.instance_party_id ' ||
' and a.party_account_id IN ( '||l_covered_acct_id ||' ) )' ;
l_instance_table_name || 'instance_id in ( select instance_id from ' ||
' csi_i_parties p, csi_ip_accounts a where a.instance_party_id = p.instance_party_id ' ||
' and a.party_account_id IN ( '||l_covered_acct_id ||' ) )' ;
SELECT 'x'
INTO l_dummy
FROM csi_item_instances_h
WHERE transaction_id = p_transaction_id
AND ROWNUM = 1;
SELECT 'x'
INTO l_dummy
FROM csi_i_assets_h
WHERE transaction_id = p_transaction_id
AND ROWNUM = 1;
SELECT 'x'
INTO l_dummy
FROM csi_i_parties_h
WHERE transaction_id = p_transaction_id
AND ROWNUM = 1;
SELECT 'x'
INTO l_dummy
FROM csi_ip_accounts_h
WHERE transaction_id = p_transaction_id
AND rownum=1;
SELECT 'x'
INTO l_dummy
FROM csi_i_org_assignments_h
WHERE transaction_id = p_transaction_id
AND ROWNUM = 1;
SELECT 'x'
INTO l_dummy
FROM csi_iea_values_h
WHERE transaction_id = p_transaction_id
AND ROWNUM = 1;
SELECT 'x'
INTO l_dummy
FROM csi_ii_relationships_h
WHERE transaction_id = p_transaction_id
AND rownum=1;
SELECT 'x'
INTO l_dummy
FROM csi_i_version_labels_h
WHERE transaction_id = p_transaction_id
AND ROWNUM = 1;
insert into csi_configuration_temp_tbl (object_id,subject_id) values ( p_connected_relationship_tbl(i).object_id, p_connected_relationship_tbl(i).subject_id);
delete from csi_configuration_temp_tbl;
insert into csi_configuration_temp_tbl
(
object_id,
subject_id
)
values
(
l_rel_tbl(l_var).object_id,
l_rel_tbl(l_var).subject_id
);
insert into csi_configuration_temp_tbl (object_id,subject_id) values ( l_rel_tbl1(i).object_id, l_rel_tbl1(i).subject_id);
SELECT
org_id into l_org_id
FROM
oe_order_lines_all oeol
WHERE
line_id=p_last_oe_order_line_id;
SELECT
oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id)
INTO l_config_id
FROM DUAL;
SELECT serial_number
FROM csi_item_instances
WHERE instance_id =l_instance_id ;
SELECT CIIH.INSTANCE_ID FROM
CSI_ITEM_INSTANCES_H ciih,
csi_item_instances cii
WHERE
cii.instance_id =ciih.instance_id
AND cii.SERIAL_NUMBER IS NULL
and ciiH.INSTANCE_ID NOT IN n_instance_id
AND TRANSACTION_ID IN
( SELECT MAX(TRANSACTION_ID) FROM CSI_ITEM_INSTANCES_H WHERE INSTANCE_ID
= n_instance_id);
--p_instance_tbl.DELETE(i_dx);
PROCEDURE delete_search_oks_temp
(
p_sequence_id IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_search_oks_temp';
DELETE csi_search_oks_temp where id = p_sequence_id ;
END delete_search_oks_temp;
SELECT
relationship_id, object_version_number INTO l_relationship_id, l_object_version_number
FROM
csi_ii_relationships
WHERE
subject_id = p_subject_id
and (active_end_date IS NULL OR active_end_date > sysdate);