DBA Data[Home] [Help]

APPS.IEX_STATUS_RULE_PUB_W dependencies on FND_API

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

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

Line 14: a number := fnd_api.g_miss_num;

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;

Line 367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

363: , x_msg_count out nocopy NUMBER
364: , x_msg_data out nocopy VARCHAR2
365: , x_status_rule_id out nocopy NUMBER
366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date

Line 368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

364: , x_msg_data out nocopy VARCHAR2
365: , x_status_rule_id out nocopy NUMBER
366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724

Line 369: , p3_a3 DATE := fnd_api.g_miss_date

365: , x_status_rule_id out nocopy NUMBER
366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date

Line 370: , p3_a4 DATE := fnd_api.g_miss_date

366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date
374: , p3_a8 NUMBER := 0-1962.0724

Line 371: , p3_a5 DATE := fnd_api.g_miss_date

367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date
374: , p3_a8 NUMBER := 0-1962.0724
375: , p3_a9 NUMBER := 0-1962.0724

Line 373: , p3_a7 DATE := fnd_api.g_miss_date

369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date
374: , p3_a8 NUMBER := 0-1962.0724
375: , p3_a9 NUMBER := 0-1962.0724
376: , p3_a10 NUMBER := 0-1962.0724
377: , p3_a11 NUMBER := 0-1962.0724

Line 549: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

545: , x_return_status out nocopy VARCHAR2
546: , x_msg_count out nocopy NUMBER
547: , x_msg_data out nocopy VARCHAR2
548: , p3_a0 NUMBER := 0-1962.0724
549: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a2 NUMBER := 0-1962.0724
551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date

Line 551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

547: , x_msg_data out nocopy VARCHAR2
548: , p3_a0 NUMBER := 0-1962.0724
549: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a2 NUMBER := 0-1962.0724
551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date
554: , p3_a6 NUMBER := 0-1962.0724
555: , p3_a7 DATE := fnd_api.g_miss_date

Line 553: , p3_a5 DATE := fnd_api.g_miss_date

549: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a2 NUMBER := 0-1962.0724
551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date
554: , p3_a6 NUMBER := 0-1962.0724
555: , p3_a7 DATE := fnd_api.g_miss_date
556: , p3_a8 NUMBER := 0-1962.0724
557: , p3_a9 NUMBER := 0-1962.0724

Line 555: , p3_a7 DATE := fnd_api.g_miss_date

551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date
554: , p3_a6 NUMBER := 0-1962.0724
555: , p3_a7 DATE := fnd_api.g_miss_date
556: , p3_a8 NUMBER := 0-1962.0724
557: , p3_a9 NUMBER := 0-1962.0724
558: , p3_a10 NUMBER := 0-1962.0724
559: , p3_a11 NUMBER := 0-1962.0724