APPS.PA_RES_LIST_ASSIGNMENTS SQL Statements

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

Line: 17

        Select Project_Id from Pa_Projects_all -- changed for bug 6743458
        where Project_id = X_Project_Id;

Line: 20

        Select End_Date_Active  from PA_RESOURCE_LISTS
        where Resource_list_Id = X_Resource_List_id;

Line: 29

        x_err_stage := 'Select Project_id from Pa_Projects '||
                       To_Char(X_project_id);

Line: 40

        x_err_stage := 'Select End_date_Active from Pa_Resource_lists '||
                       To_Char(X_resource_list_id);

Line: 67

          x_err_stage := 'Select pa_resource_list_assignments_s.nextval';

Line: 68

          Select Pa_Resource_list_Assignments_s.nextval into W_num
          from Dual;

Line: 70

          x_err_stage := 'Insert into Pa_Resource_list_assignments ';

Line: 71

          Insert into Pa_Resource_list_Assignments
          (RESOURCE_LIST_ASSIGNMENT_ID,RESOURCE_LIST_ID,PROJECT_ID,
           RESOURCE_LIST_CHANGED_FLAG,LAST_UPDATED_BY,LAST_UPDATE_DATE,
           CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,
           RESOURCE_LIST_ACCUMULATED_FLAG) Values
           (W_Num,X_Resource_list_id,X_project_id,'N',Nvl(W_user_id,-1),
           Trunc(Sysdate),Trunc(Sysdate),
           Nvl(W_user_id ,-1),Nvl(W_login_id,-1),'N');

Line: 101

        Select Resource_list_Assignment_Id  from PA_RESOURCE_LIST_ASSIGNMENTS
        where Resource_list_Id = X_Resource_List_id and
              Project_id       = X_Project_id;

Line: 108

       x_err_stage := ' Select Resource_List_Assignment_id from '||
                      ' PA_RESOURCE_LIST_ASSIGNMENTS '||
                        To_Char(X_Resource_List_Id);

Line: 144

W_insert_Flag  Char(1) := 'N';

Line: 145

W_Update_Flag  Char(1) := 'N';

Line: 149

        Select Project_id,Resource_list_Id  from
        PA_RESOURCE_LIST_ASSIGNMENTS
        Where  Resource_list_Assignment_Id = X_Resource_list_Assgmt_id;

Line: 153

        Select Budget_Type_Yn from PA_RESOURCE_LIST_USE_CODES_V where
        List_Use_Code = X_Use_Code;

Line: 156

       Select Row_id,Resource_List_Id
       from Pa_Resource_list_uses_v where Project_id = X_Project_id and
       Use_Code = X_Use_Code ;

Line: 166

        x_err_stage := 'Select Project_id,Resource_list_Id '||
                       ' from Pa_Resource_list_Assignments  '||
                       To_Char(X_Resource_list_Assgmt_id);

Line: 178

        x_err_stage := 'Select  Budget_Type_Yn from  '||
                       ' PA_RESOURCE_LIST_USE_CODES_V '||
                       To_Char(W_Asgmt_Res_list_id);

Line: 190

       x_err_stage := ' Select Row_id,Resource_List_id from '||
                      ' PA_RESOURCE_LIST_ASSIGNMENTS '||
                        To_Char(X_Project_Id);

Line: 197

          W_insert_flag := 'Y';

Line: 202

                 x_err_stage := ' Update Pa_Resource_List_Uses ';

Line: 203

                 Update Pa_Resource_List_uses
                 Set Resource_list_Assignment_id  =
                 X_Resource_list_Assgmt_id
                 Where RowId = W_Row_Id;

Line: 210

                 W_Insert_Flag := 'Y';

Line: 218

      If W_Insert_Flag = 'Y' Then
         x_err_stage := ' Insert into Pa_Resource_List_Uses ';

Line: 220

         Insert into Pa_Resource_list_uses
         (RESOURCE_LIST_ASSIGNMENT_ID,USE_CODE,DEFAULT_FLAG,
         LAST_UPDATED_BY,LAST_UPDATE_DATE,
         CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN) Values
         (X_Resource_list_Assgmt_id,X_Use_Code,'N',
          Nvl(W_user_id,-1), Trunc(Sysdate),
          Trunc(Sysdate),Nvl(W_user_id,-1),Nvl(W_login_id,-1));

Line: 234

 Procedure Delete_Rl_Uses  (X_Resource_list_Assgmt_id In Number,
                            X_Use_Code      IN Varchar2,
                            X_err_code  IN  Out NOCOPY Number, --File.Sql.39 bug 4440895
                            X_err_stage IN  Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
                            x_err_stack IN  Out NOCOPY Varchar2 ) Is --File.Sql.39 bug 4440895

W_Assgmt_Id Number := 0;

Line: 243

        Select Resource_list_Assignment_Id  from PA_RESOURCE_LIST_USES_V
        where Resource_list_Assignment_id = X_Resource_list_Assgmt_id;

Line: 249

        X_err_stack := X_err_stack ||'->PA_RES_LIST_ASSIGNMENTS.Delete_Rl_Uses';

Line: 250

        x_err_stage := ' Delete from PA_RESOURCE_LIST_USES';

Line: 251

        Delete from PA_RESOURCE_LIST_USES Where
        Resource_List_Assignment_id = X_Resource_list_Assgmt_id and
        Use_Code                    = X_Use_Code;

Line: 260

        ' Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_USES_V '
        || To_Char(X_Resource_list_Assgmt_id);

Line: 265

          x_err_stage := 'Delete from Pa_Resource_list_assignments ';

Line: 266

          Delete from PA_RESOURCE_LIST_ASSIGNMENTS where
          RESOURCE_LIST_ASSIGNMENT_ID = X_Resource_list_Assgmt_id;

Line: 277

 Procedure Delete_Rl_Assgmt(X_Resource_list_Assgmt_id In Number,
                            X_err_code  IN  Out NOCOPY Number, --File.Sql.39 bug 4440895
                            X_err_stage IN  Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
                            x_err_stack IN  Out NOCOPY Varchar2 ) Is --File.Sql.39 bug 4440895

W_Assgmt_Id Number := 0;

Line: 285

        Select Resource_list_Assignment_Id  from PA_RESOURCE_LIST_USES
        where Resource_list_Assignment_id = X_Resource_list_Assgmt_id;

Line: 291

       X_err_stack := X_err_stack ||'->PA_RES_LIST_ASSIGNMENTS.Delete_Rl_Asgmt';

Line: 293

        ' Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_USES '
        || To_Char(X_Resource_list_Assgmt_id);

Line: 298

          x_err_stage := 'Delete from Pa_Resource_list_assignments ';

Line: 299

          Delete from PA_RESOURCE_LIST_ASSIGNMENTS where
          RESOURCE_LIST_ASSIGNMENT_ID = X_Resource_list_Assgmt_id;