DBA Data[Home] [Help]

APPS.OKL_PDT_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 8: name OKL_PRODUCTS.NAME%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,

Line 9: aes_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 10: ptl_id 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,

Line 11: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%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,

Line 12: version OKL_PRODUCTS.VERSION%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 13: object_version_number NUMBER := OKC_API.G_MISS_NUM,

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,

Line 14: description OKL_PRODUCTS.DESCRIPTION%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,

Line 15: reporting_pdt_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,
19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 16: product_status_code OKL_PRODUCTS.product_status_code%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,

Line 17: from_date OKL_PRODUCTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 18: to_date OKL_PRODUCTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 19: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%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,

Line 20: attribute1 OKL_PRODUCTS.ATTRIBUTE1%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,

Line 21: attribute2 OKL_PRODUCTS.ATTRIBUTE2%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,

Line 22: attribute3 OKL_PRODUCTS.ATTRIBUTE3%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,

Line 23: attribute4 OKL_PRODUCTS.ATTRIBUTE4%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,

Line 24: attribute5 OKL_PRODUCTS.ATTRIBUTE5%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,

Line 25: attribute6 OKL_PRODUCTS.ATTRIBUTE6%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,

Line 26: attribute7 OKL_PRODUCTS.ATTRIBUTE7%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,

Line 27: attribute8 OKL_PRODUCTS.ATTRIBUTE8%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,

Line 28: attribute9 OKL_PRODUCTS.ATTRIBUTE9%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,

Line 29: attribute10 OKL_PRODUCTS.ATTRIBUTE10%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,

Line 30: attribute11 OKL_PRODUCTS.ATTRIBUTE11%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,

Line 31: attribute12 OKL_PRODUCTS.ATTRIBUTE12%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,

Line 32: attribute13 OKL_PRODUCTS.ATTRIBUTE13%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,
36: creation_date OKL_PRODUCTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 33: attribute14 OKL_PRODUCTS.ATTRIBUTE14%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,
37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 34: attribute15 OKL_PRODUCTS.ATTRIBUTE15%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,
38: last_update_date OKL_PRODUCTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 35: created_by NUMBER := OKC_API.G_MISS_NUM,

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);

Line 36: creation_date OKL_PRODUCTS.CREATION_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;

Line 37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 38: last_update_date OKL_PRODUCTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 39: last_update_login NUMBER := OKC_API.G_MISS_NUM);

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 (

Line 44: id 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 (
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,

Line 45: object_version_number NUMBER := OKC_API.G_MISS_NUM,

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,

Line 46: aes_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 47: ptl_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,

Line 48: name OKL_PRODUCTS_V.NAME%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,

Line 49: description OKL_PRODUCTS_V.DESCRIPTION%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,

Line 50: reporting_pdt_id 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,
54: version OKL_PRODUCTS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,

Line 51: product_status_code OKL_PRODUCTS_V.product_status_code%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,

Line 52: legacy_product_yn OKL_PRODUCTS_V.LEGACY_PRODUCT_YN%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 53: from_date OKL_PRODUCTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 54: version OKL_PRODUCTS_V.VERSION%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,

Line 55: to_date OKL_PRODUCTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 56: attribute_category OKL_PRODUCTS_V.ATTRIBUTE_CATEGORY%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,

Line 57: attribute1 OKL_PRODUCTS_V.ATTRIBUTE1%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,

Line 58: attribute2 OKL_PRODUCTS_V.ATTRIBUTE2%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,

Line 59: attribute3 OKL_PRODUCTS_V.ATTRIBUTE3%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,

Line 60: attribute4 OKL_PRODUCTS_V.ATTRIBUTE4%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,

Line 61: attribute5 OKL_PRODUCTS_V.ATTRIBUTE5%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,

Line 62: attribute6 OKL_PRODUCTS_V.ATTRIBUTE6%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,

Line 63: attribute7 OKL_PRODUCTS_V.ATTRIBUTE7%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,

Line 64: attribute8 OKL_PRODUCTS_V.ATTRIBUTE8%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,

Line 65: attribute9 OKL_PRODUCTS_V.ATTRIBUTE9%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,

Line 66: attribute10 OKL_PRODUCTS_V.ATTRIBUTE10%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,

Line 67: attribute11 OKL_PRODUCTS_V.ATTRIBUTE11%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,

Line 68: attribute12 OKL_PRODUCTS_V.ATTRIBUTE12%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,

Line 69: attribute13 OKL_PRODUCTS_V.ATTRIBUTE13%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,
73: creation_date OKL_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 70: attribute14 OKL_PRODUCTS_V.ATTRIBUTE14%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,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 71: attribute15 OKL_PRODUCTS_V.ATTRIBUTE15%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,
75: last_update_date OKL_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 72: created_by NUMBER := OKC_API.G_MISS_NUM,

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);

Line 73: creation_date OKL_PRODUCTS_V.CREATION_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;

Line 74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 75: last_update_date OKL_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 76: last_update_login NUMBER := OKC_API.G_MISS_NUM);

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: ---------------------------------------------------------------------------

Line 83: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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;

Line 84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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;

Line 86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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;

Line 87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;

Line 89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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:

Line 90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

Line 91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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';

Line 92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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';

Line 113: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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:

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,