The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id
,object_version_number
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,reference_number
,status
,parent_object_code
,parent_object_id
,valid_from
,valid_to
,customer_bookclass
,customer_taxowner
,expected_start_date
,expected_funding_date
,expected_delivery_date
,pricing_method
,term
,product_id
,end_of_term_option_id
,rate_card_id
,rate_template_id
,target_rate_type
,target_rate
,target_amount
,target_frequency
,target_arrears_yn
,target_periods
,iir
,booking_yield
,pirr
,airr
,sub_iir
,sub_booking_yield
,sub_pirr
,sub_airr
,usage_category
,usage_industry_class
,usage_industry_code
,usage_amount
,usage_location_id
,property_tax_applicable
,property_tax_billing_type
,upfront_tax_treatment
,upfront_tax_stream_type
,transfer_of_title
,age_of_equipment
,purchase_of_lease
,sale_and_lease_back
,interest_disclosed
,structured_pricing
,line_level_pricing
,short_description
,description
,comments
,PRIMARY_QUOTE
INTO
l_lsqv_rec.id
,l_lsqv_rec.object_version_number
,l_lsqv_rec.attribute_category
,l_lsqv_rec.attribute1
,l_lsqv_rec.attribute2
,l_lsqv_rec.attribute3
,l_lsqv_rec.attribute4
,l_lsqv_rec.attribute5
,l_lsqv_rec.attribute6
,l_lsqv_rec.attribute7
,l_lsqv_rec.attribute8
,l_lsqv_rec.attribute9
,l_lsqv_rec.attribute10
,l_lsqv_rec.attribute11
,l_lsqv_rec.attribute12
,l_lsqv_rec.attribute13
,l_lsqv_rec.attribute14
,l_lsqv_rec.attribute15
,l_lsqv_rec.reference_number
,l_lsqv_rec.status
,l_lsqv_rec.parent_object_code
,l_lsqv_rec.parent_object_id
,l_lsqv_rec.valid_from
,l_lsqv_rec.valid_to
,l_lsqv_rec.customer_bookclass
,l_lsqv_rec.customer_taxowner
,l_lsqv_rec.expected_start_date
,l_lsqv_rec.expected_funding_date
,l_lsqv_rec.expected_delivery_date
,l_lsqv_rec.pricing_method
,l_lsqv_rec.term
,l_lsqv_rec.product_id
,l_lsqv_rec.end_of_term_option_id
,l_lsqv_rec.rate_card_id
,l_lsqv_rec.rate_template_id
,l_lsqv_rec.target_rate_type
,l_lsqv_rec.target_rate
,l_lsqv_rec.target_amount
,l_lsqv_rec.target_frequency
,l_lsqv_rec.target_arrears_yn
,l_lsqv_rec.target_periods
,l_lsqv_rec.iir
,l_lsqv_rec.booking_yield
,l_lsqv_rec.pirr
,l_lsqv_rec.airr
,l_lsqv_rec.sub_iir
,l_lsqv_rec.sub_booking_yield
,l_lsqv_rec.sub_pirr
,l_lsqv_rec.sub_airr
,l_lsqv_rec.usage_category
,l_lsqv_rec.usage_industry_class
,l_lsqv_rec.usage_industry_code
,l_lsqv_rec.usage_amount
,l_lsqv_rec.usage_location_id
,l_lsqv_rec.property_tax_applicable
,l_lsqv_rec.property_tax_billing_type
,l_lsqv_rec.upfront_tax_treatment
,l_lsqv_rec.upfront_tax_stream_type
,l_lsqv_rec.transfer_of_title
,l_lsqv_rec.age_of_equipment
,l_lsqv_rec.purchase_of_lease
,l_lsqv_rec.sale_and_lease_back
,l_lsqv_rec.interest_disclosed
,l_lsqv_rec.structured_pricing
,l_lsqv_rec.line_level_pricing
,l_lsqv_rec.short_description
,l_lsqv_rec.description
,l_lsqv_rec.comments
,l_lsqv_rec.PRIMARY_QUOTE
FROM OKL_LEASE_QUOTES_V
WHERE id = p_quote_id;
SELECT id
,object_version_number
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,parent_object_code
,parent_object_id
,stream_type_id
,fee_type
,rate_card_id
,rate_template_id
,structured_pricing
,target_arrears
,effective_from
,effective_to
,supplier_id
,rollover_quote_id
,initial_direct_cost
,fee_amount
,target_amount
,target_frequency
,payment_type_id
,fee_purpose_code -- Bug#9708535
INTO
l_feev_rec.id
,l_feev_rec.object_version_number
,l_feev_rec.attribute_category
,l_feev_rec.attribute1
,l_feev_rec.attribute2
,l_feev_rec.attribute3
,l_feev_rec.attribute4
,l_feev_rec.attribute5
,l_feev_rec.attribute6
,l_feev_rec.attribute7
,l_feev_rec.attribute8
,l_feev_rec.attribute9
,l_feev_rec.attribute10
,l_feev_rec.attribute11
,l_feev_rec.attribute12
,l_feev_rec.attribute13
,l_feev_rec.attribute14
,l_feev_rec.attribute15
,l_feev_rec.parent_object_code
,l_feev_rec.parent_object_id
,l_feev_rec.stream_type_id
,l_feev_rec.fee_type
,l_feev_rec.rate_card_id
,l_feev_rec.rate_template_id
,l_feev_rec.structured_pricing
,l_feev_rec.target_arrears
,l_feev_rec.effective_from
,l_feev_rec.effective_to
,l_feev_rec.supplier_id
,l_feev_rec.rollover_quote_id
,l_feev_rec.initial_direct_cost
,l_feev_rec.fee_amount
,l_feev_rec.target_amount
,l_feev_rec.target_frequency
,l_feev_rec.payment_type_id
,l_feev_rec.fee_purpose_code -- Bug#9708535
FROM okL_fees_V
WHERE id = p_fee_id;
SELECT id
,object_version_number
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,parent_object_code
,parent_object_id
,asset_number
,install_site_id
,rate_card_id
,rate_template_id
,oec
,end_of_term_value_default
,end_of_term_value
,oec_percentage
,target_amount
,target_frequency
,short_description
,description
,comments
INTO
l_assv_rec.id
,l_assv_rec.object_version_number
,l_assv_rec.attribute_category
,l_assv_rec.attribute1
,l_assv_rec.attribute2
,l_assv_rec.attribute3
,l_assv_rec.attribute4
,l_assv_rec.attribute5
,l_assv_rec.attribute6
,l_assv_rec.attribute7
,l_assv_rec.attribute8
,l_assv_rec.attribute9
,l_assv_rec.attribute10
,l_assv_rec.attribute11
,l_assv_rec.attribute12
,l_assv_rec.attribute13
,l_assv_rec.attribute14
,l_assv_rec.attribute15
,l_assv_rec.parent_object_code
,l_assv_rec.parent_object_id
,l_assv_rec.asset_number
,l_assv_rec.install_site_id
,l_assv_rec.rate_card_id
,l_assv_rec.rate_template_id
,l_assv_rec.oec
,l_assv_rec.end_of_term_value_default
,l_assv_rec.end_of_term_value
,l_assv_rec.oec_percentage
,l_assv_rec.target_amount
,l_assv_rec.target_frequency
,l_assv_rec.short_description
,l_assv_rec.description
,l_assv_rec.comments
FROM OKL_ASSETS_V
WHERE id = p_asset_id;
SELECT count(*) overriden_assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND ( AST.RATE_TEMPLATE_ID IS NOT NULL
OR AST.STRUCTURED_PRICING = 'Y' )
AND QTE.ID = p_quote_id
AND p_line_level_pricing = 'Y';
SELECT count(*) overriden_assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND ( AST.RATE_CARD_ID IS NOT NULL
OR AST.LEASE_RATE_FACTOR IS NOT NULL )
AND QTE.ID = p_quote_id
AND p_line_level_pricing = 'Y';
SELECT count(*) overriden_assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND ( AST.STRUCTURED_PRICING = 'Y')
AND QTE.ID = p_quote_id
AND p_line_level_pricing = 'Y';
SELECT count(*) assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND QTE.ID = p_quote_id;
SELECT ID
FROM OKL_LEASE_QUOTES_B
WHERE parent_object_id =p_parent_object_id
AND primary_quote = 'Y';
OKL_LEASE_QUOTE_PVT.update_lease_qte(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_lease_qte_rec => l_lsqv_rec
,x_lease_qte_rec => lx_lsqv_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
PROCEDURE create_update_payment (
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_lease_qte_rec IN lease_qte_rec_type
,p_payment_header_rec IN cashflow_hdr_rec_type
,p_payment_level_tbl IN cashflow_level_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_UPDATE_PAYMENT';
SELECT 'YES'
FROM OKL_CASH_FLOW_OBJECTS
WHERE OTY_CODE = 'LEASE_QUOTE'
AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
AND SOURCE_ID = p_quote_id;
SELECT ID
FROM OKL_ASSETS_B
WHERE parent_object_id = lc_quote_id
AND parent_object_code = 'LEASEQUOTE';
SELECT ID
FROM OKL_FEES_B
WHERE parent_object_id = lc_quote_id
AND parent_object_code = 'LEASEQUOTE'
AND fee_type <> 'CAPITALIZED';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
,'begin debug call update_lease_qte');
OKL_LEASE_QUOTE_PVT.update_lease_qte(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_lease_qte_rec => l_lease_qte_rec
,x_lease_qte_rec => lx_lease_qte_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
,'end debug call update_lease_qte');
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
okl_lease_quote_cashflow_pvt.delete_cashflows(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_source_object_code => 'LEASE_QUOTE'
,p_source_object_id => p_lease_qte_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
,'begin debug call update_cashflow');
OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_cashflow_header_rec => l_payment_header_rec
,p_cashflow_level_tbl => l_payment_level_tbl
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
,'end debug call update_cashflow');
delete_line_payment(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_source_object_code => 'QUOTED_ASSET'
,p_source_object_id => l_quote_asset_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
delete_line_payment(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_source_object_code => 'QUOTED_FEE'
,p_source_object_id => l_quote_fees_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
END create_update_payment;
PROCEDURE create_update_payment (
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_lease_qte_rec IN lease_qte_rec_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_UPDATE_PAYMENT';
SELECT ID
FROM OKL_ASSETS_B
WHERE parent_object_id = lc_quote_id
AND parent_object_code = 'LEASEQUOTE';
SELECT ID
FROM OKL_FEES_B
WHERE parent_object_id = lc_quote_id
AND parent_object_code = 'LEASEQUOTE'
AND fee_type <> 'CAPITALIZED';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
,'begin debug call update_lease_qte');
OKL_LEASE_QUOTE_PVT.update_lease_qte(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_lease_qte_rec => l_lease_qte_rec
,x_lease_qte_rec => lx_lease_qte_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
,'End debug call update_lease_qte');
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
okl_lease_quote_cashflow_pvt.delete_cashflows(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_source_object_code => 'LEASE_QUOTE'
,p_source_object_id => p_lease_qte_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
delete_line_payment(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_source_object_code => 'QUOTED_ASSET'
,p_source_object_id => l_quote_asset_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
delete_line_payment(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_source_object_code => 'QUOTED_FEE'
,p_source_object_id => l_quote_fees_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
END create_update_payment;
PROCEDURE create_update_line_payment (
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_fee_rec IN fee_rec_type
,p_asset_rec IN asset_rec_type
,p_payment_header_rec IN cashflow_hdr_rec_type
,p_payment_level_tbl IN cashflow_level_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
SELECT 'YES'
FROM OKL_CASH_FLOW_OBJECTS
WHERE OTY_CODE = 'QUOTED_ASSET'
AND SOURCE_TABLE = 'OKL_ASSETS_B'
AND SOURCE_ID = p_asset_id;
SELECT 'YES'
FROM OKL_CASH_FLOW_OBJECTS
WHERE OTY_CODE = 'QUOTED_FEE'
AND SOURCE_TABLE = 'OKL_FEES_B'
AND SOURCE_ID = p_fee_id;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
,'begin debug call update_row');
OKL_FEE_PVT.update_row(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_feev_rec => l_fee_rec
,x_feev_rec => lx_fee_rec
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
,'end debug call update_row');
SELECT pricing_method
INTO l_pricing_method
FROM okl_lease_quotes_b
where id = l_fee_Rec.parent_object_id;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
,'begin debug call update_row');
OKL_ASS_PVT.update_row (p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_assv_rec => l_asset_rec
,x_assv_rec => lx_asset_rec );
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
,'end debug call update_row');
SELECT pricing_method
INTO l_pricing_method
FROM okl_lease_quotes_b
where id = l_asset_rec.parent_object_id;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
,'begin debug call update_cashflow');
OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_cashflow_header_rec => l_payment_header_rec
,p_cashflow_level_tbl => l_payment_level_tbl
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
,'end debug call update_cashflow');
/*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
FROM okl_lease_quotes_b where ID = nvl(l_fee_rec.parent_object_id,l_Asset_rec.parent_object_id);
END create_update_line_payment;
PROCEDURE create_update_line_payment (
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_fee_rec IN fee_rec_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
,'begin debug call update_row');
OKL_FEE_PVT.update_row(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_feev_rec => l_fee_rec
,x_feev_rec => lx_fee_rec
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
,'end debug call update_row');
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
okl_lease_quote_cashflow_pvt.delete_cashflows(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_source_object_code => 'QUOTED_FEE'
,p_source_object_id => p_fee_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
/*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;
END create_update_line_payment;
PROCEDURE create_update_line_payment (
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_asset_rec IN asset_rec_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
,'begin debug call update_row');
OKL_ASS_PVT.update_row (p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_assv_rec => l_asset_rec
,x_assv_rec => lx_asset_rec );
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
,'begin debug call update_row');
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
okl_lease_quote_cashflow_pvt.delete_cashflows(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_source_object_code => 'QUOTED_ASSET'
,p_source_object_id => p_asset_rec.id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
/*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;
END create_update_line_payment;
PROCEDURE delete_line_payment(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_source_object_code IN VARCHAR2
,p_source_object_id IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_LINE_PAYMENT';
SELECT 'YES'
FROM OKL_CASH_FLOW_OBJECTS
WHERE OTY_CODE = p_source_code
AND SOURCE_ID = p_source_id;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
,'begin debug call update_row');
OKL_FEE_PVT.update_row(
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_feev_rec => l_fee_rec
,x_feev_rec => lx_fee_rec
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
,'end debug call update_row');
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
,'begin debug call update_row');
OKL_ASS_PVT.update_row (p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_assv_rec => l_asset_rec
,x_assv_rec => lx_asset_rec );
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
,'end debug call update_row');
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows'
,'begin debug call delete_cashflows');
OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
p_api_version => G_API_VERSION
,p_init_msg_list => G_FALSE
,p_transaction_control => G_FALSE
,p_source_object_code => l_source_object_code
,p_source_object_id => l_source_object_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows'
,'end debug call delete_cashflows');
END delete_line_payment;
SELECT STUB_DAYS,
STUB_AMOUNT
FROM OKL_CASH_FLOW_LEVELS
WHERE CAF_ID = l_cashflow_id;
SELECT SUM(NUMBER_OF_PERIODS)
FROM OKL_CASH_FLOW_LEVELS
WHERE CAF_ID = l_cashflow_id;
SELECT STUB_DAYS,
STUB_AMOUNT
FROM OKL_CASH_FLOW_LEVELS
WHERE CAF_ID = l_cashflow_id;
SELECT COUNT(ID)
FROM OKL_CASH_FLOW_LEVELS
WHERE CAF_ID = l_cashflow_id;
SELECT AMOUNT
FROM OKL_CASH_FLOW_LEVELS
WHERE CAF_ID = l_cashflow_id;