[Home] [Help]
PACKAGE: APPS.OKC_CGP_PVT
Source
1 Package OKC_CGP_PVT AS
2 /* $Header: OKCSCGPS.pls 120.0 2005/05/25 23:06:50 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cgp_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
9 object_version_number NUMBER := OKC_API.G_MISS_NUM,
10 created_by NUMBER := OKC_API.G_MISS_NUM,
11 creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13 last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14 user_id NUMBER := OKC_API.G_MISS_NUM,
15 last_update_login NUMBER := OKC_API.G_MISS_NUM,
16 attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17 attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18 attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19 attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20 attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21 attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22 attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23 attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24 attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25 attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26 attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27 attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28 attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29 attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30 attribute14 OKC_K_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31 attribute15 OKC_K_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32 g_miss_cgp_rec cgp_rec_type;
33 TYPE cgp_tbl_type IS TABLE OF cgp_rec_type
34 INDEX BY BINARY_INTEGER;
35 TYPE OkcContractGroupsTlRecType IS RECORD (
36 id NUMBER := OKC_API.G_MISS_NUM,
37 language OKC_K_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
38 source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39 sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40 name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41 short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42 created_by NUMBER := OKC_API.G_MISS_NUM,
43 creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45 last_update_date OKC_K_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46 last_update_login NUMBER := OKC_API.G_MISS_NUM);
47 GMissOkcContractGroupsTlRec OkcContractGroupsTlRecType;
48 TYPE OkcContractGroupsTlTblType IS TABLE OF OkcContractGroupsTlRecType
49 INDEX BY BINARY_INTEGER;
50 TYPE cgpv_rec_type IS RECORD (
51 id NUMBER := OKC_API.G_MISS_NUM,
52 object_version_number NUMBER := OKC_API.G_MISS_NUM,
53 sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54 name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55 public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56 short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57 attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58 attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59 attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60 attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61 attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62 attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63 attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64 attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65 attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66 attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67 attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68 attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69 attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70 attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71 attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72 attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73 created_by NUMBER := OKC_API.G_MISS_NUM,
74 creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76 last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77 user_id NUMBER := OKC_API.G_MISS_NUM,
78 last_update_login NUMBER := OKC_API.G_MISS_NUM);
79 g_miss_cgpv_rec cgpv_rec_type;
80 TYPE cgpv_tbl_type IS TABLE OF cgpv_rec_type
81 INDEX BY BINARY_INTEGER;
82 --
83 -- TYPE id_tbl IS TABLE OF okc_k_groups_v.id%TYPE INDEX BY BINARY_INTEGER;
84 -- TYPE public_yn_tbl IS TABLE OF okc_k_groups_v.public_yn%TYPE INDEX BY BINARY_INTEGER;
85 -- TYPE name_tbl IS TABLE OF okc_k_groups_v.name%TYPE INDEX BY BINARY_INTEGER;
86
87 TYPE id_tbl IS TABLE OF number INDEX BY BINARY_INTEGER;
88 TYPE public_yn_tbl IS TABLE OF varchar2(3) INDEX BY BINARY_INTEGER;
89 TYPE name_tbl IS TABLE OF varchar2(150) INDEX BY BINARY_INTEGER;
90
91 ---------------------------------------------------------------------------
92 -- GLOBAL MESSAGE CONSTANTS
93 ---------------------------------------------------------------------------
94 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
95 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
96 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
102 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
103 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
104 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
105 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
106 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
107 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
108 ---------------------------------------------------------------------------
109 -- GLOBAL EXCEPTIONS
110 ---------------------------------------------------------------------------
111 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
112 ---------------------------------------------------------------------------
113 -- GLOBAL VARIABLES
114 ---------------------------------------------------------------------------
115 G_VIEW_NAME CONSTANT VARCHAR2(200) := 'OKC_K_GROUPS_V';
116 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CGP_PVT';
117 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
118 ---------------------------------------------------------------------------
119 -- Procedures and Functions
120 ---------------------------------------------------------------------------
121
122 PROCEDURE qc;
123 PROCEDURE change_version;
124 PROCEDURE api_copy;
125 PROCEDURE add_language;
126 PROCEDURE insert_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_cgpv_rec IN cgpv_rec_type,
133 x_cgpv_rec OUT NOCOPY cgpv_rec_type);
134
135 PROCEDURE insert_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_cgpv_tbl IN cgpv_tbl_type,
142 x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
143
144 PROCEDURE lock_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_cgpv_rec IN cgpv_rec_type);
151
152 PROCEDURE lock_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_cgpv_tbl IN cgpv_tbl_type);
159
160 PROCEDURE update_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_cgpv_rec IN cgpv_rec_type,
167 x_cgpv_rec OUT NOCOPY cgpv_rec_type);
168
169 PROCEDURE update_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_cgpv_tbl IN cgpv_tbl_type,
176 x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
177
178 PROCEDURE delete_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_cgpv_rec IN cgpv_rec_type);
185
186 PROCEDURE delete_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_cgpv_tbl IN cgpv_tbl_type);
193
194 PROCEDURE validate_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_cgpv_rec IN cgpv_rec_type);
201
202 PROCEDURE validate_row(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_cgpv_tbl IN cgpv_tbl_type);
209
210 PROCEDURE Validate_Name(x_return_status OUT NOCOPY VARCHAR2,
211 p_cgpv_rec IN cgpv_rec_type);
212 PROCEDURE Validate_Public_YN(x_return_status OUT NOCOPY VARCHAR2,
213 p_cgpv_rec IN cgpv_rec_type);
214 PROCEDURE Validate_Short_Description(x_return_status OUT NOCOPY VARCHAR2,
215 p_cgpv_rec IN cgpv_rec_type);
216 FUNCTION Validate_Record(p_cgpv_rec IN cgpv_rec_type)
217 RETURN VARCHAR2;
218
219 PROCEDURE Build_Groups_Tbl(x_id_tbl OUT NOCOPY id_tbl,
220 x_public_yn_tbl OUT NOCOPY public_yn_tbl,
221 x_name_tbl OUT NOCOPY name_tbl,
222 x_return_status OUT NOCOPY Varchar2);
223
224 PROCEDURE Populate_Groups_Temp_Tbl(p_cgp_parent_id_tbl IN id_tbl,
225 p_included_cgp_id_tbl IN id_tbl,
226 p_included_public_yn_tbl IN public_yn_tbl,
227 p_included_name_tbl IN name_tbl,
228 x_return_status OUT NOCOPY Varchar2);
229 END OKC_CGP_PVT;