APPS.PA_ROLE_JOB_BG_PVT SQL Statements

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

Line: 4

procedure INSERT_ROW (
 p_commit                       IN         VARCHAR2:=FND_API.G_FALSE,
 p_debug_mode                   IN         VARCHAR2 DEFAULT 'N',
 P_ROLE_JOB_BG_ID               OUT NOCOPY NUMBER,
 P_PROJECT_ROLE_ID              IN         NUMBER,
 P_BUSINESS_GROUP_ID            IN         NUMBER,
 P_JOB_ID                       IN         NUMBER,
 P_MIN_JOB_LEVEL                IN         NUMBER,
 P_MAX_JOB_LEVEL                IN         NUMBER,
 P_OBJECT_VERSION_NUMBER        OUT NOCOPY NUMBER,
 P_LAST_UPDATE_DATE             IN         DATE,
 P_LAST_UPDATED_BY              IN         NUMBER,
 P_CREATION_DATE                IN         DATE,
 P_CREATED_BY                   IN         NUMBER,
 P_LAST_UPDATE_LOGIN            IN         NUMBER,
 p_return_status                OUT NOCOPY VARCHAR2,
 p_msg_count                    OUT NOCOPY NUMBER,
 p_msg_data                     OUT NOCOPY VARCHAR2
) IS

l_sqlcode            varchar2(30);

Line: 50

   pa_role_job_bg_pkg.insert_row(
      P_ROLE_JOB_BG_ID               =>        P_ROLE_JOB_BG_ID,
      P_PROJECT_ROLE_ID              =>        P_PROJECT_ROLE_ID,
      P_BUSINESS_GROUP_ID            =>        P_BUSINESS_GROUP_ID,
      P_JOB_ID                       =>        P_JOB_ID,
      P_MIN_JOB_LEVEL                =>        P_MIN_JOB_LEVEL,
      P_MAX_JOB_LEVEL                =>        P_MAX_JOB_LEVEL,
      P_OBJECT_VERSION_NUMBER        =>        P_OBJECT_VERSION_NUMBER,
      P_LAST_UPDATE_DATE             =>        P_LAST_UPDATE_DATE,
      P_LAST_UPDATED_BY              =>        P_LAST_UPDATED_BY,
      P_CREATION_DATE                =>        P_CREATION_DATE,
      P_CREATED_BY                   =>        P_CREATED_BY,
      P_LAST_UPDATE_LOGIN            =>        P_LAST_UPDATE_LOGIN
   );

Line: 92

        p_procedure_name => 'INSERT_ROW',
        p_error_text     => l_sqlcode);

Line: 140

procedure UPDATE_ROW (
 p_commit                       IN         VARCHAR2:=FND_API.G_FALSE,
 p_debug_mode                   IN         VARCHAR2 DEFAULT 'N',
 P_ROLE_JOB_BG_ID               IN         NUMBER,
 P_PROJECT_ROLE_ID              IN         NUMBER,
 P_BUSINESS_GROUP_ID            IN         NUMBER,
 P_JOB_ID                       IN         NUMBER,
 P_MIN_JOB_LEVEL                IN         NUMBER,
 P_MAX_JOB_LEVEL                IN         NUMBER,
 P_OBJECT_VERSION_NUMBER        IN OUT NOCOPY    NUMBER,
 P_LAST_UPDATE_DATE             IN         DATE,
 P_LAST_UPDATED_BY              IN         NUMBER,
 P_CREATION_DATE                IN         DATE,
 P_CREATED_BY                   IN         NUMBER,
 P_LAST_UPDATE_LOGIN            IN         NUMBER,
 p_return_status                OUT NOCOPY VARCHAR2,
 p_msg_count                    OUT NOCOPY NUMBER,
 p_msg_data                     OUT NOCOPY VARCHAR2
) is

l_error_message_code    VARCHAR2(30);

Line: 170

select business_group_id
  into l_business_group_id
  from pa_role_job_bgs
 where role_job_bg_id = p_role_job_bg_id;

Line: 193

   pa_role_job_bg_pkg.update_row(
      P_ROLE_JOB_BG_ID               =>        P_ROLE_JOB_BG_ID,
      P_PROJECT_ROLE_ID              =>        P_PROJECT_ROLE_ID,
      P_BUSINESS_GROUP_ID            =>        P_BUSINESS_GROUP_ID,
      P_JOB_ID                       =>        P_JOB_ID,
      P_MIN_JOB_LEVEL                =>        P_MIN_JOB_LEVEL,
      P_MAX_JOB_LEVEL                =>        P_MAX_JOB_LEVEL,
      P_OBJECT_VERSION_NUMBER        =>        P_OBJECT_VERSION_NUMBER,
      P_LAST_UPDATE_DATE             =>        P_LAST_UPDATE_DATE,
      P_LAST_UPDATED_BY              =>        P_LAST_UPDATED_BY,
      P_CREATION_DATE                =>        P_CREATION_DATE,
      P_CREATED_BY                   =>        P_CREATED_BY,
      P_LAST_UPDATE_LOGIN            =>        P_LAST_UPDATE_LOGIN
   );

Line: 231

        p_procedure_name => 'UPDATE_ROW',
        p_error_text     => l_sqlcode);

Line: 238

procedure DELETE_ROW (
 p_commit                       IN         VARCHAR2:=FND_API.G_FALSE,
 p_debug_mode                   IN         VARCHAR2 DEFAULT 'N',
 P_ROLE_JOB_BG_ID               IN         NUMBER,
 P_OBJECT_VERSION_NUMBER        IN         NUMBER,
 p_return_status                OUT NOCOPY VARCHAR2,
 p_msg_count                    OUT NOCOPY NUMBER,
 p_msg_data                     OUT NOCOPY VARCHAR2
) is

l_error_message_code  VARCHAR2(30);

Line: 265

   pa_role_job_bg_pkg.delete_row(
      P_ROLE_JOB_BG_ID               =>         P_ROLE_JOB_BG_ID,
      P_OBJECT_VERSION_NUMBER        =>         P_OBJECT_VERSION_NUMBER
   );

Line: 286

        p_procedure_name => 'DELETE_ROW',
        p_error_text     => l_sqlcode);