The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;