APPS.WIP_MTL_TXNS_TEMP_CLEANUP dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 473: p_serials in out nocopy wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec) is

469:
470: procedure fetch_and_delete(
471: p_hdr_id in number,
472: p_act_id in number,
473: p_serials in out nocopy wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec) is
474:
475: i number := 0;
476:
477: cursor get_serials(

Line 498: from mtl_serial_numbers_temp

494: to_serial_number,
495: serial_prefix,
496: error_code error_code,
497: group_header_id
498: from mtl_serial_numbers_temp
499: where
500: transaction_temp_id in
501: (select transaction_temp_id
502: from mtl_material_transactions_temp

Line 559: delete from mtl_serial_numbers_temp

555:
556: close get_serials;
557:
558: if (p_serials.numrecs > 0) then
559: delete from mtl_serial_numbers_temp
560: where
561: transaction_temp_id in
562: (select transaction_temp_id
563: from mtl_material_transactions_temp

Line 851: p_serials in out nocopy wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,

847: p_hdr_id in number,
848: p_act_id in number default NULL,
849: p_materials in out nocopy mtl_transactions_temp_rec,
850: p_lots in out nocopy wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
851: p_serials in out nocopy wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
852: p_dyn_serials in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_rec,
853: p_ser_marks in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_mark_rec) is
854: begin
855: -- get marked serial numbers

Line 1232: p_serials in wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,

1228:
1229: procedure insert_rows(
1230: p_materials in mtl_transactions_temp_rec,
1231: p_lots in wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
1232: p_serials in wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
1233: p_dyn_serials in wip_serial_number_cleanup.mtl_serial_numbers_rec,
1234: p_ser_marks in wip_serial_number_cleanup.mtl_serial_numbers_mark_rec,
1235: p_retcode out nocopy number,
1236: p_app out nocopy varchar2,