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_PQY_VALUES

Line 181: FROM Okl_Pqy_Values_V qve

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
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);

Line 200: okl_pqy_values_v qve,

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
204: AND qve.ID = pqv.QVE_ID

Line 213: okl_pqy_values_v qve,

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
217: AND qve.ID = pqv.QVE_ID

Line 246: select value from okl_pqy_values qve

242: WHERE a.aes_id = b.id
243: AND b.gts_id = c.id
244: AND a.id = p_pdt_id
245: intersect
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,

Line 261: select value from okl_pqy_values qve

257: WHERE a.aes_id = b.id
258: AND b.gts_id = c.id
259: AND a.id = p_pdt_id
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)

Line 275: select value from okl_pqy_values qve

271: WHERE a.aes_id = b.id
272: AND b.gts_id = c.id
273: AND a.id = p_pdt_id
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)

Line 289: select value from okl_pqy_values qve

285: WHERE a.aes_id = b.id
286: AND b.gts_id = c.id
287: AND a.id = p_pdt_id
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)

Line 303: select value from okl_pqy_values qve

299: WHERE a.aes_id = b.id
300: AND b.gts_id = c.id
301: AND a.id = p_pdt_id
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'

Line 546: okl_pqy_values_v c

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
549: AND c.id = p_pqvv_rec.qve_id
550: AND c.value = 'LESSEE'

Line 557: okl_pqy_values_v c

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
560: AND c.id = p_pqvv_rec.qve_id
561: AND c.value = 'LEASEOP'

Line 570: okl_pqy_values_v c

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
573: AND c.id = p_pqvv_rec.qve_id
574: AND c.value = 'LOAN-REVOLVING'

Line 581: okl_pqy_values_v c

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
584: AND c.id = p_pqvv_rec.qve_id
585: AND c.value = 'FLOAT_FACTORS'

Line 595: okl_pqy_values_v c

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
598: AND c.id = p_pqvv_rec.qve_id
599: AND c.value = 'FLOAT_FACTORS'

Line 606: okl_pqy_values_v c

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
609: AND c.id = p_pqvv_rec.qve_id
610: AND c.value = 'ESTIMATED_AND_BILLED'

Line 621: okl_pqy_values_v c

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
624: AND c.id = p_pqvv_rec.qve_id
625: AND c.value = 'LESSOR'

Line 633: okl_pqy_values_v c

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
636: AND c.id = p_pqvv_rec.qve_id
637: AND c.value = 'LOAN'

Line 647: okl_pqy_values_v c

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
650: AND c.id = p_pqvv_rec.qve_id
651: AND c.value = 'LESSOR'

Line 658: okl_pqy_values_v c

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
661: AND c.id = p_pqvv_rec.qve_id
662: AND c.value = 'LOAN-REVOLVING'

Line 805: FROM okl_pqy_values_v

801: ,x_return_status OUT NOCOPY VARCHAR2)
802: IS
803: CURSOR okl_qvev_pk_csr (p_id IN NUMBER) IS
804: SELECT '1'
805: FROM okl_pqy_values_v
806: WHERE okl_pqy_values_v.id = p_id;
807:
808: l_qve_status VARCHAR2(1);
809: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 806: WHERE okl_pqy_values_v.id = p_id;

802: IS
803: CURSOR okl_qvev_pk_csr (p_id IN NUMBER) IS
804: SELECT '1'
805: FROM okl_pqy_values_v
806: WHERE okl_pqy_values_v.id = p_id;
807:
808: l_qve_status VARCHAR2(1);
809: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
810: l_row_notfound BOOLEAN := TRUE;

Line 1033: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values

1029: END IF;
1030:
1031: /* public api to insert pqyvalues */
1032:
1033: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
1034: IF(L_DEBUG_ENABLED='Y') THEN
1035: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1036: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1037: END IF;

Line 1041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');

1037: END IF;
1038: IF(IS_DEBUG_PROCEDURE_ON) THEN
1039: BEGIN
1040:
1041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
1042: END;
1043: END IF;
1044: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
1045: p_init_msg_list => p_init_msg_list,

Line 1044: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,

1040:
1041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
1042: END;
1043: END IF;
1044: Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
1045: p_init_msg_list => p_init_msg_list,
1046: x_return_status => l_return_status,
1047: x_msg_count => x_msg_count,
1048: x_msg_data => x_msg_data,

Line 1053: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');

1049: p_pqvv_rec => l_pqvv_rec,
1050: x_pqvv_rec => x_pqvv_rec);
1051: IF(IS_DEBUG_PROCEDURE_ON) THEN
1052: BEGIN
1053: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
1054: END;
1055: END IF;
1056: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
1057:

Line 1056: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values

1052: BEGIN
1053: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
1054: END;
1055: END IF;
1056: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
1057:
1058: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1059: RAISE Okl_Api.G_EXCEPTION_ERROR;
1060: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

Line 1195: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values

1191:
1192: /* public api to update pqyvalues */
1193:
1194:
1195: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
1196: IF(L_DEBUG_ENABLED='Y') THEN
1197: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1198: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1199: END IF;

Line 1202: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');

1198: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1199: END IF;
1200: IF(IS_DEBUG_PROCEDURE_ON) THEN
1201: BEGIN
1202: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
1203: END;
1204: END IF;
1205: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
1206: p_init_msg_list => p_init_msg_list,

Line 1205: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,

1201: BEGIN
1202: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
1203: END;
1204: END IF;
1205: Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
1206: p_init_msg_list => p_init_msg_list,
1207: x_return_status => l_return_status,
1208: x_msg_count => x_msg_count,
1209: x_msg_data => x_msg_data,

Line 1214: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');

1210: p_pqvv_rec => l_pqvv_rec,
1211: x_pqvv_rec => x_pqvv_rec);
1212: IF(IS_DEBUG_PROCEDURE_ON) THEN
1213: BEGIN
1214: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
1215: END;
1216: END IF;
1217: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
1218:

Line 1217: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values

1213: BEGIN
1214: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
1215: END;
1216: END IF;
1217: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
1218:
1219: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1220: RAISE Okl_Api.G_EXCEPTION_ERROR;
1221: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN