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_SETUPDQUALITYS_PVT dependencies on OKL_PDT_QUALITYS_V

Line 159: CURSOR okl_pdq_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,

155: FROM Okl_pdt_templates_V ptl
156: WHERE ptl.ID = p_ptl_id
157: AND NVL(ptl.TO_DATE, p_date) < p_date;
158:
159: CURSOR okl_pdq_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
160: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
161: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
162: ) IS
163: SELECT '1'

Line 160: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,

156: WHERE ptl.ID = p_ptl_id
157: AND NVL(ptl.TO_DATE, p_date) < p_date;
158:
159: CURSOR okl_pdq_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
160: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
161: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
162: ) IS
163: SELECT '1'
164: FROM Okl_Pdt_Qualitys_V pqy

Line 161: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE

157: AND NVL(ptl.TO_DATE, p_date) < p_date;
158:
159: CURSOR okl_pdq_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
160: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
161: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
162: ) IS
163: SELECT '1'
164: FROM Okl_Pdt_Qualitys_V pqy
165: WHERE pqy.ID = p_pqy_id

Line 164: FROM Okl_Pdt_Qualitys_V pqy

160: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
161: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
162: ) IS
163: SELECT '1'
164: FROM Okl_Pdt_Qualitys_V pqy
165: WHERE pqy.ID = p_pqy_id
166: AND ((pqy.FROM_DATE > p_from_date OR
167: p_from_date > NVL(pqy.TO_DATE,p_from_date)) OR
168: NVL(pqy.TO_DATE, p_to_date) < p_to_date);

Line 181: FROM okl_pdt_qualitys_v

177:
178: CURSOR choose_qlty_csr(cp_pqy_id okl_pdt_pqys_v.pqy_id%TYPE
179: ) IS
180: SELECT NAME
181: FROM okl_pdt_qualitys_v
182: WHERE id = cp_pqy_id
183: AND name IN ('LEASE','INVESTOR','TAXOWNER','REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');
184:
185: l_unq_tbl Okc_Util.unq_tbl_type;

Line 281: OKL_PDT_QUALITYS_V pqy

277:
278: SELECT COUNT(pqy.id)
279: INTO l_invalid_selection_1
280: FROM OKL_PDT_PQYS_V pdq,
281: OKL_PDT_QUALITYS_V pqy
282: WHERE pdq.PTL_ID = p_pdqv_rec.ptl_id
283: AND pdq.PQY_ID = pqy.ID
284: AND pqy.name = 'INVESTOR';
285:

Line 291: OKL_PDT_QUALITYS_V pqy

287:
288: SELECT COUNT(pqy.id)
289: INTO l_invalid_selection_1
290: FROM OKL_PDT_PQYS_V pdq,
291: OKL_PDT_QUALITYS_V pqy
292: WHERE pdq.PTL_ID = p_pdqv_rec.ptl_id
293: AND pdq.PQY_ID = pqy.ID
294: AND pqy.name IN ('LEASE','TAXOWNER','REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');
295:

Line 304: OKL_PDT_QUALITYS_V pqy

300: IF l_chosen_quality = 'LEASE' THEN
301: SELECT COUNT(pqy.id)
302: INTO l_invalid_selection_1
303: FROM OKL_PDT_PQYS_V pdq,
304: OKL_PDT_QUALITYS_V pqy
305: WHERE pdq.PTL_ID = p_pdqv_rec.ptl_id
306: AND pdq.PQY_ID = pqy.ID
307: AND pqy.name = 'INVESTOR';
308: ELSIF l_chosen_quality = 'INVESTOR' THEN

Line 312: OKL_PDT_QUALITYS_V pqy

308: ELSIF l_chosen_quality = 'INVESTOR' THEN
309: SELECT COUNT(pqy.id)
310: INTO l_invalid_selection_1
311: FROM OKL_PDT_PQYS_V pdq,
312: OKL_PDT_QUALITYS_V pqy
313: WHERE pdq.PTL_ID = p_pdqv_rec.ptl_id
314: AND pdq.PQY_ID = pqy.ID
315: AND pqy.name = 'LEASE';
316: ELSIF l_chosen_quality = 'TAXOWNER' THEN

Line 320: OKL_PDT_QUALITYS_V pqy

316: ELSIF l_chosen_quality = 'TAXOWNER' THEN
317: SELECT COUNT(pqy.id)
318: INTO l_invalid_selection_2
319: FROM OKL_PDT_PQYS_V pdq,
320: OKL_PDT_QUALITYS_V pqy
321: WHERE pdq.PTL_ID = p_pdqv_rec.ptl_id
322: AND pdq.PQY_ID = pqy.ID
323: AND pqy.name = 'INVESTOR';
324: ELSIF l_chosen_quality = 'INVESTOR' THEN

Line 328: OKL_PDT_QUALITYS_V pqy

324: ELSIF l_chosen_quality = 'INVESTOR' THEN
325: SELECT COUNT(pqy.id)
326: INTO l_invalid_selection_2
327: FROM OKL_PDT_PQYS_V pdq,
328: OKL_PDT_QUALITYS_V pqy
329: WHERE pdq.PTL_ID = p_pdqv_rec.ptl_id
330: AND pdq.PQY_ID = pqy.ID
331: AND pqy.name = 'TAXOWNER';
332: END IF;

Line 435: FROM okl_pdt_qualitys_v

431: IS
432:
433: CURSOR okl_pqyv_pk_csr (p_id IN NUMBER) IS
434: SELECT '1'
435: FROM okl_pdt_qualitys_v
436: WHERE okl_pdt_qualitys_v.id = p_id;
437:
438: l_pqy_status VARCHAR2(1);
439: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 436: WHERE okl_pdt_qualitys_v.id = p_id;

432:
433: CURSOR okl_pqyv_pk_csr (p_id IN NUMBER) IS
434: SELECT '1'
435: FROM okl_pdt_qualitys_v
436: WHERE okl_pdt_qualitys_v.id = p_id;
437:
438: l_pqy_status VARCHAR2(1);
439: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
440: l_row_notfound BOOLEAN := TRUE;

Line 584: p_name IN okl_pdt_qualitys_v.name%TYPE,

580:
581: PROCEDURE copy_dependent_qualitys (p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
583: p_pdqv_rec IN pdqv_rec_type,
584: p_name IN okl_pdt_qualitys_v.name%TYPE,
585: x_return_status OUT NOCOPY VARCHAR2,
586: x_msg_count OUT NOCOPY NUMBER,
587: x_msg_data OUT NOCOPY VARCHAR2
588: ) IS

Line 589: CURSOR get_pqy_csr(cp_name okl_pdt_qualitys_v.name%TYPE

585: x_return_status OUT NOCOPY VARCHAR2,
586: x_msg_count OUT NOCOPY NUMBER,
587: x_msg_data OUT NOCOPY VARCHAR2
588: ) IS
589: CURSOR get_pqy_csr(cp_name okl_pdt_qualitys_v.name%TYPE
590: ) IS
591: SELECT id
592: FROM okl_pdt_qualitys_v pqy
593: WHERE pqy.name = cp_name;

Line 592: FROM okl_pdt_qualitys_v pqy

588: ) IS
589: CURSOR get_pqy_csr(cp_name okl_pdt_qualitys_v.name%TYPE
590: ) IS
591: SELECT id
592: FROM okl_pdt_qualitys_v pqy
593: WHERE pqy.name = cp_name;
594:
595: l_pdqv_rec pdqv_rec_type;
596: l_out_pdqv_rec pdqv_rec_type;

Line 599: l_name okl_pdt_qualitys_v.name%TYPE;

595: l_pdqv_rec pdqv_rec_type;
596: l_out_pdqv_rec pdqv_rec_type;
597: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
598: l_psy_count NUMBER := 0;
599: l_name okl_pdt_qualitys_v.name%TYPE;
600: l_pqy_id okl_pdt_qualitys_v.id%TYPE;
601:
602: BEGIN
603: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 600: l_pqy_id okl_pdt_qualitys_v.id%TYPE;

596: l_out_pdqv_rec pdqv_rec_type;
597: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
598: l_psy_count NUMBER := 0;
599: l_name okl_pdt_qualitys_v.name%TYPE;
600: l_pqy_id okl_pdt_qualitys_v.id%TYPE;
601:
602: BEGIN
603: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
604: l_pdqv_rec := p_pdqv_rec;

Line 687: CURSOR choose_qualitys_csr(cp_pqy_id okl_pdt_qualitys_v.id%TYPE

683: p_pdqv_rec IN pdqv_rec_type,
684: x_pdqv_rec OUT NOCOPY pdqv_rec_type
685: ) IS
686:
687: CURSOR choose_qualitys_csr(cp_pqy_id okl_pdt_qualitys_v.id%TYPE
688: ) IS
689: SELECT name
690: FROM okl_pdt_qualitys_v pqy
691: WHERE pqy.ID = cp_pqy_id;

Line 690: FROM okl_pdt_qualitys_v pqy

686:
687: CURSOR choose_qualitys_csr(cp_pqy_id okl_pdt_qualitys_v.id%TYPE
688: ) IS
689: SELECT name
690: FROM okl_pdt_qualitys_v pqy
691: WHERE pqy.ID = cp_pqy_id;
692:
693:
694: CURSOR get_dependent_qualitys_csr(P_choosen_quality okl_pdt_qualitys_v.NAME%TYPE

Line 694: CURSOR get_dependent_qualitys_csr(P_choosen_quality okl_pdt_qualitys_v.NAME%TYPE

690: FROM okl_pdt_qualitys_v pqy
691: WHERE pqy.ID = cp_pqy_id;
692:
693:
694: CURSOR get_dependent_qualitys_csr(P_choosen_quality okl_pdt_qualitys_v.NAME%TYPE
695: ) IS
696: SELECT name
697: FROM okl_pdt_qualitys_v pqy
698: WHERE pqy.NAME <> P_choosen_quality

Line 697: FROM okl_pdt_qualitys_v pqy

693:
694: CURSOR get_dependent_qualitys_csr(P_choosen_quality okl_pdt_qualitys_v.NAME%TYPE
695: ) IS
696: SELECT name
697: FROM okl_pdt_qualitys_v pqy
698: WHERE pqy.NAME <> P_choosen_quality
699: AND pqy.NAME IN ('LEASE','TAXOWNER','REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');
700:
701:

Line 705: l_choosen_quality okl_pdt_qualitys_v.name%TYPE;

701:
702: l_api_version CONSTANT NUMBER := 1;
703: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
704: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
705: l_choosen_quality okl_pdt_qualitys_v.name%TYPE;
706: l_dependent_quality okl_pdt_qualitys_v.name%TYPE;
707: l_dependent_quality_cnt NUMBER(4):= 0;
708: l_valid BOOLEAN;
709: l_pdqv_rec pdqv_rec_type;

Line 706: l_dependent_quality okl_pdt_qualitys_v.name%TYPE;

702: l_api_version CONSTANT NUMBER := 1;
703: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
704: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
705: l_choosen_quality okl_pdt_qualitys_v.name%TYPE;
706: l_dependent_quality okl_pdt_qualitys_v.name%TYPE;
707: l_dependent_quality_cnt NUMBER(4):= 0;
708: l_valid BOOLEAN;
709: l_pdqv_rec pdqv_rec_type;
710: l_ptlv_rec ptlv_rec_type;

Line 847: okl_pdt_qualitys_v pqy

843: IF l_choosen_quality = 'LEASE' THEN
844: SELECT COUNT(pqy.id)
845: INTO l_dependent_quality_cnt
846: FROM okl_pdt_pqys_v pdq,
847: okl_pdt_qualitys_v pqy
848: WHERE pdq.ptl_id = l_pdqv_rec.ptl_id
849: AND pdq.pqy_id = pqy.id
850: AND pqy.name = 'TAXOWNER';
851: ELSIF l_choosen_quality = 'TAXOWNER' THEN

Line 855: okl_pdt_qualitys_v pqy

851: ELSIF l_choosen_quality = 'TAXOWNER' THEN
852: SELECT COUNT(pqy.id)
853: INTO l_dependent_quality_cnt
854: FROM okl_pdt_pqys_v pdq,
855: okl_pdt_qualitys_v pqy
856: WHERE pdq.ptl_id = l_pdqv_rec.ptl_id
857: AND pdq.pqy_id = pqy.id
858: AND pqy.name = 'LEASE';
859: ELSIF l_choosen_quality = 'REVENUE_RECOGNITION_METHOD' THEN

Line 863: okl_pdt_qualitys_v pqy

859: ELSIF l_choosen_quality = 'REVENUE_RECOGNITION_METHOD' THEN
860: SELECT COUNT(pqy.id)
861: INTO l_dependent_quality_cnt
862: FROM okl_pdt_pqys_v pdq,
863: okl_pdt_qualitys_v pqy
864: WHERE pdq.ptl_id = l_pdqv_rec.ptl_id
865: AND pdq.pqy_id = pqy.id
866: AND pqy.name = 'LEASE';
867: ELSIF l_choosen_quality = 'TAXOWNER' THEN

Line 871: okl_pdt_qualitys_v pqy

867: ELSIF l_choosen_quality = 'TAXOWNER' THEN
868: SELECT COUNT(pqy.id)
869: INTO l_dependent_quality_cnt
870: FROM okl_pdt_pqys_v pdq,
871: okl_pdt_qualitys_v pqy
872: WHERE pdq.ptl_id = l_pdqv_rec.ptl_id
873: AND pdq.pqy_id = pqy.id
874: AND pqy.name = 'LEASE';
875: END IF;

Line 963: FROM okl_pdt_qualitys_v pqy

959:
960: CURSOR get_dependent_qualitys_csr--- added by rajnisku for bug 6398092 get the dependent qualitites not selected by the user
961: IS
962: SELECT name
963: FROM okl_pdt_qualitys_v pqy
964: WHERE pqy.NAME not in ( select pdtq.name from okl_pdt_qualitys pdtq ,okl_pdt_pqys pdt
965: where pdtq.id = pdt.pqy_id and pdt.ptl_id=p_pdqv_tbl(i).ptl_id)
966: AND pqy.NAME IN ('LEASE','TAXOWNER','REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');
967: