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

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

Line: 84


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_ADV_RULE_OBJECTS_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number BETWEEN p_project_number_from  AND p_project_number_to
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 102


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_ADV_RULE_OBJECTS_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number >= p_project_number_from
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 120


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_ADV_RULE_OBJECTS_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number <= p_project_number_to
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 138


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_ADV_RULE_OBJECTS_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE
                 conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 163


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_PROJ_STATUS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number BETWEEN p_project_number_from  AND p_project_number_to
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 181


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_PROJ_STATUS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number >= p_project_number_from
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 199


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_PROJ_STATUS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number <= p_project_number_to
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 217


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_PROJ_STATUS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE
                 conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 242


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number BETWEEN p_project_number_from  AND p_project_number_to
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 260


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number >= p_project_number_from
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 278


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE project_number <= p_project_number_to
             AND conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 296


          SELECT alines.action_set_line_id,
                 conc_view.object_name,
                 conc_view.project_number
            BULK COLLECT INTO x_action_set_line_id_tbl,
                   x_object_name_tbl,
                   x_project_number_tbl
            FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
                 pa_action_sets asets,
                 pa_action_set_lines alines
           WHERE
                 conc_view.object_type = asets.object_type
             AND conc_view.object_id = asets.object_id
             AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)
             AND asets.status_code IN ('STARTED', 'RESUMED')
             AND asets.action_set_id = alines.action_set_id
             AND alines.status_code IN ('PENDING', 'ACTIVE', 'REVERSE_PENDING', 'UPDATE_PENDING')
          ORDER BY alines.action_set_line_number;

Line: 321


                                     x_action_line_audit_tbl       OUT   NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type, -- For 1159 mandate changes bug#2674619
                                     x_action_line_result_code     OUT   NOCOPY VARCHAR2)  --File.Sql.39 bug 4440895
  IS
  BEGIN
  NULL;