The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE GetSelections_prod(p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2
, p_clvl_filter_rec IN clvl_filter_rec
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, x_prod_selections_tbl OUT NOCOPY prod_selections_tbl)
IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'GetSelections_prod';
OKS_AUTH_UTIL_PVT.GetSelections_prod
(p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_clvl_filter_rec => p_clvl_filter_rec
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, x_prod_selections_tbl => x_prod_selections_tbl);
END GetSelections_prod;
PROCEDURE GetSelections_other(p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2
, p_clvl_filter_rec IN clvl_filter_rec
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, x_clvl_selections_tbl OUT NOCOPY clvl_selections_tbl)
IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'GetSelections_prod';
OKS_AUTH_UTIL_PVT.GetSelections_other
(p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_clvl_filter_rec => p_clvl_filter_rec
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, x_clvl_selections_tbl => x_clvl_selections_tbl);
END GetSelections_other;
SELECT short_description,
contract_number,
contract_number_modifier,
start_date,
end_date,
currency_code
FROM OKC_K_HEADERS_V
WHERE ID = p_chr_id;
SELECT line_number,
start_date,
end_date,
cognomen,
lse_id
FROM OKC_K_LINES_V
WHERE ID = p_line_id;
SELECT description,
segment1,
concatenated_segments
FROM mtl_system_items_kfv
WHERE inventory_item_id = p_inventory_item_id AND
organization_id = p_organization_id ;
SELECT counter_group_id
FROM okx_ctr_associations_v
WHERE source_object_id = p_object1_id1;
SELECT a.template_flag
FROM cs_csi_counter_groups a
WHERE a.source_object_id = p_cle_id
AND a.source_object_code = 'CONTRACT_LINE'
AND(
(a.template_flag = 'Y') OR
(a.template_flag = 'N' AND EXISTS (select 1 from
csi_counters_b ccb, csi_counter_associations cca
where a.counter_group_id = ccb.group_id AND
ccb.counter_id = cca.counter_id))
);*/
SELECT a.template_flag
FROM cs_csi_counter_groups a,
csi_counters_b ccb, csi_counter_associations cca
WHERE a.counter_group_id = ccb.group_id AND
ccb.counter_id = cca.counter_id AND
cca.source_object_id = p_cle_id AND
cca.source_object_code = 'CONTRACT_LINE';
SELECT COUNT(temp.counter_id) cnt
FROM
(SELECT counter_id FROM CSI_COUNTER_TEMPLATE_B
UNION ALL
SELECT counter_id FROM CSI_COUNTERS_B) temp
WHERE temp.counter_id = p_object1_id1;
SELECT template_flag
-- FROM okx_counter_groups_v
FROM csi_counter_groups_v -- Bug 5284349
WHERE counter_group_id = p_ctr_grp_id;
SELECT COUNT(object_id) cnt
FROM okc_condition_headers_b
WHERE object_id = p_cle_id
AND jtot_object_code = 'OKC_K_LINE';
SELECT counter_group_id
FROM okx_ctr_associations_v
WHERE source_object_id = p_object1_id1;
SELECT COUNT(counter_group_id) cnt
FROM okc_condition_headers_b
WHERE counter_group_id = p_ctr_grp_id
AND template_yn = 'Y';
SELECT template_yn
FROM OKC_CONDITION_HEADERS_B
WHERE counter_group_id = p_ctr_grp_id;
l_create_update_flag VARCHAR2(10);
oks_auth_util_pvt.Update_Contact_Points
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
P_contact_point_rec => p_contact_point_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
PROCEDURE DELETE_CII_FOR_SUBSCRIPTION
(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_instance_id IN NUMBER
)
IS
BEGIN
OKS_AUTH_UTIL_PVT.DELETE_CII_FOR_SUBSCRIPTION
(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_instance_id
) ;
END DELETE_CII_FOR_SUBSCRIPTION ;
SELECT code
FROM okc_statuses_v
WHERE ste_code = p_ste_code
AND default_yn = 'Y';
SELECT ste_code
FROM okc_statuses_v
WHERE code = p_sts_code;
PROCEDURE update_person (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_person_tbl IN PERSON_TBL_TYPE,
p_party_object_version_number IN NUMBER,
x_profile_id OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)IS
BEGIN
OKS_AUTH_UTIL_PVT.update_person
(p_init_msg_list,
p_person_tbl,
p_party_object_version_number,
x_profile_id,
x_return_status,
x_msg_count,
x_msg_data);
PROCEDURE update_org_contact (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_org_contact_tbl IN ORG_CONTACT_TBL_TYPE,
p_relationship_tbl_type IN relationship_tbl_type,
p_cont_object_version_number IN OUT NOCOPY NUMBER,
p_rel_object_version_number IN OUT NOCOPY NUMBER,
p_party_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)IS
BEGIN
OKS_AUTH_UTIL_PVT.update_org_contact
(p_init_msg_list,
p_org_contact_tbl,
p_relationship_tbl_type,
p_cont_object_version_number,
p_rel_object_version_number,
p_party_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
PROCEDURE update_party_site (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_party_site_tbl IN PARTY_SITE_TBL_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)IS
BEGIN
OKS_AUTH_UTIL_PVT.update_party_site
(p_init_msg_list,
p_party_site_tbl,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
PROCEDURE update_cust_account_role (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_account_role_tbl IN CUST_ACCOUNT_ROLE_tbl_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
OKS_AUTH_UTIL_PVT.update_cust_account_role
(p_init_msg_list,
p_cust_account_role_tbl,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
PROCEDURE update_cust_acct_site (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_acct_site_tbl IN CUST_ACCT_SITE_TBL_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)IS
BEGIN
OKS_AUTH_UTIL_PVT.update_cust_acct_site
(p_init_msg_list,
p_cust_acct_site_tbl,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
PROCEDURE DELETE_PRICE_ADJUST_LINE(
p_api_version IN NUMBER,
p_chr_id IN NUMBER,
p_header_currency IN VARCHAR2) IS
BEGIN
-- HEADERS --
DELETE FROM OKC_PRICE_ADJUSTMENTS
WHERE ID IN
(SELECT A.ID
FROM OKC_PRICE_ADJUSTMENTS A, qp_list_headers_b B
WHERE A.CHR_ID = P_CHR_ID
AND B.LIST_HEADER_ID = A.LIST_HEADER_ID
AND B.CURRENCY_CODE <> P_HEADER_CURRENCY
AND B.CURRENCY_CODE IS NOT NULL ) ;
DELETE FROM OKC_PRICE_ADJUSTMENTS WHERE
ID IN (SELECT A.ID
FROM OKC_PRICE_ADJUSTMENTS A, QP_LIST_HEADERS_B B
WHERE A.CLE_ID IN
(SELECT ID FROM OKC_K_LINES_B WHERE
DNZ_CHR_ID = P_CHR_ID
AND LSE_ID IN (1, 12, 46, 19, 7, 8, 9, 10, 11, 13, 35, 25))
AND B.LIST_HEADER_ID = A.LIST_HEADER_ID
AND B.CURRENCY_CODE <> P_HEADER_CURRENCY
AND B.CURRENCY_CODE IS NOT NULL ) ;
SELECT COUNT(instance_id) cnt
FROM oks_subscr_header_b sub, okc_k_items_v item
WHERE sub.instance_id = item.object1_id1
AND item.cle_id = p_cle_id;