eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PERZ_DATA_PUB_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_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

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
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;

Line 27: , a5 JTF_VARCHAR2_TABLE_100

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
31: if a0 is not null and a0.count > 0 then

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

49: end if;
50: end rosetta_table_copy_in_p1;
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

Line 54: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

50: end rosetta_table_copy_in_p1;
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;

Line 56: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
60: if t is null or t.count = 0 then

Line 63: a2 := JTF_VARCHAR2_TABLE_100();

59: begin
60: if t is null or t.count = 0 then
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

Line 64: a3 := JTF_VARCHAR2_TABLE_100();

60: if t is null or t.count = 0 then
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();

Line 66: a5 := JTF_VARCHAR2_TABLE_100();

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();
70: a2 := JTF_VARCHAR2_TABLE_100();

Line 70: a2 := JTF_VARCHAR2_TABLE_100();

66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
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

Line 71: a3 := JTF_VARCHAR2_TABLE_100();

67: else
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);

Line 73: a5 := JTF_VARCHAR2_TABLE_100();

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);
77: a2.extend(t.count);

Line 104: , a4 JTF_VARCHAR2_TABLE_100

100: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_out_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 133: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

129: procedure rosetta_table_copy_out_p4(t jtf_perz_data_pub.data_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
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

Line 143: a4 := JTF_VARCHAR2_TABLE_100();

139: a0 := JTF_NUMBER_TABLE();
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();

Line 150: a4 := JTF_VARCHAR2_TABLE_100();

146: a0 := JTF_NUMBER_TABLE();
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);

Line 187: , p7_a2 JTF_VARCHAR2_TABLE_100

183: , p_profile_name VARCHAR2
184: , p_profile_type VARCHAR2
185: , p7_a0 JTF_NUMBER_TABLE
186: , p7_a1 JTF_NUMBER_TABLE
187: , p7_a2 JTF_VARCHAR2_TABLE_100
188: , p7_a3 JTF_VARCHAR2_TABLE_100
189: , p7_a4 JTF_VARCHAR2_TABLE_100
190: , p_perz_data_id NUMBER
191: , p_perz_data_name VARCHAR2

Line 188: , p7_a3 JTF_VARCHAR2_TABLE_100

184: , p_profile_type VARCHAR2
185: , p7_a0 JTF_NUMBER_TABLE
186: , p7_a1 JTF_NUMBER_TABLE
187: , p7_a2 JTF_VARCHAR2_TABLE_100
188: , p7_a3 JTF_VARCHAR2_TABLE_100
189: , p7_a4 JTF_VARCHAR2_TABLE_100
190: , p_perz_data_id NUMBER
191: , p_perz_data_name VARCHAR2
192: , p_perz_data_type VARCHAR2

Line 189: , p7_a4 JTF_VARCHAR2_TABLE_100

185: , p7_a0 JTF_NUMBER_TABLE
186: , p7_a1 JTF_NUMBER_TABLE
187: , p7_a2 JTF_VARCHAR2_TABLE_100
188: , p7_a3 JTF_VARCHAR2_TABLE_100
189: , p7_a4 JTF_VARCHAR2_TABLE_100
190: , p_perz_data_id NUMBER
191: , p_perz_data_name VARCHAR2
192: , p_perz_data_type VARCHAR2
193: , p_perz_data_desc VARCHAR2

Line 196: , p12_a2 JTF_VARCHAR2_TABLE_100

192: , p_perz_data_type VARCHAR2
193: , p_perz_data_desc VARCHAR2
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

Line 197: , p12_a3 JTF_VARCHAR2_TABLE_100

193: , p_perz_data_desc VARCHAR2
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

Line 199: , p12_a5 JTF_VARCHAR2_TABLE_100

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
203: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 292: , p10_a2 JTF_VARCHAR2_TABLE_100

288: , p_perz_data_type VARCHAR2
289: , p_perz_data_desc VARCHAR2
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

Line 293: , p10_a3 JTF_VARCHAR2_TABLE_100

289: , p_perz_data_desc VARCHAR2
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

Line 295: , p10_a5 JTF_VARCHAR2_TABLE_100

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
299: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 377: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

373: , x_perz_data_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
374: , x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 378: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

374: , x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 380: , p12_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
384: )

Line 462: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

458: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
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

Line 532: , p9_a2 JTF_VARCHAR2_TABLE_100

528: , p_perz_data_type VARCHAR2
529: , p_perz_data_desc VARCHAR2
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

Line 533: , p9_a3 JTF_VARCHAR2_TABLE_100

529: , p_perz_data_desc VARCHAR2
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

Line 535: , p9_a5 JTF_VARCHAR2_TABLE_100

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
539: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2