DBA Data[Home] [Help]

APPS.OKL_BPD_CAP_ADV_MON_PVT_W dependencies on FND_API

Line 11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;

7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:

Line 12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;

8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as

Line 17: a number := fnd_api.g_miss_num;

13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;

Line 50: , p5_a0 VARCHAR2 := fnd_api.g_miss_char

46: , p6_a16 out nocopy NUMBER
47: , p6_a17 out nocopy VARCHAR2
48: , p6_a18 out nocopy VARCHAR2
49: , p6_a19 out nocopy VARCHAR2
50: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a2 DATE := fnd_api.g_miss_date
53: , p5_a3 NUMBER := 0-1962.0724
54: , p5_a4 NUMBER := 0-1962.0724

Line 51: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

47: , p6_a17 out nocopy VARCHAR2
48: , p6_a18 out nocopy VARCHAR2
49: , p6_a19 out nocopy VARCHAR2
50: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a2 DATE := fnd_api.g_miss_date
53: , p5_a3 NUMBER := 0-1962.0724
54: , p5_a4 NUMBER := 0-1962.0724
55: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 52: , p5_a2 DATE := fnd_api.g_miss_date

48: , p6_a18 out nocopy VARCHAR2
49: , p6_a19 out nocopy VARCHAR2
50: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a2 DATE := fnd_api.g_miss_date
53: , p5_a3 NUMBER := 0-1962.0724
54: , p5_a4 NUMBER := 0-1962.0724
55: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a6 NUMBER := 0-1962.0724

Line 55: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

51: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a2 DATE := fnd_api.g_miss_date
53: , p5_a3 NUMBER := 0-1962.0724
54: , p5_a4 NUMBER := 0-1962.0724
55: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a6 NUMBER := 0-1962.0724
57: , p5_a7 NUMBER := 0-1962.0724
58: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a9 NUMBER := 0-1962.0724

Line 58: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

54: , p5_a4 NUMBER := 0-1962.0724
55: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a6 NUMBER := 0-1962.0724
57: , p5_a7 NUMBER := 0-1962.0724
58: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a9 NUMBER := 0-1962.0724
60: , p5_a10 NUMBER := 0-1962.0724
61: , p5_a11 DATE := fnd_api.g_miss_date
62: , p5_a12 DATE := fnd_api.g_miss_date

Line 61: , p5_a11 DATE := fnd_api.g_miss_date

57: , p5_a7 NUMBER := 0-1962.0724
58: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a9 NUMBER := 0-1962.0724
60: , p5_a10 NUMBER := 0-1962.0724
61: , p5_a11 DATE := fnd_api.g_miss_date
62: , p5_a12 DATE := fnd_api.g_miss_date
63: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a14 NUMBER := 0-1962.0724
65: , p5_a15 NUMBER := 0-1962.0724

Line 62: , p5_a12 DATE := fnd_api.g_miss_date

58: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a9 NUMBER := 0-1962.0724
60: , p5_a10 NUMBER := 0-1962.0724
61: , p5_a11 DATE := fnd_api.g_miss_date
62: , p5_a12 DATE := fnd_api.g_miss_date
63: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a14 NUMBER := 0-1962.0724
65: , p5_a15 NUMBER := 0-1962.0724
66: , p5_a16 NUMBER := 0-1962.0724

Line 63: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

59: , p5_a9 NUMBER := 0-1962.0724
60: , p5_a10 NUMBER := 0-1962.0724
61: , p5_a11 DATE := fnd_api.g_miss_date
62: , p5_a12 DATE := fnd_api.g_miss_date
63: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a14 NUMBER := 0-1962.0724
65: , p5_a15 NUMBER := 0-1962.0724
66: , p5_a16 NUMBER := 0-1962.0724
67: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 67: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

63: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a14 NUMBER := 0-1962.0724
65: , p5_a15 NUMBER := 0-1962.0724
66: , p5_a16 NUMBER := 0-1962.0724
67: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
70: )
71:

Line 68: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

64: , p5_a14 NUMBER := 0-1962.0724
65: , p5_a15 NUMBER := 0-1962.0724
66: , p5_a16 NUMBER := 0-1962.0724
67: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
70: )
71:
72: as

Line 69: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

65: , p5_a15 NUMBER := 0-1962.0724
66: , p5_a16 NUMBER := 0-1962.0724
67: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
70: )
71:
72: as
73: ddp_adv_rcpt_rec okl_bpd_cap_adv_mon_pvt.adv_rcpt_rec;