The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ID,
OBJECT_VERSION_NUMBER,
ICA_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
TAS_TYPE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
TSU_CODE,
TRY_ID,
DATE_TRANS_OCCURRED,
TRANS_NUMBER,
COMMENTS,
REQ_ASSET_ID,
TOTAL_MATCH_AMOUNT
FROM OKL_TRX_ASSETS
WHERE id = p_tas_id;
x_trxv_rec.LAST_UPDATED_BY,
x_trxv_rec.LAST_UPDATE_DATE,
x_trxv_rec.LAST_UPDATE_LOGIN,
x_trxv_rec.TSU_CODE,
x_trxv_rec.TRY_ID,
x_trxv_rec.DATE_TRANS_OCCURRED,
x_trxv_rec.TRANS_NUMBER,
x_trxv_rec.COMMENTS,
x_trxv_rec.REQ_ASSET_ID,
x_trxv_rec.TOTAL_MATCH_AMOUNT;
SELECT CIM.ID,
CIM.OBJECT_VERSION_NUMBER,
CIM.CLE_ID,
CIM.CHR_ID,
CIM.CLE_ID_FOR,
CIM.DNZ_CHR_ID,
CIM.OBJECT1_ID1,
CIM.OBJECT1_ID2,
CIM.JTOT_OBJECT1_CODE,
CIM.UOM_CODE,
CIM.EXCEPTION_YN,
CIM.NUMBER_OF_ITEMS,
CIM.UPG_ORIG_SYSTEM_REF,
CIM.UPG_ORIG_SYSTEM_REF_ID,
CIM.PRICED_ITEM_YN,
CIM.CREATED_BY,
CIM.CREATION_DATE,
CIM.LAST_UPDATED_BY,
CIM.LAST_UPDATE_DATE,
CIM.LAST_UPDATE_LOGIN
FROM okc_k_items_v cim
WHERE cim.dnz_chr_id = p_dnz_chr_id
AND cim.cle_id = p_cle_id;
x_cimv_rec.LAST_UPDATED_BY,
x_cimv_rec.LAST_UPDATE_DATE,
x_cimv_rec.LAST_UPDATE_LOGIN;
SELECT ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
CHR_ID_RESPONSE,
CHR_ID_AWARD,
INV_ORGANIZATION_ID,
STS_CODE,
QCL_ID,
SCS_CODE,
CONTRACT_NUMBER,
CURRENCY_CODE,
CONTRACT_NUMBER_MODIFIER,
ARCHIVED_YN,
DELETED_YN,
CUST_PO_NUMBER_REQ_YN,
PRE_PAY_REQ_YN,
CUST_PO_NUMBER,
SHORT_DESCRIPTION,
COMMENTS,
DESCRIPTION,
DPAS_RATING,
COGNOMEN,
TEMPLATE_YN,
TEMPLATE_USED,
DATE_APPROVED,
DATETIME_CANCELLED,
AUTO_RENEW_DAYS,
DATE_ISSUED,
DATETIME_RESPONDED,
NON_RESPONSE_REASON,
NON_RESPONSE_EXPLAIN,
RFP_TYPE,
CHR_TYPE,
KEEP_ON_MAIL_LIST,
SET_ASIDE_REASON,
SET_ASIDE_PERCENT,
RESPONSE_COPIES_REQ,
DATE_CLOSE_PROJECTED,
DATETIME_PROPOSED,
DATE_SIGNED,
DATE_TERMINATED,
DATE_RENEWED,
TRN_CODE,
START_DATE,
END_DATE,
AUTHORING_ORG_ID,
BUY_OR_SELL,
ISSUE_OR_RECEIVE,
ESTIMATED_AMOUNT,
ESTIMATED_AMOUNT_RENEWED,
CURRENCY_CODE_RENEWED,
UPG_ORIG_SYSTEM_REF,
UPG_ORIG_SYSTEM_REF_ID,
APPLICATION_ID,
ORIG_SYSTEM_SOURCE_CODE,
ORIG_SYSTEM_ID1,
ORIG_SYSTEM_REFERENCE1,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM okc_k_headers_v chrv
WHERE chrv.id = p_id;
x_chrv_rec.DELETED_YN,
x_chrv_rec.CUST_PO_NUMBER_REQ_YN,
x_chrv_rec.PRE_PAY_REQ_YN,
x_chrv_rec.CUST_PO_NUMBER,
x_chrv_rec.SHORT_DESCRIPTION,
x_chrv_rec.COMMENTS,
x_chrv_rec.DESCRIPTION,
x_chrv_rec.DPAS_RATING,
x_chrv_rec.COGNOMEN,
x_chrv_rec.TEMPLATE_YN,
x_chrv_rec.TEMPLATE_USED,
x_chrv_rec.DATE_APPROVED,
x_chrv_rec.DATETIME_CANCELLED,
x_chrv_rec.AUTO_RENEW_DAYS,
x_chrv_rec.DATE_ISSUED,
x_chrv_rec.DATETIME_RESPONDED,
x_chrv_rec.NON_RESPONSE_REASON,
x_chrv_rec.NON_RESPONSE_EXPLAIN,
x_chrv_rec.RFP_TYPE,
x_chrv_rec.CHR_TYPE,
x_chrv_rec.KEEP_ON_MAIL_LIST,
x_chrv_rec.SET_ASIDE_REASON,
x_chrv_rec.SET_ASIDE_PERCENT,
x_chrv_rec.RESPONSE_COPIES_REQ,
x_chrv_rec.DATE_CLOSE_PROJECTED,
x_chrv_rec.DATETIME_PROPOSED,
x_chrv_rec.DATE_SIGNED,
x_chrv_rec.DATE_TERMINATED,
x_chrv_rec.DATE_RENEWED,
x_chrv_rec.TRN_CODE,
x_chrv_rec.START_DATE,
x_chrv_rec.END_DATE,
x_chrv_rec.AUTHORING_ORG_ID,
x_chrv_rec.BUY_OR_SELL,
x_chrv_rec.ISSUE_OR_RECEIVE,
x_chrv_rec.ESTIMATED_AMOUNT,
x_chrv_rec.ESTIMATED_AMOUNT_RENEWED,
x_chrv_rec.CURRENCY_CODE_RENEWED,
x_chrv_rec.UPG_ORIG_SYSTEM_REF,
x_chrv_rec.UPG_ORIG_SYSTEM_REF_ID,
x_chrv_rec.APPLICATION_ID,
x_chrv_rec.ORIG_SYSTEM_SOURCE_CODE,
x_chrv_rec.ORIG_SYSTEM_ID1,
x_chrv_rec.ORIG_SYSTEM_REFERENCE1,
x_chrv_rec.ATTRIBUTE_CATEGORY,
x_chrv_rec.ATTRIBUTE1,
x_chrv_rec.ATTRIBUTE2,
x_chrv_rec.ATTRIBUTE3,
x_chrv_rec.ATTRIBUTE4,
x_chrv_rec.ATTRIBUTE5,
x_chrv_rec.ATTRIBUTE6,
x_chrv_rec.ATTRIBUTE7,
x_chrv_rec.ATTRIBUTE8,
x_chrv_rec.ATTRIBUTE9,
x_chrv_rec.ATTRIBUTE10,
x_chrv_rec.ATTRIBUTE11,
x_chrv_rec.ATTRIBUTE12,
x_chrv_rec.ATTRIBUTE13,
x_chrv_rec.ATTRIBUTE14,
x_chrv_rec.ATTRIBUTE15,
x_chrv_rec.CREATED_BY,
x_chrv_rec.CREATION_DATE,
x_chrv_rec.LAST_UPDATED_BY,
x_chrv_rec.LAST_UPDATE_DATE,
x_chrv_rec.LAST_UPDATE_LOGIN;
SELECT ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
CHR_ID,
CLE_ID,
LSE_ID,
LINE_NUMBER,
STS_CODE,
DISPLAY_SEQUENCE,
TRN_CODE,
DNZ_CHR_ID,
COMMENTS,
ITEM_DESCRIPTION,
OKE_BOE_DESCRIPTION,
COGNOMEN,
HIDDEN_IND,
PRICE_UNIT,
PRICE_UNIT_PERCENT,
PRICE_NEGOTIATED,
PRICE_NEGOTIATED_RENEWED,
PRICE_LEVEL_IND,
INVOICE_LINE_LEVEL_IND,
DPAS_RATING,
BLOCK23TEXT,
EXCEPTION_YN,
TEMPLATE_USED,
DATE_TERMINATED,
NAME,
START_DATE,
END_DATE,
DATE_RENEWED,
UPG_ORIG_SYSTEM_REF,
UPG_ORIG_SYSTEM_REF_ID,
ORIG_SYSTEM_SOURCE_CODE,
ORIG_SYSTEM_ID1,
ORIG_SYSTEM_REFERENCE1,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
PRICE_LIST_ID,
PRICING_DATE,
PRICE_LIST_LINE_ID,
LINE_LIST_PRICE,
ITEM_TO_PRICE_YN,
PRICE_BASIS_YN,
CONFIG_HEADER_ID,
CONFIG_REVISION_NUMBER,
CONFIG_COMPLETE_YN,
CONFIG_VALID_YN,
CONFIG_TOP_MODEL_LINE_ID,
CONFIG_ITEM_TYPE,
CONFIG_ITEM_ID ,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
PRICE_TYPE,
CURRENCY_CODE,
CURRENCY_CODE_RENEWED,
LAST_UPDATE_LOGIN
FROM Okc_K_Lines_V
WHERE okc_k_lines_v.id = p_cle_id;
x_clev_rec.program_update_date,
x_clev_rec.price_list_id,
x_clev_rec.pricing_date,
x_clev_rec.price_list_line_id,
x_clev_rec.line_list_price,
x_clev_rec.item_to_price_yn,
x_clev_rec.price_basis_yn,
x_clev_rec.config_header_id,
x_clev_rec.config_revision_number,
x_clev_rec.config_complete_yn,
x_clev_rec.config_valid_yn,
x_clev_rec.config_top_model_line_id,
x_clev_rec.config_item_type,
x_clev_rec.CONFIG_ITEM_ID ,
x_clev_rec.ATTRIBUTE_CATEGORY,
x_clev_rec.ATTRIBUTE1,
x_clev_rec.ATTRIBUTE2,
x_clev_rec.ATTRIBUTE3,
x_clev_rec.ATTRIBUTE4,
x_clev_rec.ATTRIBUTE5,
x_clev_rec.ATTRIBUTE6,
x_clev_rec.ATTRIBUTE7,
x_clev_rec.ATTRIBUTE8,
x_clev_rec.ATTRIBUTE9,
x_clev_rec.ATTRIBUTE10,
x_clev_rec.ATTRIBUTE11,
x_clev_rec.ATTRIBUTE12,
x_clev_rec.ATTRIBUTE13,
x_clev_rec.ATTRIBUTE14,
x_clev_rec.ATTRIBUTE15,
x_clev_rec.CREATED_BY,
x_clev_rec.CREATION_DATE,
x_clev_rec.LAST_UPDATED_BY,
x_clev_rec.LAST_UPDATE_DATE,
x_clev_rec.PRICE_TYPE,
x_clev_rec.CURRENCY_CODE,
x_clev_rec.CURRENCY_CODE_RENEWED,
x_clev_rec.LAST_UPDATE_LOGIN;
SELECT ID,
OBJECT_VERSION_NUMBER,
KLE_ID,
STY_ID,
PRC_CODE,
FCG_CODE,
NTY_CODE,
ESTIMATED_OEC,
LAO_AMOUNT,
TITLE_DATE,
FEE_CHARGE,
LRS_PERCENT,
INITIAL_DIRECT_COST,
PERCENT_STAKE,
PERCENT,
EVERGREEN_PERCENT,
AMOUNT_STAKE,
OCCUPANCY,
COVERAGE,
RESIDUAL_PERCENTAGE,
DATE_LAST_INSPECTION,
DATE_SOLD,
LRV_AMOUNT,
CAPITAL_REDUCTION,
DATE_NEXT_INSPECTION_DUE,
DATE_RESIDUAL_LAST_REVIEW,
DATE_LAST_REAMORTISATION,
VENDOR_ADVANCE_PAID,
WEIGHTED_AVERAGE_LIFE,
TRADEIN_AMOUNT,
BOND_EQUIVALENT_YIELD,
TERMINATION_PURCHASE_AMOUNT,
REFINANCE_AMOUNT,
YEAR_BUILT,
DELIVERED_DATE,
CREDIT_TENANT_YN,
DATE_LAST_CLEANUP,
YEAR_OF_MANUFACTURE,
COVERAGE_RATIO,
REMARKETED_AMOUNT,
GROSS_SQUARE_FOOTAGE,
PRESCRIBED_ASSET_YN,
DATE_REMARKETED,
NET_RENTABLE,
REMARKET_MARGIN,
DATE_LETTER_ACCEPTANCE,
REPURCHASED_AMOUNT,
DATE_COMMITMENT_EXPIRATION,
DATE_REPURCHASED,
DATE_APPRAISAL,
RESIDUAL_VALUE,
APPRAISAL_VALUE,
SECURED_DEAL_YN,
GAIN_LOSS,
FLOOR_AMOUNT,
RE_LEASE_YN,
PREVIOUS_CONTRACT,
TRACKED_RESIDUAL,
DATE_TITLE_RECEIVED,
AMOUNT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
STY_ID_FOR,
CLG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
DATE_FUNDING,
DATE_FUNDING_REQUIRED,
DATE_ACCEPTED,
DATE_DELIVERY_EXPECTED,
OEC,
CAPITAL_AMOUNT,
RESIDUAL_GRNTY_AMOUNT,
RESIDUAL_CODE,
RVI_PREMIUM,
CREDIT_NATURE,
CAPITALIZED_INTEREST,
CAPITAL_REDUCTION_PERCENT,
FEE_TYPE
FROM OKL_K_LINES_V
WHERE OKL_K_LINES_V.id = p_kle_id;
x_klev_rec.LAST_UPDATED_BY,
x_klev_rec.LAST_UPDATE_DATE,
x_klev_rec.LAST_UPDATE_LOGIN,
x_klev_rec.DATE_FUNDING,
x_klev_rec.DATE_FUNDING_REQUIRED,
x_klev_rec.DATE_ACCEPTED,
x_klev_rec.DATE_DELIVERY_EXPECTED,
x_klev_rec.OEC,
x_klev_rec.CAPITAL_AMOUNT,
x_klev_rec.RESIDUAL_GRNTY_AMOUNT,
x_klev_rec.RESIDUAL_CODE,
x_klev_rec.RVI_PREMIUM,
x_klev_rec.CREDIT_NATURE,
x_klev_rec.CAPITALIZED_INTEREST,
x_klev_rec.CAPITAL_REDUCTION_PERCENT,
x_klev_rec.FEE_TYPE;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKC_K_HEADERS_B
WHERE ID = p_chr_id);
SELECT id
FROM okl_trx_contracts
WHERE khr_id = p_chr_id
AND tcn_type = 'SPLC'
--rkuttiya added for 12.1.1 Multi GAAP
AND representation_type = 'PRIMARY'
--
AND tsu_code IN ('ENTERED','WORKING','WAITING','SUBMITTED');
SELECT id
FROM okc_k_headers_b
WHERE orig_system_id1 = p_chr_id
AND orig_system_source_code = 'OKL_SPLIT'
ORDER BY CREATION_DATE;
PROCEDURE l_update_contract_header(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_restricted_update IN VARCHAR2 DEFAULT 'F',
p_chrv_rec IN chrv_rec_type,
p_khrv_rec IN khrv_rec_type,
x_chrv_rec OUT NOCOPY chrv_rec_type,
x_khrv_rec OUT NOCOPY khrv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'L_UPDATE_CONTRACT_HEADER';
OKL_CONTRACT_PUB.update_contract_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_restricted_update => p_restricted_update,
p_chrv_rec => l_chrv_rec,
p_khrv_rec => l_khrv_rec,
x_chrv_rec => x_chrv_rec,
x_khrv_rec => x_khrv_rec);
END l_update_contract_header;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM OKC_SUBCLASS_TOP_LINE stl,
OKC_LINE_STYLES_V lse,
OKC_K_LINES_V cle
WHERE cle.id = p_top_line_id
AND cle.dnz_chr_id = p_dnz_chr_id
AND cle.cle_id IS NULL
AND cle.chr_id = cle.dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FIN_LINE_LTY_CODE
AND lse.lse_type = G_TLS_TYPE
AND lse.lse_parent_id IS NULL
AND lse.id = stl.lse_id
AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
SELECT CHR.contract_number
FROM OKC_K_HEADERS_B CHR
WHERE CHR.id = p_chr_id;
SELECT id
FROM okc_qa_check_lists_v
WHERE name = p_qcl_name;
SELECT NVL(qcl_id,0)
FROM okc_k_headers_b
WHERE id = p_chr_id;
PROCEDURE l_delete_contract_line(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_contract_id IN OKC_K_HEADERS_V.ID%TYPE) IS
l_api_name CONSTANT VARCHAR2(30) := 'LOCAL_DEL_CONTRACT_LINE';
SELECT id stm_id
FROM OKL_STREAMS
WHERE khr_id = p_khr_id;
SELECT id trx_id
FROM OKL_TRX_CONTRACTS
WHERE khr_id = p_khr_id
--rkuttiya added for 12.1.1 Multi GAAP
AND representation_type = 'PRIMARY';
SELECT id
FROM OKL_TXL_CNTRCT_LNS
WHERE khr_id = p_khr_id;
SELECT cle.id top_line
FROM okc_line_styles_b lse,
okc_k_lines_b cle
WHERE cle.dnz_chr_id = p_dnz_chr_id
AND cle.cle_id IS NULL
AND cle.chr_id = cle.dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lse_parent_id IS NULL
AND lse.lse_type = G_TLS_TYPE;
SELECT orig_system_id1
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT trx.id trx_id
FROM okl_trx_contracts trx,
okl_trx_types_tl try,
okc_k_headers_b CHR
WHERE try.name = 'Split Contract'
AND try.LANGUAGE = 'US'
AND trx.try_id = try.id
AND trx.tsu_code = 'ENTERED'
AND trx.khr_id = CHR.orig_system_id1
--rkuttiya added for 12.1.1 Multi GAAP Project
AND trx.representation_type = 'PRIMARY'
--
AND CHR.orig_system_source_code = 'OKL_SPLIT'
AND CHR.orig_system_id1= p_org_sys_id;
Okl_Trx_Contracts_Pub.update_trx_contracts(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => l_tcnv_rec,
x_tcnv_rec => lx_tcnv_rec);
OKL_CONTRACT_STATUS_PUB.update_contract_status(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => 'INCOMPLETE',
p_chr_id => p_contract_id);
OKL_ACCOUNT_DIST_PUB.DELETE_ACCT_ENTRIES(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_source_id => r_get_source_id.id,
p_source_table => 'OKL_TXL_CNTRCT_LNS');
OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => r_tcnv_rec);
OKL_STREAMS_PUB.delete_streams(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_stmv_rec => l_stmv_rec);
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => r_get_k_top_line.top_line);
OKL_CONTRACT_PUB.delete_contract_header(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chrv_rec => l_chrv_rec,
p_khrv_rec => l_khrv_rec);
END l_delete_contract_line;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKC_K_HEADERS_B
WHERE ID = p_chr_id);
SELECT trx.id trx_id
FROM okl_trx_contracts trx,
okl_trx_types_tl try
WHERE try.name = 'Split Contract'
AND try.LANGUAGE = 'US'
AND trx.try_id = try.id
AND trx.tsu_code IN ('ENTERED','WORKING','WAITING','SUBMITTED')
AND trx.tcn_type = 'SPLC'
--rkuttiya added for 12.1.1 Multi GAAP
AND trx.representation_type = 'PRIMARY'
--
AND trx.khr_id = p_chr_id;
SELECT id
FROM okc_k_headers_b
WHERE orig_system_id1 = p_chr_id
AND orig_system_source_code = 'OKL_SPLIT';
Okl_Trx_Contracts_Pub.update_trx_contracts(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => l_tcnv_rec,
x_tcnv_rec => lx_tcnv_rec);
l_delete_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => ln_split_contract1);
PROCEDURE l_delete_fee_service_lines(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_contract_id IN OKC_K_HEADERS_V.ID%TYPE) IS
l_api_name CONSTANT VARCHAR2(30) := 'L_DEL_FEE_SERV_LINES';
SELECT cle.id id
FROM okl_k_lines_v kle,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = kle.id
AND cle.lse_id = lse.id
AND lse.lty_code IN (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
AND lse.lse_type = 'TLS'
AND cle.cle_id IS NULL
AND cle.id NOT IN (SELECT DISTINCT(cle_sl.cle_id) cle_id
FROM okl_k_lines_v kle_sl,
okc_k_lines_v cle_sl,
okc_line_styles_b lse_sl
WHERE cle_sl.dnz_chr_id = p_chr_id
AND cle_sl.id = kle_sl.id
AND cle_sl.lse_id = lse_sl.id
AND lse_sl.lty_code IN (G_FEL_LINE_LTY_CODE, G_SRL_LINE_LTY_CODE));
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => r_get_fee_service_lines.id);
END l_delete_fee_service_lines;
SELECT '1'
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKC_K_LINES_B cle,
OKC_LINE_STYLES_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND lse.id = cle.lse_id
AND lse.lty_code IN (G_SER_LINE_LTY_CODE,
G_SRL_LINE_LTY_CODE,
G_FEE_LINE_LTY_CODE,
G_FEL_LINE_LTY_CODE,
G_USG_LINE_LTY_CODE,
G_USL_LINE_LTY_CODE));
SELECT orig_system_id1
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT sum(cle.capital_amount) total_capital_amount
FROM okl_k_lines_full_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FIN_LINE_LTY_CODE
AND lse.lse_type = G_TLS_TYPE;*/
select tcle.id id
from okc_k_items tcim,
okc_k_lines_b tcle,
okc_line_styles_b lse
where tcim.dnz_chr_id = p_dnz_chr_id
and tcle.lse_id = lse.id
and tcim.cle_id = tcle.id
and tcim.dnz_chr_id = tcle.dnz_chr_id
and lse.lty_code in (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
and exists (select 1
from okc_k_items cim,
okc_k_lines_b cle
where cim.dnz_chr_id = p_dnz_chr_id
and cle.cle_id = tcle.id
and cim.cle_id = cle.id
and cim.jtot_object1_code = 'OKX_COVASST'
and not exists
(select 1
from okc_k_lines_b cle,
okc_line_styles_b lse
where cle.dnz_chr_id = p_dnz_chr_id
and cle.lse_id = lse.id
and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
and lse.lse_type = G_TLS_TYPE
and cle.id = cim.object1_id1))
and not exists
(select 1
from okc_k_lines_b cle,
okc_line_styles_b lse
where cle.dnz_chr_id = p_dnz_chr_id
and cle.lse_id = lse.id
and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
and lse.lse_type = G_TLS_TYPE
and exists(select 1
from okc_k_lines_b scle,
okc_k_items scim
where scle.id = scim.cle_id -- sub line join with item
and scim.dnz_chr_id = p_dnz_chr_id
and scim.dnz_chr_id = tcle.dnz_chr_id
and scle.cle_id = tcle.id -- fee top line join
and scim.object1_id1 = cle.id));
SELECT DISTINCT(cle.id) id
FROM okl_k_lines_full_v cle,
okc_k_items cim
WHERE cle.dnz_chr_id = p_dnz_chr_Id
AND cle.id = cim.cle_id
AND cim.jtot_object1_code = 'OKX_COVASST'
AND cim.object1_id1 NOT IN (SELECT cle.id
FROM okc_k_lines_b cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_dnz_chr_Id
AND cle.lse_id = lse.id
AND lse.lty_code IN (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
AND lse.lse_type = G_TLS_TYPE);
SELECT cle.cle_id fee_top_line_id, cim.cle_id linked_asset_id
FROM okc_k_items cim,
okc_k_lines_b cle
WHERE cim.dnz_chr_id = p_dnz_chr_Id
AND cim.cle_id = cle.id
AND cim.dnz_chr_id = cle.dnz_chr_id
AND cim.jtot_object1_code = 'OKX_COVASST'
AND cim.object1_id1 not in (SELECT cle.id
FROM okc_k_lines_b cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_dnz_chr_Id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FIN_LINE_LTY_CODE
AND lse.lse_type = G_TLS_TYPE);
SELECT cim.cle_id cle_id
FROM okc_k_items cim
WHERE cim.dnz_chr_id = p_dnz_chr_Id
AND cim.jtot_object1_code = 'OKX_COVASST'
AND cim.object1_id1 not in (SELECT cle.id
FROM okc_k_lines_b cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_dnz_chr_Id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FIN_LINE_LTY_CODE
AND lse.lse_type = G_TLS_TYPE);*/
SELECT nvl(kle.amount,0) amount,
nvl(kle.initial_direct_cost,0) initial_direct_cost,
cle.id id
FROM okl_k_lines_v kle,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = kle.id
AND cle.lse_id = lse.id
AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
AND lse.lse_type = G_TLS_TYPE
AND cle.cle_id IS NULL;*/
SELECT DISTINCT(cle.id) id,
NVL(kle.amount,0) amount,
NVL(kle.initial_direct_cost,0) initial_direct_cost
FROM okl_k_lines_v kle_sl,
okc_k_lines_v cle_sl,
okc_line_styles_b lse_sl,
okl_k_lines_v kle,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = kle.id
AND cle.lse_id = lse.id
AND lse.lty_code IN (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
AND lse.lse_type = G_TLS_TYPE
AND cle.cle_id IS NULL
AND cle.id = cle_sl.cle_id
AND cle_sl.id = kle_sl.id
AND cle_sl.lse_id = lse_sl.id
AND lse_sl.lty_code IN (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE);
SELECT SUM(kle.CAPITAL_AMOUNT)
FROM okl_k_lines_v kle,
okc_line_styles_b lse,
okc_k_lines_v cle
WHERE cle.cle_id = p_cle_id
AND cle.id = kle.id
AND cle.lse_id = lse.id
AND lse.lty_code IN (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE);
SELECT sum(nvl(kle_sl.capital_amount,0)) amount,
cle.id id,
cle.orig_system_id1 orig_system_id1
FROM okl_k_lines_v kle_sl,
okc_k_lines_v cle_sl,
okc_line_styles_b lse_sl,
okl_k_lines_v kle,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = kle.id
AND cle.lse_id = lse.id
AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
AND lse.lse_type = G_TLS_TYPE
AND cle.cle_id IS NULL
AND cle.id = cle_sl.cle_id
and cle_sl.id = kle_sl.id
AND cle_sl.lse_id = lse_sl.id
AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE)
group by cle.id,
cle.orig_system_id1;*/
SELECT rl.id,
rl.rule_information6 payment_amount,
rl.rule_information2 rl_date
FROM okc_rule_groups_b rg,
okc_rules_b rl,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = p_cle_id
AND cle.lse_id = lse.id
AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
AND lse.lse_type = G_TLS_TYPE
AND cle.cle_id IS NULL
AND rg.dnz_chr_id = cle.dnz_chr_id
AND rg.cle_id = cle.id
AND rg.chr_id IS NULL
AND rg.id = rl.rgp_id
AND rg.rgd_code = 'LALEVL'
AND rl.rule_information_category = 'LASLL'
AND not exists (SELECT '1'
FROM okc_k_lines_v cle_sl,
okc_line_styles_b lse_sl
WHERE cle_sl.dnz_chr_id = p_chr_id
AND cle_sl.cle_id = cle.id
AND cle_sl.lse_id = lse_sl.id
AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
SELECT rl.id,
rl.rule_information6 payment_amount
FROM okc_rule_groups_b rg,
okc_rules_b rl,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = p_cle_id
AND cle.lse_id = lse.id
AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
AND lse.lse_type = G_TLS_TYPE
AND cle.cle_id IS NULL
AND rg.dnz_chr_id = cle.dnz_chr_id
AND rg.cle_id = cle.id
AND rg.chr_id IS NULL
AND rg.id = rl.rgp_id
AND rg.rgd_code = 'LALEVL'
AND rl.rule_information_category = 'LASLL'
AND exists (SELECT '1'
FROM okc_k_lines_v cle_sl,
okc_line_styles_b lse_sl
WHERE cle_sl.dnz_chr_id = p_chr_id
AND cle_sl.cle_id = cle.id
AND cle_sl.lse_id = lse_sl.id
AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
SELECT rl.id,
cle.currency_code
FROM okc_rule_groups_b rg,
okc_rules_b rl,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = p_cle_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_SER_LINE_LTY_CODE
AND lse.lse_type = G_TLS_TYPE
AND cle.cle_id IS NULL
AND rg.dnz_chr_id = cle.dnz_chr_id
AND rg.cle_id = cle.id
AND rg.chr_id IS NULL
AND rg.id = rl.rgp_id
AND rg.rgd_code = 'LAFEXP'
AND rl.rule_information_category = 'LAFEXP';
SELECT crl.RULE_INFORMATION1,
crl.RULE_INFORMATION2
FROM OKC_RULE_GROUPS_B crg,
OKC_RULES_B crl
WHERE crl.rgp_id = crg.id
AND crg.RGD_CODE = p_rgd_code
AND crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
AND crg.dnz_chr_id = p_chr_id
AND NVL(crg.cle_id,-1) = p_cle_id;
SELECT cle.id id,
NVL(kle.amount,0) amount
FROM okl_k_lines_v kle,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = kle.id
AND cle.lse_id = lse.id
AND lse.lty_code = G_SER_LINE_LTY_CODE
AND lse.lse_type = G_TLS_TYPE
AND cle.cle_id IS NULL;
SELECT cle.id id,
NVL(kle.amount,0) amount
FROM okl_k_lines_v kle,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_old_chr_id
AND cle.id = kle.id
AND cle.lse_id = lse.id
AND lse.lty_code = 'SOLD_SERVICE'
AND lse.lse_type = 'TLS'
AND cle.cle_id IS NULL
AND cle.id = (SELECT klfv.ORIG_SYSTEM_ID1
FROM okl_k_lines_full_v klfv
WHERE klfv.id = p_new_cle_id
AND klfv.dnz_chr_id = p_new_chr_id);
SELECT rl.id,
rl.rule_information2,
rl.rule_information3,
rl.rule_information6,
rl.rule_information7,
rl.rule_information8,
cle.currency_code
FROM okc_rule_groups_b rg,
okc_rules_b rl,
okc_k_lines_v cle,
okc_line_styles_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = p_cle_id
AND cle.lse_id = lse.id
AND cle.cle_id IS NULL
AND rg.dnz_chr_id = cle.dnz_chr_id
AND rg.cle_id = cle.id
AND rg.id = rl.rgp_id
AND rg.rgd_code = p_rgd_code
AND rl.rule_information_category = p_rgp_cat;
/*SELECT crl.id,
crl.RULE_INFORMATION3,
crl.RULE_INFORMATION6
FROM OKC_RULE_GROUPS_B crg,
OKC_RULES_B crl
WHERE crl.rgp_id = crg.id
and crg.RGD_CODE = p_rgd_code
and crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
and crg.dnz_chr_id = p_chr_id
and nvl(crg.cle_id,-1) = p_cle_id; */
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => r_get_item_info_tls.id);
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => r_get_item_info.id);
OKL_CONTRACT_PUB.update_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_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,
p_klev_rec => l_klev_rec,
x_clev_rec => lx_clev_rec,
x_klev_rec => lx_klev_rec);
OKL_RULE_PUB.update_rule(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => l_rulv_rec,
x_rulv_rec => lx_rulv_rec);
OKL_RULE_PUB.update_rule(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => lp_rulv_rec,
x_rulv_rec => lx_rulv_rec);
OKL_RULE_PUB.update_rule(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => l_rulv_rec,
x_rulv_rec => lx_rulv_rec);
OKL_RULE_PUB.update_rule(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => l_rulv_rec,
x_rulv_rec => lx_rulv_rec);
OKL_CONTRACT_PUB.update_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_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,
p_klev_rec => l_klev_rec,
x_clev_rec => lx_clev_rec,
x_klev_rec => lx_klev_rec);
OKL_RULE_PUB.update_rule(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => r_rulv_rec,
x_rulv_rec => rx_rulv_rec);
SELECT object1_id1 service_contract_id
FROM okc_k_rel_objs_v rel
WHERE rel.chr_id = P_chr_id;
SELECT '1'
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKC_K_LINES_B cle,
OKC_LINE_STYLES_b lse
WHERE cle.dnz_chr_id = p_chr_id
AND lse.id = cle.lse_id
AND lse.lty_code IN (G_USG_LINE_LTY_CODE,
G_USL_LINE_LTY_CODE));
SELECT 1
FROM dual
WHERE EXISTS (SELECT 1
FROM okl_trx_contracts trx,
okl_trx_types_tl try,
okl_k_headers khr
WHERE try.name = 'Split Contract'
AND try.LANGUAGE = 'US'
AND trx.try_id = try.id
--rkuttiya added for 12.1.1 Multi GAAP
AND trx.representation_type = 'PRIMARY'
--
AND trx.tsu_code = 'ENTERED'
AND khr.id = trx.khr_id
AND trx.khr_id = p_chr_id);
SELECT orig_system_id1
FROM okc_k_headers_b
WHERE id = p_chr_id
AND orig_system_source_code = 'OKL_SPLIT';
SELECT CHR.id chr_id,
sts_code sts_code,
trx.id trx_id
FROM okl_trx_contracts trx,
okl_trx_types_tl try,
okc_k_headers_b CHR
WHERE try.name = 'Split Contract'
AND try.LANGUAGE = 'US'
AND trx.try_id = try.id
AND trx.tsu_code = 'ENTERED'
AND trx.khr_id = CHR.orig_system_id1
--rkuttiya added for 12.1.1 Multi GAAP
AND trx.representation_type = 'PRIMARY'
--
AND CHR.orig_system_source_code = 'OKL_SPLIT'
AND CHR.orig_system_id1= p_chr_id;
SELECT orig_system_id1 orig_cle_fa,
txl.tas_id tas_id_fa,
cle.id id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse,
OKL_TXL_ASSETS_B txl
WHERE cle.dnz_chr_id = p_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FA_LINE_LTY_CODE
AND cle.id = txl.kle_id;
SELECT orig_system_id1 orig_cle_ib,
iti.tas_id tas_id_ib,
cle.id id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse,
OKL_TXL_ITM_INSTS iti
WHERE cle.dnz_chr_id = p_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_IB_LINE_LTY_CODE
AND cle.id = iti.kle_id;
SELECT object1_id1,
object1_id2
FROM okc_k_items
WHERE cle_id = p_orig_cle_id
AND dnz_chr_Id = p_orig_chr_id;
SELECT KHR.ID, KHR.CONTRACT_NUMBER, KHR.START_DATE, TRX.DATE_TRANSACTION_OCCURRED
FROM OKC_K_HEADERS_B KHR,
OKL_TRX_CONTRACTS TRX
WHERE TRX.KHR_ID = KHR.ID
AND TRX.TSU_CODE = 'PROCESSED'
AND TRX.TCN_TYPE = 'SPLC'
--rkuttiya added for 12.1.1 Multi GAAP
AND TRX.REPRESENTATION_TYPE = 'PRIMARY'
--
AND KHR.ID = p_chr_id;
OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec,
x_cimv_rec => lx_cimv_rec);
OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thpv_rec => l_trxv_rec,
x_thpv_rec => lx_trxv_rec);
OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec,
x_cimv_rec => lx_cimv_rec);
OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thpv_rec => l_trxv_rec,
x_thpv_rec => lx_trxv_rec);
OKL_CONTRACT_STATUS_PUB.update_contract_status(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => 'BOOKED',
p_chr_id => p_chr_id);
FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'OKL_CONTRACT_STATUS_PUB.update_contract_status
procedure finished with status ' || x_return_status || ' in
split_contract_after_yield procedure');
Okl_Trx_Contracts_Pub.update_trx_contracts(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => l_tcnv_rec,
x_tcnv_rec => lx_tcnv_rec);
OKL_CONTRACT_STATUS_PUB.update_contract_status(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => 'AMENDED',
p_chr_id => ln_orig_system_id1);
OKL_CONTRACT_STATUS_PUB.update_contract_status(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => 'AMENDED',
p_chr_id => ln_service_id);
SELECT id
FROM OKC_K_HEADERS_V
WHERE contract_number = p_contract_number;
SELECT contract_number
FROM OKC_K_HEADERS_V
WHERE id = p_header_id;
SELECT COUNT(cle.id)
FROM OKC_SUBCLASS_TOP_LINE stl,
OKC_LINE_STYLES_V lse,
OKC_K_LINES_V cle,
OKC_K_HEADERS_V chrv
WHERE chrv.contract_number = p_contract_number
AND chrv.id = cle.dnz_chr_id
AND cle.cle_id IS NULL
AND cle.chr_id = chrv.id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FIN_LINE_LTY_CODE
AND lse.lse_type = G_TLS_TYPE
AND lse.lse_parent_id IS NULL
AND lse.id = stl.lse_id
AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
l_update_contract_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chrv_rec => l_chrv_rec,
p_khrv_rec => l_khrv_rec,
x_chrv_rec => lx_chrv_rec,
x_khrv_rec => lx_khrv_rec);
SELECT a.id,
a.sis_code,
h.sts_code
FROM okl_stream_interfaces a,
okc_k_headers_b h
WHERE a.khr_id = p_khr_id
AND h.id = a.khr_id
AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))
FROM okl_stream_interfaces b
WHERE b.khr_id = p_khr_id);
SELECT NVL(SUBSTRB(TRANSLATE(LTRIM(value),',',' '), 1,
INSTR(TRANSLATE(LTRIM(value),',',' '),' ') - 1),value)
FROM v$parameter
WHERE name = 'utl_file_dir';
SELECT sts_code
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT contract_number
FROM okc_k_headers_b
WHERE id = (SELECT ORIG_SYSTEM_ID1
FROM okc_k_headers_b
WHERE id = p_khr_id);
SELECT a.sis_code,
h.sts_code
FROM okl_stream_interfaces a,
okc_k_headers_b h
WHERE a.id = p_stream_id
AND a.khr_id = p_khr_id
AND h.id = a.khr_id
AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))
FROM okl_stream_interfaces b
WHERE b.khr_id = p_khr_id);
SELECT id
FROM OKL_TXL_CNTRCT_LNS
WHERE khr_id = p_khr_id;
SELECT authoring_org_id
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT chrb.orig_system_id1 old_chr_id
,trxb.date_transaction_occurred date_transaction_occurred
FROM okc_k_headers_b chrb
,okl_trx_contracts trxb
,okl_trx_types_b tryv
WHERE chrb.id = p_khr_id
-- AND trxb.khr_id_old = chrb.orig_system_id1
AND trxb.khr_id = chrb.id
AND trxb.tsu_code = 'PROCESSED'
AND trxb.try_id = tryv.id;
SELECT chrb.orig_system_id1 old_chr_id
,trxb2.date_transaction_occurred date_transaction_occurred
FROM okc_k_headers_b chrb
,okl_trx_contracts trxb1
,okl_trx_types_b tryv
,okl_trx_contracts trxb2
WHERE chrb.id = p_khr_id
AND trxb1.khr_id = chrb.id
AND trxb1.tsu_code = 'PROCESSED'
--rkuttiya added for 12.1.1 MUlti GAAP
AND trxb1.representation_type = 'PRIMARY'
--
AND trxb1.try_id = tryv.id
AND trxb2.khr_id = chrb.orig_system_id1
AND trxb2.TCN_TYPE = 'SPLC'
AND trxb2.tsu_code = 'PROCESSED'
AND trxb2.try_id = tryv.id;
l_delete_fee_service_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_new2_contract_id);
FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'l_delete_fee_service_lines procedure completed with '
|| x_return_status || ' for second Split contract');
OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_source_id => r_get_source_id.id,
p_source_table => 'OKL_TXL_CNTRCT_LNS');
FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL
procedure completed for first contract with status ' || x_return_status);
OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_source_id => r_get_source_id.id,
p_source_table => 'OKL_TXL_CNTRCT_LNS');
FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL
procedure completed for second contract with status ' || x_return_status);
l_delete_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_new1_contract_id);
l_delete_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_new2_contract_id);
l_delete_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_new1_contract_id);
l_delete_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_new2_contract_id);
l_delete_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_new1_contract_id);
l_delete_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_new2_contract_id);