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

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy eam_workorder_util_pkg.t_bom_table, a0 JTF_NUMBER_TABLE

1: package body eam_workorder_util_pkg_w as
2: /* $Header: EAMVWUPB.pls 120.0.12020000.2 2012/11/07 13:03:35 rsandepo ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy eam_workorder_util_pkg.t_bom_table, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body eam_workorder_util_pkg_w as
2: /* $Header: EAMVWUPB.pls 120.0.12020000.2 2012/11/07 13:03:35 rsandepo ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy eam_workorder_util_pkg.t_bom_table, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p4(t out nocopy eam_workorder_util_pkg.t_bom_table, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: ) as
14: ddindx binary_integer; indx binary_integer;

Line 40: procedure rosetta_table_copy_out_p4(t eam_workorder_util_pkg.t_bom_table, a0 out nocopy JTF_NUMBER_TABLE

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p4;
40: procedure rosetta_table_copy_out_p4(t eam_workorder_util_pkg.t_bom_table, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_300
44: , a4 out nocopy JTF_NUMBER_TABLE

Line 41: , a1 out nocopy JTF_NUMBER_TABLE

37: end if;
38: end if;
39: end rosetta_table_copy_in_p4;
40: procedure rosetta_table_copy_out_p4(t eam_workorder_util_pkg.t_bom_table, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_300
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE

Line 44: , a4 out nocopy JTF_NUMBER_TABLE

40: procedure rosetta_table_copy_out_p4(t eam_workorder_util_pkg.t_bom_table, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_300
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_VARCHAR2_TABLE_100
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a5 out nocopy JTF_NUMBER_TABLE

41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_300
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_VARCHAR2_TABLE_100
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a7 out nocopy JTF_NUMBER_TABLE

43: , a3 out nocopy JTF_VARCHAR2_TABLE_300
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_VARCHAR2_TABLE_100
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_VARCHAR2_TABLE_100
50: ) as
51: ddindx binary_integer; indx binary_integer;

Line 54: a0 := JTF_NUMBER_TABLE();

50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_VARCHAR2_TABLE_100();
57: a3 := JTF_VARCHAR2_TABLE_300();
58: a4 := JTF_NUMBER_TABLE();

Line 55: a1 := JTF_NUMBER_TABLE();

51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_VARCHAR2_TABLE_100();
57: a3 := JTF_VARCHAR2_TABLE_300();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();

Line 58: a4 := JTF_NUMBER_TABLE();

54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_VARCHAR2_TABLE_100();
57: a3 := JTF_VARCHAR2_TABLE_300();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_VARCHAR2_TABLE_100();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_VARCHAR2_TABLE_100();

Line 59: a5 := JTF_NUMBER_TABLE();

55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_VARCHAR2_TABLE_100();
57: a3 := JTF_VARCHAR2_TABLE_300();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_VARCHAR2_TABLE_100();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();

Line 61: a7 := JTF_NUMBER_TABLE();

57: a3 := JTF_VARCHAR2_TABLE_300();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_VARCHAR2_TABLE_100();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();

Line 65: a0 := JTF_NUMBER_TABLE();

61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_VARCHAR2_TABLE_100();
68: a3 := JTF_VARCHAR2_TABLE_300();
69: a4 := JTF_NUMBER_TABLE();

Line 66: a1 := JTF_NUMBER_TABLE();

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

Line 69: a4 := JTF_NUMBER_TABLE();

65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_VARCHAR2_TABLE_100();
68: a3 := JTF_VARCHAR2_TABLE_300();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_VARCHAR2_TABLE_100();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_VARCHAR2_TABLE_100();

Line 70: a5 := JTF_NUMBER_TABLE();

66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_VARCHAR2_TABLE_100();
68: a3 := JTF_VARCHAR2_TABLE_300();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_VARCHAR2_TABLE_100();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_VARCHAR2_TABLE_100();
74: a9 := JTF_VARCHAR2_TABLE_100();

Line 72: a7 := JTF_NUMBER_TABLE();

68: a3 := JTF_VARCHAR2_TABLE_300();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_VARCHAR2_TABLE_100();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_VARCHAR2_TABLE_100();
74: a9 := JTF_VARCHAR2_TABLE_100();
75: if t.count > 0 then
76: a0.extend(t.count);

Line 110: , a1 JTF_NUMBER_TABLE

106: end if;
107: end rosetta_table_copy_out_p4;
108:
109: procedure rosetta_table_copy_in_p5(t out nocopy eam_workorder_util_pkg.t_component_table, a0 JTF_VARCHAR2_TABLE_100
110: , a1 JTF_NUMBER_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_NUMBER_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE

Line 112: , a3 JTF_NUMBER_TABLE

108:
109: procedure rosetta_table_copy_in_p5(t out nocopy eam_workorder_util_pkg.t_component_table, a0 JTF_VARCHAR2_TABLE_100
110: , a1 JTF_NUMBER_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_NUMBER_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_VARCHAR2_TABLE_100
116: , a7 JTF_NUMBER_TABLE

Line 113: , a4 JTF_NUMBER_TABLE

109: procedure rosetta_table_copy_in_p5(t out nocopy eam_workorder_util_pkg.t_component_table, a0 JTF_VARCHAR2_TABLE_100
110: , a1 JTF_NUMBER_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_NUMBER_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_VARCHAR2_TABLE_100
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_VARCHAR2_TABLE_100

Line 114: , a5 JTF_NUMBER_TABLE

110: , a1 JTF_NUMBER_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_NUMBER_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_VARCHAR2_TABLE_100
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_VARCHAR2_TABLE_100
118: ) as

Line 116: , a7 JTF_NUMBER_TABLE

112: , a3 JTF_NUMBER_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_VARCHAR2_TABLE_100
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_VARCHAR2_TABLE_100
118: ) as
119: ddindx binary_integer; indx binary_integer;
120: begin

Line 145: , a1 out nocopy JTF_NUMBER_TABLE

141: end if;
142: end if;
143: end rosetta_table_copy_in_p5;
144: procedure rosetta_table_copy_out_p5(t eam_workorder_util_pkg.t_component_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
145: , a1 out nocopy JTF_NUMBER_TABLE
146: , a2 out nocopy JTF_DATE_TABLE
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_NUMBER_TABLE
149: , a5 out nocopy JTF_NUMBER_TABLE

Line 147: , a3 out nocopy JTF_NUMBER_TABLE

143: end rosetta_table_copy_in_p5;
144: procedure rosetta_table_copy_out_p5(t eam_workorder_util_pkg.t_component_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
145: , a1 out nocopy JTF_NUMBER_TABLE
146: , a2 out nocopy JTF_DATE_TABLE
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_NUMBER_TABLE
149: , a5 out nocopy JTF_NUMBER_TABLE
150: , a6 out nocopy JTF_VARCHAR2_TABLE_100
151: , a7 out nocopy JTF_NUMBER_TABLE

Line 148: , a4 out nocopy JTF_NUMBER_TABLE

144: procedure rosetta_table_copy_out_p5(t eam_workorder_util_pkg.t_component_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
145: , a1 out nocopy JTF_NUMBER_TABLE
146: , a2 out nocopy JTF_DATE_TABLE
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_NUMBER_TABLE
149: , a5 out nocopy JTF_NUMBER_TABLE
150: , a6 out nocopy JTF_VARCHAR2_TABLE_100
151: , a7 out nocopy JTF_NUMBER_TABLE
152: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 149: , a5 out nocopy JTF_NUMBER_TABLE

145: , a1 out nocopy JTF_NUMBER_TABLE
146: , a2 out nocopy JTF_DATE_TABLE
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_NUMBER_TABLE
149: , a5 out nocopy JTF_NUMBER_TABLE
150: , a6 out nocopy JTF_VARCHAR2_TABLE_100
151: , a7 out nocopy JTF_NUMBER_TABLE
152: , a8 out nocopy JTF_VARCHAR2_TABLE_100
153: ) as

Line 151: , a7 out nocopy JTF_NUMBER_TABLE

147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_NUMBER_TABLE
149: , a5 out nocopy JTF_NUMBER_TABLE
150: , a6 out nocopy JTF_VARCHAR2_TABLE_100
151: , a7 out nocopy JTF_NUMBER_TABLE
152: , a8 out nocopy JTF_VARCHAR2_TABLE_100
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin

Line 158: a1 := JTF_NUMBER_TABLE();

154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_VARCHAR2_TABLE_100();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_DATE_TABLE();
160: a3 := JTF_NUMBER_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();

Line 160: a3 := JTF_NUMBER_TABLE();

156: if t is null or t.count = 0 then
157: a0 := JTF_VARCHAR2_TABLE_100();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_DATE_TABLE();
160: a3 := JTF_NUMBER_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();
163: a6 := JTF_VARCHAR2_TABLE_100();
164: a7 := JTF_NUMBER_TABLE();

Line 161: a4 := JTF_NUMBER_TABLE();

157: a0 := JTF_VARCHAR2_TABLE_100();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_DATE_TABLE();
160: a3 := JTF_NUMBER_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();
163: a6 := JTF_VARCHAR2_TABLE_100();
164: a7 := JTF_NUMBER_TABLE();
165: a8 := JTF_VARCHAR2_TABLE_100();

Line 162: a5 := JTF_NUMBER_TABLE();

158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_DATE_TABLE();
160: a3 := JTF_NUMBER_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();
163: a6 := JTF_VARCHAR2_TABLE_100();
164: a7 := JTF_NUMBER_TABLE();
165: a8 := JTF_VARCHAR2_TABLE_100();
166: else

Line 164: a7 := JTF_NUMBER_TABLE();

160: a3 := JTF_NUMBER_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();
163: a6 := JTF_VARCHAR2_TABLE_100();
164: a7 := JTF_NUMBER_TABLE();
165: a8 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_VARCHAR2_TABLE_100();
168: a1 := JTF_NUMBER_TABLE();

Line 168: a1 := JTF_NUMBER_TABLE();

164: a7 := JTF_NUMBER_TABLE();
165: a8 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_VARCHAR2_TABLE_100();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_DATE_TABLE();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();

Line 170: a3 := JTF_NUMBER_TABLE();

166: else
167: a0 := JTF_VARCHAR2_TABLE_100();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_DATE_TABLE();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_NUMBER_TABLE();

Line 171: a4 := JTF_NUMBER_TABLE();

167: a0 := JTF_VARCHAR2_TABLE_100();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_DATE_TABLE();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();

Line 172: a5 := JTF_NUMBER_TABLE();

168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_DATE_TABLE();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: if t.count > 0 then

Line 174: a7 := JTF_NUMBER_TABLE();

170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: if t.count > 0 then
177: a0.extend(t.count);
178: a1.extend(t.count);

Line 208: procedure rosetta_table_copy_in_p6(t out nocopy eam_workorder_util_pkg.t_optime_table, a0 JTF_NUMBER_TABLE

204: end if;
205: end if;
206: end rosetta_table_copy_out_p5;
207:
208: procedure rosetta_table_copy_in_p6(t out nocopy eam_workorder_util_pkg.t_optime_table, a0 JTF_NUMBER_TABLE
209: , a1 JTF_NUMBER_TABLE
210: ) as
211: ddindx binary_integer; indx binary_integer;
212: begin

Line 209: , a1 JTF_NUMBER_TABLE

205: end if;
206: end rosetta_table_copy_out_p5;
207:
208: procedure rosetta_table_copy_in_p6(t out nocopy eam_workorder_util_pkg.t_optime_table, a0 JTF_NUMBER_TABLE
209: , a1 JTF_NUMBER_TABLE
210: ) as
211: ddindx binary_integer; indx binary_integer;
212: begin
213: if a0 is not null and a0.count > 0 then

Line 229: procedure rosetta_table_copy_out_p6(t eam_workorder_util_pkg.t_optime_table, a0 out nocopy JTF_NUMBER_TABLE

225: end loop;
226: end if;
227: end if;
228: end rosetta_table_copy_in_p6;
229: procedure rosetta_table_copy_out_p6(t eam_workorder_util_pkg.t_optime_table, a0 out nocopy JTF_NUMBER_TABLE
230: , a1 out nocopy JTF_NUMBER_TABLE
231: ) as
232: ddindx binary_integer; indx binary_integer;
233: begin

Line 230: , a1 out nocopy JTF_NUMBER_TABLE

226: end if;
227: end if;
228: end rosetta_table_copy_in_p6;
229: procedure rosetta_table_copy_out_p6(t eam_workorder_util_pkg.t_optime_table, a0 out nocopy JTF_NUMBER_TABLE
230: , a1 out nocopy JTF_NUMBER_TABLE
231: ) as
232: ddindx binary_integer; indx binary_integer;
233: begin
234: if t is null or t.count = 0 then

Line 235: a0 := JTF_NUMBER_TABLE();

231: ) as
232: ddindx binary_integer; indx binary_integer;
233: begin
234: if t is null or t.count = 0 then
235: a0 := JTF_NUMBER_TABLE();
236: a1 := JTF_NUMBER_TABLE();
237: else
238: a0 := JTF_NUMBER_TABLE();
239: a1 := JTF_NUMBER_TABLE();

Line 236: a1 := JTF_NUMBER_TABLE();

232: ddindx binary_integer; indx binary_integer;
233: begin
234: if t is null or t.count = 0 then
235: a0 := JTF_NUMBER_TABLE();
236: a1 := JTF_NUMBER_TABLE();
237: else
238: a0 := JTF_NUMBER_TABLE();
239: a1 := JTF_NUMBER_TABLE();
240: if t.count > 0 then

Line 238: a0 := JTF_NUMBER_TABLE();

234: if t is null or t.count = 0 then
235: a0 := JTF_NUMBER_TABLE();
236: a1 := JTF_NUMBER_TABLE();
237: else
238: a0 := JTF_NUMBER_TABLE();
239: a1 := JTF_NUMBER_TABLE();
240: if t.count > 0 then
241: a0.extend(t.count);
242: a1.extend(t.count);

Line 239: a1 := JTF_NUMBER_TABLE();

235: a0 := JTF_NUMBER_TABLE();
236: a1 := JTF_NUMBER_TABLE();
237: else
238: a0 := JTF_NUMBER_TABLE();
239: a1 := JTF_NUMBER_TABLE();
240: if t.count > 0 then
241: a0.extend(t.count);
242: a1.extend(t.count);
243: ddindx := t.first;

Line 258: procedure rosetta_table_copy_in_p7(t out nocopy eam_workorder_util_pkg.t_workflow_table, a0 JTF_NUMBER_TABLE

254: end if;
255: end if;
256: end rosetta_table_copy_out_p6;
257:
258: procedure rosetta_table_copy_in_p7(t out nocopy eam_workorder_util_pkg.t_workflow_table, a0 JTF_NUMBER_TABLE
259: , a1 JTF_VARCHAR2_TABLE_400
260: , a2 JTF_VARCHAR2_TABLE_100
261: , a3 JTF_DATE_TABLE
262: , a4 JTF_VARCHAR2_TABLE_300

Line 289: procedure rosetta_table_copy_out_p7(t eam_workorder_util_pkg.t_workflow_table, a0 out nocopy JTF_NUMBER_TABLE

285: end loop;
286: end if;
287: end if;
288: end rosetta_table_copy_in_p7;
289: procedure rosetta_table_copy_out_p7(t eam_workorder_util_pkg.t_workflow_table, a0 out nocopy JTF_NUMBER_TABLE
290: , a1 out nocopy JTF_VARCHAR2_TABLE_400
291: , a2 out nocopy JTF_VARCHAR2_TABLE_100
292: , a3 out nocopy JTF_DATE_TABLE
293: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 300: a0 := JTF_NUMBER_TABLE();

296: ) as
297: ddindx binary_integer; indx binary_integer;
298: begin
299: if t is null or t.count = 0 then
300: a0 := JTF_NUMBER_TABLE();
301: a1 := JTF_VARCHAR2_TABLE_400();
302: a2 := JTF_VARCHAR2_TABLE_100();
303: a3 := JTF_DATE_TABLE();
304: a4 := JTF_VARCHAR2_TABLE_300();

Line 308: a0 := JTF_NUMBER_TABLE();

304: a4 := JTF_VARCHAR2_TABLE_300();
305: a5 := JTF_VARCHAR2_TABLE_100();
306: a6 := JTF_VARCHAR2_TABLE_4000();
307: else
308: a0 := JTF_NUMBER_TABLE();
309: a1 := JTF_VARCHAR2_TABLE_400();
310: a2 := JTF_VARCHAR2_TABLE_100();
311: a3 := JTF_DATE_TABLE();
312: a4 := JTF_VARCHAR2_TABLE_300();

Line 343: procedure rosetta_table_copy_in_p30(t out nocopy eam_workorder_util_pkg.replace_rebuild_tbl_type, a0 JTF_NUMBER_TABLE

339: end if;
340: end if;
341: end rosetta_table_copy_out_p7;
342:
343: procedure rosetta_table_copy_in_p30(t out nocopy eam_workorder_util_pkg.replace_rebuild_tbl_type, a0 JTF_NUMBER_TABLE
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin
347: if a0 is not null and a0.count > 0 then

Line 362: procedure rosetta_table_copy_out_p30(t eam_workorder_util_pkg.replace_rebuild_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

358: end loop;
359: end if;
360: end if;
361: end rosetta_table_copy_in_p30;
362: procedure rosetta_table_copy_out_p30(t eam_workorder_util_pkg.replace_rebuild_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
363: ) as
364: ddindx binary_integer; indx binary_integer;
365: begin
366: if t is null or t.count = 0 then

Line 367: a0 := JTF_NUMBER_TABLE();

363: ) as
364: ddindx binary_integer; indx binary_integer;
365: begin
366: if t is null or t.count = 0 then
367: a0 := JTF_NUMBER_TABLE();
368: else
369: a0 := JTF_NUMBER_TABLE();
370: if t.count > 0 then
371: a0.extend(t.count);

Line 369: a0 := JTF_NUMBER_TABLE();

365: begin
366: if t is null or t.count = 0 then
367: a0 := JTF_NUMBER_TABLE();
368: else
369: a0 := JTF_NUMBER_TABLE();
370: if t.count > 0 then
371: a0.extend(t.count);
372: ddindx := t.first;
373: indx := 1;

Line 390: , p4_a0 out nocopy JTF_NUMBER_TABLE

386: procedure retrieve_asset_bom(i_organization_id NUMBER
387: , i_asset_number VARCHAR2
388: , i_asset_group_id NUMBER
389: , p_context VARCHAR2
390: , p4_a0 out nocopy JTF_NUMBER_TABLE
391: , p4_a1 out nocopy JTF_NUMBER_TABLE
392: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
394: , p4_a4 out nocopy JTF_NUMBER_TABLE

Line 391: , p4_a1 out nocopy JTF_NUMBER_TABLE

387: , i_asset_number VARCHAR2
388: , i_asset_group_id NUMBER
389: , p_context VARCHAR2
390: , p4_a0 out nocopy JTF_NUMBER_TABLE
391: , p4_a1 out nocopy JTF_NUMBER_TABLE
392: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
394: , p4_a4 out nocopy JTF_NUMBER_TABLE
395: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 394: , p4_a4 out nocopy JTF_NUMBER_TABLE

390: , p4_a0 out nocopy JTF_NUMBER_TABLE
391: , p4_a1 out nocopy JTF_NUMBER_TABLE
392: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
394: , p4_a4 out nocopy JTF_NUMBER_TABLE
395: , p4_a5 out nocopy JTF_NUMBER_TABLE
396: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a7 out nocopy JTF_NUMBER_TABLE
398: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 395: , p4_a5 out nocopy JTF_NUMBER_TABLE

391: , p4_a1 out nocopy JTF_NUMBER_TABLE
392: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
394: , p4_a4 out nocopy JTF_NUMBER_TABLE
395: , p4_a5 out nocopy JTF_NUMBER_TABLE
396: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a7 out nocopy JTF_NUMBER_TABLE
398: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 397: , p4_a7 out nocopy JTF_NUMBER_TABLE

393: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
394: , p4_a4 out nocopy JTF_NUMBER_TABLE
395: , p4_a5 out nocopy JTF_NUMBER_TABLE
396: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a7 out nocopy JTF_NUMBER_TABLE
398: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , o_error_code out nocopy NUMBER
401: )

Line 447: , p4_a1 JTF_NUMBER_TABLE

443: , i_organization_code VARCHAR2
444: , i_asset_number VARCHAR2
445: , i_asset_group_id NUMBER
446: , p4_a0 JTF_VARCHAR2_TABLE_100
447: , p4_a1 JTF_NUMBER_TABLE
448: , p4_a2 JTF_DATE_TABLE
449: , p4_a3 JTF_NUMBER_TABLE
450: , p4_a4 JTF_NUMBER_TABLE
451: , p4_a5 JTF_NUMBER_TABLE

Line 449: , p4_a3 JTF_NUMBER_TABLE

445: , i_asset_group_id NUMBER
446: , p4_a0 JTF_VARCHAR2_TABLE_100
447: , p4_a1 JTF_NUMBER_TABLE
448: , p4_a2 JTF_DATE_TABLE
449: , p4_a3 JTF_NUMBER_TABLE
450: , p4_a4 JTF_NUMBER_TABLE
451: , p4_a5 JTF_NUMBER_TABLE
452: , p4_a6 JTF_VARCHAR2_TABLE_100
453: , p4_a7 JTF_NUMBER_TABLE

Line 450: , p4_a4 JTF_NUMBER_TABLE

446: , p4_a0 JTF_VARCHAR2_TABLE_100
447: , p4_a1 JTF_NUMBER_TABLE
448: , p4_a2 JTF_DATE_TABLE
449: , p4_a3 JTF_NUMBER_TABLE
450: , p4_a4 JTF_NUMBER_TABLE
451: , p4_a5 JTF_NUMBER_TABLE
452: , p4_a6 JTF_VARCHAR2_TABLE_100
453: , p4_a7 JTF_NUMBER_TABLE
454: , p4_a8 JTF_VARCHAR2_TABLE_100

Line 451: , p4_a5 JTF_NUMBER_TABLE

447: , p4_a1 JTF_NUMBER_TABLE
448: , p4_a2 JTF_DATE_TABLE
449: , p4_a3 JTF_NUMBER_TABLE
450: , p4_a4 JTF_NUMBER_TABLE
451: , p4_a5 JTF_NUMBER_TABLE
452: , p4_a6 JTF_VARCHAR2_TABLE_100
453: , p4_a7 JTF_NUMBER_TABLE
454: , p4_a8 JTF_VARCHAR2_TABLE_100
455: , o_error_code out nocopy NUMBER

Line 453: , p4_a7 JTF_NUMBER_TABLE

449: , p4_a3 JTF_NUMBER_TABLE
450: , p4_a4 JTF_NUMBER_TABLE
451: , p4_a5 JTF_NUMBER_TABLE
452: , p4_a6 JTF_VARCHAR2_TABLE_100
453: , p4_a7 JTF_NUMBER_TABLE
454: , p4_a8 JTF_VARCHAR2_TABLE_100
455: , o_error_code out nocopy NUMBER
456: )
457:

Line 497: , p1_a0 JTF_NUMBER_TABLE

493:
494: end;
495:
496: procedure adjust_operations(i_wip_entity_id NUMBER
497: , p1_a0 JTF_NUMBER_TABLE
498: , p1_a1 JTF_NUMBER_TABLE
499: )
500:
501: as

Line 498: , p1_a1 JTF_NUMBER_TABLE

494: end;
495:
496: procedure adjust_operations(i_wip_entity_id NUMBER
497: , p1_a0 JTF_NUMBER_TABLE
498: , p1_a1 JTF_NUMBER_TABLE
499: )
500:
501: as
502: ddi_operation_table eam_workorder_util_pkg.t_optime_table;

Line 545: , p2_a0 out nocopy JTF_NUMBER_TABLE

541: end;
542:
543: procedure get_workflow_details(p_item_type VARCHAR2
544: , p_item_key VARCHAR2
545: , p2_a0 out nocopy JTF_NUMBER_TABLE
546: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_400
547: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
548: , p2_a3 out nocopy JTF_DATE_TABLE
549: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 583: , p2_a0 out nocopy JTF_NUMBER_TABLE

579: end;
580:
581: procedure get_replaced_rebuilds(p_wip_entity_id NUMBER
582: , p_organization_id NUMBER
583: , p2_a0 out nocopy JTF_NUMBER_TABLE
584: , x_return_status out nocopy VARCHAR2
585: , x_error_message out nocopy VARCHAR2
586: )
587: