[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT '1'
FROM okc_k_headers_v
WHERE id = p_contract_id
AND sts_code = G_BOOKED;
PROCEDURE Update_Contracts ( 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_contract_id IN NUMBER)
IS
l_return_status VARCHAR2(1);
OKL_CONTRACT_STATUS_PUB.update_contract_status(
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => G_REVERSED,
p_chr_id => p_contract_id );
END Update_Contracts;
SELECT '1'
FROM OKL_TRX_CONTRACTS TC, OKL_TRX_TYPES_B TTB
WHERE TC.KHR_ID = p_contract_id
AND TC.TRY_ID = TTB.ID
--rkuttiya added for 12.1.1 Multi GAAP
AND TC.REPRESENTATION_TYPE = 'PRIMARY'
--
AND TTB.TRX_TYPE_CLASS NOT IN (G_BOOKING, G_GENERATE_YIELDS, G_REVERSE,
G_UPFRONT_TAX); -- G_UPFRONT_TAX introduced for R12 ebTax requirement
SELECT '1'
FROM OKL_TRX_ASSETS A, OKL_TXL_ASSETS_B B, OKL_TRX_TYPES_B TTB
WHERE B.DNZ_KHR_ID = p_contract_id
AND A.ID = B.TAS_ID
AND A.TRY_ID = TTB.ID
AND TTB.TRX_TYPE_CLASS NOT IN (G_INTERNAL_ASSET_CREATION);
SELECT '1'
FROM OKL_TRX_AP_INVOICES_B TAI, OKL_TRX_TYPES_B TTB
,OKL_TXL_AP_INV_LNS_ALL_B TPL
WHERE TAI.ID = TPL.TAP_ID
AND TPL.KHR_ID = p_contract_id
AND TAI.TRY_ID = TTB.ID
AND TTB.TRX_TYPE_CLASS NOT IN (G_FUNDING)
AND TAI.TRX_STATUS_CODE = 'PROCESSED';
SELECT '1'
FROM OKL_TRX_AR_INVOICES_B TAI
WHERE TAI.KHR_ID = p_contract_id
AND TAI.TRX_STATUS_CODE = 'PROCESSED';
l_select_statement VARCHAR2(4000);
SELECT ID, TRY_ID, transaction_date
FROM OKL_TRX_CONTRACTS
WHERE KHR_ID = p_contract_id
--rkuttiya added for 12.1.1 Multi GAAP
AND REPRESENTATION_TYPE = 'PRIMARY';
SELECT ID
FROM OKL_TXL_CNTRCT_LNS
WHERE TCN_ID = p_tcn_id;
SELECT DISTINCT TAS.ID TAS_ID,TAS.TRANSACTION_DATE
FROM OKL_TXL_ASSETS_B TA,OKL_TRX_ASSETS TAS
WHERE TA.DNZ_KHR_ID = p_contract_id
AND TA.TAS_ID=TAS.ID;
SELECT ID
FROM OKL_TXL_ASSETS_B TA
WHERE TA.TAS_ID = p_tas_id;
SELECT a.ID, a.try_id
FROM OKL_TRX_AP_INVOICES_B a
,okl_txl_ap_inv_lns_all_b b
WHERE a.id = b.tap_id
AND b.khr_id = p_contract_id;
SELECT ID
FROM OKL_TXL_AP_INV_LNS_B
WHERE TAP_ID = p_tap_id;
SELECT TRX_TYPE_CLASS
FROM OKL_TRX_TYPES_B
WHERE ID = p_try_id;
SELECT '1'
FROM OKL_TRNS_ACC_DSTRS
WHERE SOURCE_ID = p_source_id
AND SOURCE_TABLE = p_source_table;
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
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_tcnv_rec => l_tcnv_rec
,x_tcnv_rec => x_tcnv_rec );
OKL_TRX_ASSETS_PUB.update_trx_ass_h_Def(
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_thpv_rec => l_thpv_rec
,x_thpv_rec => x_thpv_rec );
OKL_TRX_AP_INVOICES_PUB.update_trx_ap_invoices(
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_tapv_rec => l_tapv_rec
,x_tapv_rec => x_tapv_rec );
SELECT TRYB.id
FROM OKL_TRX_TYPES_B TRYB,
OKL_TRX_TYPES_TL TRYT
WHERE
TRYB.ID = TRYT.ID and
TRYT.LANGUAGE = 'US' and
TRYT.NAME = G_TRX_TYPE_REVERSE;
SELECT '1'
FROM okc_k_headers_v
WHERE id = p_contract_id;
SELECT '1'
FROM OKL_TRX_CONTRACTS
WHERE KHR_ID = p_contract_id
--rkuttiya added for 12.1.1 Multi GAAP
AND REPRESENTATION_TYPE = 'PRIMARY';
SELECT '1'
FROM OKL_TRX_AP_INVOICES_B a
, okl_txl_ap_inv_lns_all_b b
WHERE a.id = b.tap_id
AND b.KHR_ID = p_contract_id;
SELECT '1'
FROM OKL_TXL_ASSETS_B
WHERE DNZ_KHR_ID = p_contract_id;
SELECT 1 FROM okc_k_lines_b CLEB, okl_k_lines KLE
WHERE CLEB.dnz_chr_id = p_k_id
AND KLE.FEE_TYPE = 'ROLLOVER'
AND KLE.ID = CLEB.ID
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_v okcsts
WHERE okcsts.code = cleb.sts_code
AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
SELECT contract_number FROM okc_k_headers_v
WHERE id = p_k_id;
SELECT
'X'
FROM
OKL_K_HEADERS
WHERE
id = p_chr_id
AND DATE_LAST_INTERIM_INTEREST_CAL IS NOT NULL;
Update_Contracts ( 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_contract_id => p_contract_id );
Update_Contracts ( 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_contract_id => p_contract_id );
Okl_Trx_Contracts_Pub.update_trx_contracts(
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_tcnv_rec => l_tcnv_rec
,x_tcnv_rec => x_tcnv_rec);