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_st_assoc_pvt.st_assoc_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_st_assoc_pvt.st_assoc_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_st_assoc_pvt.st_assoc_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_4000
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_4000
34: , a12 JTF_VARCHAR2_TABLE_100
61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p3;
65: procedure rosetta_table_copy_out_p3(t ams_st_assoc_pvt.st_assoc_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
66: , a1 OUT NOCOPY JTF_DATE_TABLE
67: , a2 OUT NOCOPY JTF_NUMBER_TABLE
68: , a3 OUT NOCOPY JTF_DATE_TABLE
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE
63: end if;
64: end rosetta_table_copy_in_p3;
65: procedure rosetta_table_copy_out_p3(t ams_st_assoc_pvt.st_assoc_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
66: , a1 OUT NOCOPY JTF_DATE_TABLE
67: , a2 OUT NOCOPY JTF_NUMBER_TABLE
68: , a3 OUT NOCOPY JTF_DATE_TABLE
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE
70: , a5 OUT NOCOPY JTF_NUMBER_TABLE
71: , a6 OUT NOCOPY JTF_NUMBER_TABLE
65: procedure rosetta_table_copy_out_p3(t ams_st_assoc_pvt.st_assoc_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
66: , a1 OUT NOCOPY JTF_DATE_TABLE
67: , a2 OUT NOCOPY JTF_NUMBER_TABLE
68: , a3 OUT NOCOPY JTF_DATE_TABLE
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE
70: , a5 OUT NOCOPY JTF_NUMBER_TABLE
71: , a6 OUT NOCOPY JTF_NUMBER_TABLE
72: , a7 OUT NOCOPY JTF_NUMBER_TABLE
73: , a8 OUT NOCOPY JTF_NUMBER_TABLE
66: , a1 OUT NOCOPY JTF_DATE_TABLE
67: , a2 OUT NOCOPY JTF_NUMBER_TABLE
68: , a3 OUT NOCOPY JTF_DATE_TABLE
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE
70: , a5 OUT NOCOPY JTF_NUMBER_TABLE
71: , a6 OUT NOCOPY JTF_NUMBER_TABLE
72: , a7 OUT NOCOPY JTF_NUMBER_TABLE
73: , a8 OUT NOCOPY JTF_NUMBER_TABLE
74: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
67: , a2 OUT NOCOPY JTF_NUMBER_TABLE
68: , a3 OUT NOCOPY JTF_DATE_TABLE
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE
70: , a5 OUT NOCOPY JTF_NUMBER_TABLE
71: , a6 OUT NOCOPY JTF_NUMBER_TABLE
72: , a7 OUT NOCOPY JTF_NUMBER_TABLE
73: , a8 OUT NOCOPY JTF_NUMBER_TABLE
74: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
68: , a3 OUT NOCOPY JTF_DATE_TABLE
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE
70: , a5 OUT NOCOPY JTF_NUMBER_TABLE
71: , a6 OUT NOCOPY JTF_NUMBER_TABLE
72: , a7 OUT NOCOPY JTF_NUMBER_TABLE
73: , a8 OUT NOCOPY JTF_NUMBER_TABLE
74: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE
70: , a5 OUT NOCOPY JTF_NUMBER_TABLE
71: , a6 OUT NOCOPY JTF_NUMBER_TABLE
72: , a7 OUT NOCOPY JTF_NUMBER_TABLE
73: , a8 OUT NOCOPY JTF_NUMBER_TABLE
74: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
77: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_DATE_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_NUMBER_TABLE();
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_DATE_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_DATE_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
83: a1 := JTF_DATE_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_4000();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_4000();
94: a12 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_4000();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_DATE_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_DATE_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_DATE_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_NUMBER_TABLE();
97: a1 := JTF_DATE_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_VARCHAR2_TABLE_100();
106: a10 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_VARCHAR2_TABLE_100();
106: a10 := JTF_VARCHAR2_TABLE_100();
107: a11 := JTF_VARCHAR2_TABLE_4000();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_VARCHAR2_TABLE_100();
106: a10 := JTF_VARCHAR2_TABLE_100();
107: a11 := JTF_VARCHAR2_TABLE_4000();
108: a12 := JTF_VARCHAR2_TABLE_100();