DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKL_API

Line 22: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

18:
19: ------------------------------------------------------------------------------
20: -- Global Variables
21: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_REPORT_PVT';
22: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26:

Line 43: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

39: PROCEDURE ADD_LANGUAGE;
40:
41: PROCEDURE create_report(
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_repv_rec IN repv_rec_type,

Line 53: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

49: );
50:
51: PROCEDURE update_report(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_repv_rec IN repv_rec_type,

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

59: );
60:
61: PROCEDURE delete_report(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_repv_rec IN repv_rec_type

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

68: );
69:
70: PROCEDURE submit_report(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_rep_id IN NUMBER

Line 81: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

77: );
78:
79: PROCEDURE activate_report(
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_rep_id IN NUMBER

Line 91: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

87:
88:
89: PROCEDURE lock_report(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_repv_rec IN repv_rec_type

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

96: );
97:
98: PROCEDURE create_report(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_repv_tbl IN repv_tbl_type,

Line 110: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

106: );
107:
108: PROCEDURE update_report(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_repv_tbl IN repv_tbl_type,

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

116: );
117:
118: PROCEDURE delete_report(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_repv_tbl IN repv_tbl_type

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

125: );
126:
127: PROCEDURE lock_report(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_repv_tbl IN repv_tbl_type

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

134: );
135:
136: PROCEDURE create_report_parameters(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_rpp_rec IN rpp_rec_type,

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

144: );
145:
146: PROCEDURE update_report_parameters(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_rpp_rec IN rpp_rec_type,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

154: );
155:
156: PROCEDURE delete_report_parameters(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_rpp_rec IN rpp_rec_type

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

163: );
164:
165: PROCEDURE lock_report_parameters(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_rpp_rec IN rpp_rec_type

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

172: );
173:
174: PROCEDURE create_report_parameters(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_rpp_tbl IN rpp_tbl_type,

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

182: );
183:
184: PROCEDURE update_report_parameters(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_rpp_tbl IN rpp_tbl_type,

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

192: );
193:
194: PROCEDURE delete_report_parameters(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rpp_tbl IN rpp_tbl_type

Line 205: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

201: );
202:
203: PROCEDURE lock_report_parameters(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_rpp_tbl IN rpp_tbl_type

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

210: );
211:
212: PROCEDURE create_report_acc_parameters(
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_rap_rec IN rap_rec_type,

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

220: );
221:
222: PROCEDURE update_report_acc_parameters(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_rap_rec IN rap_rec_type,

Line 234: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

230: );
231:
232: PROCEDURE delete_report_acc_parameters(
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_rap_rec IN rap_rec_type

Line 243: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

239: );
240:
241: PROCEDURE lock_report_acc_parameters(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_rap_rec IN rap_rec_type

Line 252: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

248: );
249:
250: PROCEDURE create_report_acc_parameters(
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
256: p_rap_tbl IN rap_tbl_type,

Line 262: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

258: );
259:
260: PROCEDURE update_report_acc_parameters(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_rap_tbl IN rap_tbl_type,

Line 272: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

268: );
269:
270: PROCEDURE delete_report_acc_parameters(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_rap_tbl IN rap_tbl_type

Line 281: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

277: );
278:
279: PROCEDURE lock_report_acc_parameters(
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: p_rap_tbl IN rap_tbl_type

Line 290: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

286: );
287:
288: PROCEDURE create_report_strm_parameters(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,
293: x_msg_data OUT NOCOPY VARCHAR2,
294: p_rps_rec IN rps_rec_type,

Line 300: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

296: );
297:
298: PROCEDURE update_report_strm_parameters(
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2,
304: p_rps_rec IN rps_rec_type,

Line 310: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

306: );
307:
308: PROCEDURE delete_report_strm_parameters(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_rps_rec IN rps_rec_type

Line 319: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

315: );
316:
317: PROCEDURE lock_report_strm_parameters(
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_rps_rec IN rps_rec_type

Line 328: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

324: );
325:
326: PROCEDURE create_report_strm_parameters(
327: p_api_version IN NUMBER,
328: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
331: x_msg_data OUT NOCOPY VARCHAR2,
332: p_rps_tbl IN rps_tbl_type,

Line 338: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

334: );
335:
336: PROCEDURE update_report_strm_parameters(
337: p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: p_rps_tbl IN rps_tbl_type,

Line 348: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

344: );
345:
346: PROCEDURE delete_report_strm_parameters(
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
352: p_rps_tbl IN rps_tbl_type

Line 357: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

353: );
354:
355: PROCEDURE lock_report_strm_parameters(
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,
360: x_msg_data OUT NOCOPY VARCHAR2,
361: p_rps_tbl IN rps_tbl_type

Line 366: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

362: );
363:
364: PROCEDURE create_report_trx_parameters(
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
367: x_return_status OUT NOCOPY VARCHAR2,
368: x_msg_count OUT NOCOPY NUMBER,
369: x_msg_data OUT NOCOPY VARCHAR2,
370: p_rtp_rec IN rtp_rec_type,

Line 376: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

372: );
373:
374: PROCEDURE update_report_trx_parameters(
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2,
380: p_rtp_rec IN rtp_rec_type,

Line 386: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

382: );
383:
384: PROCEDURE delete_report_trx_parameters(
385: p_api_version IN NUMBER,
386: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,
389: x_msg_data OUT NOCOPY VARCHAR2,
390: p_rtp_rec IN rtp_rec_type

Line 395: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

391: );
392:
393: PROCEDURE lock_report_trx_parameters(
394: p_api_version IN NUMBER,
395: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
396: x_return_status OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
398: x_msg_data OUT NOCOPY VARCHAR2,
399: p_rtp_rec IN rtp_rec_type

Line 404: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

400: );
401:
402: PROCEDURE create_report_trx_parameters(
403: p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: p_rtp_tbl IN rtp_tbl_type,

Line 414: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

410: );
411:
412: PROCEDURE update_report_trx_parameters(
413: p_api_version IN NUMBER,
414: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
415: x_return_status OUT NOCOPY VARCHAR2,
416: x_msg_count OUT NOCOPY NUMBER,
417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_rtp_tbl IN rtp_tbl_type,

Line 424: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

420: );
421:
422: PROCEDURE delete_report_trx_parameters(
423: p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_rtp_tbl IN rtp_tbl_type

Line 433: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

429: );
430:
431: PROCEDURE lock_report_trx_parameters(
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
434: x_return_status OUT NOCOPY VARCHAR2,
435: x_msg_count OUT NOCOPY NUMBER,
436: x_msg_data OUT NOCOPY VARCHAR2,
437: p_rtp_tbl IN rtp_tbl_type

Line 442: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

438: );
439:
440: PROCEDURE create_report(
441: p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
443: x_return_status OUT NOCOPY VARCHAR2,
444: x_msg_count OUT NOCOPY NUMBER,
445: x_msg_data OUT NOCOPY VARCHAR2,
446: p_repv_rec IN repv_rec_type,

Line 460: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

456: );
457:
458: PROCEDURE update_report(
459: p_api_version IN NUMBER,
460: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
461: x_return_status OUT NOCOPY VARCHAR2,
462: x_msg_count OUT NOCOPY NUMBER,
463: x_msg_data OUT NOCOPY VARCHAR2,
464: p_repv_rec IN repv_rec_type,