8:
9: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
10: function rosetta_g_miss_date_in_map(d date) return date as
11: begin
12: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
13: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
14: return d;
15: end;
16:
9: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
10: function rosetta_g_miss_date_in_map(d date) return date as
11: begin
12: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
13: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
14: return d;
15: end;
16:
17:
15: end;
16:
17:
18: function rosetta_g_miss_num_map(n number) return number as
19: a number := fnd_api.g_miss_num;
20: b number := 0-1962.0724;
21: begin
22: if n=a then return b; end if;
23: if n=b then return a; end if;
174: , x_msg_data out nocopy VARCHAR2
175: , p7_a0 NUMBER := 0-1962.0724
176: , p7_a1 NUMBER := 0-1962.0724
177: , p7_a2 NUMBER := 0-1962.0724
178: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
179: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a0 NUMBER := 0-1962.0724
176: , p7_a1 NUMBER := 0-1962.0724
177: , p7_a2 NUMBER := 0-1962.0724
178: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
179: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a8 DATE := fnd_api.g_miss_date
176: , p7_a1 NUMBER := 0-1962.0724
177: , p7_a2 NUMBER := 0-1962.0724
178: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
179: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a8 DATE := fnd_api.g_miss_date
184: , p7_a9 NUMBER := 0-1962.0724
177: , p7_a2 NUMBER := 0-1962.0724
178: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
179: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a8 DATE := fnd_api.g_miss_date
184: , p7_a9 NUMBER := 0-1962.0724
185: , p7_a10 DATE := fnd_api.g_miss_date
178: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
179: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a8 DATE := fnd_api.g_miss_date
184: , p7_a9 NUMBER := 0-1962.0724
185: , p7_a10 DATE := fnd_api.g_miss_date
186: , p7_a11 NUMBER := 0-1962.0724
179: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
180: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
181: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a8 DATE := fnd_api.g_miss_date
184: , p7_a9 NUMBER := 0-1962.0724
185: , p7_a10 DATE := fnd_api.g_miss_date
186: , p7_a11 NUMBER := 0-1962.0724
187: , p7_a12 NUMBER := 0-1962.0724
181: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a8 DATE := fnd_api.g_miss_date
184: , p7_a9 NUMBER := 0-1962.0724
185: , p7_a10 DATE := fnd_api.g_miss_date
186: , p7_a11 NUMBER := 0-1962.0724
187: , p7_a12 NUMBER := 0-1962.0724
188: , p7_a13 NUMBER := 0-1962.0724
189: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
185: , p7_a10 DATE := fnd_api.g_miss_date
186: , p7_a11 NUMBER := 0-1962.0724
187: , p7_a12 NUMBER := 0-1962.0724
188: , p7_a13 NUMBER := 0-1962.0724
189: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
190: , x_offer_adj_new_product_id out nocopy NUMBER
191: )
192:
193: as
251: , x_msg_data out nocopy VARCHAR2
252: , p7_a0 NUMBER := 0-1962.0724
253: , p7_a1 NUMBER := 0-1962.0724
254: , p7_a2 NUMBER := 0-1962.0724
255: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a0 NUMBER := 0-1962.0724
253: , p7_a1 NUMBER := 0-1962.0724
254: , p7_a2 NUMBER := 0-1962.0724
255: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a8 DATE := fnd_api.g_miss_date
253: , p7_a1 NUMBER := 0-1962.0724
254: , p7_a2 NUMBER := 0-1962.0724
255: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a8 DATE := fnd_api.g_miss_date
261: , p7_a9 NUMBER := 0-1962.0724
254: , p7_a2 NUMBER := 0-1962.0724
255: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a8 DATE := fnd_api.g_miss_date
261: , p7_a9 NUMBER := 0-1962.0724
262: , p7_a10 DATE := fnd_api.g_miss_date
255: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a8 DATE := fnd_api.g_miss_date
261: , p7_a9 NUMBER := 0-1962.0724
262: , p7_a10 DATE := fnd_api.g_miss_date
263: , p7_a11 NUMBER := 0-1962.0724
256: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a8 DATE := fnd_api.g_miss_date
261: , p7_a9 NUMBER := 0-1962.0724
262: , p7_a10 DATE := fnd_api.g_miss_date
263: , p7_a11 NUMBER := 0-1962.0724
264: , p7_a12 NUMBER := 0-1962.0724
258: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a8 DATE := fnd_api.g_miss_date
261: , p7_a9 NUMBER := 0-1962.0724
262: , p7_a10 DATE := fnd_api.g_miss_date
263: , p7_a11 NUMBER := 0-1962.0724
264: , p7_a12 NUMBER := 0-1962.0724
265: , p7_a13 NUMBER := 0-1962.0724
266: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a10 DATE := fnd_api.g_miss_date
263: , p7_a11 NUMBER := 0-1962.0724
264: , p7_a12 NUMBER := 0-1962.0724
265: , p7_a13 NUMBER := 0-1962.0724
266: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
267: , x_object_version_number out nocopy NUMBER
268: )
269:
270: as
328: , x_msg_data out nocopy VARCHAR2
329: , p4_a0 NUMBER := 0-1962.0724
330: , p4_a1 NUMBER := 0-1962.0724
331: , p4_a2 NUMBER := 0-1962.0724
332: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
336: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
329: , p4_a0 NUMBER := 0-1962.0724
330: , p4_a1 NUMBER := 0-1962.0724
331: , p4_a2 NUMBER := 0-1962.0724
332: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
336: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a8 DATE := fnd_api.g_miss_date
330: , p4_a1 NUMBER := 0-1962.0724
331: , p4_a2 NUMBER := 0-1962.0724
332: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
336: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a8 DATE := fnd_api.g_miss_date
338: , p4_a9 NUMBER := 0-1962.0724
331: , p4_a2 NUMBER := 0-1962.0724
332: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
336: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a8 DATE := fnd_api.g_miss_date
338: , p4_a9 NUMBER := 0-1962.0724
339: , p4_a10 DATE := fnd_api.g_miss_date
332: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
336: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a8 DATE := fnd_api.g_miss_date
338: , p4_a9 NUMBER := 0-1962.0724
339: , p4_a10 DATE := fnd_api.g_miss_date
340: , p4_a11 NUMBER := 0-1962.0724
333: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
336: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a8 DATE := fnd_api.g_miss_date
338: , p4_a9 NUMBER := 0-1962.0724
339: , p4_a10 DATE := fnd_api.g_miss_date
340: , p4_a11 NUMBER := 0-1962.0724
341: , p4_a12 NUMBER := 0-1962.0724
335: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
336: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a8 DATE := fnd_api.g_miss_date
338: , p4_a9 NUMBER := 0-1962.0724
339: , p4_a10 DATE := fnd_api.g_miss_date
340: , p4_a11 NUMBER := 0-1962.0724
341: , p4_a12 NUMBER := 0-1962.0724
342: , p4_a13 NUMBER := 0-1962.0724
343: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
339: , p4_a10 DATE := fnd_api.g_miss_date
340: , p4_a11 NUMBER := 0-1962.0724
341: , p4_a12 NUMBER := 0-1962.0724
342: , p4_a13 NUMBER := 0-1962.0724
343: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
344: )
345:
346: as
347: ddp_adj_new_prod_rec ozf_adj_new_prod_pvt.adj_new_prod_rec_type;
396: , x_return_status out nocopy VARCHAR2
397: , p0_a0 NUMBER := 0-1962.0724
398: , p0_a1 NUMBER := 0-1962.0724
399: , p0_a2 NUMBER := 0-1962.0724
400: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
397: , p0_a0 NUMBER := 0-1962.0724
398: , p0_a1 NUMBER := 0-1962.0724
399: , p0_a2 NUMBER := 0-1962.0724
400: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a8 DATE := fnd_api.g_miss_date
398: , p0_a1 NUMBER := 0-1962.0724
399: , p0_a2 NUMBER := 0-1962.0724
400: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a8 DATE := fnd_api.g_miss_date
406: , p0_a9 NUMBER := 0-1962.0724
399: , p0_a2 NUMBER := 0-1962.0724
400: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a8 DATE := fnd_api.g_miss_date
406: , p0_a9 NUMBER := 0-1962.0724
407: , p0_a10 DATE := fnd_api.g_miss_date
400: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a8 DATE := fnd_api.g_miss_date
406: , p0_a9 NUMBER := 0-1962.0724
407: , p0_a10 DATE := fnd_api.g_miss_date
408: , p0_a11 NUMBER := 0-1962.0724
401: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a8 DATE := fnd_api.g_miss_date
406: , p0_a9 NUMBER := 0-1962.0724
407: , p0_a10 DATE := fnd_api.g_miss_date
408: , p0_a11 NUMBER := 0-1962.0724
409: , p0_a12 NUMBER := 0-1962.0724
403: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
405: , p0_a8 DATE := fnd_api.g_miss_date
406: , p0_a9 NUMBER := 0-1962.0724
407: , p0_a10 DATE := fnd_api.g_miss_date
408: , p0_a11 NUMBER := 0-1962.0724
409: , p0_a12 NUMBER := 0-1962.0724
410: , p0_a13 NUMBER := 0-1962.0724
411: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p0_a10 DATE := fnd_api.g_miss_date
408: , p0_a11 NUMBER := 0-1962.0724
409: , p0_a12 NUMBER := 0-1962.0724
410: , p0_a13 NUMBER := 0-1962.0724
411: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
412: )
413:
414: as
415: ddp_adj_new_prod_rec ozf_adj_new_prod_pvt.adj_new_prod_rec_type;
452: , x_msg_data out nocopy VARCHAR2
453: , p5_a0 NUMBER := 0-1962.0724
454: , p5_a1 NUMBER := 0-1962.0724
455: , p5_a2 NUMBER := 0-1962.0724
456: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a0 NUMBER := 0-1962.0724
454: , p5_a1 NUMBER := 0-1962.0724
455: , p5_a2 NUMBER := 0-1962.0724
456: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a8 DATE := fnd_api.g_miss_date
454: , p5_a1 NUMBER := 0-1962.0724
455: , p5_a2 NUMBER := 0-1962.0724
456: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a8 DATE := fnd_api.g_miss_date
462: , p5_a9 NUMBER := 0-1962.0724
455: , p5_a2 NUMBER := 0-1962.0724
456: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a8 DATE := fnd_api.g_miss_date
462: , p5_a9 NUMBER := 0-1962.0724
463: , p5_a10 DATE := fnd_api.g_miss_date
456: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a8 DATE := fnd_api.g_miss_date
462: , p5_a9 NUMBER := 0-1962.0724
463: , p5_a10 DATE := fnd_api.g_miss_date
464: , p5_a11 NUMBER := 0-1962.0724
457: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a8 DATE := fnd_api.g_miss_date
462: , p5_a9 NUMBER := 0-1962.0724
463: , p5_a10 DATE := fnd_api.g_miss_date
464: , p5_a11 NUMBER := 0-1962.0724
465: , p5_a12 NUMBER := 0-1962.0724
459: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a8 DATE := fnd_api.g_miss_date
462: , p5_a9 NUMBER := 0-1962.0724
463: , p5_a10 DATE := fnd_api.g_miss_date
464: , p5_a11 NUMBER := 0-1962.0724
465: , p5_a12 NUMBER := 0-1962.0724
466: , p5_a13 NUMBER := 0-1962.0724
467: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a10 DATE := fnd_api.g_miss_date
464: , p5_a11 NUMBER := 0-1962.0724
465: , p5_a12 NUMBER := 0-1962.0724
466: , p5_a13 NUMBER := 0-1962.0724
467: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
468: )
469:
470: as
471: ddp_adj_new_prod_rec ozf_adj_new_prod_pvt.adj_new_prod_rec_type;