The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_party_site_temp(j).program_update_date,
l_party_site_temp(j).created_by_module,
l_party_site_temp(j).created_by_name,
l_party_site_temp(j).creation_date,
l_party_site_temp(j).last_update_date,
l_party_site_temp(j).last_updated_by_name,
l_party_site_temp(j).actual_content_source,
l_party_site_temp(j).global_location_number,
l_party_site_temp(j).orig_sys_objs,
l_party_site_temp(j).ext_attributes_objs,
l_party_site_temp(j).location_obj,
l_party_site_temp(j).party_site_use_objs,
l_party_site_temp(j).phone_objs,
l_party_site_temp(j).telex_objs,
l_party_site_temp(j).email_objs,
l_party_site_temp(j).web_objs,
l_party_site_temp(j).contact_pref_objs);
l_contact_objs_temp(i).program_update_date,
l_contact_objs_temp(i).created_by_module,
l_contact_objs_temp(i).created_by_name,
l_contact_objs_temp(i).creation_date,
l_contact_objs_temp(i).last_update_date,
l_contact_objs_temp(i).last_updated_by_name,
l_contact_objs_temp(i).relationship_code,
l_contact_objs_temp(i).relationship_type,
l_contact_objs_temp(i).relationship_comments,
l_contact_objs_temp(i).start_date,
l_contact_objs_temp(i).end_date,
l_contact_objs_temp(i).status,
l_contact_objs_temp(i).orig_sys_objs,
l_contact_objs_temp(i).person_profile_obj,
l_contact_objs_temp(i).org_contact_role_objs,
l_party_site_objs_1,
l_contact_objs_temp(i).phone_objs,
l_contact_objs_temp(i).telex_objs,
l_contact_objs_temp(i).email_objs,
l_contact_objs_temp(i).web_objs,
l_contact_objs_temp(i).sms_objs,
l_contact_objs_temp(i).contact_pref_objs);
l_party_site_objs_1.delete;
p_hz_organization_bo.party_site_objs(j).program_update_date,
p_hz_organization_bo.party_site_objs(j).created_by_module,
p_hz_organization_bo.party_site_objs(j).created_by_name,
p_hz_organization_bo.party_site_objs(j).creation_date,
p_hz_organization_bo.party_site_objs(j).last_update_date,
p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
p_hz_organization_bo.party_site_objs(j).actual_content_source,
p_hz_organization_bo.party_site_objs(j).global_location_number,
p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
p_hz_organization_bo.party_site_objs(j).location_obj,
p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
p_hz_organization_bo.party_site_objs(j).phone_objs,
p_hz_organization_bo.party_site_objs(j).telex_objs,
p_hz_organization_bo.party_site_objs(j).email_objs,
p_hz_organization_bo.party_site_objs(j).web_objs,
p_hz_organization_bo.party_site_objs(j).contact_pref_objs);
p_hz_organization_bo.program_update_date,
p_hz_organization_bo.created_by_module,
p_hz_organization_bo.created_by_name,
p_hz_organization_bo.creation_date,
p_hz_organization_bo.last_update_date,
p_hz_organization_bo.last_updated_by_name,
p_hz_organization_bo.do_not_confuse_with,
p_hz_organization_bo.actual_content_source,
p_hz_organization_bo.orig_sys_objs,
p_hz_organization_bo.ext_attributes_objs,
l_contact_objs,
l_party_site_objs_2,
p_hz_organization_bo.preference_objs,
p_hz_organization_bo.phone_objs,
p_hz_organization_bo.telex_objs,
p_hz_organization_bo.email_objs,
p_hz_organization_bo.web_objs,
p_hz_organization_bo.edi_objs,
p_hz_organization_bo.eft_objs,
p_hz_organization_bo.relationship_objs,
p_hz_organization_bo.class_objs,
p_hz_organization_bo.financial_report_objs,
p_hz_organization_bo.credit_rating_objs,
p_hz_organization_bo.certification_objs,
p_hz_organization_bo.financial_prof_objs,
p_hz_organization_bo.contact_pref_objs,
p_hz_organization_bo.party_usage_objs);
PROCEDURE pos_create_update_supplier_bo(p_api_version IN NUMBER DEFAULT NULL,
p_init_msg_list IN VARCHAR2 DEFAULT NULL,
p_party_id IN NUMBER,
p_orig_system IN VARCHAR2,
p_orig_system_reference IN VARCHAR2,
p_create_update_flag IN VARCHAR2,
p_pos_supplier_bo IN pos_supplier_bo,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_party_id NUMBER;
p_create_update_flag,
x_vendor_id,
x_party_id,
x_return_status,
x_msg_count,
x_msg_data);
p_create_update_flag,
x_vendor_site_id,
x_party_site_id,
x_location_id,
x_return_status,
x_msg_count,
x_msg_data);
p_create_update_flag,
x_return_status,
x_msg_count,
x_msg_data);
p_create_update_flag,
x_return_status,
x_msg_count,
x_msg_data);
p_create_update_flag,
x_vendor_contact_id,
x_per_party_id,
x_rel_party_id,
x_rel_id,
x_org_contact_id,
x_party_site_id,
x_return_status,
x_msg_count,
x_msg_data);
p_create_update_flag,
x_return_status,
x_msg_count,
x_msg_data,
x_tax_profile_id);
p_create_update_flag,
p_pos_supplier_bo.p_pos_tax_report_bo_tbl,
x_return_status,
x_msg_count,
x_msg_data);
END pos_create_update_supplier_bo;