DBA Data[Home] [Help]

APPS.JTF_PRIME_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_prime.tab01, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_400
28: , a6 JTF_VARCHAR2_TABLE_1000

Line 28: , a6 JTF_VARCHAR2_TABLE_1000

24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_400
28: , a6 JTF_VARCHAR2_TABLE_1000
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_VARCHAR2_TABLE_3000
31: , a9 JTF_VARCHAR2_TABLE_4000
32: ) as

Line 61: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

57: end if;
58: end rosetta_table_copy_in_p1;
59: procedure rosetta_table_copy_out_p1(t jtf_prime.tab01, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
61: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
62: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
63: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
64: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
65: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000

Line 65: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000

61: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
62: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
63: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
64: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
65: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
66: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
67: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_3000
68: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_4000
69: ) as

Line 75: a2 := JTF_VARCHAR2_TABLE_100();

71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_DATE_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_200();
77: a4 := JTF_VARCHAR2_TABLE_300();
78: a5 := JTF_VARCHAR2_TABLE_400();
79: a6 := JTF_VARCHAR2_TABLE_1000();

Line 79: a6 := JTF_VARCHAR2_TABLE_1000();

75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_200();
77: a4 := JTF_VARCHAR2_TABLE_300();
78: a5 := JTF_VARCHAR2_TABLE_400();
79: a6 := JTF_VARCHAR2_TABLE_1000();
80: a7 := JTF_VARCHAR2_TABLE_2000();
81: a8 := JTF_VARCHAR2_TABLE_3000();
82: a9 := JTF_VARCHAR2_TABLE_4000();
83: else

Line 86: a2 := JTF_VARCHAR2_TABLE_100();

82: a9 := JTF_VARCHAR2_TABLE_4000();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_DATE_TABLE();
86: a2 := JTF_VARCHAR2_TABLE_100();
87: a3 := JTF_VARCHAR2_TABLE_200();
88: a4 := JTF_VARCHAR2_TABLE_300();
89: a5 := JTF_VARCHAR2_TABLE_400();
90: a6 := JTF_VARCHAR2_TABLE_1000();

Line 90: a6 := JTF_VARCHAR2_TABLE_1000();

86: a2 := JTF_VARCHAR2_TABLE_100();
87: a3 := JTF_VARCHAR2_TABLE_200();
88: a4 := JTF_VARCHAR2_TABLE_300();
89: a5 := JTF_VARCHAR2_TABLE_400();
90: a6 := JTF_VARCHAR2_TABLE_1000();
91: a7 := JTF_VARCHAR2_TABLE_2000();
92: a8 := JTF_VARCHAR2_TABLE_3000();
93: a9 := JTF_VARCHAR2_TABLE_4000();
94: if t.count > 0 then

Line 130: , p0_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

126: end rosetta_table_copy_out_p1;
127:
128: procedure proc1(p0_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
129: , p0_a1 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
130: , p0_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
131: , p0_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
132: , p0_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
133: , p0_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
134: , p0_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000

Line 134: , p0_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000

130: , p0_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
131: , p0_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
132: , p0_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
133: , p0_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
134: , p0_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
135: , p0_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
136: , p0_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_3000
137: , p0_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_4000
138: )

Line 165: , p0_a2 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

161: end;
162:
163: procedure proc2(p0_a0 IN OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
164: , p0_a1 IN OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
165: , p0_a2 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
166: , p0_a3 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
167: , p0_a4 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
168: , p0_a5 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
169: , p0_a6 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000

Line 169: , p0_a6 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000

165: , p0_a2 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
166: , p0_a3 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
167: , p0_a4 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
168: , p0_a5 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
169: , p0_a6 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
170: , p0_a7 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
171: , p0_a8 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_3000
172: , p0_a9 IN OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_4000
173: )