DBA Data[Home] [Help]

APPS.JTF_PERZ_DATA_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 26: , a4 JTF_VARCHAR2_TABLE_300

22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_attrib_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin

Line 55: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

51: procedure rosetta_table_copy_out_p1(t jtf_perz_data_pub.data_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
52: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
53: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
54: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
55: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
56: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 65: a4 := JTF_VARCHAR2_TABLE_300();

61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_300();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_NUMBER_TABLE();

Line 72: a4 := JTF_VARCHAR2_TABLE_300();

68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_NUMBER_TABLE();
70: a2 := JTF_VARCHAR2_TABLE_100();
71: a3 := JTF_VARCHAR2_TABLE_100();
72: a4 := JTF_VARCHAR2_TABLE_300();
73: a5 := JTF_VARCHAR2_TABLE_100();
74: if t.count > 0 then
75: a0.extend(t.count);
76: a1.extend(t.count);

Line 105: , a5 JTF_VARCHAR2_TABLE_300

101: , a1 JTF_NUMBER_TABLE
102: , a2 JTF_NUMBER_TABLE
103: , a3 JTF_VARCHAR2_TABLE_200
104: , a4 JTF_VARCHAR2_TABLE_100
105: , a5 JTF_VARCHAR2_TABLE_300
106: ) as
107: ddindx binary_integer; indx binary_integer;
108: begin
109: if a0 is not null and a0.count > 0 then

Line 134: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

130: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
131: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
132: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
133: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
134: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then

Line 144: a5 := JTF_VARCHAR2_TABLE_300();

140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_200();
143: a4 := JTF_VARCHAR2_TABLE_100();
144: a5 := JTF_VARCHAR2_TABLE_300();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_NUMBER_TABLE();

Line 151: a5 := JTF_VARCHAR2_TABLE_300();

147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_NUMBER_TABLE();
149: a3 := JTF_VARCHAR2_TABLE_200();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_VARCHAR2_TABLE_300();
152: if t.count > 0 then
153: a0.extend(t.count);
154: a1.extend(t.count);
155: a2.extend(t.count);

Line 198: , p12_a4 JTF_VARCHAR2_TABLE_300

194: , p12_a0 JTF_NUMBER_TABLE
195: , p12_a1 JTF_NUMBER_TABLE
196: , p12_a2 JTF_VARCHAR2_TABLE_100
197: , p12_a3 JTF_VARCHAR2_TABLE_100
198: , p12_a4 JTF_VARCHAR2_TABLE_300
199: , p12_a5 JTF_VARCHAR2_TABLE_100
200: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
201: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
202: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 294: , p10_a4 JTF_VARCHAR2_TABLE_300

290: , p10_a0 JTF_NUMBER_TABLE
291: , p10_a1 JTF_NUMBER_TABLE
292: , p10_a2 JTF_VARCHAR2_TABLE_100
293: , p10_a3 JTF_VARCHAR2_TABLE_100
294: , p10_a4 JTF_VARCHAR2_TABLE_300
295: , p10_a5 JTF_VARCHAR2_TABLE_100
296: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
297: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
298: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 379: , p12_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

375: , p12_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
376: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
377: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
378: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
379: , p12_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
380: , p12_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
381: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
382: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
383: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 463: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

459: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
460: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
461: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
462: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
463: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
464: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
465: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
466: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
467: )

Line 534: , p9_a4 JTF_VARCHAR2_TABLE_300

530: , p9_a0 JTF_NUMBER_TABLE
531: , p9_a1 JTF_NUMBER_TABLE
532: , p9_a2 JTF_VARCHAR2_TABLE_100
533: , p9_a3 JTF_VARCHAR2_TABLE_100
534: , p9_a4 JTF_VARCHAR2_TABLE_300
535: , p9_a5 JTF_VARCHAR2_TABLE_100
536: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
537: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
538: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER