The following lines contain the word 'select', 'insert', 'update' or 'delete':
PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_PROJECT_REQUEST_PKG.insert_row');
PA_PROJECT_REQUEST_PKG.insert_row
( p_request_name => p_request_name ,
p_request_type => p_request_type,
p_request_status_code => l_request_status_code,
p_description => p_description,
p_expected_proj_approval_date => p_expected_proj_approval_date,
p_closed_date => null,
p_source_type => p_source_type ,
p_application_id => p_application_id,
p_source_reference => p_source_reference,
p_value => p_value,
p_currency_code => p_currency_code,
p_cust_party_id => p_cust_party_id,
p_cust_party_site_id => p_cust_party_site_id,
p_cust_account_id => p_cust_account_id,
p_source_org_id => p_source_org_id,
p_record_version_number => 1 ,
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
x_request_id => x_request_id,
x_request_number => x_request_number,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data );
PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW to form the relationship.' );
PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
p_user_id => FND_GLOBAL.USER_ID
,p_object_type_from => p_source_object
,p_object_id_from1 => p_source_id
,p_object_id_from2 => NULL
,p_object_id_from3 => NULL
,p_object_id_from4 => NULL
,p_object_id_from5 => NULL
,p_object_type_to => 'PA_PROJECT_REQUESTS'
,p_object_id_to1 => x_request_id
,p_object_id_to2 => NULL
,p_object_id_to3 => NULL
,p_object_id_to4 => NULL
,p_object_id_to5 => NULL
,p_relationship_type => 'A'
,p_relationship_subtype => 'PROJECT_REQUEST'
,p_lag_day => NULL
,p_imported_lag => NULL
,p_priority => NULL
,p_pm_product_code => NULL
,x_object_relationship_id => l_new_obj_rel_id
,x_return_status => x_return_status
);
PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
p_user_id => FND_GLOBAL.USER_ID
,p_object_type_from => 'PA_PROJECT_REQUESTS'
,p_object_id_from1 => x_request_id
,p_object_id_from2 => NULL
,p_object_id_from3 => NULL
,p_object_id_from4 => NULL
,p_object_id_from5 => NULL
,p_object_type_to => p_source_object
,p_object_id_to1 => p_source_id
,p_object_id_to2 => NULL
,p_object_id_to3 => NULL
,p_object_id_to4 => NULL
,p_object_id_to5 => NULL
,p_relationship_type => 'A'
,p_relationship_subtype => 'PROJECT_REQUEST'
,p_lag_day => NULL
,p_imported_lag => NULL
,p_priority => NULL
,p_pm_product_code => NULL
,x_object_relationship_id => l_new_obj_rel_id2
,x_return_status => x_return_status
);
PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.cancel_project_request: Calling PA_PROJECT_REQUEST_PKG.update_row');
PA_PROJECT_REQUEST_PKG.update_row
( p_request_id =>p_request_id,
p_request_status_code =>'123',
p_closed_date => null,
p_record_version_number =>p_record_version_number,
x_return_status =>x_return_status,
x_msg_count =>x_msg_count,
x_msg_data =>x_msg_data );
update PA_PROJECT_REQUESTS
set CUST_PARTY_ID = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
record_version_number = nvl(record_Version_number,0) +1
where CUST_PARTY_ID = p_from_fk_id;