The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT OKL_TRX_CONTRACTS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;
SELECT
ID,
KHR_ID_NEW,
PVN_ID,
PDT_ID,
RBR_CODE,
RPY_CODE,
RVN_CODE,
TRN_CODE,
QTE_ID,
AES_ID,
CODE_COMBINATION_ID,
TCN_TYPE,
RJN_CODE,
PARTY_REL_ID1_OLD,
PARTY_REL_ID2_OLD,
PARTY_REL_ID1_NEW,
PARTY_REL_ID2_NEW,
COMPLETE_TRANSFER_YN,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
DATE_ACCRUAL,
ACCRUAL_STATUS_YN,
UPDATE_STATUS_YN,
ORG_ID,
KHR_ID,
TAX_DEDUCTIBLE_LOCAL,
tax_deductible_corporate,
AMOUNT,
REQUEST_ID,
CURRENCY_CODE,
PROGRAM_APPLICATION_ID,
KHR_ID_OLD,
PROGRAM_ID,
PROGRAM_update_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
LAST_UPDATE_LOGIN,
TRY_ID,
TSU_CODE,
SET_OF_BOOKS_ID,
DESCRIPTION,
DATE_TRANSACTION_OCCURRED,
TRX_NUMBER,
TMT_EVERGREEN_YN,
TMT_CLOSE_BALANCES_YN,
TMT_ACCOUNTING_ENTRIES_YN,
TMT_CANCEL_INSURANCE_YN,
TMT_ASSET_DISPOSITION_YN,
TMT_AMORTIZATION_YN,
TMT_ASSET_RETURN_YN,
TMT_CONTRACT_UPDATED_YN,
TMT_RECYCLE_YN,
TMT_VALIDATED_YN,
TMT_STREAMS_UPDATED_YN ,
ACCRUAL_ACTIVITY,
-- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
TMT_SPLIT_ASSET_YN,
TMT_GENERIC_FLAG1_YN,
TMT_GENERIC_FLAG2_YN,
TMT_GENERIC_FLAG3_YN,
-- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_DATE,
-- Added by Keerthi for Service Contracts
CHR_ID ,
-- Added by Keerthi for Bug No 3195713
SOURCE_TRX_ID,
SOURCE_TRX_TYPE,
-- Added by kmotepal for bug 3621485
CANCELED_DATE,
--Added by dpsingh for LE Uptake
LEGAL_ENTITY_ID,
--Added by dpsingh for SLA Uptake (Bug 5707866)
ACCRUAL_REVERSAL_DATE,
-- Added by DJANASWA for SLA project
ACCOUNTING_REVERSAL_YN,
-- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
PRODUCT_NAME,
BOOK_CLASSIFICATION_CODE,
TAX_OWNER_CODE,
TMT_STATUS_CODE,
REPRESENTATION_NAME,
REPRESENTATION_CODE,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
UPGRADE_STATUS_FLAG,
-- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
TRANSACTION_DATE,
-- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
primary_rep_trx_id,
REPRESENTATION_TYPE,
-- Added by sosharma for Income Account recon-report 01-Nov-2008
TRANSACTION_REVERSAL_DATE
FROM OKL_TRX_CONTRACTS
WHERE OKL_TRX_CONTRACTS.id = p_id;
l_tcn_rec.LAST_UPDATED_BY,
l_tcn_rec.LAST_UPDATE_DATE,
l_tcn_rec.DATE_ACCRUAL,
l_tcn_rec.ACCRUAL_STATUS_YN,
l_tcn_rec.UPDATE_STATUS_YN,
l_tcn_rec.ORG_ID,
l_tcn_rec.KHR_ID,
l_tcn_rec.TAX_DEDUCTIBLE_LOCAL,
l_tcn_rec.tax_deductible_corporate,
l_tcn_rec.AMOUNT,
l_tcn_rec.REQUEST_ID,
l_tcn_rec.currency_code,
l_tcn_rec.PROGRAM_APPLICATION_ID,
l_tcn_rec.KHR_ID_OLD,
l_tcn_rec.PROGRAM_ID,
l_tcn_rec.PROGRAM_update_DATE,
l_tcn_rec.ATTRIBUTE_CATEGORY,
l_tcn_rec.ATTRIBUTE1,
l_tcn_rec.ATTRIBUTE2,
l_tcn_rec.ATTRIBUTE3,
l_tcn_rec.ATTRIBUTE4,
l_tcn_rec.ATTRIBUTE5,
l_tcn_rec.ATTRIBUTE6,
l_tcn_rec.ATTRIBUTE7,
l_tcn_rec.ATTRIBUTE8,
l_tcn_rec.ATTRIBUTE9,
l_tcn_rec.ATTRIBUTE10,
l_tcn_rec.ATTRIBUTE11,
l_tcn_rec.ATTRIBUTE12,
l_tcn_rec.ATTRIBUTE13,
l_tcn_rec.ATTRIBUTE14,
l_tcn_rec.ATTRIBUTE15,
l_tcn_rec.LAST_UPDATE_LOGIN,
l_tcn_rec.TRY_ID,
l_tcn_rec.TSU_CODE,
l_tcn_rec.SET_OF_BOOKS_ID,
l_tcn_rec.DESCRIPTION,
l_tcn_rec.DATE_TRANSACTION_OCCURRED,
l_tcn_rec.TRX_NUMBER ,
l_tcn_rec.TMT_EVERGREEN_YN ,
l_tcn_rec.TMT_CLOSE_BALANCES_YN ,
l_tcn_rec.TMT_ACCOUNTING_ENTRIES_YN ,
l_tcn_rec.TMT_CANCEL_INSURANCE_YN ,
l_tcn_rec.TMT_ASSET_DISPOSITION_YN ,
l_tcn_rec.TMT_AMORTIZATION_YN ,
l_tcn_rec.TMT_ASSET_RETURN_YN ,
l_tcn_rec.TMT_CONTRACT_UPDATED_YN ,
l_tcn_rec.TMT_RECYCLE_YN ,
l_tcn_rec.TMT_VALIDATED_YN ,
l_tcn_rec.TMT_STREAMS_UPDATED_YN,
l_tcn_rec.ACCRUAL_ACTIVITY,
-- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
l_tcn_rec.TMT_SPLIT_ASSET_YN,
l_tcn_rec.TMT_GENERIC_FLAG1_YN,
l_tcn_rec.TMT_GENERIC_FLAG2_YN,
l_tcn_rec.TMT_GENERIC_FLAG3_YN ,
-- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
l_tcn_rec.CURRENCY_CONVERSION_TYPE,
l_tcn_rec.CURRENCY_CONVERSION_RATE,
l_tcn_rec.CURRENCY_CONVERSION_DATE,
-- Added by Keerthi 04-SEP-2003.
l_tcn_rec.CHR_ID,
-- Added by Keerthi for Bug No 3195713
l_tcn_rec.SOURCE_TRX_ID,
l_tcn_rec.SOURCE_TRX_TYPE,
-- Added by kmotepal for Bug No 3621485
l_tcn_rec.CANCELED_DATE,
---- Added by dpsingh for LE Uptake
l_tcn_rec.LEGAL_ENTITY_ID,
--Added by dpsingh for SLA Uptake (Bug 5707866)
l_tcn_rec.ACCRUAL_REVERSAL_DATE,
-- Added by DJANASWA for SLA project
l_tcn_rec.ACCOUNTING_REVERSAL_YN,
-- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
l_tcn_rec.PRODUCT_NAME,
l_tcn_rec.BOOK_CLASSIFICATION_CODE,
l_tcn_rec.TAX_OWNER_CODE,
l_tcn_rec.TMT_STATUS_CODE,
l_tcn_rec.REPRESENTATION_NAME,
l_tcn_rec.REPRESENTATION_CODE,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
l_tcn_rec.UPGRADE_STATUS_FLAG,
-- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
l_tcn_rec.TRANSACTION_DATE,
-- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
l_tcn_rec.primary_rep_trx_id,
l_tcn_rec.REPRESENTATION_TYPE,
-- Added by sosharma for Income Account recon- report 01-Nov-2008
l_tcn_rec.TRANSACTION_REVERSAL_DATE;
SELECT
ID,
OBJECT_VERSION_NUMBER,
RBR_CODE,
RPY_CODE,
RVN_CODE,
TRN_CODE,
KHR_ID_NEW,
PVN_ID,
PDT_ID,
QTE_ID,
AES_ID,
CODE_COMBINATION_ID,
TAX_DEDUCTIBLE_LOCAL,
tax_deductible_corporate,
DATE_ACCRUAL,
ACCRUAL_STATUS_YN,
UPDATE_STATUS_YN,
AMOUNT,
CURRENCY_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
TCN_TYPE,
RJN_CODE,
PARTY_REL_ID1_OLD,
PARTY_REL_ID2_OLD,
PARTY_REL_ID1_NEW,
PARTY_REL_ID2_NEW,
COMPLETE_TRANSFER_YN,
ORG_ID,
KHR_ID,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
KHR_ID_OLD,
PROGRAM_ID,
PROGRAM_update_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
TRY_ID,
TSU_CODE,
SET_OF_BOOKS_ID,
DESCRIPTION,
DATE_TRANSACTION_OCCURRED,
TRX_NUMBER,
TMT_EVERGREEN_YN,
TMT_CLOSE_BALANCES_YN,
TMT_ACCOUNTING_ENTRIES_YN,
TMT_CANCEL_INSURANCE_YN,
TMT_ASSET_DISPOSITION_YN,
TMT_AMORTIZATION_YN,
TMT_ASSET_RETURN_YN,
TMT_CONTRACT_UPDATED_YN,
TMT_RECYCLE_YN,
TMT_VALIDATED_YN,
TMT_STREAMS_UPDATED_YN ,
accrual_activity,
-- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
TMT_SPLIT_ASSET_YN,
TMT_GENERIC_FLAG1_YN,
TMT_GENERIC_FLAG2_YN,
TMT_GENERIC_FLAG3_YN,
-- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_DATE,
-- Added by Keerthi 04-SEP-2003 Sevice Contracts
CHR_ID ,
-- Added by Keerthi for Bug No 3195713
SOURCE_TRX_ID,
SOURCE_TRX_TYPE,
-- Added by kmotepal for Bug 3621485
CANCELED_DATE,
--Added by dpsingh for LE Uptake
LEGAL_ENTITY_ID,
--Added by dpsingh for SLA Uptake (Bug 5707866)
ACCRUAL_REVERSAL_DATE,
-- Added by DJANASWA for SLA project
ACCOUNTING_REVERSAL_YN,
-- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
PRODUCT_NAME,
BOOK_CLASSIFICATION_CODE,
TAX_OWNER_CODE,
TMT_STATUS_CODE,
REPRESENTATION_NAME,
REPRESENTATION_CODE,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
UPGRADE_STATUS_FLAG,
-- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
TRANSACTION_DATE,
-- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
primary_rep_trx_id,
REPRESENTATION_TYPE,
-- Added by sosharma for Income Account recon- report 01-Nov-2008
TRANSACTION_REVERSAL_DATE
FROM OKL_TRX_CONTRACTS
WHERE OKL_TRX_CONTRACTS.id = p_id;
l_tcnv_rec.UPDATE_STATUS_YN,
l_tcnv_rec.AMOUNT,
l_tcnv_rec.currency_code,
l_tcnv_rec.ATTRIBUTE_CATEGORY,
l_tcnv_rec.ATTRIBUTE1,
l_tcnv_rec.ATTRIBUTE2,
l_tcnv_rec.ATTRIBUTE3,
l_tcnv_rec.ATTRIBUTE4,
l_tcnv_rec.ATTRIBUTE5,
l_tcnv_rec.ATTRIBUTE6,
l_tcnv_rec.ATTRIBUTE7,
l_tcnv_rec.ATTRIBUTE8,
l_tcnv_rec.ATTRIBUTE9,
l_tcnv_rec.ATTRIBUTE10,
l_tcnv_rec.ATTRIBUTE11,
l_tcnv_rec.ATTRIBUTE12,
l_tcnv_rec.ATTRIBUTE13,
l_tcnv_rec.ATTRIBUTE14,
l_tcnv_rec.ATTRIBUTE15,
l_tcnv_rec.TCN_TYPE,
l_tcnv_rec.RJN_CODE,
l_tcnv_rec.PARTY_REL_ID1_OLD,
l_tcnv_rec.PARTY_REL_ID2_OLD,
l_tcnv_rec.PARTY_REL_ID1_NEW,
l_tcnv_rec.PARTY_REL_ID2_NEW,
l_tcnv_rec.COMPLETE_TRANSFER_YN,
l_tcnv_rec.ORG_ID,
l_tcnv_rec.KHR_ID,
l_tcnv_rec.REQUEST_ID,
l_tcnv_rec.PROGRAM_APPLICATION_ID,
l_tcnv_rec.KHR_ID_OLD,
l_tcnv_rec.PROGRAM_ID,
l_tcnv_rec.PROGRAM_update_DATE,
l_tcnv_rec.CREATED_BY,
l_tcnv_rec.CREATION_DATE,
l_tcnv_rec.LAST_UPDATED_BY,
l_tcnv_rec.LAST_UPDATE_DATE,
l_tcnv_rec.LAST_UPDATE_LOGIN,
l_tcnv_rec.TRY_ID,
l_tcnv_rec.TSU_CODE,
l_tcnv_rec.SET_OF_BOOKS_ID,
l_tcnv_rec.DESCRIPTION,
l_tcnv_rec.DATE_TRANSACTION_OCCURRED,
l_tcnv_rec.TRX_NUMBER,
l_tcnv_rec.TMT_EVERGREEN_YN ,
l_tcnv_rec.TMT_CLOSE_BALANCES_YN ,
l_tcnv_rec.TMT_ACCOUNTING_ENTRIES_YN ,
l_tcnv_rec.TMT_CANCEL_INSURANCE_YN ,
l_tcnv_rec.TMT_ASSET_DISPOSITION_YN ,
l_tcnv_rec.TMT_AMORTIZATION_YN ,
l_tcnv_rec.TMT_ASSET_RETURN_YN ,
l_tcnv_rec.TMT_CONTRACT_UPDATED_YN ,
l_tcnv_rec.TMT_RECYCLE_YN ,
l_tcnv_rec.TMT_VALIDATED_YN ,
l_tcnv_rec.TMT_STREAMS_UPDATED_YN,
l_tcnv_rec.accrual_activity,
-- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
l_tcnv_rec.TMT_SPLIT_ASSET_YN,
l_tcnv_rec.TMT_GENERIC_FLAG1_YN,
l_tcnv_rec.TMT_GENERIC_FLAG2_YN,
l_tcnv_rec.TMT_GENERIC_FLAG3_YN,
-- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
l_tcnv_rec.CURRENCY_CONVERSION_TYPE,
l_tcnv_rec.CURRENCY_CONVERSION_RATE,
l_tcnv_rec.CURRENCY_CONVERSION_DATE,
-- Added by Keerthi 04-SEP-2003
l_tcnv_rec.CHR_ID,
-- Added by Keerthi for Bug No 3195713
l_tcnv_rec.SOURCE_TRX_ID,
l_tcnv_rec.SOURCE_TRX_TYPE,
-- Added by kmotepal for Bug 3621485
l_tcnv_rec.CANCELED_DATE,
--Added by dpsingh for LE Uptake
l_tcnv_rec.LEGAL_ENTITY_ID,
--Added by dpsingh for SLA Uptake (Bug 5707866)
l_tcnv_rec.ACCRUAL_REVERSAL_DATE,
l_tcnv_rec.ACCOUNTING_REVERSAL_YN,
-- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
l_tcnv_rec.PRODUCT_NAME,
l_tcnv_rec.BOOK_CLASSIFICATION_CODE,
l_tcnv_rec.TAX_OWNER_CODE,
l_tcnv_rec.TMT_STATUS_CODE,
l_tcnv_rec.REPRESENTATION_NAME,
l_tcnv_rec.REPRESENTATION_CODE,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
l_tcnv_rec.UPGRADE_STATUS_FLAG,
-- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
l_tcnv_rec.TRANSACTION_DATE,
-- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
l_tcnv_rec.primary_rep_trx_id,
l_tcnv_rec.REPRESENTATION_TYPE,
-- Added by sosharma for Income Account recon- report 01-Nov-2008
l_tcnv_rec.TRANSACTION_REVERSAL_DATE;
IF (l_tcnv_rec.update_status_yn = Okc_Api.G_MISS_CHAR) THEN
l_tcnv_rec.update_status_yn := NULL;
IF (l_tcnv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
l_tcnv_rec.program_update_date := NULL;
IF (l_tcnv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
l_tcnv_rec.last_updated_by := NULL;
IF (l_tcnv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
l_tcnv_rec.last_update_date := NULL;
IF (l_tcnv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
l_tcnv_rec.last_update_login := NULL;
IF (l_tcnv_rec.tmt_contract_updated_yn = Okc_Api.G_MISS_CHAR) THEN
l_tcnv_rec.tmt_contract_updated_yn := NULL;
IF (l_tcnv_rec.tmt_streams_updated_yn = Okc_Api.G_MISS_CHAR) THEN
l_tcnv_rec.tmt_streams_updated_yn := NULL;
SELECT '1'
FROM Okl_K_Headers_V
WHERE okl_k_headers_v.id = p_id;
SELECT '1'
FROM Okl_K_Headers_V
WHERE okl_k_headers_v.id = p_id;
SELECT '1'
FROM Okl_K_Headers_V
WHERE okl_k_headers_v.id = p_id;
SELECT '1'
FROM OKL_PROVISIONS_V
WHERE ID = v_pvn_id;
SELECT '1'
FROM OKL_PRODUCTS_V
WHERE ID = v_pdt_id;
SELECT '1'
FROM OKL_TRX_QUOTES_V
WHERE ID = v_qte_id;
SELECT '1'
FROM OKL_AE_TMPT_SETS_V
WHERE ID = v_aes_id;
PROCEDURE Validate_Update_Status_YN(p_tcnv_rec IN tcnv_rec_type
,x_return_status OUT NOCOPY VARCHAR2)
IS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
IF (p_tcnv_rec.update_status_yn IS NOT NULL) AND
(p_tcnv_rec.update_status_yn <> Okc_Api.G_MISS_CHAR) THEN
-- check in fnd_lookups for validity
l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
(p_lookup_type => 'YES_NO',
p_lookup_code => p_tcnv_rec.update_status_yn,
p_app_id => l_app_id,
p_view_app_id => l_view_app_id);
,p_token1_value => 'update_status_yn');
END Validate_Update_Status_YN;
SELECT '1'
FROM OKL_TRX_TYPES_V
WHERE ID = v_try_id;
SELECT trx_number
FROM OKL_TRX_CONTRACTS
WHERE trx_number = v_trx_number
and representation_code = v_rep_code
AND id <> v_id;
IF (p_tcnv_rec.TMT_CONTRACT_UPDATED_YN IS NOT NULL) AND
(p_tcnv_rec.TMT_CONTRACT_UPDATED_YN <> Okc_Api.G_MISS_CHAR) THEN
l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
(p_lookup_type => 'YES_NO',
p_lookup_code => p_tcnv_rec.TMT_CONTRACT_UPDATED_YN,
p_app_id => l_app_id,
p_view_app_id => l_view_app_id);
,p_token1_value => 'TMT_CONTRACT_UPDATED_YN');
IF (p_tcnv_rec.TMT_STREAMS_UPDATED_YN IS NOT NULL) AND
(p_tcnv_rec.TMT_STREAMS_UPDATED_YN <> Okc_Api.G_MISS_CHAR) THEN
l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
(p_lookup_type => 'YES_NO',
p_lookup_code => p_tcnv_rec.TMT_STREAMS_UPDATED_YN,
p_app_id => l_app_id,
p_view_app_id => l_view_app_id);
,p_token1_value => 'TMT_STREAMS_UPDATED_YN');
SELECT '1'
FROM Okc_k_headers_b
WHERE okc_k_headers_b.id = p_id;
SELECT '1'
FROM okl_trx_contracts otc
WHERE otc.id = p_source_id;
SELECT '1'
FROM okl_trx_assets ota
WHERE ota.id = p_source_id;
SELECT '1'
FROM okl_trx_quotes_b qte
WHERE qte.id = p_source_id;
SELECT '1'
FROM okl_trx_contracts
WHERE okl_trx_contracts.id = p_id
AND okl_trx_contracts.primary_rep_trx_id is null
and okl_trx_contracts.khr_id = p_chr_id;
SELECT '1'
from fnd_lookups lkp
where lkp.lookup_type = 'OKL_REPRESENTATION_TYPE'
and lkp.lookup_code = p_rep_code;
SELECT '1'
FROM gl_ledgers
WHERE name = p_rep_name
AND short_name = p_rep_code;
SELECT '1'
FROM gl_sets_of_books_11i
WHERE name = p_rep_name
AND short_name = p_rep_code;
Validate_Update_Status_YN(p_tcnv_rec, x_return_status);
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.update_status_yn := p_from.update_status_yn;
p_to.program_update_date := p_from.program_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.tmt_contract_updated_yn := p_from.tmt_contract_updated_yn;
p_to.tmt_streams_updated_yn := p_from.tmt_streams_updated_yn;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.update_status_yn := p_from.update_status_yn;
p_to.program_update_date := p_from.program_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.tmt_contract_updated_yn := p_from.tmt_contract_updated_yn;
p_to.tmt_streams_updated_yn := p_from.tmt_streams_updated_yn;
PROCEDURE insert_row(
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_tcn_rec IN tcn_rec_type,
x_tcn_rec OUT NOCOPY tcn_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'CONTRACTS_insert_row';
INSERT INTO OKL_TRX_CONTRACTS(
id,
khr_id_new,
pvn_id,
pdt_id,
rbr_code,
rpy_code,
rvn_code,
trn_code,
qte_id,
aes_id,
code_combination_id,
tcn_type,
RJN_CODE,
PARTY_REL_ID1_OLD,
PARTY_REL_ID2_OLD,
PARTY_REL_ID1_NEW,
PARTY_REL_ID2_NEW,
COMPLETE_TRANSFER_YN,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
date_accrual,
accrual_status_yn,
update_status_yn,
org_id,
khr_id,
tax_deductible_local,
tax_deductible_corporate,
amount,
request_id,
currency_CODE,
program_application_id,
khr_id_old,
program_id,
program_update_date,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
last_update_login,
try_id,
tsu_code,
set_of_books_id,
description,
date_transaction_occurred,
trx_number,
TMT_EVERGREEN_YN,
TMT_CLOSE_BALANCES_YN,
TMT_ACCOUNTING_ENTRIES_YN,
TMT_CANCEL_INSURANCE_YN,
TMT_ASSET_DISPOSITION_YN,
TMT_AMORTIZATION_YN,
TMT_ASSET_RETURN_YN,
TMT_CONTRACT_UPDATED_YN,
TMT_RECYCLE_YN,
TMT_VALIDATED_YN,
TMT_STREAMS_UPDATED_YN,
accrual_activity,
-- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
TMT_SPLIT_ASSET_YN,
TMT_GENERIC_FLAG1_YN,
TMT_GENERIC_FLAG2_YN,
TMT_GENERIC_FLAG3_YN,
-- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_DATE,
CHR_ID,
-- Added by Keerthi for Bug No 3195713
SOURCE_TRX_ID,
SOURCE_TRX_TYPE,
-- Added by kmotepal for Bug 3621485
CANCELED_DATE,
--Added by dpsingh for LE Uptake
LEGAL_ENTITY_ID,
--Added by dpsingh for SLA Uptake (Bug 5707866)
ACCRUAL_REVERSAL_DATE,
-- Added by DJANASWA for SLA project
ACCOUNTING_REVERSAL_YN,
-- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
product_name,
BOOK_CLASSIFICATION_CODE,
TAX_OWNER_CODE,
TMT_STATUS_CODE,
REPRESENTATION_NAME,
REPRESENTATION_CODE,
-- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
UPGRADE_STATUS_FLAG,
-- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
TRANSACTION_DATE,
-- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
primary_rep_trx_id,
REPRESENTATION_TYPE,
-- Added by sosharma for Income Account recon- report 01-Nov-2008
TRANSACTION_REVERSAL_DATE
)
VALUES (
l_tcn_rec.id,
l_tcn_rec.khr_id_new,
l_tcn_rec.pvn_id,
l_tcn_rec.pdt_id,
l_tcn_rec.rbr_code,
l_tcn_rec.rpy_code,
l_tcn_rec.rvn_code,
l_tcn_rec.trn_code,
l_tcn_rec.qte_id,
l_tcn_rec.aes_id,
l_tcn_rec.code_combination_id,
l_tcn_rec.tcn_type,
l_tcn_rec.RJN_CODE,
l_tcn_rec.PARTY_REL_ID1_OLD,
l_tcn_rec.PARTY_REL_ID2_OLD,
l_tcn_rec.PARTY_REL_ID1_NEW,
l_tcn_rec.PARTY_REL_ID2_NEW,
l_tcn_rec.COMPLETE_TRANSFER_YN,
l_tcn_rec.object_version_number,
l_tcn_rec.created_by,
l_tcn_rec.creation_date,
l_tcn_rec.last_updated_by,
l_tcn_rec.last_update_date,
l_tcn_rec.date_accrual,
l_tcn_rec.accrual_status_yn,
l_tcn_rec.update_status_yn,
l_tcn_rec.org_id,
l_tcn_rec.khr_id,
l_tcn_rec.tax_deductible_local,
l_tcn_rec.tax_deductible_corporate,
l_tcn_rec.amount,
l_tcn_rec.request_id,
l_tcn_rec.currency_code,
l_tcn_rec.program_application_id,
l_tcn_rec.khr_id_old,
l_tcn_rec.program_id,
l_tcn_rec.program_update_date,
l_tcn_rec.attribute_category,
l_tcn_rec.attribute1,
l_tcn_rec.attribute2,
l_tcn_rec.attribute3,
l_tcn_rec.attribute4,
l_tcn_rec.attribute5,
l_tcn_rec.attribute6,
l_tcn_rec.attribute7,
l_tcn_rec.attribute8,
l_tcn_rec.attribute9,
l_tcn_rec.attribute10,
l_tcn_rec.attribute11,
l_tcn_rec.attribute12,
l_tcn_rec.attribute13,
l_tcn_rec.attribute14,
l_tcn_rec.attribute15,
l_tcn_rec.last_update_login,
l_tcn_rec.try_id,
l_tcn_rec.tsu_code,
l_tcn_rec.set_of_books_id,
l_tcn_rec.description,
l_tcn_rec.date_transaction_occurred,
l_tcn_rec.trx_number,
l_tcn_rec.TMT_EVERGREEN_YN ,
l_tcn_rec.TMT_CLOSE_BALANCES_YN ,
l_tcn_rec.TMT_ACCOUNTING_ENTRIES_YN ,
l_tcn_rec.TMT_CANCEL_INSURANCE_YN ,
l_tcn_rec.TMT_ASSET_DISPOSITION_YN ,
l_tcn_rec.TMT_AMORTIZATION_YN ,
l_tcn_rec.TMT_ASSET_RETURN_YN ,
l_tcn_rec.TMT_CONTRACT_UPDATED_YN ,
l_tcn_rec.TMT_RECYCLE_YN ,
l_tcn_rec.TMT_VALIDATED_YN ,
l_tcn_rec.TMT_STREAMS_UPDATED_YN,
l_tcn_rec.accrual_activity,
-- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
l_tcn_rec.TMT_SPLIT_ASSET_YN,
l_tcn_rec.TMT_GENERIC_FLAG1_YN,
l_tcn_rec.TMT_GENERIC_FLAG2_YN,
l_tcn_rec.TMT_GENERIC_FLAG3_YN,
-- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
l_tcn_rec.CURRENCY_CONVERSION_TYPE,
l_tcn_rec.CURRENCY_CONVERSION_RATE,
l_tcn_rec.CURRENCY_CONVERSION_DATE,
-- Added by Keerthi 04-SEP-2003
l_tcn_rec.CHR_ID,
-- Added by Keerthi for Bug No 3195713
l_tcn_rec.SOURCE_TRX_ID,
l_tcn_rec.SOURCE_TRX_TYPE,
-- Added by kmotepal for Bug 3621485
l_tcn_rec.CANCELED_DATE,
--Added by dpsingh for LE Uptake
l_tcn_rec.LEGAL_ENTITY_ID,
--Added by dpsingh for SLA Uptake (Bug 5707866)
l_tcn_rec.ACCRUAL_REVERSAL_DATE,
-- Added by DJANASWA for SLA project
l_tcn_rec.ACCOUNTING_REVERSAL_YN,
-- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
l_tcn_rec.product_name,
l_tcn_rec.book_classification_code,
l_tcn_rec.tax_owner_code,
l_tcn_rec.tmt_status_code,
l_tcn_rec.representation_name,
l_tcn_rec.representation_code,
-- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
l_tcn_rec.UPGRADE_STATUS_FLAG,
-- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
l_tcn_rec.TRANSACTION_DATE,
-- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
l_tcn_rec.primary_rep_trx_id,
l_tcn_rec.REPRESENTATION_TYPE,
-- Added by sosharma for Income Account recon- report 01-Nov-2008
l_tcn_rec.TRANSACTION_REVERSAL_DATE
);
END insert_row;
PROCEDURE insert_row(
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_tcnv_rec IN tcnv_rec_type,
x_tcnv_rec OUT NOCOPY tcnv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_tcnv_rec.LAST_UPDATE_DATE := SYSDATE;
l_tcnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_tcnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
SELECT DECODE(l_request_id, -1, NULL, l_request_id),
DECODE(l_prog_app_id, -1, NULL, l_prog_app_id),
DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
DECODE(l_request_id, -1, NULL, SYSDATE)
INTO x_tcnv_rec.REQUEST_ID
,x_tcnv_rec.PROGRAM_APPLICATION_ID
,x_tcnv_rec.PROGRAM_ID
,x_tcnv_rec.PROGRAM_UPDATE_DATE
FROM DUAL;
SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_tcn_rec,
lx_tcn_rec
);
END insert_row;
PROCEDURE insert_row(
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_tcnv_tbl IN tcnv_tbl_type,
x_tcnv_tbl OUT NOCOPY tcnv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
insert_row (
p_api_version => p_api_version,
p_init_msg_list => Okc_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => p_tcnv_tbl(i),
x_tcnv_rec => x_tcnv_tbl(i));
END insert_row;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_TRX_CONTRACTS
WHERE ID = p_tcn_rec.id
AND OBJECT_VERSION_NUMBER = p_tcn_rec.object_version_number
FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_TRX_CONTRACTS
WHERE ID = p_tcn_rec.id;
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
PROCEDURE update_row(
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_tcn_rec IN tcn_rec_type,
x_tcn_rec OUT NOCOPY tcn_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'CONTRACTS_update_row';
IF (x_tcn_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_tcn_rec.last_updated_by := l_tcn_rec.last_updated_by;
IF (x_tcn_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_tcn_rec.last_update_date := l_tcn_rec.last_update_date;
IF (x_tcn_rec.update_status_yn = Okc_Api.G_MISS_CHAR)
THEN
x_tcn_rec.update_status_yn := l_tcn_rec.update_status_yn;
IF (x_tcn_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_tcn_rec.program_update_date := l_tcn_rec.program_update_date;
IF (x_tcn_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_tcn_rec.last_update_login := l_tcn_rec.last_update_login;
IF (x_tcn_rec.tmt_contract_updated_yn = Okc_Api.G_MISS_CHAR)
THEN
x_tcn_rec.tmt_contract_updated_yn := l_tcn_rec.tmt_contract_updated_yn ;
IF (x_tcn_rec.tmt_streams_updated_yn = Okc_Api.G_MISS_CHAR)
THEN
x_tcn_rec.tmt_streams_updated_yn := l_tcn_rec.tmt_streams_updated_yn ;
UPDATE OKL_TRX_CONTRACTS
SET KHR_ID_NEW = l_def_tcn_rec.khr_id_new,
PVN_ID = l_def_tcn_rec.pvn_id,
PDT_ID = l_def_tcn_rec.pdt_id,
RBR_CODE = l_def_tcn_rec.rbr_code,
RPY_CODE = l_def_tcn_rec.rpy_code,
RVN_CODE = l_def_tcn_rec.rvn_code,
TRN_CODE = l_def_tcn_rec.trn_code,
QTE_ID = l_def_tcn_rec.qte_id,
AES_ID = l_def_tcn_rec.aes_id,
CODE_COMBINATION_ID = l_def_tcn_rec.code_combination_id,
TCN_TYPE = l_def_tcn_rec.tcn_type,
RJN_CODE = l_def_tcn_rec.RJN_CODE,
PARTY_REL_ID1_OLD = l_def_tcn_rec.PARTY_REL_ID1_OLD,
PARTY_REL_ID2_OLD = l_def_tcn_rec.PARTY_REL_ID2_OLD,
PARTY_REL_ID1_NEW = l_def_tcn_rec.PARTY_REL_ID1_NEW,
PARTY_REL_ID2_NEW = l_def_tcn_rec.PARTY_REL_ID2_NEW,
COMPLETE_TRANSFER_YN = l_def_tcn_rec.COMPLETE_TRANSFER_YN,
OBJECT_VERSION_NUMBER = l_def_tcn_rec.object_version_number,
CREATED_BY = l_def_tcn_rec.created_by,
CREATION_DATE = l_def_tcn_rec.creation_date,
LAST_UPDATED_BY = l_def_tcn_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_tcn_rec.last_update_date,
DATE_ACCRUAL = l_def_tcn_rec.date_accrual,
ACCRUAL_STATUS_YN = l_def_tcn_rec.accrual_status_yn,
UPDATE_STATUS_YN = l_def_tcn_rec.update_status_yn,
ORG_ID = l_def_tcn_rec.org_id,
KHR_ID = l_def_tcn_rec.khr_id,
TAX_DEDUCTIBLE_LOCAL = l_def_tcn_rec.tax_deductible_local,
tax_deductible_corporate = l_def_tcn_rec.tax_deductible_corporate,
AMOUNT = l_def_tcn_rec.amount,
REQUEST_ID = l_def_tcn_rec.request_id,
CURRENCY_CODE = l_def_tcn_rec.currency_code,
PROGRAM_APPLICATION_ID = l_def_tcn_rec.program_application_id,
KHR_ID_OLD = l_def_tcn_rec.khr_id_old,
PROGRAM_ID = l_def_tcn_rec.program_id,
PROGRAM_update_DATE = l_def_tcn_rec.program_update_date,
ATTRIBUTE_CATEGORY = l_def_tcn_rec.attribute_category,
ATTRIBUTE1 = l_def_tcn_rec.attribute1,
ATTRIBUTE2 = l_def_tcn_rec.attribute2,
ATTRIBUTE3 = l_def_tcn_rec.attribute3,
ATTRIBUTE4 = l_def_tcn_rec.attribute4,
ATTRIBUTE5 = l_def_tcn_rec.attribute5,
ATTRIBUTE6 = l_def_tcn_rec.attribute6,
ATTRIBUTE7 = l_def_tcn_rec.attribute7,
ATTRIBUTE8 = l_def_tcn_rec.attribute8,
ATTRIBUTE9 = l_def_tcn_rec.attribute9,
ATTRIBUTE10 = l_def_tcn_rec.attribute10,
ATTRIBUTE11 = l_def_tcn_rec.attribute11,
ATTRIBUTE12 = l_def_tcn_rec.attribute12,
ATTRIBUTE13 = l_def_tcn_rec.attribute13,
ATTRIBUTE14 = l_def_tcn_rec.attribute14,
ATTRIBUTE15 = l_def_tcn_rec.attribute15,
LAST_UPDATE_LOGIN = l_def_tcn_rec.last_update_login,
TRY_ID = l_def_tcn_rec.try_id,
TSU_CODE = l_def_tcn_rec.tsu_code,
SET_OF_BOOKS_ID = l_def_tcn_rec.set_of_books_id,
DESCRIPTION = l_def_tcn_rec.description,
DATE_TRANSACTION_OCCURRED = l_def_tcn_rec.date_transaction_occurred,
TRX_NUMBER = l_def_tcn_rec.trx_number,
TMT_EVERGREEN_YN = l_def_tcn_rec.tmt_evergreen_yn,
TMT_CLOSE_BALANCES_YN = l_def_tcn_rec.tmt_close_balances_yn,
TMT_ACCOUNTING_ENTRIES_YN = l_def_tcn_rec.tmt_accounting_entries_yn,
TMT_CANCEL_INSURANCE_YN = l_def_tcn_rec.tmt_cancel_insurance_yn,
TMT_ASSET_DISPOSITION_YN = l_def_tcn_rec.tmt_asset_disposition_yn,
TMT_AMORTIZATION_YN = l_def_tcn_rec.tmt_amortization_yn,
TMT_ASSET_RETURN_YN = l_def_tcn_rec.tmt_asset_return_yn,
TMT_CONTRACT_UPDATED_YN = l_def_tcn_rec.tmt_contract_updated_yn,
TMT_RECYCLE_YN = l_def_tcn_rec.tmt_recycle_yn,
TMT_VALIDATED_YN = l_def_tcn_rec.tmt_validated_yn,
TMT_STREAMS_UPDATED_YN = l_def_tcn_rec.tmt_streams_updated_yn,
accrual_activity = l_def_tcn_rec.accrual_activity,
-- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
tmt_split_asset_yn = l_def_tcn_rec.tmt_split_asset_yn,
tmt_generic_flag1_yn = l_def_tcn_rec.tmt_generic_flag1_yn,
tmt_generic_flag2_yn = l_def_tcn_rec.tmt_generic_flag2_yn,
tmt_generic_flag3_yn = l_def_tcn_rec.tmt_generic_flag3_yn,
-- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
CURRENCY_CONVERSION_TYPE = l_def_tcn_rec.currency_conversion_type,
CURRENCY_CONVERSION_RATE = l_def_tcn_rec.currency_conversion_rate,
CURRENCY_CONVERSION_DATE = l_def_tcn_rec.currency_conversion_date,
-- Added by Keerthi 04-SEP-2003
CHR_ID = l_def_tcn_rec.chr_id ,
-- Added by Keerthi for Bug No 3195713
SOURCE_TRX_ID = l_def_tcn_rec.source_trx_id,
SOURCE_TRX_TYPE = l_def_tcn_rec.source_trx_type,
-- Added by kmotepal
CANCELED_DATE = l_def_tcn_rec.canceled_date,
--Added by dpsingh for LE Uptake
LEGAL_ENTITY_ID = l_def_tcn_rec.legal_entity_id,
--Added by dpsingh for SLA Uptake (Bug 5707866)
ACCRUAL_REVERSAL_DATE = l_def_tcn_rec.accrual_reversal_date,
-- Added by DJANASWA for SLA project
ACCOUNTING_REVERSAL_YN = l_def_tcn_rec.accounting_reversal_yn,
-- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
PRODUCT_NAME = l_def_tcn_rec.product_name,
BOOK_CLASSIFICATION_CODE = l_def_tcn_rec.book_classification_code,
TAX_OWNER_CODE = l_def_tcn_rec.tax_owner_code,
TMT_STATUS_CODE = l_def_tcn_rec.tmt_status_code,
REPRESENTATION_NAME = l_def_tcn_rec.representation_name,
REPRESENTATION_CODE = l_def_tcn_rec.representation_code,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
UPGRADE_STATUS_FLAG = l_def_tcn_rec.UPGRADE_STATUS_FLAG,
-- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
TRANSACTION_DATE = l_def_tcn_rec.transaction_date,
-- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
primary_rep_trx_id = l_def_tcn_rec.primary_rep_trx_id,
REPRESENTATION_TYPE = l_def_tcn_rec.REPRESENTATION_TYPE,
-- Added by sosharma for Income Account recon- report 01-Nov-2008
TRANSACTION_REVERSAL_DATE = l_def_tcn_rec.TRANSACTION_REVERSAL_DATE
WHERE ID = l_def_tcn_rec.id;
END update_row;
PROCEDURE update_row(
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_tcnv_rec IN tcnv_rec_type,
x_tcnv_rec OUT NOCOPY tcnv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_tcnv_rec.LAST_UPDATE_DATE := SYSDATE;
l_tcnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_tcnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_tcnv_rec.update_status_yn = Okc_Api.G_MISS_CHAR)
THEN
x_tcnv_rec.update_status_yn := l_tcnv_rec.update_status_yn;
IF (x_tcnv_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_tcnv_rec.program_update_date := l_tcnv_rec.program_update_date;
IF (x_tcnv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_tcnv_rec.last_updated_by := l_tcnv_rec.last_updated_by;
IF (x_tcnv_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_tcnv_rec.last_update_date := l_tcnv_rec.last_update_date;
IF (x_tcnv_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_tcnv_rec.last_update_login := l_tcnv_rec.last_update_login;
IF (x_tcnv_rec.tmt_contract_updated_yn = Okc_Api.G_MISS_CHAR) THEN
x_tcnv_rec.tmt_contract_updated_yn := l_tcnv_rec.tmt_contract_updated_yn;
IF (x_tcnv_rec.tmt_streams_updated_yn = Okc_Api.G_MISS_CHAR) THEN
x_tcnv_rec.tmt_streams_updated_yn := l_tcnv_rec.tmt_streams_updated_yn;
SELECT NVL(DECODE(l_request_id, -1, NULL, l_request_id) ,p_tcnv_rec.REQUEST_ID)
,NVL(DECODE(l_prog_app_id, -1, NULL, l_prog_app_id) ,p_tcnv_rec.PROGRAM_APPLICATION_ID)
,NVL(DECODE(l_program_id, -1, NULL, l_program_id) ,p_tcnv_rec.PROGRAM_ID)
,DECODE(DECODE(l_request_id, -1, NULL, SYSDATE) ,NULL, p_tcnv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
INTO x_tcnv_rec.REQUEST_ID
,x_tcnv_rec.PROGRAM_APPLICATION_ID
,x_tcnv_rec.PROGRAM_ID
,x_tcnv_rec.PROGRAM_UPDATE_DATE
FROM DUAL;
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_tcn_rec,
lx_tcn_rec
);
END update_row;
PROCEDURE update_row(
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_tcnv_tbl IN tcnv_tbl_type,
x_tcnv_tbl OUT NOCOPY tcnv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
update_row (
p_api_version => p_api_version,
p_init_msg_list => Okc_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => p_tcnv_tbl(i),
x_tcnv_rec => x_tcnv_tbl(i));
END update_row;
PROCEDURE delete_row(
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_tcn_rec IN tcn_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'CONTRACTS_delete_row';
DELETE FROM OKL_TRX_CONTRACTS
WHERE ID = l_tcn_rec.id;
END delete_row;
PROCEDURE delete_row(
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_tcnv_rec IN tcnv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
delete_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_tcn_rec
);
END delete_row;
PROCEDURE delete_row(
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_tcnv_tbl IN tcnv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
delete_row (
p_api_version => p_api_version,
p_init_msg_list => Okc_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => p_tcnv_tbl(i));
END delete_row;