eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CRQ_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

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

Line 9: ,quote_id 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

Line 10: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR

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

Line 11: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM

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

Line 12: ,credit_amount 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

Line 13: ,requested_by 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
17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 14: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 15: ,approved_by 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

Line 16: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 17: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR

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

Line 18: ,credit_khr_id 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
22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%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

Line 20: ,object_version_number 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
24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%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

Line 22: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%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

Line 23: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%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

Line 24: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%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

Line 25: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%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

Line 26: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%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

Line 27: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%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

Line 28: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%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

Line 29: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%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

Line 30: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%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

Line 31: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%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

Line 32: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%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

Line 33: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%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

Line 34: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%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
38: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 35: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%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
39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 36: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%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
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 37: ,org_id 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

Line 38: ,created_by NUMBER := OKC_API.G_MISS_NUM

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);

Line 39: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

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

Line 41: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 42: ,last_update_login 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;
46: -- OKL_CREDIT_REQUESTS Record Spec

Line 48: id NUMBER := OKC_API.G_MISS_NUM

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

Line 49: ,quote_id 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

Line 50: ,credit_req_number OKL_CREDIT_REQUESTS.CREDIT_REQ_NUMBER%TYPE := OKC_API.G_MISS_CHAR

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

Line 51: ,credit_req_id NUMBER := OKC_API.G_MISS_NUM

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

Line 52: ,credit_amount 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

Line 53: ,requested_by 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
57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 54: ,requested_date OKL_CREDIT_REQUESTS.REQUESTED_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 55: ,approved_by 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

Line 56: ,approved_date OKL_CREDIT_REQUESTS.APPROVED_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 57: ,status OKL_CREDIT_REQUESTS.STATUS%TYPE := OKC_API.G_MISS_CHAR

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

Line 58: ,credit_khr_id 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
62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 59: ,currency_code OKL_CREDIT_REQUESTS.CURRENCY_CODE%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

Line 60: ,object_version_number 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
64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 61: ,attribute_category OKL_CREDIT_REQUESTS.ATTRIBUTE_CATEGORY%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

Line 62: ,attribute1 OKL_CREDIT_REQUESTS.ATTRIBUTE1%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

Line 63: ,attribute2 OKL_CREDIT_REQUESTS.ATTRIBUTE2%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

Line 64: ,attribute3 OKL_CREDIT_REQUESTS.ATTRIBUTE3%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

Line 65: ,attribute4 OKL_CREDIT_REQUESTS.ATTRIBUTE4%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

Line 66: ,attribute5 OKL_CREDIT_REQUESTS.ATTRIBUTE5%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

Line 67: ,attribute6 OKL_CREDIT_REQUESTS.ATTRIBUTE6%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

Line 68: ,attribute7 OKL_CREDIT_REQUESTS.ATTRIBUTE7%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

Line 69: ,attribute8 OKL_CREDIT_REQUESTS.ATTRIBUTE8%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

Line 70: ,attribute9 OKL_CREDIT_REQUESTS.ATTRIBUTE9%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

Line 71: ,attribute10 OKL_CREDIT_REQUESTS.ATTRIBUTE10%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

Line 72: ,attribute11 OKL_CREDIT_REQUESTS.ATTRIBUTE11%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

Line 73: ,attribute12 OKL_CREDIT_REQUESTS.ATTRIBUTE12%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

Line 74: ,attribute13 OKL_CREDIT_REQUESTS.ATTRIBUTE13%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
78: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 75: ,attribute14 OKL_CREDIT_REQUESTS.ATTRIBUTE14%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
79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 76: ,attribute15 OKL_CREDIT_REQUESTS.ATTRIBUTE15%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
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 77: ,org_id 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

Line 78: ,created_by NUMBER := OKC_API.G_MISS_NUM

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);

Line 79: ,creation_date OKL_CREDIT_REQUESTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

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

Line 81: ,last_update_date OKL_CREDIT_REQUESTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 82: ,last_update_login 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;
86: ---------------------------------------------------------------------------

Line 89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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;

Line 90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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;

Line 92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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;

Line 93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;

Line 95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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';

Line 96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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';

Line 97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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';

Line 98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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:

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 136: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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,

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 159: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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,

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 183: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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,

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 206: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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,

Line 209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 228: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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,

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);