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_ACTION_SETS_PVT SQL Statements

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

Line: 125


                     ,x_msg         => 'before pa_action_sets_pkg.insert_row'
                     ,x_log_level   => 5);

Line: 129


     PA_ACTION_SETS_PKG.insert_row
          (p_action_set_type_code   =>   p_action_set_type_code
          ,p_action_set_name        =>   p_action_set_name
          ,p_object_type            =>   p_object_type
          ,p_object_id              =>   p_object_id
          ,p_start_date_active      =>   p_start_date_active
          ,p_end_date_active        =>   p_end_date_active
          ,p_description            =>   p_description
          ,p_source_action_set_id   =>   p_source_action_set_id
          ,p_status_code            =>   l_status_code
          ,p_actual_start_date      =>   l_actual_start_date
          ,p_action_set_template_flag => p_action_set_template_flag
          ,p_attribute_category     =>   p_attribute_category
          ,p_attribute1             =>   p_attribute1
          ,p_attribute2             =>   p_attribute2
          ,p_attribute3             =>   p_attribute3
          ,p_attribute4             =>   p_attribute4
          ,p_attribute5             =>   p_attribute5
          ,p_attribute6             =>   p_attribute6
          ,p_attribute7             =>   p_attribute7
          ,p_attribute8             =>   p_attribute8
          ,p_attribute9             =>   p_attribute9
          ,p_attribute10            =>   p_attribute10
          ,p_attribute11            =>   p_attribute11
          ,p_attribute12            =>   p_attribute12
          ,p_attribute13            =>   p_attribute13
          ,p_attribute14            =>   p_attribute14
          ,p_attribute15            =>   p_attribute15
          ,x_action_set_id          =>   x_action_set_id
          ,x_return_status          =>   l_return_status);

Line: 186


PROCEDURE update_action_set
 (p_action_set_id          IN    pa_action_sets.action_set_id%TYPE           := NULL
 ,p_action_set_name        IN    pa_action_sets.action_set_name%TYPE         := FND_API.G_MISS_CHAR
 ,p_action_set_type_code   IN    pa_action_sets.action_set_type_code%TYPE    := FND_API.G_MISS_CHAR
 ,p_start_date_active      IN    pa_action_sets.start_date_active%TYPE       := FND_API.G_MISS_DATE
 ,p_end_date_active        IN    pa_action_sets.end_date_active%TYPE         := FND_API.G_MISS_DATE
 ,p_action_set_template_flag IN  pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
 ,p_status_code            IN    pa_action_sets.status_code%TYPE              := FND_API.G_MISS_CHAR
 ,p_description            IN    pa_action_sets.description%TYPE             := FND_API.G_MISS_CHAR
 ,p_record_version_number  IN    pa_action_sets.record_version_number%TYPE
 ,p_attribute_category     IN    pa_action_sets.attribute_category%TYPE      := FND_API.G_MISS_CHAR
 ,p_attribute1             IN    pa_action_sets.attribute1%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute2             IN    pa_action_sets.attribute2%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute3             IN    pa_action_sets.attribute3%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute4             IN    pa_action_sets.attribute4%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute5             IN    pa_action_sets.attribute5%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute6             IN    pa_action_sets.attribute6%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute7             IN    pa_action_sets.attribute7%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute8             IN    pa_action_sets.attribute8%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute9             IN    pa_action_sets.attribute9%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute10            IN    pa_action_sets.attribute10%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute11            IN    pa_action_sets.attribute11%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute12            IN    pa_action_sets.attribute12%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute13            IN    pa_action_sets.attribute13%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute14            IN    pa_action_sets.attribute14%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute15            IN    pa_action_sets.attribute15%TYPE             := FND_API.G_MISS_CHAR
 ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS

 l_return_status             VARCHAR2(1);

Line: 240


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PVT.Update_Action_Set.begin'
                     ,x_msg         => 'Beginning of Update_Action_Set pvt'
                     ,x_log_level   => 5);

Line: 245


    SELECT action_set_type_code,
           action_set_template_flag
      INTO l_action_set_type_code,
           l_action_set_template_flag
      FROM pa_action_sets
     WHERE action_set_id = p_action_set_id;

Line: 281


        SELECT status_code INTO l_previous_status
          FROM pa_action_sets
         WHERE action_set_id = p_action_set_id;

Line: 295


     PA_ACTION_SETS_PKG.update_row
          (p_action_set_id          =>   p_action_set_id
          ,p_action_set_name        =>   p_action_set_name
          ,p_start_date_active      =>   p_start_date_active
          ,p_end_date_active        =>   p_end_date_active
          ,p_description            =>   p_description
          ,p_status_code            =>   p_status_code
          ,p_actual_start_date      =>   l_actual_start_date
          ,p_attribute_category     =>   p_attribute_category
          ,p_attribute1             =>   p_attribute1
          ,p_attribute2             =>   p_attribute2
          ,p_attribute3             =>   p_attribute3
          ,p_attribute4             =>   p_attribute4
          ,p_attribute5             =>   p_attribute5
          ,p_attribute6             =>   p_attribute6
          ,p_attribute7             =>   p_attribute7
          ,p_attribute8             =>   p_attribute8
          ,p_attribute9             =>   p_attribute9
          ,p_attribute10            =>   p_attribute10
          ,p_attribute11            =>   p_attribute11
          ,p_attribute12            =>   p_attribute12
          ,p_attribute13            =>   p_attribute13
          ,p_attribute14            =>   p_attribute14
          ,p_attribute15            =>   p_attribute15
          ,x_return_status          =>   l_return_status);

Line: 354


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 360


 END Update_Action_Set;

Line: 363


PROCEDURE delete_action_set
 (p_action_set_id          IN    pa_action_sets.action_set_id%TYPE
 ,p_record_version_number  IN    pa_action_sets.record_version_number%TYPE   := NULL
 ,x_return_status         OUT    NOCOPY VARCHAR2)  --File.Sql.39 bug 4440895
IS

 l_return_status          VARCHAR2(1);

Line: 391


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PVT.Delete_Action_Set'
                     ,x_msg         => 'Beginning of Delete_Action_Set pvt'
                     ,x_log_level   => 5);

Line: 396


   SELECT action_set_template_flag INTO l_action_set_template_flag
     FROM pa_action_sets
    WHERE action_set_id = p_action_set_id;

Line: 419


        delete_action_set_line(p_action_set_line_id    => l_action_set_lines_tbl(i).action_set_line_id,
                               p_record_version_number => l_action_set_lines_tbl(i).record_version_number,
                               x_return_status         => l_return_status);

Line: 435


        PA_ACTION_SETS_PKG.delete_row
               (p_action_set_id         => p_action_set_id,
                p_record_version_number => p_record_version_number,
                x_return_status         => l_return_status);

Line: 452


        PA_ACTION_SETS_PKG.update_row(p_action_set_id         => p_action_set_id,
                                      p_record_version_number => p_record_version_number,
                                      p_status_code           => 'DELETED',
                                      x_return_status         => l_return_status);

Line: 470


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 476


 END Delete_Action_Set;

Line: 548


  SELECT action_set_type_code, action_set_template_flag
    INTO l_action_set_type_code, l_action_set_template_flag
    FROM pa_action_sets
   WHERE action_set_id = p_action_set_id;

Line: 574


     PA_ACTION_SET_LINES_PKG.Insert_Row
          (p_action_set_id          =>   p_action_set_id
          ,p_action_set_line_number =>   p_action_set_line_number
          ,p_description            =>   p_description
          ,p_status_code            =>   'PENDING'
          ,p_action_code            =>   p_action_code
          ,p_action_attribute1      =>   p_action_attribute1
          ,p_action_attribute2      =>   p_action_attribute2
          ,p_action_attribute3      =>   p_action_attribute3
          ,p_action_attribute4      =>   p_action_attribute4
          ,p_action_attribute5      =>   p_action_attribute5
          ,p_action_attribute6      =>   p_action_attribute6
          ,p_action_attribute7      =>   p_action_attribute7
          ,p_action_attribute8      =>   p_action_attribute8
          ,p_action_attribute9      =>   p_action_attribute9
          ,p_action_attribute10     =>   p_action_attribute10
          ,x_action_set_line_id     =>   l_action_set_line_id
          ,x_return_status          =>   l_return_status);

Line: 596


        PA_ACTION_SET_LINE_COND_PKG.Insert_Row
          (p_action_set_line_id        =>   l_action_set_line_id
          ,p_condition_date            =>   p_condition_tbl(i).condition_date
          ,p_condition_code            =>   p_condition_tbl(i).condition_code
          ,p_description               =>   p_condition_tbl(i).description
          ,p_condition_attribute1      =>   p_condition_tbl(i).condition_attribute1
          ,p_condition_attribute2      =>   p_condition_tbl(i).condition_attribute2
          ,p_condition_attribute3      =>   p_condition_tbl(i).condition_attribute3
          ,p_condition_attribute4      =>   p_condition_tbl(i).condition_attribute4
          ,p_condition_attribute5      =>   p_condition_tbl(i).condition_attribute5
          ,p_condition_attribute6      =>   p_condition_tbl(i).condition_attribute6
          ,p_condition_attribute7      =>   p_condition_tbl(i).condition_attribute7
          ,p_condition_attribute8      =>   p_condition_tbl(i).condition_attribute8
          ,p_condition_attribute9      =>   p_condition_tbl(i).condition_attribute9
          ,p_condition_attribute10     =>   p_condition_tbl(i).condition_attribute10
          ,x_action_set_line_condition_id   =>   l_action_line_condition_id
          ,x_return_status             =>   l_return_status);

Line: 637


PROCEDURE update_action_set_line
 (p_action_set_line_id       IN    pa_action_set_lines.action_set_line_id%TYPE
 ,p_record_version_number    IN    pa_action_set_lines.record_version_number%TYPE
 ,p_action_set_line_number   IN    pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
 ,p_description              IN    pa_action_set_lines.description%TYPE         := FND_API.G_MISS_CHAR
 ,p_action_code              IN    pa_action_set_lines.action_code%TYPE         := FND_API.G_MISS_CHAR
 ,p_action_attribute1        IN    pa_action_set_lines.action_attribute1%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute2        IN    pa_action_set_lines.action_attribute2%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute3        IN    pa_action_set_lines.action_attribute3%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute4        IN    pa_action_set_lines.action_attribute4%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute5        IN    pa_action_set_lines.action_attribute5%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute6        IN    pa_action_set_lines.action_attribute6%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute7        IN    pa_action_set_lines.action_attribute7%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute8        IN    pa_action_set_lines.action_attribute8%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute9        IN    pa_action_set_lines.action_attribute9%TYPE   := FND_API.G_MISS_CHAR
 ,p_action_attribute10       IN    pa_action_set_lines.action_attribute10%TYPE  := FND_API.G_MISS_CHAR
 ,p_condition_tbl            IN    pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
 ,x_return_status           OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS

 l_return_status           VARCHAR2(1);

Line: 677


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PVT.Update_Action_Set_Line.begin'
                     ,x_msg         => 'Beginning of Update_Action_Set_Line pvt'
                     ,x_log_level   => 5);

Line: 682


  SELECT sets.action_set_type_code,
         sets.action_set_id,
         sets.action_set_template_flag,
         lines.status_code
    INTO l_action_set_type_code,
         l_action_set_id,
         l_action_set_template_flag,
         l_current_line_status
    FROM pa_action_sets sets,
         pa_action_set_lines lines
   WHERE lines.action_set_line_id = p_action_set_line_id
     AND sets.action_set_id = lines.action_set_id;

Line: 724


        PA_ACTION_SET_LINES_PKG.Update_Row
             (p_action_set_line_id     =>   p_action_set_line_id
             ,p_action_set_line_number =>   p_action_set_line_number
             ,p_description            =>   p_description
             ,p_action_code            =>   p_action_code
             ,p_action_attribute1      =>   p_action_attribute1
             ,p_action_attribute2      =>   p_action_attribute2
             ,p_action_attribute3      =>   p_action_attribute3
             ,p_action_attribute4      =>   p_action_attribute4
             ,p_action_attribute5      =>   p_action_attribute5
             ,p_action_attribute6      =>   p_action_attribute6
             ,p_action_attribute7      =>   p_action_attribute7
             ,p_action_attribute8      =>   p_action_attribute8
             ,p_action_attribute9      =>   p_action_attribute9
             ,p_action_attribute10     =>   p_action_attribute10
             ,x_return_status          =>   l_return_status);

Line: 744


           PA_ACTION_SET_LINE_COND_PKG.Update_Row
             (p_action_set_line_condition_id   =>   p_condition_tbl(i).action_set_line_condition_id
             ,p_condition_date            =>   p_condition_tbl(i).condition_date
             ,p_condition_code            =>   p_condition_tbl(i).condition_code
             ,p_description               =>   p_condition_tbl(i).description
             ,p_condition_attribute1      =>   p_condition_tbl(i).condition_attribute1
             ,p_condition_attribute2      =>   p_condition_tbl(i).condition_attribute2
             ,p_condition_attribute3      =>   p_condition_tbl(i).condition_attribute3
             ,p_condition_attribute4      =>   p_condition_tbl(i).condition_attribute4
             ,p_condition_attribute5      =>   p_condition_tbl(i).condition_attribute5
             ,p_condition_attribute6      =>   p_condition_tbl(i).condition_attribute6
             ,p_condition_attribute7      =>   p_condition_tbl(i).condition_attribute7
             ,p_condition_attribute8      =>   p_condition_tbl(i).condition_attribute8
             ,p_condition_attribute9      =>   p_condition_tbl(i).condition_attribute9
             ,p_condition_attribute10     =>   p_condition_tbl(i).condition_attribute10
             ,x_return_status             =>   l_return_status);

Line: 776


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set_Line'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 782


END Update_Action_Set_Line;

Line: 785


PROCEDURE delete_action_set_line
 (p_action_set_line_id     IN    pa_action_sets.action_set_id%TYPE
 ,p_record_version_number  IN    pa_action_set_lines.record_version_number%TYPE
 ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS

 l_return_status               VARCHAR2(1);

Line: 811


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PVT.Delete_Action_Set_Line.begin'
                     ,x_msg         => 'Beginning of Delete_Action_Set_Line pvt'
                     ,x_log_level   => 5);

Line: 816


  SELECT sets.action_set_type_code,
         sets.action_set_id,
         sets.action_set_template_flag,
         lines.status_code
    INTO l_action_set_type_code,
         l_action_set_id,
         l_action_set_template_flag,
         l_current_line_status
    FROM pa_action_sets sets,
         pa_action_set_lines lines
   WHERE lines.action_set_line_id = p_action_set_line_id
     AND sets.action_set_id = lines.action_set_id;

Line: 829


  IF l_current_line_status = 'REVERSE_PENDING' OR l_current_line_status = 'UPDATE_PENDING' THEN

          PA_UTILS.Add_Message ( p_app_short_name => 'PA'
                                ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');

Line: 838


           UPDATE pa_action_sets
              SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
            WHERE action_set_id = l_action_set_id;

Line: 843


     PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id      => p_action_set_line_id,
                                        p_line_deleted_flag       => 'Y',
                                        x_return_status           => l_return_status);

Line: 853


    	   DELETE
	     FROM PA_ACTION_SET_LINE_AUD
	    WHERE ACTION_SET_LINE_ID = P_ACTION_SET_LINE_ID;

Line: 862


           UPDATE pa_action_sets
              SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
            WHERE action_set_id = l_action_set_id;

Line: 869


            PA_ACTION_SET_LINE_COND_PKG.delete_row
                  (p_action_set_line_condition_id    => l_action_line_conditions_tbl(i).action_set_line_condition_id,
                   p_record_version_number           => p_record_version_number,
                   x_return_status                   => l_return_status);

Line: 874


          PA_ACTION_SET_LINES_PKG.delete_row
                  (p_action_set_line_id    => p_action_set_line_id,
                   p_record_version_number => p_record_version_number,
                   x_return_status         => l_return_status);

Line: 879


         PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id      => p_action_set_line_id,
                                            p_record_version_number   => p_record_version_number,
                                            p_status_code             => 'REVERSE_PENDING',
                                            p_line_deleted_flag       => 'Y',
                                            x_return_status           => l_return_status);

Line: 889


             UPDATE pa_action_sets
                SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
              WHERE action_set_id = l_action_set_id;

Line: 897


           PA_ACTION_SET_LINE_COND_PKG.delete_row
                  (p_action_set_line_condition_id    => l_action_line_conditions_tbl(i).action_set_line_condition_id,
                   p_record_version_number           => p_record_version_number,
                   x_return_status                   => l_return_status);

Line: 904


        PA_ACTION_SET_LINES_PKG.delete_row
                  (p_action_set_line_id    => p_action_set_line_id,
                   p_record_version_number => p_record_version_number,
                   x_return_status         => l_return_status);

Line: 911


         PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id      => p_action_set_line_id,
                                            p_record_version_number   => p_record_version_number,
                                            p_status_code             => 'REVERSE_PENDING',
                                            p_line_deleted_flag       => 'Y',
                                            x_return_status           => l_return_status);

Line: 930


    FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set_Line'
                             ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 936


 END Delete_Action_Set_Line;

Line: 940


                                     p_reason                        IN  VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_type
IS

   l_action_set_details_rec           pa_action_sets%ROWTYPE;

Line: 946


   l_insert_audit_lines_tbl           pa_action_set_utils.insert_audit_lines_tbl_type;

Line: 967


        l_insert_audit_lines_tbl(i).action_code             := l_active_audit_lines_tbl(i).action_code;

Line: 968


        l_insert_audit_lines_tbl(i).audit_display_attribute := l_active_audit_lines_tbl(i).audit_display_attribute;

Line: 969


        l_insert_audit_lines_tbl(i).audit_attribute         := l_active_audit_lines_tbl(i).audit_attribute;

Line: 971


           l_insert_audit_lines_tbl(i).reason_code          := 'DELETED';

Line: 972


        ELSIF p_reason='UPDATED' THEN
           l_insert_audit_lines_tbl(i).reason_code          := 'UPDATED';

Line: 975


        l_insert_audit_lines_tbl(i).reversed_action_set_line_id  := p_action_set_line_id;

Line: 981


  RETURN l_insert_audit_lines_tbl;

Line: 996


PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl      IN  pa_action_set_utils.insert_audit_lines_tbl_type,
                                  p_action_set_line_id   IN  pa_action_set_lines.action_set_line_id%TYPE,
                                  p_object_type          IN  pa_action_sets.object_type%TYPE,
                                  p_object_id            IN  pa_action_sets.object_id%TYPE,
                                  p_action_set_type_code IN  pa_action_sets.action_set_type_code%TYPE,
                                  p_status_code          IN  VARCHAR2,
                                  x_return_status       OUT  NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
IS

   l_audit_lines_tbl                  pa_action_set_utils.insert_audit_lines_tbl_type;

Line: 1017


       UPDATE pa_action_set_line_aud
          SET active_flag = 'N'
        WHERE action_set_line_id = p_action_set_line_id;

Line: 1037


       INSERT INTO pa_action_set_line_aud
                   (action_set_line_id,
                    object_type,
                    object_id,
                    action_set_type_code,
                    status_code,
                    reason_code,
                    action_code,
                    audit_display_attribute,
                    audit_attribute,
                    encoded_error_message,
                    action_date,
                    active_flag,
                    reversed_action_set_line_id,
                    creation_date,
                    created_by,
                    last_update_date,
                    last_updated_by,
                    last_update_login,
                    request_id,
                    program_application_id,
                    program_id,
                    program_update_date
                    )
          VALUES   (p_action_set_line_id,
                   p_object_type,
                   p_object_id,
                   p_action_set_type_code,
                   p_status_code,
                   l_reason_code_tbl(i),
                   l_action_code_tbl(i),
                   l_audit_display_attribute_tbl(i),
                   l_audit_attribute_tbl(i),
                   l_encoded_error_message_tbl(i),
                   SYSDATE,
                   decode(p_status_code,'REVERSED',decode(l_rev_action_set_line_id_tbl(i),NULL,'Y','N'),'Y'),
                   l_rev_action_set_line_id_tbl(i),
                   SYSDATE,
                   FND_GLOBAL.user_id,
                   SYSDATE,
                   FND_GLOBAL.user_id,
                   FND_GLOBAL.user_id,
                   FND_GLOBAL.CONC_REQUEST_ID,
                   FND_GLOBAL.PROG_APPL_ID,
                   FND_GLOBAL.CONC_PROGRAM_ID,
                   SYSDATE);

Line: 1090


    FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_insert_audit_lines'
                             ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 1100


PROCEDURE bulk_update_line_number(p_action_set_line_id_tbl      IN  pa_action_set_utils.number_tbl_type,
                                  p_line_number_tbl             IN  pa_action_set_utils.number_tbl_type,
                                  x_return_status              OUT  NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
IS

TYPE rowid_tbl IS TABLE OF ROWID
  INDEX BY BINARY_INTEGER;

Line: 1119


       SELECT rowid INTO l_rowid_tbl(i)
         FROM pa_action_set_lines
        WHERE action_set_line_id = p_action_set_line_id_tbl(i)
         FOR UPDATE NOWAIT;

Line: 1127


       UPDATE pa_action_set_lines
          SET action_set_line_number = p_line_number_tbl(i)
        WHERE rowid = l_rowid_tbl(i);

Line: 1141


    FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_number'
                             ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 1149


PROCEDURE bulk_update_condition_date(p_action_line_condition_id_tbl      IN  pa_action_set_utils.number_tbl_type,
                                     p_condition_date_tbl                IN  pa_action_set_utils.date_tbl_type,
                                     x_return_status                    OUT  NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
IS

TYPE rowid_tbl IS TABLE OF ROWID
  INDEX BY BINARY_INTEGER;

Line: 1168


       SELECT rowid INTO l_rowid_tbl(i)
         FROM pa_action_set_line_cond
        WHERE action_set_line_condition_id = p_action_line_condition_id_tbl(i)
         FOR UPDATE NOWAIT;

Line: 1176


       UPDATE pa_action_set_line_cond
          SET condition_date = p_condition_date_tbl(i)
        WHERE rowid = l_rowid_tbl(i);

Line: 1190


    FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_condition_date'
                             ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 1198


PROCEDURE bulk_update_line_status(p_action_set_line_id_tbl      IN  pa_action_set_utils.number_tbl_type,
                                  p_line_status_tbl             IN  pa_action_set_utils.varchar_tbl_type,
                                  x_return_status              OUT  NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
IS

TYPE rowid_tbl IS TABLE OF ROWID
  INDEX BY BINARY_INTEGER;

Line: 1217


       SELECT rowid INTO l_rowid_tbl(i)
         FROM pa_action_set_lines
        WHERE action_set_line_id = p_action_set_line_id_tbl(i)
         FOR UPDATE NOWAIT;

Line: 1225


       UPDATE pa_action_set_lines
          SET status_code = p_line_status_tbl(i)
        WHERE rowid = l_rowid_tbl(i);

Line: 1238


    FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_status'
                             ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 1257


 l_action_line_audit_tbl       pa_action_set_utils.insert_audit_lines_tbl_type;

Line: 1263


 l_line_deleted_flag           VARCHAR2(1);

Line: 1340


     ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_UPDATED_DEFAULT_AUDIT THEN

            l_action_line_audit_tbl := get_def_reverse_audit_lines(p_action_set_line_id    => p_action_set_line_id
                                                                  ,p_reason                  => 'UPDATED');

Line: 1349


     ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_UPDATED_CUSTOM_AUDIT THEN

            l_audit_status_code := 'REVERSED';

Line: 1360


        l_line_deleted_flag := 'N';

Line: 1362


        l_line_deleted_flag := FND_API.G_MISS_CHAR;

Line: 1370


        PA_ACTION_SET_LINES_PKG.update_row
                 (p_action_set_line_id    => p_action_set_line_id,
                  p_status_code           => l_new_line_status_code,
--                  p_line_deleted_flag     => l_line_deleted_flag,
                  x_return_status         => l_return_status);

Line: 1376


        bulk_insert_audit_lines
                         (p_audit_lines_tbl       => l_action_line_audit_tbl,
                          p_action_set_line_id    => p_action_set_line_id,
                          p_object_type           => l_action_set_details_rec.object_type,
                          p_object_id             => l_action_set_details_rec.object_id,
                          p_action_set_type_code  => p_action_set_type_code,
                          p_status_code           => l_audit_status_code,
                          x_return_status         => l_return_status);

Line: 1397


        SELECT action_set_line_number INTO l_action_set_line_number
          FROM pa_action_set_lines
         WHERE action_set_line_id = p_action_set_line_id;