APPS.PV_ASSIGN_UTIL_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_p4(t out nocopy pv_assign_util_pvt.resource_details_tbl_type, a0 JTF_VARCHAR2_TABLE_100

Line 124: , p4_a1 DATE := fnd_api.g_miss_date

120: , p_init_msg_list VARCHAR2
121: , p_commit VARCHAR2
122: , p_validation_level NUMBER
123: , p4_a0 NUMBER := 0-1962.0724
124: , p4_a1 DATE := fnd_api.g_miss_date
125: , p4_a2 NUMBER := 0-1962.0724
126: , p4_a3 DATE := fnd_api.g_miss_date
127: , p4_a4 NUMBER := 0-1962.0724
128: , p4_a5 NUMBER := 0-1962.0724

Line 126: , p4_a3 DATE := fnd_api.g_miss_date

122: , p_validation_level NUMBER
123: , p4_a0 NUMBER := 0-1962.0724
124: , p4_a1 DATE := fnd_api.g_miss_date
125: , p4_a2 NUMBER := 0-1962.0724
126: , p4_a3 DATE := fnd_api.g_miss_date
127: , p4_a4 NUMBER := 0-1962.0724
128: , p4_a5 NUMBER := 0-1962.0724
129: , p4_a6 NUMBER := 0-1962.0724
130: , p4_a7 NUMBER := 0-1962.0724

Line 133: , p4_a10 DATE := fnd_api.g_miss_date

129: , p4_a6 NUMBER := 0-1962.0724
130: , p4_a7 NUMBER := 0-1962.0724
131: , p4_a8 NUMBER := 0-1962.0724
132: , p4_a9 NUMBER := 0-1962.0724
133: , p4_a10 DATE := fnd_api.g_miss_date
134: , p4_a11 NUMBER := 0-1962.0724
135: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
136: , p4_a13 NUMBER := 0-1962.0724
137: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

Line 135: , p4_a12 VARCHAR2 := fnd_api.g_miss_char

131: , p4_a8 NUMBER := 0-1962.0724
132: , p4_a9 NUMBER := 0-1962.0724
133: , p4_a10 DATE := fnd_api.g_miss_date
134: , p4_a11 NUMBER := 0-1962.0724
135: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
136: , p4_a13 NUMBER := 0-1962.0724
137: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
138: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p4_a16 NUMBER := 0-1962.0724

Line 137: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

133: , p4_a10 DATE := fnd_api.g_miss_date
134: , p4_a11 NUMBER := 0-1962.0724
135: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
136: , p4_a13 NUMBER := 0-1962.0724
137: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
138: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p4_a16 NUMBER := 0-1962.0724
140: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p4_a18 NUMBER := 0-1962.0724

Line 138: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

134: , p4_a11 NUMBER := 0-1962.0724
135: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
136: , p4_a13 NUMBER := 0-1962.0724
137: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
138: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p4_a16 NUMBER := 0-1962.0724
140: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p4_a18 NUMBER := 0-1962.0724
142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

Line 140: , p4_a17 VARCHAR2 := fnd_api.g_miss_char

136: , p4_a13 NUMBER := 0-1962.0724
137: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
138: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p4_a16 NUMBER := 0-1962.0724
140: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p4_a18 NUMBER := 0-1962.0724
142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
144: , p4_a21 DATE := fnd_api.g_miss_date

Line 142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

138: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p4_a16 NUMBER := 0-1962.0724
140: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p4_a18 NUMBER := 0-1962.0724
142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
144: , p4_a21 DATE := fnd_api.g_miss_date
145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char

Line 143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char

139: , p4_a16 NUMBER := 0-1962.0724
140: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p4_a18 NUMBER := 0-1962.0724
142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
144: , p4_a21 DATE := fnd_api.g_miss_date
145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char

Line 144: , p4_a21 DATE := fnd_api.g_miss_date

140: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p4_a18 NUMBER := 0-1962.0724
142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
144: , p4_a21 DATE := fnd_api.g_miss_date
145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char

Line 145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char

141: , p4_a18 NUMBER := 0-1962.0724
142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
144: , p4_a21 DATE := fnd_api.g_miss_date
145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char

Line 146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char

142: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
144: , p4_a21 DATE := fnd_api.g_miss_date
145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char

Line 147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char

143: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
144: , p4_a21 DATE := fnd_api.g_miss_date
145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char

Line 148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char

144: , p4_a21 DATE := fnd_api.g_miss_date
145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char

Line 149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char

145: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char

Line 150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char

146: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char

Line 151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char

147: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char

Line 152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char

148: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char

Line 153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char

149: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char

Line 154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char

150: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char

Line 155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char

151: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
159: , p4_a36 VARCHAR2 := fnd_api.g_miss_char

Line 156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char

152: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
159: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
160: , p4_a37 VARCHAR2 := fnd_api.g_miss_char

Line 157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char

153: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
159: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
160: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
161: , x_party_notification_id out nocopy NUMBER

Line 158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char

154: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
159: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
160: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
161: , x_party_notification_id out nocopy NUMBER
162: , x_return_status out nocopy VARCHAR2

Line 159: , p4_a36 VARCHAR2 := fnd_api.g_miss_char

155: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
159: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
160: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
161: , x_party_notification_id out nocopy NUMBER
162: , x_return_status out nocopy VARCHAR2
163: , x_msg_count out nocopy NUMBER

Line 160: , p4_a37 VARCHAR2 := fnd_api.g_miss_char

156: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
157: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
158: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
159: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
160: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
161: , x_party_notification_id out nocopy NUMBER
162: , x_return_status out nocopy VARCHAR2
163: , x_msg_count out nocopy NUMBER
164: , x_msg_data out nocopy VARCHAR2

Line 246: , p4_a1 DATE := fnd_api.g_miss_date

242: , p_init_msg_list VARCHAR2
243: , p_commit VARCHAR2
244: , p_validation_level NUMBER
245: , p4_a0 NUMBER := 0-1962.0724
246: , p4_a1 DATE := fnd_api.g_miss_date
247: , p4_a2 NUMBER := 0-1962.0724
248: , p4_a3 DATE := fnd_api.g_miss_date
249: , p4_a4 NUMBER := 0-1962.0724
250: , p4_a5 NUMBER := 0-1962.0724

Line 248: , p4_a3 DATE := fnd_api.g_miss_date

244: , p_validation_level NUMBER
245: , p4_a0 NUMBER := 0-1962.0724
246: , p4_a1 DATE := fnd_api.g_miss_date
247: , p4_a2 NUMBER := 0-1962.0724
248: , p4_a3 DATE := fnd_api.g_miss_date
249: , p4_a4 NUMBER := 0-1962.0724
250: , p4_a5 NUMBER := 0-1962.0724
251: , p4_a6 NUMBER := 0-1962.0724
252: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 252: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

248: , p4_a3 DATE := fnd_api.g_miss_date
249: , p4_a4 NUMBER := 0-1962.0724
250: , p4_a5 NUMBER := 0-1962.0724
251: , p4_a6 NUMBER := 0-1962.0724
252: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
253: , p4_a8 NUMBER := 0-1962.0724
254: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

Line 254: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

250: , p4_a5 NUMBER := 0-1962.0724
251: , p4_a6 NUMBER := 0-1962.0724
252: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
253: , p4_a8 NUMBER := 0-1962.0724
254: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date

Line 255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char

251: , p4_a6 NUMBER := 0-1962.0724
252: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
253: , p4_a8 NUMBER := 0-1962.0724
254: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date
259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

Line 256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

252: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
253: , p4_a8 NUMBER := 0-1962.0724
254: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date
259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
260: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

Line 257: , p4_a12 DATE := fnd_api.g_miss_date

253: , p4_a8 NUMBER := 0-1962.0724
254: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date
259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
260: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
261: , p4_a16 VARCHAR2 := fnd_api.g_miss_char

Line 258: , p4_a13 DATE := fnd_api.g_miss_date

254: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date
259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
260: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
261: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
262: , x_itemkey out nocopy VARCHAR2

Line 259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

255: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date
259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
260: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
261: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
262: , x_itemkey out nocopy VARCHAR2
263: , x_return_status out nocopy VARCHAR2

Line 260: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

256: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date
259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
260: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
261: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
262: , x_itemkey out nocopy VARCHAR2
263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER

Line 261: , p4_a16 VARCHAR2 := fnd_api.g_miss_char

257: , p4_a12 DATE := fnd_api.g_miss_date
258: , p4_a13 DATE := fnd_api.g_miss_date
259: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
260: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
261: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
262: , x_itemkey out nocopy VARCHAR2
263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2

Line 326: , p4_a1 DATE := fnd_api.g_miss_date

322: , p_init_msg_list VARCHAR2
323: , p_commit VARCHAR2
324: , p_validation_level NUMBER
325: , p4_a0 NUMBER := 0-1962.0724
326: , p4_a1 DATE := fnd_api.g_miss_date
327: , p4_a2 NUMBER := 0-1962.0724
328: , p4_a3 DATE := fnd_api.g_miss_date
329: , p4_a4 NUMBER := 0-1962.0724
330: , p4_a5 NUMBER := 0-1962.0724

Line 328: , p4_a3 DATE := fnd_api.g_miss_date

324: , p_validation_level NUMBER
325: , p4_a0 NUMBER := 0-1962.0724
326: , p4_a1 DATE := fnd_api.g_miss_date
327: , p4_a2 NUMBER := 0-1962.0724
328: , p4_a3 DATE := fnd_api.g_miss_date
329: , p4_a4 NUMBER := 0-1962.0724
330: , p4_a5 NUMBER := 0-1962.0724
331: , p4_a6 NUMBER := 0-1962.0724
332: , p4_a7 NUMBER := 0-1962.0724

Line 334: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

330: , p4_a5 NUMBER := 0-1962.0724
331: , p4_a6 NUMBER := 0-1962.0724
332: , p4_a7 NUMBER := 0-1962.0724
333: , p4_a8 NUMBER := 0-1962.0724
334: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a10 NUMBER := 0-1962.0724
336: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a12 NUMBER := 0-1962.0724
338: , p4_a13 DATE := fnd_api.g_miss_date

Line 336: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

332: , p4_a7 NUMBER := 0-1962.0724
333: , p4_a8 NUMBER := 0-1962.0724
334: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a10 NUMBER := 0-1962.0724
336: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a12 NUMBER := 0-1962.0724
338: , p4_a13 DATE := fnd_api.g_miss_date
339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

Line 338: , p4_a13 DATE := fnd_api.g_miss_date

334: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a10 NUMBER := 0-1962.0724
336: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a12 NUMBER := 0-1962.0724
338: , p4_a13 DATE := fnd_api.g_miss_date
339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char

Line 339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

335: , p4_a10 NUMBER := 0-1962.0724
336: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a12 NUMBER := 0-1962.0724
338: , p4_a13 DATE := fnd_api.g_miss_date
339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
343: , p4_a18 VARCHAR2 := fnd_api.g_miss_char

Line 340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

336: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
337: , p4_a12 NUMBER := 0-1962.0724
338: , p4_a13 DATE := fnd_api.g_miss_date
339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
343: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
344: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

Line 341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char

337: , p4_a12 NUMBER := 0-1962.0724
338: , p4_a13 DATE := fnd_api.g_miss_date
339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
343: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
344: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
345: , x_lead_assignment_id out nocopy NUMBER

Line 342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char

338: , p4_a13 DATE := fnd_api.g_miss_date
339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
343: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
344: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
345: , x_lead_assignment_id out nocopy NUMBER
346: , x_return_status out nocopy VARCHAR2

Line 343: , p4_a18 VARCHAR2 := fnd_api.g_miss_char

339: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
343: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
344: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
345: , x_lead_assignment_id out nocopy NUMBER
346: , x_return_status out nocopy VARCHAR2
347: , x_msg_count out nocopy NUMBER

Line 344: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

340: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
341: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
342: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
343: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
344: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
345: , x_lead_assignment_id out nocopy NUMBER
346: , x_return_status out nocopy VARCHAR2
347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2