3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE spp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE spp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE spp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
6: TYPE spp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
9: name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
11: date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
12: date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
13: description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
14: sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
15: dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
16: array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
17: xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
18: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
27: attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
28: attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_date OKL_SIF_PRICE_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_date OKL_SIF_PRICE_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_update_login NUMBER := OKC_API.G_MISS_NUM);
31: attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_date OKL_SIF_PRICE_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_update_login NUMBER := OKC_API.G_MISS_NUM);
39: g_miss_spp_rec spp_rec_type;
32: attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_date OKL_SIF_PRICE_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_update_login NUMBER := OKC_API.G_MISS_NUM);
39: g_miss_spp_rec spp_rec_type;
40: TYPE spp_tbl_type IS TABLE OF spp_rec_type
33: attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_date OKL_SIF_PRICE_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_update_login NUMBER := OKC_API.G_MISS_NUM);
39: g_miss_spp_rec spp_rec_type;
40: TYPE spp_tbl_type IS TABLE OF spp_rec_type
41: INDEX BY BINARY_INTEGER;
34: created_by NUMBER := OKC_API.G_MISS_NUM,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_date OKL_SIF_PRICE_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_update_login NUMBER := OKC_API.G_MISS_NUM);
39: g_miss_spp_rec spp_rec_type;
40: TYPE spp_tbl_type IS TABLE OF spp_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE sppv_rec_type IS RECORD (
39: g_miss_spp_rec spp_rec_type;
40: TYPE spp_tbl_type IS TABLE OF spp_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE sppv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
40: TYPE spp_tbl_type IS TABLE OF spp_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE sppv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
41: INDEX BY BINARY_INTEGER;
42: TYPE sppv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: TYPE sppv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
45: name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
46: version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
48: date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
63: attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
64: attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_date OKL_SIF_PRICE_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_date OKL_SIF_PRICE_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_date OKL_SIF_PRICE_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_sppv_rec sppv_rec_type;
68: attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_date OKL_SIF_PRICE_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_sppv_rec sppv_rec_type;
76: TYPE sppv_tbl_type IS TABLE OF sppv_rec_type
69: attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_date OKL_SIF_PRICE_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_sppv_rec sppv_rec_type;
76: TYPE sppv_tbl_type IS TABLE OF sppv_rec_type
77: INDEX BY BINARY_INTEGER;
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_date OKL_SIF_PRICE_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_sppv_rec sppv_rec_type;
76: TYPE sppv_tbl_type IS TABLE OF sppv_rec_type
77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
91: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
91: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
92: -- START CHANGE : akjain -- 05/07/2001
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
91: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
92: -- START CHANGE : akjain -- 05/07/2001
93: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
91: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
92: -- START CHANGE : akjain -- 05/07/2001
93: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
94: G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_PRICE_PARM_NOT_UNIQUE';
87: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
91: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
92: -- START CHANGE : akjain -- 05/07/2001
93: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
94: G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_PRICE_PARM_NOT_UNIQUE';
95: G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
118: PROCEDURE change_version;
119: PROCEDURE api_copy;
120: PROCEDURE insert_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_sppv_rec IN sppv_rec_type,
127: x_sppv_rec OUT NOCOPY sppv_rec_type);
128:
129: PROCEDURE insert_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_sppv_tbl IN sppv_tbl_type,
136: x_sppv_tbl OUT NOCOPY sppv_tbl_type);
137:
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_sppv_rec IN sppv_rec_type);
144: p_sppv_rec IN sppv_rec_type);
145:
146: PROCEDURE lock_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_sppv_tbl IN sppv_tbl_type);
152: p_sppv_tbl IN sppv_tbl_type);
153:
154: PROCEDURE update_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_sppv_rec IN sppv_rec_type,
161: x_sppv_rec OUT NOCOPY sppv_rec_type);
162:
163: PROCEDURE update_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_sppv_tbl IN sppv_tbl_type,
170: x_sppv_tbl OUT NOCOPY sppv_tbl_type);
171:
172: PROCEDURE delete_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_sppv_rec IN sppv_rec_type);
178: p_sppv_rec IN sppv_rec_type);
179:
180: PROCEDURE delete_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_sppv_tbl IN sppv_tbl_type);
186: p_sppv_tbl IN sppv_tbl_type);
187:
188: PROCEDURE validate_row(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_sppv_rec IN sppv_rec_type);
194: p_sppv_rec IN sppv_rec_type);
195:
196: PROCEDURE validate_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_sppv_tbl IN sppv_tbl_type);