The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATED_BY;
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_DATE;
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_MODIFIERS_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_MODIFIERS_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_MODIFIERS_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_MODIFIERS_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_MODIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
x_return_status => l_return_status);
IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIERS_rec.list_header_id,
p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
p_request_unique_key2 => 'UD',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
x_return_status => l_return_status);
p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
x_return_status => l_return_status);
p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,
p_param1 => p_MODIFIERS_rec.pricing_phase_id,
p_param2 => p_old_MODIFIERS_rec.pricing_phase_id,
x_return_status => l_return_status);
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)
THEN
NULL;
p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
x_return_status => l_return_status);
p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
x_return_status => l_return_status);
, p_request_type =>QP_GLOBALS.G_UPDATE_HVOP
, x_return_status => l_return_status
);
QP_delayed_requests_pvt.Delete_Request
( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
, p_entity_id => p_MODIFIERS_rec.list_line_id
, p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
, x_return_status => l_return_status
);
IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)
THEN
NULL;
IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIERS_rec.list_header_id,
p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
p_request_unique_key2 => 'U',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
x_return_status => l_return_status);
IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
qp_delayed_requests_pvt.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_MODIFIERS_rec.list_header_id,
p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
p_request_unique_key2 => 'U',
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
x_return_status => l_return_status);
IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_MODIFIERS_rec.last_updated_by := p_old_MODIFIERS_rec.last_updated_by;
IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIERS_rec.last_update_date := p_old_MODIFIERS_rec.last_update_date;
IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_MODIFIERS_rec.last_update_login := p_old_MODIFIERS_rec.last_update_login;
IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIERS_rec.program_update_date := p_old_MODIFIERS_rec.program_update_date;
IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_MODIFIERS_rec.last_updated_by := NULL;
IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIERS_rec.last_update_date := NULL;
IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_MODIFIERS_rec.last_update_login := NULL;
IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_MODIFIERS_rec.program_update_date := NULL;
PROCEDURE UPDATE_CHILD_LINES(p_MODIFIERS_rec IN
QP_MODIFIERS_PUB.Modifiers_rec_type) IS
l_status NUMBER;
SELECT *
FROM QP_LIST_LINES qll
WHERE qll.list_line_id IN
(select to_rltd_modifier_id from
qp_rltd_modifiers qrm where
from_rltd_modifier_id = l_list_line_id);
oe_debug_pub.add('begin update child lines');
oe_debug_pub.add('update child lines'||to_char(p_MODIFIERS_rec.list_line_id));
update qp_list_lines set
-- list_line_no = p_MODIFIERS_rec.list_line_no
modifier_level_code = p_MODIFIERS_rec.modifier_level_code
,automatic_flag = p_MODIFIERS_rec.automatic_flag
,override_flag = p_MODIFIERS_rec.override_flag
,Print_on_invoice_flag = p_MODIFIERS_rec.Print_on_invoice_flag
,price_break_type_code = p_MODIFIERS_rec.price_break_type_code
,Proration_type_code = p_MODIFIERS_rec.Proration_type_code
,Incompatibility_Grp_code= p_MODIFIERS_rec.Incompatibility_Grp_code
,Pricing_phase_id = p_MODIFIERS_rec.Pricing_phase_id
,Pricing_group_sequence = p_MODIFIERS_rec.Pricing_group_sequence
,accrual_flag = p_MODIFIERS_rec.accrual_flag
,estim_accrual_rate = p_MODIFIERS_rec.estim_accrual_rate
,rebate_transaction_type_code = p_MODIFIERS_rec.rebate_trxn_type_code
,expiration_date = p_MODIFIERS_rec.expiration_date
,expiration_period_start_date = p_MODIFIERS_rec.expiration_period_start_date
,expiration_period_uom = p_MODIFIERS_rec.expiration_period_uom
,number_expiration_periods = p_MODIFIERS_rec.number_expiration_periods
where list_line_id = l_MODIFIERS_rec.list_line_id;
oe_debug_pub.add('update child lines'||to_char(p_MODIFIERS_rec.list_line_id));
update qp_list_lines set
-- list_line_no = p_MODIFIERS_rec.list_line_no
modifier_level_code = p_MODIFIERS_rec.modifier_level_code
,automatic_flag = p_MODIFIERS_rec.automatic_flag
,override_flag = p_MODIFIERS_rec.override_flag
,Print_on_invoice_flag = p_MODIFIERS_rec.Print_on_invoice_flag
-- ,price_break_type_code = p_MODIFIERS_rec.price_break_type_code --2749159
,Proration_type_code = p_MODIFIERS_rec.Proration_type_code
,Incompatibility_Grp_code= p_MODIFIERS_rec.Incompatibility_Grp_code
,Pricing_phase_id = p_MODIFIERS_rec.Pricing_phase_id
,Pricing_group_sequence = p_MODIFIERS_rec.Pricing_group_sequence
,accrual_flag = p_MODIFIERS_rec.accrual_flag
,estim_accrual_rate = p_MODIFIERS_rec.estim_accrual_rate
,rebate_transaction_type_code = p_MODIFIERS_rec.rebate_trxn_type_code
,expiration_date = p_MODIFIERS_rec.expiration_date
,expiration_period_start_date = p_MODIFIERS_rec.expiration_period_start_date
,expiration_period_uom = p_MODIFIERS_rec.expiration_period_uom
,number_expiration_periods = p_MODIFIERS_rec.number_expiration_periods
where list_line_id = l_MODIFIERS_rec.list_line_id;
oe_debug_pub.add('end update child lines');
, 'Update_Child_Lines'
);
oe_debug_pub.add('exp update child lines');
END UPDATE_CHILD_LINES;
PROCEDURE Update_Row
( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
)
IS
v_accum_context VARCHAR2(30) := NULL;
oe_debug_pub.add('BEGIN Update_Row in QPXUMLLB');
SELECT nvl(user_sourcing_method,seeded_sourcing_method)
INTO l_sourcing_method
FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
WHERE c.prc_context_code = 'VOLUME'
AND c.prc_context_type = 'PRICING_ATTRIBUTE'
AND c.prc_context_id = s.prc_context_id
AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute
AND s.segment_id = ps.segment_id
AND ps.pte_code = l_pte_code;
SELECT ACTIVE_FLAG
INTO l_active_flag
FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
WHERE b.list_line_id=p_MODIFIERS_rec.list_line_id
AND b.LIST_HEADER_ID = a.list_header_id;
UPDATE QP_LIST_LINES
SET ARITHMETIC_OPERATOR = p_MODIFIERS_rec.arithmetic_operator
, ATTRIBUTE1 = p_MODIFIERS_rec.attribute1
, ATTRIBUTE10 = p_MODIFIERS_rec.attribute10
, ATTRIBUTE11 = p_MODIFIERS_rec.attribute11
, ATTRIBUTE12 = p_MODIFIERS_rec.attribute12
, ATTRIBUTE13 = p_MODIFIERS_rec.attribute13
, ATTRIBUTE14 = p_MODIFIERS_rec.attribute14
, ATTRIBUTE15 = p_MODIFIERS_rec.attribute15
, ATTRIBUTE2 = p_MODIFIERS_rec.attribute2
, ATTRIBUTE3 = p_MODIFIERS_rec.attribute3
, ATTRIBUTE4 = p_MODIFIERS_rec.attribute4
, ATTRIBUTE5 = p_MODIFIERS_rec.attribute5
, ATTRIBUTE6 = p_MODIFIERS_rec.attribute6
, ATTRIBUTE7 = p_MODIFIERS_rec.attribute7
, ATTRIBUTE8 = p_MODIFIERS_rec.attribute8
, ATTRIBUTE9 = p_MODIFIERS_rec.attribute9
, AUTOMATIC_FLAG = p_MODIFIERS_rec.automatic_flag
-- , BASE_QTY = p_MODIFIERS_rec.base_qty
, PRICING_PHASE_ID = p_MODIFIERS_rec.pricing_phase_id
-- , BASE_UOM_CODE = p_MODIFIERS_rec.base_uom_code
, COMMENTS = p_MODIFIERS_rec.comments
, CONTEXT = p_MODIFIERS_rec.context
, CREATED_BY = p_MODIFIERS_rec.created_by
, CREATION_DATE = p_MODIFIERS_rec.creation_date
, EFFECTIVE_PERIOD_UOM = p_MODIFIERS_rec.effective_period_uom
, END_DATE_ACTIVE = p_MODIFIERS_rec.end_date_active
, ESTIM_ACCRUAL_RATE = p_MODIFIERS_rec.estim_accrual_rate
, GENERATE_USING_FORMULA_ID = p_MODIFIERS_rec.generate_using_formula_id
, INVENTORY_ITEM_ID = p_MODIFIERS_rec.inventory_item_id
, LAST_UPDATED_BY = p_MODIFIERS_rec.last_updated_by
, LAST_UPDATE_DATE = p_MODIFIERS_rec.last_update_date
, LAST_UPDATE_LOGIN = p_MODIFIERS_rec.last_update_login
, LIST_HEADER_ID = p_MODIFIERS_rec.list_header_id
, LIST_LINE_ID = p_MODIFIERS_rec.list_line_id
, LIST_LINE_TYPE_CODE = p_MODIFIERS_rec.list_line_type_code
, LIST_PRICE = p_MODIFIERS_rec.list_price
, MODIFIER_LEVEL_CODE = p_MODIFIERS_rec.modifier_level_code
, NUMBER_EFFECTIVE_PERIODS = p_MODIFIERS_rec.number_effective_periods
, OPERAND = p_MODIFIERS_rec.operand
, ORGANIZATION_ID = p_MODIFIERS_rec.organization_id
, OVERRIDE_FLAG = p_MODIFIERS_rec.override_flag
, PERCENT_PRICE = p_MODIFIERS_rec.percent_price
, PRICE_BREAK_TYPE_CODE = p_MODIFIERS_rec.price_break_type_code
, PRICE_BY_FORMULA_ID = p_MODIFIERS_rec.price_by_formula_id
, PRIMARY_UOM_FLAG = p_MODIFIERS_rec.primary_uom_flag
, PRINT_ON_INVOICE_FLAG = p_MODIFIERS_rec.print_on_invoice_flag
, PROGRAM_APPLICATION_ID = p_MODIFIERS_rec.program_application_id
, PROGRAM_ID = p_MODIFIERS_rec.program_id
, PROGRAM_UPDATE_DATE = p_MODIFIERS_rec.program_update_date
, REBATE_TRANSACTION_TYPE_CODE = p_MODIFIERS_rec.rebate_trxn_type_code
, RELATED_ITEM_ID = p_MODIFIERS_rec.related_item_id
, RELATIONSHIP_TYPE_ID = p_MODIFIERS_rec.relationship_type_id
, REPRICE_FLAG = p_MODIFIERS_rec.reprice_flag
, REQUEST_ID = p_MODIFIERS_rec.request_id
, REVISION = p_MODIFIERS_rec.revision
, REVISION_DATE = p_MODIFIERS_rec.revision_date
, REVISION_REASON_CODE = p_MODIFIERS_rec.revision_reason_code
, START_DATE_ACTIVE = p_MODIFIERS_rec.start_date_active
, SUBSTITUTION_ATTRIBUTE = p_MODIFIERS_rec.substitution_attribute
, SUBSTITUTION_CONTEXT = p_MODIFIERS_rec.substitution_context
, SUBSTITUTION_VALUE = p_MODIFIERS_rec.substitution_value
, ACCRUAL_FLAG = p_MODIFIERS_rec.accrual_flag
, PRICING_GROUP_SEQUENCE = p_MODIFIERS_rec.pricing_group_sequence
, INCOMPATIBILITY_GRP_CODE = p_MODIFIERS_rec.incompatibility_grp_code
, LIST_LINE_NO = p_MODIFIERS_rec.list_line_no
, PRODUCT_PRECEDENCE = p_MODIFIERS_rec.product_precedence
, EXPIRATION_PERIOD_START_DATE = p_MODIFIERS_rec.expiration_period_start_date
, NUMBER_EXPIRATION_PERIODS = p_MODIFIERS_rec.number_expiration_periods
, EXPIRATION_PERIOD_UOM = p_MODIFIERS_rec.expiration_period_uom
, EXPIRATION_DATE = p_MODIFIERS_rec.expiration_date
, ESTIM_GL_VALUE = p_MODIFIERS_rec.estim_gl_value
, BENEFIT_PRICE_LIST_LINE_ID = p_MODIFIERS_rec.benefit_price_list_line_id
-- , RECURRING_FLAG = p_MODIFIERS_rec.recurring_flag
, BENEFIT_LIMIT = p_MODIFIERS_rec.benefit_limit
, CHARGE_TYPE_CODE = p_MODIFIERS_rec.charge_type_code
, CHARGE_SUBTYPE_CODE = p_MODIFIERS_rec.charge_subtype_code
, BENEFIT_QTY = p_MODIFIERS_rec.benefit_qty
, BENEFIT_UOM_CODE = p_MODIFIERS_rec.benefit_uom_code
, ACCRUAL_CONVERSION_RATE = p_MODIFIERS_rec.accrual_conversion_rate
, PRORATION_TYPE_CODE = p_MODIFIERS_rec.proration_type_code
, INCLUDE_ON_RETURNS_FLAG = p_MODIFIERS_rec.include_on_returns_flag
, QUALIFICATION_IND = p_MODIFIERS_rec.qualification_ind
, NET_AMOUNT_FLAG = p_MODIFIERS_rec.net_amount_flag
, ACCUM_ATTRIBUTE = p_MODIFIERS_rec.accum_attribute
, ACCUM_CONTEXT = v_accum_context
, ACCUM_ATTR_RUN_SRC_FLAG = v_accum_flag
, CONTINUOUS_PRICE_BREAK_FLAG = p_MODIFIERS_rec.continuous_price_break_flag
, SERVICE_DURATION = p_MODIFIERS_rec.service_duration -- service project
, SERVICE_PERIOD = p_MODIFIERS_rec.service_period -- service project
WHERE LIST_LINE_ID = p_MODIFIERS_rec.list_line_id
;
oe_debug_pub.add('start update child'||p_modifiers_rec.list_line_type_code);
update_child_lines(p_Modifiers_rec);
oe_debug_pub.add('end update child'||p_modifiers_rec.list_line_type_code);
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
WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
AND a.prc_context_id=b.prc_context_id
AND b.prc_context_type = 'PRICING_ATTRIBUTE'
AND b.prc_context_code=v_accum_context);
oe_debug_pub.add('END Update_Row in QPXUMLLB');
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
)
IS
l_return_status VARCHAR2(30);
oe_debug_pub.add('BEGIN Insert_Row in QPXUMLLB'||p_MODIFIERS_rec.list_line_type_code);
SELECT nvl(user_sourcing_method,seeded_sourcing_method)
INTO l_sourcing_method
FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
WHERE c.prc_context_code = 'VOLUME'
AND c.prc_context_type = 'PRICING_ATTRIBUTE'
AND c.prc_context_id = s.prc_context_id
AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute
AND s.segment_id = ps.segment_id
AND ps.pte_code = l_pte_code;
SELECT ACTIVE_FLAG
INTO l_active_flag
FROM QP_LIST_HEADERS_B
WHERE list_header_id=p_MODIFIERS_rec.list_header_id;
INSERT INTO QP_LIST_LINES
( ARITHMETIC_OPERATOR
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
-- , BASE_QTY
, PRICING_PHASE_ID
-- , BASE_UOM_CODE
, COMMENTS
, CONTEXT
, CREATED_BY
, CREATION_DATE
, EFFECTIVE_PERIOD_UOM
, END_DATE_ACTIVE
, ESTIM_ACCRUAL_RATE
, GENERATE_USING_FORMULA_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, LIST_PRICE
, MODIFIER_LEVEL_CODE
, NUMBER_EFFECTIVE_PERIODS
, OPERAND
, ORGANIZATION_ID
, OVERRIDE_FLAG
, PERCENT_PRICE
, PRICE_BREAK_TYPE_CODE
, PRICE_BY_FORMULA_ID
, PRIMARY_UOM_FLAG
, PRINT_ON_INVOICE_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REBATE_TRANSACTION_TYPE_CODE
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, REPRICE_FLAG
, REQUEST_ID
, REVISION
, REVISION_DATE
, REVISION_REASON_CODE
, START_DATE_ACTIVE
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_VALUE
, ACCRUAL_FLAG
, PRICING_GROUP_SEQUENCE
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_NO
, PRODUCT_PRECEDENCE
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE
, ESTIM_GL_VALUE
, BENEFIT_PRICE_LIST_LINE_ID
-- , RECURRING_FLAG
, BENEFIT_LIMIT
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, ACCRUAL_CONVERSION_RATE
, PRORATION_TYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, QUALIFICATION_IND
, NET_AMOUNT_FLAG
, ACCUM_ATTRIBUTE
, ACCUM_CONTEXT
, ACCUM_ATTR_RUN_SRC_FLAG
, CONTINUOUS_PRICE_BREAK_FLAG
, SERVICE_DURATION -- service project
, SERVICE_PERIOD -- service project
)
VALUES
( p_MODIFIERS_rec.arithmetic_operator
, p_MODIFIERS_rec.attribute1
, p_MODIFIERS_rec.attribute10
, p_MODIFIERS_rec.attribute11
, p_MODIFIERS_rec.attribute12
, p_MODIFIERS_rec.attribute13
, p_MODIFIERS_rec.attribute14
, p_MODIFIERS_rec.attribute15
, p_MODIFIERS_rec.attribute2
, p_MODIFIERS_rec.attribute3
, p_MODIFIERS_rec.attribute4
, p_MODIFIERS_rec.attribute5
, p_MODIFIERS_rec.attribute6
, p_MODIFIERS_rec.attribute7
, p_MODIFIERS_rec.attribute8
, p_MODIFIERS_rec.attribute9
, p_MODIFIERS_rec.automatic_flag
-- , p_MODIFIERS_rec.base_qty
, p_MODIFIERS_rec.pricing_phase_id
-- , p_MODIFIERS_rec.base_uom_code
, p_MODIFIERS_rec.comments
, p_MODIFIERS_rec.context
, p_MODIFIERS_rec.created_by
, p_MODIFIERS_rec.creation_date
, p_MODIFIERS_rec.effective_period_uom
, p_MODIFIERS_rec.end_date_active
, p_MODIFIERS_rec.estim_accrual_rate
, p_MODIFIERS_rec.generate_using_formula_id
, p_MODIFIERS_rec.inventory_item_id
, p_MODIFIERS_rec.last_updated_by
, p_MODIFIERS_rec.last_update_date
, p_MODIFIERS_rec.last_update_login
, p_MODIFIERS_rec.list_header_id
, p_MODIFIERS_rec.list_line_id
, p_MODIFIERS_rec.list_line_type_code
, p_MODIFIERS_rec.list_price
, p_MODIFIERS_rec.modifier_level_code
, p_MODIFIERS_rec.number_effective_periods
, p_MODIFIERS_rec.operand
, p_MODIFIERS_rec.organization_id
, p_MODIFIERS_rec.override_flag
, p_MODIFIERS_rec.percent_price
, p_MODIFIERS_rec.price_break_type_code
, p_MODIFIERS_rec.price_by_formula_id
, p_MODIFIERS_rec.primary_uom_flag
, p_MODIFIERS_rec.print_on_invoice_flag
, p_MODIFIERS_rec.program_application_id
, p_MODIFIERS_rec.program_id
, p_MODIFIERS_rec.program_update_date
, p_MODIFIERS_rec.rebate_trxn_type_code
, p_MODIFIERS_rec.related_item_id
, p_MODIFIERS_rec.relationship_type_id
, p_MODIFIERS_rec.reprice_flag
, p_MODIFIERS_rec.request_id
, p_MODIFIERS_rec.revision
, p_MODIFIERS_rec.revision_date
, p_MODIFIERS_rec.revision_reason_code
, p_MODIFIERS_rec.start_date_active
, p_MODIFIERS_rec.substitution_attribute
, p_MODIFIERS_rec.substitution_context
, p_MODIFIERS_rec.substitution_value
, p_MODIFIERS_rec.accrual_flag
, p_MODIFIERS_rec.pricing_group_sequence
, p_MODIFIERS_rec.incompatibility_grp_code
, p_MODIFIERS_rec.list_line_no
, p_MODIFIERS_rec.product_precedence
, p_MODIFIERS_rec.expiration_period_start_date
, p_MODIFIERS_rec.number_expiration_periods
, p_MODIFIERS_rec.expiration_period_uom
, p_MODIFIERS_rec.expiration_date
, p_MODIFIERS_rec.estim_gl_value
, p_MODIFIERS_rec.benefit_price_list_line_id
-- , p_MODIFIERS_rec.recurring_flag
, p_MODIFIERS_rec.benefit_limit
, p_MODIFIERS_rec.charge_type_code
, p_MODIFIERS_rec.charge_subtype_code
, p_MODIFIERS_rec.benefit_qty
, p_MODIFIERS_rec.benefit_uom_code
, p_MODIFIERS_rec.accrual_conversion_rate
, p_MODIFIERS_rec.proration_type_code
, p_MODIFIERS_rec.include_on_returns_flag
, p_MODIFIERS_rec.qualification_ind
, p_MODIFIERS_rec.net_amount_flag
, p_MODIFIERS_rec.accum_attribute
, v_accum_context
, v_accum_flag
, p_MODIFIERS_rec.continuous_price_break_flag
, p_MODIFIERS_rec.service_duration -- service project
, p_MODIFIERS_rec.service_period -- service project
);
select gsa_indicator
into l_gsa_indicator
from qp_list_headers_b
where list_header_id = p_MODIFIERS_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
WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
AND a.prc_context_id=b.prc_context_id
AND b.prc_context_type = 'PRICING_ATTRIBUTE'
AND b.prc_context_code=v_accum_context);
oe_debug_pub.add('END Insert_Row in QPXUMLLB');
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_list_line_id IN NUMBER
)
IS
BEGIN
oe_debug_pub.add('BEGIN Delete_Row in QPXUMLLB');
DELETE FROM QP_PRICING_ATTRIBUTES
WHERE LIST_LINE_ID = p_list_line_id;
DELETE FROM QP_QUALIFIERS
WHERE LIST_LINE_ID = p_list_line_id;
DELETE FROM QP_RLTD_MODIFIERS
WHERE TO_RLTD_MODIFIER_ID = p_list_line_id;
DELETE FROM QP_LIST_LINES
WHERE LIST_LINE_ID = p_list_line_id ;
oe_debug_pub.add('END Delete_Row in QPXUMLLB');
, 'Delete_Row'
);
END Delete_Row;
SELECT ARITHMETIC_OPERATOR
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
-- , BASE_QTY
, PRICING_PHASE_ID
-- , BASE_UOM_CODE
, COMMENTS
, CONTEXT
, CREATED_BY
, CREATION_DATE
, EFFECTIVE_PERIOD_UOM
, END_DATE_ACTIVE
, ESTIM_ACCRUAL_RATE
, GENERATE_USING_FORMULA_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, LIST_PRICE
, MODIFIER_LEVEL_CODE
, NUMBER_EFFECTIVE_PERIODS
, OPERAND
, ORGANIZATION_ID
, OVERRIDE_FLAG
, PERCENT_PRICE
, PRICE_BREAK_TYPE_CODE
, PRICE_BY_FORMULA_ID
, PRIMARY_UOM_FLAG
, PRINT_ON_INVOICE_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REBATE_TRANSACTION_TYPE_CODE
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, REPRICE_FLAG
, REQUEST_ID
, REVISION
, REVISION_DATE
, REVISION_REASON_CODE
, START_DATE_ACTIVE
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_VALUE
, ACCRUAL_FLAG
, PRICING_GROUP_SEQUENCE
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_NO
, PRODUCT_PRECEDENCE
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE
, ESTIM_GL_VALUE
, BENEFIT_PRICE_LIST_LINE_ID
-- , RECURRING_FLAG
, BENEFIT_LIMIT
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, ACCRUAL_CONVERSION_RATE
, PRORATION_TYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, QUALIFICATION_IND
, NET_AMOUNT_FLAG
, ACCUM_ATTRIBUTE
, CONTINUOUS_PRICE_BREAK_FLAG
, SERVICE_DURATION
, SERVICE_PERIOD
FROM QP_LIST_LINES
WHERE ( LIST_LINE_ID = p_list_line_id)
UNION -- Changed for the bug#2715150
SELECT ARITHMETIC_OPERATOR
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
-- , BASE_QTY
, PRICING_PHASE_ID
-- , BASE_UOM_CODE
, COMMENTS
, CONTEXT
, CREATED_BY
, CREATION_DATE
, EFFECTIVE_PERIOD_UOM
, END_DATE_ACTIVE
, ESTIM_ACCRUAL_RATE
, GENERATE_USING_FORMULA_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, LIST_PRICE
, MODIFIER_LEVEL_CODE
, NUMBER_EFFECTIVE_PERIODS
, OPERAND
, ORGANIZATION_ID
, OVERRIDE_FLAG
, PERCENT_PRICE
, PRICE_BREAK_TYPE_CODE
, PRICE_BY_FORMULA_ID
, PRIMARY_UOM_FLAG
, PRINT_ON_INVOICE_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REBATE_TRANSACTION_TYPE_CODE
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, REPRICE_FLAG
, REQUEST_ID
, REVISION
, REVISION_DATE
, REVISION_REASON_CODE
, START_DATE_ACTIVE
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_VALUE
, ACCRUAL_FLAG
, PRICING_GROUP_SEQUENCE
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_NO
, PRODUCT_PRECEDENCE
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE
, ESTIM_GL_VALUE
, BENEFIT_PRICE_LIST_LINE_ID
-- , RECURRING_FLAG
, BENEFIT_LIMIT
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, ACCRUAL_CONVERSION_RATE
, PRORATION_TYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, QUALIFICATION_IND
, NET_AMOUNT_FLAG
, ACCUM_ATTRIBUTE
, CONTINUOUS_PRICE_BREAK_FLAG
, SERVICE_DURATION
, SERVICE_PERIOD
FROM QP_LIST_LINES
WHERE ( LIST_HEADER_ID = p_list_header_id );
l_MODIFIERS_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
l_MODIFIERS_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
l_MODIFIERS_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
l_MODIFIERS_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;
SELECT RLTD_MODIFIER_GRP_NO
, RLTD_MODIFIER_GRP_TYPE
, FROM_RLTD_MODIFIER_ID
, TO_RLTD_MODIFIER_ID
, RLTD_MODIFIER_ID
INTO l_MODIFIERS_rec.rltd_modifier_grp_no
, l_MODIFIERS_rec.rltd_modifier_grp_type
, l_MODIFIERS_rec.from_rltd_modifier_id
, l_MODIFIERS_rec.to_rltd_modifier_id
, l_MODIFIERS_rec.rltd_modifier_id
FROM QP_RLTD_MODIFIERS
WHERE ( TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID )
AND EXISTS
( SELECT TO_RLTD_MODIFIER_ID
FROM QP_RLTD_MODIFIERS
WHERE TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID );
SELECT ARITHMETIC_OPERATOR
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
-- , BASE_QTY
, PRICING_PHASE_ID
-- , BASE_UOM_CODE
, COMMENTS
, CONTEXT
, CREATED_BY
, CREATION_DATE
, EFFECTIVE_PERIOD_UOM
, END_DATE_ACTIVE
, ESTIM_ACCRUAL_RATE
, GENERATE_USING_FORMULA_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, LIST_PRICE
, MODIFIER_LEVEL_CODE
, NUMBER_EFFECTIVE_PERIODS
, OPERAND
, ORGANIZATION_ID
, OVERRIDE_FLAG
, PERCENT_PRICE
, PRICE_BREAK_TYPE_CODE
, PRICE_BY_FORMULA_ID
, PRIMARY_UOM_FLAG
, PRINT_ON_INVOICE_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REBATE_TRANSACTION_TYPE_CODE
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, REPRICE_FLAG
, REQUEST_ID
, REVISION
, REVISION_DATE
, REVISION_REASON_CODE
, START_DATE_ACTIVE
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_VALUE
, ACCRUAL_FLAG
, PRICING_GROUP_SEQUENCE
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_NO
, PRODUCT_PRECEDENCE
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE
, ESTIM_GL_VALUE
, BENEFIT_PRICE_LIST_LINE_ID
-- , RECURRING_FLAG
, BENEFIT_LIMIT
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, ACCRUAL_CONVERSION_RATE
, PRORATION_TYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, ACCUM_ATTRIBUTE
, CONTINUOUS_PRICE_BREAK_FLAG
, SERVICE_DURATION
, SERVICE_PERIOD
INTO l_MODIFIERS_rec.arithmetic_operator
, l_MODIFIERS_rec.attribute1
, l_MODIFIERS_rec.attribute10
, l_MODIFIERS_rec.attribute11
, l_MODIFIERS_rec.attribute12
, l_MODIFIERS_rec.attribute13
, l_MODIFIERS_rec.attribute14
, l_MODIFIERS_rec.attribute15
, l_MODIFIERS_rec.attribute2
, l_MODIFIERS_rec.attribute3
, l_MODIFIERS_rec.attribute4
, l_MODIFIERS_rec.attribute5
, l_MODIFIERS_rec.attribute6
, l_MODIFIERS_rec.attribute7
, l_MODIFIERS_rec.attribute8
, l_MODIFIERS_rec.attribute9
, l_MODIFIERS_rec.automatic_flag
-- , l_MODIFIERS_rec.base_qty
, l_MODIFIERS_rec.pricing_phase_id
-- , l_MODIFIERS_rec.base_uom_code
, l_MODIFIERS_rec.comments
, l_MODIFIERS_rec.context
, l_MODIFIERS_rec.created_by
, l_MODIFIERS_rec.creation_date
, l_MODIFIERS_rec.effective_period_uom
, l_MODIFIERS_rec.end_date_active
, l_MODIFIERS_rec.estim_accrual_rate
, l_MODIFIERS_rec.generate_using_formula_id
, l_MODIFIERS_rec.inventory_item_id
, l_MODIFIERS_rec.last_updated_by
, l_MODIFIERS_rec.last_update_date
, l_MODIFIERS_rec.last_update_login
, l_MODIFIERS_rec.list_header_id
, l_MODIFIERS_rec.list_line_id
, l_MODIFIERS_rec.list_line_type_code
, l_MODIFIERS_rec.list_price
, l_MODIFIERS_rec.modifier_level_code
, l_MODIFIERS_rec.number_effective_periods
, l_MODIFIERS_rec.operand
, l_MODIFIERS_rec.organization_id
, l_MODIFIERS_rec.override_flag
, l_MODIFIERS_rec.percent_price
, l_MODIFIERS_rec.price_break_type_code
, l_MODIFIERS_rec.price_by_formula_id
, l_MODIFIERS_rec.primary_uom_flag
, l_MODIFIERS_rec.print_on_invoice_flag
, l_MODIFIERS_rec.program_application_id
, l_MODIFIERS_rec.program_id
, l_MODIFIERS_rec.program_update_date
, l_MODIFIERS_rec.rebate_trxn_type_code
, l_MODIFIERS_rec.related_item_id
, l_MODIFIERS_rec.relationship_type_id
, l_MODIFIERS_rec.reprice_flag
, l_MODIFIERS_rec.request_id
, l_MODIFIERS_rec.revision
, l_MODIFIERS_rec.revision_date
, l_MODIFIERS_rec.revision_reason_code
, l_MODIFIERS_rec.start_date_active
, l_MODIFIERS_rec.substitution_attribute
, l_MODIFIERS_rec.substitution_context
, l_MODIFIERS_rec.substitution_value
, l_MODIFIERS_rec.accrual_flag
, l_MODIFIERS_rec.pricing_group_sequence
, l_MODIFIERS_rec.incompatibility_grp_code
, l_MODIFIERS_rec.list_line_no
, l_MODIFIERS_rec.product_precedence
, l_MODIFIERS_rec.expiration_period_start_date
, l_MODIFIERS_rec.number_expiration_periods
, l_MODIFIERS_rec.expiration_period_uom
, l_MODIFIERS_rec.expiration_date
, l_MODIFIERS_rec.estim_gl_value
, l_MODIFIERS_rec.benefit_price_list_line_id
-- , l_MODIFIERS_rec.recurring_flag
, l_MODIFIERS_rec.benefit_limit
, l_MODIFIERS_rec.charge_type_code
, l_MODIFIERS_rec.charge_subtype_code
, l_MODIFIERS_rec.benefit_qty
, l_MODIFIERS_rec.benefit_uom_code
, l_MODIFIERS_rec.accrual_conversion_rate
, l_MODIFIERS_rec.proration_type_code
, l_MODIFIERS_rec.include_on_returns_flag
, l_MODIFIERS_rec.accum_attribute
, l_MODIFIERS_rec.continuous_price_break_flag
, l_MODIFIERS_rec.service_duration
, l_MODIFIERS_rec.service_period
FROM QP_LIST_LINES
WHERE LIST_LINE_ID = p_MODIFIERS_rec.list_line_id
FOR UPDATE NOWAIT;
oe_debug_pub.add('p_MODIFIERS_rec.last_updated_by :'||p_MODIFIERS_rec.last_updated_by||':'||'l_MODIFIERS_rec.last_updated_by:'||l_MODIFIERS_rec.last_updated_by||':');
oe_debug_pub.add('p_MODIFIERS_rec.last_update_date :'||p_MODIFIERS_rec.last_update_date||':'||'l_MODIFIERS_rec.last_update_date:'||l_MODIFIERS_rec.last_update_date||':');
oe_debug_pub.add('p_MODIFIERS_rec.last_update_login :'||p_MODIFIERS_rec.last_update_login||':'||'l_MODIFIERS_rec.last_update_login:'||l_MODIFIERS_rec.last_update_login||':');
oe_debug_pub.add('p_MODIFIERS_rec.program_update_date :'||p_MODIFIERS_rec.program_update_date||':'||'l_MODIFIERS_rec.program_update_date:'||l_MODIFIERS_rec.program_update_date||':');
oe_debug_pub.add('p_MODIFIERS_rec.last_updated_by :'||p_MODIFIERS_rec.last_updated_by||':'||'l_MODIFIERS_rec.last_updated_by:'||l_MODIFIERS_rec.last_updated_by||':');
oe_debug_pub.add('p_MODIFIERS_rec.last_update_date :'||p_MODIFIERS_rec.last_update_date||':'||'l_MODIFIERS_rec.last_update_date:'||l_MODIFIERS_rec.last_update_date||':');
oe_debug_pub.add('p_MODIFIERS_rec.last_update_login :'||p_MODIFIERS_rec.last_update_login||':'||'l_MODIFIERS_rec.last_update_login:'||l_MODIFIERS_rec.last_update_login||':');
oe_debug_pub.add('p_MODIFIERS_rec.program_update_date :'||p_MODIFIERS_rec.program_update_date||':'||'l_MODIFIERS_rec.program_update_date:'||l_MODIFIERS_rec.program_update_date||':');
FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
(OE_GLOBALS.G_OPR_CREATE, OE_GLOBALS.G_OPR_UPDATE)) THEN
oe_debug_pub.add('request to update QP_PRICING_PHASES '||l_parent_line_type, 1);
oe_debug_pub.add('Logging a request to update QP_PRICING_PHASES ', 1);
((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE) and
(p_old_MODIFIERS_rec.pricing_phase_id <> p_MODIFIERS_rec.pricing_phase_id))
then
qp_delayed_requests_PVT.log_request(
p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
p_entity_id => p_MODIFIERS_rec.list_header_id,
p_param1 => p_MODIFIERS_rec.pricing_phase_id,
p_param4 => l_call_from,
p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => l_return_status);
p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => l_return_status);
if (p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE)
then
l_call_from :=2;
Log_Update_Phases_DL(p_MODIFIERS_rec => p_MODIFIERS_rec,
x_return_status => l_return_status);
p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => l_return_status);
select active_flag into l_active_flag from qp_list_headers_b
where list_header_id =p_MODIFIERS_rec.list_header_id;
select count(*) into l_count from qp_list_lines qll
where automatic_flag = p_old_MODIFIERS_rec.automatic_flag and
pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => l_return_status);
oe_debug_pub.add('request to update G_UPDATE_MANUAL_MODIFIER_FLAG '||l_parent_line_type, 1);
oe_debug_pub.add('Logging a request to update G_UPDATE_MANUAL_MODIFIER_FLAG ', 1);
p_request_type => QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG,
x_return_status => l_return_status);
Procedure Log_Update_Phases_DL(p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type,
x_return_status OUT NOCOPY VARCHAR2)
IS
l_active_flag varchar2(1);
select active_flag into l_active_flag from qp_list_headers
where list_header_id = p_MODIFIERS_rec.list_header_id;
select manual_modifier_flag into l_manual_modifier_flag
from qp_pricing_phases
where pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => l_return_status);
p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => l_return_status);
p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
x_return_status => l_return_status);
END Log_Update_Phases_DL;