[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,OLD_DISCOUNT_LINE_ID,
NEW_LIST_HEADER_ID,NEW_LIST_LINE_ID, OLD_PRICE_BREAK_LINES_LOW,
OLD_PRICE_BREAK_LINES_HIGH, OLD_METHOD_TYPE_CODE, OLD_PRICE_BREAK_PERCENT,
OLD_PRICE_BREAK_AMOUNT, OLD_PRICE_BREAK_PRICE, NEW_TYPE,PRICING_CONTEXT)
VALUES (p_old_discount_id,p_old_discount_line_id,p_new_list_header_id,p_new_list_line_id,
p_old_pbl_low,p_old_pbl_high,p_old_method_type_code,p_old_pb_percent,
p_old_pb_amount,p_old_pb_price,p_new_type,p_pricing_context);
delete qp_upg_lines_distribution
where line_type = v_type;
SELECT
NVL(MIN(DISCOUNT_ID),0),
NVL(MAX(DISCOUNT_ID),0)
INTO
l_min_line,
l_max_line
FROM
SO_DISCOUNTS;
QP_Modifier_Upgrade_Util_PVT.insert_line_distribution
( l_worker => i,
l_start_line => l_worker_start,
l_end_line => l_worker_end,
l_type_var => v_type);
SELECT sod.DISCOUNT_ID, sod.CREATION_DATE, sod.CREATED_BY, sod.LAST_UPDATE_DATE,
sod.LAST_UPDATED_BY, sod.LAST_UPDATE_LOGIN, sod.PROGRAM_APPLICATION_ID, sod.PROGRAM_ID,
sod.PROGRAM_UPDATE_DATE,sod.REQUEST_ID, sod.NAME, sod.DISCOUNT_TYPE_CODE, sod.PRICE_LIST_ID,
nvl(sod.AUTOMATIC_DISCOUNT_FLAG,'N') AUTOMATIC_DISCOUNT_FLAG, sod.OVERRIDE_ALLOWED_FLAG,
sod.GSA_INDICATOR, sod.PRORATE_FLAG, sod.PERCENT, sod.AMOUNT, sod.START_DATE_ACTIVE, sod.END_DATE_ACTIVE,
sod.DESCRIPTION, sod.DISCOUNT_LINES_FLAG, sopl.CURRENCY_CODE,sod.CONTEXT,
sod.ATTRIBUTE1, sod.ATTRIBUTE2, sod.ATTRIBUTE3,sod.ATTRIBUTE4,sod.ATTRIBUTE5,sod.ATTRIBUTE6,sod.ATTRIBUTE7,
sod.ATTRIBUTE8, sod.ATTRIBUTE9,sod.ATTRIBUTE10,sod.ATTRIBUTE11,sod.ATTRIBUTE12,sod.ATTRIBUTE13,
sod.ATTRIBUTE14, sod.ATTRIBUTE15
FROM SO_DISCOUNTS sod,QP_LIST_HEADERS_B sopl
WHERE sod.price_list_id = sopl.list_header_id
AND NOT EXISTS (SELECT 'x'
FROM QP_DISCOUNT_MAPPING a
WHERE a.OLD_DISCOUNT_ID = sod.DISCOUNT_ID
AND a.NEW_TYPE in ('O','L','Q','X'))
AND sod.DISCOUNT_ID BETWEEN p_min_line and p_max_line;
SELECT CUSTOMER_CLASS_CODE ,CUSTOMER_ID , SITE_USE_ID,START_DATE_ACTIVE,END_DATE_ACTIVE,CONTEXT,ATTRIBUTE1,
ATTRIBUTE2,ATTRIBUTE3, ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,
ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
FROM SO_DISCOUNT_CUSTOMERS
WHERE DISCOUNT_ID = p_discount_id;
SELECT DISCOUNT_LINE_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
REQUEST_ID, DISCOUNT_ID, ENTITY_ID, ENTITY_VALUE, PERCENT,
AMOUNT, PRICE, START_DATE_ACTIVE, END_DATE_ACTIVE,CONTEXT,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,
ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,
ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
FROM SO_DISCOUNT_LINES_115
WHERE DISCOUNT_ID = p_discount_id;
SELECT PRICE_BREAK_LINES_LOW_RANGE, PRICE_BREAK_LINES_HIGH_RANGE, DISCOUNT_LINE_ID,
METHOD_TYPE_CODE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
REQUEST_ID, PERCENT, AMOUNT, PRICE, UNIT_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE,
CONTEXT,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3, ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,
ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
FROM SO_PRICE_BREAK_LINES
WHERE DISCOUNT_LINE_ID = p_discount_line_id;
SELECT a.DISCOUNT_ID,a.PRICE_LIST_ID
FROM SO_DISCOUNTS a
WHERE NOT EXISTS ( SELECT 'x'
FROM QP_LIST_HEADERS_B b
WHERE b.LIST_HEADER_ID = a.PRICE_LIST_ID);
SELECT nvl(a.DESCRIPTIVE_FLEX_CONTEXT_CODE,'Global Data Elements') descriptive_flex_context_code ,
b.ENTITY_CODE, a.COLUMN_SEQ_NUM, nvl(c.FORMAT_TYPE,'C') FORMAT_TYPE
FROM FND_DESCR_FLEX_COLUMN_USAGES a , SO_ENTITIES b, fnd_flex_value_sets c
WHERE a.DESCRIPTIVE_FLEXFIELD_NAME = 'PRICING_ATTRIBUTES'
AND a.APPLICATION_COLUMN_NAME = b.ENTITY_CODE
AND b.ENTITY_ID = p_entity_id
AND a.FLEX_VALUE_SET_ID = c.FLEX_VALUE_SET_ID(+);
SELECT distinct a.UNIT_CODE
FROM SO_PRICE_LIST_LINES_115 a
WHERE a.PRICE_LIST_ID = p_price_list_id
AND a.INVENTORY_ITEM_ID = p_entity_value;
select start_line_id,
end_line_id
into v_min_line,
v_max_line
from qp_upg_lines_distribution
where worker = l_worker
and line_type = G_LIST_TYPE_CODE;
i.last_update_date,
i.last_updated_by,
nvl(i.last_update_login,1),
G_LIST_TYPE_CODE,
i.start_date_active,
i.end_date_active,
nvl(i.automatic_discount_flag,'N'),
i.discount_lines_flag,
i.currency_code,
i.name,
i.description,
NULL,--version_no,
'N', -- ask_for_flag
'QP',--source_sys_code
'Y',--active_flag,
nvl(i.gsa_indicator,'N'),
i.context,
i.attribute1,
i.attribute2,
i.attribute3,
i.attribute4,
i.attribute5,
i.attribute6,
i.attribute7,
i.attribute8,
i.attribute9,
i.attribute10,
i.attribute11,
i.attribute12,
i.attribute13,
i.attribute14,
i.attribute15,
v_new_flag,
v_seq_num,
v_old_discount_id,
'DISCOUNTS',
x_list_header_id);
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
'N',
G_COMPARATOR_CODE,
v_context,
v_attribute_name,
i.price_list_id,
null,
v_list_header_id,
NULL,
-- x_qualifier_precedence,
-- nvl(x_qualifier_datatype,'C'),
140,
'C',
null, -- start_date_active
null, -- end_date_active
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
v_old_discount_id,
'DISCOUNTS',
x_qualifier_grouping_no);
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
'N',
G_COMPARATOR_CODE,
v_context,
v_attribute_name,
i.gsa_indicator,
-1,
v_list_header_id,
NULL,
-- x_qualifier_precedence,
-- nvl(x_qualifier_datatype,'C'),
100,
'C',
null, -- start_date_active
null, -- end_date_active
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
v_old_discount_id,
'DISCOUNTS',
x_qualifier_grouping_no);
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
'N',
G_COMPARATOR_CODE,
v_context,
v_attribute_name,
l.customer_class_code,
v_cust_qualifier_grp_no,
v_list_header_id,
NULL,
-- x_qualifier_precedence,
-- nvl(x_qualifier_datatype,'C'),
310,
'C',
l.start_date_active,
l.end_date_active,
l.context,
l.attribute1,
l.attribute2,
l.attribute3,
l.attribute4,
l.attribute5,
l.attribute6,
l.attribute7,
l.attribute8,
l.attribute9,
l.attribute10,
l.attribute11,
l.attribute12,
l.attribute13,
l.attribute14,
l.attribute15,
v_old_discount_id,
'DISCOUNTS',
x_qualifier_grouping_no);
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
'N',
G_COMPARATOR_CODE,
v_context,
v_attribute_name,
l.site_use_id,
v_cust_qualifier_grp_no,
v_list_header_id,
NULL,
-- x_qualifier_precedence,
-- nvl(x_qualifier_datatype,'C'),
270,
'N',
l.start_date_active,
l.end_date_active,
l.context,
l.attribute1,
l.attribute2,
l.attribute3,
l.attribute4,
l.attribute5,
l.attribute6,
l.attribute7,
l.attribute8,
l.attribute9,
l.attribute10,
l.attribute11,
l.attribute12,
l.attribute13,
l.attribute14,
l.attribute15,
v_old_discount_id,
'DISCOUNTS',
x_qualifier_grouping_no);
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
'N',
G_COMPARATOR_CODE,
v_context,
v_attribute_name,
l.customer_id,
v_cust_qualifier_grp_no,
v_list_header_id,
NULL,
-- x_qualifier_precedence,
-- nvl(x_qualifier_datatype,'C'),
260,
'N',
l.start_date_active,
l.end_date_active,
l.context,
l.attribute1,
l.attribute2,
l.attribute3,
l.attribute4,
l.attribute5,
l.attribute6,
l.attribute7,
l.attribute8,
l.attribute9,
l.attribute10,
l.attribute11,
l.attribute12,
l.attribute13,
l.attribute14,
l.attribute15,
v_old_discount_id,
'DISCOUNTS',
x_qualifier_grouping_no);
select count(*)
into number_discount_lines
from so_discount_lines_115
where discount_id = i.discount_id;
select a.COLUMN_SEQ_NUM
INTO v_precedence
FROM FND_DESCR_FLEX_COLUMN_USAGES a
WHERE a.DESCRIPTIVE_FLEXFIELD_NAME = 'QP_ATTR_DEFNS_PRICING'
AND a.APPLICATION_ID = 661 --(QP). Added for bug 5030757
AND a.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'ITEM'
AND a.APPLICATION_COLUMN_NAME = 'PRICING_ATTRIBUTE3';
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
v_list_header_id,
v_line_type_code,
i.start_date_active,
i.end_date_active,
i.automatic_discount_flag,
v_discount_level,
x_arithmetic_operator,
x_operand,
v_pricing_phase_id,
v_incomp_grp_code, -- incomp_grp_code
v_pricing_group_sequence, -- pricing_group_seq
'N', -- accrual_flag
-- NULL, -- issue Can this be null
v_precedence, -- for bug 1807828
i.PRORATE_FLAG,
'N', -- print on invoice flag
nvl(i.override_allowed_flag,'N'), -- override flag
null,
i.context,
i.attribute1,
i.attribute2,
i.attribute3,
i.attribute4,
i.attribute5,
i.attribute6,
i.attribute7,
i.attribute8,
i.attribute9,
i.attribute10,
i.attribute11,
i.attribute12,
i.attribute13,
i.attribute14,
i.attribute15,
v_qualification_ind,
v_new_line_flag,
v_line_seq_num,
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_list_line_id);
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
v_list_line_id,
'N',
'N',
'ITEM',
'PRICING_ATTRIBUTE3',
'ALL',
NULL, --Product UOM Code
NULL,
NULL,
NULL,--Pricing attr value from
NULL, --Pricing_attr_value_to
NULL, -- changed to NULL from BETWEEN for bug 1872995
'N', -- pricing datatype
'C',
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_pricing_attribute_id);
j.last_update_date,
j.last_updated_by,
j.last_update_login,
j.program_application_id,
j.program_id,
j.program_update_date,
j.request_id,
v_list_header_id,
v_line_type_code,
j.start_date_active,
j.end_date_active,
i.automatic_discount_flag,
v_discount_level,
x_arithmetic_operator,
x_operand,
v_pricing_phase_id,
v_incomp_grp_code,
v_pricing_group_sequence, -- pricing_group_seq
'N', -- accrual_flag
-- l_precedence,
b.COLUMN_SEQ_NUM,
i.PRORATE_FLAG,
'N', -- print on invoice flag
nvl(i.override_allowed_flag,'N'), -- override flag
v_price_break_type_code,
j.context,
j.attribute1,
j.attribute2,
j.attribute3,
j.attribute4,
j.attribute5,
j.attribute6,
j.attribute7,
j.attribute8,
j.attribute9,
j.attribute10,
j.attribute11,
j.attribute12,
j.attribute13,
j.attribute14,
j.attribute15,
v_qualification_ind,
v_new_line_flag,
v_line_seq_num,
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_list_line_id);
j.last_update_date,
j.last_updated_by,
j.last_update_login,
j.program_application_id,
j.program_id,
j.program_update_date,
j.request_id,
v_list_line_id,
'N',
'N',
'ITEM',
'PRICING_ATTRIBUTE3',
'ALL',
NULL, --Product UOM Code
b.descriptive_flex_context_code,-- Pricing Context
b.entity_code,--Pricing Attribute
l_pricing_attr_value_from,
NULL, --Pricing_attr_value_to
l_comparison_operator_code,
-- nvl(x_pricing_datatype,'C'),
b.FORMAT_TYPE,
'C', -- product datatype
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_pricing_attribute_id);
j.last_update_date,
j.last_updated_by,
j.last_update_login,
j.program_application_id,
j.program_id,
j.program_update_date,
j.request_id,
v_list_line_id,
'N',
'N',
'ITEM',
'PRICING_ATTRIBUTE3',
'ALL',
NULL, --Product UOM Code
v_price_context,-- Pricing Context
v_price_attribute,--Pricing Attribute
NULL , --Pricing attr value from
NULL, --Pricing_attr_value_to
v_operator_code,
'N', -- pricing datatype
'C', -- product_datatype
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_pricing_attribute_id);
-- Insert a record into the mapping table
Create_Discount_Mapping_Record(i.discount_id,j.discount_line_id,
v_list_header_id,v_list_line_id,b.descriptive_flex_context_code,v_mapping_line_type,
null,null,null,null,null,null);
SELECT a.COLUMN_SEQ_NUM, nvl(c.FORMAT_TYPE,'C')
INTO x_qualifier_precedence, x_product_datatype
--INTO l_precedence, x_product_datatype --modified by dhgupta for 2992566
FROM FND_DESCR_FLEX_COLUMN_USAGES a , fnd_flex_value_sets c
WHERE a.DESCRIPTIVE_FLEXFIELD_NAME = 'QP_ATTR_DEFNS_PRICING'
AND a.APPLICATION_ID = 661 --(QP). Added for bug 5030757
AND a.DESCRIPTIVE_FLEX_CONTEXT_CODE = v_product_context
AND a.APPLICATION_COLUMN_NAME = v_product_attribute
AND a.FLEX_VALUE_SET_ID = c.FLEX_VALUE_SET_ID(+);
SELECT a.COLUMN_SEQ_NUM, nvl(c.FORMAT_TYPE,'C')
INTO x_qualifier_precedence, x_qualifier_datatype
FROM FND_DESCR_FLEX_COLUMN_USAGES a , fnd_flex_value_sets c
WHERE a.DESCRIPTIVE_FLEXFIELD_NAME = 'QP_ATTR_DEFNS_QUALIFIER'
AND a.APPLICATION_ID = 661 --(QP). Added for bug 5030757
AND a.DESCRIPTIVE_FLEX_CONTEXT_CODE = v_product_context
AND a.APPLICATION_COLUMN_NAME = v_product_attribute
AND a.FLEX_VALUE_SET_ID = c.FLEX_VALUE_SET_ID(+);
-- Insert a record into the mapping table
Create_Discount_Mapping_Record(i.discount_id,NULL,v_list_header_id,NULL,null,'L',
null,null,null,null,null,null);
j.last_update_date,
j.last_updated_by,
j.last_update_login,
j.program_application_id,
j.program_id,
j.program_update_date,
j.request_id,
v_list_header_id,
v_line_type_code,
j.start_date_active,
j.end_date_active,
i.automatic_discount_flag,
v_discount_level,
x_arithmetic_operator,
x_operand,
v_pricing_phase_id,
v_incomp_grp_code,
v_pricing_group_sequence, -- pricing_group_seq
'N', -- accrual_flag
-- l_precedence,
x_qualifier_precedence,
i.PRORATE_FLAG,
'N', -- print on invoice flag
nvl(i.override_allowed_flag,'N'), -- override flag
v_price_break_type_code,
j.context,
j.attribute1,
j.attribute2,
j.attribute3,
j.attribute4,
j.attribute5,
j.attribute6,
j.attribute7,
j.attribute8,
j.attribute9,
j.attribute10,
j.attribute11,
j.attribute12,
j.attribute13,
j.attribute14,
j.attribute15,
v_qualification_ind,
v_new_line_flag,
v_line_seq_num,
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_list_line_id);
-- Insert a record into the mapping table
Create_Discount_Mapping_Record(i.discount_id,j.discount_line_id,
v_list_header_id,v_list_line_id,null,v_mapping_line_type, null,null,null,null,null,null);
j.last_update_date,
j.last_updated_by,
j.last_update_login,
j.program_application_id,
j.program_id,
j.program_update_date,
j.request_id,
v_list_line_id,
'N',
'N',
v_product_context,
v_product_attribute,
j.entity_value,
v_item_uom, --Product UOM Code
v_price_context ,
v_price_attribute,
NULL,--Pricing attr value from
NULL, --Pricing_attr_value_to
v_operator_code,
v_price_datatype, -- pricing datatype
nvl(x_product_datatype,'C'),
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_pricing_attribute_id);
i.last_update_date,
i.last_updated_by,
i.last_update_login,
i.program_application_id,
i.program_id,
i.program_update_date,
i.request_id,
'N',
G_COMPARATOR_CODE,
v_product_context,
v_product_attribute,
j.entity_value,
v_cust_qualifier_grp_no, --Initially 0 , so create new grp no
v_list_header_id,
v_list_line_id,
x_qualifier_precedence,
nvl(x_qualifier_datatype,'C'),
null,-- start_date_active
null,-- end_date_active
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
v_old_discount_id,
'DISCOUNTS',
x_qualifier_grouping_no);
k.last_update_date,
k.last_updated_by,
k.last_update_login,
k.program_application_id,
k.program_id,
k.program_update_date,
k.request_id,
v_list_header_id,
v_line_type_code,
k.start_date_active,
k.end_date_active,
i.automatic_discount_flag,
v_discount_level,
x_arithmetic_operator,
x_operand,
v_pricing_phase_id,
v_incomp_grp_code,
v_pricing_group_sequence, -- pricing_group_seq
'N', -- accrual_flag
-- l_precedence,
x_qualifier_precedence,
i.PRORATE_FLAG,
'N', -- print on invoice flag
nvl(i.override_allowed_flag,'N'), -- override flag
'POINT',
k.context,
k.attribute1,
k.attribute2,
k.attribute3,
k.attribute4,
k.attribute5,
k.attribute6,
k.attribute7,
k.attribute8,
k.attribute9,
k.attribute10,
k.attribute11,
k.attribute12,
k.attribute13,
k.attribute14,
k.attribute15,
v_qualification_ind,
v_new_line_flag,
v_line_seq_num,
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_list_line_id);
k.last_update_date,
k.last_updated_by,
k.last_update_login,
v_list_line_id,
v_price_break_line_id,
'PRICE BREAK',
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_rltd_modifier_id);
k.last_update_date,
k.last_updated_by,
k.last_update_login,
k.program_application_id,
k.program_id,
k.program_update_date,
k.request_id,
v_price_break_line_id,
'N',
'N',
v_product_context,
v_product_attribute,
j.entity_value,
k.unit_code, /* Product UOM Code */
v_price_break_context,
v_price_break_attribute,
k.price_break_lines_low_range,
k.price_break_lines_high_range,
'BETWEEN',
'N', -- pricing_datatype
'C', -- product datatype
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_pricing_attribute_id);
-- Insert only 1 record
IF (v_qualifier_flag = TRUE and v_break_count = 0 ) THEN
-- Create the Product/Pricing Attribute
QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute(j.creation_date,
j.created_by,
j.last_update_date,
j.last_updated_by,
j.last_update_login,
j.program_application_id,
j.program_id,
j.program_update_date,
j.request_id,
v_list_line_id,
'N',
'N',
'ITEM',
'PRICING_ATTRIBUTE3',
'ALL',
NULL, --Product UOM Code
v_price_break_context,
v_price_break_attribute,
NULL,--Pricing attr value from
NULL, --Pricing_attr_value_to
'BETWEEN',
'N', -- pricing datatype
'C',
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_pricing_attribute_id);
k.last_update_date,
k.last_updated_by,
k.last_update_login,
k.program_application_id,
k.program_id,
k.program_update_date,
k.request_id,
v_price_break_line_id,
'N',
'N',
'ITEM',
'PRICING_ATTRIBUTE3',
'ALL',
k.unit_code, /* Product UOM Code */
v_price_break_context,
v_price_break_attribute,
k.price_break_lines_low_range,
k.price_break_lines_high_range,
'BETWEEN',
'N', -- pricing datatype
'C', -- product datatype
v_old_discount_id,
v_old_discount_line_id,
'DISCOUNTS',
x_pricing_attribute_id);
-- Insert a record into the mapping table
-- Type = 'B' is the actual price break line
Create_Discount_Mapping_Record(i.discount_id,j.discount_line_id,v_list_header_id,
v_price_break_line_id,null,'B',k.price_break_lines_low_range,
k.price_break_lines_high_range,k.method_type_code,
k.percent,k.amount , k.price);
-- Update the Unit Code on the PBH line(parent Line)
-- makes PRICING_ATTRIBUTE10 to PRICING_ATTRIBUTE12(if needed)
UPDATE QP_PRICING_ATTRIBUTES
SET PRODUCT_UOM_CODE = v_unit_code,
PRICING_ATTRIBUTE = v_price_break_attribute
WHERE LIST_LINE_ID = v_list_line_id;
-- If there are no discount lines insert record into mapping table
IF (v_lines_flag = FALSE ) THEN
-- Insert a record into the mapping table
Create_Discount_Mapping_Record(i.discount_id,NULL,v_list_header_id,NULL,null,'O',
null,null,null,null,null,null);