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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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