DBA Data[Home] [Help]

APPS.JTF_PRIME_W dependencies on JTF_PRIME

Line 1: package body jtf_prime_w as

1: package body jtf_prime_w as
2: /* $Header: JTFPRMWB.pls 120.2 2005/11/28 22:22:44 skothe ship $ */
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:

Line 22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_prime.tab01, a0 JTF_NUMBER_TABLE

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_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

Line 59: procedure rosetta_table_copy_out_p1(t jtf_prime.tab01, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

55: end loop;
56: end if;
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

Line 140: ddt jtf_prime.tab01;

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: )
139: as
140: ddt jtf_prime.tab01;
141: ddindx binary_integer; indx binary_integer;
142: begin
143:
144: -- copy data to the local IN or IN-OUT args, if any

Line 147: jtf_prime.proc1(ddt);

143:
144: -- copy data to the local IN or IN-OUT args, if any
145:
146: -- here's the delegated call to the old PL/SQL routine
147: jtf_prime.proc1(ddt);
148:
149: -- copy data back from the local OUT or IN-OUT args, if any
150: jtf_prime_w.rosetta_table_copy_out_p1(ddt, p0_a0
151: , p0_a1

Line 150: jtf_prime_w.rosetta_table_copy_out_p1(ddt, p0_a0

146: -- here's the delegated call to the old PL/SQL routine
147: jtf_prime.proc1(ddt);
148:
149: -- copy data back from the local OUT or IN-OUT args, if any
150: jtf_prime_w.rosetta_table_copy_out_p1(ddt, p0_a0
151: , p0_a1
152: , p0_a2
153: , p0_a3
154: , p0_a4

Line 175: ddt jtf_prime.tab01;

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: )
174: as
175: ddt jtf_prime.tab01;
176: ddindx binary_integer; indx binary_integer;
177: begin
178:
179: -- copy data to the local IN or IN-OUT args, if any

Line 180: jtf_prime_w.rosetta_table_copy_in_p1(ddt, p0_a0

176: ddindx binary_integer; indx binary_integer;
177: begin
178:
179: -- copy data to the local IN or IN-OUT args, if any
180: jtf_prime_w.rosetta_table_copy_in_p1(ddt, p0_a0
181: , p0_a1
182: , p0_a2
183: , p0_a3
184: , p0_a4

Line 193: jtf_prime.proc2(ddt);

189: , p0_a9
190: );
191:
192: -- here's the delegated call to the old PL/SQL routine
193: jtf_prime.proc2(ddt);
194:
195: -- copy data back from the local OUT or IN-OUT args, if any
196: jtf_prime_w.rosetta_table_copy_out_p1(ddt, p0_a0
197: , p0_a1

Line 196: jtf_prime_w.rosetta_table_copy_out_p1(ddt, p0_a0

192: -- here's the delegated call to the old PL/SQL routine
193: jtf_prime.proc2(ddt);
194:
195: -- copy data back from the local OUT or IN-OUT args, if any
196: jtf_prime_w.rosetta_table_copy_out_p1(ddt, p0_a0
197: , p0_a1
198: , p0_a2
199: , p0_a3
200: , p0_a4

Line 209: end jtf_prime_w;

205: , p0_a9
206: );
207: end;
208:
209: end jtf_prime_w;