The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT action_set_id INTO l_action_set_id
FROM pa_action_sets
WHERE object_type = p_object_type
AND object_id = p_object_id
AND action_set_type_code = p_action_set_type_code
AND status_code IN ('NOT_STARTED', 'STARTED', 'PAUSED', 'RESUMED', 'CLOSED');
SELECT action_set_line_id,
action_set_id,
action_set_line_number,
status_code,
description,
record_version_number,
action_code,
action_attribute1,
action_attribute2,
action_attribute3,
action_attribute4,
action_attribute5,
action_attribute6,
action_attribute7,
action_attribute8,
action_attribute9,
action_attribute10
BULK COLLECT INTO
l_action_set_line_id_tbl,
l_action_set_id_tbl,
l_action_set_line_number_tbl,
l_status_code_tbl,
l_description_tbl,
l_record_version_number_tbl,
l_action_code_tbl,
l_action_attribute1_tbl,
l_action_attribute2_tbl,
l_action_attribute3_tbl,
l_action_attribute4_tbl,
l_action_attribute5_tbl,
l_action_attribute6_tbl,
l_action_attribute7_tbl,
l_action_attribute8_tbl,
l_action_attribute9_tbl,
l_action_attribute10_tbl
FROM pa_action_set_lines
WHERE action_set_id = p_action_set_id;
SELECT action_set_line_id,
action_set_id,
action_set_line_number,
status_code,
description,
record_version_number,
action_code,
action_attribute1,
action_attribute2,
action_attribute3,
action_attribute4,
action_attribute5,
action_attribute6,
action_attribute7,
action_attribute8,
action_attribute9,
action_attribute10
INTO
l_action_set_lines_rec.action_set_line_id,
l_action_set_lines_rec.action_set_id,
l_action_set_lines_rec.action_set_line_number,
l_action_set_lines_rec.status_code,
l_action_set_lines_rec.description,
l_action_set_lines_rec.record_version_number,
l_action_set_lines_rec.action_code,
l_action_set_lines_rec.action_attribute1,
l_action_set_lines_rec.action_attribute2,
l_action_set_lines_rec.action_attribute3,
l_action_set_lines_rec.action_attribute4,
l_action_set_lines_rec.action_attribute5,
l_action_set_lines_rec.action_attribute6,
l_action_set_lines_rec.action_attribute7,
l_action_set_lines_rec.action_attribute8,
l_action_set_lines_rec.action_attribute9,
l_action_set_lines_rec.action_attribute10
FROM pa_action_set_lines
WHERE action_set_line_id = p_action_set_line_id;
SELECT sets.action_set_id,
sets.action_set_name,
sets.action_set_type_code,
sets.object_type,
sets.object_id,
sets.start_date_active,
sets.end_date_active,
sets.description,
sets.status_code,
sets.actual_start_date,
sets.action_set_template_flag,
sets.source_action_set_id,
sets.attribute_category,
sets.attribute1,
sets.attribute2,
sets.attribute3,
sets.attribute4,
sets.attribute5,
sets.attribute6,
sets.attribute7,
sets.attribute8,
sets.attribute9,
sets.attribute10,
sets.attribute11,
sets.attribute12,
sets.attribute13,
sets.attribute14,
sets.attribute15
INTO
l_action_sets_rec.action_set_id,
l_action_sets_rec.action_set_name,
l_action_sets_rec.action_set_type_code,
l_action_sets_rec.object_type,
l_action_sets_rec.object_id,
l_action_sets_rec.start_date_active,
l_action_sets_rec.end_date_active,
l_action_sets_rec.description,
l_action_sets_rec.status_code,
l_action_sets_rec.actual_start_date,
l_action_sets_rec.action_set_template_flag,
l_action_sets_rec.source_action_set_id,
l_action_sets_rec.attribute_category,
l_action_sets_rec.attribute1,
l_action_sets_rec.attribute2,
l_action_sets_rec.attribute3,
l_action_sets_rec.attribute4,
l_action_sets_rec.attribute5,
l_action_sets_rec.attribute6,
l_action_sets_rec.attribute7,
l_action_sets_rec.attribute8,
l_action_sets_rec.attribute9,
l_action_sets_rec.attribute10,
l_action_sets_rec.attribute11,
l_action_sets_rec.attribute12,
l_action_sets_rec.attribute13,
l_action_sets_rec.attribute14,
l_action_sets_rec.attribute15
FROM pa_action_sets sets,
pa_action_set_lines lines
WHERE lines.action_set_line_id = p_action_set_line_id
AND lines.action_set_id = sets.action_set_id;
SELECT action_set_line_id,
action_set_line_condition_id,
description,
condition_date,
condition_code,
condition_attribute1,
condition_attribute2,
condition_attribute3,
condition_attribute4,
condition_attribute5,
condition_attribute6,
condition_attribute7,
condition_attribute8,
condition_attribute9,
condition_attribute10
BULK COLLECT INTO
l_action_set_line_id_tbl,
l_action_line_cond_id_tbl,
l_description_tbl,
l_condition_date_tbl,
l_condition_code_tbl,
l_condition_attribute1_tbl,
l_condition_attribute2_tbl,
l_condition_attribute3_tbl,
l_condition_attribute4_tbl,
l_condition_attribute5_tbl,
l_condition_attribute6_tbl,
l_condition_attribute7_tbl,
l_condition_attribute8_tbl,
l_condition_attribute9_tbl,
l_condition_attribute10_tbl
FROM pa_action_set_line_cond
WHERE action_set_line_id = p_action_set_line_id;
SELECT action_set_line_id,
object_type,
object_id,
action_set_type_code,
status_code,
reason_code,
action_code,
audit_display_attribute,
audit_attribute,
action_date,
active_flag,
reversed_action_set_line_id
BULK COLLECT INTO
l_action_set_line_id_tbl,
l_object_type_tbl,
l_object_id_tbl,
l_action_set_type_code_tbl,
l_status_code_tbl,
l_reason_code_tbl,
l_action_code_tbl,
l_audit_display_attribute_tbl,
l_audit_attribute_tbl,
l_action_date_tbl,
l_active_flag_tbl,
l_reversed_action_set_line_tbl
FROM pa_action_set_line_aud
WHERE action_set_line_id = p_action_set_line_id
AND active_flag = 'Y';
SELECT 'X'
FROM pa_action_sets
WHERE action_set_name = p_action_set_name
AND action_set_type_code = p_action_set_type_code
AND action_set_template_flag = 'Y'
AND ((action_set_id <> p_action_set_id AND p_action_set_id IS NOT NULL)
OR p_action_set_id IS NULL);
SELECT 'X'
FROM pa_action_sets
WHERE source_action_set_id = p_action_set_id;
SELECT 'X'
FROM pa_action_set_lines
WHERE action_set_id = p_action_set_id;
SELECT 'X'
FROM pa_action_set_line_aud
WHERE action_set_line_id = p_action_set_line_id;
SELECT max(trunc(action_date)) INTO l_action_date
FROM pa_action_set_line_aud
WHERE action_set_line_id = p_action_set_line_id;
SELECT action_set_id
INTO x_action_set_id
FROM pa_action_sets
WHERE action_set_id = p_action_set_id
-- 2767129: Modified select stmt to use action_set_template_flag for
-- performance improvement. This is OK because the action set LOV
-- only displays template action sets.
AND action_set_template_flag = 'Y'
-- end of 2767129
AND action_set_name = p_action_set_name
AND action_set_type_code = p_action_set_type_code
AND p_date between start_date_active AND nvl(end_date_active, p_date);
SELECT action_set_id
INTO x_action_set_id
FROM pa_action_sets
WHERE action_set_name = p_action_set_name
-- 2767129: Modified select stmt to use action_set_template_flag for
-- performance improvement. This is OK because the action set LOV
-- only displays template action sets.
AND action_set_template_flag = 'Y'
-- end of 2767129
AND action_set_type_code = p_action_set_type_code
AND p_date between start_date_active AND nvl(end_date_active, p_date);