3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: /* -- history tables not supported -- 04 APR 2002
7: TYPE okl_srch_strm_typs_h_rec_type IS RECORD (
8: id NUMBER := Okl_Api.G_MISS_NUM,
9: major_version NUMBER := Okl_Api.G_MISS_NUM,
10: sty_id NUMBER := Okl_Api.G_MISS_NUM,
11: cah_id NUMBER := Okl_Api.G_MISS_NUM,
9: major_version NUMBER := Okl_Api.G_MISS_NUM,
10: sty_id NUMBER := Okl_Api.G_MISS_NUM,
11: cah_id NUMBER := Okl_Api.G_MISS_NUM,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
13: add_yn OKL_SRCH_STRM_TYPS_H.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute_category OKL_SRCH_STRM_TYPS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
10: sty_id NUMBER := Okl_Api.G_MISS_NUM,
11: cah_id NUMBER := Okl_Api.G_MISS_NUM,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
13: add_yn OKL_SRCH_STRM_TYPS_H.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute_category OKL_SRCH_STRM_TYPS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
11: cah_id NUMBER := Okl_Api.G_MISS_NUM,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
13: add_yn OKL_SRCH_STRM_TYPS_H.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute_category OKL_SRCH_STRM_TYPS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
13: add_yn OKL_SRCH_STRM_TYPS_H.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute_category OKL_SRCH_STRM_TYPS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
13: add_yn OKL_SRCH_STRM_TYPS_H.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute_category OKL_SRCH_STRM_TYPS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute_category OKL_SRCH_STRM_TYPS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
23: attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_SRCH_STRM_TYPS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
24: attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_SRCH_STRM_TYPS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
25: attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_SRCH_STRM_TYPS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_SRCH_STRM_TYPS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_SRCH_STRM_TYPS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_SRCH_STRM_TYPS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: GMissOklSrchStrmTypsHRec okl_srch_strm_typs_h_rec_type;
29: attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_SRCH_STRM_TYPS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_SRCH_STRM_TYPS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: GMissOklSrchStrmTypsHRec okl_srch_strm_typs_h_rec_type;
36: TYPE okl_srch_strm_typs_h_tbl_type IS TABLE OF okl_srch_strm_typs_h_rec_type
37: INDEX BY BINARY_INTEGER;
31: creation_date OKL_SRCH_STRM_TYPS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_SRCH_STRM_TYPS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: GMissOklSrchStrmTypsHRec okl_srch_strm_typs_h_rec_type;
36: TYPE okl_srch_strm_typs_h_tbl_type IS TABLE OF okl_srch_strm_typs_h_rec_type
37: INDEX BY BINARY_INTEGER;
38: */ -- history tables not supported -- 04 APR 2002
39: TYPE sst_rec_type IS RECORD (
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_SRCH_STRM_TYPS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: GMissOklSrchStrmTypsHRec okl_srch_strm_typs_h_rec_type;
36: TYPE okl_srch_strm_typs_h_tbl_type IS TABLE OF okl_srch_strm_typs_h_rec_type
37: INDEX BY BINARY_INTEGER;
38: */ -- history tables not supported -- 04 APR 2002
39: TYPE sst_rec_type IS RECORD (
40: id NUMBER := Okl_Api.G_MISS_NUM,
40: id NUMBER := Okl_Api.G_MISS_NUM,
41: sty_id NUMBER := Okl_Api.G_MISS_NUM,
42: cah_id NUMBER := Okl_Api.G_MISS_NUM,
43: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
44: add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute_category OKL_SRCH_STRM_TYPS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
41: sty_id NUMBER := Okl_Api.G_MISS_NUM,
42: cah_id NUMBER := Okl_Api.G_MISS_NUM,
43: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
44: add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute_category OKL_SRCH_STRM_TYPS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
42: cah_id NUMBER := Okl_Api.G_MISS_NUM,
43: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
44: add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute_category OKL_SRCH_STRM_TYPS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
43: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
44: add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute_category OKL_SRCH_STRM_TYPS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
44: add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute_category OKL_SRCH_STRM_TYPS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute_category OKL_SRCH_STRM_TYPS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
61: created_by NUMBER := Okl_Api.G_MISS_NUM,
54: attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
61: created_by NUMBER := Okl_Api.G_MISS_NUM,
62: creation_date OKL_SRCH_STRM_TYPS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
61: created_by NUMBER := Okl_Api.G_MISS_NUM,
62: creation_date OKL_SRCH_STRM_TYPS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
56: attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
61: created_by NUMBER := Okl_Api.G_MISS_NUM,
62: creation_date OKL_SRCH_STRM_TYPS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
64: last_update_date OKL_SRCH_STRM_TYPS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
61: created_by NUMBER := Okl_Api.G_MISS_NUM,
62: creation_date OKL_SRCH_STRM_TYPS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
64: last_update_date OKL_SRCH_STRM_TYPS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
66: g_miss_sst_rec sst_rec_type;
60: attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
61: created_by NUMBER := Okl_Api.G_MISS_NUM,
62: creation_date OKL_SRCH_STRM_TYPS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
64: last_update_date OKL_SRCH_STRM_TYPS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
66: g_miss_sst_rec sst_rec_type;
67: TYPE sst_tbl_type IS TABLE OF sst_rec_type
68: INDEX BY BINARY_INTEGER;
70: id NUMBER := Okl_Api.G_MISS_NUM,
71: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
72: sty_id NUMBER := Okl_Api.G_MISS_NUM,
73: cah_id NUMBER := Okl_Api.G_MISS_NUM,
74: add_yn OKL_SRCH_STRM_TYPS_V.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute_category OKL_SRCH_STRM_TYPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
71: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
72: sty_id NUMBER := Okl_Api.G_MISS_NUM,
73: cah_id NUMBER := Okl_Api.G_MISS_NUM,
74: add_yn OKL_SRCH_STRM_TYPS_V.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute_category OKL_SRCH_STRM_TYPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
72: sty_id NUMBER := Okl_Api.G_MISS_NUM,
73: cah_id NUMBER := Okl_Api.G_MISS_NUM,
74: add_yn OKL_SRCH_STRM_TYPS_V.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute_category OKL_SRCH_STRM_TYPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
73: cah_id NUMBER := Okl_Api.G_MISS_NUM,
74: add_yn OKL_SRCH_STRM_TYPS_V.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute_category OKL_SRCH_STRM_TYPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
74: add_yn OKL_SRCH_STRM_TYPS_V.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute_category OKL_SRCH_STRM_TYPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute_category OKL_SRCH_STRM_TYPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89: attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
82: attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89: attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
90: attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
83: attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89: attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
90: attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
91: created_by NUMBER := Okl_Api.G_MISS_NUM,
84: attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89: attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
90: attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
91: created_by NUMBER := Okl_Api.G_MISS_NUM,
92: creation_date OKL_SRCH_STRM_TYPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
85: attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89: attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
90: attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
91: created_by NUMBER := Okl_Api.G_MISS_NUM,
92: creation_date OKL_SRCH_STRM_TYPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
86: attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87: attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89: attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
90: attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
91: created_by NUMBER := Okl_Api.G_MISS_NUM,
92: creation_date OKL_SRCH_STRM_TYPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
94: last_update_date OKL_SRCH_STRM_TYPS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
88: attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89: attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
90: attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
91: created_by NUMBER := Okl_Api.G_MISS_NUM,
92: creation_date OKL_SRCH_STRM_TYPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
94: last_update_date OKL_SRCH_STRM_TYPS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
95: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
96: g_miss_sstv_rec sstv_rec_type;
90: attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
91: created_by NUMBER := Okl_Api.G_MISS_NUM,
92: creation_date OKL_SRCH_STRM_TYPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
94: last_update_date OKL_SRCH_STRM_TYPS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
95: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
96: g_miss_sstv_rec sstv_rec_type;
97: TYPE sstv_tbl_type IS TABLE OF sstv_rec_type
98: INDEX BY BINARY_INTEGER;