The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_PRICE_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_PRICE_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_PRICE_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_PRICE_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_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
IF(p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF(p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF (p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF (p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF (p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
THEN
UPDATE qp_qualifiers
SET active_flag = p_PRICE_LIST_rec.active_flag
WHERE list_header_id = p_PRICE_LIST_rec.list_header_id;
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_qualifiers c
where c.list_header_id = p_PRICE_LIST_rec.list_header_id
and a.segment_mapping_column = c .qualifier_attribute
and a.segment_id = d.segment_id
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_PRICE_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_PRICE_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);
IF (p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
select BASE_ROUNDING_FACTOR
into x_PRICE_LIST_rec.rounding_factor
from QP_CURRENCY_LISTS_VL
where currency_header_id = p_PRICE_LIST_rec.currency_header_id;
IF (p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
THEN
NULL;
IF(p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF(p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
THEN
NULL;
IF (p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF( p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF( p_PRICE_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_PRICE_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_PRICE_LIST_rec.list_header_id,
p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
x_return_status => x_PRICE_LIST_rec.return_status);
IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_PRICE_LIST_rec.last_updated_by := NULL;
IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_PRICE_LIST_rec.last_update_date := NULL;
IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_PRICE_LIST_rec.last_update_login := NULL;
IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_PRICE_LIST_rec.program_update_date := NULL;
PROCEDURE Update_Row
( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
)
IS
l_price_list_exists number := 0;
IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
p_instance_type => QP_Security.G_PRICELIST_OBJECT,
p_instance_pk1 => p_PRICE_LIST_rec.list_header_id) <> 'F' THEN
--for moac changes QP_LIST_HEADERS_B to all_b to enable updates to PL 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_PRICE_LIST_rec.attribute1
, ATTRIBUTE10 = p_PRICE_LIST_rec.attribute10
, ATTRIBUTE11 = p_PRICE_LIST_rec.attribute11
, ATTRIBUTE12 = p_PRICE_LIST_rec.attribute12
, ATTRIBUTE13 = p_PRICE_LIST_rec.attribute13
, ATTRIBUTE14 = p_PRICE_LIST_rec.attribute14
, ATTRIBUTE15 = p_PRICE_LIST_rec.attribute15
, ATTRIBUTE2 = p_PRICE_LIST_rec.attribute2
, ATTRIBUTE3 = p_PRICE_LIST_rec.attribute3
, ATTRIBUTE4 = p_PRICE_LIST_rec.attribute4
, ATTRIBUTE5 = p_PRICE_LIST_rec.attribute5
, ATTRIBUTE6 = p_PRICE_LIST_rec.attribute6
, ATTRIBUTE7 = p_PRICE_LIST_rec.attribute7
, ATTRIBUTE8 = p_PRICE_LIST_rec.attribute8
, ATTRIBUTE9 = p_PRICE_LIST_rec.attribute9
, AUTOMATIC_FLAG = p_PRICE_LIST_rec.automatic_flag
, COMMENTS = p_PRICE_LIST_rec.comments
, CONTEXT = p_PRICE_LIST_rec.context
, CREATED_BY = p_PRICE_LIST_rec.created_by
, CREATION_DATE = p_PRICE_LIST_rec.creation_date
, CURRENCY_CODE = p_PRICE_LIST_rec.currency_code
, DISCOUNT_LINES_FLAG = p_PRICE_LIST_rec.discount_lines_flag
, END_DATE_ACTIVE = trunc(p_PRICE_LIST_rec.end_date_active)
, FREIGHT_TERMS_CODE = p_PRICE_LIST_rec.freight_terms_code
, GSA_INDICATOR = p_PRICE_LIST_rec.gsa_indicator
, LAST_UPDATED_BY = p_PRICE_LIST_rec.last_updated_by
, LAST_UPDATE_DATE = p_PRICE_LIST_rec.last_update_date
, LAST_UPDATE_LOGIN = p_PRICE_LIST_rec.last_update_login
, LIST_HEADER_ID = p_PRICE_LIST_rec.list_header_id
, LIST_TYPE_CODE = p_PRICE_LIST_rec.list_type_code
, PROGRAM_APPLICATION_ID = p_PRICE_LIST_rec.program_application_id
, PROGRAM_ID = p_PRICE_LIST_rec.program_id
, PROGRAM_UPDATE_DATE = p_PRICE_LIST_rec.program_update_date
, PRORATE_FLAG = p_PRICE_LIST_rec.prorate_flag
, REQUEST_ID = p_PRICE_LIST_rec.request_id
, ROUNDING_FACTOR = p_PRICE_LIST_rec.rounding_factor
, SHIP_METHOD_CODE = p_PRICE_LIST_rec.ship_method_code
, START_DATE_ACTIVE = trunc(p_PRICE_LIST_rec.start_date_active)
, TERMS_ID = p_PRICE_LIST_rec.terms_id
, ASK_FOR_FLAG = 'N'
, ACTIVE_FLAG =
decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, ACTIVE_FLAG, --dhgupta for 2052900
p_PRICE_LIST_rec.active_flag)
, MOBILE_DOWNLOAD =
decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, MOBILE_DOWNLOAD,--dhgupta for 2052900
p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
, CURRENCY_HEADER_ID = p_PRICE_LIST_rec.currency_header_id
, PTE_CODE = p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
, LIST_SOURCE_CODE = p_PRICE_LIST_rec.list_source_code --Blanket Sales Order
, ORIG_SYSTEM_HEADER_REF = p_PRICE_LIST_rec.orig_system_header_ref --Blanket Sales Order
, GLOBAL_FLAG =
decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, GLOBAL_FLAG,
p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
, SOURCE_SYSTEM_CODE = p_PRICE_LIST_rec.source_system_code
, SHAREABLE_FLAG = p_PRICE_LIST_rec.shareable_flag
, SOLD_TO_ORG_ID = p_PRICE_LIST_rec.sold_to_org_id
, LOCKED_FROM_LIST_HEADER_ID =
p_PRICE_LIST_rec.locked_from_list_header_id --Pricelist locking
--added for MOAC
, ORIG_ORG_ID = p_PRICE_LIST_rec.org_id
WHERE LIST_HEADER_ID = p_PRICE_LIST_rec.list_header_id
;
update QP_LIST_HEADERS_TL set
NAME = p_PRICE_LIST_rec.name,
DESCRIPTION = p_PRICE_LIST_rec.description,
LAST_UPDATE_DATE = p_PRICE_LIST_rec.LAST_UPDATE_DATE,
LAST_UPDATED_BY = p_PRICE_LIST_rec.LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = p_PRICE_LIST_rec.LAST_UPDATE_LOGIN,
VERSION_NO = p_PRICE_LIST_rec.version_no,
SOURCE_LANG = userenv('LANG')
where LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
)
IS
--l_source_system_code varchar2(30);
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
, ASK_FOR_FLAG
, SOURCE_SYSTEM_CODE
, ACTIVE_FLAG
, MOBILE_DOWNLOAD -- mkarya for bug 1944882
, CURRENCY_HEADER_ID -- Multi-Currency SunilPandey
, PTE_CODE -- Attributes Manager Giri
, LIST_SOURCE_CODE --Blanket Sales Order
, ORIG_SYSTEM_HEADER_REF --Blanket Sales Order
, GLOBAL_FLAG --Pricing Security gtippire
, ORIG_ORG_ID -- Pricing Security sfiresto
, SHAREABLE_FLAG
, SOLD_TO_ORG_ID
, LOCKED_FROM_LIST_HEADER_ID
)
VALUES
( p_PRICE_LIST_rec.attribute1
, p_PRICE_LIST_rec.attribute10
, p_PRICE_LIST_rec.attribute11
, p_PRICE_LIST_rec.attribute12
, p_PRICE_LIST_rec.attribute13
, p_PRICE_LIST_rec.attribute14
, p_PRICE_LIST_rec.attribute15
, p_PRICE_LIST_rec.attribute2
, p_PRICE_LIST_rec.attribute3
, p_PRICE_LIST_rec.attribute4
, p_PRICE_LIST_rec.attribute5
, p_PRICE_LIST_rec.attribute6
, p_PRICE_LIST_rec.attribute7
, p_PRICE_LIST_rec.attribute8
, p_PRICE_LIST_rec.attribute9
, p_PRICE_LIST_rec.automatic_flag
, p_PRICE_LIST_rec.comments
, p_PRICE_LIST_rec.context
, p_PRICE_LIST_rec.created_by
, p_PRICE_LIST_rec.creation_date
, p_PRICE_LIST_rec.currency_code
, p_PRICE_LIST_rec.discount_lines_flag
, trunc(p_PRICE_LIST_rec.end_date_active)
, p_PRICE_LIST_rec.freight_terms_code
, p_PRICE_LIST_rec.gsa_indicator
, p_PRICE_LIST_rec.last_updated_by
, p_PRICE_LIST_rec.last_update_date
, p_PRICE_LIST_rec.last_update_login
, p_PRICE_LIST_rec.list_header_id
, p_PRICE_LIST_rec.list_type_code
, p_PRICE_LIST_rec.program_application_id
, p_PRICE_LIST_rec.program_id
, p_PRICE_LIST_rec.program_update_date
, p_PRICE_LIST_rec.prorate_flag
, p_PRICE_LIST_rec.request_id
, p_PRICE_LIST_rec.rounding_factor
, p_PRICE_LIST_rec.ship_method_code
, trunc(p_PRICE_LIST_rec.start_date_active)
, p_PRICE_LIST_rec.terms_id
, 'N' /* ask_for_flag */
-- , l_source_system_code
, p_PRICE_LIST_rec.source_system_code
, decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, 'Y',
p_PRICE_LIST_rec.active_flag)
, decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, 'N',
p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
, p_PRICE_LIST_rec.currency_header_id
, p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
, p_PRICE_LIST_rec.list_source_code -- Blanket Sales Order
--ENH Upgrade BOAPI for orig_sys...ref RAVI
, nvl(p_PRICE_LIST_rec.orig_system_header_ref,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(p_PRICE_LIST_rec.list_header_id)) -- Blanket Sales Order
, decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, 'N',
p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
--added for MOAC
, p_PRICE_LIST_rec.org_id
, p_PRICE_LIST_rec.shareable_flag
, p_PRICE_LIST_rec.sold_to_org_id
, p_PRICE_LIST_rec.locked_from_list_header_id
);
insert into QP_LIST_HEADERS_TL (
LAST_UPDATE_LOGIN,
NAME,
DESCRIPTION,
VERSION_NO,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LIST_HEADER_ID,
LANGUAGE,
SOURCE_LANG
) select
p_PRICE_LIST_rec.LAST_UPDATE_LOGIN,
p_PRICE_LIST_rec.NAME,
p_PRICE_LIST_rec.DESCRIPTION,
p_PRICE_LIST_rec.version_no,
p_PRICE_LIST_rec.CREATION_DATE,
p_PRICE_LIST_rec.CREATED_BY,
p_PRICE_LIST_rec.LAST_UPDATE_DATE,
p_PRICE_LIST_rec.LAST_UPDATED_BY,
p_PRICE_LIST_rec.LIST_HEADER_ID,
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_PRICE_LIST_rec.LIST_HEADER_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_list_header_id IN NUMBER
)
IS
cursor lines is
select list_line_id
from qp_list_lines
where list_header_id = p_list_header_id;
QP_PRICE_LIST_LINE_UTIL.DELETE_ROW(lines_rec.list_line_id);
/* delete all qualifiers which refer to this list_header_id */
delete from qp_qualifiers
where list_header_id = p_list_header_id
or ( qualifier_attr_value = to_char(p_list_header_id)
and qualifier_context = 'MODLIST'
and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4' );
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;
, '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
, ACTIVE_FLAG
, MOBILE_DOWNLOAD --mkarya for bug 1944882
, CURRENCY_HEADER_ID --Multi-Currency SunilPandey
, PTE_CODE --Attributes Manager Giri
, LIST_SOURCE_CODE --Blanket Sales Order
, ORIG_SYSTEM_HEADER_REF --Blanket Sales Order
, GLOBAL_FLAG --Pricing Security gtippire
, SOURCE_SYSTEM_CODE
, SHAREABLE_FLAG
, SOLD_TO_ORG_ID
, LOCKED_FROM_LIST_HEADER_ID
--added for MOAC
, ORIG_ORG_ID
INTO l_PRICE_LIST_rec.attribute1
, l_PRICE_LIST_rec.attribute10
, l_PRICE_LIST_rec.attribute11
, l_PRICE_LIST_rec.attribute12
, l_PRICE_LIST_rec.attribute13
, l_PRICE_LIST_rec.attribute14
, l_PRICE_LIST_rec.attribute15
, l_PRICE_LIST_rec.attribute2
, l_PRICE_LIST_rec.attribute3
, l_PRICE_LIST_rec.attribute4
, l_PRICE_LIST_rec.attribute5
, l_PRICE_LIST_rec.attribute6
, l_PRICE_LIST_rec.attribute7
, l_PRICE_LIST_rec.attribute8
, l_PRICE_LIST_rec.attribute9
, l_PRICE_LIST_rec.automatic_flag
, l_PRICE_LIST_rec.comments
, l_PRICE_LIST_rec.context
, l_PRICE_LIST_rec.created_by
, l_PRICE_LIST_rec.creation_date
, l_PRICE_LIST_rec.currency_code
, l_PRICE_LIST_rec.discount_lines_flag
, l_PRICE_LIST_rec.end_date_active
, l_PRICE_LIST_rec.freight_terms_code
, l_PRICE_LIST_rec.gsa_indicator
, l_PRICE_LIST_rec.last_updated_by
, l_PRICE_LIST_rec.last_update_date
, l_PRICE_LIST_rec.last_update_login
, l_PRICE_LIST_rec.list_header_id
, l_PRICE_LIST_rec.list_type_code
, l_PRICE_LIST_rec.program_application_id
, l_PRICE_LIST_rec.program_id
, l_PRICE_LIST_rec.program_update_date
, l_PRICE_LIST_rec.prorate_flag
, l_PRICE_LIST_rec.request_id
, l_PRICE_LIST_rec.rounding_factor
, l_PRICE_LIST_rec.ship_method_code
, l_PRICE_LIST_rec.start_date_active
, l_PRICE_LIST_rec.terms_id
, l_PRICE_LIST_rec.active_flag
, l_PRICE_LIST_rec.mobile_download -- mkarya for bug 1944882
, l_PRICE_LIST_rec.currency_header_id -- Multi-Currency SunilPandey
, l_PRICE_LIST_rec.pte_code -- Attributes Manager Giri
, l_PRICE_LIST_rec.list_source_code -- Blanket Sales Order
, l_PRICE_LIST_rec.orig_system_header_ref -- Blanket Sales Order
, l_PRICE_LIST_rec.global_flag -- Pricing Security gtippire
, l_PRICE_LIST_rec.source_system_code
, l_PRICE_LIST_rec.shareable_flag
, l_PRICE_LIST_rec.sold_to_org_id
, l_PRICE_LIST_rec.locked_from_list_header_id
--added for MOAC
, l_PRICE_LIST_rec.org_id
FROM QP_LIST_HEADERS_B
WHERE LIST_HEADER_ID = p_list_header_id
;
SELECT NAME
, DESCRIPTION
, VERSION_NO
INTO l_PRICE_LIST_rec.name
, l_PRICE_LIST_rec.description
, l_PRICE_LIST_rec.version_no
FROM QP_LIST_HEADERS_TL
WHERE LIST_HEADER_ID = p_list_header_id
AND LANGUAGE = userenv('LANG');
cursor c1 is select
NAME,
DESCRIPTION,
VERSION_NO,
decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from QP_LIST_HEADERS_TL
where LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
for update of LIST_HEADER_ID nowait;
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
, ACTIVE_FLAG -- Added by dhgupta for bug 2144903
, MOBILE_DOWNLOAD -- Added by dhgupta for bug 2144903
, CURRENCY_HEADER_ID --Multi-Currency Change SunilPandey; new change
, l_PRICE_LIST_rec.last_updated_by
, l_PRICE_LIST_rec.last_update_date
, l_PRICE_LIST_rec.last_update_login
, l_PRICE_LIST_rec.list_header_id
, l_PRICE_LIST_rec.list_type_code
, l_PRICE_LIST_rec.program_application_id
, l_PRICE_LIST_rec.program_id
, l_PRICE_LIST_rec.program_update_date
, l_PRICE_LIST_rec.prorate_flag
, l_PRICE_LIST_rec.request_id
, l_PRICE_LIST_rec.rounding_factor
, l_PRICE_LIST_rec.ship_method_code
, l_PRICE_LIST_rec.start_date_active
, l_PRICE_LIST_rec.terms_id
, l_PRICE_LIST_rec.active_flag -- Added by dhgupta for bug 2144903
, l_PRICE_LIST_rec.mobile_download -- Added by dhgupta for bug 2144903
, l_PRICE_LIST_rec.currency_header_id --Multi-Currency Change SunilPandey; new change
FOR UPDATE NOWAIT;
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
l_PRICE_LIST_rec.last_updated_by)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
l_PRICE_LIST_rec.last_update_date)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
l_PRICE_LIST_rec.last_update_login)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
l_PRICE_LIST_rec.list_header_id)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
l_PRICE_LIST_rec.list_type_code)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
l_PRICE_LIST_rec.program_application_id)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
l_PRICE_LIST_rec.program_id)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
l_PRICE_LIST_rec.program_update_date)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
l_PRICE_LIST_rec.prorate_flag)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
l_PRICE_LIST_rec.request_id)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
l_PRICE_LIST_rec.rounding_factor)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
l_PRICE_LIST_rec.ship_method_code)
AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
l_PRICE_LIST_rec.terms_id)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903
l_PRICE_LIST_rec.active_flag)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903
l_PRICE_LIST_rec.mobile_download)
-- Multi-Currency Change SunilPandey
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
l_PRICE_LIST_rec.currency_header_id)
-- Blanket Sales Order
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
l_PRICE_LIST_rec.list_source_code)
-- Bug # 5128941
--AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
-- l_PRICE_LIST_rec.orig_system_header_ref)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire
l_PRICE_LIST_rec.global_flag)
-- Blanket Pricing
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
l_PRICE_LIST_rec.source_system_code)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
l_PRICE_LIST_rec.shareable_flag)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
l_PRICE_LIST_rec.sold_to_org_id)
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
l_PRICE_LIST_rec.locked_from_list_header_id)
--added for MOAC
AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,
l_PRICE_LIST_rec.org_id)
THEN
-- Row has not changed. Set out parameter.
x_PRICE_LIST_rec := l_PRICE_LIST_rec;
FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
Select COUNT(*) into l_exist
from qp_list_headers_b h
where h.orig_system_header_ref=to_char(p_LIST_HEADER_ID);