[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM okc_k_lines_v clev
WHERE clev.id = l_line_id
AND clev.config_item_type = 'TOP_MODEL_LINE'
AND clev.config_header_id = l_config_hdr_id
AND clev.config_revision_number = l_config_rev_nbr;
SELECT config_hdr_id,
config_rev_nbr ,
config_item_id ,
parent_config_item_id ,
inventory_item_id ,
organization_id ,
component_code ,
quantity ,
uom_code ,
'INSERT' -- operation
FROM okx_config_details_v czdv
WHERE czdv.config_hdr_id = l_config_hdr_id
AND czdv.config_rev_nbr = l_config_rev_nbr
AND NOT EXISTS (
SELECT 'x'
FROM okc_k_lines_v clev,
okc_k_items_v cimv
WHERE clev.id = cimv.cle_id
AND clev.dnz_chr_id = l_dnz_chr_id
AND clev.config_header_id = czdv.config_hdr_id
AND clev.config_revision_number = czdv.config_rev_nbr
AND cimv.object1_id1 = czdv.inventory_item_id)
ORDER BY bom_sort_order; -- Bug 2654009
SELECT cleb.id
FROM okc_k_lines_b cleb
WHERE cleb.dnz_chr_id = l_dnz_chr_id
AND cleb.id <> l_top_model_line_id
AND cleb.config_header_id = l_config_hdr_id
AND cleb.config_revision_number = l_config_rev_nbr;
SELECT cleb.id id,
'P' pi_bpi,
cim.number_of_items qty,
cim.uom_code uom_code,
cleb.currency_code currency_code,
cim.jtot_object1_code object_code,
cim.object1_id1 id1,
cim.object1_id2 id2,
cleb.price_list_id price_list_id,
cleb.dnz_chr_id dnz_chr_id,
cleb.pricing_date pricing_date -- Added for Bug 2393302
FROM okc_k_lines_b cleb,
okc_k_items cim
WHERE cleb.dnz_chr_id = l_dnz_chr_id
AND cleb.config_header_id = l_config_hdr_id
AND cleb.config_revision_number = l_config_rev_nbr
AND cleb.id = cim.cle_id
AND cleb.config_item_type <> 'TOP_MODEL_LINE';
SELECT cleb.id top_model_id,
cleb.config_top_model_line_id top_model_line_id
FROM okc_k_lines_b cleb
WHERE cleb.dnz_chr_id = l_dnz_chr_id
AND cleb.config_header_id = l_config_hdr_id
AND cleb.config_revision_number = l_config_rev_nbr
AND cleb.config_item_type = 'TOP_MODEL_LINE';
SELECT cleb.cle_id,
cleb.chr_id,
cleb.line_number,
cleb.display_sequence
FROM okc_k_lines_b cleb
WHERE cleb.id = l_line_id;
SELECT chrv.pricing_date
FROM okc_k_headers_b chrv
WHERE chrv.id = l_dnz_chr_id;
SELECT clev.price_list_id,clev.pricing_date
FROM okc_k_lines_b clev
WHERE clev.id = l_line_id;
SELECT clev.price_list_id
FROM okc_k_lines_b clev
WHERE clev.id = l_line_id;
OKC_DEBUG.log('30: Before delete old revision....');
OKC_CONTRACT_PUB.delete_contract_line (
p_api_version => l_api_version_number,
p_init_msg_list => l_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => l_line_id );
OKC_DEBUG.log('40: After delete old revision...'||x_return_status);
OKC_DEBUG.log('200: Before update contract top model line...');
OKC_CONTRACT_PUB.update_contract_line
( p_api_version => l_api_version_number,
p_init_msg_list => l_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_clev_rec => l_clev_rec,
x_clev_rec => x_clev_rec);
OKC_DEBUG.log('210: Updated contract Top Model Line..'||x_return_status);
l_cle_price_tbl.DELETE(i);
OKC_DEBUG.log('5700: Before Update Pricing Info ....');
OKC_CONTRACT_PUB.update_contract_line
( p_api_version => l_api_version_number,
p_init_msg_list => l_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_clev_rec => l_clev_rec,
x_clev_rec => x_clev_rec);
OKC_DEBUG.log('5800: Updated Pricing Info...'||x_return_status);
OKC_DEBUG.log('5910: Before Update Top Model Pricing Info ....');
OKC_CONTRACT_PUB.update_contract_line
( p_api_version => l_api_version_number,
p_init_msg_list => l_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_clev_rec => l_clev_rec,
x_clev_rec => x_clev_rec);
OKC_DEBUG.log('5920: Updated Top Model Pricing Info...'||x_return_status);
SELECT application_id,
buy_or_sell
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT count(clev.id)
FROM okc_k_lines_b clev
WHERE clev.dnz_chr_id = p_chr_id
AND clev.config_item_type = 'TOP_MODEL_LINE'
AND ( NVL(clev.config_valid_yn,'Y') = 'N'
OR NVL(clev.config_complete_yn,'Y') = 'N');
SELECT clev.id,
clev.config_valid_yn,
clev.config_complete_yn
FROM okc_k_lines_b clev
WHERE clev.dnz_chr_id = p_chr_id
AND clev.config_item_type = 'TOP_MODEL_LINE'
AND ( NVL(clev.config_valid_yn,'Y') = 'N'
OR NVL(clev.config_complete_yn,'Y') = 'N');
SELECT TO_NUMBER(SUBSTR(p_config_session_key,1,
INSTR( p_config_session_key, '-' ) - 1 )) id,
CZ_ATP_CALLBACK_UTIL.inv_item_id_from_item_key(item_key) item_id,
quantity quantity,
uom_code uom_code,
SUBSTR(item_key, 1,INSTR( item_key, ':' ,1)-1) comp_code
FROM okx_config_pricing_v
WHERE configurator_session_key = p_config_session_key
AND list_price IS NULL
AND selling_price IS NULL;
SELECT dnz_chr_id,
price_list_id
FROM okc_k_lines_b
WHERE id = p_top_model_line_id;
SELECT currency_code,
authoring_org_id,
price_list_id -- If user already selects one
FROM okc_k_headers_v
WHERE id = p_chr_id;
l_cle_price_tbl.DELETE(i);
UPDATE cz_pricing_structures
SET selling_price = l_unit_sell_price,
list_price = l_cle_price_tbl(i).list_price
WHERE configurator_session_key = p_config_session_key
AND CZ_ATP_CALLBACK_UTIL.inv_item_id_from_item_key(item_key) =
l_cle_price_tbl(i).id1 ;
UPDATE okx_config_pricing_v
SET msg_data = l_calc_price_error
WHERE configurator_session_key = p_config_session_key;
SELECT clev.id,
clev.config_header_id,
clev.config_revision_number
FROM okc_k_lines_v clev
WHERE clev.dnz_chr_id = p_dnz_chr_id
AND clev.config_item_type = 'TOP_MODEL_LINE';
UPDATE okc_k_lines_b
SET config_top_model_line_id = l_top_model_line_id,
config_header_id = x_cfg_hdr_id,
config_revision_number = x_cfg_rev_nbr
WHERE dnz_chr_id = p_dnz_chr_id
AND config_header_id = l_cfg_hdr_id
AND config_revision_number = l_cfg_rev_nbr ;
UPDATE okc_k_lines_b
SET config_item_id = x_new_item_id_tbl(i)
WHERE
dnz_chr_id = p_dnz_chr_id
AND config_header_id = x_cfg_hdr_id
AND config_revision_number = x_cfg_rev_nbr
AND config_item_id = x_orig_item_id_tbl(i)
AND config_item_type IN ('CONFIG','TOP_BASE_LINE');