APPS.PA_CI_TYPE_USAGE_PVT SQL Statements

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

Line: 14

  p_last_update_login		IN NUMBER DEFAULT fnd_global.user_id,
  x_ci_type_usage_id		OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  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_rowid VARCHAR2(30);

Line: 38

    pa_ci_type_usage_pkg.insert_row(
      x_rowid => l_rowid,
      x_ci_type_usage_id => x_ci_type_usage_id,
      x_project_type_id => p_project_type_id,
      x_ci_type_id => p_ci_type_id,
      x_creation_date => p_creation_date,
      x_created_by => p_created_by,
      x_last_update_date => p_creation_date,
      x_last_updated_by => p_created_by,
      x_last_update_login => p_last_update_login);

Line: 78

PROCEDURE update_ci_type_usage (
  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_max_msg_count		IN NUMBER := FND_API.g_miss_num,
  p_ci_type_usage_id            IN NUMBER,
  p_project_type_id		IN NUMBER,
  p_ci_type_id			IN NUMBER,
  p_last_updated_by     	IN NUMBER DEFAULT fnd_global.user_id,
  p_last_update_date		IN DATE DEFAULT SYSDATE,
  p_last_update_login		IN NUMBER DEFAULT fnd_global.user_id,
  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
BEGIN
  pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.UPDATE_CI_TYPE_USAGE');

Line: 99

    SAVEPOINT update_ci_type_usage;

Line: 111

    pa_ci_type_usage_pkg.update_row(
      x_ci_type_usage_id => p_ci_type_usage_id,
      x_project_type_id => p_project_type_id,
      x_ci_type_id => p_ci_type_id,
      x_last_update_date => p_last_update_date,
      x_last_updated_by => p_last_updated_by,
      x_last_update_login => p_last_update_login);

Line: 124

      ROLLBACK TO update_ci_type_usage;

Line: 136

      ROLLBACK TO update_ci_type_usage;

Line: 141

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

Line: 146

END update_ci_type_usage;

Line: 148

PROCEDURE delete_ci_type_usage (
  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_max_msg_count		IN NUMBER := FND_API.g_miss_num,
  p_ci_type_usage_id		IN NUMBER,
  p_project_type_id             IN NUMBER,
  p_ci_type_id                  IN NUMBER,
  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_temp VARCHAR2(1);

Line: 164

  pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.DELETE_CI_TYPE_USAGE');

Line: 167

    SAVEPOINT delete_ci_type_usage;

Line: 185

    pa_ci_type_usage_pkg.delete_row(
      x_ci_type_usage_id => p_ci_type_usage_id);

Line: 193

      ROLLBACK TO delete_ci_type_usage;

Line: 205

      ROLLBACK TO delete_ci_type_usage;

Line: 210

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

Line: 215

END delete_ci_type_usage;