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

Line 680: p_khr_id IN okl_k_headers_full_v.id%TYPE,

676:
677:
678: PROCEDURE get_primary_stream_type
679: (
680: p_khr_id IN okl_k_headers_full_v.id%TYPE,
681: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
682: x_return_status OUT NOCOPY VARCHAR2,
683: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE
684: )

Line 690: FROM okl_k_headers_full_v

686: IS
687:
688: CURSOR cntrct_csr (l_khr_id NUMBER)IS
689: SELECT pdt_id, start_date
690: FROM okl_k_headers_full_v
691: WHERE id = l_khr_id;
692:
693: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
694: SELECT PRIMARY_STY_ID

Line 785: p_khr_id IN okl_k_headers_full_v.id%TYPE,

781: END get_primary_stream_type;
782:
783: PROCEDURE get_primary_stream_type
784: (
785: p_khr_id IN okl_k_headers_full_v.id%TYPE,
786: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
787: x_return_status OUT NOCOPY VARCHAR2,
788: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
789: )

Line 795: FROM okl_k_headers_full_v

791: IS
792:
793: CURSOR cntrct_csr (l_khr_id NUMBER)IS
794: SELECT pdt_id, start_date
795: FROM okl_k_headers_full_v
796: WHERE id = l_khr_id;
797:
798: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
799: SELECT PRIMARY_STY_ID

Line 884: p_khr_id IN okl_k_headers_full_v.id%TYPE,

880: END get_primary_stream_type;
881:
882: PROCEDURE get_primary_stream_type_rep
883: (
884: p_khr_id IN okl_k_headers_full_v.id%TYPE,
885: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE
888: )

Line 894: FROM okl_k_headers_full_v khr, okl_products pdt

890: IS
891:
892: CURSOR cntrct_csr (l_khr_id NUMBER)IS
893: SELECT pdt.reporting_pdt_id, khr.start_date
894: FROM okl_k_headers_full_v khr, okl_products pdt
895: WHERE khr.id = l_khr_id
896: AND khr.pdt_id = pdt.id;
897:
898: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS

Line 990: p_khr_id IN okl_k_headers_full_v.id%TYPE,

986: END get_primary_stream_type_rep;
987:
988: PROCEDURE get_primary_stream_type_rep
989: (
990: p_khr_id IN okl_k_headers_full_v.id%TYPE,
991: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
992: x_return_status OUT NOCOPY VARCHAR2,
993: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
994: )

Line 1000: FROM okl_k_headers_full_v khr, okl_products pdt

996: IS
997:
998: CURSOR cntrct_csr (l_khr_id NUMBER)IS
999: SELECT pdt.reporting_pdt_id, khr.start_date
1000: FROM okl_k_headers_full_v khr, okl_products pdt
1001: WHERE khr.id = l_khr_id
1002: AND khr.pdt_id = pdt.id;
1003:
1004: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS

Line 1090: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1086: END get_primary_stream_type_rep;
1087:
1088: PROCEDURE get_dependent_stream_type
1089: (
1090: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1091: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1092: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 1101: FROM okl_k_headers_full_v

1097: IS
1098:
1099: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1100: SELECT pdt_id, start_date
1101: FROM okl_k_headers_full_v
1102: WHERE id = l_khr_id;
1103:
1104: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1105: SELECT DEPENDENT_STY_ID

Line 1194: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1190:
1191:
1192: PROCEDURE get_dependent_stream_type
1193: (
1194: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1195: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1196: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1197: x_return_status OUT NOCOPY VARCHAR2,
1198: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 1205: FROM okl_k_headers_full_v

1201: IS
1202:
1203: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1204: SELECT pdt_id, start_date
1205: FROM okl_k_headers_full_v
1206: WHERE id = l_khr_id;
1207:
1208: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1209: SELECT DEPENDENT_STY_ID

Line 1301: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1297:
1298: -- Added for bug 6326479 - start
1299: PROCEDURE get_dependent_stream_type
1300: (
1301: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1302: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
1303: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1304: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1305: x_return_status OUT NOCOPY VARCHAR2,

Line 1302: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,

1298: -- Added for bug 6326479 - start
1299: PROCEDURE get_dependent_stream_type
1300: (
1301: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1302: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
1303: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1304: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1305: x_return_status OUT NOCOPY VARCHAR2,
1306: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 1313: FROM okl_k_headers_full_v

1309: IS
1310:
1311: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1312: SELECT pdt_id, start_date
1313: FROM okl_k_headers_full_v
1314: WHERE id = l_khr_id;
1315:
1316: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1317: SELECT DEPENDENT_STY_ID

Line 1398: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1394: END get_dependent_stream_type;
1395:
1396: PROCEDURE get_dependent_stream_type_rep
1397: (
1398: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1399: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1400: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1401: x_return_status OUT NOCOPY VARCHAR2,
1402: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 1409: FROM okl_k_headers_full_v khr, okl_products pdt

1405: IS
1406:
1407: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1408: SELECT pdt.reporting_pdt_id, khr.start_date
1409: FROM okl_k_headers_full_v khr, okl_products pdt
1410: WHERE khr.id = l_khr_id
1411: AND khr.pdt_id = pdt.id;
1412:
1413: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1503: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1499:
1500:
1501: PROCEDURE get_dependent_stream_type_rep
1502: (
1503: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1504: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1505: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1506: x_return_status OUT NOCOPY VARCHAR2,
1507: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 1514: FROM okl_k_headers_full_v khr, okl_products pdt

1510: IS
1511:
1512: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1513: SELECT pdt.reporting_pdt_id, khr.start_date
1514: FROM okl_k_headers_full_v khr, okl_products pdt
1515: WHERE khr.id = l_khr_id
1516: AND khr.pdt_id = pdt.id;
1517:
1518: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1611: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1607:
1608: -- Added for bug 6326479 - start
1609: PROCEDURE get_dependent_stream_type_rep
1610: (
1611: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1612: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
1613: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1614: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1615: x_return_status OUT NOCOPY VARCHAR2,

Line 1612: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,

1608: -- Added for bug 6326479 - start
1609: PROCEDURE get_dependent_stream_type_rep
1610: (
1611: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1612: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
1613: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1614: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1615: x_return_status OUT NOCOPY VARCHAR2,
1616: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 1623: FROM okl_k_headers_full_v khr, okl_products pdt

1619: IS
1620:
1621: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1622: SELECT pdt.reporting_pdt_id, khr.start_date
1623: FROM okl_k_headers_full_v khr, okl_products pdt
1624: WHERE khr.id = l_khr_id
1625: AND khr.pdt_id = pdt.id;
1626:
1627: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1713: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1709: -- Evaluates whether a stream type is present in the stream generation
1710: -- template for a contract
1711: FUNCTION strm_tmpt_contains_strm_type
1712: (
1713: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1714: p_sty_id IN okl_strm_type_b.ID%TYPE
1715: )
1716: RETURN VARCHAR2
1717: IS

Line 1721: FROM okl_k_headers_full_v

1717: IS
1718:
1719: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1720: SELECT pdt_id, start_date
1721: FROM okl_k_headers_full_v
1722: WHERE id = l_khr_id;
1723:
1724: CURSOR sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1725: SELECT '1'