[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cs_interactions_s.NEXTVAL INTO l_interaction_id FROM dual;
INSERT INTO cs_interactions
( interaction_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
org_id,
customer_id,
contact_id,
contact_lastname,
contact_firstname,
phone_area_code,
phone_number,
phone_extension,
fax_area_code,
fax_number,
email_address,
interaction_type_code,
interaction_category_code,
interaction_method_code,
interaction_date,
interaction_document_code,
source_document_id,
source_document_name,
reference_form,
source_document_status,
employee_id,
public_flag,
follow_up_action,
notes,
parent_interaction_id,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category )
VALUES
( l_interaction_id,
p_user_id,
Sysdate,
p_user_id,
Sysdate,
p_login_id,
l_org_id,
p_customer_id,
p_contact_id,
p_contact_lastname,
p_contact_firstname,
l_phone_area_code,
l_phone_number,
l_phone_extension,
l_fax_area_code,
l_fax_number,
l_email_address,
p_interaction_type_code,
p_interaction_category_code,
p_interaction_method_code,
p_interaction_date,
p_interaction_document_code,
l_source_document_id,
l_source_document_name,
l_reference_form,
l_source_document_status,
p_employee_id,
p_public_flag,
l_follow_up_action,
l_notes,
l_parent_id,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute_category );