4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_RBK_SELECTED_CONTRACT_V Record Spec
7: TYPE mstv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- OKL_RBK_SELECTED_CONTRACT_V Record Spec
7: TYPE mstv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
6: -- OKL_RBK_SELECTED_CONTRACT_V Record Spec
7: TYPE mstv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE mstv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
9: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
10: ,khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
12: ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
13: ,kle_id NUMBER := OKC_API.G_MISS_NUM
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
14: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
15: ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
16: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
30: ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
38: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
31: ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
38: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: G_MISS_mstv_rec mstv_rec_type;
32: ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
38: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: G_MISS_mstv_rec mstv_rec_type;
40: TYPE mstv_tbl_type IS TABLE OF mstv_rec_type
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
38: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: G_MISS_mstv_rec mstv_rec_type;
40: TYPE mstv_tbl_type IS TABLE OF mstv_rec_type
41: INDEX BY BINARY_INTEGER;
34: ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
38: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: G_MISS_mstv_rec mstv_rec_type;
40: TYPE mstv_tbl_type IS TABLE OF mstv_rec_type
41: INDEX BY BINARY_INTEGER;
42: -- OKL_RBK_SELECTED_CONTRACT Record Spec
40: TYPE mstv_tbl_type IS TABLE OF mstv_rec_type
41: INDEX BY BINARY_INTEGER;
42: -- OKL_RBK_SELECTED_CONTRACT Record Spec
43: TYPE mst_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
46: ,khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
41: INDEX BY BINARY_INTEGER;
42: -- OKL_RBK_SELECTED_CONTRACT Record Spec
43: TYPE mst_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
46: ,khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
42: -- OKL_RBK_SELECTED_CONTRACT Record Spec
43: TYPE mst_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
46: ,khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
43: TYPE mst_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
46: ,khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
46: ,khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
45: ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
46: ,khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
46: ,khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
47: ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
48: ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
49: ,kle_id NUMBER := OKC_API.G_MISS_NUM
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
50: ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
51: ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
52: ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
74: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
67: ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
74: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
75: G_MISS_mst_rec mst_rec_type;
68: ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
74: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
75: G_MISS_mst_rec mst_rec_type;
76: TYPE mst_tbl_type IS TABLE OF mst_rec_type
69: ,created_by NUMBER := OKC_API.G_MISS_NUM
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
74: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
75: G_MISS_mst_rec mst_rec_type;
76: TYPE mst_tbl_type IS TABLE OF mst_rec_type
77: INDEX BY BINARY_INTEGER;
70: ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
74: ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
75: G_MISS_mst_rec mst_rec_type;
76: TYPE mst_tbl_type IS TABLE OF mst_rec_type
77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
94:
105: ---------------------------------------------------------------------------
106: -- GLOBAL VARIABLES
107: ---------------------------------------------------------------------------
108: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_MST_PVT';
109: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
110: ---------------------------------------------------------------------------
111: -- Procedures and Functions
112: ---------------------------------------------------------------------------
113:
115: PROCEDURE change_version;
116: PROCEDURE api_copy;
117: PROCEDURE insert_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_mstv_rec IN mstv_rec_type,
123: p_mstv_rec IN mstv_rec_type,
124: x_mstv_rec OUT NOCOPY mstv_rec_type);
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_mstv_tbl IN mstv_tbl_type,
131: p_mstv_tbl IN mstv_tbl_type,
132: x_mstv_tbl OUT NOCOPY mstv_tbl_type);
133: PROCEDURE lock_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_mstv_rec IN mstv_rec_type);
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_mstv_rec IN mstv_rec_type);
140: PROCEDURE lock_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_mstv_tbl IN mstv_tbl_type);
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_mstv_tbl IN mstv_tbl_type);
147: PROCEDURE update_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_mstv_rec IN mstv_rec_type,
153: p_mstv_rec IN mstv_rec_type,
154: x_mstv_rec OUT NOCOPY mstv_rec_type);
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_mstv_tbl IN mstv_tbl_type,
161: p_mstv_tbl IN mstv_tbl_type,
162: x_mstv_tbl OUT NOCOPY mstv_tbl_type);
163: PROCEDURE delete_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_mstv_rec IN mstv_rec_type);
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_mstv_rec IN mstv_rec_type);
170: PROCEDURE delete_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_mstv_tbl IN mstv_tbl_type);
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_mstv_tbl IN mstv_tbl_type);
177: PROCEDURE validate_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_mstv_rec IN mstv_rec_type);
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_mstv_rec IN mstv_rec_type);
184: PROCEDURE validate_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_mstv_tbl IN mstv_tbl_type);