[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sysdate INTO l_system_date FROM dual;
SELECT coterminate_day_month
INTO l_coterminate_day_month
FROM hz_cust_accounts
WHERE cust_account_id = p_customer_id;
CS_SYSTEMS_ALL_PKG.Insert_Row(
X_Rowid => l_rowid,
X_system_id => l_system_id,
X_last_update_date => sysdate,
X_last_updated_by => FND_GLOBAL.USER_ID,
X_creation_date => sysdate,
X_created_by => FND_GLOBAL.USER_ID,
X_last_update_login => FND_GLOBAL.LOGIN_ID,
X_name => l_system_name,
X_customer_id => p_customer_id,
X_system_type_code => p_system_type_code,
X_description => p_description,
X_serial_number => NULL,
X_parent_system_id => NULL,
X_technical_contact_id => p_technical_contact_id,
X_service_admin_contact_id => p_service_admin_contact_id,
X_install_site_use_id => p_install_site_use_id,
X_bill_to_contact_id => p_bill_to_contact_id,
X_bill_to_site_use_id => p_bill_to_site_use_id,
X_ship_to_site_use_id => p_ship_to_site_use_id,
X_ship_to_contact_id => p_ship_to_contact_id,
X_coterminate_day_month => l_coterminate_day_month,
X_start_date_active => p_start_date_active,
X_end_date_active => p_end_date_active,
X_autocreated_from_system_id => null,
X_attribute1 => p_attribute1,
X_attribute2 => p_attribute2,
X_attribute3 => p_attribute3,
X_attribute4 => p_attribute4,
X_attribute5 => p_attribute5,
X_attribute6 => p_attribute6,
X_attribute7 => p_attribute7,
X_attribute8 => p_attribute8,
X_attribute9 => p_attribute9,
X_attribute10 => p_attribute10,
X_attribute11 => p_attribute11,
X_attribute12 => p_attribute12,
X_attribute13 => p_attribute13,
X_attribute14 => p_attribute14,
X_attribute15 => p_attribute15,
X_context => p_context,
X_config_system_type => p_config_system_type);