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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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
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);
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:
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;
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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
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);
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:
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;
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;
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;
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;
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;
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;
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;
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: ---------------------------------------------------------------------------
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
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: ---------------------------------------------------------------------------
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';
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:
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,
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,
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);
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);
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,
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,
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);
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);
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);
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);