APPS.AMS_IBA_PL_STYLESHEETS_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_tbl_type, a0 JTF_NUMBER_TABLE

Line 151: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

147: , x_msg_count OUT NOCOPY NUMBER
148: , x_msg_data OUT NOCOPY VARCHAR2
149: , x_stylesheet_id OUT NOCOPY NUMBER
150: , p7_a0 NUMBER := 0-1962.0724
151: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a4 NUMBER := 0-1962.0724
155: , p7_a5 DATE := fnd_api.g_miss_date

Line 152: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

148: , x_msg_data OUT NOCOPY VARCHAR2
149: , x_stylesheet_id OUT NOCOPY NUMBER
150: , p7_a0 NUMBER := 0-1962.0724
151: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a4 NUMBER := 0-1962.0724
155: , p7_a5 DATE := fnd_api.g_miss_date
156: , p7_a6 NUMBER := 0-1962.0724

Line 153: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

149: , x_stylesheet_id OUT NOCOPY NUMBER
150: , p7_a0 NUMBER := 0-1962.0724
151: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a4 NUMBER := 0-1962.0724
155: , p7_a5 DATE := fnd_api.g_miss_date
156: , p7_a6 NUMBER := 0-1962.0724
157: , p7_a7 DATE := fnd_api.g_miss_date

Line 155: , p7_a5 DATE := fnd_api.g_miss_date

151: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a4 NUMBER := 0-1962.0724
155: , p7_a5 DATE := fnd_api.g_miss_date
156: , p7_a6 NUMBER := 0-1962.0724
157: , p7_a7 DATE := fnd_api.g_miss_date
158: , p7_a8 NUMBER := 0-1962.0724
159: , p7_a9 NUMBER := 0-1962.0724

Line 157: , p7_a7 DATE := fnd_api.g_miss_date

153: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a4 NUMBER := 0-1962.0724
155: , p7_a5 DATE := fnd_api.g_miss_date
156: , p7_a6 NUMBER := 0-1962.0724
157: , p7_a7 DATE := fnd_api.g_miss_date
158: , p7_a8 NUMBER := 0-1962.0724
159: , p7_a9 NUMBER := 0-1962.0724
160: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 160: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

156: , p7_a6 NUMBER := 0-1962.0724
157: , p7_a7 DATE := fnd_api.g_miss_date
158: , p7_a8 NUMBER := 0-1962.0724
159: , p7_a9 NUMBER := 0-1962.0724
160: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
162: )
163: as
164: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;

Line 161: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

157: , p7_a7 DATE := fnd_api.g_miss_date
158: , p7_a8 NUMBER := 0-1962.0724
159: , p7_a9 NUMBER := 0-1962.0724
160: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
162: )
163: as
164: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;
165: ddindx binary_integer; indx binary_integer;

Line 221: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

217: , x_msg_count OUT NOCOPY NUMBER
218: , x_msg_data OUT NOCOPY VARCHAR2
219: , x_object_version_number OUT NOCOPY NUMBER
220: , p7_a0 NUMBER := 0-1962.0724
221: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a4 NUMBER := 0-1962.0724
225: , p7_a5 DATE := fnd_api.g_miss_date

Line 222: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

218: , x_msg_data OUT NOCOPY VARCHAR2
219: , x_object_version_number OUT NOCOPY NUMBER
220: , p7_a0 NUMBER := 0-1962.0724
221: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a4 NUMBER := 0-1962.0724
225: , p7_a5 DATE := fnd_api.g_miss_date
226: , p7_a6 NUMBER := 0-1962.0724

Line 223: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

219: , x_object_version_number OUT NOCOPY NUMBER
220: , p7_a0 NUMBER := 0-1962.0724
221: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a4 NUMBER := 0-1962.0724
225: , p7_a5 DATE := fnd_api.g_miss_date
226: , p7_a6 NUMBER := 0-1962.0724
227: , p7_a7 DATE := fnd_api.g_miss_date

Line 225: , p7_a5 DATE := fnd_api.g_miss_date

221: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a4 NUMBER := 0-1962.0724
225: , p7_a5 DATE := fnd_api.g_miss_date
226: , p7_a6 NUMBER := 0-1962.0724
227: , p7_a7 DATE := fnd_api.g_miss_date
228: , p7_a8 NUMBER := 0-1962.0724
229: , p7_a9 NUMBER := 0-1962.0724

Line 227: , p7_a7 DATE := fnd_api.g_miss_date

223: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a4 NUMBER := 0-1962.0724
225: , p7_a5 DATE := fnd_api.g_miss_date
226: , p7_a6 NUMBER := 0-1962.0724
227: , p7_a7 DATE := fnd_api.g_miss_date
228: , p7_a8 NUMBER := 0-1962.0724
229: , p7_a9 NUMBER := 0-1962.0724
230: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 230: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

226: , p7_a6 NUMBER := 0-1962.0724
227: , p7_a7 DATE := fnd_api.g_miss_date
228: , p7_a8 NUMBER := 0-1962.0724
229: , p7_a9 NUMBER := 0-1962.0724
230: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
232: )
233: as
234: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;

Line 231: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

227: , p7_a7 DATE := fnd_api.g_miss_date
228: , p7_a8 NUMBER := 0-1962.0724
229: , p7_a9 NUMBER := 0-1962.0724
230: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
232: )
233: as
234: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;
235: ddindx binary_integer; indx binary_integer;

Line 290: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

286: , x_msg_count OUT NOCOPY NUMBER
287: , x_msg_data OUT NOCOPY VARCHAR2
288: , p_validation_mode VARCHAR2
289: , p3_a0 NUMBER := 0-1962.0724
290: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
291: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
292: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a4 NUMBER := 0-1962.0724
294: , p3_a5 DATE := fnd_api.g_miss_date

Line 291: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

287: , x_msg_data OUT NOCOPY VARCHAR2
288: , p_validation_mode VARCHAR2
289: , p3_a0 NUMBER := 0-1962.0724
290: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
291: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
292: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a4 NUMBER := 0-1962.0724
294: , p3_a5 DATE := fnd_api.g_miss_date
295: , p3_a6 NUMBER := 0-1962.0724

Line 292: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

288: , p_validation_mode VARCHAR2
289: , p3_a0 NUMBER := 0-1962.0724
290: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
291: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
292: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a4 NUMBER := 0-1962.0724
294: , p3_a5 DATE := fnd_api.g_miss_date
295: , p3_a6 NUMBER := 0-1962.0724
296: , p3_a7 DATE := fnd_api.g_miss_date

Line 294: , p3_a5 DATE := fnd_api.g_miss_date

290: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
291: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
292: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a4 NUMBER := 0-1962.0724
294: , p3_a5 DATE := fnd_api.g_miss_date
295: , p3_a6 NUMBER := 0-1962.0724
296: , p3_a7 DATE := fnd_api.g_miss_date
297: , p3_a8 NUMBER := 0-1962.0724
298: , p3_a9 NUMBER := 0-1962.0724

Line 296: , p3_a7 DATE := fnd_api.g_miss_date

292: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a4 NUMBER := 0-1962.0724
294: , p3_a5 DATE := fnd_api.g_miss_date
295: , p3_a6 NUMBER := 0-1962.0724
296: , p3_a7 DATE := fnd_api.g_miss_date
297: , p3_a8 NUMBER := 0-1962.0724
298: , p3_a9 NUMBER := 0-1962.0724
299: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
300: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

Line 299: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

295: , p3_a6 NUMBER := 0-1962.0724
296: , p3_a7 DATE := fnd_api.g_miss_date
297: , p3_a8 NUMBER := 0-1962.0724
298: , p3_a9 NUMBER := 0-1962.0724
299: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
300: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
301: )
302: as
303: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;

Line 300: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

296: , p3_a7 DATE := fnd_api.g_miss_date
297: , p3_a8 NUMBER := 0-1962.0724
298: , p3_a9 NUMBER := 0-1962.0724
299: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
300: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
301: )
302: as
303: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;
304: ddindx binary_integer; indx binary_integer;

Line 351: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

347:
348: procedure check_iba_pl_style_items(p_validation_mode VARCHAR2
349: , x_return_status OUT NOCOPY VARCHAR2
350: , p0_a0 NUMBER := 0-1962.0724
351: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a4 NUMBER := 0-1962.0724
355: , p0_a5 DATE := fnd_api.g_miss_date

Line 352: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

348: procedure check_iba_pl_style_items(p_validation_mode VARCHAR2
349: , x_return_status OUT NOCOPY VARCHAR2
350: , p0_a0 NUMBER := 0-1962.0724
351: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a4 NUMBER := 0-1962.0724
355: , p0_a5 DATE := fnd_api.g_miss_date
356: , p0_a6 NUMBER := 0-1962.0724

Line 353: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

349: , x_return_status OUT NOCOPY VARCHAR2
350: , p0_a0 NUMBER := 0-1962.0724
351: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a4 NUMBER := 0-1962.0724
355: , p0_a5 DATE := fnd_api.g_miss_date
356: , p0_a6 NUMBER := 0-1962.0724
357: , p0_a7 DATE := fnd_api.g_miss_date

Line 355: , p0_a5 DATE := fnd_api.g_miss_date

351: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a4 NUMBER := 0-1962.0724
355: , p0_a5 DATE := fnd_api.g_miss_date
356: , p0_a6 NUMBER := 0-1962.0724
357: , p0_a7 DATE := fnd_api.g_miss_date
358: , p0_a8 NUMBER := 0-1962.0724
359: , p0_a9 NUMBER := 0-1962.0724

Line 357: , p0_a7 DATE := fnd_api.g_miss_date

353: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a4 NUMBER := 0-1962.0724
355: , p0_a5 DATE := fnd_api.g_miss_date
356: , p0_a6 NUMBER := 0-1962.0724
357: , p0_a7 DATE := fnd_api.g_miss_date
358: , p0_a8 NUMBER := 0-1962.0724
359: , p0_a9 NUMBER := 0-1962.0724
360: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 360: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

356: , p0_a6 NUMBER := 0-1962.0724
357: , p0_a7 DATE := fnd_api.g_miss_date
358: , p0_a8 NUMBER := 0-1962.0724
359: , p0_a9 NUMBER := 0-1962.0724
360: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
362: )
363: as
364: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;

Line 361: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

357: , p0_a7 DATE := fnd_api.g_miss_date
358: , p0_a8 NUMBER := 0-1962.0724
359: , p0_a9 NUMBER := 0-1962.0724
360: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
362: )
363: as
364: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;
365: ddindx binary_integer; indx binary_integer;

Line 400: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

396: , x_return_status OUT NOCOPY VARCHAR2
397: , x_msg_count OUT NOCOPY NUMBER
398: , x_msg_data OUT NOCOPY VARCHAR2
399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 DATE := fnd_api.g_miss_date

Line 401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

397: , x_msg_count OUT NOCOPY NUMBER
398: , x_msg_data OUT NOCOPY VARCHAR2
399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 DATE := fnd_api.g_miss_date
405: , p5_a6 NUMBER := 0-1962.0724

Line 402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

398: , x_msg_data OUT NOCOPY VARCHAR2
399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 DATE := fnd_api.g_miss_date
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 DATE := fnd_api.g_miss_date

Line 404: , p5_a5 DATE := fnd_api.g_miss_date

400: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 DATE := fnd_api.g_miss_date
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 DATE := fnd_api.g_miss_date
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 NUMBER := 0-1962.0724

Line 406: , p5_a7 DATE := fnd_api.g_miss_date

402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 DATE := fnd_api.g_miss_date
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 DATE := fnd_api.g_miss_date
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 NUMBER := 0-1962.0724
409: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 409: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 DATE := fnd_api.g_miss_date
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 NUMBER := 0-1962.0724
409: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
411: )
412: as
413: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;

Line 410: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

406: , p5_a7 DATE := fnd_api.g_miss_date
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 NUMBER := 0-1962.0724
409: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
411: )
412: as
413: ddp_iba_pl_stylesheets_rec ams_iba_pl_stylesheets_pvt.iba_pl_stylesheets_rec_type;
414: ddindx binary_integer; indx binary_integer;