APPS.IEM_SERVICEREQUEST_PVT_W dependencies on JTF_NUMBER_TABLE

Line 17: , a4 JTF_NUMBER_TABLE

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
21: , a8 JTF_NUMBER_TABLE

Line 19: , a6 JTF_NUMBER_TABLE

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
23: ddindx binary_integer; indx binary_integer;

Line 21: , a8 JTF_NUMBER_TABLE

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

Line 52: , a4 out nocopy JTF_NUMBER_TABLE

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
56: , a8 out nocopy JTF_NUMBER_TABLE

Line 54: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 56: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 65: a4 := JTF_NUMBER_TABLE();

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();
69: a8 := JTF_NUMBER_TABLE();

Line 67: a6 := JTF_NUMBER_TABLE();

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
71: a0 := JTF_VARCHAR2_TABLE_2000();

Line 69: a8 := JTF_NUMBER_TABLE();

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();
73: a2 := JTF_VARCHAR2_TABLE_300();

Line 75: a4 := JTF_NUMBER_TABLE();

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();
79: a8 := JTF_NUMBER_TABLE();

Line 77: a6 := JTF_NUMBER_TABLE();

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

Line 79: a8 := JTF_NUMBER_TABLE();

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

Line 112: procedure rosetta_table_copy_in_p6(t out nocopy iem_servicerequest_pvt.contacts_table, a0 JTF_NUMBER_TABLE

108: end if;
109: end if;
110: end rosetta_table_copy_out_p4;
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

Line 113: , a1 JTF_NUMBER_TABLE

109: end if;
110: end rosetta_table_copy_out_p4;
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

Line 114: , a2 JTF_NUMBER_TABLE

110: end rosetta_table_copy_out_p4;
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

Line 141: procedure rosetta_table_copy_out_p6(t iem_servicerequest_pvt.contacts_table, a0 out nocopy JTF_NUMBER_TABLE

137: end loop;
138: end if;
139: end if;
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

Line 142: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 143: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 151: a0 := JTF_NUMBER_TABLE();

147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin
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();

Line 152: a1 := JTF_NUMBER_TABLE();

148: ddindx binary_integer; indx binary_integer;
149: begin
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();

Line 153: a2 := JTF_NUMBER_TABLE();

149: begin
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

Line 158: a0 := 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();
161: a3 := JTF_VARCHAR2_TABLE_100();
162: a4 := JTF_VARCHAR2_TABLE_100();

Line 159: a1 := JTF_NUMBER_TABLE();

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();
161: a3 := JTF_VARCHAR2_TABLE_100();
162: a4 := JTF_VARCHAR2_TABLE_100();
163: a5 := JTF_VARCHAR2_TABLE_100();

Line 160: a2 := JTF_NUMBER_TABLE();

156: a5 := 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

Line 333: , p14_a4 JTF_NUMBER_TABLE

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
337: , p14_a8 JTF_NUMBER_TABLE

Line 335: , p14_a6 JTF_NUMBER_TABLE

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
339: , p15_a1 JTF_NUMBER_TABLE

Line 337: , p14_a8 JTF_NUMBER_TABLE

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
341: , p15_a3 JTF_VARCHAR2_TABLE_100

Line 338: , p15_a0 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
341: , p15_a3 JTF_VARCHAR2_TABLE_100
342: , p15_a4 JTF_VARCHAR2_TABLE_100

Line 339: , p15_a1 JTF_NUMBER_TABLE

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
341: , p15_a3 JTF_VARCHAR2_TABLE_100
342: , p15_a4 JTF_VARCHAR2_TABLE_100
343: , p15_a5 JTF_VARCHAR2_TABLE_100

Line 340: , p15_a2 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
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

Line 710: , p16_a4 JTF_NUMBER_TABLE

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
714: , p16_a8 JTF_NUMBER_TABLE

Line 712: , p16_a6 JTF_NUMBER_TABLE

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
716: , p17_a1 JTF_NUMBER_TABLE

Line 714: , p16_a8 JTF_NUMBER_TABLE

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
718: , p17_a3 JTF_VARCHAR2_TABLE_100

Line 715: , p17_a0 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
718: , p17_a3 JTF_VARCHAR2_TABLE_100
719: , p17_a4 JTF_VARCHAR2_TABLE_100

Line 716: , p17_a1 JTF_NUMBER_TABLE

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
718: , p17_a3 JTF_VARCHAR2_TABLE_100
719: , p17_a4 JTF_VARCHAR2_TABLE_100
720: , p17_a5 JTF_VARCHAR2_TABLE_100

Line 717: , p17_a2 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
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