[Home] [Help]
PACKAGE: APPS.OKC_AAE_PVT
Source
1 Package OKC_AAE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSAAES.pls 120.0 2005/05/26 09:55:20 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE aae_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 aal_id NUMBER := OKC_API.G_MISS_NUM,
9 acn_id NUMBER := OKC_API.G_MISS_NUM,
10 element_name OKC_ACTION_ATTRIBUTES_B.ELEMENT_NAME%TYPE := OKC_API.G_MISS_CHAR,
11 data_type OKC_ACTION_ATTRIBUTES_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12 list_yn OKC_ACTION_ATTRIBUTES_B.LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
13 visible_yn OKC_ACTION_ATTRIBUTES_B.VISIBLE_YN%TYPE := OKC_API.G_MISS_CHAR,
14 date_of_interest_yn OKC_ACTION_ATTRIBUTES_B.DATE_OF_INTEREST_YN%TYPE := OKC_API.G_MISS_CHAR,
15 object_version_number NUMBER := OKC_API.G_MISS_NUM,
16 created_by NUMBER := OKC_API.G_MISS_NUM,
17 creation_date OKC_ACTION_ATTRIBUTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19 last_update_date OKC_ACTION_ATTRIBUTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20 format_mask OKC_ACTION_ATTRIBUTES_B.FORMAT_MASK%TYPE := OKC_API.G_MISS_CHAR,
21 minimum_value OKC_ACTION_ATTRIBUTES_B.MINIMUM_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22 maximum_value OKC_ACTION_ATTRIBUTES_B.MAXIMUM_VALUE%TYPE := OKC_API.G_MISS_CHAR,
23 JTOT_OBJECT_CODE OKC_ACTION_ATTRIBUTES_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
24 NAME_COLUMN OKC_ACTION_ATTRIBUTES_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
25 DESCRIPTION_COLUMN OKC_ACTION_ATTRIBUTES_B.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
26 source_doc_number_yn OKC_ACTION_ATTRIBUTES_B.source_doc_number_yn%TYPE := OKC_API.G_MISS_CHAR,
27 last_update_login NUMBER := OKC_API.G_MISS_NUM,
28 application_id NUMBER := OKC_API.G_MISS_NUM,
29 seeded_flag OKC_ACTION_ATTRIBUTES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
30 attribute_category OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31 attribute1 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32 attribute2 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33 attribute3 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34 attribute4 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35 attribute5 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36 attribute6 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37 attribute7 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38 attribute8 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39 attribute9 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40 attribute10 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41 attribute11 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42 attribute12 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43 attribute13 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44 attribute14 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48 INDEX BY BINARY_INTEGER;
45 attribute15 OKC_ACTION_ATTRIBUTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
46 g_miss_aae_rec aae_rec_type;
47 TYPE aae_tbl_type IS TABLE OF aae_rec_type
49 TYPE OkcActionAttributesTlRecType IS RECORD (
50 id NUMBER := OKC_API.G_MISS_NUM,
51 language OKC_ACTION_ATTRIBUTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
52 source_lang OKC_ACTION_ATTRIBUTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
53 sfwt_flag OKC_ACTION_ATTRIBUTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54 name OKC_ACTION_ATTRIBUTES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
55 description OKC_ACTION_ATTRIBUTES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
56 created_by NUMBER := OKC_API.G_MISS_NUM,
57 creation_date OKC_ACTION_ATTRIBUTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
58 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
59 last_update_date OKC_ACTION_ATTRIBUTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
60 last_update_login NUMBER := OKC_API.G_MISS_NUM);
61 GMissOkcActionAttributesTlRec OkcActionAttributesTlRecType;
62 TYPE OkcActionAttributesTlTblType IS TABLE OF OkcActionAttributesTlRecType
63 INDEX BY BINARY_INTEGER;
64 TYPE aaev_rec_type IS RECORD (
65 id NUMBER := OKC_API.G_MISS_NUM,
66 aal_id NUMBER := OKC_API.G_MISS_NUM,
67 object_version_number NUMBER := OKC_API.G_MISS_NUM,
68 sfwt_flag OKC_ACTION_ATTRIBUTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
69 acn_id NUMBER := OKC_API.G_MISS_NUM,
70 element_name OKC_ACTION_ATTRIBUTES_V.ELEMENT_NAME%TYPE := OKC_API.G_MISS_CHAR,
71 name OKC_ACTION_ATTRIBUTES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
72 description OKC_ACTION_ATTRIBUTES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73 data_type OKC_ACTION_ATTRIBUTES_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
74 list_yn OKC_ACTION_ATTRIBUTES_V.LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
75 visible_yn OKC_ACTION_ATTRIBUTES_V.VISIBLE_YN%TYPE := OKC_API.G_MISS_CHAR,
76 date_of_interest_yn OKC_ACTION_ATTRIBUTES_V.DATE_OF_INTEREST_YN%TYPE := OKC_API.G_MISS_CHAR,
77 format_mask OKC_ACTION_ATTRIBUTES_V.FORMAT_MASK%TYPE := OKC_API.G_MISS_CHAR,
78 minimum_value OKC_ACTION_ATTRIBUTES_V.MINIMUM_VALUE%TYPE := OKC_API.G_MISS_CHAR,
79 maximum_value OKC_ACTION_ATTRIBUTES_V.MAXIMUM_VALUE%TYPE := OKC_API.G_MISS_CHAR,
80 JTOT_OBJECT_CODE OKC_ACTION_ATTRIBUTES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
81 NAME_COLUMN OKC_ACTION_ATTRIBUTES_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
82 DESCRIPTION_COLUMN OKC_ACTION_ATTRIBUTES_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
83 source_doc_number_yn OKC_ACTION_ATTRIBUTES_V.source_doc_number_yn%TYPE := OKC_API.G_MISS_CHAR,
84 application_id NUMBER := OKC_API.G_MISS_NUM,
85 seeded_flag OKC_ACTION_ATTRIBUTES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
86 attribute_category OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
87 attribute1 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
88 attribute2 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
89 attribute3 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
90 attribute4 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
91 attribute5 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
92 attribute6 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
93 attribute7 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
94 attribute8 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
95 attribute9 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
96 attribute10 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
97 attribute11 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
98 attribute12 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
99 attribute13 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
100 attribute14 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
101 attribute15 OKC_ACTION_ATTRIBUTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
102 created_by NUMBER := OKC_API.G_MISS_NUM,
103 creation_date OKC_ACTION_ATTRIBUTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
104 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
105 last_update_date OKC_ACTION_ATTRIBUTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
106 last_update_login NUMBER := OKC_API.G_MISS_NUM);
107 g_miss_aaev_rec aaev_rec_type;
108 TYPE aaev_tbl_type IS TABLE OF aaev_rec_type
109 INDEX BY BINARY_INTEGER;
110 ---------------------------------------------------------------------------
111 -- GLOBAL MESSAGE CONSTANTS
112 ---------------------------------------------------------------------------
113 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
114 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
115 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
116 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
118 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
119 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
121 G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
122 G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';
123 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
125 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
126 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLerrm';
127 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLcode';
128 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
129 --G_UNQS CONSTANT VARCHAR2(200) := 'OKC_VALUES_NOT_UNIQUE';
130 G_UNQS CONSTANT VARCHAR2(200) := 'OKC_ACN_ELEMENT_NOT_UNIQUE';
131 G_ONE_DOI CONSTANT VARCHAR2(200) := 'OKC_ONE_DOI';
132 ---------------------------------------------------------------------------
133 -- GLOBAL EXCEPTION
134 ---------------------------------------------------------------------------
135 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
136 ---------------------------------------------------------------------------
137 -- GLOBAL VARIABLES
138 ---------------------------------------------------------------------------
139 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AAE_PVT';
140 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
141 ---------------------------------------------------------------------------
142 -- Procedures and Functions
143 ---------------------------------------------------------------------------
144
145 PROCEDURE qc;
146 PROCEDURE change_version;
147 PROCEDURE api_copy;
148 PROCEDURE add_language;
149 PROCEDURE insert_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_aaev_rec IN aaev_rec_type,
156 x_aaev_rec OUT NOCOPY aaev_rec_type);
157
158 PROCEDURE insert_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_aaev_tbl IN aaev_tbl_type,
165 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
166
167 PROCEDURE lock_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_aaev_rec IN aaev_rec_type);
174
175 PROCEDURE lock_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_aaev_tbl IN aaev_tbl_type);
182
183 PROCEDURE update_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_aaev_rec IN aaev_rec_type,
190 x_aaev_rec OUT NOCOPY aaev_rec_type);
191
192 PROCEDURE update_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_aaev_tbl IN aaev_tbl_type,
199 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
200
201 PROCEDURE delete_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_aaev_rec IN aaev_rec_type);
208
209 PROCEDURE delete_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_aaev_tbl IN aaev_tbl_type);
216
217 PROCEDURE validate_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_aaev_rec IN aaev_rec_type);
224
225 PROCEDURE validate_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_aaev_tbl IN aaev_tbl_type);
232
233 END OKC_AAE_PVT;