DBA Data[Home] [Help]

APPS.OKL_PERD_STATUS_PVT dependencies on GL_PERIOD_STATUSES

Line 8: PERIOD_NAME GL_PERIOD_STATUSES.PERIOD_NAME%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,

Line 9: LAST_UPDATE_DATE GL_PERIOD_STATUSES.LAST_UPDATE_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,

Line 11: CLOSING_STATUS GL_PERIOD_STATUSES.CLOSING_STATUS%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,

Line 12: START_DATE GL_PERIOD_STATUSES.START_DATE%TYPE := OKL_API.G_MISS_DATE,

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,

Line 13: END_DATE GL_PERIOD_STATUSES.END_DATE%TYPE := OKL_API.G_MISS_DATE,

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,

Line 14: PERIOD_TYPE GL_PERIOD_STATUSES.PERIOD_TYPE%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 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,

Line 19: CREATION_DATE GL_PERIOD_STATUSES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,

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,

Line 22: ATTRIBUTE1 GL_PERIOD_STATUSES.ATTRIBUTE1%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,

Line 23: ATTRIBUTE2 GL_PERIOD_STATUSES.ATTRIBUTE2%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,

Line 24: ATTRIBUTE3 GL_PERIOD_STATUSES.ATTRIBUTE3%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,

Line 25: ATTRIBUTE4 GL_PERIOD_STATUSES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 26: ATTRIBUTE5 GL_PERIOD_STATUSES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 27: CONTEXT GL_PERIOD_STATUSES.CONTEXT%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,
31: ELIMINATION_CONFIRMED_FLAG GL_PERIOD_STATUSES.ELIMINATION_CONFIRMED_FLAG%TYPE := OKL_API.G_MISS_CHAR);

Line 28: YEAR_START_DATE GL_PERIOD_STATUSES.YEAR_START_DATE%TYPE := OKL_API.G_MISS_DATE,

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:

Line 29: QUARTER_START_DATE GL_PERIOD_STATUSES.QUARTER_START_DATE%TYPE := OKL_API.G_MISS_DATE,

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;

Line 31: ELIMINATION_CONFIRMED_FLAG GL_PERIOD_STATUSES.ELIMINATION_CONFIRMED_FLAG%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:
35: