5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
168: , x_msg_count out nocopy NUMBER
169: , x_msg_data out nocopy VARCHAR2
170: , x_metric_tpl_header_id out nocopy NUMBER
171: , p7_a0 NUMBER := 0-1962.0724
172: , p7_a1 DATE := fnd_api.g_miss_date
173: , p7_a2 NUMBER := 0-1962.0724
174: , p7_a3 DATE := fnd_api.g_miss_date
175: , p7_a4 NUMBER := 0-1962.0724
176: , p7_a5 NUMBER := 0-1962.0724
170: , x_metric_tpl_header_id out nocopy NUMBER
171: , p7_a0 NUMBER := 0-1962.0724
172: , p7_a1 DATE := fnd_api.g_miss_date
173: , p7_a2 NUMBER := 0-1962.0724
174: , p7_a3 DATE := fnd_api.g_miss_date
175: , p7_a4 NUMBER := 0-1962.0724
176: , p7_a5 NUMBER := 0-1962.0724
177: , p7_a6 NUMBER := 0-1962.0724
178: , p7_a7 NUMBER := 0-1962.0724
175: , p7_a4 NUMBER := 0-1962.0724
176: , p7_a5 NUMBER := 0-1962.0724
177: , p7_a6 NUMBER := 0-1962.0724
178: , p7_a7 NUMBER := 0-1962.0724
179: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a5 NUMBER := 0-1962.0724
177: , p7_a6 NUMBER := 0-1962.0724
178: , p7_a7 NUMBER := 0-1962.0724
179: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
177: , p7_a6 NUMBER := 0-1962.0724
178: , p7_a7 NUMBER := 0-1962.0724
179: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p7_a7 NUMBER := 0-1962.0724
179: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
186: )
179: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
186: )
187:
181: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
186: )
187:
188: as
189: ddp_metric_tpl_header_rec ams_metric_template_pvt.metric_tpl_header_rec_type;
245: , x_msg_count out nocopy NUMBER
246: , x_msg_data out nocopy VARCHAR2
247: , x_object_version_number out nocopy NUMBER
248: , p7_a0 NUMBER := 0-1962.0724
249: , p7_a1 DATE := fnd_api.g_miss_date
250: , p7_a2 NUMBER := 0-1962.0724
251: , p7_a3 DATE := fnd_api.g_miss_date
252: , p7_a4 NUMBER := 0-1962.0724
253: , p7_a5 NUMBER := 0-1962.0724
247: , x_object_version_number out nocopy NUMBER
248: , p7_a0 NUMBER := 0-1962.0724
249: , p7_a1 DATE := fnd_api.g_miss_date
250: , p7_a2 NUMBER := 0-1962.0724
251: , p7_a3 DATE := fnd_api.g_miss_date
252: , p7_a4 NUMBER := 0-1962.0724
253: , p7_a5 NUMBER := 0-1962.0724
254: , p7_a6 NUMBER := 0-1962.0724
255: , p7_a7 NUMBER := 0-1962.0724
252: , p7_a4 NUMBER := 0-1962.0724
253: , p7_a5 NUMBER := 0-1962.0724
254: , p7_a6 NUMBER := 0-1962.0724
255: , p7_a7 NUMBER := 0-1962.0724
256: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a5 NUMBER := 0-1962.0724
254: , p7_a6 NUMBER := 0-1962.0724
255: , p7_a7 NUMBER := 0-1962.0724
256: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a13 NUMBER := 0-1962.0724
254: , p7_a6 NUMBER := 0-1962.0724
255: , p7_a7 NUMBER := 0-1962.0724
256: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a13 NUMBER := 0-1962.0724
262: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a7 NUMBER := 0-1962.0724
256: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a13 NUMBER := 0-1962.0724
262: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
263: )
256: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a13 NUMBER := 0-1962.0724
262: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
263: )
264:
258: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a13 NUMBER := 0-1962.0724
262: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
263: )
264:
265: as
266: ddp_metric_tpl_header_rec ams_metric_template_pvt.metric_tpl_header_rec_type;
321: , x_return_status out nocopy VARCHAR2
322: , x_msg_count out nocopy NUMBER
323: , x_msg_data out nocopy VARCHAR2
324: , p3_a0 NUMBER := 0-1962.0724
325: , p3_a1 DATE := fnd_api.g_miss_date
326: , p3_a2 NUMBER := 0-1962.0724
327: , p3_a3 DATE := fnd_api.g_miss_date
328: , p3_a4 NUMBER := 0-1962.0724
329: , p3_a5 NUMBER := 0-1962.0724
323: , x_msg_data out nocopy VARCHAR2
324: , p3_a0 NUMBER := 0-1962.0724
325: , p3_a1 DATE := fnd_api.g_miss_date
326: , p3_a2 NUMBER := 0-1962.0724
327: , p3_a3 DATE := fnd_api.g_miss_date
328: , p3_a4 NUMBER := 0-1962.0724
329: , p3_a5 NUMBER := 0-1962.0724
330: , p3_a6 NUMBER := 0-1962.0724
331: , p3_a7 NUMBER := 0-1962.0724
328: , p3_a4 NUMBER := 0-1962.0724
329: , p3_a5 NUMBER := 0-1962.0724
330: , p3_a6 NUMBER := 0-1962.0724
331: , p3_a7 NUMBER := 0-1962.0724
332: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
335: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
336: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
329: , p3_a5 NUMBER := 0-1962.0724
330: , p3_a6 NUMBER := 0-1962.0724
331: , p3_a7 NUMBER := 0-1962.0724
332: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
335: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
336: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
337: , p3_a13 NUMBER := 0-1962.0724
330: , p3_a6 NUMBER := 0-1962.0724
331: , p3_a7 NUMBER := 0-1962.0724
332: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
335: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
336: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
337: , p3_a13 NUMBER := 0-1962.0724
338: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
331: , p3_a7 NUMBER := 0-1962.0724
332: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
335: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
336: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
337: , p3_a13 NUMBER := 0-1962.0724
338: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
339: )
332: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
335: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
336: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
337: , p3_a13 NUMBER := 0-1962.0724
338: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
339: )
340:
334: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
335: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
336: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
337: , p3_a13 NUMBER := 0-1962.0724
338: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
339: )
340:
341: as
342: ddp_metric_tpl_header_rec ams_metric_template_pvt.metric_tpl_header_rec_type;
389:
390: procedure check_met_tpl_hdr_items(p_validation_mode VARCHAR2
391: , x_return_status out nocopy VARCHAR2
392: , p0_a0 NUMBER := 0-1962.0724
393: , p0_a1 DATE := fnd_api.g_miss_date
394: , p0_a2 NUMBER := 0-1962.0724
395: , p0_a3 DATE := fnd_api.g_miss_date
396: , p0_a4 NUMBER := 0-1962.0724
397: , p0_a5 NUMBER := 0-1962.0724
391: , x_return_status out nocopy VARCHAR2
392: , p0_a0 NUMBER := 0-1962.0724
393: , p0_a1 DATE := fnd_api.g_miss_date
394: , p0_a2 NUMBER := 0-1962.0724
395: , p0_a3 DATE := fnd_api.g_miss_date
396: , p0_a4 NUMBER := 0-1962.0724
397: , p0_a5 NUMBER := 0-1962.0724
398: , p0_a6 NUMBER := 0-1962.0724
399: , p0_a7 NUMBER := 0-1962.0724
396: , p0_a4 NUMBER := 0-1962.0724
397: , p0_a5 NUMBER := 0-1962.0724
398: , p0_a6 NUMBER := 0-1962.0724
399: , p0_a7 NUMBER := 0-1962.0724
400: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
397: , p0_a5 NUMBER := 0-1962.0724
398: , p0_a6 NUMBER := 0-1962.0724
399: , p0_a7 NUMBER := 0-1962.0724
400: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a13 NUMBER := 0-1962.0724
398: , p0_a6 NUMBER := 0-1962.0724
399: , p0_a7 NUMBER := 0-1962.0724
400: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a13 NUMBER := 0-1962.0724
406: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
399: , p0_a7 NUMBER := 0-1962.0724
400: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a13 NUMBER := 0-1962.0724
406: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
407: )
400: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a13 NUMBER := 0-1962.0724
406: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
407: )
408:
402: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a13 NUMBER := 0-1962.0724
406: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
407: )
408:
409: as
410: ddp_metric_tpl_header_rec ams_metric_template_pvt.metric_tpl_header_rec_type;
445: , x_return_status out nocopy VARCHAR2
446: , x_msg_count out nocopy NUMBER
447: , x_msg_data out nocopy VARCHAR2
448: , p5_a0 NUMBER := 0-1962.0724
449: , p5_a1 DATE := fnd_api.g_miss_date
450: , p5_a2 NUMBER := 0-1962.0724
451: , p5_a3 DATE := fnd_api.g_miss_date
452: , p5_a4 NUMBER := 0-1962.0724
453: , p5_a5 NUMBER := 0-1962.0724
447: , x_msg_data out nocopy VARCHAR2
448: , p5_a0 NUMBER := 0-1962.0724
449: , p5_a1 DATE := fnd_api.g_miss_date
450: , p5_a2 NUMBER := 0-1962.0724
451: , p5_a3 DATE := fnd_api.g_miss_date
452: , p5_a4 NUMBER := 0-1962.0724
453: , p5_a5 NUMBER := 0-1962.0724
454: , p5_a6 NUMBER := 0-1962.0724
455: , p5_a7 NUMBER := 0-1962.0724
452: , p5_a4 NUMBER := 0-1962.0724
453: , p5_a5 NUMBER := 0-1962.0724
454: , p5_a6 NUMBER := 0-1962.0724
455: , p5_a7 NUMBER := 0-1962.0724
456: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a5 NUMBER := 0-1962.0724
454: , p5_a6 NUMBER := 0-1962.0724
455: , p5_a7 NUMBER := 0-1962.0724
456: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a13 NUMBER := 0-1962.0724
454: , p5_a6 NUMBER := 0-1962.0724
455: , p5_a7 NUMBER := 0-1962.0724
456: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a13 NUMBER := 0-1962.0724
462: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a7 NUMBER := 0-1962.0724
456: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a13 NUMBER := 0-1962.0724
462: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
463: )
456: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a13 NUMBER := 0-1962.0724
462: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
463: )
464:
458: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a13 NUMBER := 0-1962.0724
462: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
463: )
464:
465: as
466: ddp_metric_tpl_header_rec ams_metric_template_pvt.metric_tpl_header_rec_type;