eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PXL_PVT dependencies on OKL_API

Line 128: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

124: INDEX BY BINARY_INTEGER;
125: ---------------------------------------------------------------------------
126: -- GLOBAL MESSAGE CONSTANTS
127: ---------------------------------------------------------------------------
128: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
129: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 129: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

125: ---------------------------------------------------------------------------
126: -- GLOBAL MESSAGE CONSTANTS
127: ---------------------------------------------------------------------------
128: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
129: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

126: -- GLOBAL MESSAGE CONSTANTS
127: ---------------------------------------------------------------------------
128: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
129: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

127: ---------------------------------------------------------------------------
128: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
129: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

128: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
129: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
136: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

129: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
136: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
137: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

130: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
136: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
137: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
138: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

131: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
136: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
137: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
138: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
139: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 136: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

132: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
136: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
137: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
138: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
139: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
140: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 137: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

133: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
136: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
137: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
138: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
139: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
140: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
141:

Line 151: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

147: ---------------------------------------------------------------------------
148: -- GLOBAL VARIABLES
149: ---------------------------------------------------------------------------
150: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PXL_PVT';
151: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
152: ---------------------------------------------------------------------------
153: -- Procedures and Functions
154: ---------------------------------------------------------------------------
155:

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

158: PROCEDURE api_copy;
159: PROCEDURE add_language;
160: PROCEDURE insert_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_pxlv_rec IN pxlv_rec_type,

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

166: p_pxlv_rec IN pxlv_rec_type,
167: x_pxlv_rec OUT NOCOPY pxlv_rec_type);
168: PROCEDURE insert_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_pxlv_tbl IN pxlv_tbl_type,

Line 176: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_pxlv_tbl IN pxlv_tbl_type,
175: x_pxlv_tbl OUT NOCOPY pxlv_tbl_type,
176: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
177: PROCEDURE insert_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

175: x_pxlv_tbl OUT NOCOPY pxlv_tbl_type,
176: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
177: PROCEDURE insert_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_pxlv_tbl IN pxlv_tbl_type,

Line 187: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

183: p_pxlv_tbl IN pxlv_tbl_type,
184: x_pxlv_tbl OUT NOCOPY pxlv_tbl_type);
185: PROCEDURE lock_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_pxlv_rec IN pxlv_rec_type);

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_pxlv_rec IN pxlv_rec_type);
192: PROCEDURE lock_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_pxlv_tbl IN pxlv_tbl_type,

Line 199: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_pxlv_tbl IN pxlv_tbl_type,
199: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
200: PROCEDURE lock_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

198: p_pxlv_tbl IN pxlv_tbl_type,
199: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
200: PROCEDURE lock_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_pxlv_tbl IN pxlv_tbl_type);

Line 209: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_pxlv_tbl IN pxlv_tbl_type);
207: PROCEDURE update_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_pxlv_rec IN pxlv_rec_type,

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

213: p_pxlv_rec IN pxlv_rec_type,
214: x_pxlv_rec OUT NOCOPY pxlv_rec_type);
215: PROCEDURE update_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_pxlv_tbl IN pxlv_tbl_type,

Line 223: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_pxlv_tbl IN pxlv_tbl_type,
222: x_pxlv_tbl OUT NOCOPY pxlv_tbl_type,
223: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
224: PROCEDURE update_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

222: x_pxlv_tbl OUT NOCOPY pxlv_tbl_type,
223: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
224: PROCEDURE update_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_pxlv_tbl IN pxlv_tbl_type,

Line 234: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

230: p_pxlv_tbl IN pxlv_tbl_type,
231: x_pxlv_tbl OUT NOCOPY pxlv_tbl_type);
232: PROCEDURE delete_row(
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,
238: p_pxlv_rec IN pxlv_rec_type);

Line 241: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

237: x_msg_data OUT NOCOPY VARCHAR2,
238: p_pxlv_rec IN pxlv_rec_type);
239: PROCEDURE delete_row(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_pxlv_tbl IN pxlv_tbl_type,

Line 246: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_pxlv_tbl IN pxlv_tbl_type,
246: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
247: PROCEDURE delete_row(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,

Line 249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

245: p_pxlv_tbl IN pxlv_tbl_type,
246: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
247: PROCEDURE delete_row(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_pxlv_tbl IN pxlv_tbl_type);

Line 256: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_pxlv_tbl IN pxlv_tbl_type);
254: PROCEDURE validate_row(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2,
260: p_pxlv_rec IN pxlv_rec_type);

Line 263: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

259: x_msg_data OUT NOCOPY VARCHAR2,
260: p_pxlv_rec IN pxlv_rec_type);
261: PROCEDURE validate_row(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_pxlv_tbl IN pxlv_tbl_type,

Line 268: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_pxlv_tbl IN pxlv_tbl_type,
268: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
269: PROCEDURE validate_row(
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
272: x_return_status OUT NOCOPY VARCHAR2,

Line 271: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

267: p_pxlv_tbl IN pxlv_tbl_type,
268: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
269: PROCEDURE validate_row(
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_pxlv_tbl IN pxlv_tbl_type);

Line 279: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

275: p_pxlv_tbl IN pxlv_tbl_type);
276: -- Added for Bug# 6268782 : PRASJAIN
277: PROCEDURE insert_row(
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_pxl_rec IN pxl_rec_type,