[Home] [Help]
176: overcompletion_transaction_id,
177: overcompletion_transaction_qty,
178: overcompletion_primary_qty,
179: kanban_card_id
180: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
181: WHERE TRANSACTION_HEADER_ID = c_hdr_id
182: AND TRANSACTION_ACTION_ID = NVL(c_act_id, TRANSACTION_ACTION_ID);
183:
184: mtl_rec get_materials%rowtype;
372:
373: close get_materials;
374:
375: if (p_mtls.numrecs > 0) then
376: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
377: WHERE TRANSACTION_HEADER_ID = p_hdr_id
378: AND TRANSACTION_ACTION_ID = NVL(p_act_id, TRANSACTION_ACTION_ID);
379: end if;
380: end fetch_and_delete;
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
415: and transaction_action_id = nvl(c_act_id, transaction_action_id));
416:
417: lot_rec get_lots%rowtype;
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
466: and transaction_action_id = nvl(p_act_id, transaction_action_id));
467: end if;
468: end fetch_and_delete;
498: from mtl_serial_numbers_temp
499: where
500: transaction_temp_id in
501: (select transaction_temp_id
502: from mtl_material_transactions_temp
503: where transaction_header_id = c_hdr_id
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
513: and transaction_action_id = nvl(c_act_id, transaction_action_id)));
514:
515: serial_rec get_serials%rowtype;
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
564: where transaction_header_id = p_hdr_id
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
574: and transaction_action_id = nvl(p_act_id, transaction_action_id)));
575: end if;
576: end fetch_and_delete;
643: where current_status = 6
644: and group_mark_id = c_hdr_id
645: and (line_mark_id in
646: (select transaction_temp_id
647: from mtl_material_transactions_temp
648: where transaction_header_id = c_hdr_id
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
658: and transaction_action_id = nvl(c_act_id, transaction_action_id))));
659:
660: serial_rec get_serials%rowtype;
741: where current_status = 6
742: and group_mark_id = p_hdr_id
743: and (line_mark_id in
744: (select transaction_temp_id
745: from mtl_material_transactions_temp
746: where transaction_header_id = p_hdr_id
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
756: and transaction_action_id = nvl(p_act_id, transaction_action_id))));
757: end if;
758: end fetch_and_delete;
775: from mtl_serial_numbers
776: where group_mark_id = c_hdr_id
777: and (line_mark_id in
778: (select transaction_temp_id
779: from mtl_material_transactions_temp
780: where transaction_header_id = c_hdr_id
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
790: and transaction_action_id = nvl(c_act_id, transaction_action_id))));
791:
792: serial_rec get_serials%rowtype;
827: lot_line_mark_id = null
828: where group_mark_id = p_hdr_id
829: and (line_mark_id in
830: (select transaction_temp_id
831: from mtl_material_transactions_temp
832: where transaction_header_id = p_hdr_id
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
842: and transaction_action_id = nvl(p_act_id, transaction_action_id))));
843: end if;
844: end fetch_and_unmark;
887: p_mtls in mtl_transactions_temp_rec) is
888: i number := 1;
889: begin
890: while (i <= nvl(p_mtls.numrecs, 0)) loop
891: insert into mtl_material_transactions_temp (
892: TRANSACTION_HEADER_ID,
893: TRANSACTION_TEMP_ID,
894: SOURCE_CODE,
895: SOURCE_LINE_ID,