[Home] [Help]
42:
43: select mms.status_code
44: into x_status_code
45: from mtl_material_statuses mms ,
46: MTL_SECONDARY_INVENTORIES msi
47: where mms.status_id = msi.status_id
48: and msi.SECONDARY_INVENTORY_NAME = p_sub_inv
49: and msi.organization_id = p_org_id;
50:
353: AND mmsh.group_id = p_transaction_id
354: FOR UPDATE NOWAIT;
355:
356: CURSOR cur_Subinv IS
357: select ms.rowid FROM mtl_secondary_inventories ms,
358: mtl_material_status_history mmsh
359: where ms.organization_id = mmsh.organization_id
360: and ms.secondary_inventory_name = mmsh.zone_code
361: AND mmsh.status_update_id = p_transaction_id
459: OPEN cur_Subinv;
460: FETCH cur_Subinv BULK COLLECT INTO rowid_list ;
461:
462: FORALL j in rowid_list.first .. rowid_list.last
463: update mtl_secondary_inventories
464: set status_id = p_status_id
465: , last_updated_by = FND_GLOBAL.USER_ID
466: , last_update_date = SYSDATE
467: , last_update_login = FND_GLOBAL.LOGIN_ID
791:
792: --ERES Deferred
793:
794: IF p_pending_status = 0 THEN --ERES Deferred
795: update mtl_secondary_inventories
796: set status_id = p_sub_status_id
797: , last_updated_by = FND_GLOBAL.USER_ID
798: , last_update_date = SYSDATE
799: , last_update_login = FND_GLOBAL.LOGIN_ID