4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CREDIT_REQUESTS_V Record Spec
7: TYPE crqv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,quote_id NUMBER := OKC_API.G_MISS_NUM
10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKL_CREDIT_REQUESTS_V Record Spec
7: TYPE crqv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,quote_id NUMBER := OKC_API.G_MISS_NUM
10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
6: -- OKL_CREDIT_REQUESTS_V Record Spec
7: TYPE crqv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,quote_id NUMBER := OKC_API.G_MISS_NUM
10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
7: TYPE crqv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,quote_id NUMBER := OKC_API.G_MISS_NUM
10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,quote_id NUMBER := OKC_API.G_MISS_NUM
10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
9: ,quote_id NUMBER := OKC_API.G_MISS_NUM
10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,requested_by NUMBER := OKC_API.G_MISS_NUM
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
15: ,approved_by NUMBER := OKC_API.G_MISS_NUM
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
18: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
43: G_MISS_crqv_rec crqv_rec_type;
36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
43: G_MISS_crqv_rec crqv_rec_type;
44: TYPE crqv_tbl_type IS TABLE OF crqv_rec_type
37: ,org_id NUMBER := OKC_API.G_MISS_NUM
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
43: G_MISS_crqv_rec crqv_rec_type;
44: TYPE crqv_tbl_type IS TABLE OF crqv_rec_type
45: INDEX BY BINARY_INTEGER;
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
43: G_MISS_crqv_rec crqv_rec_type;
44: TYPE crqv_tbl_type IS TABLE OF crqv_rec_type
45: INDEX BY BINARY_INTEGER;
46: -- OKL_CREDIT_REQUESTS Record Spec
44: TYPE crqv_tbl_type IS TABLE OF crqv_rec_type
45: INDEX BY BINARY_INTEGER;
46: -- OKL_CREDIT_REQUESTS Record Spec
47: TYPE crq_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,quote_id NUMBER := OKC_API.G_MISS_NUM
50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
45: INDEX BY BINARY_INTEGER;
46: -- OKL_CREDIT_REQUESTS Record Spec
47: TYPE crq_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,quote_id NUMBER := OKC_API.G_MISS_NUM
50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
46: -- OKL_CREDIT_REQUESTS Record Spec
47: TYPE crq_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,quote_id NUMBER := OKC_API.G_MISS_NUM
50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
47: TYPE crq_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,quote_id NUMBER := OKC_API.G_MISS_NUM
50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,quote_id NUMBER := OKC_API.G_MISS_NUM
50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,quote_id NUMBER := OKC_API.G_MISS_NUM
50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
52: ,credit_amount NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53: ,requested_by NUMBER := OKC_API.G_MISS_NUM
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55: ,approved_by NUMBER := OKC_API.G_MISS_NUM
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58: ,credit_khr_id NUMBER := OKC_API.G_MISS_NUM
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: G_MISS_crq_rec crq_rec_type;
76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: G_MISS_crq_rec crq_rec_type;
84: TYPE crq_tbl_type IS TABLE OF crq_rec_type
77: ,org_id NUMBER := OKC_API.G_MISS_NUM
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: G_MISS_crq_rec crq_rec_type;
84: TYPE crq_tbl_type IS TABLE OF crq_rec_type
85: INDEX BY BINARY_INTEGER;
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: G_MISS_crq_rec crq_rec_type;
84: TYPE crq_tbl_type IS TABLE OF crq_rec_type
85: INDEX BY BINARY_INTEGER;
86: ---------------------------------------------------------------------------
85: INDEX BY BINARY_INTEGER;
86: ---------------------------------------------------------------------------
87: -- GLOBAL MESSAGE CONSTANTS
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: ---------------------------------------------------------------------------
87: -- GLOBAL MESSAGE CONSTANTS
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: -- GLOBAL MESSAGE CONSTANTS
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
100: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
100: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
101: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
100: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
101: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
102:
118: PROCEDURE change_version;
119: PROCEDURE api_copy;
120: PROCEDURE insert_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_crqv_rec IN crqv_rec_type,
126: p_crqv_rec IN crqv_rec_type,
127: x_crqv_rec OUT NOCOPY crqv_rec_type);
128: PROCEDURE insert_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_crqv_tbl IN crqv_tbl_type,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_crqv_tbl IN crqv_tbl_type,
135: x_crqv_tbl OUT NOCOPY crqv_tbl_type,
136: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
137: PROCEDURE insert_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
135: x_crqv_tbl OUT NOCOPY crqv_tbl_type,
136: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
137: PROCEDURE insert_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_crqv_tbl IN crqv_tbl_type,
143: p_crqv_tbl IN crqv_tbl_type,
144: x_crqv_tbl OUT NOCOPY crqv_tbl_type);
145: PROCEDURE lock_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_crqv_rec IN crqv_rec_type);
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_crqv_rec IN crqv_rec_type);
152: PROCEDURE lock_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_crqv_tbl IN crqv_tbl_type,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_crqv_tbl IN crqv_tbl_type,
159: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
160: PROCEDURE lock_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
158: p_crqv_tbl IN crqv_tbl_type,
159: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
160: PROCEDURE lock_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_crqv_tbl IN crqv_tbl_type);
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_crqv_tbl IN crqv_tbl_type);
167: PROCEDURE update_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_crqv_rec IN crqv_rec_type,
173: p_crqv_rec IN crqv_rec_type,
174: x_crqv_rec OUT NOCOPY crqv_rec_type);
175: PROCEDURE update_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_crqv_tbl IN crqv_tbl_type,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_crqv_tbl IN crqv_tbl_type,
182: x_crqv_tbl OUT NOCOPY crqv_tbl_type,
183: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
184: PROCEDURE update_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,
182: x_crqv_tbl OUT NOCOPY crqv_tbl_type,
183: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
184: PROCEDURE update_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_crqv_tbl IN crqv_tbl_type,
190: p_crqv_tbl IN crqv_tbl_type,
191: x_crqv_tbl OUT NOCOPY crqv_tbl_type);
192: PROCEDURE delete_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_crqv_rec IN crqv_rec_type);
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_crqv_rec IN crqv_rec_type);
199: PROCEDURE delete_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_crqv_tbl IN crqv_tbl_type,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_crqv_tbl IN crqv_tbl_type,
206: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
207: PROCEDURE delete_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
205: p_crqv_tbl IN crqv_tbl_type,
206: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
207: PROCEDURE delete_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_crqv_tbl IN crqv_tbl_type);
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_crqv_tbl IN crqv_tbl_type);
214: PROCEDURE validate_row(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_crqv_rec IN crqv_rec_type);
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_crqv_rec IN crqv_rec_type);
221: PROCEDURE validate_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_crqv_tbl IN crqv_tbl_type,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_crqv_tbl IN crqv_tbl_type,
228: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
229: PROCEDURE validate_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
227: p_crqv_tbl IN crqv_tbl_type,
228: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
229: PROCEDURE validate_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_crqv_tbl IN crqv_tbl_type);