eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_PERD_STATUS_PVT

Source


1 PACKAGE OKL_PERD_STATUS_PVT AUTHID CURRENT_USER AS
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,
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,
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,
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 
36 PROCEDURE SEARCH_PERIOD_STATUS(p_api_version        IN       NUMBER,
37                                p_init_msg_list      IN       VARCHAR2,
38                                x_return_status      OUT      NOCOPY VARCHAR2,
39                                x_msg_count          OUT      NOCOPY NUMBER,
40                                x_msg_data           OUT      NOCOPY VARCHAR2,
41                                p_period_rec         IN       PERIOD_REC_TYPE,
42                                x_period_tbl         OUT      NOCOPY PERIOD_TBL_TYPE);
43 
44 
45 PROCEDURE UPDATE_PERIOD_STATUS   (p_api_version      IN       NUMBER,
46                                   p_init_msg_list    IN       VARCHAR2,
47                                   x_return_status    OUT      NOCOPY VARCHAR2,
48                                   x_msg_count        OUT      NOCOPY NUMBER,
49                                   x_msg_data         OUT      NOCOPY VARCHAR2,
50                                   p_period_tbl       IN       PERIOD_TBL_TYPE);
51 
52 
53 PROCEDURE UPDATE_PERD_ROW (p_api_version        IN       NUMBER,
54                            p_init_msg_list      IN       VARCHAR2,
55                            x_return_status      OUT      NOCOPY VARCHAR2,
56                            x_msg_count          OUT      NOCOPY NUMBER,
57                            x_msg_data           OUT      NOCOPY VARCHAR2,
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 
67 END;