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_STRM_TYPE_B

Line 681: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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: )
685:

Line 683: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%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: )
685:
686: IS
687:

Line 786: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%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: )
790:

Line 885: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%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: )
889:

Line 887: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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: )
889:
890: IS
891:

Line 991: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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: )
995:

Line 1091: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1095: )

Line 1092: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1095: )
1096:

Line 1094: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
1095: )
1096:
1097: IS
1098:

Line 1195: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

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
1199: )

Line 1196: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1199: )
1200:

Line 1198: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
1199: )
1200:
1201: IS
1202:

Line 1303: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1307: )

Line 1304: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%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
1307: )
1308:

Line 1306: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.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
1307: )
1308:
1309: IS
1310:

Line 1399: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%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
1403: )

Line 1400: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1403: )
1404:

Line 1402: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
1403: )
1404:
1405: IS
1406:

Line 1504: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

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
1508: )

Line 1505: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1508: )
1509:

Line 1507: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
1508: )
1509:
1510: IS
1511:

Line 1613: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1617: )

Line 1614: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
1617: )
1618:

Line 1616: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.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
1617: )
1618:
1619: IS
1620:

Line 1714: p_sty_id IN okl_strm_type_b.ID%TYPE

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
1718: