The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
select distinct pricing_phase_id from qp_list_lines
where list_header_id = l_list_header_id;
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
THEN
NULL;
IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
THEN
NULL;
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,
p_param1 => p_MODIFIER_LIST_rec.active_flag,
x_return_status => x_MODIFIER_LIST_rec.return_status);
p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
BEGIN
select 'Y' into l_modifiers_exist
from qp_list_lines
where list_header_id = p_MODIFIER_LIST_rec.list_header_id
and rownum = 1;
p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => x_MODIFIER_LIST_rec.return_status);
p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
Update QP_QUALIFIERS
set active_flag = p_MODIFIER_LIST_rec.active_flag
where list_header_id = p_MODIFIER_LIST_rec.list_header_id;
update qp_pte_segments set used_in_setup='Y'
where nvl(used_in_setup,'N')='N'
and segment_id in
(select a.segment_id
from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
and a.segment_mapping_column = c .qualifier_attribute
and a.prc_context_id = b.prc_context_id
and b.prc_context_type = 'QUALIFIER'
and b.prc_context_code = c.qualifier_context);
update qp_pte_segments d set used_in_setup='Y'
where nvl(used_in_setup,'N')='N'
and exists
(select 'x'
from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
and a.segment_mapping_column = c.pricing_attribute
and a.segment_id = d.segment_id
and a.prc_context_id = b.prc_context_id
and b.prc_context_type = 'PRICING_ATTRIBUTE'
and b.prc_context_code = c.pricing_attribute_context);
update qp_pte_segments d set used_in_setup='Y'
where nvl(used_in_setup,'N')='N'
and exists
(select 'x'
from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
and a.segment_mapping_column = c.product_attribute
and a.segment_id = d.segment_id
and a.prc_context_id = b.prc_context_id
and b.prc_context_type = 'PRODUCT'
and b.prc_context_code = c.product_attribute_context);
update qp_pte_segments set used_in_setup='Y'
where nvl(used_in_setup,'N')='N'
and segment_id in
(select a.segment_id
from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
and a.segment_mapping_column = c.multival_attribute1
and a.prc_context_id = b.prc_context_id
and b.prc_context_type = c.multival_attr1_type
and b.prc_context_code = c.multival_attr1_context);
update qp_pte_segments set used_in_setup='Y'
where nvl(used_in_setup,'N')='N'
and segment_id in
(select a.segment_id
from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
and a.segment_mapping_column = c.multival_attribute2
and a.prc_context_id = b.prc_context_id
and b.prc_context_type = c.multival_attr2_type
and b.prc_context_code = c.multival_attr2_context);
update qp_pte_segments set used_in_setup='Y'
where nvl(used_in_setup,'N')='N'
and segment_id in
(select a.segment_id
from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d
where c.limit_id = d.limit_id
and d.list_header_id = p_MODIFIER_LIST_rec.list_header_id
and a.segment_mapping_column = c.limit_attribute
and a.prc_context_id = b.prc_context_id
and b.prc_context_type = c.limit_attribute_type
and b.prc_context_code = c.limit_attribute_context);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_unique_key1 => NULL,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_MODIFIER_LIST_rec.return_status);
IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_MODIFIER_LIST_rec.last_updated_by := p_old_MODIFIER_LIST_rec.last_updated_by;
IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIER_LIST_rec.last_update_date := p_old_MODIFIER_LIST_rec.last_update_date;
IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_MODIFIER_LIST_rec.last_update_login := p_old_MODIFIER_LIST_rec.last_update_login;
IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIER_LIST_rec.program_update_date := p_old_MODIFIER_LIST_rec.program_update_date;
IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_MODIFIER_LIST_rec.last_updated_by := NULL;
IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIER_LIST_rec.last_update_date := NULL;
IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_MODIFIER_LIST_rec.last_update_login := NULL;
IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIER_LIST_rec.program_update_date := NULL;
PROCEDURE Update_Row
( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
)
IS
l_active_date_first_type VARCHAR2(30);
oe_debug_pub.add('BEGIN update_row in QPXUMLHB');
if QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
p_instance_type => QP_Security.G_MODIFIER_OBJECT,
p_instance_pk1 => p_MODIFIER_LIST_rec.list_header_id) <> 'F' then
--for moac changes QP_LIST_HEADERS_B to all_b to enable updates to ML with orig_org_id
--that do not belong to the responsibility when the user has update privilges
UPDATE QP_LIST_HEADERS_ALL_B
SET ATTRIBUTE1 = p_MODIFIER_LIST_rec.attribute1
, ATTRIBUTE10 = p_MODIFIER_LIST_rec.attribute10
, ATTRIBUTE11 = p_MODIFIER_LIST_rec.attribute11
, ATTRIBUTE12 = p_MODIFIER_LIST_rec.attribute12
, ATTRIBUTE13 = p_MODIFIER_LIST_rec.attribute13
, ATTRIBUTE14 = p_MODIFIER_LIST_rec.attribute14
, ATTRIBUTE15 = p_MODIFIER_LIST_rec.attribute15
, ATTRIBUTE2 = p_MODIFIER_LIST_rec.attribute2
, ATTRIBUTE3 = p_MODIFIER_LIST_rec.attribute3
, ATTRIBUTE4 = p_MODIFIER_LIST_rec.attribute4
, ATTRIBUTE5 = p_MODIFIER_LIST_rec.attribute5
, ATTRIBUTE6 = p_MODIFIER_LIST_rec.attribute6
, ATTRIBUTE7 = p_MODIFIER_LIST_rec.attribute7
, ATTRIBUTE8 = p_MODIFIER_LIST_rec.attribute8
, ATTRIBUTE9 = p_MODIFIER_LIST_rec.attribute9
, AUTOMATIC_FLAG = p_MODIFIER_LIST_rec.automatic_flag
, COMMENTS = p_MODIFIER_LIST_rec.comments
, CONTEXT = p_MODIFIER_LIST_rec.context
, CREATED_BY = p_MODIFIER_LIST_rec.created_by
, CREATION_DATE = p_MODIFIER_LIST_rec.creation_date
, CURRENCY_CODE = p_MODIFIER_LIST_rec.currency_code
, DISCOUNT_LINES_FLAG = p_MODIFIER_LIST_rec.discount_lines_flag
, END_DATE_ACTIVE = TRUNC(p_MODIFIER_LIST_rec.end_date_active)
, FREIGHT_TERMS_CODE = p_MODIFIER_LIST_rec.freight_terms_code
, GSA_INDICATOR = p_MODIFIER_LIST_rec.gsa_indicator
, LAST_UPDATED_BY = p_MODIFIER_LIST_rec.last_updated_by
, LAST_UPDATE_DATE = p_MODIFIER_LIST_rec.last_update_date
, LAST_UPDATE_LOGIN = p_MODIFIER_LIST_rec.last_update_login
, LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
, LIST_TYPE_CODE = p_MODIFIER_LIST_rec.list_type_code
, PROGRAM_APPLICATION_ID = p_MODIFIER_LIST_rec.program_application_id
, PROGRAM_ID = p_MODIFIER_LIST_rec.program_id
, PROGRAM_UPDATE_DATE = p_MODIFIER_LIST_rec.program_update_date
, PRORATE_FLAG = p_MODIFIER_LIST_rec.prorate_flag
, REQUEST_ID = p_MODIFIER_LIST_rec.request_id
, ROUNDING_FACTOR = p_MODIFIER_LIST_rec.rounding_factor
, SHIP_METHOD_CODE = p_MODIFIER_LIST_rec.ship_method_code
, START_DATE_ACTIVE = TRUNC(p_MODIFIER_LIST_rec.start_date_active)
, TERMS_ID = p_MODIFIER_LIST_rec.terms_id
, SOURCE_SYSTEM_CODE = p_MODIFIER_LIST_rec.source_system_code
, PTE_CODE = p_MODIFIER_LIST_rec.pte_code
, ACTIVE_FLAG = p_MODIFIER_LIST_rec.active_flag
, PARENT_LIST_HEADER_ID = p_MODIFIER_LIST_rec.parent_list_header_id
, START_DATE_ACTIVE_FIRST = TRUNC(l_start_date_active_first)
, END_DATE_ACTIVE_FIRST = TRUNC(l_end_date_active_first)
, ACTIVE_DATE_FIRST_TYPE = l_active_date_first_type
, START_DATE_ACTIVE_SECOND = TRUNC(l_start_date_active_second)
, GLOBAL_FLAG = p_MODIFIER_LIST_rec.global_flag
, END_DATE_ACTIVE_SECOND = TRUNC(l_end_date_active_second)
, ACTIVE_DATE_SECOND_TYPE = l_active_date_second_type
, ASK_FOR_FLAG = p_MODIFIER_LIST_rec.ask_for_flag
, LIST_SOURCE_CODE = p_MODIFIER_LIST_rec.list_source_code
, ORIG_SYSTEM_HEADER_REF = p_MODIFIER_LIST_rec.orig_system_header_ref
, SHAREABLE_FLAG = p_MODIFIER_LIST_rec.shareable_flag
, ORIG_ORG_ID = p_MODIFIER_LIST_rec.org_id
WHERE LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
;
update QP_LIST_HEADERS_TL set
NAME = p_MODIFIER_LIST_rec.NAME
, DESCRIPTION = p_MODIFIER_LIST_rec.DESCRIPTION
, VERSION_NO = p_MODIFIER_LIST_rec.VERSION_NO
, LAST_UPDATE_DATE = p_MODIFIER_LIST_rec.LAST_UPDATE_DATE
, LAST_UPDATED_BY = p_MODIFIER_LIST_rec.LAST_UPDATED_BY
, LAST_UPDATE_LOGIN = p_MODIFIER_LIST_rec.LAST_UPDATE_LOGIN
, SOURCE_LANG = userenv('LANG')
where LIST_HEADER_ID = p_MODIFIER_LIST_rec.LIST_HEADER_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
, 'Update_Row'
);
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
)
IS
l_return_status VARCHAR2(30);
insert into QP_LIST_HEADERS_TL
( LIST_HEADER_ID
, NAME
, DESCRIPTION
, VERSION_NO
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
) select
p_MODIFIER_LIST_rec.LIST_HEADER_ID
, p_MODIFIER_LIST_rec.NAME
, p_MODIFIER_LIST_rec.DESCRIPTION
, p_MODIFIER_LIST_rec.VERSION_NO
, p_MODIFIER_LIST_rec.CREATION_DATE
, p_MODIFIER_LIST_rec.CREATED_BY
, p_MODIFIER_LIST_rec.LAST_UPDATE_DATE
, p_MODIFIER_LIST_rec.LAST_UPDATED_BY
, p_MODIFIER_LIST_rec.LAST_UPDATE_LOGIN
, L.LANGUAGE_CODE
, userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I','B')
and not exists
(select NULL from QP_LIST_HEADERS_TL T
where T.LIST_HEADER_ID = p_MODIFIER_LIST_rec.LIST_HEADER_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
, 'Insert_Row'
);
oe_debug_pub.add('BEGIN insert_row in QPXUMLHB');
INSERT INTO QP_LIST_HEADERS_B
( ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, COMMENTS
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CURRENCY_CODE
, DISCOUNT_LINES_FLAG
, END_DATE_ACTIVE
, FREIGHT_TERMS_CODE
, GSA_INDICATOR
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_HEADER_ID
, LIST_TYPE_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PRORATE_FLAG
, REQUEST_ID
, ROUNDING_FACTOR
, SHIP_METHOD_CODE
, START_DATE_ACTIVE
, TERMS_ID
, SOURCE_SYSTEM_CODE
, PTE_CODE
, ACTIVE_FLAG
, PARENT_LIST_HEADER_ID
, START_DATE_ACTIVE_FIRST
, END_DATE_ACTIVE_FIRST
, ACTIVE_DATE_FIRST_TYPE
, START_DATE_ACTIVE_SECOND
, GLOBAL_FLAG
, END_DATE_ACTIVE_SECOND
, ACTIVE_DATE_SECOND_TYPE
, ASK_FOR_FLAG
, orig_org_id
, LIST_SOURCE_CODE
, ORIG_SYSTEM_HEADER_REF
, SHAREABLE_FLAG
)
VALUES
( p_MODIFIER_LIST_rec.attribute1
, p_MODIFIER_LIST_rec.attribute10
, p_MODIFIER_LIST_rec.attribute11
, p_MODIFIER_LIST_rec.attribute12
, p_MODIFIER_LIST_rec.attribute13
, p_MODIFIER_LIST_rec.attribute14
, p_MODIFIER_LIST_rec.attribute15
, p_MODIFIER_LIST_rec.attribute2
, p_MODIFIER_LIST_rec.attribute3
, p_MODIFIER_LIST_rec.attribute4
, p_MODIFIER_LIST_rec.attribute5
, p_MODIFIER_LIST_rec.attribute6
, p_MODIFIER_LIST_rec.attribute7
, p_MODIFIER_LIST_rec.attribute8
, p_MODIFIER_LIST_rec.attribute9
, p_MODIFIER_LIST_rec.automatic_flag
, p_MODIFIER_LIST_rec.comments
, p_MODIFIER_LIST_rec.context
, p_MODIFIER_LIST_rec.created_by
, p_MODIFIER_LIST_rec.creation_date
, p_MODIFIER_LIST_rec.currency_code
, p_MODIFIER_LIST_rec.discount_lines_flag
, TRUNC(p_MODIFIER_LIST_rec.end_date_active)
, p_MODIFIER_LIST_rec.freight_terms_code
, p_MODIFIER_LIST_rec.gsa_indicator
, p_MODIFIER_LIST_rec.last_updated_by
, p_MODIFIER_LIST_rec.last_update_date
, p_MODIFIER_LIST_rec.last_update_login
, p_MODIFIER_LIST_rec.list_header_id
, p_MODIFIER_LIST_rec.list_type_code
, p_MODIFIER_LIST_rec.program_application_id
, p_MODIFIER_LIST_rec.program_id
, p_MODIFIER_LIST_rec.program_update_date
, p_MODIFIER_LIST_rec.prorate_flag
, p_MODIFIER_LIST_rec.request_id
, p_MODIFIER_LIST_rec.rounding_factor
, p_MODIFIER_LIST_rec.ship_method_code
, TRUNC(p_MODIFIER_LIST_rec.start_date_active)
, p_MODIFIER_LIST_rec.terms_id
, p_MODIFIER_LIST_rec.source_system_code
, p_MODIFIER_LIST_rec.pte_code
, p_MODIFIER_LIST_rec.active_flag
, p_MODIFIER_LIST_rec.parent_list_header_id
, TRUNC(l_start_date_active_first)
, TRUNC(l_end_date_active_first)
, l_active_date_first_type
, TRUNC(l_start_date_active_second)
, p_MODIFIER_LIST_rec.global_flag
, TRUNC(l_end_date_active_second)
, l_active_date_second_type
, p_MODIFIER_LIST_rec.ask_for_flag
--added for MOAC
, p_MODIFIER_LIST_rec.org_id
, p_MODIFIER_LIST_rec.list_source_code
, p_MODIFIER_LIST_rec.orig_system_header_ref
, p_MODIFIER_LIST_rec.shareable_flag
);
oe_debug_pub.add('insert QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
oe_debug_pub.add('insert after QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
oe_debug_pub.add('END insert_row in QPXUMLHB');
, 'Insert_Row'
);
, 'Insert_Row'
);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_list_header_id IN NUMBER
)
IS
CURSOR C1(a_list_header_id NUMBER)
IS
SELECT list_line_id
FROM qp_list_lines
WHERE list_header_id = a_list_header_id;
oe_debug_pub.add('BEGIN delete_row in QPXUMLHB');
DELETE FROM QP_PRICING_ATTRIBUTES
WHERE LIST_LINE_ID = list_lines.list_line_id;
DELETE FROM QP_RLTD_MODIFIERS
WHERE FROM_RLTD_MODIFIER_ID = list_lines.list_line_id;
DELETE FROM QP_LIST_LINES
WHERE LIST_HEADER_ID = p_list_header_id;
DELETE FROM QP_QUALIFIERS
WHERE LIST_HEADER_ID = p_list_header_id;
DELETE FROM QP_LIST_HEADERS_TL
WHERE LIST_HEADER_ID = p_list_header_id;
DELETE FROM QP_LIST_HEADERS_B
WHERE LIST_HEADER_ID = p_list_header_id ;
oe_debug_pub.add('END delete_row in QPXUMLHB');
, 'Delete_Row'
);
END Delete_Row;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, COMMENTS
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CURRENCY_CODE
, DISCOUNT_LINES_FLAG
, END_DATE_ACTIVE
, FREIGHT_TERMS_CODE
, GSA_INDICATOR
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_HEADER_ID
, LIST_TYPE_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PRORATE_FLAG
, REQUEST_ID
, ROUNDING_FACTOR
, SHIP_METHOD_CODE
, START_DATE_ACTIVE
, TERMS_ID
, SOURCE_SYSTEM_CODE
, PTE_CODE
, ACTIVE_FLAG
, PARENT_LIST_HEADER_ID
, START_DATE_ACTIVE_FIRST
, END_DATE_ACTIVE_FIRST
, ACTIVE_DATE_FIRST_TYPE
, START_DATE_ACTIVE_SECOND
, GLOBAL_FLAG
, END_DATE_ACTIVE_SECOND
, ACTIVE_DATE_SECOND_TYPE
, ASK_FOR_FLAG
, LIST_SOURCE_CODE
, ORIG_SYSTEM_HEADER_REF
, SHAREABLE_FLAG
--added for MOAC
, orig_org_id
INTO l_MODIFIER_LIST_rec.attribute1
, l_MODIFIER_LIST_rec.attribute10
, l_MODIFIER_LIST_rec.attribute11
, l_MODIFIER_LIST_rec.attribute12
, l_MODIFIER_LIST_rec.attribute13
, l_MODIFIER_LIST_rec.attribute14
, l_MODIFIER_LIST_rec.attribute15
, l_MODIFIER_LIST_rec.attribute2
, l_MODIFIER_LIST_rec.attribute3
, l_MODIFIER_LIST_rec.attribute4
, l_MODIFIER_LIST_rec.attribute5
, l_MODIFIER_LIST_rec.attribute6
, l_MODIFIER_LIST_rec.attribute7
, l_MODIFIER_LIST_rec.attribute8
, l_MODIFIER_LIST_rec.attribute9
, l_MODIFIER_LIST_rec.automatic_flag
, l_MODIFIER_LIST_rec.comments
, l_MODIFIER_LIST_rec.context
, l_MODIFIER_LIST_rec.created_by
, l_MODIFIER_LIST_rec.creation_date
, l_MODIFIER_LIST_rec.currency_code
, l_MODIFIER_LIST_rec.discount_lines_flag
, l_MODIFIER_LIST_rec.end_date_active
, l_MODIFIER_LIST_rec.freight_terms_code
, l_MODIFIER_LIST_rec.gsa_indicator
, l_MODIFIER_LIST_rec.last_updated_by
, l_MODIFIER_LIST_rec.last_update_date
, l_MODIFIER_LIST_rec.last_update_login
, l_MODIFIER_LIST_rec.list_header_id
, l_MODIFIER_LIST_rec.list_type_code
, l_MODIFIER_LIST_rec.program_application_id
, l_MODIFIER_LIST_rec.program_id
, l_MODIFIER_LIST_rec.program_update_date
, l_MODIFIER_LIST_rec.prorate_flag
, l_MODIFIER_LIST_rec.request_id
, l_MODIFIER_LIST_rec.rounding_factor
, l_MODIFIER_LIST_rec.ship_method_code
, l_MODIFIER_LIST_rec.start_date_active
, l_MODIFIER_LIST_rec.terms_id
, l_MODIFIER_LIST_rec.source_system_code
, l_MODIFIER_LIST_rec.pte_code
, l_MODIFIER_LIST_rec.active_flag
, l_MODIFIER_LIST_rec.parent_list_header_id
, l_MODIFIER_LIST_rec.start_date_active_first
, l_MODIFIER_LIST_rec.end_date_active_first
, l_MODIFIER_LIST_rec.active_date_first_type
, l_MODIFIER_LIST_rec.start_date_active_second
, l_MODIFIER_LIST_rec.global_flag
, l_MODIFIER_LIST_rec.end_date_active_second
, l_MODIFIER_LIST_rec.active_date_second_type
, l_MODIFIER_LIST_rec.ask_for_flag
, l_MODIFIER_LIST_rec.list_source_code
, l_MODIFIER_LIST_rec.orig_system_header_ref
, l_MODIFIER_LIST_rec.shareable_flag
--added for MOAC
, l_MODIFIER_LIST_rec.org_id
FROM QP_LIST_HEADERS_B
WHERE LIST_HEADER_ID = p_list_header_id
;
SELECT NAME
, DESCRIPTION
, VERSION_NO
INTO l_MODIFIER_LIST_rec.name
, l_MODIFIER_LIST_rec.description
, l_MODIFIER_LIST_rec.version_no
FROM qp_list_headers_tl
WHERE LIST_HEADER_ID = p_list_header_id
AND LANGUAGE = userenv('LANG');
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, COMMENTS
, CONTEXT
, CREATED_BY
, trunc(CREATION_DATE)
, CURRENCY_CODE
, DISCOUNT_LINES_FLAG
, trunc(END_DATE_ACTIVE)
, FREIGHT_TERMS_CODE
, GSA_INDICATOR
, LAST_UPDATED_BY
, trunc(LAST_UPDATE_DATE)
, LAST_UPDATE_LOGIN
, LIST_HEADER_ID
, LIST_TYPE_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, trunc(PROGRAM_UPDATE_DATE)
, PRORATE_FLAG
, REQUEST_ID
, ROUNDING_FACTOR
, SHIP_METHOD_CODE
, trunc(START_DATE_ACTIVE)
, TERMS_ID
, SOURCE_SYSTEM_CODE
, PTE_CODE
, ACTIVE_FLAG
, PARENT_LIST_HEADER_ID
, trunc(START_DATE_ACTIVE_FIRST)
, trunc(END_DATE_ACTIVE_FIRST)
, (ACTIVE_DATE_FIRST_TYPE)
, trunc(START_DATE_ACTIVE_SECOND)
, GLOBAL_FLAG
, trunc(END_DATE_ACTIVE_SECOND)
, (ACTIVE_DATE_SECOND_TYPE)
, ASK_FOR_FLAG
, LIST_SOURCE_CODE
, ORIG_SYSTEM_HEADER_REF
, SHAREABLE_FLAG
, ORIG_ORG_ID
INTO l_MODIFIER_LIST_rec.attribute1
, l_MODIFIER_LIST_rec.attribute10
, l_MODIFIER_LIST_rec.attribute11
, l_MODIFIER_LIST_rec.attribute12
, l_MODIFIER_LIST_rec.attribute13
, l_MODIFIER_LIST_rec.attribute14
, l_MODIFIER_LIST_rec.attribute15
, l_MODIFIER_LIST_rec.attribute2
, l_MODIFIER_LIST_rec.attribute3
, l_MODIFIER_LIST_rec.attribute4
, l_MODIFIER_LIST_rec.attribute5
, l_MODIFIER_LIST_rec.attribute6
, l_MODIFIER_LIST_rec.attribute7
, l_MODIFIER_LIST_rec.attribute8
, l_MODIFIER_LIST_rec.attribute9
, l_MODIFIER_LIST_rec.automatic_flag
, l_MODIFIER_LIST_rec.comments
, l_MODIFIER_LIST_rec.context
, l_MODIFIER_LIST_rec.created_by
, l_MODIFIER_LIST_rec.creation_date
, l_MODIFIER_LIST_rec.currency_code
, l_MODIFIER_LIST_rec.discount_lines_flag
, l_MODIFIER_LIST_rec.end_date_active
, l_MODIFIER_LIST_rec.freight_terms_code
, l_MODIFIER_LIST_rec.gsa_indicator
, l_MODIFIER_LIST_rec.last_updated_by
, l_MODIFIER_LIST_rec.last_update_date
, l_MODIFIER_LIST_rec.last_update_login
, l_MODIFIER_LIST_rec.list_header_id
, l_MODIFIER_LIST_rec.list_type_code
, l_MODIFIER_LIST_rec.program_application_id
, l_MODIFIER_LIST_rec.program_id
, l_MODIFIER_LIST_rec.program_update_date
, l_MODIFIER_LIST_rec.prorate_flag
, l_MODIFIER_LIST_rec.request_id
, l_MODIFIER_LIST_rec.rounding_factor
, l_MODIFIER_LIST_rec.ship_method_code
, l_MODIFIER_LIST_rec.start_date_active
, l_MODIFIER_LIST_rec.terms_id
, l_MODIFIER_LIST_rec.source_system_code
, l_MODIFIER_LIST_rec.pte_code
, l_MODIFIER_LIST_rec.active_flag
, l_MODIFIER_LIST_rec.parent_list_header_id
, l_MODIFIER_LIST_rec.start_date_active_first
, l_MODIFIER_LIST_rec.end_date_active_first
, l_MODIFIER_LIST_rec.active_date_first_type
, l_MODIFIER_LIST_rec.start_date_active_second
, l_MODIFIER_LIST_rec.global_flag
, l_MODIFIER_LIST_rec.end_date_active_second
, l_MODIFIER_LIST_rec.active_date_second_type
, l_MODIFIER_LIST_rec.ask_for_flag
, l_MODIFIER_LIST_rec.list_source_code
, l_MODIFIER_LIST_rec.orig_system_header_ref
, l_MODIFIER_LIST_rec.shareable_flag
--added for MOAC
, l_MODIFIER_LIST_rec.org_id
--for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to ML with orig_org_id
--that do not belong to the responsibility when the user has update privilges
FROM QP_LIST_HEADERS_ALL_B
WHERE LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
FOR UPDATE NOWAIT;
SELECT NAME
, DESCRIPTION
, VERSION_NO
INTO l_MODIFIER_LIST_rec.name
, l_MODIFIER_LIST_rec.description
, l_MODIFIER_LIST_rec.version_no
FROM qp_list_headers_tl
WHERE LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
AND LANGUAGE = userenv('LANG');
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
l_MODIFIER_LIST_rec.last_updated_by)
-- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
-- l_MODIFIER_LIST_rec.last_update_date)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
l_MODIFIER_LIST_rec.last_update_login)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
l_MODIFIER_LIST_rec.list_header_id)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
l_MODIFIER_LIST_rec.list_type_code)
--AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
-- l_MODIFIER_LIST_rec.program_application_id)
--AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
-- l_MODIFIER_LIST_rec.program_id)
--AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
-- l_MODIFIER_LIST_rec.program_update_date)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
l_MODIFIER_LIST_rec.prorate_flag)
--AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
-- l_MODIFIER_LIST_rec.request_id)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
l_MODIFIER_LIST_rec.rounding_factor)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
l_MODIFIER_LIST_rec.ship_method_code)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
l_MODIFIER_LIST_rec.start_date_active)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
l_MODIFIER_LIST_rec.terms_id)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
l_MODIFIER_LIST_rec.source_system_code)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
l_MODIFIER_LIST_rec.pte_code)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
l_MODIFIER_LIST_rec.active_flag)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
l_MODIFIER_LIST_rec.parent_list_header_id)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
l_MODIFIER_LIST_rec.start_date_active_first)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
l_MODIFIER_LIST_rec.end_date_active_first)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
l_MODIFIER_LIST_rec.active_date_first_type)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
l_MODIFIER_LIST_rec.start_date_active_second)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
l_MODIFIER_LIST_rec.global_flag)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
l_MODIFIER_LIST_rec.end_date_active_second)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
l_MODIFIER_LIST_rec.active_date_second_type)
AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
l_MODIFIER_LIST_rec.ask_for_flag)
AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
l_MODIFIER_LIST_rec.list_source_code)
AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
l_MODIFIER_LIST_rec.orig_system_header_ref)
AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,
l_MODIFIER_LIST_rec.shareable_flag)
THEN
-- Row has not changed. Set out parameter.
x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
oe_debug_pub.add('last_updated_by :'||l_MODIFIER_LIST_rec.last_updated_by||':'||p_MODIFIER_LIST_rec.last_updated_by||':');
oe_debug_pub.add('last_update_date :'||l_MODIFIER_LIST_rec.last_update_date||':'||p_MODIFIER_LIST_rec.last_update_date||':');
oe_debug_pub.add('last_update_login :'||l_MODIFIER_LIST_rec.last_update_login||':'||p_MODIFIER_LIST_rec.last_update_login||':');
oe_debug_pub.add('program_update_date :'||l_MODIFIER_LIST_rec.program_update_date||':'||p_MODIFIER_LIST_rec.program_update_date||':');
FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
select qualifier_context, qualifier_attribute
from qp_qualifiers
where list_header_id = p_list_header_id
and ((qualifier_grouping_no = p_qualifier_grouping_no) OR (qualifier_grouping_no = -1))
and list_line_id = p_list_line_id;