[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT lse_id,
line_number
FROM okc_k_lines_b
WHERE ID = p_line_id;
SELECT b.line_number ||
'.' ||
a.line_number line_no
FROM okc_k_lines_b a,
okc_k_lines_b b
WHERE a.ID = p_subline_id
AND a.cle_id = b.ID;
SELECT kle.lse_id,
(NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty discount
FROM okc_k_lines_b kle,
oks_k_lines_b cleb
WHERE kle.ID = cp_subline_id
AND kle.ID = cleb.cle_id
AND NVL(kle.line_list_price, 0) > NVL(cleb.toplvl_adj_price,0);
SELECT number_of_items subline_qty
FROM okc_k_items
WHERE cle_id = cp_subline_id;
SELECT kle.lse_id,
(NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty surcharge
FROM okc_k_lines_b kle,
oks_k_lines_b cleb
WHERE kle.ID = cp_subline_id
AND kle.ID = cleb.cle_id
AND NVL (kle.line_list_price, 0) < NVL (cleb.toplvl_adj_price, 0);
SELECT number_of_items subline_qty
FROM okc_k_items
WHERE cle_id = cp_subline_id;
SELECT ID,
lse_id
FROM okc_k_lines_b
WHERE cle_id = cp_cle_id;
SELECT ID,
lse_id
FROM okc_k_lines_b
WHERE cle_id = cp_cle_id;
SELECT lse_id,
start_date,
end_date,
date_terminated,
dnz_chr_id
FROM okc_k_lines_b
WHERE ID = p_line_id;
oks_contract_line_pub.update_line
(p_api_version => l_api_version,
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_klnv_rec => l_kln_rec_in,
x_klnv_rec => l_kln_rec_out,
p_validate_yn => 'N'
);
oks_contract_line_pub.update_line
(p_api_version => l_api_version,
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_klnv_rec => l_kln_rec_in,
x_klnv_rec => l_kln_rec_out,
p_validate_yn => 'N'
);
SELECT ID
FROM okc_k_lines_b
WHERE dnz_chr_id = p_chr_id
AND cle_id IS NULL;
SELECT ID,
object_version_number
FROM okc_k_headers_all_b
WHERE ID = p_id;
SELECT ID,
object_version_number
FROM okc_k_lines_b
WHERE ID = p_id;
SELECT ID,
object_version_number
FROM oks_k_headers_b
WHERE chr_id = p_id;
SELECT ID,
object_version_number
FROM oks_k_lines_b
WHERE cle_id = p_id;
SELECT dnz_chr_id,
cle_id
FROM okc_k_lines_b
WHERE ID = p_line_id;
SELECT 'x'
FROM okc_k_lines_b kl,
okc_k_items ki,
oks_subscr_header_b sh
WHERE kl.ID = p_subline_id
AND ki.cle_id = kl.ID
AND sh.instance_id = ki.object1_id1;
SELECT cle_id,
lse_id,
dnz_chr_id
FROM okc_k_lines_b
WHERE ID = p_line_id;
SELECT object1_id1,
object1_id2
FROM okc_k_items
WHERE cle_id = c_cle_id;
SELECT inventory_item_id
FROM csi_item_instances
WHERE instance_id = c_instance_id;
SELECT inv_organization_id
FROM okc_k_headers_all_b
WHERE ID = c_chr_id;
SELECT concatenated_segments,
description
FROM mtl_system_items_kfv
WHERE inventory_item_id = c_item_id
AND organization_id = c_inv_org_id;
SELECT SUM (price_negotiated) amount
FROM okc_k_lines_b
WHERE cle_id = p_line_id
AND chr_id IS NULL
AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
AND date_cancelled IS NULL; -- bug 4870602
SELECT SUM (price_negotiated) amount
FROM okc_k_lines_b
WHERE chr_id = p_chr_id
AND cle_id IS NULL
AND date_cancelled IS NULL; -- bug 4870602
UPDATE oks_qualifiers
SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = SYSDATE
WHERE qualifier_attr_value = TO_CHAR (p_from_fk_id);
arp_message.set_name ('AR', 'AR_ROWS_UPDATED');
SELECT DISTINCT customer_merge_header_id,
qualifier_id,
qualifier_attr_value
FROM oks_qualifiers yt,
ra_customer_merges m
WHERE (yt.qualifier_attr_value = m.duplicate_site_id)
AND m.process_flag = 'N'
AND m.request_id = req_id
AND m.set_number = set_num;
INSERT INTO hz_customer_merge_log
(merge_log_id,
table_name,
merge_header_id,
primary_key_id1,
vchar_col1_orig,
vchar_col1_new,
action_flag,
request_id,
created_by,
creation_date,
last_update_login,
last_update_date,
last_updated_by
)
VALUES (hz_customer_merge_log_s.NEXTVAL,
'OKS_QUALIFIERS',
merge_header_id_list (i),
primary_key_id1_list (i),
vchar_col1_orig_list (i),
vchar_col1_new_list (i),
'U',
req_id,
hz_utility_pub.created_by,
hz_utility_pub.creation_date,
hz_utility_pub.last_update_login,
hz_utility_pub.last_update_date,
hz_utility_pub.last_updated_by
);
UPDATE oks_qualifiers yt
SET qualifier_attr_value = vchar_col1_new_list (i),
last_update_date = SYSDATE,
last_updated_by = arp_standard.PROFILE.user_id,
last_update_login = arp_standard.PROFILE.last_update_login,
request_id = req_id
WHERE qualifier_id = primary_key_id1_list (i);
arp_message.set_name ('AR', 'AR_ROWS_UPDATED');
SELECT currency_code
FROM okc_k_headers_all_b
WHERE ID = p_hdr_id;
SELECT ID,
start_date,
end_date,
lse_id,
dnz_chr_id,
price_negotiated,
price_unit,
price_unit_percent,
price_list_line_id,
price_list_id,
line_list_price,
item_to_price_yn,
pricing_date,
price_basis_yn,
object_version_number
FROM okc_k_lines_b
WHERE ID = p_cle_id
AND lse_id = 46;
SELECT ID,
osh_id,
dnz_chr_id,
dnz_cle_id,
linked_flag,
seq_no,
om_interface_date,
amount,
start_date,
end_date,
quantity,
uom_code,
order_header_id,
order_line_id,
object_version_number
FROM oks_subscr_elements
WHERE dnz_cle_id = p_line_id;
oks_contract_line_pub.update_line (p_api_version => l_api_version,
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_klnv_rec => l_kln_rec_in,
x_klnv_rec => l_kln_rec_out,
p_validate_yn => 'N'
);
'338:Update line details at Calc Subscription'
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
'339:Update Contract line ERROR at Calc Subscription'
);
oks_subscr_elems_pub.update_row (p_api_version => l_api_version,
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_scev_rec => l_scev_rec_in,
x_scev_rec => l_scev_rec_out
);
SELECT currency_code
FROM okc_k_headers_all_b
WHERE ID = p_hdr_id;
SELECT ID,
start_date,
end_date,
cle_id,
dnz_chr_id,
lse_id,
price_negotiated,
price_unit,
price_unit_percent,
price_list_line_id,
price_list_id,
line_list_price,
item_to_price_yn,
pricing_date,
price_basis_yn
FROM okc_k_lines_b
WHERE ID = p_cle_id
AND lse_id IN (7, 9, 25);
SELECT price_uom
FROM oks_k_lines_b
WHERE cle_id = p_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE ID = p_cle_id;
SELECT number_of_items
FROM okc_k_items_v
WHERE cle_id = p_subline_id;
oks_contract_line_pub.update_line (p_api_version => l_api_version,
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_klnv_rec => l_kln_rec_in,
x_klnv_rec => l_kln_rec_out,
p_validate_yn => 'N'
);
'360:Update line details at Calc Subscription'
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
SELECT ID,
start_date,
end_date,
lse_id
FROM okc_k_lines_b
WHERE cle_id = p_cle_id
AND lse_id IN (7, 9, 25)
AND date_cancelled IS NULL --[llc]
AND date_terminated IS NULL -- bug 5504157
ORDER BY line_number;
oks_contract_line_pub.update_line
(p_api_version => l_api_version,
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_klnv_rec => l_kln_rec_in,
x_klnv_rec => l_kln_rec_out,
p_validate_yn => 'N'
);
'368:Update line details at Calc Subscription'
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
select id,
start_date,
end_date,
lse_id
from okc_k_lines_b
where cle_id = p_cle_id
and lse_id in (7, 9, 25)
and date_cancelled is null --[llc]
and date_terminated is null -- bug 5504157
order by line_number;
g_req_line_tbl_blk.delete;
g_req_line_detail_tbl_blk.delete;
g_req_related_lines_tbl_blk.delete;
g_req_qual_tbl_blk.delete;
g_req_line_attr_tbl_blk.delete;
g_req_line_detail_qual_tbl_blk.delete;
g_req_line_detail_attr_tbl_blk.delete;
gx_req_line_tbl.delete;
gx_req_qual_tbl.delete;
gx_req_line_attr_tbl.delete;
gx_req_line_detail_tbl.delete;
gx_req_line_detail_qual_tbl.delete;
gx_req_line_detail_attr_tbl.delete;
gx_req_related_lines_tbl.delete;
fnd_log.string (fnd_log.level_statement, g_module || l_api_name,'qp_call: l_control_rec.temp_table_insert_flag : '|| l_control_rec.temp_table_insert_flag
);
fnd_log.string (fnd_log.level_statement, g_module || l_api_name,'qp_call: g_req_line_tbl_blk('|| p ||').updated_adjusted_unit_price : '|| g_req_line_tbl_blk(p).updated_adjusted_unit_price
);
fnd_log.string (fnd_log.level_statement, g_module || l_api_name,'qp_call: g_req_line_detail_tbl_blk('|| p ||').updated_flag : '|| g_req_line_detail_tbl_blk(p).updated_flag
);
fnd_log.string (fnd_log.level_statement, g_module || l_api_name,'qp_call: gx_req_line_tbl('|| p ||').updated_adjusted_unit_price : '|| gx_req_line_tbl(p).updated_adjusted_unit_price
);
fnd_log.string (fnd_log.level_statement, g_module || l_api_name,'qp_call: gx_req_line_detail_tbl('|| p ||').updated_flag : '|| gx_req_line_detail_tbl(p).updated_flag
);
oks_contract_line_pub.update_line
(p_api_version => l_api_version,
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_klnv_rec => l_kln_rec_in,
x_klnv_rec => l_kln_rec_out,
p_validate_yn => 'N'
);
'368:update line details at calc subscription'
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
SELECT ID,
start_date,
end_date,
lse_id
FROM okc_k_lines_b
WHERE chr_id = p_chr_id
AND lse_id IN (1, 14, 19, 46)
AND date_cancelled IS NULL --[llc] bug 4653406
AND date_terminated IS NULL -- bug 5504157
ORDER BY line_number;
okc_contract_pub.update_contract_header
(p_api_version => l_api_version,
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_restricted_update => okc_api.g_false,
p_chrv_rec => l_chrv_rec_in,
x_chrv_rec => l_chrv_rec_out
);
g_pricing_status_tbl.DELETE;
okc_contract_pub.update_contract_header
(p_api_version => l_api_version,
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_restricted_update => okc_api.g_false,
p_chrv_rec => l_chrv_rec_in,
x_chrv_rec => l_chrv_rec_out
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
okc_contract_pub.update_contract_header
(p_api_version => l_api_version,
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_restricted_update => okc_api.g_false,
p_chrv_rec => l_chrv_rec_in,
x_chrv_rec => l_chrv_rec_out
);
okc_contract_pub.update_contract_header
(p_api_version => l_api_version,
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_restricted_update => okc_api.g_false,
p_chrv_rec => l_chrv_rec_in,
x_chrv_rec => l_chrv_rec_out
);
okc_contract_pub.update_contract_line
(p_api_version => l_api_version,
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_clev_rec => l_clev_rec_in,
x_clev_rec => l_clev_rec_out
);
okc_contract_pub.update_contract_header
(p_api_version => l_api_version,
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_restricted_update => okc_api.g_false,
p_chrv_rec => l_chrv_rec_in,
x_chrv_rec => l_chrv_rec_out
);