APPS.PA_RESOURCE_SETUP_PUB SQL Statements

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

Line: 11

PROCEDURE UPDATE_ADDITIONAL_STAFF_INFO
( p_api_version                  IN NUMBER     := 1.0
 ,p_init_msg_list                IN VARCHAR2   := FND_API.G_TRUE
 ,p_commit                       IN VARCHAR2   := FND_API.G_FALSE
 ,p_validate_only                IN VARCHAR2   := FND_API.G_TRUE
 ,p_project_id                   IN NUMBER
 ,p_calendar_id                  IN NUMBER     := FND_API.G_MISS_NUM
 ,p_calendar_name                IN VARCHAR2   := FND_API.G_MISS_CHAR
 ,p_role_list_id                 IN NUMBER     := FND_API.G_MISS_NUM
 ,p_adv_action_set_id            IN NUMBER     := FND_API.G_MISS_NUM
 ,p_adv_action_set_name          IN VARCHAR2   := FND_API.G_MISS_CHAR
 ,p_start_adv_action_set_flag    IN VARCHAR2   := FND_API.G_MISS_CHAR
 ,p_record_version_number        IN NUMBER
 ,p_initial_team_template_id     IN NUMBER     := FND_API.G_MISS_NUM  -- added for bug 2607631
 ,p_proj_req_res_format_id       IN NUMBER     := FND_API.G_MISS_NUM
 ,p_proj_asgmt_res_format_id     IN NUMBER     := FND_API.G_MISS_NUM
 ,p_max_msg_count                IN NUMBER     := FND_API.G_MISS_NUM
 ,x_return_status                OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
 ,x_msg_count                    OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
 ,x_msg_data                     OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
IS

l_api_name           CONSTANT VARCHAR(30) := 'update_addition_staff_info';

Line: 49

      SAVEPOINT update_addition_staff_info;

Line: 53

   pa_debug.init_err_stack('PA_RESOURCE_SETUP_PUB.update_addition_staff_info');

Line: 54

   PA_DEBUG.write_log (x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info.begin'
       ,x_msg => 'Beginning of PA_RESOURCE_SETUP_PUB.update_addition_staff_info'
       ,x_log_level   => 5);

Line: 66

   pa_debug.write(x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info'
		 ,x_msg         => 'adv_id='||p_adv_action_set_id||
				   ' adv_name='||p_adv_action_set_name||
				   ' req_format='||p_proj_req_res_format_id||
				   ' asgmt_format='||p_proj_asgmt_res_format_id
   	         ,x_log_level   => li_message_level);

Line: 123

     PA_RESOURCE_SETUP_PVT.UPDATE_ADDITIONAL_STAFF_INFO
     (
      p_commit                       => FND_API.G_FALSE,
      p_validate_only                => p_validate_only,
      p_project_id                   => p_project_id,
      p_calendar_id                  => l_calendar_id,
      p_role_list_id                 => p_role_list_id,
      p_adv_action_set_id            => l_adv_action_set_id,
      p_start_adv_action_set_flag    => p_start_adv_action_set_flag,
      p_record_version_number        => p_record_version_number,
      p_initial_team_template_id     => p_initial_team_template_id, -- added for bug 2607631
      p_proj_req_res_format_id       => p_proj_req_res_format_id,
      p_proj_asgmt_res_format_id     => p_proj_asgmt_res_format_id,
      p_max_msg_count                => p_max_msg_count,
      x_return_status                => l_return_status,
      x_msg_count                    => l_msg_count,
      x_msg_data                     => l_msg_data);

Line: 163

        ROLLBACK TO update_addition_staff_info;

Line: 170

         ROLLBACK TO update_addition_staff_info;

Line: 174

                              p_procedure_name => 'UPDATE_ADDITIONAL_STAFF_INFO',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 179

END UPDATE_ADDITIONAL_STAFF_INFO;