APPS.AMS_PS_RULE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin
27: if a0 is not null and a0.count > 0 then

Line 43: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p3;
43: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin

Line 44: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100

40: end if;
41: end if;
42: end rosetta_table_copy_in_p3;
43: procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then

Line 49: a0 := JTF_VARCHAR2_TABLE_100();

45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: else
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();

Line 50: a1 := JTF_VARCHAR2_TABLE_100();

46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: else
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: if t.count > 0 then

Line 52: a0 := JTF_VARCHAR2_TABLE_100();

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

Line 53: a1 := JTF_VARCHAR2_TABLE_100();

49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: else
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: if t.count > 0 then
55: a0.extend(t.count);
56: a1.extend(t.count);
57: ddindx := t.first;

Line 83: , a11 JTF_VARCHAR2_TABLE_100

79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100

Line 84: , a12 JTF_VARCHAR2_TABLE_100

80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100

Line 85: , a13 JTF_VARCHAR2_TABLE_100

81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE

Line 87: , a15 JTF_VARCHAR2_TABLE_100

83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100

Line 88: , a16 JTF_VARCHAR2_TABLE_100

84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100

Line 90: , a18 JTF_VARCHAR2_TABLE_100

86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100

Line 91: , a19 JTF_VARCHAR2_TABLE_100

87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100

Line 92: , a20 JTF_VARCHAR2_TABLE_100

88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100

Line 93: , a21 JTF_VARCHAR2_TABLE_100

89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100
97: , a25 JTF_VARCHAR2_TABLE_100

Line 94: , a22 JTF_VARCHAR2_TABLE_100

90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100
97: , a25 JTF_VARCHAR2_TABLE_100
98: , a26 JTF_VARCHAR2_TABLE_100

Line 95: , a23 JTF_VARCHAR2_TABLE_100

91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100
97: , a25 JTF_VARCHAR2_TABLE_100
98: , a26 JTF_VARCHAR2_TABLE_100
99: , a27 JTF_VARCHAR2_TABLE_100

Line 96: , a24 JTF_VARCHAR2_TABLE_100

92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100
97: , a25 JTF_VARCHAR2_TABLE_100
98: , a26 JTF_VARCHAR2_TABLE_100
99: , a27 JTF_VARCHAR2_TABLE_100
100: ) as

Line 97: , a25 JTF_VARCHAR2_TABLE_100

93: , a21 JTF_VARCHAR2_TABLE_100
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100
97: , a25 JTF_VARCHAR2_TABLE_100
98: , a26 JTF_VARCHAR2_TABLE_100
99: , a27 JTF_VARCHAR2_TABLE_100
100: ) as
101: ddindx binary_integer; indx binary_integer;

Line 98: , a26 JTF_VARCHAR2_TABLE_100

94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100
97: , a25 JTF_VARCHAR2_TABLE_100
98: , a26 JTF_VARCHAR2_TABLE_100
99: , a27 JTF_VARCHAR2_TABLE_100
100: ) as
101: ddindx binary_integer; indx binary_integer;
102: begin

Line 99: , a27 JTF_VARCHAR2_TABLE_100

95: , a23 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_100
97: , a25 JTF_VARCHAR2_TABLE_100
98: , a26 JTF_VARCHAR2_TABLE_100
99: , a27 JTF_VARCHAR2_TABLE_100
100: ) as
101: ddindx binary_integer; indx binary_integer;
102: begin
103: if a0 is not null and a0.count > 0 then

Line 156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100

154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE

Line 160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
171: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
171: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
172: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100

165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
171: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
172: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
173: ) as

Line 170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100

166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
171: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
172: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
173: ) as
174: ddindx binary_integer; indx binary_integer;

Line 171: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100

167: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
171: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
172: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin

Line 172: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100

168: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
169: , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
170: , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
171: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
172: , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then

Line 188: a11 := JTF_VARCHAR2_TABLE_100();

184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();

Line 189: a12 := JTF_VARCHAR2_TABLE_100();

185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();

Line 190: a13 := JTF_VARCHAR2_TABLE_100();

186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();

Line 192: a15 := JTF_VARCHAR2_TABLE_100();

188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();

Line 193: a16 := JTF_VARCHAR2_TABLE_100();

189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();

Line 195: a18 := JTF_VARCHAR2_TABLE_100();

191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();

Line 196: a19 := JTF_VARCHAR2_TABLE_100();

192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();

Line 197: a20 := JTF_VARCHAR2_TABLE_100();

193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();

Line 198: a21 := JTF_VARCHAR2_TABLE_100();

194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();

Line 199: a22 := JTF_VARCHAR2_TABLE_100();

195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_VARCHAR2_TABLE_100();

Line 200: a23 := JTF_VARCHAR2_TABLE_100();

196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_VARCHAR2_TABLE_100();
204: a27 := JTF_VARCHAR2_TABLE_100();

Line 201: a24 := JTF_VARCHAR2_TABLE_100();

197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_VARCHAR2_TABLE_100();
204: a27 := JTF_VARCHAR2_TABLE_100();
205: else

Line 202: a25 := JTF_VARCHAR2_TABLE_100();

198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_VARCHAR2_TABLE_100();
204: a27 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();

Line 203: a26 := JTF_VARCHAR2_TABLE_100();

199: a22 := JTF_VARCHAR2_TABLE_100();
200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_VARCHAR2_TABLE_100();
204: a27 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_DATE_TABLE();

Line 204: a27 := JTF_VARCHAR2_TABLE_100();

200: a23 := JTF_VARCHAR2_TABLE_100();
201: a24 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_VARCHAR2_TABLE_100();
204: a27 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_DATE_TABLE();
208: a2 := JTF_NUMBER_TABLE();

Line 217: a11 := JTF_VARCHAR2_TABLE_100();

213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();

Line 218: a12 := JTF_VARCHAR2_TABLE_100();

214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();

Line 219: a13 := JTF_VARCHAR2_TABLE_100();

215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();

Line 221: a15 := JTF_VARCHAR2_TABLE_100();

217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();

Line 222: a16 := JTF_VARCHAR2_TABLE_100();

218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();

Line 224: a18 := JTF_VARCHAR2_TABLE_100();

220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();

Line 225: a19 := JTF_VARCHAR2_TABLE_100();

221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();

Line 226: a20 := JTF_VARCHAR2_TABLE_100();

222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();

Line 227: a21 := JTF_VARCHAR2_TABLE_100();

223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();
231: a25 := JTF_VARCHAR2_TABLE_100();

Line 228: a22 := JTF_VARCHAR2_TABLE_100();

224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();
231: a25 := JTF_VARCHAR2_TABLE_100();
232: a26 := JTF_VARCHAR2_TABLE_100();

Line 229: a23 := JTF_VARCHAR2_TABLE_100();

225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();
231: a25 := JTF_VARCHAR2_TABLE_100();
232: a26 := JTF_VARCHAR2_TABLE_100();
233: a27 := JTF_VARCHAR2_TABLE_100();

Line 230: a24 := JTF_VARCHAR2_TABLE_100();

226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();
231: a25 := JTF_VARCHAR2_TABLE_100();
232: a26 := JTF_VARCHAR2_TABLE_100();
233: a27 := JTF_VARCHAR2_TABLE_100();
234: if t.count > 0 then

Line 231: a25 := JTF_VARCHAR2_TABLE_100();

227: a21 := JTF_VARCHAR2_TABLE_100();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();
231: a25 := JTF_VARCHAR2_TABLE_100();
232: a26 := JTF_VARCHAR2_TABLE_100();
233: a27 := JTF_VARCHAR2_TABLE_100();
234: if t.count > 0 then
235: a0.extend(t.count);

Line 232: a26 := JTF_VARCHAR2_TABLE_100();

228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();
231: a25 := JTF_VARCHAR2_TABLE_100();
232: a26 := JTF_VARCHAR2_TABLE_100();
233: a27 := JTF_VARCHAR2_TABLE_100();
234: if t.count > 0 then
235: a0.extend(t.count);
236: a1.extend(t.count);

Line 233: a27 := JTF_VARCHAR2_TABLE_100();

229: a23 := JTF_VARCHAR2_TABLE_100();
230: a24 := JTF_VARCHAR2_TABLE_100();
231: a25 := JTF_VARCHAR2_TABLE_100();
232: a26 := JTF_VARCHAR2_TABLE_100();
233: a27 := JTF_VARCHAR2_TABLE_100();
234: if t.count > 0 then
235: a0.extend(t.count);
236: a1.extend(t.count);
237: a2.extend(t.count);

Line 441: , p9_a0 JTF_VARCHAR2_TABLE_100

437: , x_msg_data OUT NOCOPY VARCHAR2
438: , p8_a0 NUMBER
439: , p8_a1 NUMBER
440: , p8_a2 NUMBER
441: , p9_a0 JTF_VARCHAR2_TABLE_100
442: , p9_a1 JTF_VARCHAR2_TABLE_100
443: , p10_a0 JTF_VARCHAR2_TABLE_100
444: , p10_a1 JTF_VARCHAR2_TABLE_100
445: , x_object_version_number OUT NOCOPY NUMBER

Line 442: , p9_a1 JTF_VARCHAR2_TABLE_100

438: , p8_a0 NUMBER
439: , p8_a1 NUMBER
440: , p8_a2 NUMBER
441: , p9_a0 JTF_VARCHAR2_TABLE_100
442: , p9_a1 JTF_VARCHAR2_TABLE_100
443: , p10_a0 JTF_VARCHAR2_TABLE_100
444: , p10_a1 JTF_VARCHAR2_TABLE_100
445: , x_object_version_number OUT NOCOPY NUMBER
446: , p7_a0 NUMBER := 0-1962.0724

Line 443: , p10_a0 JTF_VARCHAR2_TABLE_100

439: , p8_a1 NUMBER
440: , p8_a2 NUMBER
441: , p9_a0 JTF_VARCHAR2_TABLE_100
442: , p9_a1 JTF_VARCHAR2_TABLE_100
443: , p10_a0 JTF_VARCHAR2_TABLE_100
444: , p10_a1 JTF_VARCHAR2_TABLE_100
445: , x_object_version_number OUT NOCOPY NUMBER
446: , p7_a0 NUMBER := 0-1962.0724
447: , p7_a1 DATE := fnd_api.g_miss_date

Line 444: , p10_a1 JTF_VARCHAR2_TABLE_100

440: , p8_a2 NUMBER
441: , p9_a0 JTF_VARCHAR2_TABLE_100
442: , p9_a1 JTF_VARCHAR2_TABLE_100
443: , p10_a0 JTF_VARCHAR2_TABLE_100
444: , p10_a1 JTF_VARCHAR2_TABLE_100
445: , x_object_version_number OUT NOCOPY NUMBER
446: , p7_a0 NUMBER := 0-1962.0724
447: , p7_a1 DATE := fnd_api.g_miss_date
448: , p7_a2 NUMBER := 0-1962.0724

Line 586: , p9_a0 JTF_VARCHAR2_TABLE_100

582: , x_msg_data OUT NOCOPY VARCHAR2
583: , p8_a0 NUMBER
584: , p8_a1 NUMBER
585: , p8_a2 NUMBER
586: , p9_a0 JTF_VARCHAR2_TABLE_100
587: , p9_a1 JTF_VARCHAR2_TABLE_100
588: , p10_a0 JTF_VARCHAR2_TABLE_100
589: , p10_a1 JTF_VARCHAR2_TABLE_100
590: , p_vistype_change number

Line 587: , p9_a1 JTF_VARCHAR2_TABLE_100

583: , p8_a0 NUMBER
584: , p8_a1 NUMBER
585: , p8_a2 NUMBER
586: , p9_a0 JTF_VARCHAR2_TABLE_100
587: , p9_a1 JTF_VARCHAR2_TABLE_100
588: , p10_a0 JTF_VARCHAR2_TABLE_100
589: , p10_a1 JTF_VARCHAR2_TABLE_100
590: , p_vistype_change number
591: , p_rem_change number

Line 588: , p10_a0 JTF_VARCHAR2_TABLE_100

584: , p8_a1 NUMBER
585: , p8_a2 NUMBER
586: , p9_a0 JTF_VARCHAR2_TABLE_100
587: , p9_a1 JTF_VARCHAR2_TABLE_100
588: , p10_a0 JTF_VARCHAR2_TABLE_100
589: , p10_a1 JTF_VARCHAR2_TABLE_100
590: , p_vistype_change number
591: , p_rem_change number
592: , x_object_version_number OUT NOCOPY NUMBER

Line 589: , p10_a1 JTF_VARCHAR2_TABLE_100

585: , p8_a2 NUMBER
586: , p9_a0 JTF_VARCHAR2_TABLE_100
587: , p9_a1 JTF_VARCHAR2_TABLE_100
588: , p10_a0 JTF_VARCHAR2_TABLE_100
589: , p10_a1 JTF_VARCHAR2_TABLE_100
590: , p_vistype_change number
591: , p_rem_change number
592: , x_object_version_number OUT NOCOPY NUMBER
593: , p7_a0 NUMBER := 0-1962.0724

Line 1018: , p1_a0 JTF_VARCHAR2_TABLE_100

1014:
1015: end;
1016:
1017: procedure update_filters(p_rulegroup_id NUMBER
1018: , p1_a0 JTF_VARCHAR2_TABLE_100
1019: , p1_a1 JTF_VARCHAR2_TABLE_100
1020: , x_return_status OUT NOCOPY VARCHAR2
1021: )
1022: as

Line 1019: , p1_a1 JTF_VARCHAR2_TABLE_100

1015: end;
1016:
1017: procedure update_filters(p_rulegroup_id NUMBER
1018: , p1_a0 JTF_VARCHAR2_TABLE_100
1019: , p1_a1 JTF_VARCHAR2_TABLE_100
1020: , x_return_status OUT NOCOPY VARCHAR2
1021: )
1022: as
1023: ddp_ps_filter_tbl ams_ps_rule_pvt.ps_rules_tuple_tbl_type;

Line 1045: , p1_a0 JTF_VARCHAR2_TABLE_100

1041:
1042: end;
1043:
1044: procedure update_strategy_params(p_rulegroup_id NUMBER
1045: , p1_a0 JTF_VARCHAR2_TABLE_100
1046: , p1_a1 JTF_VARCHAR2_TABLE_100
1047: , x_return_status OUT NOCOPY VARCHAR2
1048: )
1049: as

Line 1046: , p1_a1 JTF_VARCHAR2_TABLE_100

1042: end;
1043:
1044: procedure update_strategy_params(p_rulegroup_id NUMBER
1045: , p1_a0 JTF_VARCHAR2_TABLE_100
1046: , p1_a1 JTF_VARCHAR2_TABLE_100
1047: , x_return_status OUT NOCOPY VARCHAR2
1048: )
1049: as
1050: ddp_ps_strategy_tbl ams_ps_rule_pvt.ps_rules_tuple_tbl_type;