[Home] [Help]
PACKAGE: APPS.OKL_ESD_PVT
Source
1 PACKAGE Okl_Esd_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSESDS.pls 115.2 2002/02/05 12:16:17 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE esd_rec_type IS RECORD (
7 id NUMBER := Okl_api.G_MISS_NUM,
8 xls_id NUMBER := Okl_api.G_MISS_NUM,
9 ild_id NUMBER := Okl_api.G_MISS_NUM,
10 account_class OKL_XTD_SELL_INVS_B.ACCOUNT_CLASS%TYPE := Okl_api.G_MISS_CHAR,
11 code_combination_id NUMBER := Okl_api.G_MISS_NUM,
12 object_version_number NUMBER := Okl_api.G_MISS_NUM,
13 amount NUMBER := Okl_api.G_MISS_NUM,
14 percent NUMBER := Okl_api.G_MISS_NUM,
15 request_id NUMBER := Okl_api.G_MISS_NUM,
16 program_application_id NUMBER := Okl_api.G_MISS_NUM,
17 program_id NUMBER := Okl_api.G_MISS_NUM,
18 program_update_date OKL_XTD_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
19 org_id NUMBER := Okl_api.G_MISS_NUM,
20 attribute_category OKL_XTD_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
21 attribute1 OKL_XTD_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
22 attribute2 OKL_XTD_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
23 attribute3 OKL_XTD_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
24 attribute4 OKL_XTD_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
25 attribute5 OKL_XTD_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
26 attribute6 OKL_XTD_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
27 attribute7 OKL_XTD_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
28 attribute8 OKL_XTD_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
29 attribute9 OKL_XTD_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
30 attribute10 OKL_XTD_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
31 attribute11 OKL_XTD_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
32 attribute12 OKL_XTD_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
33 attribute13 OKL_XTD_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
34 attribute14 OKL_XTD_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
35 attribute15 OKL_XTD_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
36 created_by NUMBER := Okl_api.G_MISS_NUM,
37 creation_date OKL_XTD_SELL_INVS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
38 last_updated_by NUMBER := Okl_api.G_MISS_NUM,
39 last_update_date OKL_XTD_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
40 last_update_login NUMBER := Okl_api.G_MISS_NUM);
41 g_miss_esd_rec esd_rec_type;
42 TYPE esd_tbl_type IS TABLE OF esd_rec_type
43 INDEX BY BINARY_INTEGER;
44 TYPE okl_xtd_sell_invs_tl_rec_type IS RECORD (
45 id NUMBER := Okl_api.G_MISS_NUM,
46 LANGUAGE OKL_XTD_SELL_INVS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
47 source_lang OKL_XTD_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
48 sfwt_flag OKL_XTD_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
49 created_by NUMBER := Okl_api.G_MISS_NUM,
50 creation_date OKL_XTD_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
51 last_updated_by NUMBER := Okl_api.G_MISS_NUM,
52 last_update_date OKL_XTD_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
53 last_update_login NUMBER := Okl_api.G_MISS_NUM);
54 GMissOklXtdSellInvsTlRec okl_xtd_sell_invs_tl_rec_type;
55 TYPE okl_xtd_sell_invs_tl_tbl_type IS TABLE OF okl_xtd_sell_invs_tl_rec_type
56 INDEX BY BINARY_INTEGER;
57 TYPE esdv_rec_type IS RECORD (
58 id NUMBER := Okl_api.G_MISS_NUM,
59 object_version_number NUMBER := Okl_api.G_MISS_NUM,
60 sfwt_flag OKL_XTD_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
61 xls_id NUMBER := Okl_api.G_MISS_NUM,
62 ild_id NUMBER := Okl_api.G_MISS_NUM,
63 account_class OKL_XTD_SELL_INVS_V.ACCOUNT_CLASS%TYPE := Okl_api.G_MISS_CHAR,
64 code_combination_id NUMBER := Okl_api.G_MISS_NUM,
65 amount NUMBER := Okl_api.G_MISS_NUM,
66 percent NUMBER := Okl_api.G_MISS_NUM,
67 attribute_category OKL_XTD_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
68 attribute1 OKL_XTD_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
69 attribute2 OKL_XTD_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
70 attribute3 OKL_XTD_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
71 attribute4 OKL_XTD_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
72 attribute5 OKL_XTD_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
73 attribute6 OKL_XTD_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
74 attribute7 OKL_XTD_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
75 attribute8 OKL_XTD_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
76 attribute9 OKL_XTD_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
77 attribute10 OKL_XTD_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
78 attribute11 OKL_XTD_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
79 attribute12 OKL_XTD_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
80 attribute13 OKL_XTD_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
81 attribute14 OKL_XTD_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
82 attribute15 OKL_XTD_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
83 request_id NUMBER := Okl_api.G_MISS_NUM,
84 program_application_id NUMBER := Okl_api.G_MISS_NUM,
85 program_id NUMBER := Okl_api.G_MISS_NUM,
86 program_update_date OKL_XTD_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
87 org_id NUMBER := Okl_api.G_MISS_NUM,
88 created_by NUMBER := Okl_api.G_MISS_NUM,
89 creation_date OKL_XTD_SELL_INVS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
90 last_updated_by NUMBER := Okl_api.G_MISS_NUM,
91 last_update_date OKL_XTD_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
92 last_update_login NUMBER := Okl_api.G_MISS_NUM);
93 g_miss_esdv_rec esdv_rec_type;
94 TYPE esdv_tbl_type IS TABLE OF esdv_rec_type
95 INDEX BY BINARY_INTEGER;
96 ---------------------------------------------------------------------------
97 -- GLOBAL MESSAGE CONSTANTS
98 ---------------------------------------------------------------------------
99 G_FND_APP CONSTANT VARCHAR2(200) := Okl_api.G_FND_APP;
100 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
101 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
102 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
103 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
104 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
105 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
106 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
107 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
108 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_CHILD_TABLE_TOKEN;
109 ---------------------------------------------------------------------------
110 -- GLOBAL VARIABLES
111 ---------------------------------------------------------------------------
112 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ESD_PVT';
113 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
114
115 /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
116 --GLOBAL MESSAGES
117 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
118 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
119 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
120 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
121 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
122
123
124 --GLOBAL VARIABLES
125 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTD_SELL_INVS_V';
126 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
127
128 ---------------------------------------------------------------------------
129 -- validation Procedures and Functions
130 ---------------------------------------------------------------------------
131 --PROCEDURE validate_unique(p_saiv_rec IN saiv_rec_type,
132 -- x_return_status OUT NOCOPY VARCHAR2);
133
134 /****************END ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001)**************/
135
136 ---------------------------------------------------------------------------
137 -- Procedures and Functions
138 ---------------------------------------------------------------------------
139
140 PROCEDURE qc;
141 PROCEDURE change_version;
142 PROCEDURE api_copy;
143 PROCEDURE add_language;
144 PROCEDURE insert_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_esdv_rec IN esdv_rec_type,
151 x_esdv_rec OUT NOCOPY esdv_rec_type);
152
153 PROCEDURE insert_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_esdv_tbl IN esdv_tbl_type,
160 x_esdv_tbl OUT NOCOPY esdv_tbl_type);
161
162 PROCEDURE lock_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_esdv_rec IN esdv_rec_type);
169
170 PROCEDURE lock_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_esdv_tbl IN esdv_tbl_type);
177
178 PROCEDURE update_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_esdv_rec IN esdv_rec_type,
185 x_esdv_rec OUT NOCOPY esdv_rec_type);
186
187 PROCEDURE update_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_esdv_tbl IN esdv_tbl_type,
194 x_esdv_tbl OUT NOCOPY esdv_tbl_type);
195
196 PROCEDURE delete_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_esdv_rec IN esdv_rec_type);
203
204 PROCEDURE delete_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_esdv_tbl IN esdv_tbl_type);
211
212 PROCEDURE validate_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_esdv_rec IN esdv_rec_type);
219
220 PROCEDURE validate_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_esdv_tbl IN esdv_tbl_type);
227
228 END Okl_Esd_Pvt;