DBA Data[Home] [Help]

APPS.WIP_MTL_TXNS_TEMP_CLEANUP dependencies on WIP_SERIAL_TEMP_CLEANUP

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 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,

Line 1247: wip_serial_temp_cleanup.insert_rows(p_serials => p_serials);

1243: -- insert lot records
1244: wip_lot_temp_cleanup.insert_rows(p_lots => p_lots);
1245:
1246: -- insert serial records
1247: wip_serial_temp_cleanup.insert_rows(p_serials => p_serials);
1248:
1249: -- insert dynamic serial records
1250: wip_serial_number_cleanup.insert_rows(p_serials => p_dyn_serials);
1251: