APPS.PA_PROJECT_REQUEST_PUB SQL Statements

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

Line: 119

        PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_PROJECT_REQUEST_PKG.insert_row');

Line: 121

     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 );

Line: 168

      PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW to form the relationship.' );

Line: 170

      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
        );

Line: 197

         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
        );

Line: 340

   PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.cancel_project_request: Calling PA_PROJECT_REQUEST_PKG.update_row');

Line: 345

   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 );

Line: 438

    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;