The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MEANING FROM FND_LOOKUPS
WHERE LOOKUP_CODE = P_LOOKUP_CODE
AND LOOKUP_TYPE = P_LOOKUP_TYPE;
SELECT TRUNC(MIN(BCL.DATE_BILLED_FROM)) DATE_BILLED_FROM
, TRUNC(MAX(BCL.DATE_BILLED_TO)) DATE_BILLED_TO
FROM OKS_BILL_CONT_LINES BCL
WHERE BCL.CLE_ID = P_TOP_LINE_ID ;
SELECT TRUNC(START_DATE) START_DATE
, TRUNC(END_DATE) END_DATE
FROM OKC_K_HEADERS_B
WHERE ID = P_HDR_ID ;
SELECT TRUNC(MIN(BSL.DATE_BILLED_FROM)) DATE_BILLED_FROM
, TRUNC(MAX(BSL.DATE_BILLED_TO)) DATE_BILLED_TO
FROM OKS_BILL_SUB_LINES BSL
WHERE BSL.CLE_ID = P_SUB_LINE_ID;
SELECT TRUNC(START_DATE) START_DATE
, TRUNC(END_DATE) END_DATE
FROM OKC_K_LINES_B
WHERE ID = P_TOP_LINE_ID;
PROCEDURE update_line
(
p_clev_tbl IN okc_contract_pub.clev_tbl_type
,x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type
,x_return_status OUT NOCOPY Varchar2
,x_msg_count OUT NOCOPY Number
,x_msg_data OUT NOCOPY Varchar2
)
IS
l_api_version CONSTANT NUMBER := 1.0;
okc_contract_pub.update_contract_line
(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_restricted_update => 'F',
p_clev_tbl => l_clev_tbl_in,
x_clev_tbl => l_clev_tbl_out
);
END update_line;
SELECT ID
FROM OKC_K_PARTY_ROLES_B
WHERE DNZ_CHR_ID = p_dnz_chr_id
AND CLE_ID = P_Cle_Id
AND OBJECT1_ID1 = p_party_id ; -- Bug 5219132
SELECT party_id
FROM okx_customer_accounts_v
WHERE id1=p_can_id;
SELECT rle_code,OBJECT1_ID1,object1_id2,JTOT_OBJECT1_CODE
FROM OKC_K_PARTY_ROLES_B
WHERE object1_id1= l_party_id
and dnz_chr_id = p_dnz_chr_id;
Select SCS_CODE from OKC_K_HEADERS_B
where id = p_dnz_chr_id;
SELECT ID
FROM OKC_CONTACTS
WHERE DNZ_CHR_ID = p_dnz_chr_id
AND CPL_ID = P_CPL_Id;
SELECT ID
FROM OKC_CONTACTS
WHERE DNZ_CHR_ID = p_dnz_chr_id
AND CPL_ID = P_CPL_Id
AND JTOT_OBJECT1_CODE =p_jtot_code
AND cro_code =p_cro_code ;
select start_date,
end_date,
inv_organization_id,
authoring_org_id
from okc_k_headers_v
where id = p_chr_id;
select start_date,
end_date,
lse_id
from okc_k_lines_b
where id = p_cle_id;
Select id
From OKC_K_LINES_V
Where cle_id = p_cle_id
and lse_id in (2,13,15,20);
select
id,
inv_rule_id,
cust_acct_id,
bill_to_site_use_id,
ship_to_site_use_id,
cust_po_number,
cust_po_number_req_yn,
-- BANK ACCOUNT CONSOLIDATION --
payment_instruction_type,
authoring_org_id,
-- BANK ACCOUNT CONSOLIDATION --
price_list_id, -- hkamdar 8/23/05 R12 Partial Period
currency_code -- gchadha for Partial Period
from okc_k_headers_b
where id = p_chr_id;
select
id,
inv_rule_id,
cust_acct_id,
lse_id,
price_negotiated,
bill_to_site_use_id,
ship_to_site_use_id
from okc_k_lines_b
where id = p_cle_id;
select
id,
acct_rule_id, --for ARL rule
tax_status,
--Fixed bug#4026268 --gbgupta
-- tax_code,
tax_exemption_id,
payment_type, --for payment method
-- Bank Account Consolidation --
/* cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code, */
trxn_extension_id,
-- Bank Account Consolidation --
commitment_id,
grace_duration,
grace_period, --for payment method
object_version_number,
price_uom, -- hkamdar 8/23/05 R12 Partial Period
-- Ebtax --
exempt_certificate_number,
exempt_reason_code,
tax_classification_code
-- Ebtax --
from oks_k_headers_v
where chr_id = p_chr_id;
select
id,
acct_rule_id, --for ARL rule
tax_amount,
tax_inclusive_yn,
tax_status,
tax_code,
tax_exemption_id,
payment_type, --for payment method
-- Bank Account Consolidation --
/*cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code, */
trxn_extension_id,
-- Bank Account Consolidation --
commitment_id,
grace_duration,
grace_period, --for payment method
object_version_number,
invoice_text,
--Fix for Bug# 3542273
usage_type,
--Fix for Bug# 3542273
-- Ebtax --
tax_classification_code,
exempt_certificate_number,
exempt_reason_code,
standard_cov_yn -- Issue#14 Bug 4566346
-- Ebtax --
from oks_k_lines_v
where cle_id = p_cle_id;
select cust_account_id
from okx_cust_site_uses_v
where id1=p_object1_id1;
select cust_acct_id
from okc_k_lines_b
where id =p_cle_id;
select id, price_negotiated, cle_id, price_unit
from okc_k_lines_v
where lse_id in (7,8,9,10,11,13,18,25,35)
and date_cancelled is NULL -- new
and cle_id = l_cle_id;
select distinct cust_account_id
from okx_cust_site_uses_v
where id1 In
(
select bill_to_address_id1
from oks_billing_profiles_b
where OWNED_PARTY_ID1 IS NOT NULL
and id = l_billing_profile_id)
AND site_use_code = 'BILL_TO'
AND org_id = l_org_id;
select bill_to_address_id1
from oks_billing_profiles_b
where id = l_billing_profile_id
AND OWNED_PARTY_ID1 IS NOT NULL;
select account_object1_id1
,invoice_object1_id1
from oks_billing_profiles_b
where id = l_billing_profile_id;
select distinct incident_id,
contract_number,
contract_service_id,
incident_number
from cs_incidents_all_b cs , okc_k_lines_b line
where cs.contract_service_id = p_cle_id
and cs.contract_id =p_chr_id
and cs.contract_id =line.dnz_chr_id
and line.cle_id = p_cle_id
and line.lse_id in ('18','9','25');
Select id
,Percent
,Ctc_id
,Sales_credit_type_id1
,Sales_credit_type_id2
--new
,sales_group_id
--new
From OKS_K_SALES_CREDITS_V
Where chr_id = p_header_id
And cle_id Is NULL;
Select count(*),id
From OKS_K_SALES_CREDITS_V
Where chr_id = p_header_id
And cle_id =p_line_id
group by id;
select line_number
from okc_k_lines_b
where id = p_cle_id;
Select cust_acct_id
from okx_cust_contacts_v
where party_id in
(select object1_id1 from okc_k_party_roles_b
where dnz_chr_id = p_chr_id--:PARAMETER.OKSDEFLT_CHR_ID
and chr_id = p_chr_id--:PARAMETER.OKSDEFLT_CHR_ID
and cle_id IS NULL
and rle_code <> 'VENDOR'
)
and status = 'A'
and id1 = p_billto_id;
SELECT DISTINCT b.id1, a.party_id
FROM okx_cust_site_uses_v a, okx_customer_accounts_v b
WHERE a.id1 = l_object1_id1
AND b.id1 = a.cust_account_id
AND a.site_use_code = use;
SELECT id, cle_id, dnz_chr_id
FROM OKC_K_PARTY_ROLES_B
WHERE DNZ_CHR_ID = p_dnz_chr_id
AND CLE_ID = P_Cle_Id;
Select cust_acct_id
FROM OKX_CUST_CONTACTS_V
WHERE ROLE_TYPE = 'CONTACT'
AND ID1 = l_contact_id ;
SELECT id
FROM OKC_K_PARTY_ROLES_B
WHERE DNZ_CHR_ID = p_chr_id
AND CLE_ID = p_cle_id
AND OBJECT1_ID1 =l_party_id;
Select Party_id,name
from okx_customer_accounts_v
where id1= p_cust_acct_id;
select * from okc_contacts
where cpl_id = p_cpl_id
AND JTOT_OBJECT1_CODE <> p_jtot_object_code
AND DNZ_CHR_ID = p_chr_id;
Select line_number
from okc_k_lines_v
where cle_id =p_cle_id
and dnz_chr_id = p_chr_id;
select
cust_po_number,
cust_po_number_req_yn,
payment_instruction_type,
trxn_extension_id
from oks_k_lines_b oks, okc_k_lines_b okc
where okc.id = p_cle_id
and oks.cle_id = okc.id;
Select party_id
FROM HZ_CUST_ACCOUNTS CA
WHERE CA.cust_account_ID = p_cust_acct_id;
Select locked_price_list_id ,
locked_price_list_line_id
FROM OKS_k_LINES_B
WHERE dnz_chr_id = p_chr_id
and cle_id = p_cle_id ;
Select ex.exempt_certificate_number CUSTOMER_EXCEPTION_NUMBER, nvl(lk.lookup_code,ex.exempt_reason_code) Description
from zx_exemptions ex, fnd_lookups lk
where ex.tax_exemption_id = p_tax_exemption_id
and lk.lookup_type(+) = 'ZX_EXEMPTION_REASON_CODE'
and lk.lookup_code(+) = ex.exempt_reason_code;
Select nvl(sum(nvl(tax_amount,0)),0) tax_amount
from okc_k_lines_b cle, oks_k_lines_b sle
where cle.cle_id = p_cle_id
and cle.lse_id in (7,8,9,10,11,13,25,35)
and cle.id = sle.cle_id
and cle.dnz_chr_id = sle.dnz_chr_id
and cle.date_cancelled is null;
Select nvl(sum(nvl(tax_amount,0)),0) tax_amount
from okc_k_lines_b cle, oks_k_lines_b sle
where cle.chr_id = p_chr_id
and cle.id = sle.cle_id
and cle.dnz_chr_id = sle.dnz_chr_id
and cle.date_cancelled is null;
-- Updated or not.
-- END GCHADHA --
-- IKON ENHANCEMENT --
----new
l_sc_index NUMBER;
l_klnv_tbl_in.DELETE;
l_clev_tbl_in.DELETE;
l_kslnv_tbl_in.DELETE;-- /* Added for 7387293 */
select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;
p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
p_token1 => 'Line No ',
p_token1_value => l_line_number);
-- OKS_K_HEADERS_B table should be update or not
-- If l_oks_header_id is 0 then
-- OKS_K_HEADERS_B should not be updated.
-- Else should be Updated.
-- Used only with l_header_bca variable.
l_oks_header_id :=0;
-- Update the BTO rule at lines leve with header
-- level Customer account if the accounts are
-- not same.
-- Delete all contacts which are not
-- billing contact and are belonging to
-- ship to account Party Role
-- CASE I
IF l_header_cust_acct <> nvl(l_line_cust_acct, -1) THEN
-- Create/UPDATE a CAN RULE and Create/UPDATE the BTO Rule --
l_clev_tbl_in(1).id := l_cle_id;
-- DELETE THE TAX EXEMPTION IF THERE
-- Bug 5202208 --
-- Modified code to keep a check for both Exempt_certificate_number
-- and tax_exemption_id for contracts migrated from 11.5.10.
-- IF l_oks_lines_rec.TAX_STATUS ='E' AND l_oks_lines_rec.TAX_EXEMPTION_ID IS NOT NULL THEN
IF (l_oks_lines_rec.TAX_STATUS ='E' AND ( l_oks_lines_rec.EXEMPT_CERTIFICATE_NUMBER IS NOT NULL
OR l_oks_lines_rec.TAX_EXEMPTION_ID IS NOT NULL))
THEN
l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
p_msg_name =>'OKS_CASCADE_DELETE_EXEMPTION',
p_token1 =>'TOKEN1' ,
p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),
p_token2 => 'TOKEN2',
p_token2_value => l_temp_party_name,
p_token3 => 'TOKEN3',
p_token3_value => l_temp_line_number);
-- DELETE COMMITMENT NUMBER
IF l_oks_lines_rec.payment_type = 'COM' THEN
l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
p_msg_name =>'OKS_CASCADE_DELETE_COMMITMENT',
p_token1 =>'TOKEN1' ,
p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),
p_token2 => 'TOKEN2',
p_token2_value => l_temp_party_name,
p_token3 => 'TOKEN3',
p_token3_value => l_temp_line_number);
-- DELETE CONTACTS --
FOR CUR_PARTY_REC IN CUR_LINE_PARTY_ROLE(l_chr_id, l_cle_id,l_line_party_id ) LOOP
l_cpl_id := CUR_PARTY_REC.ID;
-- Delete the contact when Contact Account Id is not same as
-- header Account Id
IF l_header_cust_acct <> l_line_cust_acct THEN
l_ctcv_tbl_in(l_contact).id := contact_rec.id;
l_ctcv_tbl_in(l_contact).last_updated_by := contact_rec.last_updated_by;
l_ctcv_tbl_in(l_contact).last_update_date := contact_rec.last_update_date;
l_ctcv_tbl_in(l_contact).last_update_login := contact_rec.last_update_login;
okc_contract_party_pub.delete_contact
(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_ctcv_tbl => l_ctcv_tbl_in
);
-- Delete Party Role --
IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
-- Check if there is any contaact Present belonging to the party role ---
l_temp_contact_id := CHECK_LINE_CONTACT(l_chr_id,l_cpl_id);-- 5485054
okc_contract_party_pub.delete_k_party_role
(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_cplv_tbl => l_cplv_tbl_in);
-- Update the STO rule at lines leve with header
-- level Customer account if the accounts are
-- not same.
-- Delete all contacts which are not
-- billing contact and are belonging to
-- ship to account Party Role
-- CASE I
IF l_header_cust_acct <> nvl(l_line_cust_acct, -1) THEN
-- Create/UPDATE a CAN RULE and Create/UPDATE the BTO Rule --
l_clev_tbl_in(1).id := l_cle_id;
-- DELETE CONTACTS --
FOR CUR_PARTY_REC IN CUR_LINE_PARTY_ROLE(l_chr_id, l_cle_id,l_line_party_id ) LOOP
l_cpl_id := CUR_PARTY_REC.ID;
-- Delete the contact when Contact Account Id is not same as
-- header Account Id
IF l_header_cust_acct <> l_line_cust_acct THEN
l_ctcv_tbl_in(l_contact).id := contact_rec.id;
l_ctcv_tbl_in(l_contact).last_updated_by := contact_rec.last_updated_by;
l_ctcv_tbl_in(l_contact).last_update_date := contact_rec.last_update_date;
l_ctcv_tbl_in(l_contact).last_update_login := contact_rec.last_update_login;
okc_contract_party_pub.delete_contact
(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_ctcv_tbl => l_ctcv_tbl_in
);
-- Delete Party Role --
IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
-- Check if there is any contaact Present belonging to the party role ---
l_temp_contact_id := CHECK_LINE_CONTACT(l_chr_id,l_cpl_id);-- 5485054
okc_contract_party_pub.delete_k_party_role
(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_cplv_tbl => l_cplv_tbl_in);
okc_contract_party_pub.update_contact
(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_ctcv_tbl => l_ctcv_tbl_in,
x_ctcv_tbl => l_ctcv_tbl_out);
OKS_BILL_SCH.update_bs_interface_date
(
p_top_line_id => l_cle_id,
p_invoice_rule_id => l_clev_tbl_in(1).inv_rule_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
OKS_BILL_SCH.update_bs_interface_date
(
p_top_line_id => l_cle_id,
p_invoice_rule_id => l_clev_tbl_in(1).inv_rule_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_scrv_tbl_in.DELETE;
OKS_SALES_CREDIT_PUB.delete_Sales_credit
(
p_api_version => 1.0,
p_init_msg_list => 'T',
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_scrv_tbl => l_scrv_tbl_in);
-- Call the delete API to Delete Credit card details
-- if the credit card details are present on the line level
IF l_oks_comm_line_rec.trxn_extension_id IS NOT NULL
THEN
Delete_credit_Card
(p_trnx_ext_id => l_oks_comm_line_rec.trxn_extension_id,
p_line_id => l_cle_id,
p_party_id => l_oks_party_rec.party_id ,
p_cust_account_id => l_line_cust_acct,
x_return_status => l_return_status,
x_msg_data => l_msg_data );
-- Call the delete API to Delete Credit card details--
IF l_oks_comm_line_rec.trxn_extension_id IS NOT NULL
THEN
Delete_credit_Card
(p_trnx_ext_id => l_oks_comm_line_rec.trxn_extension_id,
p_line_id => l_cle_id,
p_party_id => l_oks_party_rec.party_id ,
p_cust_account_id => l_header_cust_acct,
x_return_status => l_return_status,
x_msg_data => l_msg_data );
Delete_credit_Card
(p_trnx_ext_id => l_oks_comm_line_rec.trxn_extension_id,
p_line_id => l_cle_id,
-- p_party_id => l_party_id ,
p_party_id =>l_oks_party_rec.party_id,
p_cust_account_id => l_line_cust_acct,
x_return_status => l_return_status,
x_msg_data => l_msg_data );
Delete_credit_Card
(p_trnx_ext_id => l_oks_comm_line_rec.trxn_extension_id,
p_line_id => l_cle_id,
-- p_party_id => l_party_id ,
p_party_id =>l_oks_party_rec.party_id,
p_cust_account_id => l_header_cust_acct,
x_return_status => l_return_status,
x_msg_data => l_msg_data );
Delete_credit_Card
(p_trnx_ext_id => l_oks_comm_line_rec.trxn_extension_id,
p_line_id => l_cle_id,
p_party_id => l_oks_party_rec.party_id ,
p_cust_account_id =>l_line_cust_acct,
x_return_status => l_return_status,
x_msg_data => l_msg_data );
oks_qp_pkg.delete_locked_pricebreaks(l_api_version,
l_source_price_list_line_id,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data);
oks_contract_line_pub.update_line
(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_klnv_tbl => l_klnv_tbl_in,
x_klnv_tbl => l_klnv_tbl_out,
p_validate_yn => 'N'
);
update_line(
p_clev_tbl => l_clev_tbl_in,
x_clev_tbl => l_clev_tbl_out,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
OKS_COVERAGES_PVT.Update_COVERAGE_Effectivity(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_service_Line_Id => l_cle_id,
p_New_Start_Date => header_dates_rec.start_date,
p_New_End_Date => header_dates_rec.end_date );
--Update oks lines
oks_contract_line_pub.update_line
(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_klnv_tbl => l_kslnv_tbl_in,
x_klnv_tbl => l_kslnv_tbl_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 => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_klnv_tbl => l_klnv_tbl_in,
x_klnv_tbl => l_klnv_tbl_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 => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_klnv_tbl => l_klnv_tbl_in,
x_klnv_tbl => l_klnv_tbl_out,
p_validate_yn => 'N'
);
oks_contract_hdr_pub.update_header(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_khrv_tbl => l_khrv_tbl_type_in,
x_khrv_tbl => l_khrv_tbl_type_out,
p_validate_yn => 'N');
select start_date , end_date, lse_id
from okc_k_lines_v
where id = p_cle_id;
select
id,
line_number,
line_renewal_type_code
from okc_k_lines_b
where id = p_cle_id;
select
id,
sfwt_flag,
object_version_number,
inv_print_flag,
price_uom, -- 8/23/05 hkamdar R12 Partial Period
invoice_text,
standard_cov_yn -- Issue# 14 Bug 4566346
from oks_k_lines_v
where cle_id = p_cle_id;
select id,lse_id
from okc_k_lines_v
where cle_id =p_cle_id
and chr_id is null
and lse_id in (7,8,9,10,11,13,18,25,35)
and date_cancelled is null; --[llc]
select id,
lse_id,
line_number,
date_terminated -- new
from okc_k_lines_v
where id =p_subline_id;
p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
p_token1 => 'Sub Line No ',
p_token1_value => l_sub_line_seq_number);
l_klnv_tbl_in.DELETE;
l_clev_tbl_in.DELETE;
select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;
OKS_COVERAGES_PVT.Update_COVERAGE_Effectivity
(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_service_Line_Id => l_cle_id,
p_New_Start_Date => line_dates_rec.start_date,
p_New_End_Date => line_dates_rec.end_date );
oks_contract_line_pub.update_line
(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_klnv_tbl => l_klnv_tbl_in,
x_klnv_tbl => l_klnv_tbl_out,
p_validate_yn => 'N'
);
update_line(
p_clev_tbl => l_clev_tbl_in,
x_clev_tbl => l_clev_tbl_out,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_klnv_tbl_in.DELETE;
l_clev_tbl_in.DELETE;
oks_contract_line_pub.update_line
(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_klnv_tbl => l_klnv_tbl_in,
x_klnv_tbl => l_klnv_tbl_out,
p_validate_yn => 'N'
);
update_line(
p_clev_tbl => l_clev_tbl_in,
x_clev_tbl => l_clev_tbl_out,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
Procedure Delete_credit_Card
(p_trnx_ext_id IN NUMBER,
p_line_id IN NUMBER,
p_party_id IN NUMBER,
p_cust_account_id IN NUMBER ,
x_return_status OUT NOCOPY VARCHAR2 ,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_msg_count Number;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_credit_Card';
FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension.');
IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_payer => l_payer,
--p_payer_equivalency=> IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD, bug 5439978
p_payer_equivalency=> IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_FULL,
p_entity_id => p_trnx_ext_id,
x_response => l_response
);
End Delete_Credit_Card;
SELECT instr_assignment_id
FROM IBY_TRXN_EXTENSIONS_V
WHERE TRXN_EXTENSION_ID = l_trnx_ext_id;
| Purpose: Insert cascade attributes data into OKC_CASCADE_CONC_REQ
|
| In Parameters: header_lines_tbl Cascade header attributes
| Out Parameters: x_return_status standard return status
|
+============================================================================*/
PROCEDURE ADD_CONCURRENT(header_lines_tbl IN OKS_ATTR_DEFAULTS_PVT.header_lines_tbl_type,
X_return_status OUT NOCOPY Varchar2) IS
l_id NUMBER;
INSERT INTO OKS_CASCADE_CONC_REQ( chr_id,
cle_id,
header_sto,
header_bto,
header_dates,
header_arl,
header_ire,
header_tax,
header_exception_number,
header_bca,
header_sca,
header_tax_code_id,
header_tax_code,
header_sales_credits,
header_billto_contact,
billto_id,
billing_profile,
billing_profile_id,
calculate_tax,
payment_method,
price_uom,
price_list,
header_tax_cls_code)
VALUES(header_lines_tbl(i).chr_id,
header_lines_tbl(i).cle_id,
header_lines_tbl(i).header_sto,
header_lines_tbl(i).header_bto,
header_lines_tbl(i).header_dates,
header_lines_tbl(i).header_arl,
header_lines_tbl(i).header_ire,
header_lines_tbl(i).header_tax,
header_lines_tbl(i).header_exception_number,
header_lines_tbl(i).header_bca,
header_lines_tbl(i).header_sca,
header_lines_tbl(i).header_tax_code_id,
header_lines_tbl(i).header_tax_code,
header_lines_tbl(i).header_sales_credits,
header_lines_tbl(i).header_billto_contact,
header_lines_tbl(i).billto_id,
header_lines_tbl(i).billing_profile,
header_lines_tbl(i).billing_profile_id,
header_lines_tbl(i).calculate_tax,
header_lines_tbl(i).payment_method,
header_lines_tbl(i).price_uom,
header_lines_tbl(i).price_list,
header_lines_tbl(i).header_tax_cls_code
);
| Purpose: Insert cascade attributes data into OKC_CASCADE_CONC_REQ_SUB
|
| In Parameters: l_line_table Cascade lines attributes
| Out Parameters: x_return_status standard return status
|
+============================================================================*/
PROCEDURE ADD_CONCURRENT_SUB(lines_sublines_tbl IN OKS_ATTR_DEFAULTS_PVT.lines_sublines_tbl_type,
X_return_status OUT NOCOPY Varchar2) IS
l_id NUMBER;
INSERT INTO OKS_CASCADE_CONC_REQ_SUB(chr_id ,
cle_id ,
subline_id ,
line_irt ,
line_renewal ,
line_inv_print ,
line_dates ,
line_cov_eff ,
header_to_lines ,
price_uom )
VALUES(lines_sublines_tbl(i).chr_id,
lines_sublines_tbl(i).cle_id,
lines_sublines_tbl(i).subline_id,
lines_sublines_tbl(i).line_irt,
lines_sublines_tbl(i).line_renewal,
lines_sublines_tbl(i).line_inv_print,
lines_sublines_tbl(i).line_dates,
lines_sublines_tbl(i).line_cov_eff,
lines_sublines_tbl(i).header_to_lines,
lines_sublines_tbl(i).price_uom);
DELETE FROM OKS_CASCADE_CONC_REQ WHERE CHR_ID=p_chr_id;
DELETE FROM OKS_CASCADE_CONC_REQ_SUB WHERE CHR_ID=p_chr_id;
SELECT *
FROM OKS_CASCADE_CONC_REQ
WHERE chr_id=p_chr_id;
SELECT *
FROM OKS_CASCADE_CONC_REQ_SUB
WHERE chr_id=p_chr_id;