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_class_category(p_init_msg_list VARCHAR2
19: return d;
20: end;
21:
22: procedure create_class_category(p_init_msg_list VARCHAR2
23: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
24: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
25: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
26: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
20: end;
21:
22: procedure create_class_category(p_init_msg_list VARCHAR2
23: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
24: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
25: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
26: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a5 NUMBER := 0-1962.0724
21:
22: procedure create_class_category(p_init_msg_list VARCHAR2
23: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
24: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
25: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
26: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a5 NUMBER := 0-1962.0724
29: , x_return_status out VARCHAR2
22: procedure create_class_category(p_init_msg_list VARCHAR2
23: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
24: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
25: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
26: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a5 NUMBER := 0-1962.0724
29: , x_return_status out VARCHAR2
30: , x_msg_count out NUMBER
23: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
24: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
25: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
26: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a5 NUMBER := 0-1962.0724
29: , x_return_status out VARCHAR2
30: , x_msg_count out NUMBER
31: , x_msg_data out VARCHAR2
61:
62: end;
63:
64: procedure update_class_category(p_init_msg_list VARCHAR2
65: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
66: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
67: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
68: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
62: end;
63:
64: procedure update_class_category(p_init_msg_list VARCHAR2
65: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
66: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
67: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
68: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a5 NUMBER := 0-1962.0724
63:
64: procedure update_class_category(p_init_msg_list VARCHAR2
65: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
66: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
67: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
68: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a5 NUMBER := 0-1962.0724
71: , p_object_version_number in out NUMBER
64: procedure update_class_category(p_init_msg_list VARCHAR2
65: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
66: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
67: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
68: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a5 NUMBER := 0-1962.0724
71: , p_object_version_number in out NUMBER
72: , x_return_status out VARCHAR2
65: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
66: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
67: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
68: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a5 NUMBER := 0-1962.0724
71: , p_object_version_number in out NUMBER
72: , x_return_status out VARCHAR2
73: , x_msg_count out NUMBER
153:
154: end;
155:
156: procedure create_class_code_relation(p_init_msg_list VARCHAR2
157: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
158: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
159: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
160: , p1_a3 DATE := fnd_api.g_miss_date
161: , p1_a4 DATE := fnd_api.g_miss_date
154: end;
155:
156: procedure create_class_code_relation(p_init_msg_list VARCHAR2
157: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
158: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
159: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
160: , p1_a3 DATE := fnd_api.g_miss_date
161: , p1_a4 DATE := fnd_api.g_miss_date
162: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
155:
156: procedure create_class_code_relation(p_init_msg_list VARCHAR2
157: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
158: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
159: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
160: , p1_a3 DATE := fnd_api.g_miss_date
161: , p1_a4 DATE := fnd_api.g_miss_date
162: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
163: , p1_a6 NUMBER := 0-1962.0724
156: procedure create_class_code_relation(p_init_msg_list VARCHAR2
157: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
158: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
159: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
160: , p1_a3 DATE := fnd_api.g_miss_date
161: , p1_a4 DATE := fnd_api.g_miss_date
162: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
163: , p1_a6 NUMBER := 0-1962.0724
164: , x_return_status out VARCHAR2
157: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
158: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
159: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
160: , p1_a3 DATE := fnd_api.g_miss_date
161: , p1_a4 DATE := fnd_api.g_miss_date
162: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
163: , p1_a6 NUMBER := 0-1962.0724
164: , x_return_status out VARCHAR2
165: , x_msg_count out NUMBER
158: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
159: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
160: , p1_a3 DATE := fnd_api.g_miss_date
161: , p1_a4 DATE := fnd_api.g_miss_date
162: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
163: , p1_a6 NUMBER := 0-1962.0724
164: , x_return_status out VARCHAR2
165: , x_msg_count out NUMBER
166: , x_msg_data out VARCHAR2
197:
198: end;
199:
200: procedure update_class_code_relation(p_init_msg_list VARCHAR2
201: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
202: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
203: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
204: , p1_a3 DATE := fnd_api.g_miss_date
205: , p1_a4 DATE := fnd_api.g_miss_date
198: end;
199:
200: procedure update_class_code_relation(p_init_msg_list VARCHAR2
201: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
202: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
203: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
204: , p1_a3 DATE := fnd_api.g_miss_date
205: , p1_a4 DATE := fnd_api.g_miss_date
206: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
199:
200: procedure update_class_code_relation(p_init_msg_list VARCHAR2
201: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
202: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
203: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
204: , p1_a3 DATE := fnd_api.g_miss_date
205: , p1_a4 DATE := fnd_api.g_miss_date
206: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
207: , p1_a6 NUMBER := 0-1962.0724
200: procedure update_class_code_relation(p_init_msg_list VARCHAR2
201: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
202: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
203: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
204: , p1_a3 DATE := fnd_api.g_miss_date
205: , p1_a4 DATE := fnd_api.g_miss_date
206: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
207: , p1_a6 NUMBER := 0-1962.0724
208: , p_object_version_number in out NUMBER
201: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
202: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
203: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
204: , p1_a3 DATE := fnd_api.g_miss_date
205: , p1_a4 DATE := fnd_api.g_miss_date
206: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
207: , p1_a6 NUMBER := 0-1962.0724
208: , p_object_version_number in out NUMBER
209: , x_return_status out VARCHAR2
202: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
203: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
204: , p1_a3 DATE := fnd_api.g_miss_date
205: , p1_a4 DATE := fnd_api.g_miss_date
206: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
207: , p1_a6 NUMBER := 0-1962.0724
208: , p_object_version_number in out NUMBER
209: , x_return_status out VARCHAR2
210: , x_msg_count out NUMBER
308: end;
309:
310: procedure create_code_assignment(p_init_msg_list VARCHAR2
311: , p1_a0 NUMBER := 0-1962.0724
312: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a2 NUMBER := 0-1962.0724
314: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
315: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
310: procedure create_code_assignment(p_init_msg_list VARCHAR2
311: , p1_a0 NUMBER := 0-1962.0724
312: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a2 NUMBER := 0-1962.0724
314: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
315: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
311: , p1_a0 NUMBER := 0-1962.0724
312: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a2 NUMBER := 0-1962.0724
314: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
315: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
319: , p1_a8 DATE := fnd_api.g_miss_date
312: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a2 NUMBER := 0-1962.0724
314: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
315: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
319: , p1_a8 DATE := fnd_api.g_miss_date
320: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a2 NUMBER := 0-1962.0724
314: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
315: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
319: , p1_a8 DATE := fnd_api.g_miss_date
320: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
321: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
314: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
315: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
319: , p1_a8 DATE := fnd_api.g_miss_date
320: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
321: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p1_a11 NUMBER := 0-1962.0724
315: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
319: , p1_a8 DATE := fnd_api.g_miss_date
320: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
321: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p1_a11 NUMBER := 0-1962.0724
323: , x_return_status out VARCHAR2
316: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
319: , p1_a8 DATE := fnd_api.g_miss_date
320: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
321: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p1_a11 NUMBER := 0-1962.0724
323: , x_return_status out VARCHAR2
324: , x_msg_count out NUMBER
317: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
318: , p1_a7 DATE := fnd_api.g_miss_date
319: , p1_a8 DATE := fnd_api.g_miss_date
320: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
321: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p1_a11 NUMBER := 0-1962.0724
323: , x_return_status out VARCHAR2
324: , x_msg_count out NUMBER
325: , x_msg_data out VARCHAR2
366: end;
367:
368: procedure update_code_assignment(p_init_msg_list VARCHAR2
369: , p1_a0 NUMBER := 0-1962.0724
370: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
371: , p1_a2 NUMBER := 0-1962.0724
372: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
368: procedure update_code_assignment(p_init_msg_list VARCHAR2
369: , p1_a0 NUMBER := 0-1962.0724
370: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
371: , p1_a2 NUMBER := 0-1962.0724
372: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
369: , p1_a0 NUMBER := 0-1962.0724
370: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
371: , p1_a2 NUMBER := 0-1962.0724
372: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
377: , p1_a8 DATE := fnd_api.g_miss_date
370: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
371: , p1_a2 NUMBER := 0-1962.0724
372: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
377: , p1_a8 DATE := fnd_api.g_miss_date
378: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
371: , p1_a2 NUMBER := 0-1962.0724
372: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
377: , p1_a8 DATE := fnd_api.g_miss_date
378: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
372: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
377: , p1_a8 DATE := fnd_api.g_miss_date
378: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p1_a11 NUMBER := 0-1962.0724
373: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
377: , p1_a8 DATE := fnd_api.g_miss_date
378: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p1_a11 NUMBER := 0-1962.0724
381: , p_object_version_number in out NUMBER
374: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
377: , p1_a8 DATE := fnd_api.g_miss_date
378: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p1_a11 NUMBER := 0-1962.0724
381: , p_object_version_number in out NUMBER
382: , x_return_status out VARCHAR2
375: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p1_a7 DATE := fnd_api.g_miss_date
377: , p1_a8 DATE := fnd_api.g_miss_date
378: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p1_a11 NUMBER := 0-1962.0724
381: , p_object_version_number in out NUMBER
382: , x_return_status out VARCHAR2
383: , x_msg_count out NUMBER