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.CN_REASONS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_4000

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_4000
18: , a5 JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_NUMBER_TABLE

12:
13: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_4000
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100

Line 40: , a27 JTF_NUMBER_TABLE

36: , a23 JTF_VARCHAR2_TABLE_100
37: , a24 JTF_VARCHAR2_TABLE_100
38: , a25 JTF_VARCHAR2_TABLE_100
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_VARCHAR2_TABLE_100
42: , a29 JTF_NUMBER_TABLE
43: ) as
44: ddindx binary_integer; indx binary_integer;

Line 42: , a29 JTF_NUMBER_TABLE

38: , a25 JTF_VARCHAR2_TABLE_100
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_VARCHAR2_TABLE_100
42: , a29 JTF_NUMBER_TABLE
43: ) as
44: ddindx binary_integer; indx binary_integer;
45: begin
46: if a0 is not null and a0.count > 0 then

Line 90: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE

86: end loop;
87: end if;
88: end if;
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 91: , a1 out nocopy JTF_NUMBER_TABLE

87: end if;
88: end if;
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_VARCHAR2_TABLE_4000
95: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: , a3 out nocopy JTF_NUMBER_TABLE

89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_VARCHAR2_TABLE_4000
95: , a5 out nocopy JTF_VARCHAR2_TABLE_100
96: , a6 out nocopy JTF_VARCHAR2_TABLE_100
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a27 out nocopy JTF_NUMBER_TABLE

113: , a23 out nocopy JTF_VARCHAR2_TABLE_100
114: , a24 out nocopy JTF_VARCHAR2_TABLE_100
115: , a25 out nocopy JTF_VARCHAR2_TABLE_100
116: , a26 out nocopy JTF_DATE_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_VARCHAR2_TABLE_100
119: , a29 out nocopy JTF_NUMBER_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;

Line 119: , a29 out nocopy JTF_NUMBER_TABLE

115: , a25 out nocopy JTF_VARCHAR2_TABLE_100
116: , a26 out nocopy JTF_DATE_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_VARCHAR2_TABLE_100
119: , a29 out nocopy JTF_NUMBER_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then

Line 124: a0 := JTF_NUMBER_TABLE();

120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_VARCHAR2_TABLE_100();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_VARCHAR2_TABLE_4000();

Line 125: a1 := JTF_NUMBER_TABLE();

121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_VARCHAR2_TABLE_100();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_VARCHAR2_TABLE_4000();
129: a5 := JTF_VARCHAR2_TABLE_100();

Line 127: a3 := JTF_NUMBER_TABLE();

123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_VARCHAR2_TABLE_100();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_VARCHAR2_TABLE_4000();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_100();

Line 151: a27 := JTF_NUMBER_TABLE();

147: a23 := JTF_VARCHAR2_TABLE_100();
148: a24 := JTF_VARCHAR2_TABLE_100();
149: a25 := JTF_VARCHAR2_TABLE_100();
150: a26 := JTF_DATE_TABLE();
151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_VARCHAR2_TABLE_100();
153: a29 := JTF_NUMBER_TABLE();
154: else
155: a0 := JTF_NUMBER_TABLE();

Line 153: a29 := JTF_NUMBER_TABLE();

149: a25 := JTF_VARCHAR2_TABLE_100();
150: a26 := JTF_DATE_TABLE();
151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_VARCHAR2_TABLE_100();
153: a29 := JTF_NUMBER_TABLE();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_VARCHAR2_TABLE_100();

Line 155: a0 := JTF_NUMBER_TABLE();

151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_VARCHAR2_TABLE_100();
153: a29 := JTF_NUMBER_TABLE();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_VARCHAR2_TABLE_100();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_VARCHAR2_TABLE_4000();

Line 156: a1 := JTF_NUMBER_TABLE();

152: a28 := JTF_VARCHAR2_TABLE_100();
153: a29 := JTF_NUMBER_TABLE();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_VARCHAR2_TABLE_100();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_VARCHAR2_TABLE_4000();
160: a5 := JTF_VARCHAR2_TABLE_100();

Line 158: a3 := JTF_NUMBER_TABLE();

154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_VARCHAR2_TABLE_100();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_VARCHAR2_TABLE_4000();
160: a5 := JTF_VARCHAR2_TABLE_100();
161: a6 := JTF_VARCHAR2_TABLE_100();
162: a7 := JTF_VARCHAR2_TABLE_100();

Line 182: a27 := JTF_NUMBER_TABLE();

178: a23 := JTF_VARCHAR2_TABLE_100();
179: a24 := JTF_VARCHAR2_TABLE_100();
180: a25 := JTF_VARCHAR2_TABLE_100();
181: a26 := JTF_DATE_TABLE();
182: a27 := JTF_NUMBER_TABLE();
183: a28 := JTF_VARCHAR2_TABLE_100();
184: a29 := JTF_NUMBER_TABLE();
185: if t.count > 0 then
186: a0.extend(t.count);

Line 184: a29 := JTF_NUMBER_TABLE();

180: a25 := JTF_VARCHAR2_TABLE_100();
181: a26 := JTF_DATE_TABLE();
182: a27 := JTF_NUMBER_TABLE();
183: a28 := JTF_VARCHAR2_TABLE_100();
184: a29 := JTF_NUMBER_TABLE();
185: if t.count > 0 then
186: a0.extend(t.count);
187: a1.extend(t.count);
188: a2.extend(t.count);

Line 286: , p14_a0 out nocopy JTF_NUMBER_TABLE

282: , p13_a10 out nocopy VARCHAR2
283: , p13_a11 out nocopy VARCHAR2
284: , p13_a12 out nocopy NUMBER
285: , p13_a13 out nocopy VARCHAR2
286: , p14_a0 out nocopy JTF_NUMBER_TABLE
287: , p14_a1 out nocopy JTF_NUMBER_TABLE
288: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p14_a3 out nocopy JTF_NUMBER_TABLE
290: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 287: , p14_a1 out nocopy JTF_NUMBER_TABLE

283: , p13_a11 out nocopy VARCHAR2
284: , p13_a12 out nocopy NUMBER
285: , p13_a13 out nocopy VARCHAR2
286: , p14_a0 out nocopy JTF_NUMBER_TABLE
287: , p14_a1 out nocopy JTF_NUMBER_TABLE
288: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p14_a3 out nocopy JTF_NUMBER_TABLE
290: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_4000
291: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 289: , p14_a3 out nocopy JTF_NUMBER_TABLE

285: , p13_a13 out nocopy VARCHAR2
286: , p14_a0 out nocopy JTF_NUMBER_TABLE
287: , p14_a1 out nocopy JTF_NUMBER_TABLE
288: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p14_a3 out nocopy JTF_NUMBER_TABLE
290: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_4000
291: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
292: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
293: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 313: , p14_a27 out nocopy JTF_NUMBER_TABLE

309: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_100
310: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
311: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_100
312: , p14_a26 out nocopy JTF_DATE_TABLE
313: , p14_a27 out nocopy JTF_NUMBER_TABLE
314: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
315: , p14_a29 out nocopy JTF_NUMBER_TABLE
316: , x_notes_count out nocopy NUMBER
317: )

Line 315: , p14_a29 out nocopy JTF_NUMBER_TABLE

311: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_100
312: , p14_a26 out nocopy JTF_DATE_TABLE
313: , p14_a27 out nocopy JTF_NUMBER_TABLE
314: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
315: , p14_a29 out nocopy JTF_NUMBER_TABLE
316: , x_notes_count out nocopy NUMBER
317: )
318:
319: as

Line 427: , p4_a0 JTF_NUMBER_TABLE

423: procedure manage_analyst_notes(p_api_version NUMBER
424: , p_init_msg_list VARCHAR2
425: , p_validation_level VARCHAR2
426: , p_commit VARCHAR2
427: , p4_a0 JTF_NUMBER_TABLE
428: , p4_a1 JTF_NUMBER_TABLE
429: , p4_a2 JTF_VARCHAR2_TABLE_100
430: , p4_a3 JTF_NUMBER_TABLE
431: , p4_a4 JTF_VARCHAR2_TABLE_4000

Line 428: , p4_a1 JTF_NUMBER_TABLE

424: , p_init_msg_list VARCHAR2
425: , p_validation_level VARCHAR2
426: , p_commit VARCHAR2
427: , p4_a0 JTF_NUMBER_TABLE
428: , p4_a1 JTF_NUMBER_TABLE
429: , p4_a2 JTF_VARCHAR2_TABLE_100
430: , p4_a3 JTF_NUMBER_TABLE
431: , p4_a4 JTF_VARCHAR2_TABLE_4000
432: , p4_a5 JTF_VARCHAR2_TABLE_100

Line 430: , p4_a3 JTF_NUMBER_TABLE

426: , p_commit VARCHAR2
427: , p4_a0 JTF_NUMBER_TABLE
428: , p4_a1 JTF_NUMBER_TABLE
429: , p4_a2 JTF_VARCHAR2_TABLE_100
430: , p4_a3 JTF_NUMBER_TABLE
431: , p4_a4 JTF_VARCHAR2_TABLE_4000
432: , p4_a5 JTF_VARCHAR2_TABLE_100
433: , p4_a6 JTF_VARCHAR2_TABLE_100
434: , p4_a7 JTF_VARCHAR2_TABLE_100

Line 454: , p4_a27 JTF_NUMBER_TABLE

450: , p4_a23 JTF_VARCHAR2_TABLE_100
451: , p4_a24 JTF_VARCHAR2_TABLE_100
452: , p4_a25 JTF_VARCHAR2_TABLE_100
453: , p4_a26 JTF_DATE_TABLE
454: , p4_a27 JTF_NUMBER_TABLE
455: , p4_a28 JTF_VARCHAR2_TABLE_100
456: , p4_a29 JTF_NUMBER_TABLE
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER

Line 456: , p4_a29 JTF_NUMBER_TABLE

452: , p4_a25 JTF_VARCHAR2_TABLE_100
453: , p4_a26 JTF_DATE_TABLE
454: , p4_a27 JTF_NUMBER_TABLE
455: , p4_a28 JTF_VARCHAR2_TABLE_100
456: , p4_a29 JTF_NUMBER_TABLE
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: , x_loading_status out nocopy VARCHAR2

Line 542: , p11_a0 out nocopy JTF_NUMBER_TABLE

538: , x_return_status out nocopy VARCHAR2
539: , x_msg_count out nocopy NUMBER
540: , x_msg_data out nocopy VARCHAR2
541: , x_loading_status out nocopy VARCHAR2
542: , p11_a0 out nocopy JTF_NUMBER_TABLE
543: , p11_a1 out nocopy JTF_NUMBER_TABLE
544: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
545: , p11_a3 out nocopy JTF_NUMBER_TABLE
546: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 543: , p11_a1 out nocopy JTF_NUMBER_TABLE

539: , x_msg_count out nocopy NUMBER
540: , x_msg_data out nocopy VARCHAR2
541: , x_loading_status out nocopy VARCHAR2
542: , p11_a0 out nocopy JTF_NUMBER_TABLE
543: , p11_a1 out nocopy JTF_NUMBER_TABLE
544: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
545: , p11_a3 out nocopy JTF_NUMBER_TABLE
546: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_4000
547: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 545: , p11_a3 out nocopy JTF_NUMBER_TABLE

541: , x_loading_status out nocopy VARCHAR2
542: , p11_a0 out nocopy JTF_NUMBER_TABLE
543: , p11_a1 out nocopy JTF_NUMBER_TABLE
544: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
545: , p11_a3 out nocopy JTF_NUMBER_TABLE
546: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_4000
547: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
548: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
549: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 569: , p11_a27 out nocopy JTF_NUMBER_TABLE

565: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
566: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_100
567: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
568: , p11_a26 out nocopy JTF_DATE_TABLE
569: , p11_a27 out nocopy JTF_NUMBER_TABLE
570: , p11_a28 out nocopy JTF_VARCHAR2_TABLE_100
571: , p11_a29 out nocopy JTF_NUMBER_TABLE
572: , x_notes_count out nocopy NUMBER
573: )

Line 571: , p11_a29 out nocopy JTF_NUMBER_TABLE

567: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
568: , p11_a26 out nocopy JTF_DATE_TABLE
569: , p11_a27 out nocopy JTF_NUMBER_TABLE
570: , p11_a28 out nocopy JTF_VARCHAR2_TABLE_100
571: , p11_a29 out nocopy JTF_NUMBER_TABLE
572: , x_notes_count out nocopy NUMBER
573: )
574:
575: as