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_LA_STREAM_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 110: p_khr_id IN okl_k_headers_full_v.id%TYPE,

106: END;
107: -- Added new procedure for get the streams for reporting and original product
108: PROCEDURE get_primary_pricing_name
109: (
110: p_khr_id IN okl_k_headers_full_v.id%TYPE,
111: p_sty_id IN okl_strm_type_b.ID%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_primary_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
114: )

Line 120: FROM okl_k_headers_full_v

116: IS
117:
118: CURSOR cntrct_csr (l_khr_id NUMBER)IS
119: SELECT pdt_id, start_date
120: FROM okl_k_headers_full_v
121: WHERE id = l_khr_id;
122:
123: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
124: SELECT PRICING_NAME

Line 217: p_khr_id IN okl_k_headers_full_v.id%TYPE,

213: END get_primary_pricing_name;
214:
215: PROCEDURE get_dependent_pricing_name
216: (
217: p_khr_id IN okl_k_headers_full_v.id%TYPE,
218: p_sty_id IN okl_strm_type_b.ID%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_dependent_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
221: )

Line 227: FROM okl_k_headers_full_v

223: IS
224:
225: CURSOR cntrct_csr (l_khr_id NUMBER)IS
226: SELECT pdt_id, start_date
227: FROM okl_k_headers_full_v
228: WHERE id = l_khr_id;
229:
230: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
231: SELECT PRICING_NAME

Line 326: p_khr_id IN okl_k_headers_full_v.id%TYPE,

322: END get_dependent_pricing_name;
323:
324: PROCEDURE get_primary_stream_type
325: (
326: p_khr_id IN okl_k_headers_full_v.id%TYPE,
327: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_primary_sty_id OUT NOCOPY strm_rec_type
330: )

Line 336: FROM okl_k_headers_full_v

332: IS
333:
334: CURSOR cntrct_csr (l_khr_id NUMBER)IS
335: SELECT pdt_id, start_date
336: FROM okl_k_headers_full_v
337: WHERE id = l_khr_id;
338:
339: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
340: SELECT PRIMARY_STY_ID, PRICING_NAME

Line 428: p_khr_id IN okl_k_headers_full_v.id%TYPE,

424: END get_primary_stream_type;
425:
426: PROCEDURE get_primary_no_prc_stream_type
427: (
428: p_khr_id IN okl_k_headers_full_v.id%TYPE,
429: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
430: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_primary_sty_id OUT NOCOPY strm_rec_type

Line 429: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

425:
426: PROCEDURE get_primary_no_prc_stream_type
427: (
428: p_khr_id IN okl_k_headers_full_v.id%TYPE,
429: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
430: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_primary_sty_id OUT NOCOPY strm_rec_type
433: )

Line 441: FROM okl_k_headers_full_v

437: IS
438:
439: CURSOR cntrct_csr (l_khr_id NUMBER)IS
440: SELECT pdt_id, start_date
441: FROM okl_k_headers_full_v
442: WHERE id = l_khr_id;
443:
444: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
445: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 533: p_khr_id IN okl_k_headers_full_v.id%TYPE,

529: END get_primary_no_prc_stream_type;
530:
531: PROCEDURE get_dep_no_prc_stream_type
532: (
533: p_khr_id IN okl_k_headers_full_v.id%TYPE,
534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
535: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
536: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: x_return_status OUT NOCOPY VARCHAR2,

Line 534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

530:
531: PROCEDURE get_dep_no_prc_stream_type
532: (
533: p_khr_id IN okl_k_headers_full_v.id%TYPE,
534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
535: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
536: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 545: FROM okl_k_headers_full_v

541: IS
542:
543: CURSOR cntrct_csr (l_khr_id NUMBER)IS
544: SELECT pdt_id, start_date
545: FROM okl_k_headers_full_v
546: WHERE id = l_khr_id;
547:
548: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
549: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 640: p_khr_id IN okl_k_headers_full_v.id%TYPE,

636: END get_dep_no_prc_stream_type;
637:
638: PROCEDURE get_dep_no_prc_stream_type
639: (
640: p_khr_id IN okl_k_headers_full_v.id%TYPE,
641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
642: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
643: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
644: x_return_status OUT NOCOPY VARCHAR2,

Line 641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

637:
638: PROCEDURE get_dep_no_prc_stream_type
639: (
640: p_khr_id IN okl_k_headers_full_v.id%TYPE,
641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
642: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
643: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
644: x_return_status OUT NOCOPY VARCHAR2,
645: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 652: FROM okl_k_headers_full_v

648: IS
649:
650: CURSOR cntrct_csr (l_khr_id NUMBER)IS
651: SELECT pdt_id, start_date
652: FROM okl_k_headers_full_v
653: WHERE id = l_khr_id;
654:
655: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
656: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 747: p_khr_id IN okl_k_headers_full_v.id%TYPE,

743: END get_dep_no_prc_stream_type;
744:
745: PROCEDURE get_dep_no_prc_stream_type
746: (
747: p_khr_id IN okl_k_headers_full_v.id%TYPE,
748: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
749: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
750: x_return_status OUT NOCOPY VARCHAR2,
751: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 758: FROM okl_k_headers_full_v

754: IS
755:
756: CURSOR cntrct_csr (l_khr_id NUMBER)IS
757: SELECT pdt_id, start_date
758: FROM okl_k_headers_full_v
759: WHERE id = l_khr_id;
760:
761: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
762: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 854: p_khr_id IN okl_k_headers_full_v.id%TYPE,

850:
851:
852: PROCEDURE get_primary_stream_type
853: (
854: p_khr_id IN okl_k_headers_full_v.id%TYPE,
855: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
856: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_primary_sty_id OUT NOCOPY strm_rec_type

Line 855: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

851:
852: PROCEDURE get_primary_stream_type
853: (
854: p_khr_id IN okl_k_headers_full_v.id%TYPE,
855: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
856: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_primary_sty_id OUT NOCOPY strm_rec_type
859: )

Line 867: FROM okl_k_headers_full_v

863: IS
864:
865: CURSOR cntrct_csr (l_khr_id NUMBER)IS
866: SELECT pdt_id, start_date
867: FROM okl_k_headers_full_v
868: WHERE id = l_khr_id;
869:
870: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
871: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 960: p_khr_id IN okl_k_headers_full_v.id%TYPE,

956: END get_primary_stream_type;
957:
958: PROCEDURE get_primary_stream_types
959: (
960: p_khr_id IN okl_k_headers_full_v.id%TYPE,
961: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
962: x_return_status OUT NOCOPY VARCHAR2,
963: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
964: )

Line 970: FROM okl_k_headers_full_v

966: IS
967:
968: CURSOR cntrct_csr (l_khr_id NUMBER)IS
969: SELECT pdt_id, start_date
970: FROM okl_k_headers_full_v
971: WHERE id = l_khr_id;
972:
973: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
974: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 1062: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1058: END get_primary_stream_types;
1059:
1060: PROCEDURE get_dependent_stream_type
1061: (
1062: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1063: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1064: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1065: x_return_status OUT NOCOPY VARCHAR2,
1066: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1073: FROM okl_k_headers_full_v

1069: IS
1070:
1071: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1072: SELECT pdt_id, start_date
1073: FROM okl_k_headers_full_v
1074: WHERE id = l_khr_id;
1075:
1076: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1077: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1166: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1162: END get_dependent_stream_type;
1163:
1164: PROCEDURE get_dependent_stream_type
1165: (
1166: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1167: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1168: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1169: x_return_status OUT NOCOPY VARCHAR2,
1170: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1177: FROM okl_k_headers_full_v

1173: IS
1174:
1175: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1176: SELECT pdt_id, start_date
1177: FROM okl_k_headers_full_v
1178: WHERE id = l_khr_id;
1179:
1180: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1181: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1269: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1265:
1266: END get_dependent_stream_type;
1267: PROCEDURE get_dependent_stream_types
1268: (
1269: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1270: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1271: x_return_status OUT NOCOPY VARCHAR2,
1272: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1273: )

Line 1279: FROM okl_k_headers_full_v

1275: IS
1276:
1277: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1278: SELECT pdt_id, start_date
1279: FROM okl_k_headers_full_v
1280: WHERE id = l_khr_id;
1281:
1282: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1283: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1368: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1364:
1365:
1366: PROCEDURE get_dependent_stream_types
1367: (
1368: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1369: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1370: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type

Line 1369: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1365:
1366: PROCEDURE get_dependent_stream_types
1367: (
1368: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1369: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1370: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1373: )

Line 1379: FROM okl_k_headers_full_v

1375: IS
1376:
1377: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1378: SELECT pdt_id, start_date
1379: FROM okl_k_headers_full_v
1380: WHERE id = l_khr_id;
1381:
1382: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1383: SELECT DEPENDENT_STY_ID, PRICING_NAME

Line 1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1463: END get_dependent_stream_types;
1464:
1465: PROCEDURE get_dependent_stream_type
1466: (
1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1469: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1470: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1471: x_return_status OUT NOCOPY VARCHAR2,

Line 1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1464:
1465: PROCEDURE get_dependent_stream_type
1466: (
1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1469: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1470: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1471: x_return_status OUT NOCOPY VARCHAR2,
1472: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1479: FROM okl_k_headers_full_v

1475: IS
1476:
1477: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1478: SELECT pdt_id, start_date
1479: FROM okl_k_headers_full_v
1480: WHERE id = l_khr_id;
1481:
1482: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1483: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1571: END get_dependent_stream_type;
1572:
1573: PROCEDURE get_dependent_stream_type
1574: (
1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1577: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1578: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1579: x_return_status OUT NOCOPY VARCHAR2,

Line 1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1572:
1573: PROCEDURE get_dependent_stream_type
1574: (
1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1577: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1578: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1579: x_return_status OUT NOCOPY VARCHAR2,
1580: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1587: FROM okl_k_headers_full_v

1583: IS
1584:
1585: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1586: SELECT pdt_id, start_date
1587: FROM okl_k_headers_full_v
1588: WHERE id = l_khr_id;
1589:
1590: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1591: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 7109: from okl_k_headers_full_v

7105:
7106:
7107: Cursor ylds_csr( chrId NUMBER ) IS
7108: Select 'N' exist
7109: from okl_k_headers_full_v
7110: where id = chrId
7111: and pre_tax_yield is NULL
7112: and after_tax_yield is NULL
7113: and pre_tax_irr is NULL