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_PQYS_V

Line 15: -- PROCEDURE get_rec for: OKL_PDT_PQYS_V

11: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME'; --- CHG001
12: G_TAXOWN_SEC_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_TAXOWN_SEC_MISMATCH'; --- CHG001
13: G_LEASE_SEC_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_LEASE_SEC_MISMATCH'; --- CHG001
14: ---------------------------------------------------------------------------
15: -- PROCEDURE get_rec for: OKL_PDT_PQYS_V
16: ---------------------------------------------------------------------------
17: PROCEDURE get_rec (
18: p_pdqv_rec IN pdqv_rec_type,
19: x_no_data_found OUT NOCOPY BOOLEAN,

Line 36: FROM Okl_Pdt_Pqys_V

32: CREATION_DATE,
33: LAST_UPDATED_BY,
34: LAST_UPDATE_DATE,
35: LAST_UPDATE_LOGIN
36: FROM Okl_Pdt_Pqys_V
37: WHERE okl_pdt_pqys_v.id = p_id;
38: l_okl_pdqv_pk okl_pdqv_pk_csr%ROWTYPE;
39: l_pdqv_rec pdqv_rec_type;
40: BEGIN

Line 37: WHERE okl_pdt_pqys_v.id = p_id;

33: LAST_UPDATED_BY,
34: LAST_UPDATE_DATE,
35: LAST_UPDATE_LOGIN
36: FROM Okl_Pdt_Pqys_V
37: WHERE okl_pdt_pqys_v.id = p_id;
38: l_okl_pdqv_pk okl_pdqv_pk_csr%ROWTYPE;
39: l_pdqv_rec pdqv_rec_type;
40: BEGIN
41: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 82: -- PROCEDURE get_parent_dates for: OKL_PDT_PQYS_V

78:
79: END get_rec;
80:
81: ---------------------------------------------------------------------------
82: -- PROCEDURE get_parent_dates for: OKL_PDT_PQYS_V
83: ---------------------------------------------------------------------------
84:
85: PROCEDURE get_parent_dates(
86: p_pdqv_rec IN pdqv_rec_type,

Line 129: -- PROCEDURE check_constraints for: Okl_Pdt_pqys_V

125:
126: END get_parent_dates;
127:
128: -----------------------------------------------------------------------------
129: -- PROCEDURE check_constraints for: Okl_Pdt_pqys_V
130: -----------------------------------------------------------------------------
131:
132: PROCEDURE Check_Constraints (
133: p_api_version IN NUMBER,

Line 170: CURSOR c1(p_ptl_id okl_pdt_pqys_v.ptl_id%TYPE,

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);
169:
170: CURSOR c1(p_ptl_id okl_pdt_pqys_v.ptl_id%TYPE,
171: p_pqy_id okl_pdt_pqys_v.pqy_id%TYPE) IS
172: SELECT '1'
173: FROM okl_pdt_pqys_v
174: WHERE ptl_id = p_ptl_id

Line 171: p_pqy_id okl_pdt_pqys_v.pqy_id%TYPE) IS

167: p_from_date > NVL(pqy.TO_DATE,p_from_date)) OR
168: NVL(pqy.TO_DATE, p_to_date) < p_to_date);
169:
170: CURSOR c1(p_ptl_id okl_pdt_pqys_v.ptl_id%TYPE,
171: p_pqy_id okl_pdt_pqys_v.pqy_id%TYPE) IS
172: SELECT '1'
173: FROM okl_pdt_pqys_v
174: WHERE ptl_id = p_ptl_id
175: AND pqy_id = p_pqy_id

Line 173: FROM okl_pdt_pqys_v

169:
170: CURSOR c1(p_ptl_id okl_pdt_pqys_v.ptl_id%TYPE,
171: p_pqy_id okl_pdt_pqys_v.pqy_id%TYPE) IS
172: SELECT '1'
173: FROM okl_pdt_pqys_v
174: WHERE ptl_id = p_ptl_id
175: AND pqy_id = p_pqy_id
176: AND id <> NVL(p_pdqv_rec.id,-9999);
177:

Line 178: CURSOR choose_qlty_csr(cp_pqy_id okl_pdt_pqys_v.pqy_id%TYPE

174: WHERE ptl_id = p_ptl_id
175: AND pqy_id = p_pqy_id
176: AND id <> NVL(p_pdqv_rec.id,-9999);
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

Line 280: FROM OKL_PDT_PQYS_V pdq,

276: OR l_chosen_quality = 'INTEREST_CALCULATION_BASIS' THEN
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';

Line 290: FROM OKL_PDT_PQYS_V pdq,

286: ELSIF l_chosen_quality = 'INVESTOR' THEN
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');

Line 303: FROM OKL_PDT_PQYS_V pdq,

299: /*
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';

Line 311: FROM OKL_PDT_PQYS_V pdq,

307: AND pqy.name = 'INVESTOR';
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';

Line 319: FROM OKL_PDT_PQYS_V pdq,

315: AND pqy.name = 'LEASE';
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';

Line 327: FROM OKL_PDT_PQYS_V pdq,

323: AND pqy.name = 'INVESTOR';
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';

Line 578: -- PROCEDURE copy_dependent_qualitys for: OKL_PDT_PQYS_V

574:
575: END Validate_Attributes;
576:
577: ---------------------------------------------------------------------------
578: -- PROCEDURE copy_dependent_qualitys for: OKL_PDT_PQYS_V
579: ---------------------------------------------------------------------------
580:
581: PROCEDURE copy_dependent_qualitys (p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 673: -- PROCEDURE insert_dqualitys for: Okl_Pdt_pqys_V

669:
670: END copy_dependent_qualitys;
671:
672: ---------------------------------------------------------------------------
673: -- PROCEDURE insert_dqualitys for: Okl_Pdt_pqys_V
674: ---------------------------------------------------------------------------
675:
676: PROCEDURE insert_dqualitys(p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 846: FROM okl_pdt_pqys_v pdq,

842: /*
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';

Line 854: FROM okl_pdt_pqys_v pdq,

850: AND pqy.name = 'TAXOWNER';
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';

Line 862: FROM okl_pdt_pqys_v pdq,

858: AND pqy.name = 'LEASE';
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';

Line 870: FROM okl_pdt_pqys_v pdq,

866: AND pqy.name = 'LEASE';
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';

Line 1048: -- PROCEDURE delete_pdt_pqys for: Okl_Pdt_pqys_V

1044: END insert_dqualitys;
1045:
1046: ---------------------------------------------------------------------------
1047: ---------------------------------------------------------------------------
1048: -- PROCEDURE delete_pdt_pqys for: Okl_Pdt_pqys_V
1049: -- Private procedure called from delete_dqualitys.
1050: ---------------------------------------------------------------------------
1051:
1052: PROCEDURE delete_pdt_pqys(

Line 1153: -- PROCEDURE delete_dqualitys for: Okl_Pdt_pqys_V

1149: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1150: END delete_pdt_pqys;
1151:
1152: ---------------------------------------------------------------------------
1153: -- PROCEDURE delete_dqualitys for: Okl_Pdt_pqys_V
1154: -- This allows the user to delete table of records
1155: ---------------------------------------------------------------------------
1156:
1157: PROCEDURE delete_dqualitys( p_api_version IN NUMBER