[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.qualifier_id
INTO p_to_id
FROM qp_qualifiers a
WHERE a.qualifier_attr_value = to_char(p_to_fk_id)
AND trunc(l_temp_date) between nvl(trunc(start_date_active), trunc(l_temp_date)) and
nvl(trunc(end_date_active), trunc(l_temp_date))
AND (a.qualifier_context,
a.qualifier_attribute,
nvl(a.list_header_id, -1),
nvl(a.list_line_id, -1),
nvl(qualifier_rule_id, -1),
a.qualifier_grouping_no) IN
(SELECT b.qualifier_context, b.qualifier_attribute,
nvl(b.list_header_id, -1),
nvl(b.list_line_id, -1),
nvl(qualifier_rule_id, -1),
b.qualifier_grouping_no
FROM qp_qualifiers b
WHERE b.qualifier_id = p_from_id
AND b.qualifier_id <> a.qualifier_id)
AND rownum = 1;
UPDATE qp_qualifiers
SET qualifier_attr_value = to_char(p_to_fk_id),
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
WHERE qualifier_id = p_from_id;
UPDATE qp_qualifiers
SET qualifier_attr_value = to_char(p_to_fk_id),
end_date_active = sysdate,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
WHERE qualifier_id = p_from_id;