DBA Data[Home] [Help]

APPS.PVX_CHANNEL_TYPE_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 create_channel_type(p_api_version NUMBER

Line 31: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

27: , x_return_status out nocopy VARCHAR2
28: , x_msg_count out nocopy NUMBER
29: , x_msg_data out nocopy VARCHAR2
30: , p4_a0 NUMBER := 0-1962.0724
31: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p4_a4 DATE := fnd_api.g_miss_date
35: , p4_a5 NUMBER := 0-1962.0724

Line 32: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

28: , x_msg_count out nocopy NUMBER
29: , x_msg_data out nocopy VARCHAR2
30: , p4_a0 NUMBER := 0-1962.0724
31: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p4_a4 DATE := fnd_api.g_miss_date
35: , p4_a5 NUMBER := 0-1962.0724
36: , p4_a6 DATE := fnd_api.g_miss_date

Line 33: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

29: , x_msg_data out nocopy VARCHAR2
30: , p4_a0 NUMBER := 0-1962.0724
31: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p4_a4 DATE := fnd_api.g_miss_date
35: , p4_a5 NUMBER := 0-1962.0724
36: , p4_a6 DATE := fnd_api.g_miss_date
37: , p4_a7 NUMBER := 0-1962.0724

Line 34: , p4_a4 DATE := fnd_api.g_miss_date

30: , p4_a0 NUMBER := 0-1962.0724
31: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p4_a4 DATE := fnd_api.g_miss_date
35: , p4_a5 NUMBER := 0-1962.0724
36: , p4_a6 DATE := fnd_api.g_miss_date
37: , p4_a7 NUMBER := 0-1962.0724
38: , p4_a8 NUMBER := 0-1962.0724

Line 36: , p4_a6 DATE := fnd_api.g_miss_date

32: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p4_a4 DATE := fnd_api.g_miss_date
35: , p4_a5 NUMBER := 0-1962.0724
36: , p4_a6 DATE := fnd_api.g_miss_date
37: , p4_a7 NUMBER := 0-1962.0724
38: , p4_a8 NUMBER := 0-1962.0724
39: , p4_a9 NUMBER := 0-1962.0724
40: , p4_a10 NUMBER := 0-1962.0724

Line 99: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

95: , x_return_status out nocopy VARCHAR2
96: , x_msg_count out nocopy NUMBER
97: , x_msg_data out nocopy VARCHAR2
98: , p4_a0 NUMBER := 0-1962.0724
99: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
100: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
101: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
102: , p4_a4 DATE := fnd_api.g_miss_date
103: , p4_a5 NUMBER := 0-1962.0724

Line 100: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

96: , x_msg_count out nocopy NUMBER
97: , x_msg_data out nocopy VARCHAR2
98: , p4_a0 NUMBER := 0-1962.0724
99: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
100: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
101: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
102: , p4_a4 DATE := fnd_api.g_miss_date
103: , p4_a5 NUMBER := 0-1962.0724
104: , p4_a6 DATE := fnd_api.g_miss_date

Line 101: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

97: , x_msg_data out nocopy VARCHAR2
98: , p4_a0 NUMBER := 0-1962.0724
99: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
100: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
101: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
102: , p4_a4 DATE := fnd_api.g_miss_date
103: , p4_a5 NUMBER := 0-1962.0724
104: , p4_a6 DATE := fnd_api.g_miss_date
105: , p4_a7 NUMBER := 0-1962.0724

Line 102: , p4_a4 DATE := fnd_api.g_miss_date

98: , p4_a0 NUMBER := 0-1962.0724
99: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
100: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
101: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
102: , p4_a4 DATE := fnd_api.g_miss_date
103: , p4_a5 NUMBER := 0-1962.0724
104: , p4_a6 DATE := fnd_api.g_miss_date
105: , p4_a7 NUMBER := 0-1962.0724
106: , p4_a8 NUMBER := 0-1962.0724

Line 104: , p4_a6 DATE := fnd_api.g_miss_date

100: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
101: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
102: , p4_a4 DATE := fnd_api.g_miss_date
103: , p4_a5 NUMBER := 0-1962.0724
104: , p4_a6 DATE := fnd_api.g_miss_date
105: , p4_a7 NUMBER := 0-1962.0724
106: , p4_a8 NUMBER := 0-1962.0724
107: , p4_a9 NUMBER := 0-1962.0724
108: , p4_a10 NUMBER := 0-1962.0724

Line 168: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

164: , p1_a8 out nocopy NUMBER
165: , p1_a9 out nocopy NUMBER
166: , p1_a10 out nocopy NUMBER
167: , p0_a0 NUMBER := 0-1962.0724
168: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a4 DATE := fnd_api.g_miss_date
172: , p0_a5 NUMBER := 0-1962.0724

Line 169: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

165: , p1_a9 out nocopy NUMBER
166: , p1_a10 out nocopy NUMBER
167: , p0_a0 NUMBER := 0-1962.0724
168: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a4 DATE := fnd_api.g_miss_date
172: , p0_a5 NUMBER := 0-1962.0724
173: , p0_a6 DATE := fnd_api.g_miss_date

Line 170: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

166: , p1_a10 out nocopy NUMBER
167: , p0_a0 NUMBER := 0-1962.0724
168: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a4 DATE := fnd_api.g_miss_date
172: , p0_a5 NUMBER := 0-1962.0724
173: , p0_a6 DATE := fnd_api.g_miss_date
174: , p0_a7 NUMBER := 0-1962.0724

Line 171: , p0_a4 DATE := fnd_api.g_miss_date

167: , p0_a0 NUMBER := 0-1962.0724
168: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a4 DATE := fnd_api.g_miss_date
172: , p0_a5 NUMBER := 0-1962.0724
173: , p0_a6 DATE := fnd_api.g_miss_date
174: , p0_a7 NUMBER := 0-1962.0724
175: , p0_a8 NUMBER := 0-1962.0724

Line 173: , p0_a6 DATE := fnd_api.g_miss_date

169: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a4 DATE := fnd_api.g_miss_date
172: , p0_a5 NUMBER := 0-1962.0724
173: , p0_a6 DATE := fnd_api.g_miss_date
174: , p0_a7 NUMBER := 0-1962.0724
175: , p0_a8 NUMBER := 0-1962.0724
176: , p0_a9 NUMBER := 0-1962.0724
177: , p0_a10 NUMBER := 0-1962.0724