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.OKL_VIB_PVT dependencies on OKL_API

Line 7: id NUMBER := OKL_API.G_MISS_NUM

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE vibv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,major_version NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM

Line 8: ,major_version NUMBER := OKL_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE vibv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,major_version NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM

Line 9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: TYPE vibv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,major_version NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

Line 10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM

6: TYPE vibv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,major_version NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM

Line 11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM

7: id NUMBER := OKL_API.G_MISS_NUM
8: ,major_version NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

Line 12: ,name NUMBER := OKL_API.G_MISS_NUM

8: ,major_version NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM

Line 13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM

Line 14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM

10: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

11: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM

12: ,name NUMBER := OKL_API.G_MISS_NUM
13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 17: ,quantity NUMBER := OKL_API.G_MISS_NUM

13: ,description OKL_CONTRACT_IB_HV.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

14: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

15: ,current_serial_number OKL_CONTRACT_IB_HV.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

16: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

17: ,quantity NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

18: ,attribute_category OKL_CONTRACT_IB_HV.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

19: ,attribute1 OKL_CONTRACT_IB_HV.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

20: ,attribute2 OKL_CONTRACT_IB_HV.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

21: ,attribute3 OKL_CONTRACT_IB_HV.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

22: ,attribute4 OKL_CONTRACT_IB_HV.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

23: ,attribute5 OKL_CONTRACT_IB_HV.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

24: ,attribute6 OKL_CONTRACT_IB_HV.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

25: ,attribute7 OKL_CONTRACT_IB_HV.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

26: ,attribute8 OKL_CONTRACT_IB_HV.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

27: ,attribute9 OKL_CONTRACT_IB_HV.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

28: ,attribute10 OKL_CONTRACT_IB_HV.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

29: ,attribute11 OKL_CONTRACT_IB_HV.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 34: ,created_by NUMBER := OKL_API.G_MISS_NUM

30: ,attribute12 OKL_CONTRACT_IB_HV.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

Line 35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

31: ,attribute13 OKL_CONTRACT_IB_HV.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: --Added by dpsingh for LE uptake

Line 36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

32: ,attribute14 OKL_CONTRACT_IB_HV.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: --Added by dpsingh for LE uptake
40: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);

Line 37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

33: ,attribute15 OKL_CONTRACT_IB_HV.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: --Added by dpsingh for LE uptake
40: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);
41: G_MISS_vibv_rec vibv_rec_type;

Line 38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CONTRACT_IB_HV.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: --Added by dpsingh for LE uptake
40: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);
41: G_MISS_vibv_rec vibv_rec_type;
42: TYPE vibv_tbl_type IS TABLE OF vibv_rec_type

Line 40: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);

36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CONTRACT_IB_HV.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: --Added by dpsingh for LE uptake
40: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);
41: G_MISS_vibv_rec vibv_rec_type;
42: TYPE vibv_tbl_type IS TABLE OF vibv_rec_type
43: INDEX BY BINARY_INTEGER;
44: TYPE vib_rec_type IS RECORD (

Line 45: id NUMBER := OKL_API.G_MISS_NUM

41: G_MISS_vibv_rec vibv_rec_type;
42: TYPE vibv_tbl_type IS TABLE OF vibv_rec_type
43: INDEX BY BINARY_INTEGER;
44: TYPE vib_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,major_version NUMBER := OKL_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM

Line 46: ,major_version NUMBER := OKL_API.G_MISS_NUM

42: TYPE vibv_tbl_type IS TABLE OF vibv_rec_type
43: INDEX BY BINARY_INTEGER;
44: TYPE vib_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,major_version NUMBER := OKL_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM

Line 47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

43: INDEX BY BINARY_INTEGER;
44: TYPE vib_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,major_version NUMBER := OKL_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

Line 48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM

44: TYPE vib_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,major_version NUMBER := OKL_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM

Line 49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM

45: id NUMBER := OKL_API.G_MISS_NUM
46: ,major_version NUMBER := OKL_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

Line 50: ,name NUMBER := OKL_API.G_MISS_NUM

46: ,major_version NUMBER := OKL_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM

Line 51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

47: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM

Line 52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM

48: ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM
56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

49: ,ib_cle_id NUMBER := OKL_API.G_MISS_NUM
50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM
56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CONTRACT_IB_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM

50: ,name NUMBER := OKL_API.G_MISS_NUM
51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM
56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CONTRACT_IB_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CONTRACT_IB_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 55: ,quantity NUMBER := OKL_API.G_MISS_NUM

51: ,description OKL_CONTRACT_IB_H.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM
56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CONTRACT_IB_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CONTRACT_IB_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CONTRACT_IB_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

52: ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM
56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CONTRACT_IB_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CONTRACT_IB_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CONTRACT_IB_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CONTRACT_IB_H.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 57: ,attribute1 OKL_CONTRACT_IB_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

53: ,current_serial_number OKL_CONTRACT_IB_H.CURRENT_SERIAL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM
56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CONTRACT_IB_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CONTRACT_IB_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CONTRACT_IB_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CONTRACT_IB_H.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CONTRACT_IB_H.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 58: ,attribute2 OKL_CONTRACT_IB_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

54: ,install_site_use_id NUMBER := OKL_API.G_MISS_NUM
55: ,quantity NUMBER := OKL_API.G_MISS_NUM
56: ,attribute_category OKL_CONTRACT_IB_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CONTRACT_IB_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CONTRACT_IB_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CONTRACT_IB_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CONTRACT_IB_H.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CONTRACT_IB_H.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CONTRACT_IB_H.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 59: ,attribute3 OKL_CONTRACT_IB_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

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

Line 60: ,attribute4 OKL_CONTRACT_IB_H.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

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

Line 61: ,attribute5 OKL_CONTRACT_IB_H.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

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

Line 62: ,attribute6 OKL_CONTRACT_IB_H.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

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

Line 63: ,attribute7 OKL_CONTRACT_IB_H.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

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

Line 64: ,attribute8 OKL_CONTRACT_IB_H.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

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

Line 65: ,attribute9 OKL_CONTRACT_IB_H.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

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

Line 66: ,attribute10 OKL_CONTRACT_IB_H.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

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

Line 67: ,attribute11 OKL_CONTRACT_IB_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

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

Line 68: ,attribute12 OKL_CONTRACT_IB_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

64: ,attribute8 OKL_CONTRACT_IB_H.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CONTRACT_IB_H.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CONTRACT_IB_H.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CONTRACT_IB_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CONTRACT_IB_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CONTRACT_IB_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 69: ,attribute13 OKL_CONTRACT_IB_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

65: ,attribute9 OKL_CONTRACT_IB_H.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CONTRACT_IB_H.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CONTRACT_IB_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CONTRACT_IB_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CONTRACT_IB_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

66: ,attribute10 OKL_CONTRACT_IB_H.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CONTRACT_IB_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CONTRACT_IB_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CONTRACT_IB_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

67: ,attribute11 OKL_CONTRACT_IB_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CONTRACT_IB_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CONTRACT_IB_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 72: ,created_by NUMBER := OKL_API.G_MISS_NUM

68: ,attribute12 OKL_CONTRACT_IB_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CONTRACT_IB_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

Line 73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

69: ,attribute13 OKL_CONTRACT_IB_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: --Added by dpsingh for LE uptake

Line 74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

70: ,attribute14 OKL_CONTRACT_IB_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: --Added by dpsingh for LE uptake
78: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);

Line 75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

71: ,attribute15 OKL_CONTRACT_IB_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: --Added by dpsingh for LE uptake
78: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);
79: G_MISS_vib_rec vib_rec_type;

Line 76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CONTRACT_IB_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: --Added by dpsingh for LE uptake
78: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);
79: G_MISS_vib_rec vib_rec_type;
80: TYPE vib_tbl_type IS TABLE OF vib_rec_type

Line 78: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);

74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CONTRACT_IB_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: --Added by dpsingh for LE uptake
78: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM);
79: G_MISS_vib_rec vib_rec_type;
80: TYPE vib_tbl_type IS TABLE OF vib_rec_type
81: INDEX BY BINARY_INTEGER;
82: ---------------------------------------------------------------------------

Line 85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

81: INDEX BY BINARY_INTEGER;
82: ---------------------------------------------------------------------------
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

82: ---------------------------------------------------------------------------
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';

Line 87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';

Line 88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
96: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
96: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
97: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
96: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
97: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
98:

Line 108: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

104: ---------------------------------------------------------------------------
105: -- GLOBAL VARIABLES
106: ---------------------------------------------------------------------------
107: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VIB_PVT';
108: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
109: ---------------------------------------------------------------------------
110: -- Procedures and Functions
111: ---------------------------------------------------------------------------
112:

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

114: PROCEDURE change_version;
115: PROCEDURE api_copy;
116: PROCEDURE insert_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_vibv_rec IN vibv_rec_type,

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

122: p_vibv_rec IN vibv_rec_type,
123: x_vibv_rec OUT NOCOPY vibv_rec_type);
124: PROCEDURE insert_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_vibv_tbl IN vibv_tbl_type,

Line 134: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

130: p_vibv_tbl IN vibv_tbl_type,
131: x_vibv_tbl OUT NOCOPY vibv_tbl_type);
132: PROCEDURE lock_row(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_vibv_rec IN vibv_rec_type);

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_vibv_rec IN vibv_rec_type);
139: PROCEDURE lock_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_vibv_tbl IN vibv_tbl_type);

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_vibv_tbl IN vibv_tbl_type);
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_vibv_rec IN vibv_rec_type,

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

152: p_vibv_rec IN vibv_rec_type,
153: x_vibv_rec OUT NOCOPY vibv_rec_type);
154: PROCEDURE update_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_vibv_tbl IN vibv_tbl_type,

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

160: p_vibv_tbl IN vibv_tbl_type,
161: x_vibv_tbl OUT NOCOPY vibv_tbl_type);
162: PROCEDURE delete_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_vibv_rec IN vibv_rec_type);

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_vibv_rec IN vibv_rec_type);
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_vibv_tbl IN vibv_tbl_type);

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_vibv_tbl IN vibv_tbl_type);
176: PROCEDURE validate_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_vibv_rec IN vibv_rec_type);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_vibv_rec IN vibv_rec_type);
183: PROCEDURE validate_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_vibv_tbl IN vibv_tbl_type);