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

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 620: -- Start of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys

616:
617: --Default the dependent quality
618: l_pdqv_rec.pqy_id := l_pqy_id;
619:
620: -- Start of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
621: IF(L_DEBUG_ENABLED='Y') THEN
622: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
623: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
624: END IF;

Line 627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');

623: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
624: END IF;
625: IF(IS_DEBUG_PROCEDURE_ON) THEN
626: BEGIN
627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
628: END;
629: END IF;
630: okl_pdt_pqys_pub.insert_pdt_pqys(p_api_version => p_api_version,
631: p_init_msg_list => p_init_msg_list,

Line 630: okl_pdt_pqys_pub.insert_pdt_pqys(p_api_version => p_api_version,

626: BEGIN
627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
628: END;
629: END IF;
630: okl_pdt_pqys_pub.insert_pdt_pqys(p_api_version => p_api_version,
631: p_init_msg_list => p_init_msg_list,
632: x_return_status => l_return_status,
633: x_msg_count => x_msg_count,
634: x_msg_data => x_msg_data,

Line 639: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');

635: p_pdqv_rec => l_pdqv_rec,
636: x_pdqv_rec => l_out_pdqv_rec);
637: IF(IS_DEBUG_PROCEDURE_ON) THEN
638: BEGIN
639: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
640: END;
641: END IF;
642: -- End of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
643: END IF;

Line 642: -- End of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys

638: BEGIN
639: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call okl_pdt_pqys_pub.insert_pdt_pqys ');
640: END;
641: END IF;
642: -- End of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
643: END IF;
644:
645: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
646: x_return_status := Okl_Api.G_RET_STS_ERROR;

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 779: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys

775: RAISE Okl_Api.G_EXCEPTION_ERROR;
776: END IF;
777:
778: /* public api to insert dqualitys */
779: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
780: IF(L_DEBUG_ENABLED='Y') THEN
781: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
782: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
783: END IF;

Line 786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');

782: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
783: END IF;
784: IF(IS_DEBUG_PROCEDURE_ON) THEN
785: BEGIN
786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
787: END;
788: END IF;
789: Okl_Pdt_Pqys_Pub.insert_pdt_pqys(p_api_version => p_api_version,
790: p_init_msg_list => p_init_msg_list,

Line 789: Okl_Pdt_Pqys_Pub.insert_pdt_pqys(p_api_version => p_api_version,

785: BEGIN
786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
787: END;
788: END IF;
789: Okl_Pdt_Pqys_Pub.insert_pdt_pqys(p_api_version => p_api_version,
790: p_init_msg_list => p_init_msg_list,
791:
792: x_return_status => l_return_status,
793: x_msg_count => x_msg_count,

Line 799: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');

795: p_pdqv_rec => l_pdqv_rec,
796: x_pdqv_rec => x_pdqv_rec);
797: IF(IS_DEBUG_PROCEDURE_ON) THEN
798: BEGIN
799: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
800: END;
801: END IF;
802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
803:

Line 802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys

798: BEGIN
799: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.insert_pdt_pqys ');
800: END;
801: END IF;
802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
803:
804: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
805: RAISE Okl_Api.G_EXCEPTION_ERROR;
806: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

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 955: select 1 from okl_pdt_qualitys pdtq ,okl_pdt_pqys pdt

951: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
952: i NUMBER := 0;
953: do_copy NUMBER := 0;
954: CURSOR copy_allowed_csr IS
955: select 1 from okl_pdt_qualitys pdtq ,okl_pdt_pqys pdt
956: where pdtq.id = pdt.pqy_id and pdt.ptl_id=p_pdqv_tbl(i).ptl_id
957: and pdtq.name IN ('LEASE','TAXOWNER','REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');
958:
959:

Line 964: WHERE pqy.NAME not in ( select pdtq.name from okl_pdt_qualitys pdtq ,okl_pdt_pqys pdt

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:
968: BEGIN

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 1111: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys

1107: END IF;
1108: END IF;
1109: END IF;
1110: --Delete the Master
1111: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1112: IF(IS_DEBUG_PROCEDURE_ON) THEN
1113: BEGIN
1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1115: END;

Line 1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');

1110: --Delete the Master
1111: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1112: IF(IS_DEBUG_PROCEDURE_ON) THEN
1113: BEGIN
1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1115: END;
1116: END IF;
1117: Okl_Pdt_Pqys_Pub.delete_pdt_pqys(p_api_version => p_api_version,
1118: p_init_msg_list => p_init_msg_list,

Line 1117: Okl_Pdt_Pqys_Pub.delete_pdt_pqys(p_api_version => p_api_version,

1113: BEGIN
1114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1115: END;
1116: END IF;
1117: Okl_Pdt_Pqys_Pub.delete_pdt_pqys(p_api_version => p_api_version,
1118: p_init_msg_list => p_init_msg_list,
1119: x_return_status => l_return_status,
1120: x_msg_count => x_msg_count,
1121: x_msg_data => x_msg_data,

Line 1125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');

1121: x_msg_data => x_msg_data,
1122: p_pdqv_rec => p_pdqv_rec);
1123: IF(IS_DEBUG_PROCEDURE_ON) THEN
1124: BEGIN
1125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1126: END;
1127: END IF;
1128: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1129:

Line 1128: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys

1124: BEGIN
1125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pdt_Pqys_Pub.delete_pdt_pqys ');
1126: END;
1127: END IF;
1128: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1129:
1130: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1131: RAISE G_EXCEPTION_HALT_PROCESSING;
1132: ELSE

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

Line 1183: From okl_pdt_pqys pdq,

1179: l_other_id number;
1180:
1181: CURSOR delete_dep_quality_csr(P_PDQ_ID NUMBER,P_PTL_ID NUMBER) IS
1182: Select pdq.Id
1183: From okl_pdt_pqys pdq,
1184: okl_pdt_qualitys pqy
1185: Where pdq.Id <> P_PDQ_ID
1186: and pdq.pqy_id = pqy.id
1187: and pqy.name in ('LEASE','TAXOWNER','REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS')

Line 1242: From okl_pdt_pqys pdq,

1238: IF (l_pdqv_tbl.COUNT > 0) THEN
1239: j := p_pdqv_tbl.FIRST;
1240: LOOP
1241: Select count(*) into id_count
1242: From okl_pdt_pqys pdq,
1243: okl_pdt_qualitys pqy
1244: Where pdq.Id = p_pdqv_tbl(j).Id
1245: and pdq.pqy_id = pqy.id
1246: and pqy.name in ('LEASE','TAXOWNER','REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS')

Line 1252: From okl_pdt_pqys pdq,

1248:
1249: If id_count >= 1 then
1250:
1251: /* Select pdq.Id into other_id
1252: From okl_pdt_pqys pdq,
1253: okl_pdt_qualitys pqy
1254: Where pdq.Id <> p_pdqv_tbl(j).Id
1255: and pdq.pqy_id = pqy.id
1256: and pqy.name in ('LEASE','TAXOWNER','REVENUE RECOGNITION METHOD','INTEREST_CALCULATION_BASIS')