APPS.IES_TCA_BP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 158

procedure update_org_contact(
 p_api_version number,
 p_user_name varchar2,
 p_org_contact_id number,
 p_party_site_id number,
 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2) is

l_msg_count number;

Line: 179

end update_org_contact;

Line: 181

procedure update_party_site(
 p_api_version number,
 p_user_name varchar2,
 p_party_site_id number,
 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2) is


l_msg_count number;

Line: 202

end update_party_site;