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

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy amv_perspective_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy amv_perspective_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 46: procedure rosetta_table_copy_out_p1(t amv_perspective_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p1;
46: procedure rosetta_table_copy_out_p1(t amv_perspective_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 52: a0 := JTF_NUMBER_TABLE();

48: begin
49: if t is null then
50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: if t.count > 0 then
56: a0.extend(t.count);

Line 54: a0 := JTF_NUMBER_TABLE();

50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: if t.count > 0 then
56: a0.extend(t.count);
57: ddindx := t.first;
58: indx := 1;

Line 71: procedure rosetta_table_copy_in_p5(t out nocopy amv_perspective_pvt.amv_perspective_obj_varray, a0 JTF_NUMBER_TABLE

67: end if;
68: end if;
69: end rosetta_table_copy_out_p1;
70:
71: procedure rosetta_table_copy_in_p5(t out nocopy amv_perspective_pvt.amv_perspective_obj_varray, a0 JTF_NUMBER_TABLE
72: , a1 JTF_NUMBER_TABLE
73: , a2 JTF_VARCHAR2_TABLE_100
74: , a3 JTF_VARCHAR2_TABLE_2000
75: , a4 JTF_VARCHAR2_TABLE_100

Line 72: , a1 JTF_NUMBER_TABLE

68: end if;
69: end rosetta_table_copy_out_p1;
70:
71: procedure rosetta_table_copy_in_p5(t out nocopy amv_perspective_pvt.amv_perspective_obj_varray, a0 JTF_NUMBER_TABLE
72: , a1 JTF_NUMBER_TABLE
73: , a2 JTF_VARCHAR2_TABLE_100
74: , a3 JTF_VARCHAR2_TABLE_2000
75: , a4 JTF_VARCHAR2_TABLE_100
76: , a5 JTF_VARCHAR2_TABLE_100

Line 78: , a7 JTF_NUMBER_TABLE

74: , a3 JTF_VARCHAR2_TABLE_2000
75: , a4 JTF_VARCHAR2_TABLE_100
76: , a5 JTF_VARCHAR2_TABLE_100
77: , a6 JTF_DATE_TABLE
78: , a7 JTF_NUMBER_TABLE
79: , a8 JTF_DATE_TABLE
80: , a9 JTF_NUMBER_TABLE
81: , a10 JTF_NUMBER_TABLE
82: ) as

Line 80: , a9 JTF_NUMBER_TABLE

76: , a5 JTF_VARCHAR2_TABLE_100
77: , a6 JTF_DATE_TABLE
78: , a7 JTF_NUMBER_TABLE
79: , a8 JTF_DATE_TABLE
80: , a9 JTF_NUMBER_TABLE
81: , a10 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin

Line 81: , a10 JTF_NUMBER_TABLE

77: , a6 JTF_DATE_TABLE
78: , a7 JTF_NUMBER_TABLE
79: , a8 JTF_DATE_TABLE
80: , a9 JTF_NUMBER_TABLE
81: , a10 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin
85: if a0 is not null and a0.count=0 then

Line 114: procedure rosetta_table_copy_out_p5(t amv_perspective_pvt.amv_perspective_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

110: end loop;
111: end if;
112: end if;
113: end rosetta_table_copy_in_p5;
114: procedure rosetta_table_copy_out_p5(t amv_perspective_pvt.amv_perspective_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
118: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 115: , a1 out nocopy JTF_NUMBER_TABLE

111: end if;
112: end if;
113: end rosetta_table_copy_in_p5;
114: procedure rosetta_table_copy_out_p5(t amv_perspective_pvt.amv_perspective_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
118: , a4 out nocopy JTF_VARCHAR2_TABLE_100
119: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a7 out nocopy JTF_NUMBER_TABLE

117: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
118: , a4 out nocopy JTF_VARCHAR2_TABLE_100
119: , a5 out nocopy JTF_VARCHAR2_TABLE_100
120: , a6 out nocopy JTF_DATE_TABLE
121: , a7 out nocopy JTF_NUMBER_TABLE
122: , a8 out nocopy JTF_DATE_TABLE
123: , a9 out nocopy JTF_NUMBER_TABLE
124: , a10 out nocopy JTF_NUMBER_TABLE
125: ) as

Line 123: , a9 out nocopy JTF_NUMBER_TABLE

119: , a5 out nocopy JTF_VARCHAR2_TABLE_100
120: , a6 out nocopy JTF_DATE_TABLE
121: , a7 out nocopy JTF_NUMBER_TABLE
122: , a8 out nocopy JTF_DATE_TABLE
123: , a9 out nocopy JTF_NUMBER_TABLE
124: , a10 out nocopy JTF_NUMBER_TABLE
125: ) as
126: ddindx binary_integer; indx binary_integer;
127: begin

Line 124: , a10 out nocopy JTF_NUMBER_TABLE

120: , a6 out nocopy JTF_DATE_TABLE
121: , a7 out nocopy JTF_NUMBER_TABLE
122: , a8 out nocopy JTF_DATE_TABLE
123: , a9 out nocopy JTF_NUMBER_TABLE
124: , a10 out nocopy JTF_NUMBER_TABLE
125: ) as
126: ddindx binary_integer; indx binary_integer;
127: begin
128: if t is null then

Line 141: a0 := JTF_NUMBER_TABLE();

137: a8 := null;
138: a9 := null;
139: a10 := null;
140: elsif t.count = 0 then
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_2000();
145: a4 := JTF_VARCHAR2_TABLE_100();

Line 142: a1 := JTF_NUMBER_TABLE();

138: a9 := null;
139: a10 := null;
140: elsif t.count = 0 then
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_2000();
145: a4 := JTF_VARCHAR2_TABLE_100();
146: a5 := JTF_VARCHAR2_TABLE_100();

Line 148: a7 := JTF_NUMBER_TABLE();

144: a3 := JTF_VARCHAR2_TABLE_2000();
145: a4 := JTF_VARCHAR2_TABLE_100();
146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_NUMBER_TABLE();
152: else

Line 150: a9 := JTF_NUMBER_TABLE();

146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_NUMBER_TABLE();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();

Line 151: a10 := JTF_NUMBER_TABLE();

147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_NUMBER_TABLE();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_VARCHAR2_TABLE_100();

Line 153: a0 := JTF_NUMBER_TABLE();

149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_NUMBER_TABLE();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_VARCHAR2_TABLE_2000();
157: a4 := JTF_VARCHAR2_TABLE_100();

Line 154: a1 := JTF_NUMBER_TABLE();

150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_NUMBER_TABLE();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_VARCHAR2_TABLE_2000();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_VARCHAR2_TABLE_100();

Line 160: a7 := JTF_NUMBER_TABLE();

156: a3 := JTF_VARCHAR2_TABLE_2000();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_DATE_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_DATE_TABLE();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: if t.count > 0 then

Line 162: a9 := JTF_NUMBER_TABLE();

158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_DATE_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_DATE_TABLE();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);

Line 163: a10 := JTF_NUMBER_TABLE();

159: a6 := JTF_DATE_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_DATE_TABLE();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);
167: a2.extend(t.count);

Line 285: , p11_a0 out nocopy JTF_NUMBER_TABLE

281: , p_persp_description VARCHAR2
282: , p10_a0 out nocopy NUMBER
283: , p10_a1 out nocopy NUMBER
284: , p10_a2 out nocopy NUMBER
285: , p11_a0 out nocopy JTF_NUMBER_TABLE
286: , p11_a1 out nocopy JTF_NUMBER_TABLE
287: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
288: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
289: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 286: , p11_a1 out nocopy JTF_NUMBER_TABLE

282: , p10_a0 out nocopy NUMBER
283: , p10_a1 out nocopy NUMBER
284: , p10_a2 out nocopy NUMBER
285: , p11_a0 out nocopy JTF_NUMBER_TABLE
286: , p11_a1 out nocopy JTF_NUMBER_TABLE
287: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
288: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
289: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
290: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 292: , p11_a7 out nocopy JTF_NUMBER_TABLE

288: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
289: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
290: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
291: , p11_a6 out nocopy JTF_DATE_TABLE
292: , p11_a7 out nocopy JTF_NUMBER_TABLE
293: , p11_a8 out nocopy JTF_DATE_TABLE
294: , p11_a9 out nocopy JTF_NUMBER_TABLE
295: , p11_a10 out nocopy JTF_NUMBER_TABLE
296: , p9_a0 NUMBER := 0-1962.0724

Line 294: , p11_a9 out nocopy JTF_NUMBER_TABLE

290: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
291: , p11_a6 out nocopy JTF_DATE_TABLE
292: , p11_a7 out nocopy JTF_NUMBER_TABLE
293: , p11_a8 out nocopy JTF_DATE_TABLE
294: , p11_a9 out nocopy JTF_NUMBER_TABLE
295: , p11_a10 out nocopy JTF_NUMBER_TABLE
296: , p9_a0 NUMBER := 0-1962.0724
297: , p9_a1 NUMBER := 0-1962.0724
298: , p9_a2 VARCHAR2 := fnd_api.g_miss_char

Line 295: , p11_a10 out nocopy JTF_NUMBER_TABLE

291: , p11_a6 out nocopy JTF_DATE_TABLE
292: , p11_a7 out nocopy JTF_NUMBER_TABLE
293: , p11_a8 out nocopy JTF_DATE_TABLE
294: , p11_a9 out nocopy JTF_NUMBER_TABLE
295: , p11_a10 out nocopy JTF_NUMBER_TABLE
296: , p9_a0 NUMBER := 0-1962.0724
297: , p9_a1 NUMBER := 0-1962.0724
298: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
299: )

Line 376: , p_perspective_array JTF_NUMBER_TABLE

372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p_check_login_user VARCHAR2
375: , p_item_id NUMBER
376: , p_perspective_array JTF_NUMBER_TABLE
377: )
378:
379: as
380: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;

Line 429: , p_perspective_array JTF_NUMBER_TABLE

425: , x_msg_count out nocopy NUMBER
426: , x_msg_data out nocopy VARCHAR2
427: , p_check_login_user VARCHAR2
428: , p_item_id NUMBER
429: , p_perspective_array JTF_NUMBER_TABLE
430: )
431:
432: as
433: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;

Line 482: , p_perspective_array JTF_NUMBER_TABLE

478: , x_msg_count out nocopy NUMBER
479: , x_msg_data out nocopy VARCHAR2
480: , p_check_login_user VARCHAR2
481: , p_item_id NUMBER
482: , p_perspective_array JTF_NUMBER_TABLE
483: )
484:
485: as
486: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;

Line 534: , p8_a0 out nocopy JTF_NUMBER_TABLE

530: , x_msg_count out nocopy NUMBER
531: , x_msg_data out nocopy VARCHAR2
532: , p_check_login_user VARCHAR2
533: , p_item_id NUMBER
534: , p8_a0 out nocopy JTF_NUMBER_TABLE
535: , p8_a1 out nocopy JTF_NUMBER_TABLE
536: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
537: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_2000
538: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 535: , p8_a1 out nocopy JTF_NUMBER_TABLE

531: , x_msg_data out nocopy VARCHAR2
532: , p_check_login_user VARCHAR2
533: , p_item_id NUMBER
534: , p8_a0 out nocopy JTF_NUMBER_TABLE
535: , p8_a1 out nocopy JTF_NUMBER_TABLE
536: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
537: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_2000
538: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
539: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 541: , p8_a7 out nocopy JTF_NUMBER_TABLE

537: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_2000
538: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
539: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
540: , p8_a6 out nocopy JTF_DATE_TABLE
541: , p8_a7 out nocopy JTF_NUMBER_TABLE
542: , p8_a8 out nocopy JTF_DATE_TABLE
543: , p8_a9 out nocopy JTF_NUMBER_TABLE
544: , p8_a10 out nocopy JTF_NUMBER_TABLE
545: )

Line 543: , p8_a9 out nocopy JTF_NUMBER_TABLE

539: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
540: , p8_a6 out nocopy JTF_DATE_TABLE
541: , p8_a7 out nocopy JTF_NUMBER_TABLE
542: , p8_a8 out nocopy JTF_DATE_TABLE
543: , p8_a9 out nocopy JTF_NUMBER_TABLE
544: , p8_a10 out nocopy JTF_NUMBER_TABLE
545: )
546:
547: as

Line 544: , p8_a10 out nocopy JTF_NUMBER_TABLE

540: , p8_a6 out nocopy JTF_DATE_TABLE
541: , p8_a7 out nocopy JTF_NUMBER_TABLE
542: , p8_a8 out nocopy JTF_DATE_TABLE
543: , p8_a9 out nocopy JTF_NUMBER_TABLE
544: , p8_a10 out nocopy JTF_NUMBER_TABLE
545: )
546:
547: as
548: ddx_perspective_obj_varray amv_perspective_pvt.amv_perspective_obj_varray;