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

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

Line: 147


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_object_type            IN    pa_action_sets.object_type%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_object_id              IN    pa_action_sets.object_id%TYPE               := FND_API.G_MISS_NUM
 ,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
 ,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
 ,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_return_status          VARCHAR2(1);

Line: 194


  PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Update_Action_Set');

Line: 209


    SAVEPOINT UPDATE_ACTION_SETS_PUB;

Line: 214


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

Line: 230


     SELECT record_version_number INTO l_record_version_number
       FROM pa_action_sets
      WHERE action_set_id = l_action_set_id
        AND record_version_number = p_record_version_number;

Line: 244


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set.begin'
                     ,x_msg         => 'calling Update_Action_Set pvt'
                     ,x_log_level   => 5);

Line: 249


  PA_ACTION_SETS_PVT.update_action_set
          (p_action_set_id          =>   l_action_set_id
          ,p_action_set_name        =>   p_action_set_name
          ,p_action_set_type_code   =>   p_action_set_type_code
          ,p_start_date_active      =>   p_start_date_active
          ,p_end_date_active        =>   p_end_date_active
          ,p_status_code            =>   p_status_code
          ,p_description            =>   p_description
          ,p_record_version_number  =>   p_record_version_number
          ,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: 302


          ROLLBACK TO UPDATE_ACTION_SETS_PUB;

Line: 306


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

Line: 312


 END Update_Action_Set;

Line: 315


PROCEDURE delete_action_set
 (p_action_set_id          IN    pa_action_sets.action_set_id%TYPE           := NULL
 ,p_action_set_type_code   IN    pa_action_sets.action_set_type_code%TYPE    := NULL
 ,p_object_type            IN    pa_action_sets.object_type%TYPE             := NULL
 ,p_object_id              IN    pa_action_sets.object_id%TYPE               := NULL
 ,p_record_version_number  IN    pa_action_sets.record_version_number%TYPE
 ,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
 ,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_return_status          VARCHAR2(1);

Line: 345


  PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Delete_Action_Set');

Line: 363


    SAVEPOINT Delete_ACTION_SETS_PUB;

Line: 368


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PUB.Delete_Action_Set.begin'
                     ,x_msg         => 'Beginning of Delete_Action_Set pub'
                     ,x_log_level   => 5);

Line: 384


     SELECT record_version_number INTO l_record_version_number
       FROM pa_action_sets
      WHERE action_set_id = l_action_set_id
        AND record_version_number = p_record_version_number;

Line: 398


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PUB.Delete_Action_Set.begin'
                     ,x_msg         => 'calling Delete_Action_Set pvt'
                     ,x_log_level   => 5);

Line: 403


  PA_ACTION_SETS_PVT.delete_action_set
          (p_action_set_id          =>   l_action_set_id
          ,p_record_version_number  =>   p_record_version_number
          ,x_return_status          =>   l_return_status);

Line: 441


          ROLLBACK TO Delete_ACTION_SETS_PUB;

Line: 445


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

Line: 451


 END Delete_Action_Set;

Line: 578


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_use_def_description_flag IN    VARCHAR2                                     := 'Y'
 ,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
 ,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
 ,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_return_status           VARCHAR2(1);

Line: 615


  PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Update_Action_Set_Line');

Line: 630


    SAVEPOINT UPDATE_ACTION_SET_LINE_PUB;

Line: 635


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

Line: 639


    PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set_Line.begin'
                     ,x_msg         => 'calling Update_Action_Set_Line pvt'
                     ,x_log_level   => 5);

Line: 644


  PA_ACTION_SETS_PVT.update_action_set_line
          (p_action_set_line_id       =>   p_action_set_line_id
          ,p_record_version_number    =>   p_record_version_number
          ,p_description              =>   p_description
          ,p_action_set_line_number   =>   p_action_set_line_number
          ,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
          ,p_condition_tbl            =>   p_condition_tbl
          ,x_return_status            =>   l_return_status);

Line: 688


          ROLLBACK TO UPDATE_ACTION_SET_LINE_PUB;

Line: 692


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

Line: 698


 END Update_Action_Set_Line;

Line: 701


PROCEDURE delete_action_set_line
 (p_action_set_line_id     IN    pa_action_sets.action_set_id%TYPE                := NULL
 ,p_record_version_number  IN    pa_action_set_lines.record_version_number%TYPE   := NULL
 ,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
 ,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_return_status          VARCHAR2(1);

Line: 724


  PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Delete_Action_Set_Line');

Line: 739


    SAVEPOINT Delete_ACTION_SET_LINE_PUB;

Line: 744


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

Line: 751


     SELECT record_version_number INTO l_record_version_number
       FROM pa_action_set_lines
      WHERE action_set_line_id = p_action_set_line_id
        AND record_version_number = p_record_version_number;

Line: 763


  PA_ACTION_SETS_PVT.delete_action_set_line
          (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: 793


          ROLLBACK TO Delete_ACTION_SET_LINE_PUB;

Line: 797


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

Line: 803


 END Delete_Action_Set_Line;

Line: 884


  SELECT
         action_set_name,
         action_set_type_code,
         description,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15
    INTO
         l_action_set_name,
         l_action_set_type_code,
         l_description,
         l_attribute_category,
         l_attribute1,
         l_attribute2,
         l_attribute3,
         l_attribute4,
         l_attribute5,
         l_attribute6,
         l_attribute7,
         l_attribute8,
         l_attribute9,
         l_attribute10,
         l_attribute11,
         l_attribute12,
         l_attribute13,
         l_attribute14,
         l_attribute15
    FROM pa_action_sets
   WHERE action_set_id = p_action_set_id;

Line: 1118


   delete_action_set(
           p_action_set_id          =>   l_current_action_set_id
          ,p_record_version_number  =>   p_record_version_number
          ,p_init_msg_list          =>   FND_API.G_FALSE
          ,x_return_status          =>   l_return_status
          ,x_msg_count              =>   l_msg_count
          ,x_msg_data               =>   l_msg_data);

Line: 1217


SELECT action_set_line_id
  FROM pa_action_set_lines l,
       pa_action_sets s
 WHERE s.action_set_id = p_action_set_id
   AND s.action_set_id = l.action_set_id
   AND s.status_code IN ('STARTED','RESUMED')
   AND l.status_code IN ('PENDING','ACTIVE','REVERSE_PENDING','UPDATE_PENDING')
ORDER BY l.action_set_line_number;

Line: 1266


     SELECT action_set_type_code INTO l_action_set_type_code
       FROM pa_action_sets
      WHERE action_set_id = p_action_set_id;

Line: 1364


             DELETE from pa_action_set_report_temp;

Line: 1365


             INSERT INTO pa_action_set_report_temp(action_set_line_id,
                                                   project_number,
                                                   object_name)
                                            select action_set_line_id, 'OBJ NAME', 'PROJ NAME'
                                               from pa_action_set_lines;

Line: 1382


  DELETE FROM pa_action_set_report_temp;

Line: 1385


     SELECT action_set_type_code BULK COLLECT INTO l_action_set_type_code_tbl
       FROM pa_action_set_types;

Line: 1414


             INSERT INTO pa_action_set_report_temp(action_set_line_id,
                                                   project_number,
                                                   object_name)
                                            VALUES(l_action_set_line_id_tbl(k),
                                                   l_project_number_tbl(k),
                                                   l_object_name_tbl(k));

Line: 1562


    SELECT action_set_template_flag
      INTO l_action_set_template_flag
      FROM pa_action_sets
      WHERE action_set_id = p_action_set_id;

Line: 1568


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

Line: 1587


PROCEDURE update_line_single_cond
 (p_action_set_line_id       IN    pa_action_sets.action_set_id%TYPE
 ,p_record_version_number    IN    NUMBER                                       := NULL
 ,p_action_description       IN    pa_action_set_lines.description%TYPE         := FND_API.G_MISS_CHAR
 ,p_action_code              IN    pa_action_set_lines.action_code%TYPE
 ,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_description    IN    pa_action_set_line_cond.description%TYPE     := FND_API.G_MISS_CHAR
 ,p_condition_code           IN    pa_action_set_line_cond.condition_code%TYPE
 ,p_condition_attribute1     IN    pa_action_set_line_cond.condition_attribute1%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute2     IN    pa_action_set_line_cond.condition_attribute2%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute3     IN    pa_action_set_line_cond.condition_attribute3%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute4     IN    pa_action_set_line_cond.condition_attribute4%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute5     IN    pa_action_set_line_cond.condition_attribute5%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute6     IN    pa_action_set_line_cond.condition_attribute6%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute7     IN    pa_action_set_line_cond.condition_attribute7%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute8     IN    pa_action_set_line_cond.condition_attribute8%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute9     IN    pa_action_set_line_cond.condition_attribute9%TYPE   := FND_API.G_MISS_CHAR
 ,p_condition_attribute10    IN    pa_action_set_line_cond.condition_attribute10%TYPE  := FND_API.G_MISS_CHAR
 ,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
 ,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_condition_tbl    pa_action_set_utils.action_line_cond_tbl_type;

Line: 1631


  PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.update_line_single_cond');

Line: 1649


  SELECT action_set_line_condition_id INTO l_condition_tbl(1).action_set_line_condition_id
    FROM pa_action_set_line_cond
   WHERE action_set_line_id = p_action_set_line_id;

Line: 1653


  update_action_set_line
          (p_action_set_line_id       =>   p_action_set_line_id
          ,p_record_version_number    =>   p_record_version_number
          ,p_description              =>   p_action_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
          ,p_condition_tbl            =>   l_condition_tbl
          ,p_init_msg_list            =>   p_init_msg_list
          ,p_commit                   =>   p_commit
          ,p_validate_only            =>   p_validate_only
          ,x_return_status            =>   x_return_status
          ,x_msg_count                =>   x_msg_count
          ,x_msg_data                 =>   x_msg_data);

Line: 1681


    SELECT s.action_set_template_flag, s.action_set_id
      INTO l_action_set_template_flag, l_action_set_id
      FROM pa_action_sets s, pa_action_set_lines l
      WHERE l.action_set_line_id = p_action_set_line_id
      AND s.action_set_id = l.action_set_id;

Line: 1688


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

Line: 1698


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.update_line_single_cond'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 1725


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