The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_header_id IN NUMBER
)
IS
l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
SAVEPOINT Header_Delete;
oe_debug_pub.add('Entering Oe_Oe_Html_Header.DELETE_ROW', 1);
l_x_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
oe_debug_pub.add('Exiting Oe_Oe_Html_Header.DELETE_ROW', 1);
ROLLBACK TO SAVEPOINT Header_Delete ;
ROLLBACK TO SAVEPOINT Header_Delete ;
ROLLBACK TO SAVEPOINT Header_Delete ;
, 'Delete_Row'
);
END Delete_Row;
OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
,p_entity_id => p_header_id
,x_return_status => l_return_status);
Procedure Delete_All_Requests
( x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_return_status Varchar2(30);
, 'Delete_All_Requests'
);
END Delete_All_Requests;
select /* MOAC_SQL_CHANGE */ cust.cust_account_id,
party.party_name,
cust.account_number
INTO x_customer_id,
x_customer_name,
x_customer_number
from
hz_cust_site_uses_all site,
hz_cust_acct_sites_all cas,
hz_cust_accounts cust,
hz_parties party
where site.site_use_code = p_site_use_code
and site_use_id = p_site_use_id
and site.cust_acct_site_id = cas.cust_acct_site_id
and cas.cust_account_id = cust.cust_account_id
and cust.party_id=party.party_id;
select meaning
into x_header_val_rec.status
from oe_lookups
where lookup_type = 'FLOW_STATUS'
AND lookup_code = p_header_rec.flow_status_code;
SELECT Name
INTO x_header_val_rec.salesrep
FROM ra_salesreps
WHERE salesrep_id=p_header_rec.salesrep_id;