[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor c_user_id(p_user_name in varchar2) is select user_id from fnd_user where user_name = p_user_name;
fnd_user_pkg.UpdateUser(
x_user_name=>p_um_person_rec.user_name,
x_owner=>null,
x_customer_id=>l_party_id
);
select party_id, party_name, party_number from hz_parties where party_name = x_org_rec.organization_name;
select party_id, party_name, party_number from hz_parties where party_number = x_org_rec.organization_number;