4:
5: TYPE period_rec_type IS RECORD (
6: APPLICATION_ID NUMBER := OKL_API.G_MISS_NUM,
7: SET_OF_BOOKS_ID NUMBER := OKL_API.G_MISS_NUM,
8: PERIOD_NAME GL_PERIOD_STATUSES.PERIOD_NAME%TYPE := OKL_API.G_MISS_CHAR,
9: LAST_UPDATE_DATE GL_PERIOD_STATUSES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
10: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
11: CLOSING_STATUS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE := OKL_API.G_MISS_CHAR,
12: START_DATE GL_PERIOD_STATUSES.START_DATE%TYPE := OKL_API.G_MISS_DATE,
5: TYPE period_rec_type IS RECORD (
6: APPLICATION_ID NUMBER := OKL_API.G_MISS_NUM,
7: SET_OF_BOOKS_ID NUMBER := OKL_API.G_MISS_NUM,
8: PERIOD_NAME GL_PERIOD_STATUSES.PERIOD_NAME%TYPE := OKL_API.G_MISS_CHAR,
9: LAST_UPDATE_DATE GL_PERIOD_STATUSES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
10: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
11: CLOSING_STATUS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE := OKL_API.G_MISS_CHAR,
12: START_DATE GL_PERIOD_STATUSES.START_DATE%TYPE := OKL_API.G_MISS_DATE,
13: END_DATE GL_PERIOD_STATUSES.END_DATE%TYPE := OKL_API.G_MISS_DATE,
7: SET_OF_BOOKS_ID NUMBER := OKL_API.G_MISS_NUM,
8: PERIOD_NAME GL_PERIOD_STATUSES.PERIOD_NAME%TYPE := OKL_API.G_MISS_CHAR,
9: LAST_UPDATE_DATE GL_PERIOD_STATUSES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
10: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
11: CLOSING_STATUS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE := OKL_API.G_MISS_CHAR,
12: START_DATE GL_PERIOD_STATUSES.START_DATE%TYPE := OKL_API.G_MISS_DATE,
13: END_DATE GL_PERIOD_STATUSES.END_DATE%TYPE := OKL_API.G_MISS_DATE,
14: PERIOD_TYPE GL_PERIOD_STATUSES.PERIOD_TYPE%TYPE := OKL_API.G_MISS_CHAR,
15: PERIOD_YEAR NUMBER := OKL_API.G_MISS_NUM,
8: PERIOD_NAME GL_PERIOD_STATUSES.PERIOD_NAME%TYPE := OKL_API.G_MISS_CHAR,
9: LAST_UPDATE_DATE GL_PERIOD_STATUSES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
10: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
11: CLOSING_STATUS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE := OKL_API.G_MISS_CHAR,
12: START_DATE GL_PERIOD_STATUSES.START_DATE%TYPE := OKL_API.G_MISS_DATE,
13: END_DATE GL_PERIOD_STATUSES.END_DATE%TYPE := OKL_API.G_MISS_DATE,
14: PERIOD_TYPE GL_PERIOD_STATUSES.PERIOD_TYPE%TYPE := OKL_API.G_MISS_CHAR,
15: PERIOD_YEAR NUMBER := OKL_API.G_MISS_NUM,
16: PERIOD_NUM NUMBER := OKL_API.G_MISS_NUM,
9: LAST_UPDATE_DATE GL_PERIOD_STATUSES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
10: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
11: CLOSING_STATUS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE := OKL_API.G_MISS_CHAR,
12: START_DATE GL_PERIOD_STATUSES.START_DATE%TYPE := OKL_API.G_MISS_DATE,
13: END_DATE GL_PERIOD_STATUSES.END_DATE%TYPE := OKL_API.G_MISS_DATE,
14: PERIOD_TYPE GL_PERIOD_STATUSES.PERIOD_TYPE%TYPE := OKL_API.G_MISS_CHAR,
15: PERIOD_YEAR NUMBER := OKL_API.G_MISS_NUM,
16: PERIOD_NUM NUMBER := OKL_API.G_MISS_NUM,
17: QUARTER_NUM NUMBER:= OKL_API.G_MISS_NUM,
10: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
11: CLOSING_STATUS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE := OKL_API.G_MISS_CHAR,
12: START_DATE GL_PERIOD_STATUSES.START_DATE%TYPE := OKL_API.G_MISS_DATE,
13: END_DATE GL_PERIOD_STATUSES.END_DATE%TYPE := OKL_API.G_MISS_DATE,
14: PERIOD_TYPE GL_PERIOD_STATUSES.PERIOD_TYPE%TYPE := OKL_API.G_MISS_CHAR,
15: PERIOD_YEAR NUMBER := OKL_API.G_MISS_NUM,
16: PERIOD_NUM NUMBER := OKL_API.G_MISS_NUM,
17: QUARTER_NUM NUMBER:= OKL_API.G_MISS_NUM,
18: ADJUSTMENT_PERIOD_FLAG GL_PERIOD_STATUSES.ADJUSTMENT_PERIOD_FLAG%TYPE := OKL_API.G_MISS_CHAR,
14: PERIOD_TYPE GL_PERIOD_STATUSES.PERIOD_TYPE%TYPE := OKL_API.G_MISS_CHAR,
15: PERIOD_YEAR NUMBER := OKL_API.G_MISS_NUM,
16: PERIOD_NUM NUMBER := OKL_API.G_MISS_NUM,
17: QUARTER_NUM NUMBER:= OKL_API.G_MISS_NUM,
18: ADJUSTMENT_PERIOD_FLAG GL_PERIOD_STATUSES.ADJUSTMENT_PERIOD_FLAG%TYPE := OKL_API.G_MISS_CHAR,
19: CREATION_DATE GL_PERIOD_STATUSES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKL_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER:= OKL_API.G_MISS_NUM,
22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
15: PERIOD_YEAR NUMBER := OKL_API.G_MISS_NUM,
16: PERIOD_NUM NUMBER := OKL_API.G_MISS_NUM,
17: QUARTER_NUM NUMBER:= OKL_API.G_MISS_NUM,
18: ADJUSTMENT_PERIOD_FLAG GL_PERIOD_STATUSES.ADJUSTMENT_PERIOD_FLAG%TYPE := OKL_API.G_MISS_CHAR,
19: CREATION_DATE GL_PERIOD_STATUSES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKL_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER:= OKL_API.G_MISS_NUM,
22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
18: ADJUSTMENT_PERIOD_FLAG GL_PERIOD_STATUSES.ADJUSTMENT_PERIOD_FLAG%TYPE := OKL_API.G_MISS_CHAR,
19: CREATION_DATE GL_PERIOD_STATUSES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKL_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER:= OKL_API.G_MISS_NUM,
22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
19: CREATION_DATE GL_PERIOD_STATUSES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKL_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER:= OKL_API.G_MISS_NUM,
22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
20: CREATED_BY NUMBER:= OKL_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER:= OKL_API.G_MISS_NUM,
22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,
21: LAST_UPDATE_LOGIN NUMBER:= OKL_API.G_MISS_NUM,
22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,
29: QUARTER_START_DATE GL_PERIOD_STATUSES.QUARTER_START_DATE%TYPE := OKL_API.G_MISS_DATE,
22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,
29: QUARTER_START_DATE GL_PERIOD_STATUSES.QUARTER_START_DATE%TYPE := OKL_API.G_MISS_DATE,
30: EFFECTIVE_PERIOD_NUM NUMBER:= OKL_API.G_MISS_NUM,
23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,
29: QUARTER_START_DATE GL_PERIOD_STATUSES.QUARTER_START_DATE%TYPE := OKL_API.G_MISS_DATE,
30: EFFECTIVE_PERIOD_NUM NUMBER:= OKL_API.G_MISS_NUM,
31: ELIMINATION_CONFIRMED_FLAG GL_PERIOD_STATUSES.ELIMINATION_CONFIRMED_FLAG%TYPE := OKL_API.G_MISS_CHAR);
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,
29: QUARTER_START_DATE GL_PERIOD_STATUSES.QUARTER_START_DATE%TYPE := OKL_API.G_MISS_DATE,
30: EFFECTIVE_PERIOD_NUM NUMBER:= OKL_API.G_MISS_NUM,
31: ELIMINATION_CONFIRMED_FLAG GL_PERIOD_STATUSES.ELIMINATION_CONFIRMED_FLAG%TYPE := OKL_API.G_MISS_CHAR);
32:
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,
29: QUARTER_START_DATE GL_PERIOD_STATUSES.QUARTER_START_DATE%TYPE := OKL_API.G_MISS_DATE,
30: EFFECTIVE_PERIOD_NUM NUMBER:= OKL_API.G_MISS_NUM,
31: ELIMINATION_CONFIRMED_FLAG GL_PERIOD_STATUSES.ELIMINATION_CONFIRMED_FLAG%TYPE := OKL_API.G_MISS_CHAR);
32:
33: TYPE period_tbl_type IS TABLE OF period_rec_type INDEX BY BINARY_INTEGER;
27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%TYPE := OKL_API.G_MISS_CHAR,
28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,
29: QUARTER_START_DATE GL_PERIOD_STATUSES.QUARTER_START_DATE%TYPE := OKL_API.G_MISS_DATE,
30: EFFECTIVE_PERIOD_NUM NUMBER:= OKL_API.G_MISS_NUM,
31: ELIMINATION_CONFIRMED_FLAG GL_PERIOD_STATUSES.ELIMINATION_CONFIRMED_FLAG%TYPE := OKL_API.G_MISS_CHAR);
32:
33: TYPE period_tbl_type IS TABLE OF period_rec_type INDEX BY BINARY_INTEGER;
34:
35: