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 109: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 119: FROM okl_k_headers_full_v

115: IS
116:
117: CURSOR cntrct_csr (l_khr_id NUMBER)IS
118: SELECT pdt_id, start_date
119: FROM okl_k_headers_full_v
120: WHERE id = l_khr_id;
121:
122: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
123: 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 327: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 337: FROM okl_k_headers_full_v

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

Line 429: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 430: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

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

Line 442: FROM okl_k_headers_full_v

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

Line 534: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 535: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

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

Line 546: FROM okl_k_headers_full_v

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

Line 638: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 639: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

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

Line 650: FROM okl_k_headers_full_v

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

Line 740: p_khr_id IN okl_k_headers_full_v.id%TYPE,

736: END get_dep_no_prc_stream_type;
737:
738: PROCEDURE get_dep_no_prc_stream_type
739: (
740: p_khr_id IN okl_k_headers_full_v.id%TYPE,
741: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
742: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
743: x_return_status OUT NOCOPY VARCHAR2,
744: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 751: FROM okl_k_headers_full_v

747: IS
748:
749: CURSOR cntrct_csr (l_khr_id NUMBER)IS
750: SELECT pdt_id, start_date
751: FROM okl_k_headers_full_v
752: WHERE id = l_khr_id;
753:
754: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
755: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 842: p_khr_id IN okl_k_headers_full_v.id%TYPE,

838:
839:
840: PROCEDURE get_primary_stream_type
841: (
842: p_khr_id IN okl_k_headers_full_v.id%TYPE,
843: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
844: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_primary_sty_id OUT NOCOPY strm_rec_type

Line 843: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

839:
840: PROCEDURE get_primary_stream_type
841: (
842: p_khr_id IN okl_k_headers_full_v.id%TYPE,
843: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
844: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_primary_sty_id OUT NOCOPY strm_rec_type
847: )

Line 855: FROM okl_k_headers_full_v

851: IS
852:
853: CURSOR cntrct_csr (l_khr_id NUMBER)IS
854: SELECT pdt_id, start_date
855: FROM okl_k_headers_full_v
856: WHERE id = l_khr_id;
857:
858: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
859: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 954: p_khr_id IN okl_k_headers_full_v.id%TYPE,

950: END get_primary_stream_type;
951:
952: PROCEDURE get_primary_stream_types
953: (
954: p_khr_id IN okl_k_headers_full_v.id%TYPE,
955: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
956: x_return_status OUT NOCOPY VARCHAR2,
957: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
958: )

Line 964: FROM okl_k_headers_full_v

960: IS
961:
962: CURSOR cntrct_csr (l_khr_id NUMBER)IS
963: SELECT pdt_id, start_date
964: FROM okl_k_headers_full_v
965: WHERE id = l_khr_id;
966:
967: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
968: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 1056: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1052: END get_primary_stream_types;
1053:
1054: PROCEDURE get_dependent_stream_type
1055: (
1056: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1057: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1058: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1067: FROM okl_k_headers_full_v

1063: IS
1064:
1065: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1066: SELECT pdt_id, start_date
1067: FROM okl_k_headers_full_v
1068: WHERE id = l_khr_id;
1069:
1070: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1071: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1155: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1151: END get_dependent_stream_type;
1152:
1153: PROCEDURE get_dependent_stream_type
1154: (
1155: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1156: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1157: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1166: FROM okl_k_headers_full_v

1162: IS
1163:
1164: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1165: SELECT pdt_id, start_date
1166: FROM okl_k_headers_full_v
1167: WHERE id = l_khr_id;
1168:
1169: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1170: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1253: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1249:
1250: END get_dependent_stream_type;
1251: PROCEDURE get_dependent_stream_types
1252: (
1253: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1254: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1255: x_return_status OUT NOCOPY VARCHAR2,
1256: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1257: )

Line 1263: FROM okl_k_headers_full_v

1259: IS
1260:
1261: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1262: SELECT pdt_id, start_date
1263: FROM okl_k_headers_full_v
1264: WHERE id = l_khr_id;
1265:
1266: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1267: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1347: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1343:
1344:
1345: PROCEDURE get_dependent_stream_types
1346: (
1347: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1348: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1349: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type

Line 1348: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1344:
1345: PROCEDURE get_dependent_stream_types
1346: (
1347: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1348: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1349: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1352: )

Line 1358: FROM okl_k_headers_full_v

1354: IS
1355:
1356: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1357: SELECT pdt_id, start_date
1358: FROM okl_k_headers_full_v
1359: WHERE id = l_khr_id;
1360:
1361: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1362: SELECT DEPENDENT_STY_ID, PRICING_NAME

Line 1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1437: END get_dependent_stream_types;
1438:
1439: PROCEDURE get_dependent_stream_type
1440: (
1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1443: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1444: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1445: x_return_status OUT NOCOPY VARCHAR2,

Line 1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1438:
1439: PROCEDURE get_dependent_stream_type
1440: (
1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1443: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1444: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1445: x_return_status OUT NOCOPY VARCHAR2,
1446: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1453: FROM okl_k_headers_full_v

1449: IS
1450:
1451: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1452: SELECT pdt_id, start_date
1453: FROM okl_k_headers_full_v
1454: WHERE id = l_khr_id;
1455:
1456: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1457: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1547: END get_dependent_stream_type;
1548:
1549: PROCEDURE get_dependent_stream_type
1550: (
1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1553: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1554: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1555: x_return_status OUT NOCOPY VARCHAR2,

Line 1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1548:
1549: PROCEDURE get_dependent_stream_type
1550: (
1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1553: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1554: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1555: x_return_status OUT NOCOPY VARCHAR2,
1556: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1563: FROM okl_k_headers_full_v

1559: IS
1560:
1561: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1562: SELECT pdt_id, start_date
1563: FROM okl_k_headers_full_v
1564: WHERE id = l_khr_id;
1565:
1566: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1567: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 8603: from okl_k_headers_full_v

8599:
8600:
8601: Cursor ylds_csr( chrId NUMBER ) IS
8602: Select 'N' exist
8603: from okl_k_headers_full_v
8604: where id = chrId
8605: and pre_tax_yield is NULL
8606: and after_tax_yield is NULL
8607: and pre_tax_irr is NULL