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,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
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;
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;
36: TYPE okl_srch_strm_typs_h_tbl_type IS TABLE OF 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;
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;
38: */ -- history tables not supported -- 04 APR 2002
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,
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,
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,
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,
38: */ -- history tables not supported -- 04 APR 2002
39: TYPE sst_rec_type IS RECORD (
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,
39: TYPE sst_rec_type IS RECORD (
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,
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,
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,
65: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
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;
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;
67: TYPE sst_tbl_type IS TABLE OF 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;
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;
69: TYPE sstv_rec_type IS RECORD (
66: g_miss_sst_rec sst_rec_type;
67: TYPE sst_tbl_type IS TABLE OF sst_rec_type
68: INDEX BY BINARY_INTEGER;
69: TYPE sstv_rec_type IS RECORD (
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,
67: TYPE sst_tbl_type IS TABLE OF sst_rec_type
68: INDEX BY BINARY_INTEGER;
69: TYPE sstv_rec_type IS RECORD (
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,
68: INDEX BY BINARY_INTEGER;
69: TYPE sstv_rec_type IS RECORD (
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,
69: TYPE sstv_rec_type IS RECORD (
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,
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,
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,
95: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
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;
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;
97: TYPE sstv_tbl_type IS TABLE OF 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;
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;
99: ---------------------------------------------------------------------------
98: INDEX BY BINARY_INTEGER;
99: ---------------------------------------------------------------------------
100: -- GLOBAL MESSAGE CONSTANTS
101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
99: ---------------------------------------------------------------------------
100: -- GLOBAL MESSAGE CONSTANTS
101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
100: -- GLOBAL MESSAGE CONSTANTS
101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
102: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
112: ---------------------------------------------------------------------------
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
112: ---------------------------------------------------------------------------
113: -- GLOBAL VARIABLES
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
112: ---------------------------------------------------------------------------
113: -- GLOBAL VARIABLES
114: ---------------------------------------------------------------------------
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
112: ---------------------------------------------------------------------------
113: -- GLOBAL VARIABLES
114: ---------------------------------------------------------------------------
115: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SST_PVT';
112: ---------------------------------------------------------------------------
113: -- GLOBAL VARIABLES
114: ---------------------------------------------------------------------------
115: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SST_PVT';
116: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
117: ---------------------------------------------------------------------------
118: -- ADDED AFTER TAPI 04/17/2001
119: ---------------------------------------------------------------------------
120: ---------------------------------------------------------------------------
138: PROCEDURE change_version;
139: PROCEDURE api_copy;
140: PROCEDURE insert_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_sstv_rec IN sstv_rec_type,
147: x_sstv_rec OUT NOCOPY sstv_rec_type);
148:
149: PROCEDURE insert_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_sstv_tbl IN sstv_tbl_type,
156: x_sstv_tbl OUT NOCOPY sstv_tbl_type);
157:
158: PROCEDURE lock_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_sstv_rec IN sstv_rec_type);
164: p_sstv_rec IN sstv_rec_type);
165:
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_sstv_tbl IN sstv_tbl_type);
172: p_sstv_tbl IN sstv_tbl_type);
173:
174: PROCEDURE update_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_sstv_rec IN sstv_rec_type,
181: x_sstv_rec OUT NOCOPY sstv_rec_type);
182:
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_sstv_tbl IN sstv_tbl_type,
190: x_sstv_tbl OUT NOCOPY sstv_tbl_type);
191:
192: PROCEDURE delete_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_sstv_rec IN sstv_rec_type);
198: p_sstv_rec IN sstv_rec_type);
199:
200: PROCEDURE delete_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_sstv_tbl IN sstv_tbl_type);
206: p_sstv_tbl IN sstv_tbl_type);
207:
208: PROCEDURE validate_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_sstv_rec IN sstv_rec_type);
214: p_sstv_rec IN sstv_rec_type);
215:
216: PROCEDURE validate_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_sstv_tbl IN sstv_tbl_type);