4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CF_OBJECT_PERIODS_V Record Spec
7: TYPE cfpv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
10: ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- OKL_CF_OBJECT_PERIODS_V Record Spec
7: TYPE cfpv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
10: ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
6: -- OKL_CF_OBJECT_PERIODS_V Record Spec
7: TYPE cfpv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
10: ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
7: TYPE cfpv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
10: ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
10: ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
9: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
10: ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
10: ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
11: ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
12: ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32: ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32: ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
26: ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32: ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
27: ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32: ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
35: G_MISS_cfpv_rec cfpv_rec_type;
28: ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32: ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
35: G_MISS_cfpv_rec cfpv_rec_type;
36: TYPE cfpv_tbl_type IS TABLE OF cfpv_rec_type
29: ,created_by NUMBER := OKL_API.G_MISS_NUM
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32: ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
35: G_MISS_cfpv_rec cfpv_rec_type;
36: TYPE cfpv_tbl_type IS TABLE OF cfpv_rec_type
37: INDEX BY BINARY_INTEGER;
30: ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32: ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
35: G_MISS_cfpv_rec cfpv_rec_type;
36: TYPE cfpv_tbl_type IS TABLE OF cfpv_rec_type
37: INDEX BY BINARY_INTEGER;
38: -- OKL_CF_OBJECT_PERIODS Record Spec
36: TYPE cfpv_tbl_type IS TABLE OF cfpv_rec_type
37: INDEX BY BINARY_INTEGER;
38: -- OKL_CF_OBJECT_PERIODS Record Spec
39: TYPE cfp_rec_type IS RECORD (
40: id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
37: INDEX BY BINARY_INTEGER;
38: -- OKL_CF_OBJECT_PERIODS Record Spec
39: TYPE cfp_rec_type IS RECORD (
40: id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
38: -- OKL_CF_OBJECT_PERIODS Record Spec
39: TYPE cfp_rec_type IS RECORD (
40: id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
39: TYPE cfp_rec_type IS RECORD (
40: id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
40: id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
42: ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
43: ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
44: ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
45: ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
46: ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
47: ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
48: ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
54: ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
56: ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64: ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64: ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
58: ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64: ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
59: ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64: ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
67: G_MISS_cfp_rec cfp_rec_type;
60: ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64: ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
67: G_MISS_cfp_rec cfp_rec_type;
68: TYPE cfp_tbl_type IS TABLE OF cfp_rec_type
61: ,created_by NUMBER := OKL_API.G_MISS_NUM
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64: ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
67: G_MISS_cfp_rec cfp_rec_type;
68: TYPE cfp_tbl_type IS TABLE OF cfp_rec_type
69: INDEX BY BINARY_INTEGER;
62: ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64: ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
67: G_MISS_cfp_rec cfp_rec_type;
68: TYPE cfp_tbl_type IS TABLE OF cfp_rec_type
69: INDEX BY BINARY_INTEGER;
70: ---------------------------------------------------------------------------
69: INDEX BY BINARY_INTEGER;
70: ---------------------------------------------------------------------------
71: -- GLOBAL MESSAGE CONSTANTS
72: ---------------------------------------------------------------------------
73: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
74: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
75: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
70: ---------------------------------------------------------------------------
71: -- GLOBAL MESSAGE CONSTANTS
72: ---------------------------------------------------------------------------
73: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
74: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
75: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
71: -- GLOBAL MESSAGE CONSTANTS
72: ---------------------------------------------------------------------------
73: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
74: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
75: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
72: ---------------------------------------------------------------------------
73: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
74: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
75: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
73: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
74: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
75: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
81: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
74: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
75: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
81: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
82: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
75: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
81: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
82: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
83: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
76: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
81: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
82: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
83: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
84: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
77: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
81: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
82: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
83: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
84: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
85: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
78: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
81: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
82: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
83: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
84: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
85: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
86: -- SECHAWLA Added
94: ---------------------------------------------------------------------------
95: -- GLOBAL VARIABLES
96: ---------------------------------------------------------------------------
97: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CFP_PVT';
98: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
99: ---------------------------------------------------------------------------
100: -- Procedures and Functions
101: ---------------------------------------------------------------------------
102:
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_cfpv_tbl IN cfpv_tbl_type,
121: x_cfpv_tbl OUT NOCOPY cfpv_tbl_type,
122: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
123: PROCEDURE insert_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2,
126: x_return_status OUT NOCOPY VARCHAR2,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_cfpv_tbl IN cfpv_tbl_type,
145: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
146: PROCEDURE lock_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2,
149: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_cfpv_tbl IN cfpv_tbl_type,
168: x_cfpv_tbl OUT NOCOPY cfpv_tbl_type,
169: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
170: PROCEDURE update_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2,
173: x_return_status OUT NOCOPY VARCHAR2,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_cfpv_tbl IN cfpv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
193: PROCEDURE delete_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2,
196: x_return_status OUT NOCOPY VARCHAR2,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_cfpv_tbl IN cfpv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215: PROCEDURE validate_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2,
218: x_return_status OUT NOCOPY VARCHAR2,