[Home] [Help]
PACKAGE: APPS.OKC_ACN_PVT
Source
1 Package OKC_ACN_PVT AS
2 /* $Header: OKCSACNS.pls 120.0 2005/05/26 09:34:26 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE acn_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 correlation OKC_ACTIONS_B.CORRELATION%TYPE := OKC_API.G_MISS_CHAR,
9 enabled_yn OKC_ACTIONS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
10 factory_enabled_yn OKC_ACTIONS_B.FACTORY_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
11 acn_type OKC_ACTIONS_B.ACN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12 counter_action_yn OKC_ACTIONS_B.COUNTER_ACTION_YN%TYPE := OKC_API.G_MISS_CHAR,
13 sync_allowed_yn OKC_ACTIONS_B.SYNC_ALLOWED_YN%TYPE := OKC_API.G_MISS_CHAR,
14 object_version_number NUMBER := OKC_API.G_MISS_NUM,
15 created_by NUMBER := OKC_API.G_MISS_NUM,
16 creation_date OKC_ACTIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18 last_update_date OKC_ACTIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19 last_update_login NUMBER := OKC_API.G_MISS_NUM,
20 attribute_category OKC_ACTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21 attribute1 OKC_ACTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22 attribute2 OKC_ACTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23 attribute3 OKC_ACTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24 attribute4 OKC_ACTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25 attribute5 OKC_ACTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26 attribute6 OKC_ACTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27 attribute7 OKC_ACTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28 attribute8 OKC_ACTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29 attribute9 OKC_ACTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30 attribute10 OKC_ACTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31 attribute11 OKC_ACTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32 attribute12 OKC_ACTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33 attribute13 OKC_ACTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34 attribute14 OKC_ACTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35 attribute15 OKC_ACTIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
36 application_id NUMBER := OKC_API.G_MISS_NUM,
37 seeded_flag OKC_ACTIONS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
38 g_miss_acn_rec acn_rec_type;
39 TYPE acn_tbl_type IS TABLE OF acn_rec_type
40 INDEX BY BINARY_INTEGER;
41 TYPE okc_actions_tl_rec_type IS RECORD (
42 id NUMBER := OKC_API.G_MISS_NUM,
43 language OKC_ACTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
44 source_lang OKC_ACTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
45 sfwt_flag OKC_ACTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46 name OKC_ACTIONS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
47 description OKC_ACTIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48 short_description OKC_ACTIONS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49 comments OKC_ACTIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50 created_by NUMBER := OKC_API.G_MISS_NUM,
51 creation_date OKC_ACTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
52 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
53 last_update_date OKC_ACTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
54 last_update_login NUMBER := OKC_API.G_MISS_NUM);
55 g_miss_okc_actions_tl_rec okc_actions_tl_rec_type;
56 TYPE okc_actions_tl_tbl_type IS TABLE OF okc_actions_tl_rec_type
57 INDEX BY BINARY_INTEGER;
58 TYPE acnv_rec_type IS RECORD (
59 id NUMBER := OKC_API.G_MISS_NUM,
60 correlation OKC_ACTIONS_V.CORRELATION%TYPE := OKC_API.G_MISS_CHAR,
61 object_version_number NUMBER := OKC_API.G_MISS_NUM,
62 sfwt_flag OKC_ACTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63 name OKC_ACTIONS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
64 description OKC_ACTIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
65 short_description OKC_ACTIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
66 comments OKC_ACTIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
67 enabled_yn OKC_ACTIONS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
68 factory_enabled_yn OKC_ACTIONS_V.FACTORY_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
69 counter_action_yn OKC_ACTIONS_V.COUNTER_ACTION_YN%TYPE := OKC_API.G_MISS_CHAR,
70 acn_type OKC_ACTIONS_V.ACN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
71 sync_allowed_yn OKC_ACTIONS_V.SYNC_ALLOWED_YN%TYPE := OKC_API.G_MISS_CHAR,
72 application_id NUMBER := OKC_API.G_MISS_NUM,
73 seeded_flag OKC_ACTIONS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74 attribute_category OKC_ACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75 attribute1 OKC_ACTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76 attribute2 OKC_ACTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77 attribute3 OKC_ACTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78 attribute4 OKC_ACTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79 attribute5 OKC_ACTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80 attribute6 OKC_ACTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81 attribute7 OKC_ACTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82 attribute8 OKC_ACTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83 attribute9 OKC_ACTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84 attribute10 OKC_ACTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85 attribute11 OKC_ACTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86 attribute12 OKC_ACTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87 attribute13 OKC_ACTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88 attribute14 OKC_ACTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89 attribute15 OKC_ACTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90 created_by NUMBER := OKC_API.G_MISS_NUM,
91 creation_date OKC_ACTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93 last_update_date OKC_ACTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94 last_update_login NUMBER := OKC_API.G_MISS_NUM);
95 g_miss_acnv_rec acnv_rec_type;
96 TYPE acnv_tbl_type IS TABLE OF acnv_rec_type
97 INDEX BY BINARY_INTEGER;
98 ---------------------------------------------------------------------------
99 -- GLOBAL MESSAGE CONSTANTS
100 ---------------------------------------------------------------------------
101 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
112 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
113 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
114 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
115
116 ---------------------------------------------------------------------------
117 -- GLOBAL EXCEPTION
118 ---------------------------------------------------------------------------
119 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
120 ---------------------------------------------------------------------------
121
122 -- GLOBAL VARIABLES
123 ---------------------------------------------------------------------------
124 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ACN_PVT';
125 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
126 ---------------------------------------------------------------------------
127 -- Procedures and Functions
128 ---------------------------------------------------------------------------
129
130 PROCEDURE qc;
131 PROCEDURE change_version;
132 PROCEDURE api_copy;
133 PROCEDURE add_language;
134 PROCEDURE insert_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_acnv_rec IN acnv_rec_type,
141 x_acnv_rec OUT NOCOPY acnv_rec_type);
142
143 PROCEDURE insert_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_acnv_tbl IN acnv_tbl_type,
150 x_acnv_tbl OUT NOCOPY acnv_tbl_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_acnv_rec IN acnv_rec_type);
159
160 PROCEDURE lock_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_acnv_tbl IN acnv_tbl_type);
167
168 PROCEDURE update_row(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_acnv_rec IN acnv_rec_type,
175 x_acnv_rec OUT NOCOPY acnv_rec_type);
176
177 PROCEDURE update_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_acnv_tbl IN acnv_tbl_type,
184 x_acnv_tbl OUT NOCOPY acnv_tbl_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_acnv_rec IN acnv_rec_type);
193
194 PROCEDURE delete_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_acnv_tbl IN acnv_tbl_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_acnv_rec IN acnv_rec_type);
209
210 PROCEDURE validate_row(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_acnv_tbl IN acnv_tbl_type);
217
218 END OKC_ACN_PVT;