DBA Data[Home] [Help]

APPS.OKL_PFC_PVT dependencies on OKL_API

Line 8: id NUMBER := OKL_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_PRTFL_CNTRCTS_V Record Spec
7: TYPE pfcv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM

Line 9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKL_PRTFL_CNTRCTS_V Record Spec
7: TYPE pfcv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR

Line 10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR

6: -- OKL_PRTFL_CNTRCTS_V Record Spec
7: TYPE pfcv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

Line 11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR

7: TYPE pfcv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 12: ,khr_id NUMBER := OKL_API.G_MISS_NUM

8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR

9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

10: ,sfwt_flag OKL_PRTFL_CNTRCTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 15: ,request_id NUMBER := OKL_API.G_MISS_NUM

11: ,line_level_yn OKL_PRTFL_CNTRCTS_V.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

12: ,khr_id NUMBER := OKL_API.G_MISS_NUM
13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 17: ,program_id NUMBER := OKL_API.G_MISS_NUM

13: ,name OKL_PRTFL_CNTRCTS_V.NAME%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

14: ,description OKL_PRTFL_CNTRCTS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 20: ,attribute1 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 21: ,attribute2 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_PRTFL_CNTRCTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_PRTFL_CNTRCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 22: ,attribute3 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

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

Line 23: ,attribute4 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

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

Line 24: ,attribute5 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

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

Line 25: ,attribute6 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

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

Line 26: ,attribute7 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

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

Line 27: ,attribute8 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

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

Line 28: ,attribute9 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

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

Line 29: ,attribute10 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

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

Line 30: ,attribute11 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

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

Line 31: ,attribute12 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

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

Line 32: ,attribute13 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

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

Line 33: ,attribute14 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

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

Line 34: ,attribute15 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

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

Line 35: ,created_by NUMBER := OKL_API.G_MISS_NUM

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

Line 36: ,creation_date OKL_PRTFL_CNTRCTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

32: ,attribute13 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_PRTFL_CNTRCTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_PRTFL_CNTRCTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_pfcv_rec pfcv_rec_type;

Line 37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

33: ,attribute14 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_PRTFL_CNTRCTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_PRTFL_CNTRCTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_pfcv_rec pfcv_rec_type;
41: TYPE pfcv_tbl_type IS TABLE OF pfcv_rec_type

Line 38: ,last_update_date OKL_PRTFL_CNTRCTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

34: ,attribute15 OKL_PRTFL_CNTRCTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_PRTFL_CNTRCTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_PRTFL_CNTRCTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_pfcv_rec pfcv_rec_type;
41: TYPE pfcv_tbl_type IS TABLE OF pfcv_rec_type
42: INDEX BY BINARY_INTEGER;

Line 39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_PRTFL_CNTRCTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_PRTFL_CNTRCTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_pfcv_rec pfcv_rec_type;
41: TYPE pfcv_tbl_type IS TABLE OF pfcv_rec_type
42: INDEX BY BINARY_INTEGER;
43: -- OKL_PRTFL_CNTRCTS_B Record Spec

Line 45: id NUMBER := OKL_API.G_MISS_NUM

41: TYPE pfcv_tbl_type IS TABLE OF pfcv_rec_type
42: INDEX BY BINARY_INTEGER;
43: -- OKL_PRTFL_CNTRCTS_B Record Spec
44: TYPE pfc_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,line_level_yn OKL_PRTFL_CNTRCTS_B.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
47: ,khr_id NUMBER := OKL_API.G_MISS_NUM
48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 46: ,line_level_yn OKL_PRTFL_CNTRCTS_B.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR

42: INDEX BY BINARY_INTEGER;
43: -- OKL_PRTFL_CNTRCTS_B Record Spec
44: TYPE pfc_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,line_level_yn OKL_PRTFL_CNTRCTS_B.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
47: ,khr_id NUMBER := OKL_API.G_MISS_NUM
48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 47: ,khr_id NUMBER := OKL_API.G_MISS_NUM

43: -- OKL_PRTFL_CNTRCTS_B Record Spec
44: TYPE pfc_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,line_level_yn OKL_PRTFL_CNTRCTS_B.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
47: ,khr_id NUMBER := OKL_API.G_MISS_NUM
48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

44: TYPE pfc_rec_type IS RECORD (
45: id NUMBER := OKL_API.G_MISS_NUM
46: ,line_level_yn OKL_PRTFL_CNTRCTS_B.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
47: ,khr_id NUMBER := OKL_API.G_MISS_NUM
48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 49: ,request_id NUMBER := OKL_API.G_MISS_NUM

45: id NUMBER := OKL_API.G_MISS_NUM
46: ,line_level_yn OKL_PRTFL_CNTRCTS_B.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
47: ,khr_id NUMBER := OKL_API.G_MISS_NUM
48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

46: ,line_level_yn OKL_PRTFL_CNTRCTS_B.LINE_LEVEL_YN%TYPE := OKL_API.G_MISS_CHAR
47: ,khr_id NUMBER := OKL_API.G_MISS_NUM
48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 51: ,program_id NUMBER := OKL_API.G_MISS_NUM

47: ,khr_id NUMBER := OKL_API.G_MISS_NUM
48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute2 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

48: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute2 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute3 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

49: ,request_id NUMBER := OKL_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute2 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute3 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute4 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

50: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute2 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute3 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute4 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute5 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 55: ,attribute2 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

51: ,program_id NUMBER := OKL_API.G_MISS_NUM
52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute2 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute3 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute4 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute5 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute6 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 56: ,attribute3 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

52: ,program_update_date OKL_PRTFL_CNTRCTS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,attribute_category OKL_PRTFL_CNTRCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute1 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute2 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute3 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute4 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute5 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute6 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute7 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 57: ,attribute4 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

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

Line 58: ,attribute5 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

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

Line 59: ,attribute6 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

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

Line 60: ,attribute7 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

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

Line 61: ,attribute8 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

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

Line 62: ,attribute9 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

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

Line 63: ,attribute10 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

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

Line 64: ,attribute11 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

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

Line 65: ,attribute12 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

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

Line 66: ,attribute13 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

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

Line 67: ,attribute14 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

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

Line 68: ,attribute15 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

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

Line 69: ,created_by NUMBER := OKL_API.G_MISS_NUM

65: ,attribute12 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute13 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute14 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute15 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
69: ,created_by NUMBER := OKL_API.G_MISS_NUM
70: ,creation_date OKL_PRTFL_CNTRCTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
72: ,last_update_date OKL_PRTFL_CNTRCTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 70: ,creation_date OKL_PRTFL_CNTRCTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

66: ,attribute13 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute14 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute15 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
69: ,created_by NUMBER := OKL_API.G_MISS_NUM
70: ,creation_date OKL_PRTFL_CNTRCTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
72: ,last_update_date OKL_PRTFL_CNTRCTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
74: G_MISS_pfc_rec pfc_rec_type;

Line 71: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

67: ,attribute14 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute15 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
69: ,created_by NUMBER := OKL_API.G_MISS_NUM
70: ,creation_date OKL_PRTFL_CNTRCTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
72: ,last_update_date OKL_PRTFL_CNTRCTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
74: G_MISS_pfc_rec pfc_rec_type;
75: TYPE pfc_tbl_type IS TABLE OF pfc_rec_type

Line 72: ,last_update_date OKL_PRTFL_CNTRCTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

68: ,attribute15 OKL_PRTFL_CNTRCTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
69: ,created_by NUMBER := OKL_API.G_MISS_NUM
70: ,creation_date OKL_PRTFL_CNTRCTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
72: ,last_update_date OKL_PRTFL_CNTRCTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
74: G_MISS_pfc_rec pfc_rec_type;
75: TYPE pfc_tbl_type IS TABLE OF pfc_rec_type
76: INDEX BY BINARY_INTEGER;

Line 73: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

69: ,created_by NUMBER := OKL_API.G_MISS_NUM
70: ,creation_date OKL_PRTFL_CNTRCTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
72: ,last_update_date OKL_PRTFL_CNTRCTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
74: G_MISS_pfc_rec pfc_rec_type;
75: TYPE pfc_tbl_type IS TABLE OF pfc_rec_type
76: INDEX BY BINARY_INTEGER;
77: -- OKL_PRTFL_CNTRCTS_TL Record Spec

Line 79: id NUMBER := OKL_API.G_MISS_NUM

75: TYPE pfc_tbl_type IS TABLE OF pfc_rec_type
76: INDEX BY BINARY_INTEGER;
77: -- OKL_PRTFL_CNTRCTS_TL Record Spec
78: TYPE okl_prtfl_cntrcts_tl_rec_type IS RECORD (
79: id NUMBER := OKL_API.G_MISS_NUM
80: ,language OKL_PRTFL_CNTRCTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR

Line 80: ,language OKL_PRTFL_CNTRCTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR

76: INDEX BY BINARY_INTEGER;
77: -- OKL_PRTFL_CNTRCTS_TL Record Spec
78: TYPE okl_prtfl_cntrcts_tl_rec_type IS RECORD (
79: id NUMBER := OKL_API.G_MISS_NUM
80: ,language OKL_PRTFL_CNTRCTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

Line 81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR

77: -- OKL_PRTFL_CNTRCTS_TL Record Spec
78: TYPE okl_prtfl_cntrcts_tl_rec_type IS RECORD (
79: id NUMBER := OKL_API.G_MISS_NUM
80: ,language OKL_PRTFL_CNTRCTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR

78: TYPE okl_prtfl_cntrcts_tl_rec_type IS RECORD (
79: id NUMBER := OKL_API.G_MISS_NUM
80: ,language OKL_PRTFL_CNTRCTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR

79: id NUMBER := OKL_API.G_MISS_NUM
80: ,language OKL_PRTFL_CNTRCTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

80: ,language OKL_PRTFL_CNTRCTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
88: ,last_update_date OKL_PRTFL_CNTRCTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 85: ,created_by NUMBER := OKL_API.G_MISS_NUM

81: ,source_lang OKL_PRTFL_CNTRCTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
88: ,last_update_date OKL_PRTFL_CNTRCTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

82: ,sfwt_flag OKL_PRTFL_CNTRCTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
88: ,last_update_date OKL_PRTFL_CNTRCTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
90: GMissOklPrtflCntrctsTlRec okl_prtfl_cntrcts_tl_rec_type;

Line 87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

83: ,name OKL_PRTFL_CNTRCTS_TL.NAME%TYPE := OKL_API.G_MISS_CHAR
84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
88: ,last_update_date OKL_PRTFL_CNTRCTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
90: GMissOklPrtflCntrctsTlRec okl_prtfl_cntrcts_tl_rec_type;
91: TYPE okl_prtfl_cntrcts_tl_tbl_type IS TABLE OF okl_prtfl_cntrcts_tl_rec_type

Line 88: ,last_update_date OKL_PRTFL_CNTRCTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

84: ,description OKL_PRTFL_CNTRCTS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
88: ,last_update_date OKL_PRTFL_CNTRCTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
90: GMissOklPrtflCntrctsTlRec okl_prtfl_cntrcts_tl_rec_type;
91: TYPE okl_prtfl_cntrcts_tl_tbl_type IS TABLE OF okl_prtfl_cntrcts_tl_rec_type
92: INDEX BY BINARY_INTEGER;

Line 89: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

85: ,created_by NUMBER := OKL_API.G_MISS_NUM
86: ,creation_date OKL_PRTFL_CNTRCTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
88: ,last_update_date OKL_PRTFL_CNTRCTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
90: GMissOklPrtflCntrctsTlRec okl_prtfl_cntrcts_tl_rec_type;
91: TYPE okl_prtfl_cntrcts_tl_tbl_type IS TABLE OF okl_prtfl_cntrcts_tl_rec_type
92: INDEX BY BINARY_INTEGER;
93: ---------------------------------------------------------------------------

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

92: INDEX BY BINARY_INTEGER;
93: ---------------------------------------------------------------------------
94: -- GLOBAL MESSAGE CONSTANTS
95: ---------------------------------------------------------------------------
96: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

93: ---------------------------------------------------------------------------
94: -- GLOBAL MESSAGE CONSTANTS
95: ---------------------------------------------------------------------------
96: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

94: -- GLOBAL MESSAGE CONSTANTS
95: ---------------------------------------------------------------------------
96: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

95: ---------------------------------------------------------------------------
96: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

96: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
107: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
107: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
108: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
107: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
108: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
109:

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

115: ---------------------------------------------------------------------------
116: -- GLOBAL VARIABLES
117: ---------------------------------------------------------------------------
118: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PFC_PVT';
119: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
120: ---------------------------------------------------------------------------
121: -- Procedures and Functions
122: ---------------------------------------------------------------------------
123:

Line 130: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

126: PROCEDURE api_copy;
127: PROCEDURE add_language;
128: PROCEDURE insert_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_pfcv_rec IN pfcv_rec_type,

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

134: p_pfcv_rec IN pfcv_rec_type,
135: x_pfcv_rec OUT NOCOPY pfcv_rec_type);
136: PROCEDURE insert_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_pfcv_tbl IN pfcv_tbl_type,

Line 144: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_pfcv_tbl IN pfcv_tbl_type,
143: x_pfcv_tbl OUT NOCOPY pfcv_tbl_type,
144: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
145: PROCEDURE insert_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

143: x_pfcv_tbl OUT NOCOPY pfcv_tbl_type,
144: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
145: PROCEDURE insert_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_pfcv_tbl IN pfcv_tbl_type,

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

151: p_pfcv_tbl IN pfcv_tbl_type,
152: x_pfcv_tbl OUT NOCOPY pfcv_tbl_type);
153: PROCEDURE lock_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_pfcv_rec IN pfcv_rec_type);

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_pfcv_rec IN pfcv_rec_type);
160: PROCEDURE lock_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_pfcv_tbl IN pfcv_tbl_type,

Line 167: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_pfcv_tbl IN pfcv_tbl_type,
167: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
168: PROCEDURE lock_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

166: p_pfcv_tbl IN pfcv_tbl_type,
167: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
168: PROCEDURE lock_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_pfcv_tbl IN pfcv_tbl_type);

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_pfcv_tbl IN pfcv_tbl_type);
175: PROCEDURE update_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_pfcv_rec IN pfcv_rec_type,

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

181: p_pfcv_rec IN pfcv_rec_type,
182: x_pfcv_rec OUT NOCOPY pfcv_rec_type);
183: PROCEDURE update_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_pfcv_tbl IN pfcv_tbl_type,

Line 191: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_pfcv_tbl IN pfcv_tbl_type,
190: x_pfcv_tbl OUT NOCOPY pfcv_tbl_type,
191: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
192: PROCEDURE update_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

190: x_pfcv_tbl OUT NOCOPY pfcv_tbl_type,
191: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
192: PROCEDURE update_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_pfcv_tbl IN pfcv_tbl_type,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

198: p_pfcv_tbl IN pfcv_tbl_type,
199: x_pfcv_tbl OUT NOCOPY pfcv_tbl_type);
200: PROCEDURE delete_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_pfcv_rec IN pfcv_rec_type);

Line 209: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_pfcv_rec IN pfcv_rec_type);
207: PROCEDURE delete_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_pfcv_tbl IN pfcv_tbl_type,

Line 214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_pfcv_tbl IN pfcv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215: PROCEDURE delete_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

213: p_pfcv_tbl IN pfcv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215: PROCEDURE delete_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_pfcv_tbl IN pfcv_tbl_type);

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_pfcv_tbl IN pfcv_tbl_type);
222: PROCEDURE validate_row(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_pfcv_rec IN pfcv_rec_type);

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_pfcv_rec IN pfcv_rec_type);
229: PROCEDURE validate_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_pfcv_tbl IN pfcv_tbl_type,

Line 236: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_pfcv_tbl IN pfcv_tbl_type,
236: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
237: PROCEDURE validate_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,

Line 239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

235: p_pfcv_tbl IN pfcv_tbl_type,
236: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
237: PROCEDURE validate_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_pfcv_tbl IN pfcv_tbl_type);