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_NUMBER_TABLE

Line 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

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

Line 23: , a1 JTF_NUMBER_TABLE

19: return d;
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

Line 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

47: end loop;
48: end if;
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

Line 52: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

48: end if;
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

Line 61: a0 := JTF_NUMBER_TABLE();

57: ) as
58: ddindx binary_integer; indx binary_integer;
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();

Line 62: a1 := JTF_NUMBER_TABLE();

58: ddindx binary_integer; indx binary_integer;
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();

Line 68: a0 := JTF_NUMBER_TABLE();

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();
71: a3 := JTF_VARCHAR2_TABLE_100();
72: a4 := JTF_VARCHAR2_TABLE_300();

Line 69: a1 := JTF_NUMBER_TABLE();

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();
71: a3 := JTF_VARCHAR2_TABLE_100();
72: a4 := JTF_VARCHAR2_TABLE_300();
73: a5 := JTF_VARCHAR2_TABLE_100();

Line 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

96: end if;
97: end if;
98: end rosetta_table_copy_out_p1;
99:
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

Line 101: , a1 JTF_NUMBER_TABLE

97: end if;
98: end rosetta_table_copy_out_p1;
99:
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

Line 102: , a2 JTF_NUMBER_TABLE

98: end rosetta_table_copy_out_p1;
99:
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

Line 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

125: end loop;
126: end if;
127: end if;
128: end rosetta_table_copy_in_p4;
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

Line 130: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

126: end if;
127: end if;
128: end rosetta_table_copy_in_p4;
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

Line 131: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

127: end if;
128: end rosetta_table_copy_in_p4;
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

Line 139: a0 := JTF_NUMBER_TABLE();

135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
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();

Line 140: a1 := JTF_NUMBER_TABLE();

136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
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();

Line 141: a2 := JTF_NUMBER_TABLE();

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

Line 146: a0 := 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();
149: a3 := JTF_VARCHAR2_TABLE_200();
150: a4 := JTF_VARCHAR2_TABLE_100();

Line 147: a1 := JTF_NUMBER_TABLE();

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();
149: a3 := JTF_VARCHAR2_TABLE_200();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_VARCHAR2_TABLE_300();

Line 148: a2 := JTF_NUMBER_TABLE();

144: a5 := JTF_VARCHAR2_TABLE_300();
145: else
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

Line 185: , p7_a0 JTF_NUMBER_TABLE

181: , p_application_id NUMBER
182: , p_profile_id NUMBER
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

Line 186: , p7_a1 JTF_NUMBER_TABLE

182: , p_profile_id NUMBER
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

Line 194: , p12_a0 JTF_NUMBER_TABLE

190: , p_perz_data_id NUMBER
191: , p_perz_data_name VARCHAR2
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

Line 195: , p12_a1 JTF_NUMBER_TABLE

191: , p_perz_data_name VARCHAR2
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

Line 290: , p10_a0 JTF_NUMBER_TABLE

286: , p_perz_data_id NUMBER
287: , p_perz_data_name VARCHAR2
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

Line 291: , p10_a1 JTF_NUMBER_TABLE

287: , p_perz_data_name VARCHAR2
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

Line 375: , p12_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

371: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
372: , x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 376: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 458: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

454: , p_profile_name VARCHAR2
455: , p_perz_data_id NUMBER
456: , p_perz_data_name VARCHAR2
457: , p_perz_data_type VARCHAR2
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

Line 459: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

455: , p_perz_data_id NUMBER
456: , p_perz_data_name VARCHAR2
457: , p_perz_data_type VARCHAR2
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

Line 460: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

456: , p_perz_data_name VARCHAR2
457: , p_perz_data_type VARCHAR2
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

Line 530: , p9_a0 JTF_NUMBER_TABLE

526: , p_perz_data_id NUMBER
527: , p_perz_data_name VARCHAR2
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

Line 531: , p9_a1 JTF_NUMBER_TABLE

527: , p_perz_data_name VARCHAR2
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