eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_ROLES_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',
 X_ROWID                        IN OUT     NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 X_PROJECT_ROLE_ID              IN         NUMBER,
 X_PROJECT_ROLE_TYPE            IN         VARCHAR2,
 X_MEANING                      IN         VARCHAR2,
 X_QUERY_LABOR_COST_FLAG        IN         VARCHAR2,
 X_START_DATE_ACTIVE            IN         DATE,
 X_LAST_UPDATE_DATE             IN         DATE,
 X_LAST_UPDATED_BY              IN         NUMBER,
 X_CREATION_DATE                IN         DATE,
 X_CREATED_BY                   IN         NUMBER,
 X_LAST_UPDATE_LOGIN            IN         NUMBER,
 X_END_DATE_ACTIVE              IN         DATE,
 X_DESCRIPTION                  IN         VARCHAR2,
 X_DEFAULT_MIN_JOB_LEVEL        IN         NUMBER,
 X_DEFAULT_MAX_JOB_LEVEL        IN         NUMBER,
 X_MENU_ID                      IN         NUMBER,
 X_DEFAULT_JOB_ID               IN         NUMBER,
 X_FREEZE_RULES_FLAG            IN         VARCHAR2,
 X_ATTRIBUTE_CATEGORY           IN         VARCHAR2,
 X_ATTRIBUTE1                   IN         VARCHAR2,
 X_ATTRIBUTE2                   IN         VARCHAR2,
 X_ATTRIBUTE3                   IN         VARCHAR2,
 X_ATTRIBUTE4                   IN         VARCHAR2,
 X_ATTRIBUTE5                   IN         VARCHAR2,
 X_ATTRIBUTE6                   IN         VARCHAR2,
 X_ATTRIBUTE7                   IN         VARCHAR2,
 X_ATTRIBUTE8                   IN         VARCHAR2,
 X_ATTRIBUTE9                   IN         VARCHAR2,
 X_ATTRIBUTE10                  IN         VARCHAR2,
 X_ATTRIBUTE11                  IN         VARCHAR2,
 X_ATTRIBUTE12                  IN         VARCHAR2,
 X_ATTRIBUTE13                  IN         VARCHAR2,
 X_ATTRIBUTE14                  IN         VARCHAR2,
 X_ATTRIBUTE15                  IN         VARCHAR2,
 X_DEFAULT_ACCESS_LEVEL         IN         VARCHAR2,
 X_ROLE_PARTY_CLASS             IN         VARCHAR2 DEFAULT 'PERSON',
 X_STATUS_LEVEL                 IN         VARCHAR2 DEFAULT NULL,
 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
v_sqlcode varchar2(30);

Line: 60


 pa_project_role_types_pkg.insert_row(
 X_ROWID                        ,
 X_PROJECT_ROLE_ID              ,
 X_PROJECT_ROLE_TYPE            ,
 X_MEANING                      ,
 X_QUERY_LABOR_COST_FLAG        ,
 NVL(X_START_DATE_ACTIVE, TRUNC(SYSDATE))            ,
 X_LAST_UPDATE_DATE             ,
 X_LAST_UPDATED_BY              ,
 X_CREATION_DATE                ,
 X_CREATED_BY                   ,
 X_LAST_UPDATE_LOGIN            ,
 X_END_DATE_ACTIVE              ,
 X_DESCRIPTION                  ,
 X_DEFAULT_MIN_JOB_LEVEL        ,
 X_DEFAULT_MAX_JOB_LEVEL        ,
 X_MENU_ID                      ,
 X_DEFAULT_JOB_ID               ,
 X_FREEZE_RULES_FLAG            ,
 X_ATTRIBUTE_CATEGORY           ,
 X_ATTRIBUTE1                   ,
 X_ATTRIBUTE2                   ,
 X_ATTRIBUTE3                   ,
 X_ATTRIBUTE4                   ,
 X_ATTRIBUTE5                   ,
 X_ATTRIBUTE6                   ,
 X_ATTRIBUTE7                   ,
 X_ATTRIBUTE8                   ,
 X_ATTRIBUTE9                   ,
 X_ATTRIBUTE10                  ,
 X_ATTRIBUTE11                  ,
 X_ATTRIBUTE12                  ,
 X_ATTRIBUTE13                  ,
 X_ATTRIBUTE14                  ,
 X_ATTRIBUTE15                  ,
 X_DEFAULT_ACCESS_LEVEL         ,
 X_ROLE_PARTY_CLASS             ,
 X_STATUS_LEVEL
);

Line: 118


        p_procedure_name => 'INSERT_ROW',
        P_ERROR_TEXT =>v_sqlcode);

Line: 154


procedure UPDATE_ROW (
 p_commit                       IN         VARCHAR2:=FND_API.G_FALSE,
 p_debug_mode                   in         varchar2 default 'N',
 X_ROWID                        IN OUT     NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 X_PROJECT_ROLE_ID              IN         NUMBER,
 X_PROJECT_ROLE_TYPE            IN         VARCHAR2,
 X_MEANING                      IN         VARCHAR2,
 X_QUERY_LABOR_COST_FLAG        IN         VARCHAR2,
 X_START_DATE_ACTIVE            IN         DATE,
 X_LAST_UPDATE_DATE             IN         DATE,
 X_LAST_UPDATED_BY              IN         NUMBER,
 X_CREATION_DATE                IN         DATE,
 X_CREATED_BY                   IN         NUMBER,
 X_LAST_UPDATE_LOGIN            IN         NUMBER,
 X_END_DATE_ACTIVE              IN         DATE,
 X_DESCRIPTION                  IN         VARCHAR2,
 X_DEFAULT_MIN_JOB_LEVEL        IN         NUMBER,
 X_DEFAULT_MAX_JOB_LEVEL        IN         NUMBER,
 X_MENU_ID                      IN         NUMBER,
 X_DEFAULT_JOB_ID               IN         NUMBER,
 X_FREEZE_RULES_FLAG            IN         VARCHAR2,
 X_ATTRIBUTE_CATEGORY           IN         VARCHAR2,
 X_ATTRIBUTE1                   IN         VARCHAR2,
 X_ATTRIBUTE2                   IN         VARCHAR2,
 X_ATTRIBUTE3                   IN         VARCHAR2,
 X_ATTRIBUTE4                   IN         VARCHAR2,
 X_ATTRIBUTE5                   IN         VARCHAR2,
 X_ATTRIBUTE6                   IN         VARCHAR2,
 X_ATTRIBUTE7                   IN         VARCHAR2,
 X_ATTRIBUTE8                   IN         VARCHAR2,
 X_ATTRIBUTE9                   IN         VARCHAR2,
 X_ATTRIBUTE10                  IN         VARCHAR2,
 X_ATTRIBUTE11                  IN         VARCHAR2,
 X_ATTRIBUTE12                  IN         VARCHAR2,
 X_ATTRIBUTE13                  IN         VARCHAR2,
 X_ATTRIBUTE14                  IN         VARCHAR2,
 X_ATTRIBUTE15                  IN         VARCHAR2,
 X_DEFAULT_ACCESS_LEVEL         IN         VARCHAR2,
 X_ROLE_PARTY_CLASS             IN         VARCHAR2 DEFAULT 'PERSON',
 X_STATUS_LEVEL                 IN         VARCHAR2 DEFAULT NULL,
 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
v_menu_id number;

Line: 210


 select menu_id, meaning, created_by
  into   v_menu_id, v_meaning, v_created_by
  from pa_project_role_types_vl
  where row_id=x_rowid;

Line: 238


  pa_project_role_types_pkg.update_row(
 X_ROWID                        ,
 X_PROJECT_ROLE_ID              ,
 X_PROJECT_ROLE_TYPE            ,
 X_MEANING                      ,
 X_QUERY_LABOR_COST_FLAG        ,
 X_START_DATE_ACTIVE            ,
 X_LAST_UPDATE_DATE             ,
 X_LAST_UPDATED_BY              ,
 X_CREATION_DATE                ,
 X_CREATED_BY                   ,
 X_LAST_UPDATE_LOGIN            ,
 X_END_DATE_ACTIVE              ,
 X_DESCRIPTION                  ,
 X_DEFAULT_MIN_JOB_LEVEL        ,
 X_DEFAULT_MAX_JOB_LEVEL        ,
 X_MENU_ID                      ,
 X_DEFAULT_JOB_ID               ,
 X_FREEZE_RULES_FLAG            ,
 X_ATTRIBUTE_CATEGORY           ,
 X_ATTRIBUTE1                   ,
 X_ATTRIBUTE2                   ,
 X_ATTRIBUTE3                   ,
 X_ATTRIBUTE4                   ,
 X_ATTRIBUTE5                   ,
 X_ATTRIBUTE6                   ,
 X_ATTRIBUTE7                   ,
 X_ATTRIBUTE8                   ,
 X_ATTRIBUTE9                   ,
 X_ATTRIBUTE10                  ,
 X_ATTRIBUTE11                  ,
 X_ATTRIBUTE12                  ,
 X_ATTRIBUTE13                  ,
 X_ATTRIBUTE14                  ,
 X_ATTRIBUTE15                  ,
 X_DEFAULT_ACCESS_LEVEL         ,
 X_ROLE_PARTY_CLASS             ,
 X_STATUS_LEVEL
) ;

Line: 282


      pa_role_utils.update_menu_in_grants(x_project_role_id,
                                        x_menu_id,
                                        x_return_status,
                                        v_error_message_code);

Line: 294


            p_procedure_name => 'update_menu_in_grants',
            P_ERROR_TEXT =>v_error_message_code);

Line: 361


        p_procedure_name => 'UPDATE_ROW',
        P_ERROR_TEXT =>v_sqlcode);

Line: 367


procedure DELETE_ROW (
 p_commit                       IN         VARCHAR2:=FND_API.G_FALSE,
 p_debug_mode                   in         varchar2 default 'N',
 X_ROWID in varchar2,
 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
 v_role_id  number;

Line: 383


  select project_role_id, created_by
  into v_role_id, v_created_by
  from pa_project_role_types_vl
  where row_id=X_ROWID;

Line: 398


  pa_role_utils.check_delete_role_ok(v_role_id,
                                     x_return_status,
                                     v_error_message_code);

Line: 405


     pa_project_role_types_pkg.delete_row(X_ROWID);

Line: 408


      delete from pa_role_controls
      where project_role_id=v_role_id;

Line: 412


     delete from pa_role_list_members
     where project_role_id=v_role_id;

Line: 416


     OKE_K_ACCESS_RULES_PKG.delete_all(v_role_id);

Line: 419


     delete from per_competence_elements
     where OBJECT_ID=v_role_id
     and  OBJECT_NAME='PROJECT_ROLE';

Line: 431


        p_procedure_name => 'check_delete_role_ok',
        P_ERROR_TEXT =>v_error_message_code);

Line: 441


        p_procedure_name => 'DELETE_ROW',
        P_ERROR_TEXT =>v_sqlcode);