DBA Data[Home] [Help]

APPS.JTS_CONFIGURATION_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_p5(t out jts_configuration_pvt.config_rec_tbl_type, a0 JTF_NUMBER_TABLE

Line 288: , p1_a1 VARCHAR2 := fnd_api.g_miss_char

284: , x_return_status out VARCHAR2
285: , x_msg_count out NUMBER
286: , x_msg_data out VARCHAR2
287: , p1_a0 NUMBER := 0-1962.0724
288: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
289: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
290: , p1_a3 NUMBER := 0-1962.0724
291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

Line 289: , p1_a2 VARCHAR2 := fnd_api.g_miss_char

285: , x_msg_count out NUMBER
286: , x_msg_data out VARCHAR2
287: , p1_a0 NUMBER := 0-1962.0724
288: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
289: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
290: , p1_a3 NUMBER := 0-1962.0724
291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char

Line 291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char

287: , p1_a0 NUMBER := 0-1962.0724
288: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
289: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
290: , p1_a3 NUMBER := 0-1962.0724
291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

Line 292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

288: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
289: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
290: , p1_a3 NUMBER := 0-1962.0724
291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

Line 293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char

289: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
290: , p1_a3 NUMBER := 0-1962.0724
291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

Line 294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

290: , p1_a3 NUMBER := 0-1962.0724
291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

Line 295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

291: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

Line 296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

292: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

Line 297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

293: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

294: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

Line 299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

295: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

296: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

Line 301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

297: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

298: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

Line 303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

299: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char

Line 304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

300: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char

Line 305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

301: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char

Line 306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

302: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char

Line 307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char

303: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char

Line 308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char

304: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a25 DATE := fnd_api.g_miss_date

Line 309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char

305: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a25 DATE := fnd_api.g_miss_date
313: , p1_a26 NUMBER := 0-1962.0724

Line 310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char

306: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a25 DATE := fnd_api.g_miss_date
313: , p1_a26 NUMBER := 0-1962.0724
314: , p1_a27 DATE := fnd_api.g_miss_date

Line 311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char

307: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a25 DATE := fnd_api.g_miss_date
313: , p1_a26 NUMBER := 0-1962.0724
314: , p1_a27 DATE := fnd_api.g_miss_date
315: , p1_a28 NUMBER := 0-1962.0724

Line 312: , p1_a25 DATE := fnd_api.g_miss_date

308: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a25 DATE := fnd_api.g_miss_date
313: , p1_a26 NUMBER := 0-1962.0724
314: , p1_a27 DATE := fnd_api.g_miss_date
315: , p1_a28 NUMBER := 0-1962.0724
316: , p1_a29 NUMBER := 0-1962.0724

Line 314: , p1_a27 DATE := fnd_api.g_miss_date

310: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
311: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a25 DATE := fnd_api.g_miss_date
313: , p1_a26 NUMBER := 0-1962.0724
314: , p1_a27 DATE := fnd_api.g_miss_date
315: , p1_a28 NUMBER := 0-1962.0724
316: , p1_a29 NUMBER := 0-1962.0724
317: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a31 VARCHAR2 := fnd_api.g_miss_char

Line 317: , p1_a30 VARCHAR2 := fnd_api.g_miss_char

313: , p1_a26 NUMBER := 0-1962.0724
314: , p1_a27 DATE := fnd_api.g_miss_date
315: , p1_a28 NUMBER := 0-1962.0724
316: , p1_a29 NUMBER := 0-1962.0724
317: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
319: )
320:
321: as

Line 318: , p1_a31 VARCHAR2 := fnd_api.g_miss_char

314: , p1_a27 DATE := fnd_api.g_miss_date
315: , p1_a28 NUMBER := 0-1962.0724
316: , p1_a29 NUMBER := 0-1962.0724
317: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
319: )
320:
321: as
322: ddp_configuration_rec jts_configuration_pvt.config_rec_type;