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_AVL_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM,

4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE sav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAILS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE sav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAILS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

6: ---------------------------------------------------------------------------
7: TYPE sav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAILS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

7: TYPE sav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAILS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.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: id NUMBER := OKC_API.G_MISS_NUM,
9: object1_id1 OKS_SERV_AVAILS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 13: created_by NUMBER := OKC_API.G_MISS_NUM,

9: object1_id1 OKS_SERV_AVAILS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10: object1_id2 OKS_SERV_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,

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

10: object1_id2 OKS_SERV_AVAILS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

11: jtot_object1_code OKS_SERV_AVAILS_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_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

Line 16: last_update_date OKS_SERV_AVAILS.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_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

Line 17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,

13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKS_SERV_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,

14: creation_date OKS_SERV_AVAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

16: last_update_date OKS_SERV_AVAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 21: last_update_login NUMBER := OKC_API.G_MISS_NUM,

17: general_yn OKS_SERV_AVAILS.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

18: except_object_type OKS_SERV_AVAILS.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

19: start_date_active OKS_SERV_AVAILS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

20: end_date_active OKS_SERV_AVAILS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

22: attribute_category OKS_SERV_AVAILS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

23: attribute1 OKS_SERV_AVAILS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

24: attribute2 OKS_SERV_AVAILS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

25: attribute3 OKS_SERV_AVAILS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

26: attribute4 OKS_SERV_AVAILS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

27: attribute5 OKS_SERV_AVAILS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

28: attribute6 OKS_SERV_AVAILS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_SERV_AVAILS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

29: attribute7 OKS_SERV_AVAILS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_SERV_AVAILS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_SERV_AVAILS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

Line 34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

30: attribute8 OKS_SERV_AVAILS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_SERV_AVAILS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_SERV_AVAILS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_sav_rec sav_rec_type;

Line 35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

31: attribute9 OKS_SERV_AVAILS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_SERV_AVAILS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_SERV_AVAILS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_sav_rec sav_rec_type;
39: TYPE sav_tbl_type IS TABLE OF sav_rec_type

Line 36: attribute14 OKS_SERV_AVAILS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

32: attribute10 OKS_SERV_AVAILS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_SERV_AVAILS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_SERV_AVAILS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_sav_rec sav_rec_type;
39: TYPE sav_tbl_type IS TABLE OF sav_rec_type
40: INDEX BY BINARY_INTEGER;

Line 37: attribute15 OKS_SERV_AVAILS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

33: attribute11 OKS_SERV_AVAILS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_SERV_AVAILS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_SERV_AVAILS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_SERV_AVAILS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_SERV_AVAILS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_sav_rec sav_rec_type;
39: TYPE sav_tbl_type IS TABLE OF sav_rec_type
40: INDEX BY BINARY_INTEGER;
41: TYPE savv_rec_type IS RECORD (

Line 42: id NUMBER := OKC_API.G_MISS_NUM,

38: g_miss_sav_rec sav_rec_type;
39: TYPE sav_tbl_type IS TABLE OF sav_rec_type
40: INDEX BY BINARY_INTEGER;
41: TYPE savv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object1_id1 OKS_SERV_AVAILS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 43: object1_id1 OKS_SERV_AVAILS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

39: TYPE sav_tbl_type IS TABLE OF sav_rec_type
40: INDEX BY BINARY_INTEGER;
41: TYPE savv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object1_id1 OKS_SERV_AVAILS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

40: INDEX BY BINARY_INTEGER;
41: TYPE savv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object1_id1 OKS_SERV_AVAILS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,

41: TYPE savv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object1_id1 OKS_SERV_AVAILS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 46: object_version_number NUMBER := OKC_API.G_MISS_NUM,

42: id NUMBER := OKC_API.G_MISS_NUM,
43: object1_id1 OKS_SERV_AVAILS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 47: created_by NUMBER := OKC_API.G_MISS_NUM,

43: object1_id1 OKS_SERV_AVAILS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

44: object1_id2 OKS_SERV_AVAILS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

45: jtot_object1_code OKS_SERV_AVAILS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

Line 50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

46: object_version_number NUMBER := OKC_API.G_MISS_NUM,
47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

Line 51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,

47: created_by NUMBER := OKC_API.G_MISS_NUM,
48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,

48: creation_date OKS_SERV_AVAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

49: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,

50: last_update_date OKS_SERV_AVAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 55: last_update_login NUMBER := OKC_API.G_MISS_NUM,

51: general_yn OKS_SERV_AVAILS_V.GENERAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

52: except_object_type OKS_SERV_AVAILS_V.EXCEPT_OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

53: start_date_active OKS_SERV_AVAILS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

54: end_date_active OKS_SERV_AVAILS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

55: last_update_login NUMBER := OKC_API.G_MISS_NUM,
56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

56: attribute_category OKS_SERV_AVAILS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

57: attribute1 OKS_SERV_AVAILS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

58: attribute2 OKS_SERV_AVAILS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

59: attribute3 OKS_SERV_AVAILS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

60: attribute4 OKS_SERV_AVAILS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

61: attribute5 OKS_SERV_AVAILS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

62: attribute6 OKS_SERV_AVAILS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKS_SERV_AVAILS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

63: attribute7 OKS_SERV_AVAILS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKS_SERV_AVAILS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKS_SERV_AVAILS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

Line 68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

64: attribute8 OKS_SERV_AVAILS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKS_SERV_AVAILS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKS_SERV_AVAILS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
72: g_miss_savv_rec savv_rec_type;

Line 69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

65: attribute9 OKS_SERV_AVAILS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKS_SERV_AVAILS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKS_SERV_AVAILS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
72: g_miss_savv_rec savv_rec_type;
73: TYPE savv_tbl_type IS TABLE OF savv_rec_type

Line 70: attribute14 OKS_SERV_AVAILS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

66: attribute10 OKS_SERV_AVAILS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKS_SERV_AVAILS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKS_SERV_AVAILS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
72: g_miss_savv_rec savv_rec_type;
73: TYPE savv_tbl_type IS TABLE OF savv_rec_type
74: INDEX BY BINARY_INTEGER;

Line 71: attribute15 OKS_SERV_AVAILS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

67: attribute11 OKS_SERV_AVAILS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKS_SERV_AVAILS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKS_SERV_AVAILS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKS_SERV_AVAILS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKS_SERV_AVAILS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
72: g_miss_savv_rec savv_rec_type;
73: TYPE savv_tbl_type IS TABLE OF savv_rec_type
74: INDEX BY BINARY_INTEGER;
75: ---------------------------------------------------------------------------

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

74: INDEX BY BINARY_INTEGER;
75: ---------------------------------------------------------------------------
76: -- GLOBAL MESSAGE CONSTANTS
77: ---------------------------------------------------------------------------
78: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
79: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
80: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

75: ---------------------------------------------------------------------------
76: -- GLOBAL MESSAGE CONSTANTS
77: ---------------------------------------------------------------------------
78: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
79: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
80: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

76: -- GLOBAL MESSAGE CONSTANTS
77: ---------------------------------------------------------------------------
78: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
79: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
80: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

77: ---------------------------------------------------------------------------
78: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
79: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
80: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

78: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
79: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
80: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

79: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
80: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

80: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
88: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

81: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
88: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
89: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

82: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
88: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
89: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
90: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

83: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
88: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
89: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
90: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
91:

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

98: ---------------------------------------------------------------------------
99: -- GLOBAL VARIABLES
100: ---------------------------------------------------------------------------
101: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_AVL_PVT';
102: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103: ---------------------------------------------------------------------------
104: -- Procedures and Functions
105: ---------------------------------------------------------------------------
106:

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

108: PROCEDURE change_version;
109: PROCEDURE api_copy;
110: PROCEDURE insert_row(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_savv_rec IN savv_rec_type,

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117: x_savv_rec OUT NOCOPY savv_rec_type);
118:
119: PROCEDURE insert_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_savv_tbl IN savv_tbl_type,

Line 130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

126: x_savv_tbl OUT NOCOPY savv_tbl_type);
127:
128: PROCEDURE lock_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_savv_rec IN savv_rec_type);

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

134: p_savv_rec IN savv_rec_type);
135:
136: PROCEDURE lock_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_savv_tbl IN savv_tbl_type);

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

142: p_savv_tbl IN savv_tbl_type);
143:
144: PROCEDURE update_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_savv_rec IN savv_rec_type,

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

151: x_savv_rec OUT NOCOPY savv_rec_type);
152:
153: PROCEDURE update_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_savv_tbl IN savv_tbl_type,

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

160: x_savv_tbl OUT NOCOPY savv_tbl_type);
161:
162: PROCEDURE delete_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_savv_rec IN savv_rec_type);

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

168: p_savv_rec IN savv_rec_type);
169:
170: PROCEDURE delete_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_savv_tbl IN savv_tbl_type);

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176: p_savv_tbl IN savv_tbl_type);
177:
178: PROCEDURE validate_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_savv_rec IN savv_rec_type);

Line 188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

184: p_savv_rec IN savv_rec_type);
185:
186: PROCEDURE validate_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_savv_tbl IN savv_tbl_type);