2: /* $Header: OKLRPSMS.pls 115.2 2002/07/03 22:53:46 kjinger noship $ */
3:
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,
3:
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,
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,
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,
14: PERIOD_TYPE GL_PERIOD_STATUSES.PERIOD_TYPE%TYPE := OKL_API.G_MISS_CHAR,
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,
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,
19: CREATION_DATE GL_PERIOD_STATUSES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
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,
19: CREATION_DATE GL_PERIOD_STATUSES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKL_API.G_MISS_NUM,
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,
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,
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,
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,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
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,
24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%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;
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;
34:
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:
58: p_period_rec IN PERIOD_REC_TYPE);
59:
60:
61: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PERD_STATUS_PVT' ;
62: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66:
59:
60:
61: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PERD_STATUS_PVT' ;
62: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66:
67: END;
60:
61: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PERD_STATUS_PVT' ;
62: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66:
67: END;
61: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PERD_STATUS_PVT' ;
62: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66:
67: END;