3: ---------------------------------------------------------------------------
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,
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,
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,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
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,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: description OKL_PRODUCTS.DESCRIPTION%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,
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,
17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
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,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%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,
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,
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,
39: last_update_login NUMBER := OKC_API.G_MISS_NUM);
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;
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;
41: TYPE pdt_tbl_type IS TABLE OF 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;
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;
43: TYPE pdtv_rec_type IS RECORD (
40: g_miss_pdt_rec pdt_rec_type;
41: TYPE pdt_tbl_type IS TABLE OF pdt_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE pdtv_rec_type IS RECORD (
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,
41: TYPE pdt_tbl_type IS TABLE OF pdt_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE pdtv_rec_type IS RECORD (
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,
42: INDEX BY BINARY_INTEGER;
43: TYPE pdtv_rec_type IS RECORD (
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,
43: TYPE pdtv_rec_type IS RECORD (
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,
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,
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,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
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,
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,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
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;
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;
78: TYPE pdtv_tbl_type IS TABLE OF 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;
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;
80: ---------------------------------------------------------------------------
79: INDEX BY BINARY_INTEGER;
80: ---------------------------------------------------------------------------
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: ---------------------------------------------------------------------------
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93:
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93:
94: -- RPOONUGA001: New global variables
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93:
94: -- RPOONUGA001: New global variables
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93:
94: -- RPOONUGA001: New global variables
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
96: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
109: ---------------------------------------------------------------------------
110: -- GLOBAL VARIABLES
111: ---------------------------------------------------------------------------
112: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PDT_PVT';
113: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
114: ---------------------------------------------------------------------------
115: -- Procedures and Functions
116: ---------------------------------------------------------------------------
117:
119: PROCEDURE change_version;
120: PROCEDURE api_copy;
121: PROCEDURE insert_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_pdtv_rec IN pdtv_rec_type,
128: x_pdtv_rec OUT NOCOPY pdtv_rec_type);
129:
130: PROCEDURE insert_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_pdtv_tbl IN pdtv_tbl_type,
137: x_pdtv_tbl OUT NOCOPY pdtv_tbl_type);
138:
139: PROCEDURE lock_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_pdtv_rec IN pdtv_rec_type);
145: p_pdtv_rec IN pdtv_rec_type);
146:
147: PROCEDURE lock_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_pdtv_tbl IN pdtv_tbl_type);
153: p_pdtv_tbl IN pdtv_tbl_type);
154:
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_pdtv_rec IN pdtv_rec_type,
162: x_pdtv_rec OUT NOCOPY pdtv_rec_type);
163:
164: PROCEDURE update_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_pdtv_tbl IN pdtv_tbl_type,
171: x_pdtv_tbl OUT NOCOPY pdtv_tbl_type);
172:
173: PROCEDURE delete_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_pdtv_rec IN pdtv_rec_type);
179: p_pdtv_rec IN pdtv_rec_type);
180:
181: PROCEDURE delete_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_pdtv_tbl IN pdtv_tbl_type);
187: p_pdtv_tbl IN pdtv_tbl_type);
188:
189: PROCEDURE validate_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_pdtv_rec IN pdtv_rec_type);
195: p_pdtv_rec IN pdtv_rec_type);
196:
197: PROCEDURE validate_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202:
203: x_msg_data OUT NOCOPY VARCHAR2,