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