The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
OBJECT_VERSION_NUMBER,
NAME,
VERSION,
NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
AES_ID,
PTL_ID,
REPORTING_PDT_ID,
NVL(LEGACY_PRODUCT_YN, Okl_Api.G_MISS_CHAR) LEGACY_PRODUCT_YN,
FROM_DATE,
NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
NVL(product_status_code, Okl_Api.G_MISS_CHAR) product_status_code,
NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
FROM Okl_Products_V
WHERE okl_products_v.id = p_id;
l_pdtv_rec.LAST_UPDATED_BY,
l_pdtv_rec.LAST_UPDATE_DATE,
l_pdtv_rec.LAST_UPDATE_LOGIN;
PROCEDURE delete_pdt_pqy_vals(
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_pdtv_rec IN pdtv_rec_type) IS
i PLS_INTEGER :=0;
SELECT pqvv.id
FROM okl_pdt_pqy_vals_v pqvv
WHERE pqvv.pdt_id = p_pdtv_rec.id;
/* public api to delete product option values */
-- Start of wraper code generated automatically by Debug code generator for OKL_PQY_VALUES_PUB.delete_pqy_values
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');
OKL_PQY_VALUES_PUB.delete_pqy_values(p_api_version => p_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_pqvv_tbl => l_del_pqvv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call OKL_PQY_VALUES_PUB.delete_pqy_values ');
END delete_pdt_pqy_vals;
PROCEDURE delete_pdt_psys(
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_pdtv_rec IN pdtv_rec_type) IS
i PLS_INTEGER :=0;
SELECT psyv.id
FROM okl_prod_strm_types_v psyv
WHERE psyv.pdt_id = p_pdtv_rec.id;
Okl_Pdt_Stys_Pub.delete_pdt_stys(p_api_version => p_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_psyv_tbl => l_del_psyv_tbl);
END delete_pdt_psys;
SELECT '1'
FROM Okl_K_Headers_V khr,
Okl_K_Headers_Full_V khf
WHERE khr.PDT_ID = p_pdt_id
AND khf.ID = khr.ID
AND khf.START_DATE BETWEEN p_from_date AND p_to_date;
SELECT '1' FROM okl_k_headers_v khdr
WHERE khdr.pdt_id = p_pdt_id;
SELECT '1'
FROM Okl_Pqy_Values_V qve,
Okl_Pdt_Pqy_Vals_V pqv
WHERE pqv.PDT_ID = p_pdt_id
AND qve.ID = pqv.QVE_ID
AND ((qve.FROM_DATE > p_from_date OR
p_from_date > NVL(qve.TO_DATE,p_from_date)) OR
NVL(qve.TO_DATE, p_to_date) < p_to_date)
UNION ALL
SELECT '2'
FROM Okl_Pdt_Opts_V pon,
Okl_Options_V opt
WHERE pon.PDT_ID = p_pdt_id
AND opt.ID = pon.OPT_ID
AND ((opt.FROM_DATE > p_from_date OR
p_from_date > NVL(opt.TO_DATE,p_from_date)) OR
NVL(opt.TO_DATE, p_to_date) < p_to_date)
UNION ALL
SELECT '3'
FROM Okl_Pdt_Opts_V pon,
Okl_Pdt_Opt_Vals_V pov,
Okl_Opt_Values_V ove
WHERE pon.PDT_ID = p_pdt_id
AND pov.PON_ID = pon.ID
AND ove.ID = pov.OVE_ID
AND ((ove.FROM_DATE > p_from_date OR
p_from_date > NVL(ove.TO_DATE,p_from_date)) OR
NVL(ove.TO_DATE, p_to_date) < p_to_date);
SELECT '4'
FROM Okl_Strm_Type_b sty,
Okl_Prod_Strm_Types_v psy
WHERE psy.PDT_ID = p_pdt_id
AND psy.sty_id = sty.ID
AND ((sty.START_DATE > p_from_date OR
p_from_date > NVL(sty.END_DATE,p_from_date)) OR
NVL(sty.END_DATE, p_to_date) < p_to_date)
*/
CURSOR okl_pdt_aes_ptl_csr (p_aes_id IN Okl_Products_V.AES_ID%TYPE,
p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
p_to_date IN Okl_Products_V.TO_DATE%TYPE
) IS
SELECT '1'
FROM Okl_Ae_Tmpt_Sets_V aes
WHERE aes.ID = p_aes_id
AND ((aes.START_DATE > p_from_date OR
p_from_date > NVL(aes.END_DATE,p_from_date)) OR
NVL(aes.END_DATE, p_to_date) < p_to_date)
UNION ALL
SELECT '2'
FROM Okl_Pdt_Templates_V PTL
WHERE PTL.ID = p_ptl_id
AND ((PTL.FROM_DATE > p_from_date OR
p_from_date > NVL(PTL.TO_DATE,p_from_date)) OR
NVL(PTL.TO_DATE, p_to_date) < p_to_date);
SELECT '1'
FROM okl_products_v
WHERE name = p_name
AND version = p_version;
SELECT DISTINCT pqy.id id,
pqy.name name
FROM okl_pdt_qualitys_v pqy,
okl_pdt_pqys_v pdq
WHERE pqy.id = pdq.pqy_id
AND pdq.ptl_id = cp_ptl_id
AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER');
SELECT COUNT(aes.id)
INTO l_pdt_psy_changed
FROM
okl_ae_tmpt_sets_v aes,
okl_prod_strm_types_v psy
WHERE aes.id = p_db_pdtv_rec.aes_id
and psy.pdt_id = p_upd_pdtv_rec.id;
delete_pdt_psys(p_api_version => p_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_pdtv_rec => p_pdtv_rec);
SELECT COUNT(pqy.id)
INTO l_invalid_product_cnt
FROM
okl_pdt_qualitys_v pqy,
okl_pdt_pqys_v pdq
where pqy.id = pdq.pqy_id
AND pdq.ptl_id = p_pdtv_rec.ptl_id
AND pqy.name = 'INVESTOR';
select ptl_id
into l_rep_ptl_id
from okl_products
where id = p_upd_pdtv_rec.reporting_pdt_id;
select count(pqy.id)
into l_invalid_product_cnt
from okl_pdt_qualitys_v pqy,
okl_pdt_pqys_v pdq
where pqy.id = pdq.pqy_id
and pdq.ptl_id = l_rep_ptl_id
and pqy.name = 'INVESTOR';
SELECT COUNT(pqy.id)
INTO l_quality_miss_cnt
FROM
okl_pdt_qualitys_v pqy,
okl_pdt_pqys_v pdq
WHERE pqy.id = pdq.pqy_id
AND pdq.ptl_id = p_pdtv_rec.ptl_id
AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER');
SELECT COUNT(pqv.id)
INTO l_pdt_ptl_changed
FROM okl_pqy_values_v qve,
okl_pdt_qualitys pqy,
okl_pdt_pqys_v pdq,
okl_pdt_pqy_vals pqv
WHERE qve.pqy_id = pqy.id
AND pqv.qve_id = qve.id
AND pqv.pdq_id = pdq.id
AND pdq.ptl_id = p_db_pdtv_rec.ptl_id
AND pqv.pdt_id = p_upd_pdtv_rec.id;
-- check to see if the product already has a product template attached to it , if yes delete the
-- old child records.
IF l_pdt_ptl_changed > 0 THEN
delete_pdt_pqy_vals(p_api_version => p_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_pdtv_rec => p_pdtv_rec);
SELECT COUNT(qve.id)
INTO l_lease_values_miss_cnt
FROM okl_pqy_values_v qve
WHERE qve.pqy_id = csr_rec.id
AND qve.value IN ('LEASEDF','LEASEOP','LEASEST','LOAN','LOAN-REVOLVING');
SELECT COUNT(qve.id)
INTO l_taxown_values_miss_cnt
FROM okl_pqy_values_v qve
WHERE qve.pqy_id = csr_rec.id
AND qve.value IN ('LESSEE','LESSOR');
SELECT COUNT(qve.id)
INTO l_sec_values_miss_cnt
FROM
okl_pqy_values_v qve
WHERE qve.pqy_id = csr_rec.id
AND qve.value IN ('SECURITIZATION','SYNDICATION');
SELECT
Name,
Product_subclass,
Deal_Type,
Tax_Owner,
Revenue_Recognition_Method,
Interest_Calculation_Basis,
reporting_pdt_id,
reporting_product
FROM okl_product_parameters_v
WHERE id = cp_pdt_id;
SELECT 'Y'
FROM wf_event_subscriptions a,
wf_events b
WHERE a.event_filter_guid = b.guid
AND a.status = 'ENABLED'
AND b.name = p_event_name
AND ROWNUM = 1;
SELECT okl_wf_item_s.NEXTVAL
FROM dual;
SELECT pdt.product_status_code status
FROM okl_products_v pdt
WHERE pdt.id = p_pdt_id;
SELECT ORG_ID
FROM OKL_AE_TMPT_SETS_ALL aes
WHERE aes.ID = p_aes_id;
update_product_status(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_pdt_status => G_PDT_STS_PENDING_APPROVAL,
p_pdt_id => p_pdtv_rec.ID);
l_parameter_list.DELETE;
SELECT NAME, DISPLAY_NAME
FROM WF_USERS
WHERE orig_system_id = c_user_id
AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
SELECT USER_NAME, DESCRIPTION
FROM FND_USER
WHERE user_id = c_user_id;
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
SELECT transaction_type_id,
fnd_application_id
FROM ame_transaction_types_v
WHERE DESCRIPTION='OKL LP Product Approval Process';
SELECT okl_wf_item_s.NEXTVAL item_key
FROM dual;
PROCEDURE update_product_status(
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_pdt_status IN VARCHAR2,
p_pdt_id IN VARCHAR2) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PRODUCT_STATUS';
UPDATE OKL_PRODUCTS SET PRODUCT_STATUS_CODE = l_upd_pdtv_rec.product_status_code
WHERE ID = l_UPD_pdtv_rec.id;
Okl_Products_Pub.update_products(p_api_version => p_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_pdtv_rec => l_upd_pdtv_rec,
x_pdtv_rec => x_pdtv_rec);
END update_product_status;
update_product_status(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_pdt_status => G_PDT_STS_APPROVED,
p_pdt_id => l_pdt_id);
update_product_status(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_pdt_status => G_PDT_STS_INVALID,
p_pdt_id => l_pdt_id);
SELECT '1'
FROM okl_product_parameters_v a
where a.id = p_pdt_id;
SELECT DISTINCT a.deal_type
FROM okl_product_parameters_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.deal_type = c.deal_type
AND a.id = p_pdt_id;
SELECT DISTINCT C.deal_type
FROM okl_products_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.id = p_pdt_id
and a.aes_id = p_aes_id
intersect
select DEAL_TYPE from okl_product_parameters_v ppar
where ppar.id = p_pdt_id;
SELECT DISTINCT C.deal_type
FROM okl_products_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.id = p_pdt_id
intersect
select value from okl_pqy_values qve
where qve.id = p_qve_id;
SELECT name
FROM OKL_PROD_STRM_TYPES_UV a
WHERE pdt_id = p_pdt_id
INTERSECT
SELECT STY_NAME FROM OKL_ST_GEN_TMPT_CNTRCT_UV
WHERE PDT_ID = p_pdt_id;
l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');
SELECT id pdt_id,
product_subclass,
deal_type,
deal_type_meaning,
tax_owner,
tax_owner_meaning,
revenue_recognition_method,
revenue_recognition_meaning,
interest_calculation_basis,
interest_calculation_meaning
FROM okl_product_parameters_v pp
WHERE pp.id = p_pdt_id;
SELECT gts.name sgt_name,
gts.pricing_engine,
gts.deal_type,
gts.tax_owner,
gts.interest_calc_meth_code,
gts.revenue_recog_meth_code
FROM OKL_PRODUCTS_V PDT,
OKL_AE_TMPT_SETS_V AES,
OKL_ST_GEN_TMPT_SETS GTS
WHERE PDT.AES_ID = AES.ID
AND AES.GTS_ID = GTS.ID
AND PDT.ID = p_pdt_id;
SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
FROM okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE b.gts_id = c.id
AND b.id = p_aes_id
INTERSECT
SELECT DISTINCT PQY.NAME
FROM okl_PDT_PQYS_V PDQ,
OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
WHERE PQY.ID = QVE.PQY_ID
AND PQY.ID= PDQ.PQY_ID
AND PDQ.PTL_ID = p_PTL_ID
AND pqy.name IN('LEASE','INVESTOR');
SELECT tax_upfront_sty_id
FROM OKL_SYSTEM_PARAMS;
SELECT gttv.id gtt_id, gtsv.name name, gttv.version version
FROM
OKL_ST_GEN_TEMPLATES GTTV,
OKL_ST_GEN_TMPT_SETS GTSV,
okl_ae_tmpt_sets_v AES,
okl_products_v PDT
WHERE
GTTV.gts_id = GTSV.id AND
GTTV.tmpt_status = 'ACTIVE' AND
GTSV.id = AES.gts_id AND
AES.id = PDT.aes_id AND
PDT.id = p_pdt_id AND
GTSV.product_type ='FINANCIAL';
SELECT GTLV.PRIMARY_STY_ID
FROM
OKL_ST_GEN_TEMPLATES GTTV,
OKL_ST_GEN_TMPT_LNS GTLV
WHERE
GTTV.ID = p_gtt_id AND
GTTV.ID = GTLV.gtt_id AND
GTLV.PRIMARY_STY_ID = p_tax_upfront_sty_id AND
GTLV.PRIMARY_YN = 'Y' ;
SELECT styb_purpose_meaning
FROM okl_strm_type_v
WHERE ID = p_id;
SELECT rp.product_status_code rp_pdt_sts_code
,rp.name rp_pdt_name
,rp.id rp_pdt_id -- Bug 7134895
FROM okl_products np,
okl_products rp
WHERE rp.id = np.reporting_pdt_id
AND np.id = p_pdt_id;
SELECT '1'
FROM okl_k_headers_v khdr
WHERE khdr.pdt_id = p_pdt_id;
p_msg_name => 'OKL_PDT_RPT_SELECT_LOAN'
);
p_msg_name => 'OKL_PDT_RPT_SELECT_REVLOAN'
);
p_msg_name => 'OKL_PDT_RPT_SELECT_LEASE'
);
p_msg_name => 'OKL_PDT_RPT_SELECT_LEASE'
);
p_msg_name => 'OKL_PDT_RPT_SELECT_SGT',
p_token1 => 'PRICINGENG',
p_token1_value => l_pricing_engine
);
update_products(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_pdtv_rec => l_pdtv_rec,
x_pdtv_rec => x_pdtv_rec);
update_product_status(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_pdt_status => l_pdtv_rec.product_status_code,
p_pdt_id => l_pdtv_rec.id);
SELECT '1'
FROM okl_ae_tmpt_sets_v
WHERE okl_ae_tmpt_sets_v.id = p_id;
SELECT '1'
FROM okl_pdt_templates_v
WHERE okl_pdt_templates_v.id = p_id;
l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');
PROCEDURE check_updates (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_upd_pdtv_rec IN pdtv_rec_type,
p_db_pdtv_rec IN pdtv_rec_type,
p_pdtv_rec IN pdtv_rec_type,
x_return_status OUT NOCOPY VARCHAR2
) IS
l_upd_pdtv_rec pdtv_rec_type;
END check_updates;
SELECT ID,
PDT_ID,
STY_ID,
ACCRUAL_YN,
FROM_DATE,
TO_DATE
FROM Okl_prod_strm_types_V psy
WHERE psy.PDT_ID = p_pdt_id;
IF p_flag = G_UPDATE THEN
l_psyv_tbl(l_count).ID := okl_psy_rec.ID;
SELECT ID,
PDQ_ID,
QVE_ID,
FROM_DATE,
TO_DATE
FROM Okl_pdt_pqy_vals_V pqv
WHERE pqv.PDT_ID = p_pdt_id;
IF p_flag = G_UPDATE THEN
l_pqvv_tbl(l_count).ID := okl_pqv_rec.ID;
SELECT ID,
OPT_ID,
OPTIONAL_YN,
FROM_DATE,
TO_DATE
FROM Okl_Pdt_Opts_V pon
WHERE pon.PDT_ID = p_pdt_id;
IF p_flag = G_UPDATE THEN
l_ponv_tbl(l_count).ID := okl_pon_rec.ID;
SELECT pov.ID ID,
ove.OPT_ID OPT_ID,
pov.OVE_ID OVE_ID,
pov.FROM_DATE FROM_DATE,
pov.TO_DATE TO_DATE
FROM Okl_Pdt_Opts_V pon,
Okl_Pdt_Opt_Vals_V pov,
Okl_Opt_Values_V ove
WHERE pon.PDT_ID = p_pdt_id
AND pov.PON_ID = pon.ID
AND ove.ID = pov.OVE_ID;
IF p_flag = G_UPDATE THEN
l_povv_tbl(l_count).ID := okl_pov_rec.ID;
PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
p_upd_pdtv_rec IN pdtv_rec_type,
p_db_pdtv_rec IN pdtv_rec_type,
p_pdtv_rec IN pdtv_rec_type,
p_flag IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_upd_pdtv_rec pdtv_rec_type; /* input copy */
IF p_flag = G_UPDATE THEN
-- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_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_psyv_tbl => l_psyv_tbl,
x_psyv_tbl => l_out_psyv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_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_psyv_tbl => l_psyv_tbl,
x_psyv_tbl => l_out_psyv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
IF p_flag = G_UPDATE THEN
-- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_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_pqvv_tbl => l_pqvv_tbl,
x_pqvv_tbl => l_out_pqvv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_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_pqvv_tbl => l_pqvv_tbl,
x_pqvv_tbl => l_out_pqvv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
IF p_flag = G_UPDATE THEN
-- Start of wraper code generated automatically by Debug code generator for Okl_Product_Options_Pub.update_product_options
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');
Okl_Product_Options_Pub.update_product_options(p_api_version => p_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_ponv_tbl => l_ponv_tbl,
x_ponv_tbl => l_out_ponv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.update_product_options ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');
Okl_Product_Options_Pub.insert_product_options(p_api_version => p_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_ponv_tbl => l_ponv_tbl,
x_ponv_tbl => l_out_ponv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Product_Options_Pub.insert_product_options ');
IF p_flag = G_UPDATE THEN
-- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');
Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals(p_api_version => p_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_povv_tbl => l_povv_tbl,
x_povv_tbl => l_out_povv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.update_pdt_opt_vals ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');
Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals(p_api_version => p_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_povv_tbl => l_povv_tbl,
x_povv_tbl => l_out_povv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals ');
END copy_update_constraints;
PROCEDURE insert_products(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_pdtv_rec IN pdtv_rec_type,
x_pdtv_rec OUT NOCOPY pdtv_rec_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'insert_products';
SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
FROM okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE b.gts_id = c.id
AND b.id = p_aes_id
INTERSECT
SELECT DISTINCT PQY.NAME
FROM okl_PDT_PQYS_V PDQ,
OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
WHERE PQY.ID = QVE.PQY_ID
AND PQY.ID= PDQ.PQY_ID
AND PDQ.PTL_ID = p_PTL_ID
AND pqy.name IN('LEASE','INVESTOR');
/* public api to insert products */
-- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.insert_products
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
Okl_Products_Pub.insert_products(p_api_version => p_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_pdtv_rec => l_pdtv_rec,
x_pdtv_rec => x_pdtv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.insert_products ');
END insert_products;
PROCEDURE update_products(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_pdtv_rec IN pdtv_rec_type,
x_pdtv_rec OUT NOCOPY pdtv_rec_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'update_products';
SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
FROM okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE b.gts_id = c.id
AND b.id = p_aes_id
INTERSECT
SELECT DISTINCT PQY.NAME
FROM okl_PDT_PQYS_V PDQ,
OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
WHERE PQY.ID = QVE.PQY_ID
AND PQY.ID= PDQ.PQY_ID
AND PDQ.PTL_ID = p_PTL_ID
AND pqy.name IN('LEASE','INVESTOR');
/* public api to update products */
-- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
/*
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
Okl_Products_Pub.update_products(p_api_version => p_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_pdtv_rec => l_upd_pdtv_rec,
x_pdtv_rec => x_pdtv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
check_updates(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_upd_pdtv_rec => l_upd_pdtv_rec,
p_db_pdtv_rec => l_db_pdtv_rec,
p_pdtv_rec => l_pdtv_rec,
x_return_status => l_return_status);
/* public api to update formulae */
-- Start of wraper code generated automatically by Debug code generator for Okl_Products_Pub.update_products
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
Okl_Products_Pub.update_products(p_api_version => p_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_pdtv_rec => l_upd_pdtv_rec,
x_pdtv_rec => x_pdtv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Products_Pub.update_products ');
/* update constraints */
/*copy_update_constraints(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_upd_pdtv_rec => l_upd_pdtv_rec,
p_db_pdtv_rec => l_db_pdtv_rec,
p_pdtv_rec => l_pdtv_rec,
p_flag => G_UPDATE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
END update_products;