eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AVLEXC_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 8: sav_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 9: object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 10: object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 11: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 12: object_version_number 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,

Line 13: created_by 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,
17: manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,

Line 14: creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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,

Line 16: last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 17: manufacturing_org_id 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,
21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

Line 18: revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 19: revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 20: start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 21: end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%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,
25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 22: last_update_login 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,
26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 23: attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%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,

Line 24: attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%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,

Line 25: attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%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,

Line 26: attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%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,

Line 27: attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%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,

Line 28: attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%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,

Line 29: attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%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,

Line 30: attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%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,

Line 31: attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%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,

Line 32: attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%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,

Line 33: attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%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,

Line 34: attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%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);

Line 35: attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%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;

Line 36: attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%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;
40: TYPE sax_tbl_type IS TABLE OF sax_rec_type

Line 37: attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%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
41: INDEX BY BINARY_INTEGER;

Line 38: attribute15 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE15%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;
42: TYPE saxv_rec_type IS RECORD (

Line 43: id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 44: sav_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 45: object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 46: object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 47: jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%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,

Line 48: object_version_number 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,
52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

Line 49: manufacturing_org_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,
53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

Line 50: revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%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,
54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 51: revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%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,

Line 52: start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 53: end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 54: attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%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,

Line 55: attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%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,

Line 56: attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%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,

Line 57: attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%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,

Line 58: attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%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,

Line 59: attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%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,

Line 60: attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%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,

Line 61: attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%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,

Line 62: attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%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,

Line 63: attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%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,

Line 64: attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%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,

Line 65: attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%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,

Line 66: attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%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,

Line 67: attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%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,
71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 68: attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%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,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 69: attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%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,
73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 70: created_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 71: creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 73: last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

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

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

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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

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

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

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

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

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

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:

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

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:

Line 115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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