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

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy iex_status_rule_pub.status_rule_tbl_type, a0 JTF_NUMBER_TABLE

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 iex_status_rule_pub.status_rule_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE

Line 28: , a6 JTF_NUMBER_TABLE

24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE

Line 30: , a8 JTF_NUMBER_TABLE

26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE

Line 31: , a9 JTF_NUMBER_TABLE

27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: ) as

Line 32: , a10 JTF_NUMBER_TABLE

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: ) as
36: ddindx binary_integer; indx binary_integer;

Line 33: , a11 JTF_NUMBER_TABLE

29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin

Line 34: , a12 JTF_NUMBER_TABLE

30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
38: if a0 is not null and a0.count > 0 then

Line 65: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_VARCHAR2_TABLE_200
68: , a3 out nocopy JTF_DATE_TABLE
69: , a4 out nocopy JTF_DATE_TABLE

Line 71: , a6 out nocopy JTF_NUMBER_TABLE

67: , a2 out nocopy JTF_VARCHAR2_TABLE_200
68: , a3 out nocopy JTF_DATE_TABLE
69: , a4 out nocopy JTF_DATE_TABLE
70: , a5 out nocopy JTF_DATE_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_DATE_TABLE
73: , a8 out nocopy JTF_NUMBER_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE

Line 73: , a8 out nocopy JTF_NUMBER_TABLE

69: , a4 out nocopy JTF_DATE_TABLE
70: , a5 out nocopy JTF_DATE_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_DATE_TABLE
73: , a8 out nocopy JTF_NUMBER_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_NUMBER_TABLE

Line 74: , a9 out nocopy JTF_NUMBER_TABLE

70: , a5 out nocopy JTF_DATE_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_DATE_TABLE
73: , a8 out nocopy JTF_NUMBER_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_NUMBER_TABLE
78: ) as

Line 75: , a10 out nocopy JTF_NUMBER_TABLE

71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_DATE_TABLE
73: , a8 out nocopy JTF_NUMBER_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_NUMBER_TABLE
78: ) as
79: ddindx binary_integer; indx binary_integer;

Line 76: , a11 out nocopy JTF_NUMBER_TABLE

72: , a7 out nocopy JTF_DATE_TABLE
73: , a8 out nocopy JTF_NUMBER_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_NUMBER_TABLE
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin

Line 77: , a12 out nocopy JTF_NUMBER_TABLE

73: , a8 out nocopy JTF_NUMBER_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_NUMBER_TABLE
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then

Line 82: a0 := JTF_NUMBER_TABLE();

78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_200();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_DATE_TABLE();

Line 88: a6 := JTF_NUMBER_TABLE();

84: a2 := JTF_VARCHAR2_TABLE_200();
85: a3 := JTF_DATE_TABLE();
86: a4 := JTF_DATE_TABLE();
87: a5 := JTF_DATE_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();

Line 90: a8 := JTF_NUMBER_TABLE();

86: a4 := JTF_DATE_TABLE();
87: a5 := JTF_DATE_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_NUMBER_TABLE();

Line 91: a9 := JTF_NUMBER_TABLE();

87: a5 := JTF_DATE_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_NUMBER_TABLE();
95: else

Line 92: a10 := JTF_NUMBER_TABLE();

88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_NUMBER_TABLE();
95: else
96: a0 := JTF_NUMBER_TABLE();

Line 93: a11 := JTF_NUMBER_TABLE();

89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_NUMBER_TABLE();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();

Line 94: a12 := JTF_NUMBER_TABLE();

90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_NUMBER_TABLE();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_200();

Line 96: a0 := JTF_NUMBER_TABLE();

92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_NUMBER_TABLE();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_200();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_DATE_TABLE();

Line 102: a6 := JTF_NUMBER_TABLE();

98: a2 := JTF_VARCHAR2_TABLE_200();
99: a3 := JTF_DATE_TABLE();
100: a4 := JTF_DATE_TABLE();
101: a5 := JTF_DATE_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();

Line 104: a8 := JTF_NUMBER_TABLE();

100: a4 := JTF_DATE_TABLE();
101: a5 := JTF_DATE_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_NUMBER_TABLE();

Line 105: a9 := JTF_NUMBER_TABLE();

101: a5 := JTF_DATE_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_NUMBER_TABLE();
109: if t.count > 0 then

Line 106: a10 := JTF_NUMBER_TABLE();

102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_NUMBER_TABLE();
109: if t.count > 0 then
110: a0.extend(t.count);

Line 107: a11 := JTF_NUMBER_TABLE();

103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_NUMBER_TABLE();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);

Line 108: a12 := JTF_NUMBER_TABLE();

104: a8 := JTF_NUMBER_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_NUMBER_TABLE();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);
112: a2.extend(t.count);

Line 149: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE

145: end if;
146: end if;
147: end rosetta_table_copy_out_p1;
148:
149: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE

Line 151: , a2 JTF_NUMBER_TABLE

147: end rosetta_table_copy_out_p1;
148:
149: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_DATE_TABLE
155: , a6 JTF_NUMBER_TABLE

Line 153: , a4 JTF_NUMBER_TABLE

149: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_DATE_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_DATE_TABLE
157: , a8 JTF_NUMBER_TABLE

Line 155: , a6 JTF_NUMBER_TABLE

151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_DATE_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_DATE_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_NUMBER_TABLE

Line 157: , a8 JTF_NUMBER_TABLE

153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_DATE_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_DATE_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_NUMBER_TABLE

Line 158: , a9 JTF_NUMBER_TABLE

154: , a5 JTF_DATE_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_DATE_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_NUMBER_TABLE
162: ) as

Line 159: , a10 JTF_NUMBER_TABLE

155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_DATE_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_NUMBER_TABLE
162: ) as
163: ddindx binary_integer; indx binary_integer;

Line 160: , a11 JTF_NUMBER_TABLE

156: , a7 JTF_DATE_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_NUMBER_TABLE
162: ) as
163: ddindx binary_integer; indx binary_integer;
164: begin

Line 161: , a12 JTF_NUMBER_TABLE

157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_NUMBER_TABLE
162: ) as
163: ddindx binary_integer; indx binary_integer;
164: begin
165: if a0 is not null and a0.count > 0 then

Line 192: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

188: end loop;
189: end if;
190: end if;
191: end rosetta_table_copy_in_p3;
192: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
193: , a1 out nocopy JTF_VARCHAR2_TABLE_100
194: , a2 out nocopy JTF_NUMBER_TABLE
195: , a3 out nocopy JTF_VARCHAR2_TABLE_100
196: , a4 out nocopy JTF_NUMBER_TABLE

Line 194: , a2 out nocopy JTF_NUMBER_TABLE

190: end if;
191: end rosetta_table_copy_in_p3;
192: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
193: , a1 out nocopy JTF_VARCHAR2_TABLE_100
194: , a2 out nocopy JTF_NUMBER_TABLE
195: , a3 out nocopy JTF_VARCHAR2_TABLE_100
196: , a4 out nocopy JTF_NUMBER_TABLE
197: , a5 out nocopy JTF_DATE_TABLE
198: , a6 out nocopy JTF_NUMBER_TABLE

Line 196: , a4 out nocopy JTF_NUMBER_TABLE

192: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
193: , a1 out nocopy JTF_VARCHAR2_TABLE_100
194: , a2 out nocopy JTF_NUMBER_TABLE
195: , a3 out nocopy JTF_VARCHAR2_TABLE_100
196: , a4 out nocopy JTF_NUMBER_TABLE
197: , a5 out nocopy JTF_DATE_TABLE
198: , a6 out nocopy JTF_NUMBER_TABLE
199: , a7 out nocopy JTF_DATE_TABLE
200: , a8 out nocopy JTF_NUMBER_TABLE

Line 198: , a6 out nocopy JTF_NUMBER_TABLE

194: , a2 out nocopy JTF_NUMBER_TABLE
195: , a3 out nocopy JTF_VARCHAR2_TABLE_100
196: , a4 out nocopy JTF_NUMBER_TABLE
197: , a5 out nocopy JTF_DATE_TABLE
198: , a6 out nocopy JTF_NUMBER_TABLE
199: , a7 out nocopy JTF_DATE_TABLE
200: , a8 out nocopy JTF_NUMBER_TABLE
201: , a9 out nocopy JTF_NUMBER_TABLE
202: , a10 out nocopy JTF_NUMBER_TABLE

Line 200: , a8 out nocopy JTF_NUMBER_TABLE

196: , a4 out nocopy JTF_NUMBER_TABLE
197: , a5 out nocopy JTF_DATE_TABLE
198: , a6 out nocopy JTF_NUMBER_TABLE
199: , a7 out nocopy JTF_DATE_TABLE
200: , a8 out nocopy JTF_NUMBER_TABLE
201: , a9 out nocopy JTF_NUMBER_TABLE
202: , a10 out nocopy JTF_NUMBER_TABLE
203: , a11 out nocopy JTF_NUMBER_TABLE
204: , a12 out nocopy JTF_NUMBER_TABLE

Line 201: , a9 out nocopy JTF_NUMBER_TABLE

197: , a5 out nocopy JTF_DATE_TABLE
198: , a6 out nocopy JTF_NUMBER_TABLE
199: , a7 out nocopy JTF_DATE_TABLE
200: , a8 out nocopy JTF_NUMBER_TABLE
201: , a9 out nocopy JTF_NUMBER_TABLE
202: , a10 out nocopy JTF_NUMBER_TABLE
203: , a11 out nocopy JTF_NUMBER_TABLE
204: , a12 out nocopy JTF_NUMBER_TABLE
205: ) as

Line 202: , a10 out nocopy JTF_NUMBER_TABLE

198: , a6 out nocopy JTF_NUMBER_TABLE
199: , a7 out nocopy JTF_DATE_TABLE
200: , a8 out nocopy JTF_NUMBER_TABLE
201: , a9 out nocopy JTF_NUMBER_TABLE
202: , a10 out nocopy JTF_NUMBER_TABLE
203: , a11 out nocopy JTF_NUMBER_TABLE
204: , a12 out nocopy JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;

Line 203: , a11 out nocopy JTF_NUMBER_TABLE

199: , a7 out nocopy JTF_DATE_TABLE
200: , a8 out nocopy JTF_NUMBER_TABLE
201: , a9 out nocopy JTF_NUMBER_TABLE
202: , a10 out nocopy JTF_NUMBER_TABLE
203: , a11 out nocopy JTF_NUMBER_TABLE
204: , a12 out nocopy JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin

Line 204: , a12 out nocopy JTF_NUMBER_TABLE

200: , a8 out nocopy JTF_NUMBER_TABLE
201: , a9 out nocopy JTF_NUMBER_TABLE
202: , a10 out nocopy JTF_NUMBER_TABLE
203: , a11 out nocopy JTF_NUMBER_TABLE
204: , a12 out nocopy JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then

Line 209: a0 := JTF_NUMBER_TABLE();

205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_100();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();

Line 211: a2 := JTF_NUMBER_TABLE();

207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_100();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_DATE_TABLE();
215: a6 := JTF_NUMBER_TABLE();

Line 213: a4 := JTF_NUMBER_TABLE();

209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_100();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_DATE_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_DATE_TABLE();
217: a8 := JTF_NUMBER_TABLE();

Line 215: a6 := JTF_NUMBER_TABLE();

211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_DATE_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_DATE_TABLE();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();

Line 217: a8 := JTF_NUMBER_TABLE();

213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_DATE_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_DATE_TABLE();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();

Line 218: a9 := JTF_NUMBER_TABLE();

214: a5 := JTF_DATE_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_DATE_TABLE();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: else

Line 219: a10 := JTF_NUMBER_TABLE();

215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_DATE_TABLE();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: else
223: a0 := JTF_NUMBER_TABLE();

Line 220: a11 := JTF_NUMBER_TABLE();

216: a7 := JTF_DATE_TABLE();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();

Line 221: a12 := JTF_NUMBER_TABLE();

217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();

Line 223: a0 := JTF_NUMBER_TABLE();

219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();

Line 225: a2 := JTF_NUMBER_TABLE();

221: a12 := JTF_NUMBER_TABLE();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();

Line 227: a4 := JTF_NUMBER_TABLE();

223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_DATE_TABLE();
231: a8 := JTF_NUMBER_TABLE();

Line 229: a6 := JTF_NUMBER_TABLE();

225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_DATE_TABLE();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();

Line 231: a8 := JTF_NUMBER_TABLE();

227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_DATE_TABLE();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();

Line 232: a9 := JTF_NUMBER_TABLE();

228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_DATE_TABLE();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();
236: if t.count > 0 then

Line 233: a10 := JTF_NUMBER_TABLE();

229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_DATE_TABLE();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();
236: if t.count > 0 then
237: a0.extend(t.count);

Line 234: a11 := JTF_NUMBER_TABLE();

230: a7 := JTF_DATE_TABLE();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();
236: if t.count > 0 then
237: a0.extend(t.count);
238: a1.extend(t.count);

Line 235: a12 := JTF_NUMBER_TABLE();

231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();
236: if t.count > 0 then
237: a0.extend(t.count);
238: a1.extend(t.count);
239: a2.extend(t.count);

Line 276: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE) as

272: end if;
273: end if;
274: end rosetta_table_copy_out_p3;
275:
276: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE) as
277: ddindx binary_integer; indx binary_integer;
278: begin
279: if a0 is not null and a0.count > 0 then
280: if a0.count > 0 then

Line 294: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

290: end loop;
291: end if;
292: end if;
293: end rosetta_table_copy_in_p4;
294: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
295: ddindx binary_integer; indx binary_integer;
296: begin
297: if t is null or t.count = 0 then
298: a0 := JTF_NUMBER_TABLE();

Line 298: a0 := JTF_NUMBER_TABLE();

294: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
295: ddindx binary_integer; indx binary_integer;
296: begin
297: if t is null or t.count = 0 then
298: a0 := JTF_NUMBER_TABLE();
299: else
300: a0 := JTF_NUMBER_TABLE();
301: if t.count > 0 then
302: a0.extend(t.count);

Line 300: a0 := JTF_NUMBER_TABLE();

296: begin
297: if t is null or t.count = 0 then
298: a0 := JTF_NUMBER_TABLE();
299: else
300: a0 := JTF_NUMBER_TABLE();
301: if t.count > 0 then
302: a0.extend(t.count);
303: ddindx := t.first;
304: indx := 1;

Line 317: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE) as

313: end if;
314: end if;
315: end rosetta_table_copy_out_p4;
316:
317: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE) as
318: ddindx binary_integer; indx binary_integer;
319: begin
320: if a0 is not null and a0.count > 0 then
321: if a0.count > 0 then

Line 335: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

331: end loop;
332: end if;
333: end if;
334: end rosetta_table_copy_in_p5;
335: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();

Line 339: a0 := JTF_NUMBER_TABLE();

335: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: if t.count > 0 then
343: a0.extend(t.count);

Line 341: a0 := JTF_NUMBER_TABLE();

337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: if t.count > 0 then
343: a0.extend(t.count);
344: ddindx := t.first;
345: indx := 1;

Line 434: , p3_a0 JTF_NUMBER_TABLE

430:
431: procedure update_status_rule(p_api_version NUMBER
432: , p_init_msg_list VARCHAR2
433: , p_commit VARCHAR2
434: , p3_a0 JTF_NUMBER_TABLE
435: , p3_a1 JTF_VARCHAR2_TABLE_100
436: , p3_a2 JTF_VARCHAR2_TABLE_200
437: , p3_a3 JTF_DATE_TABLE
438: , p3_a4 JTF_DATE_TABLE

Line 440: , p3_a6 JTF_NUMBER_TABLE

436: , p3_a2 JTF_VARCHAR2_TABLE_200
437: , p3_a3 JTF_DATE_TABLE
438: , p3_a4 JTF_DATE_TABLE
439: , p3_a5 JTF_DATE_TABLE
440: , p3_a6 JTF_NUMBER_TABLE
441: , p3_a7 JTF_DATE_TABLE
442: , p3_a8 JTF_NUMBER_TABLE
443: , p3_a9 JTF_NUMBER_TABLE
444: , p3_a10 JTF_NUMBER_TABLE

Line 442: , p3_a8 JTF_NUMBER_TABLE

438: , p3_a4 JTF_DATE_TABLE
439: , p3_a5 JTF_DATE_TABLE
440: , p3_a6 JTF_NUMBER_TABLE
441: , p3_a7 JTF_DATE_TABLE
442: , p3_a8 JTF_NUMBER_TABLE
443: , p3_a9 JTF_NUMBER_TABLE
444: , p3_a10 JTF_NUMBER_TABLE
445: , p3_a11 JTF_NUMBER_TABLE
446: , p3_a12 JTF_NUMBER_TABLE

Line 443: , p3_a9 JTF_NUMBER_TABLE

439: , p3_a5 JTF_DATE_TABLE
440: , p3_a6 JTF_NUMBER_TABLE
441: , p3_a7 JTF_DATE_TABLE
442: , p3_a8 JTF_NUMBER_TABLE
443: , p3_a9 JTF_NUMBER_TABLE
444: , p3_a10 JTF_NUMBER_TABLE
445: , p3_a11 JTF_NUMBER_TABLE
446: , p3_a12 JTF_NUMBER_TABLE
447: , x_dup_status out nocopy VARCHAR2

Line 444: , p3_a10 JTF_NUMBER_TABLE

440: , p3_a6 JTF_NUMBER_TABLE
441: , p3_a7 JTF_DATE_TABLE
442: , p3_a8 JTF_NUMBER_TABLE
443: , p3_a9 JTF_NUMBER_TABLE
444: , p3_a10 JTF_NUMBER_TABLE
445: , p3_a11 JTF_NUMBER_TABLE
446: , p3_a12 JTF_NUMBER_TABLE
447: , x_dup_status out nocopy VARCHAR2
448: , x_return_status out nocopy VARCHAR2

Line 445: , p3_a11 JTF_NUMBER_TABLE

441: , p3_a7 JTF_DATE_TABLE
442: , p3_a8 JTF_NUMBER_TABLE
443: , p3_a9 JTF_NUMBER_TABLE
444: , p3_a10 JTF_NUMBER_TABLE
445: , p3_a11 JTF_NUMBER_TABLE
446: , p3_a12 JTF_NUMBER_TABLE
447: , x_dup_status out nocopy VARCHAR2
448: , x_return_status out nocopy VARCHAR2
449: , x_msg_count out nocopy NUMBER

Line 446: , p3_a12 JTF_NUMBER_TABLE

442: , p3_a8 JTF_NUMBER_TABLE
443: , p3_a9 JTF_NUMBER_TABLE
444: , p3_a10 JTF_NUMBER_TABLE
445: , p3_a11 JTF_NUMBER_TABLE
446: , p3_a12 JTF_NUMBER_TABLE
447: , x_dup_status out nocopy VARCHAR2
448: , x_return_status out nocopy VARCHAR2
449: , x_msg_count out nocopy NUMBER
450: , x_msg_data out nocopy VARCHAR2

Line 504: , p_status_rule_id_tbl JTF_NUMBER_TABLE

500:
501: procedure delete_status_rule(p_api_version NUMBER
502: , p_init_msg_list VARCHAR2
503: , p_commit VARCHAR2
504: , p_status_rule_id_tbl JTF_NUMBER_TABLE
505: , x_return_status out nocopy VARCHAR2
506: , x_msg_count out nocopy NUMBER
507: , x_msg_data out nocopy VARCHAR2
508: )

Line 610: , p3_a0 JTF_NUMBER_TABLE

606:
607: procedure update_status_rule_line(p_api_version NUMBER
608: , p_init_msg_list VARCHAR2
609: , p_commit VARCHAR2
610: , p3_a0 JTF_NUMBER_TABLE
611: , p3_a1 JTF_VARCHAR2_TABLE_100
612: , p3_a2 JTF_NUMBER_TABLE
613: , p3_a3 JTF_VARCHAR2_TABLE_100
614: , p3_a4 JTF_NUMBER_TABLE

Line 612: , p3_a2 JTF_NUMBER_TABLE

608: , p_init_msg_list VARCHAR2
609: , p_commit VARCHAR2
610: , p3_a0 JTF_NUMBER_TABLE
611: , p3_a1 JTF_VARCHAR2_TABLE_100
612: , p3_a2 JTF_NUMBER_TABLE
613: , p3_a3 JTF_VARCHAR2_TABLE_100
614: , p3_a4 JTF_NUMBER_TABLE
615: , p3_a5 JTF_DATE_TABLE
616: , p3_a6 JTF_NUMBER_TABLE

Line 614: , p3_a4 JTF_NUMBER_TABLE

610: , p3_a0 JTF_NUMBER_TABLE
611: , p3_a1 JTF_VARCHAR2_TABLE_100
612: , p3_a2 JTF_NUMBER_TABLE
613: , p3_a3 JTF_VARCHAR2_TABLE_100
614: , p3_a4 JTF_NUMBER_TABLE
615: , p3_a5 JTF_DATE_TABLE
616: , p3_a6 JTF_NUMBER_TABLE
617: , p3_a7 JTF_DATE_TABLE
618: , p3_a8 JTF_NUMBER_TABLE

Line 616: , p3_a6 JTF_NUMBER_TABLE

612: , p3_a2 JTF_NUMBER_TABLE
613: , p3_a3 JTF_VARCHAR2_TABLE_100
614: , p3_a4 JTF_NUMBER_TABLE
615: , p3_a5 JTF_DATE_TABLE
616: , p3_a6 JTF_NUMBER_TABLE
617: , p3_a7 JTF_DATE_TABLE
618: , p3_a8 JTF_NUMBER_TABLE
619: , p3_a9 JTF_NUMBER_TABLE
620: , p3_a10 JTF_NUMBER_TABLE

Line 618: , p3_a8 JTF_NUMBER_TABLE

614: , p3_a4 JTF_NUMBER_TABLE
615: , p3_a5 JTF_DATE_TABLE
616: , p3_a6 JTF_NUMBER_TABLE
617: , p3_a7 JTF_DATE_TABLE
618: , p3_a8 JTF_NUMBER_TABLE
619: , p3_a9 JTF_NUMBER_TABLE
620: , p3_a10 JTF_NUMBER_TABLE
621: , p3_a11 JTF_NUMBER_TABLE
622: , p3_a12 JTF_NUMBER_TABLE

Line 619: , p3_a9 JTF_NUMBER_TABLE

615: , p3_a5 JTF_DATE_TABLE
616: , p3_a6 JTF_NUMBER_TABLE
617: , p3_a7 JTF_DATE_TABLE
618: , p3_a8 JTF_NUMBER_TABLE
619: , p3_a9 JTF_NUMBER_TABLE
620: , p3_a10 JTF_NUMBER_TABLE
621: , p3_a11 JTF_NUMBER_TABLE
622: , p3_a12 JTF_NUMBER_TABLE
623: , x_dup_status out nocopy VARCHAR2

Line 620: , p3_a10 JTF_NUMBER_TABLE

616: , p3_a6 JTF_NUMBER_TABLE
617: , p3_a7 JTF_DATE_TABLE
618: , p3_a8 JTF_NUMBER_TABLE
619: , p3_a9 JTF_NUMBER_TABLE
620: , p3_a10 JTF_NUMBER_TABLE
621: , p3_a11 JTF_NUMBER_TABLE
622: , p3_a12 JTF_NUMBER_TABLE
623: , x_dup_status out nocopy VARCHAR2
624: , x_return_status out nocopy VARCHAR2

Line 621: , p3_a11 JTF_NUMBER_TABLE

617: , p3_a7 JTF_DATE_TABLE
618: , p3_a8 JTF_NUMBER_TABLE
619: , p3_a9 JTF_NUMBER_TABLE
620: , p3_a10 JTF_NUMBER_TABLE
621: , p3_a11 JTF_NUMBER_TABLE
622: , p3_a12 JTF_NUMBER_TABLE
623: , x_dup_status out nocopy VARCHAR2
624: , x_return_status out nocopy VARCHAR2
625: , x_msg_count out nocopy NUMBER

Line 622: , p3_a12 JTF_NUMBER_TABLE

618: , p3_a8 JTF_NUMBER_TABLE
619: , p3_a9 JTF_NUMBER_TABLE
620: , p3_a10 JTF_NUMBER_TABLE
621: , p3_a11 JTF_NUMBER_TABLE
622: , p3_a12 JTF_NUMBER_TABLE
623: , x_dup_status out nocopy VARCHAR2
624: , x_return_status out nocopy VARCHAR2
625: , x_msg_count out nocopy NUMBER
626: , x_msg_data out nocopy VARCHAR2

Line 681: , p_status_rule_line_id_tbl JTF_NUMBER_TABLE

677: procedure delete_status_rule_line(p_api_version NUMBER
678: , p_init_msg_list VARCHAR2
679: , p_commit VARCHAR2
680: , p_status_rule_id NUMBER
681: , p_status_rule_line_id_tbl JTF_NUMBER_TABLE
682: , x_return_status out nocopy VARCHAR2
683: , x_msg_count out nocopy NUMBER
684: , x_msg_data out nocopy VARCHAR2
685: )