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.INV_SERIAL_EO_PVT dependencies on INV_LOT_API_PUB

Line 187: procedure rosetta_table_copy_in_p0(t out nocopy inv_lot_api_pub.char_tbl, a0 JTF_VARCHAR2_TABLE_1000) as

183: mydebug('In g_exc_unexpected_error ' || SQLERRM);
184: END delete_serial;
185:
186:
187: procedure rosetta_table_copy_in_p0(t out nocopy inv_lot_api_pub.char_tbl, a0 JTF_VARCHAR2_TABLE_1000) as
188: ddindx binary_integer; indx binary_integer;
189: begin
190: if a0 is not null and a0.count > 0 then
191: if a0.count > 0 then

Line 205: procedure rosetta_table_copy_out_p0(t inv_lot_api_pub.char_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_1000) as

201: end loop;
202: end if;
203: end if;
204: end rosetta_table_copy_in_p0;
205: procedure rosetta_table_copy_out_p0(t inv_lot_api_pub.char_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_1000) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_VARCHAR2_TABLE_1000();

Line 228: procedure rosetta_table_copy_in_p1(t out nocopy inv_lot_api_pub.number_tbl, a0 JTF_NUMBER_TABLE) as

224: end if;
225: end if;
226: end rosetta_table_copy_out_p0;
227:
228: procedure rosetta_table_copy_in_p1(t out nocopy inv_lot_api_pub.number_tbl, a0 JTF_NUMBER_TABLE) as
229: ddindx binary_integer; indx binary_integer;
230: begin
231: if a0 is not null and a0.count > 0 then
232: if a0.count > 0 then

Line 246: procedure rosetta_table_copy_out_p1(t inv_lot_api_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

242: end loop;
243: end if;
244: end if;
245: end rosetta_table_copy_in_p1;
246: procedure rosetta_table_copy_out_p1(t inv_lot_api_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
247: ddindx binary_integer; indx binary_integer;
248: begin
249: if t is null or t.count = 0 then
250: a0 := JTF_NUMBER_TABLE();

Line 269: procedure rosetta_table_copy_in_p2(t out nocopy inv_lot_api_pub.date_tbl, a0 JTF_DATE_TABLE) as

265: end if;
266: end if;
267: end rosetta_table_copy_out_p1;
268:
269: procedure rosetta_table_copy_in_p2(t out nocopy inv_lot_api_pub.date_tbl, a0 JTF_DATE_TABLE) as
270: ddindx binary_integer; indx binary_integer;
271: begin
272: if a0 is not null and a0.count > 0 then
273: if a0.count > 0 then

Line 287: procedure rosetta_table_copy_out_p2(t inv_lot_api_pub.date_tbl, a0 out nocopy JTF_DATE_TABLE) as

283: end loop;
284: end if;
285: end if;
286: end rosetta_table_copy_in_p2;
287: procedure rosetta_table_copy_out_p2(t inv_lot_api_pub.date_tbl, a0 out nocopy JTF_DATE_TABLE) as
288: ddindx binary_integer; indx binary_integer;
289: begin
290: if t is null or t.count = 0 then
291: a0 := JTF_DATE_TABLE();

Line 364: ddp_attributes_tbl inv_lot_api_pub.char_tbl;

360: , p_territory_code VARCHAR2
361: )
362:
363: as
364: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
365: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
366: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
367: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
368: ddindx binary_integer; indx binary_integer;

Line 365: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;

361: )
362:
363: as
364: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
365: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
366: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
367: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
368: ddindx binary_integer; indx binary_integer;
369: begin

Line 366: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;

362:
363: as
364: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
365: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
366: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
367: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
368: ddindx binary_integer; indx binary_integer;
369: begin
370:

Line 367: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;

363: as
364: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
365: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
366: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
367: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
368: ddindx binary_integer; indx binary_integer;
369: begin
370:
371: -- copy data to the local IN or IN-OUT args, if any

Line 504: ddp_attributes_tbl inv_lot_api_pub.char_tbl;

500: , p_territory_code VARCHAR2
501: )
502:
503: as
504: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
505: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
506: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
507: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
508: ddindx binary_integer; indx binary_integer;

Line 505: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;

501: )
502:
503: as
504: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
505: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
506: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
507: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
508: ddindx binary_integer; indx binary_integer;
509:

Line 506: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;

502:
503: as
504: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
505: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
506: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
507: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
508: ddindx binary_integer; indx binary_integer;
509:
510: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 507: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;

503: as
504: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
505: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
506: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
507: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
508: ddindx binary_integer; indx binary_integer;
509:
510: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
511: l_validation_status VARCHAR2(1);