DBA Data[Home] [Help]

APPS.AMS_CODE_DEFINITION_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_p3(t OUT NOCOPY ams_code_definition_pvt.code_def_tbl_type, a0 JTF_DATE_TABLE

Line 136: , p7_a0 DATE := fnd_api.g_miss_date

132: , x_return_status OUT NOCOPY VARCHAR2
133: , x_msg_count OUT NOCOPY NUMBER
134: , x_msg_data OUT NOCOPY VARCHAR2
135: , x_code_definition_id OUT NOCOPY NUMBER
136: , p7_a0 DATE := fnd_api.g_miss_date
137: , p7_a1 DATE := fnd_api.g_miss_date
138: , p7_a2 NUMBER := 0-1962.0724
139: , p7_a3 NUMBER := 0-1962.0724
140: , p7_a4 NUMBER := 0-1962.0724

Line 137: , p7_a1 DATE := fnd_api.g_miss_date

133: , x_msg_count OUT NOCOPY NUMBER
134: , x_msg_data OUT NOCOPY VARCHAR2
135: , x_code_definition_id OUT NOCOPY NUMBER
136: , p7_a0 DATE := fnd_api.g_miss_date
137: , p7_a1 DATE := fnd_api.g_miss_date
138: , p7_a2 NUMBER := 0-1962.0724
139: , p7_a3 NUMBER := 0-1962.0724
140: , p7_a4 NUMBER := 0-1962.0724
141: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

Line 141: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

137: , p7_a1 DATE := fnd_api.g_miss_date
138: , p7_a2 NUMBER := 0-1962.0724
139: , p7_a3 NUMBER := 0-1962.0724
140: , p7_a4 NUMBER := 0-1962.0724
141: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a8 NUMBER := 0-1962.0724
145: , p7_a9 NUMBER := 0-1962.0724

Line 142: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

138: , p7_a2 NUMBER := 0-1962.0724
139: , p7_a3 NUMBER := 0-1962.0724
140: , p7_a4 NUMBER := 0-1962.0724
141: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a8 NUMBER := 0-1962.0724
145: , p7_a9 NUMBER := 0-1962.0724
146: )

Line 143: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

139: , p7_a3 NUMBER := 0-1962.0724
140: , p7_a4 NUMBER := 0-1962.0724
141: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a8 NUMBER := 0-1962.0724
145: , p7_a9 NUMBER := 0-1962.0724
146: )
147: as

Line 202: , p7_a0 DATE := fnd_api.g_miss_date

198: , x_return_status OUT NOCOPY VARCHAR2
199: , x_msg_count OUT NOCOPY NUMBER
200: , x_msg_data OUT NOCOPY VARCHAR2
201: , x_object_version_number OUT NOCOPY NUMBER
202: , p7_a0 DATE := fnd_api.g_miss_date
203: , p7_a1 DATE := fnd_api.g_miss_date
204: , p7_a2 NUMBER := 0-1962.0724
205: , p7_a3 NUMBER := 0-1962.0724
206: , p7_a4 NUMBER := 0-1962.0724

Line 203: , p7_a1 DATE := fnd_api.g_miss_date

199: , x_msg_count OUT NOCOPY NUMBER
200: , x_msg_data OUT NOCOPY VARCHAR2
201: , x_object_version_number OUT NOCOPY NUMBER
202: , p7_a0 DATE := fnd_api.g_miss_date
203: , p7_a1 DATE := fnd_api.g_miss_date
204: , p7_a2 NUMBER := 0-1962.0724
205: , p7_a3 NUMBER := 0-1962.0724
206: , p7_a4 NUMBER := 0-1962.0724
207: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

Line 207: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

203: , p7_a1 DATE := fnd_api.g_miss_date
204: , p7_a2 NUMBER := 0-1962.0724
205: , p7_a3 NUMBER := 0-1962.0724
206: , p7_a4 NUMBER := 0-1962.0724
207: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a8 NUMBER := 0-1962.0724
211: , p7_a9 NUMBER := 0-1962.0724

Line 208: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

204: , p7_a2 NUMBER := 0-1962.0724
205: , p7_a3 NUMBER := 0-1962.0724
206: , p7_a4 NUMBER := 0-1962.0724
207: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a8 NUMBER := 0-1962.0724
211: , p7_a9 NUMBER := 0-1962.0724
212: )

Line 209: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

205: , p7_a3 NUMBER := 0-1962.0724
206: , p7_a4 NUMBER := 0-1962.0724
207: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a8 NUMBER := 0-1962.0724
211: , p7_a9 NUMBER := 0-1962.0724
212: )
213: as

Line 267: , p3_a0 DATE := fnd_api.g_miss_date

263: , p_validation_mode VARCHAR2
264: , x_return_status OUT NOCOPY VARCHAR2
265: , x_msg_count OUT NOCOPY NUMBER
266: , x_msg_data OUT NOCOPY VARCHAR2
267: , p3_a0 DATE := fnd_api.g_miss_date
268: , p3_a1 DATE := fnd_api.g_miss_date
269: , p3_a2 NUMBER := 0-1962.0724
270: , p3_a3 NUMBER := 0-1962.0724
271: , p3_a4 NUMBER := 0-1962.0724

Line 268: , p3_a1 DATE := fnd_api.g_miss_date

264: , x_return_status OUT NOCOPY VARCHAR2
265: , x_msg_count OUT NOCOPY NUMBER
266: , x_msg_data OUT NOCOPY VARCHAR2
267: , p3_a0 DATE := fnd_api.g_miss_date
268: , p3_a1 DATE := fnd_api.g_miss_date
269: , p3_a2 NUMBER := 0-1962.0724
270: , p3_a3 NUMBER := 0-1962.0724
271: , p3_a4 NUMBER := 0-1962.0724
272: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

Line 272: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

268: , p3_a1 DATE := fnd_api.g_miss_date
269: , p3_a2 NUMBER := 0-1962.0724
270: , p3_a3 NUMBER := 0-1962.0724
271: , p3_a4 NUMBER := 0-1962.0724
272: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
273: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
274: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
275: , p3_a8 NUMBER := 0-1962.0724
276: , p3_a9 NUMBER := 0-1962.0724

Line 273: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

269: , p3_a2 NUMBER := 0-1962.0724
270: , p3_a3 NUMBER := 0-1962.0724
271: , p3_a4 NUMBER := 0-1962.0724
272: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
273: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
274: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
275: , p3_a8 NUMBER := 0-1962.0724
276: , p3_a9 NUMBER := 0-1962.0724
277: )

Line 274: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

270: , p3_a3 NUMBER := 0-1962.0724
271: , p3_a4 NUMBER := 0-1962.0724
272: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
273: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
274: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
275: , p3_a8 NUMBER := 0-1962.0724
276: , p3_a9 NUMBER := 0-1962.0724
277: )
278: as

Line 324: , p0_a0 DATE := fnd_api.g_miss_date

320: end;
321:
322: procedure check_code_def_items(p_validation_mode VARCHAR2
323: , x_return_status OUT NOCOPY VARCHAR2
324: , p0_a0 DATE := fnd_api.g_miss_date
325: , p0_a1 DATE := fnd_api.g_miss_date
326: , p0_a2 NUMBER := 0-1962.0724
327: , p0_a3 NUMBER := 0-1962.0724
328: , p0_a4 NUMBER := 0-1962.0724

Line 325: , p0_a1 DATE := fnd_api.g_miss_date

321:
322: procedure check_code_def_items(p_validation_mode VARCHAR2
323: , x_return_status OUT NOCOPY VARCHAR2
324: , p0_a0 DATE := fnd_api.g_miss_date
325: , p0_a1 DATE := fnd_api.g_miss_date
326: , p0_a2 NUMBER := 0-1962.0724
327: , p0_a3 NUMBER := 0-1962.0724
328: , p0_a4 NUMBER := 0-1962.0724
329: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

Line 329: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

325: , p0_a1 DATE := fnd_api.g_miss_date
326: , p0_a2 NUMBER := 0-1962.0724
327: , p0_a3 NUMBER := 0-1962.0724
328: , p0_a4 NUMBER := 0-1962.0724
329: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
330: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
331: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
332: , p0_a8 NUMBER := 0-1962.0724
333: , p0_a9 NUMBER := 0-1962.0724

Line 330: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

326: , p0_a2 NUMBER := 0-1962.0724
327: , p0_a3 NUMBER := 0-1962.0724
328: , p0_a4 NUMBER := 0-1962.0724
329: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
330: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
331: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
332: , p0_a8 NUMBER := 0-1962.0724
333: , p0_a9 NUMBER := 0-1962.0724
334: )

Line 331: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

327: , p0_a3 NUMBER := 0-1962.0724
328: , p0_a4 NUMBER := 0-1962.0724
329: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
330: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
331: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
332: , p0_a8 NUMBER := 0-1962.0724
333: , p0_a9 NUMBER := 0-1962.0724
334: )
335: as

Line 369: , p5_a0 DATE := fnd_api.g_miss_date

365: , p_init_msg_list VARCHAR2
366: , x_return_status OUT NOCOPY VARCHAR2
367: , x_msg_count OUT NOCOPY NUMBER
368: , x_msg_data OUT NOCOPY VARCHAR2
369: , p5_a0 DATE := fnd_api.g_miss_date
370: , p5_a1 DATE := fnd_api.g_miss_date
371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 NUMBER := 0-1962.0724
373: , p5_a4 NUMBER := 0-1962.0724

Line 370: , p5_a1 DATE := fnd_api.g_miss_date

366: , x_return_status OUT NOCOPY VARCHAR2
367: , x_msg_count OUT NOCOPY NUMBER
368: , x_msg_data OUT NOCOPY VARCHAR2
369: , p5_a0 DATE := fnd_api.g_miss_date
370: , p5_a1 DATE := fnd_api.g_miss_date
371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 NUMBER := 0-1962.0724
373: , p5_a4 NUMBER := 0-1962.0724
374: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 374: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

370: , p5_a1 DATE := fnd_api.g_miss_date
371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 NUMBER := 0-1962.0724
373: , p5_a4 NUMBER := 0-1962.0724
374: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a8 NUMBER := 0-1962.0724
378: , p5_a9 NUMBER := 0-1962.0724

Line 375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 NUMBER := 0-1962.0724
373: , p5_a4 NUMBER := 0-1962.0724
374: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a8 NUMBER := 0-1962.0724
378: , p5_a9 NUMBER := 0-1962.0724
379: )

Line 376: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

372: , p5_a3 NUMBER := 0-1962.0724
373: , p5_a4 NUMBER := 0-1962.0724
374: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a8 NUMBER := 0-1962.0724
378: , p5_a9 NUMBER := 0-1962.0724
379: )
380: as