[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT Start_Date, End_Date From OKC_K_LINES_V
WHERE id = p_cle_id;
Select Id From OKC_K_PARTY_ROLES_B
Where dnz_chr_id = p_chrid
And cle_id Is Null
And rle_code = p_rle_code;
Cursor l_lparty_csr Is Select Id From OKC_K_PARTY_ROLES_B
Where dnz_chr_id = p_chrid
And cle_id = p_cleid
And rle_code = p_rle_code;
Select ID Into V_ID From OKC_RULES_V
Where rgp_id = p_rgp_id
And Rule_information_category = p_rule_type;
SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V
WHERE Dnz_CHR_ID = p_chr_id
And cle_id is null ;
SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE CLE_ID = p_cle_id;
Select id
From okc_std_articles_v
Where name = p_name;
Select sav_release
From okc_std_art_versions_v
Where sae_id = p_sae_id;
SELECT length(p_cc_num_stripped)
INTO l_len_credit_card_num
FROM dual;
SELECT to_number(substr(p_cc_num_stripped,i,1))
INTO l_stripped_num_table(i)
FROM dual;
SELECT dnz_chr_id, start_date
FROM okc_k_lines_b
WHERE id = p_cle_id;
l_rgpv_tbl_in.delete;
l_rgpv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rgpv_tbl_in(1).last_update_date := SYSDATE;
SELECT Party_Id From OKX_CUST_SITE_USES_V
WHERE ID1 = p_id;
SELECT Party_Id From OKX_CUST_CONTACTS_V
WHERE Id1 = p_contactid And id2 = '#';
SELECT hzr.object_id, hzr.party_id
--NPALEPU
--18-JUN-2005,08-AUG-2005
--TCA Project
--Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
--Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
/* FROM ra_hcontacts rah,hz_party_relationships hzr
WHERE rah.contact_id = p_contact_id
AND rah.party_relationship_id = hzr.party_relationship_id; */
l_ctcv_tbl_in.DELETE;
OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contacts :: Insert contact status: '||l_return_status );
l_cgcv_tbl_in.DELETE;
l_cgcv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_cgcv_tbl_in(1).last_update_date := OKC_API.G_MISS_DATE;
l_cgcv_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;
l_cpsv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_cpsv_tbl_in(1).last_update_date := OKC_API.G_MISS_DATE;
l_cpsv_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;
SELECT Chr_id
FROM OKC_K_REL_OBJS
WHERE OBJECT1_ID1 = P_Object_id
AND jtot_object1_code = p_jtf_id;
SELECT Chr_id
FROM OKC_K_REL_OBJS
WHERE OBJECT1_ID1 = P_Object_id
AND jtot_object1_code = p_jtf_id
AND rty_code = 'CONTRACTWARRANTYORDER';
SELECT Id Chr_Id
FROM OKC_K_HEADERS_V
WHERE Attribute1 = p_Object_Id
AND End_date = p_EndDate ;
SELECT a.id1
FROM okx_cust_sites_v a, okx_cust_contacts_v b
WHERE b.id1 = p_contact_id
AND a.id1 = b.cust_acct_site_id;
SELECT contact_point_id
FROM okx_contact_points_v
WHERE contact_point_type = 'EMAIL'
AND primary_flag = 'Y'
AND owner_table_id = p_contact_id;
SELECT contact_point_id
FROM hz_contact_points
WHERE contact_point_type = 'PHONE'
AND NVL( phone_line_type, 'GEN' ) = 'GEN'
AND primary_flag = 'Y'
AND owner_table_id = p_contact_id;
SELECT contact_point_id
FROM hz_contact_points
WHERE contact_point_type = 'PHONE'
AND phone_line_type = 'FAX'
AND owner_table_id = p_contact_id;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE ;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
OKS_SALES_CREDIT_PUB.Insert_Sales_Credit
(
p_api_version => 1.0,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_scrv_tbl => l_scrv_tbl_in,
x_scrv_tbl => l_scrv_tbl_out
);
OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Sales_Credits :: Insert sales credit status:'|| l_return_status);
Select KL.Id Cle_Id
From OKC_K_LINES_V KL
,OKC_K_ITEMS_V KI
Where KL.dnz_chr_id = p_ChrId
And KL.lse_id In (14, 19)
And KL.Id = KI.cle_Id
And KI.Object1_Id1 = p_InvServiceId
-- And KL.StartDate >= p_StartDate
And KL.End_Date = p_EndDate;
Select Start_Date, End_Date ,
Authoring_Org_Id From OKC_K_HEADERS_V
Where id = p_chr_id;
Select PRICED_YN
From okc_line_styles_B
Where ID = P_LSE_ID;
SELECT ccg.COUNTER_GROUP_ID COUNTER_GROUP_ID
FROM cs_csi_counter_groups ccg,
csi_counters_b ccb,
csi_counter_associations cca
WHERE ccg.template_flag = 'N'
AND ccg.counter_group_id = ccb.group_id
AND ccb.counter_id = cca.counter_id
AND cca.source_object_code = 'CP'
AND cca.source_object_id = p_cp_id;
SELECT counter_id , usage_item_id
FROM csi_counters_b
WHERE group_id = p_counter_group_id
AND usage_item_id IS NOT NULL
ORDER BY usage_item_id;
x_counter_tbl.delete;
l_chrv_tbl_in(1).deleted_yn := 'N';
l_chrv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_chrv_tbl_in(1).last_update_date := SYSDATE;
Select NVL(Max(TO_NUMBER(line_number)),0) +1
From okc_k_lines_b
Where dnz_chr_id = p_chr_id
And lse_id in (1,12,14,19,46);
Select NVL(Max(TO_NUMBER(line_number)),0) +1
From okc_k_lines_b
Where dnz_chr_id = p_chr_id
And cle_id = p_cle_id
And lse_id in (35,7,8,9,10,11,13,18,25);
Select Counter_Group_id
From OKX_CTR_ASSOCIATIONS_V
Where Source_Object_Id = p_id;
Select cust_account_id from OKX_CUST_SITE_USES_V
where id1 = p_billto and id2 = '#';
Select hzr.object_id, hzr.party_id
--NPALEPU
--18-JUN-2005,08-AUG-2005
--TCA Project
--Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V
--Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
/* From ra_hcontacts rah, hz_party_relationships hzr
Where rah.contact_id = p_contact_id
And rah.party_relationship_id = hzr.party_relationship_id; */
SELECT id,scs_code
FROM okc_k_headers_b
WHERE id = p_header_id;
SELECT coverage_template_id
FROM okx_system_items_v
WHERE id1 = p_srv_id
AND organization_id = p_orgid;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
l_rulv_tbl_in(1).last_update_date := SYSDATE;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.delete;
l_rulv_tbl_in.delete;
Select MTL.SERVICE_ITEM_FLAG
,MTL.USAGE_ITEM_FLAG
From OKX_SYSTEM_ITEMS_V MTL
Where MTL.id1 = p_Inventory_id
And MTL.Organization_id = p_organization_id;
SELECT id, lse_id
FROM okc_k_lines_b
WHERE id = p_line_id;
SELECT rule_information10
FROM okc_rules_b rul, okc_rule_groups_b rg
WHERE rul.rgp_id = rg.id AND rg.cle_id = p_line_id
AND rule_information_category = 'QRE';*/
SELECT usage_type
FROM oks_k_lines_b
WHERE cle_id = p_line_id;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in.DELETE;
l_rulv_tbl_in.DELETE;
Select MTL.Name
,MTL.Description
,MTL.Primary_UOM_Code
,MTL.Service_starting_delay
From OKX_SYSTEM_ITEMS_V MTL
Where MTL.id1 = p_Inventory_id
And MTL.Organization_id = okc_context.get_okc_organization_id;
Select ks.averaging_interval
, ks.uom_quantified
--, ks.rule_information3
, ks.minimum_quantity
, ks.default_quantity
, ks.amcv_flag
, ks.fixed_quantity
, ks.level_yn
, ks.usage_type
--, ks.rule_information10
, ks.base_reading
From oks_k_lines_b ks,
okc_k_lines_v kc
Where ks.cle_id = kc.id
And kc.lse_id = 12;
Select instance_id from oks_subscr_header_b
Where cle_id = p_line_id
And dnz_chr_id = p_hdr_id;
Update Okc_k_headers_b
Set Estimated_amount = (Select nvl(sum(nvl(price_negotiated,0)),0)
from Okc_k_lines_b
Where dnz_chr_id = l_contract_header_id
and lse_id in (9,25,46))
Where id = l_contract_header_id ;