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_enty_attr_validation(p_api_version_number NUMBER
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
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
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: )
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;
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
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
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: )
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;
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
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
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: )
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;
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
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
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: )
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;
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
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
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: )
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;