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.IEM_SERVICEREQUEST_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_VARCHAR2_TABLE_100

12:
13: procedure rosetta_table_copy_in_p4(t out nocopy iem_servicerequest_pvt.notes_table, a0 JTF_VARCHAR2_TABLE_2000
14: , a1 JTF_VARCHAR2_TABLE_32767
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100

Line 18: , a5 JTF_VARCHAR2_TABLE_100

14: , a1 JTF_VARCHAR2_TABLE_32767
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: ) as

Line 20: , a7 JTF_VARCHAR2_TABLE_100

16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin

Line 51: , a3 out nocopy JTF_VARCHAR2_TABLE_100

47: end rosetta_table_copy_in_p4;
48: procedure rosetta_table_copy_out_p4(t iem_servicerequest_pvt.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
50: , a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a5 out nocopy JTF_VARCHAR2_TABLE_100

49: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
50: , a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_NUMBER_TABLE
57: ) as

Line 55: , a7 out nocopy JTF_VARCHAR2_TABLE_100

51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_NUMBER_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 64: a3 := JTF_VARCHAR2_TABLE_100();

60: if t is null or t.count = 0 then
61: a0 := JTF_VARCHAR2_TABLE_2000();
62: a1 := JTF_VARCHAR2_TABLE_32767();
63: a2 := JTF_VARCHAR2_TABLE_300();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();

Line 66: a5 := JTF_VARCHAR2_TABLE_100();

62: a1 := JTF_VARCHAR2_TABLE_32767();
63: a2 := JTF_VARCHAR2_TABLE_300();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();
69: a8 := JTF_NUMBER_TABLE();
70: else

Line 68: a7 := JTF_VARCHAR2_TABLE_100();

64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();
69: a8 := JTF_NUMBER_TABLE();
70: else
71: a0 := JTF_VARCHAR2_TABLE_2000();
72: a1 := JTF_VARCHAR2_TABLE_32767();

Line 74: a3 := JTF_VARCHAR2_TABLE_100();

70: else
71: a0 := JTF_VARCHAR2_TABLE_2000();
72: a1 := JTF_VARCHAR2_TABLE_32767();
73: a2 := JTF_VARCHAR2_TABLE_300();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_NUMBER_TABLE();
76: a5 := JTF_VARCHAR2_TABLE_100();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_VARCHAR2_TABLE_100();

Line 76: a5 := JTF_VARCHAR2_TABLE_100();

72: a1 := JTF_VARCHAR2_TABLE_32767();
73: a2 := JTF_VARCHAR2_TABLE_300();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_NUMBER_TABLE();
76: a5 := JTF_VARCHAR2_TABLE_100();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_VARCHAR2_TABLE_100();
79: a8 := JTF_NUMBER_TABLE();
80: if t.count > 0 then

Line 78: a7 := JTF_VARCHAR2_TABLE_100();

74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_NUMBER_TABLE();
76: a5 := JTF_VARCHAR2_TABLE_100();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_VARCHAR2_TABLE_100();
79: a8 := JTF_NUMBER_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);

Line 115: , a3 JTF_VARCHAR2_TABLE_100

111:
112: procedure rosetta_table_copy_in_p6(t out nocopy iem_servicerequest_pvt.contacts_table, a0 JTF_NUMBER_TABLE
113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_NUMBER_TABLE
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: ) as
119: ddindx binary_integer; indx binary_integer;

Line 116: , a4 JTF_VARCHAR2_TABLE_100

112: procedure rosetta_table_copy_in_p6(t out nocopy iem_servicerequest_pvt.contacts_table, a0 JTF_NUMBER_TABLE
113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_NUMBER_TABLE
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: ) as
119: ddindx binary_integer; indx binary_integer;
120: begin

Line 117: , a5 JTF_VARCHAR2_TABLE_100

113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_NUMBER_TABLE
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: ) as
119: ddindx binary_integer; indx binary_integer;
120: begin
121: if a0 is not null and a0.count > 0 then

Line 144: , a3 out nocopy JTF_VARCHAR2_TABLE_100

140: end rosetta_table_copy_in_p6;
141: procedure rosetta_table_copy_out_p6(t iem_servicerequest_pvt.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
142: , a1 out nocopy JTF_NUMBER_TABLE
143: , a2 out nocopy JTF_NUMBER_TABLE
144: , a3 out nocopy JTF_VARCHAR2_TABLE_100
145: , a4 out nocopy JTF_VARCHAR2_TABLE_100
146: , a5 out nocopy JTF_VARCHAR2_TABLE_100
147: ) as
148: ddindx binary_integer; indx binary_integer;

Line 145: , a4 out nocopy JTF_VARCHAR2_TABLE_100

141: procedure rosetta_table_copy_out_p6(t iem_servicerequest_pvt.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
142: , a1 out nocopy JTF_NUMBER_TABLE
143: , a2 out nocopy JTF_NUMBER_TABLE
144: , a3 out nocopy JTF_VARCHAR2_TABLE_100
145: , a4 out nocopy JTF_VARCHAR2_TABLE_100
146: , a5 out nocopy JTF_VARCHAR2_TABLE_100
147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin

Line 146: , a5 out nocopy JTF_VARCHAR2_TABLE_100

142: , a1 out nocopy JTF_NUMBER_TABLE
143: , a2 out nocopy JTF_NUMBER_TABLE
144: , a3 out nocopy JTF_VARCHAR2_TABLE_100
145: , a4 out nocopy JTF_VARCHAR2_TABLE_100
146: , a5 out nocopy JTF_VARCHAR2_TABLE_100
147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin
150: if t is null or t.count = 0 then

Line 154: a3 := JTF_VARCHAR2_TABLE_100();

150: if t is null or t.count = 0 then
151: a0 := JTF_NUMBER_TABLE();
152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_NUMBER_TABLE();
154: a3 := JTF_VARCHAR2_TABLE_100();
155: a4 := JTF_VARCHAR2_TABLE_100();
156: a5 := JTF_VARCHAR2_TABLE_100();
157: else
158: a0 := JTF_NUMBER_TABLE();

Line 155: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 156: a5 := JTF_VARCHAR2_TABLE_100();

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

Line 161: a3 := JTF_VARCHAR2_TABLE_100();

157: else
158: a0 := JTF_NUMBER_TABLE();
159: a1 := JTF_NUMBER_TABLE();
160: a2 := JTF_NUMBER_TABLE();
161: a3 := JTF_VARCHAR2_TABLE_100();
162: a4 := JTF_VARCHAR2_TABLE_100();
163: a5 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);

Line 162: a4 := JTF_VARCHAR2_TABLE_100();

158: a0 := JTF_NUMBER_TABLE();
159: a1 := JTF_NUMBER_TABLE();
160: a2 := JTF_NUMBER_TABLE();
161: a3 := JTF_VARCHAR2_TABLE_100();
162: a4 := JTF_VARCHAR2_TABLE_100();
163: a5 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);

Line 163: a5 := JTF_VARCHAR2_TABLE_100();

159: a1 := JTF_NUMBER_TABLE();
160: a2 := JTF_NUMBER_TABLE();
161: a3 := JTF_VARCHAR2_TABLE_100();
162: a4 := JTF_VARCHAR2_TABLE_100();
163: a5 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);
167: a2.extend(t.count);

Line 332: , p14_a3 JTF_VARCHAR2_TABLE_100

328: , p13_a125 VARCHAR2
329: , p14_a0 JTF_VARCHAR2_TABLE_2000
330: , p14_a1 JTF_VARCHAR2_TABLE_32767
331: , p14_a2 JTF_VARCHAR2_TABLE_300
332: , p14_a3 JTF_VARCHAR2_TABLE_100
333: , p14_a4 JTF_NUMBER_TABLE
334: , p14_a5 JTF_VARCHAR2_TABLE_100
335: , p14_a6 JTF_NUMBER_TABLE
336: , p14_a7 JTF_VARCHAR2_TABLE_100

Line 334: , p14_a5 JTF_VARCHAR2_TABLE_100

330: , p14_a1 JTF_VARCHAR2_TABLE_32767
331: , p14_a2 JTF_VARCHAR2_TABLE_300
332: , p14_a3 JTF_VARCHAR2_TABLE_100
333: , p14_a4 JTF_NUMBER_TABLE
334: , p14_a5 JTF_VARCHAR2_TABLE_100
335: , p14_a6 JTF_NUMBER_TABLE
336: , p14_a7 JTF_VARCHAR2_TABLE_100
337: , p14_a8 JTF_NUMBER_TABLE
338: , p15_a0 JTF_NUMBER_TABLE

Line 336: , p14_a7 JTF_VARCHAR2_TABLE_100

332: , p14_a3 JTF_VARCHAR2_TABLE_100
333: , p14_a4 JTF_NUMBER_TABLE
334: , p14_a5 JTF_VARCHAR2_TABLE_100
335: , p14_a6 JTF_NUMBER_TABLE
336: , p14_a7 JTF_VARCHAR2_TABLE_100
337: , p14_a8 JTF_NUMBER_TABLE
338: , p15_a0 JTF_NUMBER_TABLE
339: , p15_a1 JTF_NUMBER_TABLE
340: , p15_a2 JTF_NUMBER_TABLE

Line 341: , p15_a3 JTF_VARCHAR2_TABLE_100

337: , p14_a8 JTF_NUMBER_TABLE
338: , p15_a0 JTF_NUMBER_TABLE
339: , p15_a1 JTF_NUMBER_TABLE
340: , p15_a2 JTF_NUMBER_TABLE
341: , p15_a3 JTF_VARCHAR2_TABLE_100
342: , p15_a4 JTF_VARCHAR2_TABLE_100
343: , p15_a5 JTF_VARCHAR2_TABLE_100
344: , x_request_id out nocopy NUMBER
345: , x_request_number out nocopy VARCHAR2

Line 342: , p15_a4 JTF_VARCHAR2_TABLE_100

338: , p15_a0 JTF_NUMBER_TABLE
339: , p15_a1 JTF_NUMBER_TABLE
340: , p15_a2 JTF_NUMBER_TABLE
341: , p15_a3 JTF_VARCHAR2_TABLE_100
342: , p15_a4 JTF_VARCHAR2_TABLE_100
343: , p15_a5 JTF_VARCHAR2_TABLE_100
344: , x_request_id out nocopy NUMBER
345: , x_request_number out nocopy VARCHAR2
346: , x_interaction_id out nocopy NUMBER

Line 343: , p15_a5 JTF_VARCHAR2_TABLE_100

339: , p15_a1 JTF_NUMBER_TABLE
340: , p15_a2 JTF_NUMBER_TABLE
341: , p15_a3 JTF_VARCHAR2_TABLE_100
342: , p15_a4 JTF_VARCHAR2_TABLE_100
343: , p15_a5 JTF_VARCHAR2_TABLE_100
344: , x_request_id out nocopy NUMBER
345: , x_request_number out nocopy VARCHAR2
346: , x_interaction_id out nocopy NUMBER
347: , x_workflow_process_id out nocopy NUMBER

Line 709: , p16_a3 JTF_VARCHAR2_TABLE_100

705: , p15_a125 VARCHAR2
706: , p16_a0 JTF_VARCHAR2_TABLE_2000
707: , p16_a1 JTF_VARCHAR2_TABLE_32767
708: , p16_a2 JTF_VARCHAR2_TABLE_300
709: , p16_a3 JTF_VARCHAR2_TABLE_100
710: , p16_a4 JTF_NUMBER_TABLE
711: , p16_a5 JTF_VARCHAR2_TABLE_100
712: , p16_a6 JTF_NUMBER_TABLE
713: , p16_a7 JTF_VARCHAR2_TABLE_100

Line 711: , p16_a5 JTF_VARCHAR2_TABLE_100

707: , p16_a1 JTF_VARCHAR2_TABLE_32767
708: , p16_a2 JTF_VARCHAR2_TABLE_300
709: , p16_a3 JTF_VARCHAR2_TABLE_100
710: , p16_a4 JTF_NUMBER_TABLE
711: , p16_a5 JTF_VARCHAR2_TABLE_100
712: , p16_a6 JTF_NUMBER_TABLE
713: , p16_a7 JTF_VARCHAR2_TABLE_100
714: , p16_a8 JTF_NUMBER_TABLE
715: , p17_a0 JTF_NUMBER_TABLE

Line 713: , p16_a7 JTF_VARCHAR2_TABLE_100

709: , p16_a3 JTF_VARCHAR2_TABLE_100
710: , p16_a4 JTF_NUMBER_TABLE
711: , p16_a5 JTF_VARCHAR2_TABLE_100
712: , p16_a6 JTF_NUMBER_TABLE
713: , p16_a7 JTF_VARCHAR2_TABLE_100
714: , p16_a8 JTF_NUMBER_TABLE
715: , p17_a0 JTF_NUMBER_TABLE
716: , p17_a1 JTF_NUMBER_TABLE
717: , p17_a2 JTF_NUMBER_TABLE

Line 718: , p17_a3 JTF_VARCHAR2_TABLE_100

714: , p16_a8 JTF_NUMBER_TABLE
715: , p17_a0 JTF_NUMBER_TABLE
716: , p17_a1 JTF_NUMBER_TABLE
717: , p17_a2 JTF_NUMBER_TABLE
718: , p17_a3 JTF_VARCHAR2_TABLE_100
719: , p17_a4 JTF_VARCHAR2_TABLE_100
720: , p17_a5 JTF_VARCHAR2_TABLE_100
721: , p_called_by_workflow VARCHAR2
722: , p_workflow_process_id NUMBER

Line 719: , p17_a4 JTF_VARCHAR2_TABLE_100

715: , p17_a0 JTF_NUMBER_TABLE
716: , p17_a1 JTF_NUMBER_TABLE
717: , p17_a2 JTF_NUMBER_TABLE
718: , p17_a3 JTF_VARCHAR2_TABLE_100
719: , p17_a4 JTF_VARCHAR2_TABLE_100
720: , p17_a5 JTF_VARCHAR2_TABLE_100
721: , p_called_by_workflow VARCHAR2
722: , p_workflow_process_id NUMBER
723: , x_workflow_process_id out nocopy NUMBER

Line 720: , p17_a5 JTF_VARCHAR2_TABLE_100

716: , p17_a1 JTF_NUMBER_TABLE
717: , p17_a2 JTF_NUMBER_TABLE
718: , p17_a3 JTF_VARCHAR2_TABLE_100
719: , p17_a4 JTF_VARCHAR2_TABLE_100
720: , p17_a5 JTF_VARCHAR2_TABLE_100
721: , p_called_by_workflow VARCHAR2
722: , p_workflow_process_id NUMBER
723: , x_workflow_process_id out nocopy NUMBER
724: , x_interaction_id out nocopy NUMBER