3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sax_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sax_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE sax_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE sax_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: sav_id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_sax_rec sax_rec_type;
32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_sax_rec sax_rec_type;
40: TYPE sax_tbl_type IS TABLE OF sax_rec_type
33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_sax_rec sax_rec_type;
40: TYPE sax_tbl_type IS TABLE OF sax_rec_type
41: INDEX BY BINARY_INTEGER;
34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_sax_rec sax_rec_type;
40: TYPE sax_tbl_type IS TABLE OF sax_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE saxv_rec_type IS RECORD (
39: g_miss_sax_rec sax_rec_type;
40: TYPE sax_tbl_type IS TABLE OF sax_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE saxv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: sav_id NUMBER := OKC_API.G_MISS_NUM,
45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: TYPE sax_tbl_type IS TABLE OF sax_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE saxv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: sav_id NUMBER := OKC_API.G_MISS_NUM,
45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: INDEX BY BINARY_INTEGER;
42: TYPE saxv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: sav_id NUMBER := OKC_API.G_MISS_NUM,
45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
42: TYPE saxv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: sav_id NUMBER := OKC_API.G_MISS_NUM,
45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
43: id NUMBER := OKC_API.G_MISS_NUM,
44: sav_id NUMBER := OKC_API.G_MISS_NUM,
45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
44: sav_id NUMBER := OKC_API.G_MISS_NUM,
45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_saxv_rec saxv_rec_type;
68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_saxv_rec saxv_rec_type;
76: TYPE saxv_tbl_type IS TABLE OF saxv_rec_type
69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_saxv_rec saxv_rec_type;
76: TYPE saxv_tbl_type IS TABLE OF saxv_rec_type
77: INDEX BY BINARY_INTEGER;
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_saxv_rec saxv_rec_type;
76: TYPE saxv_tbl_type IS TABLE OF saxv_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_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
94:
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
103: ---------------------------------------------------------------------------
104: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_AVLEXC_PVT';
105: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
106: ---------------------------------------------------------------------------
107: -- Procedures and Functions
108: ---------------------------------------------------------------------------
109:
111: PROCEDURE change_version;
112: PROCEDURE api_copy;
113: PROCEDURE insert_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_saxv_rec IN saxv_rec_type,
120: x_saxv_rec OUT NOCOPY saxv_rec_type);
121:
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_saxv_tbl IN saxv_tbl_type,
129: x_saxv_tbl OUT NOCOPY saxv_tbl_type);
130:
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_saxv_rec IN saxv_rec_type);
137: p_saxv_rec IN saxv_rec_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_saxv_tbl IN saxv_tbl_type);
145: p_saxv_tbl IN saxv_tbl_type);
146:
147: PROCEDURE update_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_saxv_rec IN saxv_rec_type,
154: x_saxv_rec OUT NOCOPY saxv_rec_type);
155:
156: PROCEDURE update_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_saxv_tbl IN saxv_tbl_type,
163: x_saxv_tbl OUT NOCOPY saxv_tbl_type);
164:
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_saxv_rec IN saxv_rec_type);
171: p_saxv_rec IN saxv_rec_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_saxv_tbl IN saxv_tbl_type);
179: p_saxv_tbl IN saxv_tbl_type);
180:
181: PROCEDURE validate_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_saxv_rec IN saxv_rec_type);
187: p_saxv_rec IN saxv_rec_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_saxv_tbl IN saxv_tbl_type);