3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ils_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: sty_id NUMBER := Okl_Api.G_MISS_NUM,
9: inf_id NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ils_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: sty_id NUMBER := Okl_Api.G_MISS_NUM,
9: inf_id NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE ils_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: sty_id NUMBER := Okl_Api.G_MISS_NUM,
9: inf_id NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
6: TYPE ils_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: sty_id NUMBER := Okl_Api.G_MISS_NUM,
9: inf_id NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: sty_id NUMBER := Okl_Api.G_MISS_NUM,
9: inf_id NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
8: sty_id NUMBER := Okl_Api.G_MISS_NUM,
9: inf_id NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
9: inf_id NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
11: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
12: attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
13: attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
21: attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
22: attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
23: attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31: last_update_date OKL_INVC_FRMT_STRMS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
24: attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31: last_update_date OKL_INVC_FRMT_STRMS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
25: attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31: last_update_date OKL_INVC_FRMT_STRMS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
33: g_miss_ils_rec ils_rec_type;
26: attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31: last_update_date OKL_INVC_FRMT_STRMS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
33: g_miss_ils_rec ils_rec_type;
34: TYPE ils_tbl_type IS TABLE OF ils_rec_type
27: attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31: last_update_date OKL_INVC_FRMT_STRMS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
33: g_miss_ils_rec ils_rec_type;
34: TYPE ils_tbl_type IS TABLE OF ils_rec_type
35: INDEX BY BINARY_INTEGER;
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31: last_update_date OKL_INVC_FRMT_STRMS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
33: g_miss_ils_rec ils_rec_type;
34: TYPE ils_tbl_type IS TABLE OF ils_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE ilsv_rec_type IS RECORD (
33: g_miss_ils_rec ils_rec_type;
34: TYPE ils_tbl_type IS TABLE OF ils_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE ilsv_rec_type IS RECORD (
37: id NUMBER := Okl_Api.G_MISS_NUM,
38: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
39: sty_id NUMBER := Okl_Api.G_MISS_NUM,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
34: TYPE ils_tbl_type IS TABLE OF ils_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE ilsv_rec_type IS RECORD (
37: id NUMBER := Okl_Api.G_MISS_NUM,
38: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
39: sty_id NUMBER := Okl_Api.G_MISS_NUM,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
35: INDEX BY BINARY_INTEGER;
36: TYPE ilsv_rec_type IS RECORD (
37: id NUMBER := Okl_Api.G_MISS_NUM,
38: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
39: sty_id NUMBER := Okl_Api.G_MISS_NUM,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
36: TYPE ilsv_rec_type IS RECORD (
37: id NUMBER := Okl_Api.G_MISS_NUM,
38: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
39: sty_id NUMBER := Okl_Api.G_MISS_NUM,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
37: id NUMBER := Okl_Api.G_MISS_NUM,
38: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
39: sty_id NUMBER := Okl_Api.G_MISS_NUM,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
38: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
39: sty_id NUMBER := Okl_Api.G_MISS_NUM,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
39: sty_id NUMBER := Okl_Api.G_MISS_NUM,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
40: inf_id NUMBER := Okl_Api.G_MISS_NUM,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
41: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
51: attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
52: attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
53: attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
61: last_update_date OKL_INVC_FRMT_STRMS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
54: attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
61: last_update_date OKL_INVC_FRMT_STRMS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
55: attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
61: last_update_date OKL_INVC_FRMT_STRMS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_ilsv_rec ilsv_rec_type;
56: attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
61: last_update_date OKL_INVC_FRMT_STRMS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_ilsv_rec ilsv_rec_type;
64: TYPE ilsv_tbl_type IS TABLE OF ilsv_rec_type
57: attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
61: last_update_date OKL_INVC_FRMT_STRMS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_ilsv_rec ilsv_rec_type;
64: TYPE ilsv_tbl_type IS TABLE OF ilsv_rec_type
65: INDEX BY BINARY_INTEGER;
58: created_by NUMBER := Okl_Api.G_MISS_NUM,
59: creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
61: last_update_date OKL_INVC_FRMT_STRMS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_ilsv_rec ilsv_rec_type;
64: TYPE ilsv_tbl_type IS TABLE OF ilsv_rec_type
65: INDEX BY BINARY_INTEGER;
66: ---------------------------------------------------------------------------
65: INDEX BY BINARY_INTEGER;
66: ---------------------------------------------------------------------------
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
66: ---------------------------------------------------------------------------
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
69: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
79:
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
79:
80: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
79:
80: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
81: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
79:
80: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
81: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
82: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
85: ---------------------------------------------------------------------------
86: -- GLOBAL VARIABLES
87: ---------------------------------------------------------------------------
88: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ILS_PVT';
89: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
90:
91: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTD_SELL_INVS_V';
92: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
93:
100: PROCEDURE change_version;
101: PROCEDURE api_copy;
102: PROCEDURE insert_row(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_ilsv_rec IN ilsv_rec_type,
109: x_ilsv_rec OUT NOCOPY ilsv_rec_type);
110:
111: PROCEDURE insert_row(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_ilsv_tbl IN ilsv_tbl_type,
118: x_ilsv_tbl OUT NOCOPY ilsv_tbl_type);
119:
120: PROCEDURE lock_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_ilsv_rec IN ilsv_rec_type);
126: p_ilsv_rec IN ilsv_rec_type);
127:
128: PROCEDURE lock_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_ilsv_tbl IN ilsv_tbl_type);
134: p_ilsv_tbl IN ilsv_tbl_type);
135:
136: PROCEDURE update_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_ilsv_rec IN ilsv_rec_type,
143: x_ilsv_rec OUT NOCOPY ilsv_rec_type);
144:
145: PROCEDURE update_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_ilsv_tbl IN ilsv_tbl_type,
152: x_ilsv_tbl OUT NOCOPY ilsv_tbl_type);
153:
154: PROCEDURE delete_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_ilsv_rec IN ilsv_rec_type);
160: p_ilsv_rec IN ilsv_rec_type);
161:
162: PROCEDURE delete_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_ilsv_tbl IN ilsv_tbl_type);
168: p_ilsv_tbl IN ilsv_tbl_type);
169:
170: PROCEDURE validate_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_ilsv_rec IN ilsv_rec_type);
176: p_ilsv_rec IN ilsv_rec_type);
177:
178: PROCEDURE validate_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_ilsv_tbl IN ilsv_tbl_type);