4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE pdt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_PRODUCTS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: aes_id NUMBER := OKC_API.G_MISS_NUM,
10: ptl_id NUMBER := OKC_API.G_MISS_NUM,
11: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
12: version OKL_PRODUCTS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_PRODUCTS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: aes_id NUMBER := OKC_API.G_MISS_NUM,
10: ptl_id NUMBER := OKC_API.G_MISS_NUM,
11: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
12: version OKL_PRODUCTS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: description OKL_PRODUCTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
15: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_PRODUCTS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: aes_id NUMBER := OKC_API.G_MISS_NUM,
10: ptl_id NUMBER := OKC_API.G_MISS_NUM,
11: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
12: version OKL_PRODUCTS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: description OKL_PRODUCTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
15: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
16: product_status_code OKL_PRODUCTS.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
10: ptl_id NUMBER := OKC_API.G_MISS_NUM,
11: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
12: version OKL_PRODUCTS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: description OKL_PRODUCTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
15: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
16: product_status_code OKL_PRODUCTS.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
12: version OKL_PRODUCTS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: description OKL_PRODUCTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
15: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
16: product_status_code OKL_PRODUCTS.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: description OKL_PRODUCTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
15: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
16: product_status_code OKL_PRODUCTS.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
14: description OKL_PRODUCTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
15: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
16: product_status_code OKL_PRODUCTS.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
15: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
16: product_status_code OKL_PRODUCTS.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
16: product_status_code OKL_PRODUCTS.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_PRODUCTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_PRODUCTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_PRODUCTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: last_update_date OKL_PRODUCTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_PRODUCTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: last_update_date OKL_PRODUCTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: g_miss_pdt_rec pdt_rec_type;
34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_PRODUCTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: last_update_date OKL_PRODUCTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: g_miss_pdt_rec pdt_rec_type;
41: TYPE pdt_tbl_type IS TABLE OF pdt_rec_type
42: INDEX BY BINARY_INTEGER;
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: aes_id NUMBER := OKC_API.G_MISS_NUM,
47: ptl_id NUMBER := OKC_API.G_MISS_NUM,
48: name OKL_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
49: description OKL_PRODUCTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
51: product_status_code OKL_PRODUCTS_V.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: aes_id NUMBER := OKC_API.G_MISS_NUM,
47: ptl_id NUMBER := OKC_API.G_MISS_NUM,
48: name OKL_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
49: description OKL_PRODUCTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
51: product_status_code OKL_PRODUCTS_V.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
47: ptl_id NUMBER := OKC_API.G_MISS_NUM,
48: name OKL_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
49: description OKL_PRODUCTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
51: product_status_code OKL_PRODUCTS_V.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
48: name OKL_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
49: description OKL_PRODUCTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
51: product_status_code OKL_PRODUCTS_V.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
49: description OKL_PRODUCTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
51: product_status_code OKL_PRODUCTS_V.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: reporting_pdt_id NUMBER := OKC_API.G_MISS_NUM,
51: product_status_code OKL_PRODUCTS_V.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: product_status_code OKL_PRODUCTS_V.product_status_code%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: g_miss_pdtv_rec pdtv_rec_type;
71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: g_miss_pdtv_rec pdtv_rec_type;
78: TYPE pdtv_tbl_type IS TABLE OF pdtv_rec_type
79: INDEX BY BINARY_INTEGER;