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

Line 71: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

67: end if;
68: end if;
69: end rosetta_table_copy_out_p2;
70:
71: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
72: ddindx binary_integer; indx binary_integer;
73: begin
74: if a0 is null then
75: t := null;

Line 95: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p3;
95: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if t is null then
99: a0 := null;

Line 101: a0 := JTF_NUMBER_TABLE();

97: begin
98: if t is null then
99: a0 := null;
100: elsif t.count = 0 then
101: a0 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);

Line 103: a0 := JTF_NUMBER_TABLE();

99: a0 := null;
100: elsif t.count = 0 then
101: a0 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);
106: ddindx := t.first;
107: indx := 1;

Line 120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE

116: end if;
117: end if;
118: end rosetta_table_copy_out_p3;
119:
120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_NUMBER_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE

Line 121: , a1 JTF_NUMBER_TABLE

117: end if;
118: end rosetta_table_copy_out_p3;
119:
120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_NUMBER_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE
125: , a5 JTF_VARCHAR2_TABLE_100

Line 122: , a2 JTF_NUMBER_TABLE

118: end rosetta_table_copy_out_p3;
119:
120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_NUMBER_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE
125: , a5 JTF_VARCHAR2_TABLE_100
126: , a6 JTF_VARCHAR2_TABLE_2000

Line 123: , a3 JTF_NUMBER_TABLE

119:
120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_NUMBER_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE
125: , a5 JTF_VARCHAR2_TABLE_100
126: , a6 JTF_VARCHAR2_TABLE_2000
127: , a7 JTF_NUMBER_TABLE

Line 124: , a4 JTF_NUMBER_TABLE

120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_NUMBER_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE
125: , a5 JTF_VARCHAR2_TABLE_100
126: , a6 JTF_VARCHAR2_TABLE_2000
127: , a7 JTF_NUMBER_TABLE
128: ) as

Line 127: , a7 JTF_NUMBER_TABLE

123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE
125: , a5 JTF_VARCHAR2_TABLE_100
126: , a6 JTF_VARCHAR2_TABLE_2000
127: , a7 JTF_NUMBER_TABLE
128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin
131: if a0 is not null and a0.count=0 then

Line 157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE

153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p7;
157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE

Line 158: , a1 out nocopy JTF_NUMBER_TABLE

154: end if;
155: end if;
156: end rosetta_table_copy_in_p7;
157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 159: , a2 out nocopy JTF_NUMBER_TABLE

155: end if;
156: end rosetta_table_copy_in_p7;
157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 160: , a3 out nocopy JTF_NUMBER_TABLE

156: end rosetta_table_copy_in_p7;
157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
164: , a7 out nocopy JTF_NUMBER_TABLE

Line 161: , a4 out nocopy JTF_NUMBER_TABLE

157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
164: , a7 out nocopy JTF_NUMBER_TABLE
165: ) as

Line 164: , a7 out nocopy JTF_NUMBER_TABLE

160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
164: , a7 out nocopy JTF_NUMBER_TABLE
165: ) as
166: ddindx binary_integer; indx binary_integer;
167: begin
168: if t is null then

Line 178: a0 := JTF_NUMBER_TABLE();

174: a5 := null;
175: a6 := null;
176: a7 := null;
177: elsif t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();

Line 179: a1 := JTF_NUMBER_TABLE();

175: a6 := null;
176: a7 := null;
177: elsif t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();

Line 180: a2 := JTF_NUMBER_TABLE();

176: a7 := null;
177: elsif t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_2000();

Line 181: a3 := JTF_NUMBER_TABLE();

177: elsif t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();

Line 182: a4 := JTF_NUMBER_TABLE();

178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: else

Line 185: a7 := JTF_NUMBER_TABLE();

181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();

Line 187: a0 := JTF_NUMBER_TABLE();

183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();

Line 188: a1 := JTF_NUMBER_TABLE();

184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();
192: a5 := JTF_VARCHAR2_TABLE_100();

Line 189: a2 := JTF_NUMBER_TABLE();

185: a7 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();
192: a5 := JTF_VARCHAR2_TABLE_100();
193: a6 := JTF_VARCHAR2_TABLE_2000();

Line 190: a3 := JTF_NUMBER_TABLE();

186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();
192: a5 := JTF_VARCHAR2_TABLE_100();
193: a6 := JTF_VARCHAR2_TABLE_2000();
194: a7 := JTF_NUMBER_TABLE();

Line 191: a4 := JTF_NUMBER_TABLE();

187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();
192: a5 := JTF_VARCHAR2_TABLE_100();
193: a6 := JTF_VARCHAR2_TABLE_2000();
194: a7 := JTF_NUMBER_TABLE();
195: if t.count > 0 then

Line 194: a7 := JTF_NUMBER_TABLE();

190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();
192: a5 := JTF_VARCHAR2_TABLE_100();
193: a6 := JTF_VARCHAR2_TABLE_2000();
194: a7 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);
197: a1.extend(t.count);
198: a2.extend(t.count);

Line 225: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE

221: end if;
222: end if;
223: end rosetta_table_copy_out_p7;
224:
225: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
226: , a1 JTF_NUMBER_TABLE
227: , a2 JTF_VARCHAR2_TABLE_300
228: ) as
229: ddindx binary_integer; indx binary_integer;

Line 226: , a1 JTF_NUMBER_TABLE

222: end if;
223: end rosetta_table_copy_out_p7;
224:
225: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
226: , a1 JTF_NUMBER_TABLE
227: , a2 JTF_VARCHAR2_TABLE_300
228: ) as
229: ddindx binary_integer; indx binary_integer;
230: begin

Line 252: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE

248: end loop;
249: end if;
250: end if;
251: end rosetta_table_copy_in_p10;
252: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_300
255: ) as
256: ddindx binary_integer; indx binary_integer;

Line 253: , a1 out nocopy JTF_NUMBER_TABLE

249: end if;
250: end if;
251: end rosetta_table_copy_in_p10;
252: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_300
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin

Line 263: a0 := JTF_NUMBER_TABLE();

259: a0 := null;
260: a1 := null;
261: a2 := null;
262: elsif t.count = 0 then
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_NUMBER_TABLE();
265: a2 := JTF_VARCHAR2_TABLE_300();
266: else
267: a0 := JTF_NUMBER_TABLE();

Line 264: a1 := JTF_NUMBER_TABLE();

260: a1 := null;
261: a2 := null;
262: elsif t.count = 0 then
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_NUMBER_TABLE();
265: a2 := JTF_VARCHAR2_TABLE_300();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();

Line 267: a0 := JTF_NUMBER_TABLE();

263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_NUMBER_TABLE();
265: a2 := JTF_VARCHAR2_TABLE_300();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_VARCHAR2_TABLE_300();
270: if t.count > 0 then
271: a0.extend(t.count);

Line 268: a1 := JTF_NUMBER_TABLE();

264: a1 := JTF_NUMBER_TABLE();
265: a2 := JTF_VARCHAR2_TABLE_300();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_VARCHAR2_TABLE_300();
270: if t.count > 0 then
271: a0.extend(t.count);
272: a1.extend(t.count);

Line 299: , p_category_id_array JTF_NUMBER_TABLE

295: , x_msg_count out nocopy NUMBER
296: , x_msg_data out nocopy VARCHAR2
297: , p_check_login_user VARCHAR2
298: , p_application_id NUMBER
299: , p_category_id_array JTF_NUMBER_TABLE
300: , p_category_new_order JTF_NUMBER_TABLE
301: )
302:
303: as

Line 300: , p_category_new_order JTF_NUMBER_TABLE

296: , x_msg_data out nocopy VARCHAR2
297: , p_check_login_user VARCHAR2
298: , p_application_id NUMBER
299: , p_category_id_array JTF_NUMBER_TABLE
300: , p_category_new_order JTF_NUMBER_TABLE
301: )
302:
303: as
304: ddp_category_id_array amv_category_pvt.amv_number_varray_type;

Line 364: , p14_a0 out nocopy JTF_NUMBER_TABLE

360: , p_ignore_hierarchy VARCHAR2
361: , p13_a0 out nocopy NUMBER
362: , p13_a1 out nocopy NUMBER
363: , p13_a2 out nocopy NUMBER
364: , p14_a0 out nocopy JTF_NUMBER_TABLE
365: , p14_a1 out nocopy JTF_NUMBER_TABLE
366: , p14_a2 out nocopy JTF_NUMBER_TABLE
367: , p14_a3 out nocopy JTF_NUMBER_TABLE
368: , p14_a4 out nocopy JTF_NUMBER_TABLE

Line 365: , p14_a1 out nocopy JTF_NUMBER_TABLE

361: , p13_a0 out nocopy NUMBER
362: , p13_a1 out nocopy NUMBER
363: , p13_a2 out nocopy NUMBER
364: , p14_a0 out nocopy JTF_NUMBER_TABLE
365: , p14_a1 out nocopy JTF_NUMBER_TABLE
366: , p14_a2 out nocopy JTF_NUMBER_TABLE
367: , p14_a3 out nocopy JTF_NUMBER_TABLE
368: , p14_a4 out nocopy JTF_NUMBER_TABLE
369: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 366: , p14_a2 out nocopy JTF_NUMBER_TABLE

362: , p13_a1 out nocopy NUMBER
363: , p13_a2 out nocopy NUMBER
364: , p14_a0 out nocopy JTF_NUMBER_TABLE
365: , p14_a1 out nocopy JTF_NUMBER_TABLE
366: , p14_a2 out nocopy JTF_NUMBER_TABLE
367: , p14_a3 out nocopy JTF_NUMBER_TABLE
368: , p14_a4 out nocopy JTF_NUMBER_TABLE
369: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
370: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 367: , p14_a3 out nocopy JTF_NUMBER_TABLE

363: , p13_a2 out nocopy NUMBER
364: , p14_a0 out nocopy JTF_NUMBER_TABLE
365: , p14_a1 out nocopy JTF_NUMBER_TABLE
366: , p14_a2 out nocopy JTF_NUMBER_TABLE
367: , p14_a3 out nocopy JTF_NUMBER_TABLE
368: , p14_a4 out nocopy JTF_NUMBER_TABLE
369: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
370: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
371: , p14_a7 out nocopy JTF_NUMBER_TABLE

Line 368: , p14_a4 out nocopy JTF_NUMBER_TABLE

364: , p14_a0 out nocopy JTF_NUMBER_TABLE
365: , p14_a1 out nocopy JTF_NUMBER_TABLE
366: , p14_a2 out nocopy JTF_NUMBER_TABLE
367: , p14_a3 out nocopy JTF_NUMBER_TABLE
368: , p14_a4 out nocopy JTF_NUMBER_TABLE
369: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
370: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
371: , p14_a7 out nocopy JTF_NUMBER_TABLE
372: , p12_a0 NUMBER := 0-1962.0724

Line 371: , p14_a7 out nocopy JTF_NUMBER_TABLE

367: , p14_a3 out nocopy JTF_NUMBER_TABLE
368: , p14_a4 out nocopy JTF_NUMBER_TABLE
369: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
370: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
371: , p14_a7 out nocopy JTF_NUMBER_TABLE
372: , p12_a0 NUMBER := 0-1962.0724
373: , p12_a1 NUMBER := 0-1962.0724
374: , p12_a2 VARCHAR2 := fnd_api.g_miss_char
375: )

Line 458: , p9_a0 out nocopy JTF_NUMBER_TABLE

454: , x_msg_data out nocopy VARCHAR2
455: , p_check_login_user VARCHAR2
456: , p_category_id NUMBER
457: , p_include_subcats VARCHAR2
458: , p9_a0 out nocopy JTF_NUMBER_TABLE
459: , p9_a1 out nocopy JTF_NUMBER_TABLE
460: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
461: )
462:

Line 459: , p9_a1 out nocopy JTF_NUMBER_TABLE

455: , p_check_login_user VARCHAR2
456: , p_category_id NUMBER
457: , p_include_subcats VARCHAR2
458: , p9_a0 out nocopy JTF_NUMBER_TABLE
459: , p9_a1 out nocopy JTF_NUMBER_TABLE
460: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
461: )
462:
463: as

Line 516: , p9_a0 out nocopy JTF_NUMBER_TABLE

512: , x_msg_data out nocopy VARCHAR2
513: , p_check_login_user VARCHAR2
514: , p_category_id NUMBER
515: , p_include_subcats VARCHAR2
516: , p9_a0 out nocopy JTF_NUMBER_TABLE
517: , p9_a1 out nocopy JTF_NUMBER_TABLE
518: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
519: )
520:

Line 517: , p9_a1 out nocopy JTF_NUMBER_TABLE

513: , p_check_login_user VARCHAR2
514: , p_category_id NUMBER
515: , p_include_subcats VARCHAR2
516: , p9_a0 out nocopy JTF_NUMBER_TABLE
517: , p9_a1 out nocopy JTF_NUMBER_TABLE
518: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
519: )
520:
521: as

Line 577: , p12_a0 out nocopy JTF_NUMBER_TABLE

573: , p_include_subcats VARCHAR2
574: , p11_a0 out nocopy NUMBER
575: , p11_a1 out nocopy NUMBER
576: , p11_a2 out nocopy NUMBER
577: , p12_a0 out nocopy JTF_NUMBER_TABLE
578: , p12_a1 out nocopy JTF_NUMBER_TABLE
579: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
580: , p9_a0 NUMBER := 0-1962.0724
581: , p9_a1 NUMBER := 0-1962.0724

Line 578: , p12_a1 out nocopy JTF_NUMBER_TABLE

574: , p11_a0 out nocopy NUMBER
575: , p11_a1 out nocopy NUMBER
576: , p11_a2 out nocopy NUMBER
577: , p12_a0 out nocopy JTF_NUMBER_TABLE
578: , p12_a1 out nocopy JTF_NUMBER_TABLE
579: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
580: , p9_a0 NUMBER := 0-1962.0724
581: , p9_a1 NUMBER := 0-1962.0724
582: , p9_a2 VARCHAR2 := fnd_api.g_miss_char

Line 659: , p8_a0 out nocopy JTF_NUMBER_TABLE

655: , x_msg_count out nocopy NUMBER
656: , x_msg_data out nocopy VARCHAR2
657: , p_check_login_user VARCHAR2
658: , p_category_id NUMBER
659: , p8_a0 out nocopy JTF_NUMBER_TABLE
660: , p8_a1 out nocopy JTF_NUMBER_TABLE
661: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
662: )
663:

Line 660: , p8_a1 out nocopy JTF_NUMBER_TABLE

656: , x_msg_data out nocopy VARCHAR2
657: , p_check_login_user VARCHAR2
658: , p_category_id NUMBER
659: , p8_a0 out nocopy JTF_NUMBER_TABLE
660: , p8_a1 out nocopy JTF_NUMBER_TABLE
661: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
662: )
663:
664: as

Line 713: , p8_a0 out nocopy JTF_NUMBER_TABLE

709: , x_msg_count out nocopy NUMBER
710: , x_msg_data out nocopy VARCHAR2
711: , p_check_login_user VARCHAR2
712: , p_category_id NUMBER
713: , p8_a0 out nocopy JTF_NUMBER_TABLE
714: , p8_a1 out nocopy JTF_NUMBER_TABLE
715: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
716: )
717:

Line 714: , p8_a1 out nocopy JTF_NUMBER_TABLE

710: , x_msg_data out nocopy VARCHAR2
711: , p_check_login_user VARCHAR2
712: , p_category_id NUMBER
713: , p8_a0 out nocopy JTF_NUMBER_TABLE
714: , p8_a1 out nocopy JTF_NUMBER_TABLE
715: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
716: )
717:
718: as

Line 768: , p9_a0 out nocopy JTF_NUMBER_TABLE

764: , x_msg_data out nocopy VARCHAR2
765: , p_check_login_user VARCHAR2
766: , p_channel_id NUMBER
767: , x_channel_name out nocopy VARCHAR2
768: , p9_a0 out nocopy JTF_NUMBER_TABLE
769: , p9_a1 out nocopy JTF_NUMBER_TABLE
770: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
771: )
772:

Line 769: , p9_a1 out nocopy JTF_NUMBER_TABLE

765: , p_check_login_user VARCHAR2
766: , p_channel_id NUMBER
767: , x_channel_name out nocopy VARCHAR2
768: , p9_a0 out nocopy JTF_NUMBER_TABLE
769: , p9_a1 out nocopy JTF_NUMBER_TABLE
770: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
771: )
772:
773: as