[Home] [Help]
PACKAGE: APPS.OKL_RCS_PVT
Source
1 PACKAGE OKL_RCS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSRCSS.pls 120.2 2005/11/29 14:23:08 viselvar noship $ */
3 --------------------------------------------------------------------------------
4 --GLOBAL DATASTRUCTURES
5 --------------------------------------------------------------------------------
6 TYPE okl_rcsv_rec IS RECORD (
7 RESI_CATEGORY_SET_ID NUMBER ,
8 ORIG_RESI_CAT_SET_ID NUMBER ,
9 OBJECT_VERSION_NUMBER NUMBER,
10 ORG_ID NUMBER,
11 SOURCE_CODE OKL_FE_RESI_CAT_V.SOURCE_CODE%TYPE,
12 STS_CODE OKL_FE_RESI_CAT_V.STS_CODE%TYPE,
13 RESI_CAT_NAME OKL_FE_RESI_CAT_V.RESI_CAT_NAME%TYPE,
14 RESI_CAT_DESC OKL_FE_RESI_CAT_V.RESI_CAT_DESC%TYPE,
15 SFWT_FLAG OKL_FE_RESI_CAT_V.SFWT_FLAG%TYPE,
16 CREATED_BY NUMBER,
17 CREATION_DATE OKL_FE_RESI_CAT_V.CREATION_DATE%TYPE,
18 LAST_UPDATED_BY NUMBER ,
19 LAST_UPDATE_DATE OKL_FE_RESI_CAT_V.LAST_UPDATE_DATE%TYPE,
20 LAST_UPDATE_LOGIN NUMBER );
21
22 TYPE okl_rcsv_tbl IS TABLE OF okl_rcsv_rec
23 INDEX BY BINARY_INTEGER;
24 TYPE okl_rcsb_rec IS RECORD (
25 RESI_CATEGORY_SET_ID NUMBER,
26 RESI_CAT_NAME OKL_FE_RESI_CAT_ALL_B.RESI_CAT_NAME%TYPE,
27 OBJECT_VERSION_NUMBER NUMBER,
28 ORIG_RESI_CAT_SET_ID NUMBER,
29 ORG_ID NUMBER,
30 SOURCE_CODE OKL_FE_RESI_CAT_ALL_B.SOURCE_CODE%TYPE,
31 STS_CODE OKL_FE_RESI_CAT_ALL_B.STS_CODE%TYPE,
32 CREATED_BY NUMBER ,
33 CREATION_DATE OKL_FE_RESI_CAT_ALL_B.CREATION_DATE%TYPE ,
34 LAST_UPDATED_BY NUMBER ,
35 LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_B.LAST_UPDATE_DATE%TYPE ,
36 LAST_UPDATE_LOGIN NUMBER );
37
38 TYPE okl_rcsb_tbl IS TABLE OF okl_rcsb_rec
39 INDEX BY BINARY_INTEGER;
40 TYPE okl_rcstl_rec IS RECORD (
41 RESI_CATEGORY_SET_ID NUMBER := OKL_API.G_MISS_NUM ,
42 LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,
43 SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44 SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45 CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46 CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48 LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
49 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
50 RESI_CAT_DESC OKL_FE_RESI_CAT_ALL_TL.RESI_CAT_DESC%TYPE := OKL_API.G_MISS_CHAR );
51
52 TYPE okl_rcstl_tbl IS TABLE OF okl_rcstl_rec
53 INDEX BY BINARY_INTEGER;
54
55 --------------------------------------------------------------------------------
56 -- GLOBAL MESSAGE CONSTANTS
57 --------------------------------------------------------------------------------
58 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
59 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
60 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
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 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
67 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
68 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
69 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
70 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
71 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
72 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
73 G_API_VERSION CONSTANT NUMBER := 1;
74 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
75 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
76 --------------------------------------------------------------------------------
77 -- GLOBAL CONSTANTS
78 --------------------------------------------------------------------------------
79 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RCS_PVT';
80 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
81 G_CAT_ITEM CONSTANT VARCHAR2(30) := 'ITEM';
82 G_CAT_ITEM_CAT CONSTANT VARCHAR2(30) := 'ITEMCAT';
83 G_STS_ACTIVE CONSTANT VARCHAR2(30) := 'ACTIVE';
84 G_STS_INACTIVE CONSTANT VARCHAR2(30) := 'INACTIVE';
85
86 --------------------------------------------------------------------------------
87 -- Procedures and Functions
88 --------------------------------------------------------------------------------
89 PROCEDURE change_version;
90 PROCEDURE api_copy;
91
92 PROCEDURE add_language;
93
94 PROCEDURE insert_row(
95 p_api_version IN NUMBER ,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_rcsv_rec IN okl_rcsv_rec,
101 x_rcsv_rec OUT NOCOPY okl_rcsv_rec);
102 PROCEDURE insert_row(
103 p_api_version IN NUMBER ,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_rcsv_tbl IN okl_rcsv_tbl,
109 x_rcsv_tbl OUT NOCOPY okl_rcsv_tbl);
110 PROCEDURE update_row(
111 p_api_version IN NUMBER ,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_rcsv_rec IN okl_rcsv_rec,
117 x_rcsv_rec OUT NOCOPY okl_rcsv_rec);
118 PROCEDURE update_row(
119 p_api_version IN NUMBER ,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_rcsv_tbl IN okl_rcsv_tbl,
125 x_rcsv_tbl OUT NOCOPY okl_rcsv_tbl);
126 PROCEDURE delete_row(
127 p_api_version IN NUMBER ,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_rcsv_rec IN okl_rcsv_rec);
133 PROCEDURE delete_row(
134 p_api_version IN NUMBER ,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_rcsv_tbl IN okl_rcsv_tbl);
140 END OKL_RCS_PVT;