DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALIDATIONS_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_enty_attr_validation(p_api_version_number NUMBER

Line 31: , p7_a1 DATE := fnd_api.g_miss_date

27: , x_msg_count out nocopy NUMBER
28: , x_msg_data out nocopy VARCHAR2
29: , x_enty_attr_validation_id out nocopy NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724

Line 33: , p7_a3 DATE := fnd_api.g_miss_date

29: , x_enty_attr_validation_id out nocopy NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 DATE := fnd_api.g_miss_date

Line 37: , p7_a7 DATE := fnd_api.g_miss_date

33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 DATE := fnd_api.g_miss_date
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: )

Line 40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 DATE := fnd_api.g_miss_date
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: )
42:
43: as
44: ddp_enty_attr_validation_rec pv_enty_attr_validations_pvt.enty_attr_validation_rec_type;

Line 100: , p7_a1 DATE := fnd_api.g_miss_date

96: , x_msg_count out nocopy NUMBER
97: , x_msg_data out nocopy VARCHAR2
98: , x_object_version_number out nocopy NUMBER
99: , p7_a0 NUMBER := 0-1962.0724
100: , p7_a1 DATE := fnd_api.g_miss_date
101: , p7_a2 NUMBER := 0-1962.0724
102: , p7_a3 DATE := fnd_api.g_miss_date
103: , p7_a4 NUMBER := 0-1962.0724
104: , p7_a5 NUMBER := 0-1962.0724

Line 102: , p7_a3 DATE := fnd_api.g_miss_date

98: , x_object_version_number out nocopy NUMBER
99: , p7_a0 NUMBER := 0-1962.0724
100: , p7_a1 DATE := fnd_api.g_miss_date
101: , p7_a2 NUMBER := 0-1962.0724
102: , p7_a3 DATE := fnd_api.g_miss_date
103: , p7_a4 NUMBER := 0-1962.0724
104: , p7_a5 NUMBER := 0-1962.0724
105: , p7_a6 NUMBER := 0-1962.0724
106: , p7_a7 DATE := fnd_api.g_miss_date

Line 106: , p7_a7 DATE := fnd_api.g_miss_date

102: , p7_a3 DATE := fnd_api.g_miss_date
103: , p7_a4 NUMBER := 0-1962.0724
104: , p7_a5 NUMBER := 0-1962.0724
105: , p7_a6 NUMBER := 0-1962.0724
106: , p7_a7 DATE := fnd_api.g_miss_date
107: , p7_a8 NUMBER := 0-1962.0724
108: , p7_a9 NUMBER := 0-1962.0724
109: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
110: )

Line 109: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

105: , p7_a6 NUMBER := 0-1962.0724
106: , p7_a7 DATE := fnd_api.g_miss_date
107: , p7_a8 NUMBER := 0-1962.0724
108: , p7_a9 NUMBER := 0-1962.0724
109: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
110: )
111:
112: as
113: ddp_enty_attr_validation_rec pv_enty_attr_validations_pvt.enty_attr_validation_rec_type;

Line 168: , p4_a1 DATE := fnd_api.g_miss_date

164: , x_return_status out nocopy VARCHAR2
165: , x_msg_count out nocopy NUMBER
166: , x_msg_data out nocopy VARCHAR2
167: , p4_a0 NUMBER := 0-1962.0724
168: , p4_a1 DATE := fnd_api.g_miss_date
169: , p4_a2 NUMBER := 0-1962.0724
170: , p4_a3 DATE := fnd_api.g_miss_date
171: , p4_a4 NUMBER := 0-1962.0724
172: , p4_a5 NUMBER := 0-1962.0724

Line 170: , p4_a3 DATE := fnd_api.g_miss_date

166: , x_msg_data out nocopy VARCHAR2
167: , p4_a0 NUMBER := 0-1962.0724
168: , p4_a1 DATE := fnd_api.g_miss_date
169: , p4_a2 NUMBER := 0-1962.0724
170: , p4_a3 DATE := fnd_api.g_miss_date
171: , p4_a4 NUMBER := 0-1962.0724
172: , p4_a5 NUMBER := 0-1962.0724
173: , p4_a6 NUMBER := 0-1962.0724
174: , p4_a7 DATE := fnd_api.g_miss_date

Line 174: , p4_a7 DATE := fnd_api.g_miss_date

170: , p4_a3 DATE := fnd_api.g_miss_date
171: , p4_a4 NUMBER := 0-1962.0724
172: , p4_a5 NUMBER := 0-1962.0724
173: , p4_a6 NUMBER := 0-1962.0724
174: , p4_a7 DATE := fnd_api.g_miss_date
175: , p4_a8 NUMBER := 0-1962.0724
176: , p4_a9 NUMBER := 0-1962.0724
177: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
178: )

Line 177: , p4_a10 VARCHAR2 := fnd_api.g_miss_char

173: , p4_a6 NUMBER := 0-1962.0724
174: , p4_a7 DATE := fnd_api.g_miss_date
175: , p4_a8 NUMBER := 0-1962.0724
176: , p4_a9 NUMBER := 0-1962.0724
177: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
178: )
179:
180: as
181: ddp_enty_attr_validation_rec pv_enty_attr_validations_pvt.enty_attr_validation_rec_type;

Line 228: , p0_a1 DATE := fnd_api.g_miss_date

224:
225: procedure check_enty_attr_vldtn_items(p_validation_mode VARCHAR2
226: , x_return_status out nocopy VARCHAR2
227: , p0_a0 NUMBER := 0-1962.0724
228: , p0_a1 DATE := fnd_api.g_miss_date
229: , p0_a2 NUMBER := 0-1962.0724
230: , p0_a3 DATE := fnd_api.g_miss_date
231: , p0_a4 NUMBER := 0-1962.0724
232: , p0_a5 NUMBER := 0-1962.0724

Line 230: , p0_a3 DATE := fnd_api.g_miss_date

226: , x_return_status out nocopy VARCHAR2
227: , p0_a0 NUMBER := 0-1962.0724
228: , p0_a1 DATE := fnd_api.g_miss_date
229: , p0_a2 NUMBER := 0-1962.0724
230: , p0_a3 DATE := fnd_api.g_miss_date
231: , p0_a4 NUMBER := 0-1962.0724
232: , p0_a5 NUMBER := 0-1962.0724
233: , p0_a6 NUMBER := 0-1962.0724
234: , p0_a7 DATE := fnd_api.g_miss_date

Line 234: , p0_a7 DATE := fnd_api.g_miss_date

230: , p0_a3 DATE := fnd_api.g_miss_date
231: , p0_a4 NUMBER := 0-1962.0724
232: , p0_a5 NUMBER := 0-1962.0724
233: , p0_a6 NUMBER := 0-1962.0724
234: , p0_a7 DATE := fnd_api.g_miss_date
235: , p0_a8 NUMBER := 0-1962.0724
236: , p0_a9 NUMBER := 0-1962.0724
237: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
238: )

Line 237: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

233: , p0_a6 NUMBER := 0-1962.0724
234: , p0_a7 DATE := fnd_api.g_miss_date
235: , p0_a8 NUMBER := 0-1962.0724
236: , p0_a9 NUMBER := 0-1962.0724
237: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
238: )
239:
240: as
241: ddp_enty_attr_validation_rec pv_enty_attr_validations_pvt.enty_attr_validation_rec_type;

Line 277: , p5_a1 DATE := fnd_api.g_miss_date

273: , x_msg_count out nocopy NUMBER
274: , x_msg_data out nocopy VARCHAR2
275: , p_validation_mode VARCHAR2
276: , p5_a0 NUMBER := 0-1962.0724
277: , p5_a1 DATE := fnd_api.g_miss_date
278: , p5_a2 NUMBER := 0-1962.0724
279: , p5_a3 DATE := fnd_api.g_miss_date
280: , p5_a4 NUMBER := 0-1962.0724
281: , p5_a5 NUMBER := 0-1962.0724

Line 279: , p5_a3 DATE := fnd_api.g_miss_date

275: , p_validation_mode VARCHAR2
276: , p5_a0 NUMBER := 0-1962.0724
277: , p5_a1 DATE := fnd_api.g_miss_date
278: , p5_a2 NUMBER := 0-1962.0724
279: , p5_a3 DATE := fnd_api.g_miss_date
280: , p5_a4 NUMBER := 0-1962.0724
281: , p5_a5 NUMBER := 0-1962.0724
282: , p5_a6 NUMBER := 0-1962.0724
283: , p5_a7 DATE := fnd_api.g_miss_date

Line 283: , p5_a7 DATE := fnd_api.g_miss_date

279: , p5_a3 DATE := fnd_api.g_miss_date
280: , p5_a4 NUMBER := 0-1962.0724
281: , p5_a5 NUMBER := 0-1962.0724
282: , p5_a6 NUMBER := 0-1962.0724
283: , p5_a7 DATE := fnd_api.g_miss_date
284: , p5_a8 NUMBER := 0-1962.0724
285: , p5_a9 NUMBER := 0-1962.0724
286: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
287: )

Line 286: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

282: , p5_a6 NUMBER := 0-1962.0724
283: , p5_a7 DATE := fnd_api.g_miss_date
284: , p5_a8 NUMBER := 0-1962.0724
285: , p5_a9 NUMBER := 0-1962.0724
286: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
287: )
288:
289: as
290: ddp_enty_attr_validation_rec pv_enty_attr_validations_pvt.enty_attr_validation_rec_type;