eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPPQVALUES_PVT dependencies on OKL_PDT_PQY_VALS_V

Line 29: -- PROCEDURE get_rec for: Okl_Pdt_Pqy_Vals_v

25:
26: G_FLT_FAC_LOAN_REV_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_FLT_FAC_LOAN_REV_MISMATCH'; --- CHG001
27: G_FLT_FAC_EST_BILL_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_FLT_FAC_EST_BILL_MISMATCH'; --- CHG001
28: ---------------------------------------------------------------------------
29: -- PROCEDURE get_rec for: Okl_Pdt_Pqy_Vals_v
30: ---------------------------------------------------------------------------
31: PROCEDURE get_rec (
32: p_pqvv_rec IN pqvv_rec_type,
33: x_no_data_found OUT NOCOPY BOOLEAN,

Line 54: FROM Okl_Pdt_Pqy_Vals_V

50:
51: LAST_UPDATED_BY,
52: LAST_UPDATE_DATE,
53: LAST_UPDATE_LOGIN
54: FROM Okl_Pdt_Pqy_Vals_V
55: WHERE okl_pdt_pqy_vals_v.id = p_id;
56: l_okl_pqvv_pk okl_pqvv_pk_csr%ROWTYPE;
57: l_pqvv_rec pqvv_rec_type;
58: BEGIN

Line 55: WHERE okl_pdt_pqy_vals_v.id = p_id;

51: LAST_UPDATED_BY,
52: LAST_UPDATE_DATE,
53: LAST_UPDATE_LOGIN
54: FROM Okl_Pdt_Pqy_Vals_V
55: WHERE okl_pdt_pqy_vals_v.id = p_id;
56: l_okl_pqvv_pk okl_pqvv_pk_csr%ROWTYPE;
57: l_pqvv_rec pqvv_rec_type;
58: BEGIN
59: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 98: -- PROCEDURE get_parent_dates for: Okl_Pdt_Pqy_Vals_v

94:
95: END get_rec;
96:
97: ---------------------------------------------------------------------------
98: -- PROCEDURE get_parent_dates for: Okl_Pdt_Pqy_Vals_v
99: ---------------------------------------------------------------------------
100:
101: PROCEDURE get_parent_dates(
102: p_pqvv_rec IN pqvv_rec_type,

Line 149: -- PROCEDURE check_constraints for: Okl_Pdt_Pqy_Vals_v

145:
146:
147: -----------------------------------------------------------------------------
148:
149: -- PROCEDURE check_constraints for: Okl_Pdt_Pqy_Vals_v
150: -----------------------------------------------------------------------------
151:
152:
153: PROCEDURE Check_Constraints (

Line 176: CURSOR okl_pqv_constraints_csr(p_qve_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE,

172: FROM Okl_products_V pdt
173: WHERE pdt.ID = p_pdt_id
174: AND NVL(pdt.TO_DATE, p_date) < p_date;
175:
176: CURSOR okl_pqv_constraints_csr(p_qve_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE,
177: p_from_date IN Okl_Pdt_Pqy_Vals_V.FROM_DATE%TYPE,
178: p_to_date IN Okl_Pdt_Pqy_Vals_V.TO_DATE%TYPE
179: ) IS
180: SELECT '1'

Line 177: p_from_date IN Okl_Pdt_Pqy_Vals_V.FROM_DATE%TYPE,

173: WHERE pdt.ID = p_pdt_id
174: AND NVL(pdt.TO_DATE, p_date) < p_date;
175:
176: CURSOR okl_pqv_constraints_csr(p_qve_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE,
177: p_from_date IN Okl_Pdt_Pqy_Vals_V.FROM_DATE%TYPE,
178: p_to_date IN Okl_Pdt_Pqy_Vals_V.TO_DATE%TYPE
179: ) IS
180: SELECT '1'
181: FROM Okl_Pqy_Values_V qve

Line 178: p_to_date IN Okl_Pdt_Pqy_Vals_V.TO_DATE%TYPE

174: AND NVL(pdt.TO_DATE, p_date) < p_date;
175:
176: CURSOR okl_pqv_constraints_csr(p_qve_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE,
177: p_from_date IN Okl_Pdt_Pqy_Vals_V.FROM_DATE%TYPE,
178: p_to_date IN Okl_Pdt_Pqy_Vals_V.TO_DATE%TYPE
179: ) IS
180: SELECT '1'
181: FROM Okl_Pqy_Values_V qve
182: WHERE qve.ID = p_qve_id

Line 187: CURSOR c1(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

183: AND ((qve.FROM_DATE > p_from_date OR
184: p_from_date > NVL(qve.TO_DATE,p_from_date)) OR
185: NVL(qve.TO_DATE, p_to_date) < p_to_date);
186:
187: CURSOR c1(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
188: p_pdq_id okl_pdt_pqy_vals_v.pdq_id%TYPE) IS
189: SELECT '1'
190: FROM okl_pdt_pqy_vals_v
191: WHERE pdt_id = p_pdt_id

Line 188: p_pdq_id okl_pdt_pqy_vals_v.pdq_id%TYPE) IS

184: p_from_date > NVL(qve.TO_DATE,p_from_date)) OR
185: NVL(qve.TO_DATE, p_to_date) < p_to_date);
186:
187: CURSOR c1(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
188: p_pdq_id okl_pdt_pqy_vals_v.pdq_id%TYPE) IS
189: SELECT '1'
190: FROM okl_pdt_pqy_vals_v
191: WHERE pdt_id = p_pdt_id
192: AND pdq_id = p_pdq_id

Line 190: FROM okl_pdt_pqy_vals_v

186:
187: CURSOR c1(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
188: p_pdq_id okl_pdt_pqy_vals_v.pdq_id%TYPE) IS
189: SELECT '1'
190: FROM okl_pdt_pqy_vals_v
191: WHERE pdt_id = p_pdt_id
192: AND pdq_id = p_pdq_id
193: AND id <> NVL(p_pqvv_rec.id,-9999);
194:

Line 195: CURSOR pdt_parameters_csr(cp_pdt_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE)

191: WHERE pdt_id = p_pdt_id
192: AND pdq_id = p_pdq_id
193: AND id <> NVL(p_pqvv_rec.id,-9999);
194:
195: CURSOR pdt_parameters_csr(cp_pdt_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE)
196: IS
197: SELECT pqy.id pqy_id,pqy.name name,
198: qve.id qve_id,qve.value value
199: FROM okl_pdt_pqy_vals_v pqv,

Line 199: FROM okl_pdt_pqy_vals_v pqv,

195: CURSOR pdt_parameters_csr(cp_pdt_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE)
196: IS
197: SELECT pqy.id pqy_id,pqy.name name,
198: qve.id qve_id,qve.value value
199: FROM okl_pdt_pqy_vals_v pqv,
200: okl_pqy_values_v qve,
201: okl_pdt_qualitys_v pqy
202: WHERE pqv.pdt_id = cp_pdt_id
203: AND pqy.ID = qve.PQY_ID

Line 208: CURSOR pdt_parameters_csr1(cp_pdt_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE)

204: AND qve.ID = pqv.QVE_ID
205: AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER','INTEREST_CALCULATION_BASIS','REVENUE_RECOGNITION_METHOD');
206:
207:
208: CURSOR pdt_parameters_csr1(cp_pdt_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE)
209: IS
210: SELECT pqy.id pqy_id,pqy.name name,
211: qve.id qve_id,qve.value value
212: FROM okl_pdt_pqy_vals_v pqv,

Line 212: FROM okl_pdt_pqy_vals_v pqv,

208: CURSOR pdt_parameters_csr1(cp_pdt_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE)
209: IS
210: SELECT pqy.id pqy_id,pqy.name name,
211: qve.id qve_id,qve.value value
212: FROM okl_pdt_pqy_vals_v pqv,
213: okl_pqy_values_v qve,
214: okl_pdt_qualitys_v pqy
215: WHERE pqv.pdt_id = cp_pdt_id
216: AND pqy.ID = qve.PQY_ID

Line 220: CURSOR csr_loan_rev(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE)

216: AND pqy.ID = qve.PQY_ID
217: AND qve.ID = pqv.QVE_ID
218: AND pqy.name IN ('REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');
219:
220: CURSOR csr_loan_rev(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE)
221: IS
222: SELECT a.deal_type,a. REVENUE_RECOGNITION_METHOD,A.INTEREST_CALCULATION_BASIS
223: FROM okl_product_parameters_v a
224: WHERE a.id = p_pdt_id;

Line 227: cursor chk_pqy_value(p_pdq_id okl_pdt_pqy_vals_v.pdq_id%TYPE)

223: FROM okl_product_parameters_v a
224: WHERE a.id = p_pdt_id;
225:
226:
227: cursor chk_pqy_value(p_pdq_id okl_pdt_pqy_vals_v.pdq_id%TYPE)
228: IS
229: SELECT pqy.name
230: FROM okl_pdt_qualitys pqy,
231: okl_pdt_pqys pdq

Line 235: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

231: okl_pdt_pqys pdq
232: WHERE pdq.id = p_pdq_id
233: and pqy.id = pdq.pqy_id;
234:
235: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
236: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
237: IS
238: SELECT DISTINCT C.deal_type
239: FROM okl_products_v a,

Line 236: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)

232: WHERE pdq.id = p_pdq_id
233: and pqy.id = pdq.pqy_id;
234:
235: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
236: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
237: IS
238: SELECT DISTINCT C.deal_type
239: FROM okl_products_v a,
240: okl_ae_tmpt_sets_v b,

Line 250: cursor chk_investor(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

246: select value from okl_pqy_values qve
247: where qve.id = p_qve_id;
248:
249:
250: cursor chk_investor(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
251: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
252: IS
253: SELECT DISTINCT decode (C.deal_type, 'SALE','SECURITIZATION','SYNDICATION','SYNDICATION') DEAL_TYPE
254: FROM okl_products_v a,

Line 251: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)

247: where qve.id = p_qve_id;
248:
249:
250: cursor chk_investor(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
251: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
252: IS
253: SELECT DISTINCT decode (C.deal_type, 'SALE','SECURITIZATION','SYNDICATION','SYNDICATION') DEAL_TYPE
254: FROM okl_products_v a,
255: okl_ae_tmpt_sets_v b,

Line 264: cursor chk_tax_owner(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

260: intersect
261: select value from okl_pqy_values qve
262: where qve.id = p_qve_id;
263:
264: cursor chk_tax_owner(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
265: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
266: IS
267: SELECT DISTINCT C.TAX_OWNER
268: FROM okl_products_v a,

Line 265: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)

261: select value from okl_pqy_values qve
262: where qve.id = p_qve_id;
263:
264: cursor chk_tax_owner(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
265: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
266: IS
267: SELECT DISTINCT C.TAX_OWNER
268: FROM okl_products_v a,
269: okl_ae_tmpt_sets_v b,

Line 278: cursor chk_intrst_calc_mthd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

274: intersect
275: select value from okl_pqy_values qve
276: where qve.id = p_qve_id;
277:
278: cursor chk_intrst_calc_mthd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
279: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
280: IS
281: SELECT DISTINCT C.INTEREST_CALC_METH_CODE
282: FROM okl_products_v a,

Line 279: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)

275: select value from okl_pqy_values qve
276: where qve.id = p_qve_id;
277:
278: cursor chk_intrst_calc_mthd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
279: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
280: IS
281: SELECT DISTINCT C.INTEREST_CALC_METH_CODE
282: FROM okl_products_v a,
283: okl_ae_tmpt_sets_v b,

Line 292: cursor chk_rev_rec_methd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

288: intersect
289: select value from okl_pqy_values qve
290: where qve.id = p_qve_id;
291:
292: cursor chk_rev_rec_methd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
293: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
294: IS
295: SELECT DISTINCT C.REVENUE_RECOG_METH_CODE
296: FROM okl_products_v a,

Line 293: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)

289: select value from okl_pqy_values qve
290: where qve.id = p_qve_id;
291:
292: cursor chk_rev_rec_methd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
293: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
294: IS
295: SELECT DISTINCT C.REVENUE_RECOG_METH_CODE
296: FROM okl_products_v a,
297: okl_ae_tmpt_sets_v b,

Line 306: Cursor csr_rev_rec_no_update(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE) IS

302: intersect
303: select value from okl_pqy_values qve
304: where qve.id = p_qve_id;
305:
306: Cursor csr_rev_rec_no_update(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE) IS
307: SELECT '1'
308: FROM okl_product_parameters_v pdt
309: where reporting_pdt_id = p_pdt_id;
310:

Line 544: FROM OKL_pdt_pqy_vals_V a,

540: LOOP
541: IF csr_rec.name = 'LEASE' AND csr_rec.value = 'LEASEOP' THEN
542: SELECT COUNT(b.id)
543: INTO l_leaseop_lessee_mismatch
544: FROM OKL_pdt_pqy_vals_V a,
545: okl_pdt_qualitys_v b,
546: okl_pqy_values_v c
547: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
548: AND b.id = c.pqy_id

Line 555: FROM OKL_pdt_pqy_vals_V a,

551: AND b.name = 'TAXOWNER';
552: ELSIF csr_rec.name = 'TAXOWNER' and csr_rec.value = 'LESSEE' THEN
553: SELECT COUNT(b.id)
554: INTO l_leaseop_lessee_mismatch
555: FROM OKL_pdt_pqy_vals_V a,
556: okl_pdt_qualitys_v b,
557: okl_pqy_values_v c
558: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
559: AND b.id = c.pqy_id

Line 568: FROM OKL_pdt_pqy_vals_V a,

564:
565: IF csr_rec.name = 'INTEREST_CALCULATION_BASIS' and csr_rec.value = 'FLOAT_FACTORS' THEN
566: SELECT COUNT(b.id)
567: INTO l_FLT_FAC_loan_rev_mismatch
568: FROM OKL_pdt_pqy_vals_V a,
569: okl_pdt_qualitys_v b,
570: okl_pqy_values_v c
571: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
572: AND b.id = c.pqy_id

Line 579: FROM OKL_pdt_pqy_vals_V a,

575: AND b.name = 'LEASE';
576: ELSIF csr_rec.name = 'LEASE' and csr_rec.value = 'LOAN-REVOLVING' THEN
577: SELECT COUNT(b.id)
578: INTO l_FLT_FAC_loan_rev_mismatch
579: FROM OKL_pdt_pqy_vals_V a,
580: okl_pdt_qualitys_v b,
581: okl_pqy_values_v c
582: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
583: AND b.id = c.pqy_id

Line 593: FROM OKL_pdt_pqy_vals_V a,

589:
590: IF csr_rec.name = 'REVENUE_RECOGNITION_METHOD' and csr_rec.value = 'ESTIMATED_AND_BILLED' THEN
591: SELECT COUNT(b.id)
592: INTO l_FLT_FAC_EST_BILL_mismatch
593: FROM OKL_pdt_pqy_vals_V a,
594: okl_pdt_qualitys_v b,
595: okl_pqy_values_v c
596: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
597: AND b.id = c.pqy_id

Line 604: FROM OKL_pdt_pqy_vals_V a,

600: AND b.name = 'INTEREST_CALCULATION_BASIS';
601: ELSIF csr_rec.name = 'INTEREST_CALCULATION_BASIS' and csr_rec.value = 'FLOAT_FACTORS' THEN
602: SELECT COUNT(b.id)
603: INTO l_FLT_FAC_EST_BILL_mismatch
604: FROM OKL_pdt_pqy_vals_V a,
605: okl_pdt_qualitys_v b,
606: okl_pqy_values_v c
607: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
608: AND b.id = c.pqy_id

Line 619: FROM OKL_pdt_pqy_vals_V a,

615: IF csr_rec.name = 'LEASE' AND csr_rec.value = 'LOAN' THEN
616: SELECT COUNT(b.id)
617:
618: INTO l_loan_lessor_mismatch
619: FROM OKL_pdt_pqy_vals_V a,
620: okl_pdt_qualitys_v b,
621: okl_pqy_values_v c
622: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
623: AND b.id = c.pqy_id

Line 631: FROM OKL_pdt_pqy_vals_V a,

627: AND b.name = 'TAXOWNER';
628: ELSIF csr_rec.name = 'TAXOWNER' AND csr_rec.value = 'LESSOR' THEN
629: SELECT COUNT(b.id)
630: INTO l_leaseop_lessee_mismatch
631: FROM OKL_pdt_pqy_vals_V a,
632: okl_pdt_qualitys_v b,
633: okl_pqy_values_v c
634: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
635: AND b.id = c.pqy_id

Line 645: FROM OKL_pdt_pqy_vals_V a,

641: IF csr_rec.name = 'LEASE' AND csr_rec.value = 'LOAN-REVOLVING' THEN
642: SELECT COUNT(b.id)
643:
644: INTO l_loanrev_lessor_mismatch
645: FROM OKL_pdt_pqy_vals_V a,
646: okl_pdt_qualitys_v b,
647: okl_pqy_values_v c
648: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
649: AND b.id = c.pqy_id

Line 656: FROM OKL_pdt_pqy_vals_V a,

652: AND b.name = 'TAXOWNER';
653: ELSIF csr_rec.name = 'TAXOWNER' AND csr_rec.value = 'LESSOR' THEN
654: SELECT COUNT(b.id)
655: INTO l_leaseop_lessee_mismatch
656: FROM OKL_pdt_pqy_vals_V a,
657: okl_pdt_qualitys_v b,
658: okl_pqy_values_v c
659: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
660: AND b.id = c.pqy_id

Line 948: -- PROCEDURE insert_pqvvalues for: Okl_Pdt_Pqy_Vals_v

944: END Validate_Attributes;
945:
946:
947: ---------------------------------------------------------------------------
948: -- PROCEDURE insert_pqvvalues for: Okl_Pdt_Pqy_Vals_v
949: ---------------------------------------------------------------------------
950: PROCEDURE insert_pqvalues(
951: p_api_version IN NUMBER,
952: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1094: -- PROCEDURE update_pqvvalues for: Okl_Pdt_Pqy_Vals_v

1090:
1091: END insert_pqvalues;
1092:
1093: ---------------------------------------------------------------------------
1094: -- PROCEDURE update_pqvvalues for: Okl_Pdt_Pqy_Vals_v
1095: ---------------------------------------------------------------------------
1096: PROCEDURE update_pqvalues(
1097: p_api_version IN NUMBER,
1098: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,