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_AVL_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE avl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,

Line 8: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE avl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,

Line 9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,

5: ---------------------------------------------------------------------------
6: TYPE avl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 10: sty_id NUMBER := OKC_API.G_MISS_NUM,

6: TYPE avl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 11: try_id NUMBER := OKC_API.G_MISS_NUM,

7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,

Line 12: aes_id NUMBER := OKC_API.G_MISS_NUM,

8: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

Line 13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,

9: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,

Line 14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,

10: sty_id NUMBER := OKC_API.G_MISS_NUM,
11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,

Line 15: fma_id NUMBER := OKC_API.G_MISS_NUM,

11: try_id NUMBER := OKC_API.G_MISS_NUM,
12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

12: aes_id NUMBER := OKC_API.G_MISS_NUM,
13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,

13: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,

14: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

15: fma_id NUMBER := OKC_API.G_MISS_NUM,
16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 20: object_version_number NUMBER := OKC_API.G_MISS_NUM,

16: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,

17: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,

18: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

19: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,

Line 24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,

20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

21: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,

22: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 27: org_id NUMBER := OKC_API.G_MISS_NUM,

23: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

24: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

25: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

26: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

28: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

29: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

30: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

31: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

32: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

33: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

34: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

35: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

36: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

37: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

38: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

39: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 44: created_by NUMBER := OKC_API.G_MISS_NUM,

40: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

41: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49:

Line 46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

42: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49:
50: -- Added by HKPATEL for securitization changes

Line 47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

43: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49:
50: -- Added by HKPATEL for securitization changes
51: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);

Line 48: last_update_login NUMBER := OKC_API.G_MISS_NUM,

44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49:
50: -- Added by HKPATEL for securitization changes
51: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);
52:

Line 51: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);

47: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49:
50: -- Added by HKPATEL for securitization changes
51: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);
52:
53: g_miss_avl_rec avl_rec_type;
54: TYPE avl_tbl_type IS TABLE OF avl_rec_type
55: INDEX BY BINARY_INTEGER;

Line 58: id NUMBER := OKC_API.G_MISS_NUM,

54: TYPE avl_tbl_type IS TABLE OF avl_rec_type
55: INDEX BY BINARY_INTEGER;
56:
57: TYPE avlv_rec_type IS RECORD (
58: id NUMBER := OKC_API.G_MISS_NUM,
59: object_version_number NUMBER := OKC_API.G_MISS_NUM,
60: try_id NUMBER := OKC_API.G_MISS_NUM,
61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,

Line 59: object_version_number NUMBER := OKC_API.G_MISS_NUM,

55: INDEX BY BINARY_INTEGER;
56:
57: TYPE avlv_rec_type IS RECORD (
58: id NUMBER := OKC_API.G_MISS_NUM,
59: object_version_number NUMBER := OKC_API.G_MISS_NUM,
60: try_id NUMBER := OKC_API.G_MISS_NUM,
61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,

Line 60: try_id NUMBER := OKC_API.G_MISS_NUM,

56:
57: TYPE avlv_rec_type IS RECORD (
58: id NUMBER := OKC_API.G_MISS_NUM,
59: object_version_number NUMBER := OKC_API.G_MISS_NUM,
60: try_id NUMBER := OKC_API.G_MISS_NUM,
61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,

Line 61: aes_id NUMBER := OKC_API.G_MISS_NUM,

57: TYPE avlv_rec_type IS RECORD (
58: id NUMBER := OKC_API.G_MISS_NUM,
59: object_version_number NUMBER := OKC_API.G_MISS_NUM,
60: try_id NUMBER := OKC_API.G_MISS_NUM,
61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 62: sty_id NUMBER := OKC_API.G_MISS_NUM,

58: id NUMBER := OKC_API.G_MISS_NUM,
59: object_version_number NUMBER := OKC_API.G_MISS_NUM,
60: try_id NUMBER := OKC_API.G_MISS_NUM,
61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 63: fma_id NUMBER := OKC_API.G_MISS_NUM,

59: object_version_number NUMBER := OKC_API.G_MISS_NUM,
60: try_id NUMBER := OKC_API.G_MISS_NUM,
61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,

Line 64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,

60: try_id NUMBER := OKC_API.G_MISS_NUM,
61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

Line 65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,

61: aes_id NUMBER := OKC_API.G_MISS_NUM,
62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,

62: sty_id NUMBER := OKC_API.G_MISS_NUM,
63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,

63: fma_id NUMBER := OKC_API.G_MISS_NUM,
64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

64: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,

65: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,

Line 70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,

66: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,

67: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

68: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,

69: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,

70: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

71: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

72: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,

73: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

74: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

75: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

76: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

77: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

78: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

79: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

80: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

81: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

82: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

83: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

84: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

85: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

86: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,

Line 91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

87: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

88: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

89: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 94: org_id NUMBER := OKC_API.G_MISS_NUM,

90: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 95: created_by NUMBER := OKC_API.G_MISS_NUM,

91: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

92: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_update_login NUMBER := OKC_API.G_MISS_NUM,
100:

Line 97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

93: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_update_login NUMBER := OKC_API.G_MISS_NUM,
100:
101: -- Added by HKPATEL for securitization changes

Line 98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

94: org_id NUMBER := OKC_API.G_MISS_NUM,
95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_update_login NUMBER := OKC_API.G_MISS_NUM,
100:
101: -- Added by HKPATEL for securitization changes
102: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);

Line 99: last_update_login NUMBER := OKC_API.G_MISS_NUM,

95: created_by NUMBER := OKC_API.G_MISS_NUM,
96: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_update_login NUMBER := OKC_API.G_MISS_NUM,
100:
101: -- Added by HKPATEL for securitization changes
102: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);
103:

Line 102: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);

98: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_update_login NUMBER := OKC_API.G_MISS_NUM,
100:
101: -- Added by HKPATEL for securitization changes
102: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);
103:
104: g_miss_avlv_rec avlv_rec_type;
105: TYPE avlv_tbl_type IS TABLE OF avlv_rec_type
106: INDEX BY BINARY_INTEGER;

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

113: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
114: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
115: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
116:
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

114: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
115: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
116:
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

115: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
116:
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

116:
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: ---------------------------------------------------------------------------

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

120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: ---------------------------------------------------------------------------
128: -- GLOBAL VARIABLES

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

121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: ---------------------------------------------------------------------------
128: -- GLOBAL VARIABLES
129: ---------------------------------------------------------------------------

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

122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: ---------------------------------------------------------------------------
128: -- GLOBAL VARIABLES
129: ---------------------------------------------------------------------------
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AVL_PVT';

Line 131: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

127: ---------------------------------------------------------------------------
128: -- GLOBAL VARIABLES
129: ---------------------------------------------------------------------------
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AVL_PVT';
131: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
132: ---------------------------------------------------------------------------
133: -- Procedures and Functions
134: ---------------------------------------------------------------------------
135:

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

137: PROCEDURE change_version;
138: PROCEDURE api_copy;
139: PROCEDURE insert_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_avlv_rec IN avlv_rec_type,

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

146: x_avlv_rec OUT NOCOPY avlv_rec_type);
147:
148: PROCEDURE insert_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_avlv_tbl IN avlv_tbl_type,

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

155: x_avlv_tbl OUT NOCOPY avlv_tbl_type);
156:
157: PROCEDURE lock_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_avlv_rec IN avlv_rec_type);

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

163: p_avlv_rec IN avlv_rec_type);
164:
165: PROCEDURE lock_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_avlv_tbl IN avlv_tbl_type);

Line 175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

171: p_avlv_tbl IN avlv_tbl_type);
172:
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_avlv_rec IN avlv_rec_type,

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

180: x_avlv_rec OUT NOCOPY avlv_rec_type);
181:
182: PROCEDURE update_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_avlv_tbl IN avlv_tbl_type,

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: x_avlv_tbl OUT NOCOPY avlv_tbl_type);
190:
191: PROCEDURE delete_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_avlv_rec IN avlv_rec_type);

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

197: p_avlv_rec IN avlv_rec_type);
198:
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_avlv_tbl IN avlv_tbl_type);

Line 209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

205: p_avlv_tbl IN avlv_tbl_type);
206:
207: PROCEDURE validate_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_avlv_rec IN avlv_rec_type);

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

213: p_avlv_rec IN avlv_rec_type);
214:
215: PROCEDURE validate_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_avlv_tbl IN avlv_tbl_type);