APPS.WIP_MTL_TXNS_TEMP_CLEANUP dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 385: p_lots in out nocopy wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec) is

381:
382: procedure fetch_and_delete(
383: p_hdr_id in number,
384: p_act_id in number,
385: p_lots in out nocopy wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec) is
386:
387: i number := 0;
388:
389: cursor get_lots(

Line 410: from mtl_transaction_lots_temp

406: lot_expiration_date,
407: error_code,
408: serial_transaction_temp_id,
409: group_header_id
410: from mtl_transaction_lots_temp
411: where transaction_temp_id in
412: (select transaction_temp_id
413: from mtl_material_transactions_temp
414: where transaction_header_id = c_hdr_id

Line 461: delete from mtl_transaction_lots_temp

457:
458: close get_lots;
459:
460: if (p_lots.numrecs > 0) then
461: delete from mtl_transaction_lots_temp
462: where transaction_temp_id in
463: (select transaction_temp_id
464: from mtl_material_transactions_temp
465: where transaction_header_id = p_hdr_id

Line 508: from mtl_transaction_lots_temp

504: and transaction_action_id = nvl(c_act_id, transaction_action_id))
505: or
506: transaction_temp_id in
507: (select serial_transaction_temp_id
508: from mtl_transaction_lots_temp
509: where transaction_temp_id in
510: (select transaction_temp_id
511: from mtl_material_transactions_temp
512: where transaction_header_id = c_hdr_id

Line 569: from mtl_transaction_lots_temp

565: and transaction_action_id = nvl(p_act_id, transaction_action_id))
566: or
567: transaction_temp_id in
568: (select serial_transaction_temp_id
569: from mtl_transaction_lots_temp
570: where transaction_temp_id in
571: (select transaction_temp_id
572: from mtl_material_transactions_temp
573: where transaction_header_id = p_hdr_id

Line 653: from mtl_transaction_lots_temp

649: and transaction_action_id = nvl(c_act_id, transaction_action_id))
650: or
651: lot_line_mark_id in
652: (select serial_transaction_temp_id
653: from mtl_transaction_lots_temp
654: where transaction_temp_id in
655: (select transaction_temp_id
656: from mtl_material_transactions_temp
657: where transaction_header_id = c_hdr_id

Line 751: from mtl_transaction_lots_temp

747: and transaction_action_id = nvl(p_act_id, transaction_action_id))
748: or
749: lot_line_mark_id in
750: (select serial_transaction_temp_id
751: from mtl_transaction_lots_temp
752: where transaction_temp_id in
753: (select transaction_temp_id
754: from mtl_material_transactions_temp
755: where transaction_header_id = p_hdr_id

Line 785: from mtl_transaction_lots_temp

781: and transaction_action_id = nvl(c_act_id, transaction_action_id))
782: or
783: lot_line_mark_id in
784: (select serial_transaction_temp_id
785: from mtl_transaction_lots_temp
786: where transaction_temp_id in
787: (select transaction_temp_id
788: from mtl_material_transactions_temp
789: where transaction_header_id = c_hdr_id

Line 837: from mtl_transaction_lots_temp

833: and transaction_action_id = nvl(p_act_id, transaction_action_id))
834: or
835: lot_line_mark_id in
836: (select serial_transaction_temp_id
837: from mtl_transaction_lots_temp
838: where transaction_temp_id in
839: (select transaction_temp_id
840: from mtl_material_transactions_temp
841: where transaction_header_id = p_hdr_id

Line 850: p_lots in out nocopy wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,

846: procedure fetch_and_delete(
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

Line 1231: p_lots in wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,

1227: end insert_rows;
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,