67: --Bug 4662173 - Start of Changes
68: TYPE DIST_INFO_TBL_TYPE IS TABLE OF DIST_INFO_REC_TYPE INDEX BY BINARY_INTEGER;
69:
70: TYPE avlb_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: try_id NUMBER := OKC_API.G_MISS_NUM,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
68: TYPE DIST_INFO_TBL_TYPE IS TABLE OF DIST_INFO_REC_TYPE INDEX BY BINARY_INTEGER;
69:
70: TYPE avlb_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: try_id NUMBER := OKC_API.G_MISS_NUM,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
69:
70: TYPE avlb_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: try_id NUMBER := OKC_API.G_MISS_NUM,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
70: TYPE avlb_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: try_id NUMBER := OKC_API.G_MISS_NUM,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: try_id NUMBER := OKC_API.G_MISS_NUM,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: try_id NUMBER := OKC_API.G_MISS_NUM,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
73: try_id NUMBER := OKC_API.G_MISS_NUM,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
74: aes_id NUMBER := OKC_API.G_MISS_NUM,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
75: sty_id NUMBER := OKC_API.G_MISS_NUM,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
76: fma_id NUMBER := OKC_API.G_MISS_NUM,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
77: set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
78: fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
79: syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
80: post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
81: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
82: memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
83: prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
100: attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
101: attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
103: attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
111: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
104: attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
111: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
112: last_update_login NUMBER := OKC_API.G_MISS_NUM,
105: attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
111: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
112: last_update_login NUMBER := OKC_API.G_MISS_NUM,
113:
106: attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
111: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
112: last_update_login NUMBER := OKC_API.G_MISS_NUM,
113:
114: -- Added by HKPATEL for securitization changes
107: org_id NUMBER := OKC_API.G_MISS_NUM,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
111: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
112: last_update_login NUMBER := OKC_API.G_MISS_NUM,
113:
114: -- Added by HKPATEL for securitization changes
115: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR,
108: created_by NUMBER := OKC_API.G_MISS_NUM,
109: creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
111: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
112: last_update_login NUMBER := OKC_API.G_MISS_NUM,
113:
114: -- Added by HKPATEL for securitization changes
115: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: parent_index_number NUMBER := OKC_API.G_MISS_NUM);
111: last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
112: last_update_login NUMBER := OKC_API.G_MISS_NUM,
113:
114: -- Added by HKPATEL for securitization changes
115: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: parent_index_number NUMBER := OKC_API.G_MISS_NUM);
117:
118: g_miss_avlv_rec avlv_rec_type;
119:
112: last_update_login NUMBER := OKC_API.G_MISS_NUM,
113:
114: -- Added by HKPATEL for securitization changes
115: inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: parent_index_number NUMBER := OKC_API.G_MISS_NUM);
117:
118: g_miss_avlv_rec avlv_rec_type;
119:
120: TYPE avlb_tbl_type IS TABLE OF avlb_rec_type
120: TYPE avlb_tbl_type IS TABLE OF avlb_rec_type
121: INDEX BY BINARY_INTEGER;
122:
123: TYPE amt_rec_type IS RECORD(
124: amount NUMBER := OKC_API.G_MISS_NUM,
125: parent_index_number NUMBER := OKC_API.G_MISS_NUM);
126:
127: TYPE amt_tbl_type IS TABLE OF amt_rec_type
128: INDEX BY BINARY_INTEGER;
121: INDEX BY BINARY_INTEGER;
122:
123: TYPE amt_rec_type IS RECORD(
124: amount NUMBER := OKC_API.G_MISS_NUM,
125: parent_index_number NUMBER := OKC_API.G_MISS_NUM);
126:
127: TYPE amt_tbl_type IS TABLE OF amt_rec_type
128: INDEX BY BINARY_INTEGER;
129: